Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Oluwatosin Awobokun

Airdrie,Canada

Summary

Experienced and results-driven Power BI Developer with over 4 years of expertise in designing, implementing, and optimizing business intelligence solutions. Specialized in advanced DAX (Data Analysis Expressions) and M code (Power Query Formula Language) to create insightful visualizations and complex data models. Skilled in integrating data from various sources, including databases, APIs, and flat files, ensuring that decision-makers have access to accurate and actionable data. Proficient in performance optimization of reports and dashboards, making data exploration intuitive and efficient for users. Strong collaborative skills and the ability to translate business requirements into technical solutions to support organizational goals.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Business Intelligence Developer

STARS Air Ambulance
09.2021 - Current
  • Developed and maintained comprehensive Power BI reports, dashboards, and KPI scorecards, ensuring they delivered actionable insights to executive teams and department heads.
    • Enhanced Data Warehouse ETL processes using SSIS and Azure Data Factory, improving data integration and availability across the organization.
    • Automated reporting processes using Power Automate and PowerShell, increasing efficiency and reducing manual intervention by 30%.
    • Worked directly with key stakeholders to understand business needs, translate requirements into technical specifications, and deliver high-quality reporting solutions.
    • Developed ad-hoc SQL queries, stored procedures, and scripts to validate data, troubleshoot issues, and perform complex data analysis.
    • Provided technical support and troubleshooting for existing reports and databases, ensuring smooth and uninterrupted operations.
  • Collaborated with cross-functional teams to gather relevant data, ensuring comprehensive and accurate reports.
  • Streamlined report generation process for increased efficiency and faster turnaround times.
  • Established effective communication channels between departments for seamless information exchange during the reporting process.
  • Improved overall efficiency by automating manual reporting tasks through the development of dynamic BI tools.
  • Mentored junior team members on best practices in business intelligence development, fostering a culture of continuous learning and improvement.
  • Optimized data processing for faster insights by designing efficient ETL processes and data models.

Business Intelligence Analyst

RIFCO National Auto Finance
06.2018 - 09.2021
  • Designed and implemented advanced data models in Power BI and Azure Analysis Services, enhancing the accuracy and depth of financial and operational reporting.
  • Created and automated real-time performance and management reports using Power BI, SSRS, and Looker, enabling department heads to track KPIs and performance metrics with precision.
  • Led the integration of data from multiple sources, including on-prem and cloud databases, using SSIS and Azure Data Factory, optimizing ETL pipelines and ensuring seamless data flow.
  • Standardized best practices in report generation across departments to ensure consistency in presentation formats as well as analysis methodologies employed.
  • Reduced manual data entry errors by automating routine tasks using SQL scripts and ETL tools.
  • Collected data from wide-ranging sources.
  • Enhanced team productivity by developing standardized templates for data analysis and reporting.
  • Identified areas for operational improvement and implemented automation solutions using Power Apps and PowerShell, resulting in a 20% reduction in reporting errors.
  • Optimized Power BI dashboards for performance, significantly improving load times and user interactivity.

Education

B.Sc. Computer Science -

Olabisi Onabanjo University
06.2010

Skills

  • Data Modeling: Power BI, DAX, M Code, SSAS, Azure Analysis Services
  • Data Integration and ETL: SQL, SSIS, Azure Data Factory, Power Query
  • Business Intelligence Tools: Power BI Desktop, Power BI Service, SSRS, Looker
  • Data Warehousing: Design, development, and optimization of data models
  • Automation and Optimization: PowerShell, Power Automate, Power Apps, Git
  • Cloud Platforms: Azure
  • Collaboration and Communication: Strong ability to collaborate with business stakeholders and translate complex technical concepts into understandable terms for non-technical users

Certification

  • Microsoft Certified Power BI Analyst
  • Microsoft Certified Data Analyst
  • Microsoft Certified Solutions Expert (MCSE) in Data Management & Analytics
  • Microsoft Certified Solutions Associate (MCSA) – BI Reporting
  • Microsoft Certified Professional – SQL

Timeline

Business Intelligence Developer

STARS Air Ambulance
09.2021 - Current

Business Intelligence Analyst

RIFCO National Auto Finance
06.2018 - 09.2021

B.Sc. Computer Science -

Olabisi Onabanjo University

Similar Profiles

CREATE PROFILE
Oluwatosin Awobokun