Ayodeji Ogbonnaiye

 AYODEJI OGBONNAIYE Mobile:(- | Email:-Location: Dagenham, RM9 5XT | LinkedIn: https://www.linkedin.com/in/ayodeji-ogbonnaiye/ PROFESSIONAL SUMMARY Results-driven Data Analyst with over 10 years of experience in technology and reconciliation and. Proven expertise in transactional reconciliations, enhancing operational efficiency, and collaborating with cross-functional teams to drive process improvements. Adept at utilizing advanced reconciliation systems and Excel to implement data-driven solutions. Strong stakeholder management and problem-solving skills, with a focus on delivering strategic outcomes in investment management. Open to work and currently seeking a challenging role as a Reconciliations Executive.. SKILLS Reconciliation Systems, Transactional Reconciliation, Oracle, MS SQL Server Finacle, Flexcube , Json Data Analysis, Data Engineering, Data Warehousing SAP Business Objects, Banking Advanced Excel (Macros, VBA, Pivot Tables) Stakeholder Management Process Improvement & Target Operating Models Data Management & Data Analysis Financial Operations & Compliance Problem-Solving & Decision Makingg SQL (DDL, DML, DCL, TCL, DQL), SQL Training Dashboard, Data Visualization – Power BI, Tableau PL/SQL, T-SQL,Dax, Power Query, Data Modelling Agile Methodologies (Scrum) CERTIFICATIONS Certified Scrum Master ITIL Foundation Personal Project(s) ENTERPRISE DATA WAREHOUSE – SQL SERVER This project involved consolidating data from various data sources, enabling comprehensive analysis, reporting and informed decision-making across the entire organization. Achievement: I achieved centralized data management, improved data accessibility, and enhanced reporting capabilities. This facilitated comprehensive, real-time business insights, streamlined decision-making processes, and supported scalable data integration across multiple departments, leading to more informed strategic decisions and operational efficiency. Technologies employed: SQL Server Integration Services (SSIS) for ETL (Extract, Transform, Load) processes to gather and integrate data from various sources Power BI for developing dashboards. SQL Server Management Studio (SSMS) for database management and administration. T-SQL (Transact-SQL) for writing complex queries, stored procedures, and scripts to manage data and automate tasks. Education University Of Ilorin (2008 – 2011) BSc. Statistics (Honors) Employment History Business Intelligence Manager / Data Governance Manager – Ikeja ElectricJul 2021 - Present Lead a team of 5 Data/BI engineers, fostering a culture of innovation and excellence in delivering high-quality data solutions, with a focus on using SQL for efficient data querying and management. Spearhead the strategic direction of the company's data initiatives, leveraging PowerBI to develop dynamic dashboards and visualizations that align BI solutions with business goals to drive growth. Define and champion the company’s data strategy, employing Python for advanced analytics and predictive modeling, ensuring seamless integration with broader business objectives. Establish and enforce data governance frameworks, maintaining the highest standards of data integrity, security, and compliance through meticulous SQL scripting and database management. Collaborated with business users to capture and define user information requirements. Senior Data Analyst – Rubies Technologies, Birmingham UKJul 2021 - Present Developed and maintained BI solutions to support business decision-making processes. Analyzed large datasets to identify data quality issues, implemented solutions to enhance the consistency and integrity of data, and created metrics to monitor improvements. Worked closely with various teams to define data quality requirements and standards based on business needs, and developed frameworks for ongoing data management. Implemented data quality monitoring tools and procedures, significantly improving the accuracy of customer and transaction data. Utilized PowerBI and Tableau to create and manage interactive dashboards, enhancing reporting capabilities and decision-making processes. Team Lead, Data Management, Group Reconciliation Unit – FirstbankMar 2019 - Jun 2021 Architect and oversee the implementation of enterprise-level data warehouses, utilizing SQL for data structuring and R for statistical analysis, ensuring scalability and efficiency in data processing. Conduct daily, weekly, and monthly reconciliations of financial transactions and account balances, ensuring accuracy and timeliness. Utilized advanced Excel techniques (macros, VBA) to create customized reports and automate routine reconciliation tasks, saving time and improving accuracy Recommend and implement technology solutions that improve reconciliation accuracy and streamline operations. Ensure compliance with industry standards and internal policies by regularly reviewing reconciliation processes and documentation. Develop and implement a new target operating model for reconciliations, enhancing workflow efficiency and minimizing discrepancies Developed a training program for junior analysts on reconciliation best practices and Excel techniques Led the successful transition to a new reconciliation system, reducing manual reconciliation efforts by 40% Senior Business Intelligence Engineer / Team Lead, MIS Reporting – EcobankDec 2014 - Feb 2019 Developed and maintained BI solutions to support business decision-making processes. Designed and implemented dashboards and reports using Power BI and SQL Server Reporting Services (SSRS). Design and optimize complex ETL processes using SQL and SSIS, ensuring efficient data extraction, transformation, and loading to support the data warehouse and reporting needs. Develop predictive models and advanced analytics workflows with R, translating raw data into actionable insights that drive business strategies and performance improvements. Managed ETL processes with SQL Server Integration Services (SSIS) to ensure accurate and timely data integration from multiple sources. Optimized SQL queries and database performance, reducing report generation time by 20%. Provided training and support to end-users on BI tools and data interpretation, enhancing data literacy within the organization