Power Bi Business Intelligence

BRENDA AKINYI OONGO

Power BI Developer Business Intelligence Specialist

Cell: +254-***-******/254-***-******; Email: ***********@*****.***

PROFESSIONAL PROFILE

Results-driven Power BI Developer with 7+ years of experience in business intelligence (BI), data modeling, and dashboard development. Expertise in transforming raw data into interactive and insightful dashboards to support data-driven decision-making. Proficient in Power BI, DAX, Power Query, and SQL for data extraction, transformation, and visualization. Adept at optimizing data models, ensuring performance efficiency, and integrating multiple data sources for enterprise-wide reporting. Passionate about leveraging BI solutions to drive business success.

CORE COMPETENCE

Power BI Development – Interactive dashboards, custom visuals

DAX & Power Query – Measures, calculated columns, performance tuning

Data Modeling – Star schema, relational models, OLAP cubes

SQL & Data Extraction – SQL Server, Snowflake, BigQuery

ETL & Data Transformation – Data pipelines, integration, cleansing

Data Visualization – Storytelling with data, KPI tracking

Performance Optimization – Data compression, indexing strategies

Business Intelligence & Analytics – Insights generation, reporting

Stakeholder Collaboration – Gathering requirements, technical documentation

PROFESSIONAL EXPERIENCE

Senior Power BI Developer

I&M Bank — April 2022 – Present

Designed and developed interactive Power BI dashboards that improved executive visibility into financial KPIs and customer trends.

Created complex DAX measures for advanced calculations, improving reporting accuracy and efficiency.

Managed ETL pipelines, integrating data from multiple sources (SQL Server, Snowflake) for seamless reporting.

Optimized data models to enhance Power BI performance, reducing report loading times by 30%.

Partnered with stakeholders across marketing, finance, and operations to deliver data-driven insights for strategic decision-making.

Key Achievements and Projects

Automated reporting processes, reducing manual data processing efforts by 40%.

Developed a customer segmentation dashboard, improving targeted marketing efforts and increasing engagement by 20%.

Data Analyst

Kenya National Highway Authority (KeNHA) — Sept 2019 – Dec 2021

Spearheaded the creation of dynamic Tableau dashboards to monitor infrastructure projects, enabling real-time visibility into project performance.

Conducted cluster analysis and visualized insights to support infrastructure investment decisions, optimizing resource allocation.

Automated monthly reporting processes with Python scripts, enhancing efficiency and ensuring timely data delivery to stakeholders.

Partnered with engineering and finance teams to integrate predictive models into planning processes, visualizing outcomes and risk factors.

Key Achievements & Projects

Reduced report generation time by 40% through automation and standardized visualization templates.

Improved stakeholder engagement with data by 25% by introducing compelling, intuitive visual analytics.

Monitoring & Evaluation Intern

AMREF Kenya — June 2019 – August 2019

Assisted in developing data-driven reports to support healthcare initiatives, focusing on predictive analytics and trend analysis for program outcomes.

Collaborated with program managers to integrate data insights into project planning, ensuring alignment with goals and objectives.

Used Excel and Power BI to create visual representations of data, highlighting key performance indicators and trends.

EDUCATION

Master of Science (Strategic Management)

Jomo Kenyatta University of Agriculture and Technology

Bachelor of Science (Statistics)

Jomo Kenyatta University of Agriculture and Technology

ADDITIONAL TRAINING&CERTIFICATION

Business Analytics & Data Science (Predictive Analysis Lab, 2022)

Data Science (MySQL, R, Advanced Excel - Africa Centre for Women, ICT, 2021)

TECHNICAL SKILLS

Business Intelligence Tools: Power BI, Tableau, Looker

DAX & Power Query: Advanced calculations, performance tuning

SQL & Data Management: SQL Server, Snowflake, BigQuery, PostgreSQL

ETL & Data Transformation: Alteryx, SSIS, dbt, Python Pandas

Cloud Platforms: Azure Synapse, AWS Redshift, Google BigQuery

Data Visualization: Storytelling, KPI tracking, dashboard design

PROJECTS & LEADERSHIP

Sales & Revenue Dashboard: Built a Power BI sales dashboard that improved revenue forecasting by 20%.

Operational Efficiency Reports: Developed interactive reports that optimized business workflows, reducing bottlenecks by 25%.

Self-Service BI Training: Led Power BI training sessions, empowering non-technical users to create their own reports.

Contact this candidate