Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

Francoise Elis Mbazoa Okala

Washington,DC

Summary

Dynamic Power BI Developer and Data Analyst with 10+ years of experience translating complex datasets into actionable insights that drive business performance. Proven track record of analyzing over 1 million data points to deliver strategic solutions, resulting in a 20% boost in operational efficiency across key client engagements. Highly proficient in advanced analytics, statistical modeling, and interactive data visualization using SQL, Python, R, Tableau, and Power BI. Delivered more than 200 high-impact reports that informed critical business decisions and generated an average performance uplift of 15%. Recognized for distilling intricate data into compelling visual narratives, fostering cross-functional collaboration, and upholding the highest standards of data accuracy and integrity

Overview

11
11
years of professional experience
1
1
Certification

Work History

Lead Power BI developer

Emory Healthcare
07.2021 - Current
  • Collaborate with team members to gather requirements and design effective and visually appealing visualizations.
  • Create and model datasets from SQL Server, Azure Data Lake, Excel, CSV, JSON, and other sources.
  • Clean data using Power Query and M. Develop and maintain Power BI reports, dashboards, and apps.
  • Maintain data, refresh schedules of published datasets.
  • Monitor and evaluate the performance and availability of Power BI solutions.
  • Leverage Power BI, DAX, and SQL to construct dynamic dashboards displaying key business metrics, increasing decision-making efficiency by 35%.
  • Engineer and automate report generation system with Python, saving over 10 hours per week in manual data processing. Implement quality checks for data accuracy, reducing data inconsistencies by 40%.
  • Spearhead a project to migrate old reports to Power BI, improving data visualization and accessibility.
  • Redesign ETL processes using SSIS and SQL, enhancing data loading speed by 50%.
  • Translating business goals into technical specifications.
  • Creating interactive visual reports using Power BI.
  • Finding correlations in data to discover meaningful insights.
  • Identifying key performance indicators (KPI) to help companies adjust and fulfill objectives.
  • Write M queries in Power Query to transform the data.
  • Write SQL queries, stored procedures, views, functions based on the requirements.
  • Build SSRS reports, maintain the existing reports and publish them to the report server.
  • Create designs for dashboards based on client requirements.
  • Develop formulas for reports in Data Analysis Expression (DAX) language.
  • Analyze, design, develop, test, debug, implement, maintain and/or enhance existing or new systems that are reliable and efficient.
  • Work with a great team of professionals and always willing to learn the latest technologies and approaches.

Power BI Analyst

Amazon
03.2018 - 06.2021
  • Developed visual reports, KPI scorecards, and dashboards using Power BI desktop.
  • Connecting data sources, importing data, and transforming data for Business intelligence.
  • Translating data into informative reports and visuals.
  • Implemented row-level security on data along with an understanding of application security layer models in Power BI.
  • Expert in using advanced-level calculations on the data set and responsible for design methodology and project documentaries.
  • Developed tabular and multidimensional models that are compatible with data warehouse standards.
  • Worked in Agile Scrum Methodology with daily stand-up meetings, great knowledge working with Visual SourceSafe for Visual studio 2010 and tracking projects using JIRA.
  • Involved in upgrading the databases and servers of SQL Server 2008R2 to SQL Server 2012.
  • Design and implementation of Security Model, policies and procedures.
  • Query Optimization using Query Analyzer, Profiler, Show plan, Index Tuning and Stats Time Tool.
  • Created Snapshot Replication for the Development and Testing Databases across different Servers.

Reporting Analyst

Allied Universal Security
05.2017 - 02.2019
  • Built reports for new and existing customer accounts, analyzing data from various technical and specialized sources to include performance metrics and ad hoc information requests that foster customer satisfaction.
  • Analyzed and made recommendations for current reports and reporting processes to be streamlined.
  • Streamlined existing reports and create new reports using PeopleSoft, Microsoft Access Excel as well as the visual basic for applications programming language.
  • Ran the weekly reports with regards to consultant new starts using PeopleSoft Microsoft Excel.
  • Troubleshoot and fixed both weekly and monthly reports that encounter errors using Microsoft Access excel to promote smooth reporting practices.
  • Created the reports using ETL of data from travel vendors using SQL/Excel to produce daily, weekly and monthly reports.
  • Acquired data from primary data sources and maintained databases and data systems.
  • Identified, analyzed and interpreted the trends or patterns in complex data sets.

