Olutola Sokunbi Email & Phone Number

Canada

Canada

Ontario, Canada

• Developed and built Key Performance Indicators to monitor various processes in the businessincluding reports for internal and external stakeholders.• Facilitated extensive testing and User Acceptance Tests (UAT) for reporting solutions developed.• Performed extensive data analysis using multiple tools including data visualization, storage andanalysis tools such as Ruby, R, Power BI, Tableau, PostgreSQL and Microsoft Excel.• Automated periodic reports provided to stakeholders as well as prepared ad-hoc reports.• Designed the Business Catalog to provide a single source of truth for reporting needs.• Organized and facilitated workshops to define analytics and reporting needs. Managed theplanning and execution of the selected analytics projects.• Developed complex SQL queries to aid the extraction, transformation and loading of data frommultiple sources in order to draw insights and aid data-driven decision making.• Identified data quality issues and perform root cause analysis to identify the source and resolve thefindings.

• Led the team that implemented a Corporate Analytics Solution for a Conglomerate which entailedPurchase to pay, General Ledger and Income Assurance. I was responsible for interacting withproject managers, business process owners, application owners and business analyst forrequirements gathering, thereby managing team deliverables to ensure timelines are met. Ideveloped and built the solution consolidating data from disparate, unconnected sources. Thisreduced the Group's reporting time from 2 weeks to less than a day.• Aggregated data from multiple sources and connected them to the dashboard solutions to enabledaily or weekly refreshes as required.• Developed complex queries, implemented drill through functionalities as well as filters andpublished dashboard solutions to enable access across web and mobile applications.• Designed data governance framework for clients including data stewards as well as their roles andresponsibilities.• Implemented Azure data factory gateways and Power BI gateway to extract data from thedatabases of different ERPs sitting on different networks.• Organised and executed training events for clients on the use of business intelligence solutionssuch as Power BI, Qlik, statistical and other tools such as R, Python, and Azure.• Developed reports, PowerPoint slides and presented results of models developed and analysiscarried out to both relevant technical and non-technical stakeholders.• Led a team that performed Quality Assurance and project management on an SAP implementationproject for an Energy Company. This entailed understanding of the front and back end of the ERPand enabled its successful implementation.• Led a team that performed data cleansing of a client’s inventory items using Data Cleaner andPower BI. This enabled the client accurately report its inventory in their financial statements inaccordance with regulatory requirements.

• Developed and built management dashboards for companies across different sectors such as FastMoving Consumer Goods Companies, Financial Institutions, Oil and Gas firms among others usingPower BI, Tableau, QlikView and Qlik Sense with data gotten from the database (for instance, SQL)of different ERPs such as SAP, Sage and Microsoft Dynamics AX 2012 so that the information gottencan be used to influence strategies and business decisions.• Developed and built Key Performance Indicators to monitor various areas in a client’s business suchas revenue, purchase-to-pay and order-to-cash cycle so as to ensure sound control is in place tosupport business growth.• Carried out exploratory data analysis using R, SQL and Python and developed scripts to clean upand transform data for use in data analysis.• Developed SQL scripts to create views, procedures, functions, query and extract data from variousdatabases such as Oracle and MySQL.• Developed the cutover script and managed the data mapping process as part of a team thatworked on a Data Migration project for a client.• Managed the User Acceptance (UAT) process and worked with a team that handled the projectmanagement and quality assurance for a revenue assurance and fraud management softwaredeployment in a major telecommunication company.• Created finance analytics dashboards that give daily updates of a client’s financial position.