Femi Olaniyan

Experience

• 

  Mercer

  Feb 2013 - Nov 2019

  ▪ Operations Management (Data Support Team)o Completed scope and pricing analysis of Data based Change Order requestso Serve as a subject matter expert on all data related inquires o Assist with staff forecasting and capacity planning for Data Teamo Manage day to day operations for all data team projects and deliverables ▪ Data System Integrity and Managemento Review client requirements and perform gap and/or impact analysis to develop data architecture needed to fulfill client needs o Design and recommend database structures based on data storage and reporting needso Responsible for ensuring the integrity of client data/data structure to optimize business process functionalityo Built advanced solutions leveraging existing data systems to reduce company utilization costs while executing on client requirementso Liaise with key stakeholders to track the changing data needs of the client and adjust the delivery plan accordingly Show less ▪ Reporting and Business Intelligence Integrityo Develop automated business reports using SQL and Visual basic technologies to retrieve data from SQL Server Database and summarize data intelligently (using charts, dashboard, pivot tables…Etc.) to facilitate informed business decisions.o Determine data strategies to identify high risk audit populations to mitigate future issues▪ Key Achievements: Examples of corporate initiatives completed:★ Lead Data Manager for two Voluntary Correction Plan (VCP) projects which generated multi-million dollars in revenue for the firm.★ Create automated processes to reduce the time it took to execute existing process by 75%.This procedure was incorporated in future projects and reduced client escalations due to errors and omissions, thus saving the company money.★ Defined Benefit Data Strategy★ Plan Freezes★ Defined Benefit Plan Termination★ Mergers/Acquisitions★ Data Correction/Auditing Tool Updates and Enhancement Show less

  • Implementation Services Data Team Manager

    Nov 2014 - Nov 2019

  • Lead Data Architect

    Feb 2013 - Nov 2014
• 

  Morneau Shepell

  Sept 2019 - Nov 2019

  Implementation Services Data Team Manager

  Lead a group of talented individuals to support, design, execute on our clients data needs using SDLC methodologies. • Specializing in actionable reporting using business intelligence tools• Designing flexible data warehouses to integrate with clients data flows to ensure optimum data relational integrity and normalization• Passionate about process improvement; leveraging existing data systems to reduce company utilization by removing non-value added steps in processes or converting manual steps into automated or semi-automated steps VBA/SQL/Python to reduce costly errors and omissions.• Expert in writing and performance/tuning/debugging advanced SQL queries Show less

• 

  Willis Towers Watson

  Nov 2019 - Apr 2022

  Pension Data Implementations of large and complex data sets; Client Data Support; Data Reporting and solutions

  • Data Client Lead

    Jan 2021 - Apr 2022

  • Senior Business Analyst

    Nov 2019 - Dec 2020
• 

  Ally

  Apr 2022 - now

  Responsible for contributing to the directional data strategy of critical business process and in the management, creation and modification of data architecture with the sole effect of providing effecient and scalable data analytics solutions.

  • Principal - Data Analytics/Management

    May 2024 - now

  • Sr Analyst - Data Management

    Apr 2022 - May 2024