Clement Boateng

Deliver portfolio, financial, and schedule dashboards supporting a $2.5B energy infrastructure program and 200+ users. Build end-to-end analytics in Microsoft Fabric and Power BI, including data modeling, transformation pipelines, and reporting systems for project finance, schedule, and performance analysis. Engineer snapshot-based ETL/ELT pipelines ingesting Oracle Primavera and EcoSys API data into a Lakehouse with curated historical layers for time-stamped analysis and optimized warehouse tables for scalable reporting. Architect and manage Power BI semantic models integrating 30+ data sources, automate reporting workflows to reduce cycles by 50% and improve data accuracy, and implement governance frameworks (workspace architecture, deployment pipelines, and Row-Level Security). Train and mentor analysts and business users on Power BI development, data modeling, and data storytelling.

Supported Power BI reporting and dashboard development for state transportation projects. Performed earned value analysis and built KPIs to monitor project performance. Transformed financial datasets using Power Query and developed SQL queries for cost data extraction. Configured SharePoint and integrated Primavera P6 schedules with Power BI for unified reporting, presenting insights to senior leadership for budgeting and planning decisions. Served as an owner’s representative and supported development and management of road and bridge construction schedules used to determine contract completion dates, including baseline and progress schedule management via Primavera P6.

Produced ad-hoc analytical reports supporting project planning and management. Collected and transformed traffic data and created visualizations to improve intersection efficiency and safety. Tracked road and bridge construction schedules and costs against baseline schedules and budgets, performed cost analysis for future financial budgets, and conducted variance analysis to identify cost and schedule overruns and deviations from project plans.