Femi Oyesanya

I am a detail-oriented and results-driven Business Intelligence (BI) Developer and Data Analyst with over 8 years of experience transforming complex data into actionable insights to support strategic decision-making. Experienced at designing, developing, and maintaining end-to-end BI solutions, including data models, dashboards, reports, and ETL pipelines. Skilled in working with tools such as Power BI, Tableau, Cognos BI, SQL, Python, and Excel, with hands-on experience in data warehousing, database management, and advanced analytics.

Proven ability to collaborate cross-functionally with business and technical teams to understand requirements, automate reporting processes, and optimize data workflows. Recognized for delivering high-impact visualizations and performance metrics that drive business growth, improve operational efficiency, and support executive reporting. Passionate about data storytelling, continuous improvement, and delivering value through data-driven solutions.

Business Intelligence Developer - Ministry of Public and Business Service Delivery and Procurement (MPBSDP)

(2024-08)

Project: Business Intelligence Data Analytics (BIDA) Modernization/Migration project

• Test Planning & Execution: Developed and executed comprehensive test plans for Oral Health Reporting systems such as Healthy Smiles Ontario and the Ontario Senior Dental Care Plan (OSDCP), ensuring validation of business processes and system functionality in both on-prem and pre-production environments.
• Accessibility & Compliance Testing: Utilized tools such as NVDA, Color Contrast Analyzer, WAVE, and AXE to perform both automated, Manual and assistive Technology methodologies for accessibility testing, ensuring AODA compliance across web applications and Cognos reports.
• Cognos BI Reporting: Managed Cognos reports end-to-end—designing, developing, testing, and enhancing report presentation. Conducted AODA compliance checks, FOI audits, and verified 100% data accuracy and usability.
• Data Quality & Dashboard Testing: Conducted functional and data accuracy testing of Covid Vaccination (Covax) DQ dashboards using Cognos Data Modules, validating successful deployment in on-prem and pre-production environments.
• User Training & Support: Trained UAT testers in Jira for defect logging and tracking. Provided hands-on training to staff on navigating and using Cognos for report generation and analysis.
• Stakeholder Collaboration & Project Coordination: Coordinated cross-functional meetings with stakeholders to define project scope. Created and delivered documentation and presentations using Microsoft Word, Excel, and PowerPoint.
• Defect Management & QA Processes: Defined, reported, and managed defects in Jira, adhering to structured QA methodologies. Led application testing and validation to ensure readiness for production deployment.
• Documentation & Process Analysis: Reviewed and analyzed existing system and business documentation to gain a deep understanding of application workflows, contributing to the refinement of testing strategies.
• Project Contributions: Actively supported the Business Intelligence Data Analytics (BIDA) Modernization/Migration project through task effort estimation, and contributed to major BI initiatives including Ontario Healthcare Financial and Statistical Reporting (OHFS) and Client Profile (CPRO) projects.

Business Intelligence Analyst - Oasmack Inc. Canada

(2022-09 - 2024-08)

• Designed and developed data mappings using Informatica IDMC to extract, transform, and load data from on-premises Oracle databases to AWS Redshift target systems.
• Developed reusable mappings and transformations to ensure data consistency and accuracy between Oracle source databases and Redshift target systems.
• Developed an Enterprise Data Warehouse Bus Matrix based on core business processes to identify conformed dimensions and ensure data consistency across reporting systems.
• Collaborated in the requirements gathering, system design, and documentation phases of the QuikBuy platform to support solution delivery.
• Acted as liaison between technical teams and stakeholders to create Source-to-Target Mapping (STTM), transformation logic, and data quality documentation.
• Designed and implemented Slowly Changing Dimensions (SCD Type 2) on retail chain dimension tables using SSIS, enabling management to track historical changes in vendor data and assess impacts on delivery performance.
• Designed, developed, and deployed sales, purchasing, promotional, and employee performance dashboards and reports using SSRS, SSAS, Power BI, and Excel Power Pivot with DAX and calculated KPIs.
• Applied dimensional data modeling techniques (Star Schema) and used Tableau to analyze time-based product demand, providing actionable insights for inventory and sales optimization.
• Built interactive business dashboards to perform trend analysis on key retail metrics such as revenue growth, customer retention, and employee productivity using Power BI and DAX.

Data and Reporting Analyst - Adrian April Consult Ontario

(2016-07 - 2022-08)

• Built compelling Power BI and Tableau dashboards to track business performance resulting in the adoption and ensuring a timely flow of critical information.
• Generated monthly profit and loss validation reports, and other ad hoc reports for management using SQL and SSRS, enabling real-time performance monitoring, and ensuring business targets were met.
• Utilized Microsoft Excel to evaluate a policy's financial performance on a weekly basis by analyzing actual results.
• Extracted, manipulated, and analyzed data using advanced Microsoft excel knowledge (using pivot tables, Lookup functions.) to give ad-hoc monthly reports to present strategic business decisions.
• Created and maintained interactive data visualization through data interpretation and analyses, integrating various reporting components from multiple data sources.
• Developed balanced scorecards and key performance indicators (KPIs) to measure and improve organizational performance in alignment with strategic objectives.
• Presented complex data analysis to diverse audiences through written reports, charts, and infographics.
• Collaborated with data engineering team members on data cleaning projects utilizing Pandas and Numpy libraries. Implemented robust data governance practices leading to a 20% increase in data quality across all bank domains.

Diploma - Computer Programming - Algonquin College, Ottawa

Bachelor of Science (B.Sc.) - Economics - University of Lagos