Pascal Dongmo

Pulled and integrated data from multiple heterogeneous sources into SQL Server, ensuring reliability and consistency of business‑critical datasets. Designed and implemented ETL workflows with SQL Server Integrated Services (SSIS) to automate data extraction, transformation, and loading processes. Designed and implemented tabular data models in SQL Server Analysis Services (SSAS) to optimize reporting and enable advanced analytics. Conducted data analysis and developed advanced models to support decision‑making and reporting. Built interactive dashboards and reports with Power BI and SQL Server Reporting Services (SSRS), improving business visibility and user adoption. Administered SQL Server 2022 databases, including performance tuning, security, and backup/recovery. Developed and implemented a custom SQL Server Job monitoring tool using Power Apps, enabling proactive issue detection and reducing downtime. Implemented tools for manual user data entry into SQL Server using SharePoint Online, Power Automate, and SharePoint Framework (SPFx), streamlining workflows and reducing manual errors. Managed Power BI Service, including dataset refresh scheduling, workspace governance, and user access control. Delivered BI platform (SQL Server + SSAS + consolidating DB2 and other sources, improving reporting speed and efficiency.

Delivered BI and Data Warehouse projects for third‑party companies across multiple industries, adapting solutions to diverse business requirements. Led the implementation of a new Data Warehouse (DWH) for clients, ensuring scalability, high data quality, and compliance with corporate standards. Designed and implemented new ETL processes (SSIS) to integrate data from heterogeneous sources into client DWH systems. Modeled and deployed OLAP cubes in SQL Server Analysis Services (SSAS), enabling advanced multidimensional analysis for business stakeholders. Built interactive dashboards and reports using SQL Server Reporting Services (SSRS) and Power BI, enhancing client reporting capabilities and

Implemented and monitored ETL processes using Informatica for a banking client, ensuring reliable data integration and timely delivery of critical datasets. Collaborated with client teams to support data warehouse operations and maintain high data quality standards. Tools used are Informatica, SQL Server