Summary
Overview
Work History
Education
Skills
Websites
Certification
Languages
Technical Skills
Awards
Professional Development
Timeline
Generic

Manav Patel

Toronto

Summary

Results-driven Power BI Consultant with a strong foundation in data analytics, automation, and project controls. Experienced in designing, developing, and optimizing Power BI dashboards, data pipelines, and analytics solutions to drive strategic decision-making. Specializes in ETL processes, SQL, Power Query, data visualization, and automation. Adept at streamlining cost tracking, schedule forecasting, and rail access reporting to improve project efficiency. Holds a PMP, B.Eng (Mechanical), PGD in Analytics, and Environics Certification.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Senior Power BI Consultant

Accenture
01.2024 - Current
  • Company Overview: Formerly Comtech
  • Leading the development and enhancement of data-driven decision-making models for major railway expansion projects
  • Optimized Power BI dashboards by integrating automated ETL pipelines, significantly reducing manual data handling efforts
  • Expanded the Railway Access Utilization dashboard, incorporating real-time data integration from multiple sources to improve rail schedule tracking
  • Collaborating with senior executives and project stakeholders to enhance reporting frameworks and analytics-driven insights for cost and schedule optimization
  • Implemented KPI-driven dashboards that track over $5 billion in railway infrastructure, enabling predictive maintenance scheduling
  • Developed Power BI governance frameworks, ensuring data integrity, version control, and access security
  • Built a data reconciliation system, reducing discrepancies between financial forecasts and actuals by 30%
  • Formerly Comtech

Power BI Consultant

Comtech
06.2023 - 12.2023
  • Company Overview: Accenture
  • Designed & optimized GO Expansion Program Power BI dashboard, enabling seamless program-level schedule updates
  • Developed Railway Access Utilization dashboard for the Access Planning Team, integrating data from SharePoint lists, SQL databases, and manual inputs
  • Automated cost variance reporting, allowing real-time budget tracking across $5 billion in railway infrastructure projects
  • Created a SharePoint-integrated task tracker for the planning team, centralizing communication on 1,200+ schedule changes per quarter
  • Led cross-functional training sessions for project teams, ensuring effective adoption of Power BI tools
  • Integrated SQL-based ETL processes to improve data consistency and reliability, reducing reporting discrepancies by 30%
  • Created a risk analytics framework in Power BI, identifying early warning signs for schedule delays
  • Accenture

Project Controls Specialist

Fitzrovia Real Estate
10.2022 - 06.2023
  • Developed Power BI dashboards for cost control across six active residential projects valued at $1.2 billion
  • Automated invoice reconciliation workflows, reducing processing errors by 30% and cutting approval times from 10 days to 3 days
  • Implemented a Power BI cost-tracking system that consolidated 250+ cost line items from Procore ERP into a single dynamic view
  • Designed ETL processes using Azure SQL to optimize monthly job cost reports for two major pre-construction projects

Project Analyst & Accounting Coordinator

Gannett Fleming
01.2021 - 09.2022
  • Developed SPI & CPI tracking dashboards for the Scarborough Subway Extension
  • Created an accrual forecasting model in Power BI, improving cash flow predictions by 20% for projects worth $2 billion
  • Built a budget vs
  • Actual cost analysis tool that monitored spending across 18 subconsultants
  • Designed an automated invoice processing system, cutting administrative workload by 50% and reducing payment cycle times by two weeks

Project Associate

Jacobs
07.2019 - 05.2019
  • Managed cost control for infrastructure projects worth $500 million
  • Reconciled yearly labor and non-labor budgets, preparing financial reports for corporate strategy planning
  • Developed a project schedule optimization model, identifying high-risk activities and potential cost savings of 10%

Education

Bachelor of Engineering Technology - Mechanical Engineering

Uka Tarsadia University
India
06.2017

Post-Graduate Diploma - Analytics

Centennial College
Toronto, ON
08.2020

Post-Graduate Certificate - Project Management

Centennial College of Applied Arts And Technology
Toronto, ON
12-2019

Skills

  • Power BI
  • DAX
  • Power Query
  • SQL
  • Python
  • Excel
  • Power Pivot
  • VBA
  • Tableau
  • Power Automate
  • Azure Data Factory
  • SharePoint
  • Data-marts
  • SQL Server
  • Primavera P6
  • MS Project
  • Earned Value Management
  • Cost & Schedule Analysis
  • Procore
  • Qualtrics
  • ERP Systems
  • RPA
  • Environics Analytics
  • Advanced Power BI Development
  • Reporting Automation

Websites

Certification

  • Project Management Professional (PMP), PMI
  • B.Eng – Mechanical Engineering, Uka Tarsadia University
  • Post-Graduate Diploma in Analytics, Centennial College
  • Environics Analytics Certification

Languages

English
Hindi
Gujarati

Technical Skills

Power BI, DAX, Power Query, SQL, Python, R, Excel (Power Pivot, VBA), Tableau, Power Automate, Azure Data Factory, SharePoint, Data-marts, SQL Server, Databricks, Primavera P6, MS Project, Earned Value Management (EVM), Cost & Schedule Analysis, Procore, Qualtrics, ERP Systems, RPA, Environics Analytics

Awards

  • Best Qualitative Research Award (Centennial College – TTC Study)
  • Recognized for developing an automated milestone tracking solution at Comtech, reducing reporting time by 40%.
  • Received accolades for designing a real-time cost tracking dashboard, saving over $15M in budget forecasting errors.

Professional Development

  • Advanced DAX & Power BI Workshop
  • Azure Data Factory & SQL for ETL
  • Agile & Scrum Fundamentals

Timeline

Senior Power BI Consultant

Accenture
01.2024 - Current

Power BI Consultant

Comtech
06.2023 - 12.2023

Project Controls Specialist

Fitzrovia Real Estate
10.2022 - 06.2023

Project Analyst & Accounting Coordinator

Gannett Fleming
01.2021 - 09.2022

Project Associate

Jacobs
07.2019 - 05.2019

Bachelor of Engineering Technology - Mechanical Engineering

Uka Tarsadia University

Post-Graduate Diploma - Analytics

Centennial College

Post-Graduate Certificate - Project Management

Centennial College of Applied Arts And Technology

Similar Profiles

CREATE PROFILE
Manav Patel