Summary
Overview
Work History
Education
Skills
Technical Skills
Certification
Timeline
Generic

Peter Ferguson

Chicago,IL

Summary

Dynamic Business Intelligence developer with an engineering and technology consulting foundation. Combines Python and Power BI to standardize financial reporting, automate complex data pipelines, and deliver advanced dashboards that unlock actionable insights at scale. Trusted collaborator across cross-functional teams, known for strengthening data reporting frameworks that support 30,000+ employees, and for accelerating decision-making with clear, reliable analytics.

Overview

5
5
years of professional experience
1
1
Certification

Work History

BI Developer

Ferguson Enterprises
Chicago, IL
09.2024 - Current
  • Reconciled and standardized six inconsistent financial reporting processes, eliminating conflicting outputs and enabling a single source of truth for company-wide reporting.
  • Pioneered the BI team’s first Python (Streamlit) dashboard, enabling complex BI calculations and dynamic analytical capabilities beyond Power BI’s capacity.
  • Developed and maintained 15+ interactive Power BI reports tailored to C-suite stakeholders, enabling actionable insights on performance, finance, and operations.
  • Managed Power BI workspace access, dataset refresh schedules, and version control, supporting enterprise-wide data governance for 30,000+ employees.
  • Built Python scripts in Jupyter Notebook to extract financial data from on-premise and cloud-based SQL databases, apply complex transformations, and deliver formatted Excel reports to internal stakeholders.
  • Designed and automated a data pipeline process in Databricks which extracts inventory from a SQL Datawarehouse on the first of the month and stores it as a historical version in an on-premise database.
  • Collaborate with IT team to develop cloud-hosted semantic models which are queried across the entire financial team.

Civil Engineer / Data Scientist

CDM Smith, Inc
Chicago, IL
06.2021 - 09.2024
  • Served as deputy project technical lead on a $20 million Federal Superfund Remediation Site, coordinating across multiple engineering disciplines (e.g., Geotechnical, Electrical, etc.) to accomplish the design.
  • Collaborated with front-end developer and software tester via Azure DevOps on object-oriented Python scripts quantifying structural damage, improving accuracy by 12%.
  • Developed geospatial-data conversion tools in Python to streamline file input formatting for a novel coastal modeling software application for the Army Corps of Engineers.
  • Troubleshot Jupyter notebooks that interact with client data via API across multiple endpoints, loading client data into ML models that predicted the existence of lead in drinking water distribution pipes and simulating weather impacts across 4 U.S. project locations.

Education

Data Science And Visualization Bootcamp -

Northwestern University
Chicago, IL
08.2023

Bachelor of Science - Civil/Environmental Engineering

University of Minnesota Twin Cities
Minneapolis, MN
05.2021

Skills

  • Python programming
  • SQL programming
  • Power BI development
  • ETL development
  • Data visualization
  • Data modeling
  • Financial reporting
  • Excel VBA
  • Power Automate
  • AWS
  • NoSQL
  • DevOps
  • PySpark
  • Databricks
  • Git
  • Tableau

Technical Skills

Python, SQL, Excel VBA, Power BI, Power Automate, AWS, NoSQL, DevOps, PySpark, Databricks, Git, Tableau

Certification

AWS Certified Cloud Practitioner

Timeline

BI Developer

Ferguson Enterprises
09.2024 - Current

Civil Engineer / Data Scientist

CDM Smith, Inc
06.2021 - 09.2024

Data Science And Visualization Bootcamp -

Northwestern University

Bachelor of Science - Civil/Environmental Engineering

University of Minnesota Twin Cities

Similar Profiles

CREATE PROFILE