Data and Sales Analyst

Infosys Limited
09.2014 - 04.2017
  • Regular responsibilities for updating staging and dimensional databases as well as rebuilding the dimensions and cubes on Analysis Services (SSAS).
  • Cleaned data using Power Query and M.
  • Developed and maintained Power BI reports, dashboards, and apps.
  • Maintained data refresh schedules of published datasets.
  • Authored and published Power BI reports by Analyzing sales and data performance on new and existing products/technology.
  • Coordinated extraction of SQL Server data to Power BI and configure data connections.
  • Performed troubleshooting and analysis of Power BI reports produced by other developers.
  • Worked closely with data team to analyze data models for procurement of business data.
  • Created reports using ETL of data from travel vendors using SQL/Excel to produce daily, weekly and monthly reports.

Education

Associate of Science - Health Sciences

University of Yaounde2
Yaounde, Cameroon
06-2008

Skills

    Statistical Analysis: Hypothesis Testing, Regression Analysis, A/B Testing, Time Series Analysis, Statistical Modeling

    Data Analysis & Visualization

  • Proficient in SQL, Excel, Power BI, Tableau, and Python (Pandas, Matplotlib, Seaborn)
  • Expertise in data modeling, transformation, and dashboard development
  • Skilled in DAX and Power Query for interactive reporting
  • Skilled in JavaSript(D3js, Plotly), Excel (Advanced Charts), Google Data Studio,SAP BW , QlikView, SAS BI, SSIS, SSRS, SSAS

    • Business Intelligence & Reporting

  • Experienced in building and deploying reports via Power BI Service
  • Integration with APIs, Azure, and cloud data sources
  • Strong grasp of KPIs, metrics, and data storytelling

    • Requirements Gathering & Stakeholder Collaboration

  • Adept at business process modeling and documentation (Visio, BPMN)
  • Skilled in eliciting, analyzing, and translating business requirements
  • Effective communicator across technical and non-technical teams

    • Web Development & Engineering

  • Front-end: HTML5, CSS3, JavaScript, Reactjs, Bootstrap
  • Back-end: Nodejs, Python (Flask/Django), RESTful APIs
  • Database: MySQL, PostgreSQL, MongoDB
  • Version Control: Git, GitHub
  • Responsive Design & Cross-Browser Compatibility
  • Familiar with CI/CD pipelines, cloud platforms (AWS, Azure), and deployment tools

    • Analytical Thinking & Problem Solving

  • Detail-oriented with strong critical thinking and troubleshooting skills
  • Comfortable analyzing trends, identifying insights, and making data-driven decisions
  • Familiar with Agile methodologies and iterative development workflows

    • Technical Tools & Platforms

  • Power BI, Excel, SQL Server, Python, R
  • Microsoft 365, Azure, SharePoint, Git
  • VS Code, Postman, Docker (basic), Figma (basic)

    • Data Management & Databases: MySQL, PostgreSQL, MongoDB, Oracle, NoSQL, Data Warehousing,Hadoop

    Collaboration & PM Tools: Trello, Slack, JIRA, Confluence, Asana, Microsoft Teams, GitHub

    Cloud Platforms: AWS, Google Cloud, Microsoft Azure, BigQuery, Snowflake, Redshift

    Automation & Scripting: Python (Pandas, NumPy), SQL (Stored Procedures), Shell Scripting, Apache Airflow, Bash,

    Jenkins

Certification

Data Analytics Certificate ( George Washington University)

CS50’S Web programming with Python and JavaScript. ( EDX Learning Platform)

Front -End Web Developer ( EDX Learning platform)

Languages

French
Native or Bilingual
English
Native or Bilingual
Italian
Limited Working

Timeline

Lead Power BI developer

Emory Healthcare
07.2021 - Current

Power BI Analyst

Amazon
03.2018 - 06.2021

Reporting Analyst

Allied Universal Security
05.2017 - 02.2019

Data and Sales Analyst

Infosys Limited
09.2014 - 04.2017

Associate of Science - Health Sciences

University of Yaounde2

Similar Profiles

CREATE PROFILE