Senior Power BI Developer with 9+ Years BI Expertise
Resume:
HARRISON FONCHA
****************@*****.***
www.linkedin.com/in/harrison-foncha
SUMMARY OF QUALIFICATIONS
Dynamic and results-driven Senior Power BI Developer with 9+ years of experience delivering scalable business intelligence and analytics solutions across financial, healthcare, and technology sectors. Expert in Looker, Power BI, SQL, Azure Data Factory, and SharePoint integration, with strong hands-on experience in data modeling, ETL development, DAX optimization, and process automation. Proven ability to translate business needs into powerful, data-driven insights while maintaining performance, governance, and security standards.
PROFESSIONAL EXPERIENCE
Bethpage Federal Credit Union
Senior Power Bi Developer 03/2022 to 01/2026
●Developed interactive and visually appealing dashboards and reports using Power BI Desktop, incorporating various data sources, such as snowflakes, SharePoint, Workday, Excel, Azure Data Factory, and SQL Server.
●Implemented Row-Level Security (RLS) and role-based access controls in Looker to ensure data governance and compliance.
●Implemented complex data transformations and modeling using DAX and Power Query for optimal report performance.
●Used Power Query to automate data extraction and transformation processes, reducing manual data entry efforts.
●Created complex TSQL queries, stored procedures, and views to support data analysis and reporting needs.
●Executed complex TSQL queries to extract, transform, and analyze large datasets, ensuring optimal database performance.
●Collaborated with stakeholders to gather and analyze report requirements, ensuring solutions met business needs.
●Migrated legacy SAS and Tableau reports to Power BI using SQL-based data models, improving accuracy and consistency across departments.
●Implemented query folding techniques in Power Query to push transformations back to the source system, improving refresh efficiency and reducing load on Power BI.
●Participated in Scrum ceremonies (sprint planning, daily stand-ups, demos, retrospectives), ensuring stakeholder alignment.
●Collaborated with QA teams to test and validate reports against financial data sources (ERP, Snowflake).
●Optimized Power BI reports with enhanced features like dynamic visuals, drill-through capabilities, and improved data refresh schedules to meet business needs.
●Utilized Excel for data manipulation, including Pivot Tables, VLOOKUPs, and complex formulas, resulting in streamlined reporting processes.
●Developed and maintained documentation for data wrangling processes and procedures.
●Utilized scripting languages (Python, R) and data wrangling tools (e.g., Pandas) to automate data processing tasks.
●Developed ETL processes to extract, transform, and load data into data lakes and data warehouses, ensuring high data quality and integrity.
●Developed and maintained robust data pipelines using SSIS to automate ETL processes, integrating data from various sources.
Cystic Fibrosis Foundation
Senior Power BI Developer 04/2018 to 12/2021
●Implemented Power BI solutions for various departments, resulting in improved data visibility and decision-making.
● Automated workflows between SAS and Power BI, leveraging SQL and ETL processes for seamless integration.
●Conducted performance tuning of Power BI reports and datasets, improving load times and user experience.
●Built complex stored procedures and automated data-loading using SSIS
●Integrated enterprise data warehouses and data marts to support extensive financial, operational, and business analysis, providing stakeholders with meaningful insights for data-driven decision-making.
●Conducted performance tuning on both new and existing data models by optimizing DAX calculations, query folding, and indexing strategies.
●Implemented best practices for data modeling and DAX coding to enhance report performance.
●Implemented complex data transformations and modeling using DAX and M Query for optimal report performance.
●Integrated APIs into Power BI to pull real-time data from external systems, providing up-to-date insights for stakeholders across various departments.
●Conducted user training sessions and created documentation to enhance user adoption and proficiency with SharePoint tools.
●Developed and maintained complex data transformation processes using Power Query and M Language to extract, clean, and transform raw data from various sources.
●Designed and implemented data models to support analytical reporting and business intelligence initiatives.
●Knowledge of data governance best practices and ensuring data accuracy, consistency, and security
●Demonstrated expertise in handling sensitive health information while maintaining strict adherence to HIPAA guidelines
Cameroon Technology (CAMTECH)
BI Developer / Data Engineer 09/2016 to 01/2018
●Led the design, development, and deployment of over 50 Power BI and Tableau dashboards for various departments, improving decision-making processes by 30%.
●Collaborated with stakeholders to gather requirements and translate business needs into technical specifications.
●Created complex DAX measures to implement advanced calculations and KPIs, enhancing the reporting capabilities.
●Developed automated data refresh processes using Power Query and Power BI dataflows, reducing manual effort by 40%.
●Developed interactive dashboards and reports in Power BI and Tableau, providing insights into key business metrics.
●Utilized SQL to query large datasets and create complex joins, optimizing data retrieval times by 20%.
●Optimized OBIEE performance by tuning queries and implementing aggregate tables, reducing report load times by up to 40%.
●Collaborated with stakeholders to gather reporting requirements, translating them into OBIEE solutions that improved visibility into key business metrics.
●Implemented data validation and cleansing procedures to ensure accuracy and reliability of reports.
●Played a key role in optimizing SQL queries, improving overall database performance.
●Developed and maintained reports and visualizations to support various business units.
●Designed and developed interactive Power BI dashboards to visualize key business metrics.
●Implemented robust data models using DAX and Power Query, ensuring data accuracy and consistency.
●Worked closely with end-users to understand their reporting needs and deliver tailored solutions.
●Managed ETL processes to integrate data from multiple sources into a centralized data warehouse.
●Participated in Agile sprints, contributing to the continuous improvement of BI solutions.
EDUCATION
Bachelor of Science: Computer Science 09/2014
University of Bamenda, Cameroon
CERTIFICATION
●Microsoft Certified: Power BI Data Analyst Associate
TECHNICAL SKILLS
Operating Systems
Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64), Unix
Databases
MS SQL Server, Postgre SQL T-SQL MySQL 5.2, 5.7, Oracle 9i, 10g, 11g, DB2, Azure, Agile, Jira, workday,
Version Control
Git, GitHub
ETL/Other Tools
SAS Base 9.x, SAS Enterprise Guide, SSIS (Visual Studio), Erwin Data Modeler, ER Assistant, MS Office Suite, Qualtrics
Querying Tools
SQL Management Studio 2008/2012, SQL Plus, SQL Developer, PL/SQL
Querying language
SQL, PL/SQL, TSQL, Toad
Business Intelligence Tools
Tableau, MicroStrategy, Excel, Power Automate, Powerapps and PowerPivot, PowerBI, QlikView, SSRS, SSAS, SSIS, Crystal Report, Python, AWS Aurora PostgreSQLR, Machine Learning, Looker, Crystal Reports, Micro Soft AZURE, HADOOP, Alteryx
Contact this candidate