Jan 2020 - May 2023 Business Intelligence Analyst (Power BI Developer)
The Federal Polytechnic, Nigeria
- Developed interactive dashboards, reports, and visualizations using Power BI Desktop and Power BI Service to provide actionable insights to stakeholders.
- Delivered projects within allocated timelines and budget constraints, achieving a 90% on-time project completion rate.
- Collaborated with business users to gather requirements, understand data sources, and design efficient data models for Power BI solutions.
- Utilized Power Query and M Query to extract, transform, and load data from various sources, including relational databases, Excel files, and APIs.
- Streamlined the ETL process, leading to a 20% improvement in data loading efficiency.
- Implemented complex calculations and business logic using DAX (Data Analysis Expressions) to support advanced analytics and KPI tracking.
- Created and managed data refresh schedules, gateways, and security settings in Power BI Service.
- Implemented a financial reporting solution that reduced the reporting cycle time by 30%.
- Conducted performance tuning and optimization of Power BI reports and dashboards to enhance responsiveness and user experience.
- Provided training and support to end-users, empowering them to leverage Power BI's self-service capabilities.
- Collaborated with the development team to integrate Power BI reports into web applications and portals
Jan 2016 - Dec 2019 Junior Power BI Developer The Federal Polytechnic, Nigeria
- Designed and developed Power BI solutions for multiple clients, spanning various industries, including finance, healthcare, and manufacturing.
- Developed a sales performance dashboard that resulted in a 15% increase in sales productivity.
- Conducted workshops and requirements gathering sessions with clients to understand their data analysis needs and translate them into actionable reports and dashboards.
- Built complex data models using Power BI Desktop, incorporating multiple data sources and relationships to enable comprehensive data exploration.
- Implemented row-level security and data access controls to ensure data confidentiality and compliance with regulatory requirements.
- Created automated ETL processes using Power Query to cleanse and transform raw data before loading it into Power BI.
- Developed custom visuals and templates to meet specific client requirements and enhance data visualization capabilities.
Collaborated with cross-functional teams, including data engineers and business analysts, to ensure data accuracy and alignment with business objectives
