Summary
Overview
Work History
Skills
Accomplishments
Leadership and Working Style
Education and Certifications
Timeline
background-images

Soumya Moudgal

Brampton,Canada

Summary

Dynamic Business Intelligence leader with over 18 years of experience transforming complex data into actionable insights that drive executive decision-making and enhance operational excellence. Recognized for developing intuitive, well-governed BI solutions, mentoring high-performing teams, and collaborating closely with business leaders to establish meaningful KPIs. A service-oriented professional with exceptional communication skills, dedicated to fostering a culture of informed, data-driven decisions. Expertise aligns seamlessly with organizations prioritizing quality, consistency, and excellence, exemplified by a successful tenure at Four Seasons Hotels and Resorts.

Overview

19
19
years of professional experience

Work History

Manager, Data Modelling

Metrolinx Inc.
10.2022 - Current
  • Lead the delivery of enterprise Power BI solutions that provide timely, accurate, and actionable insights for senior leaders and operational teams.
  • Partner closely with Finance and business stakeholders to define KPIs, align metrics, and ensure consistent interpretation of performance across the organization.
  • Guide BI team members in developing clear, intuitive dashboards and data models that support confident decision-making.
  • Established reporting standards, governance practices, and quality controls, improving trust, usability, and consistency across BI assets.
  • Led the Finance BI Data Lake visualization initiative, coordinating internal teams and vendors to deliver high-quality, compliant analytics solutions.
  • Designed reusable Power BI dataflows and semantic models to support scalable reporting and self-service analytics.
  • Delivered Power BI training and enablement sessions, increasing adoption and helping business users feel confident working with data.
  • Fostered a culture of continuous improvement and collaboration, incorporating feedback, retrospectives, and best-practice sharing.
  • Automated key operational processes using Power Automate and Power Apps, reducing manual effort and improving efficiency.

Impact

  • Increased adoption of BI tools and self-service reporting
  • Improved alignment and clarity around financial and operational KPIs
  • Enabled leadership with trusted insights to support strategic decisions

Capital Maintenance Program Analyst

Toronto Hydro Electric Systems Ltd.
08.2019 - 10.2022
  • Delivered analytics and reporting solutions supporting long-term planning, forecasting, and operational performance.
  • Developed interactive dashboards for senior leadership, translating complex data into clear performance narratives.
  • Integrated data from multiple systems to create unified, reliable views of business performance.
  • Automated analytics workflows using Alteryx, SQL, Python, and R, significantly reducing manual effort and improving accuracy.
  • Produced and governed KPI scorecards used for executive and corporate performance reporting.
  • Collaborated with Finance, Engineering, and IT partners to ensure analytics solutions aligned with business priorities.

Project Manager

Thrillworks Inc.
12.2018 - 07.2019
  • Managed cross-functional teams delivering data-informed digital initiatives using Agile practices.
  • Improved delivery transparency and accountability through structured planning, reporting, and stakeholder communication.
  • Translated strategic goals into actionable execution plans, ensuring projects were delivered on time and with quality.
  • Led cross-functional teams to drive project delivery and meet client expectations.
  • Developed project plans, timelines, and budgets to ensure resource allocation efficiency.

Assistant Vice President

JP Morgan Chase & Co
07.2010 - 09.2018
  • Serving high-profile stakeholders, including Chief Risk and Control Officers, Chief Technology Officers, and external regulators like the OCC and FRB.
  • Trained and certified as a SCRUM Master, playing a key role in adopting Agile practices and implementing Continuous Integration/Continuous Deployment (CI/CD) within the Line of Business, providing strategic direction.
  • Set up and managed a team of data analysts and visualization specialists, demonstrating strong team management skills.
  • Developed complex Cognos BI reports, interactive HTML reports, Alteryx workflows, Tableau dashboards, and Power BI analyses for self-service use, addressing KPIs, gap analysis, and root cause analysis, offering decision support.
  • Initiated project management and tracking through JIRA and Confluence, streamlining project workflows and documentation.
  • Conducted workshops to identify and address gaps between the scrum team and the Product Owner, resulting in a 60% improvement in efficiency and effective problem resolution.
  • Solely responsible for Cognos and Oracle implementations, delivering over 30 reporting and database enhancements with zero rollbacks, ensuring accuracy and reliability.
  • Created complex PL/SQL scripts to extract and load data efficiently in the absence of ETL tools, achieving rapid data processing and supporting analytics.
  • Oversaw database performance management to ensure optimal operation and reliability.
  • Contributed to all project phases, including requirement gathering, development, and quality assurance, ensuring successful project delivery and adherence to regulatory requirements.

Senior Associate

Cognizant Technology Solutions
11.2006 - 07.2010
  • Managed all aspects of the Cognos BI Reporting tool, from requirements elicitation through to deployment, providing strategic direction.
  • Created and maintained multiple reports and data models, ensuring accuracy and relevance.
  • Conducted Quality Assurance (QA) and User Acceptance Testing (UAT) for developed models and reports to ensure they met user requirements and standards.

Skills

    TECHNOLOGY & TOOLS
  • Business Intelligence: Power BI, DAX, Power BI Dataflows, Tableau, Cognos
  • Data & Modeling: SQL, Star & Snowflake Schemas, Semantic Models
  • Cloud & Integration: Azure Data Lake, Azure Data Factory, Synapse
  • Automation: Power Automate, Power Apps
  • Analytics: Python, R, Alteryx
  • Delivery & Collaboration: Jira, Confluence, Agile/Scrum
  • Other: Advanced Microsoft Excel

Accomplishments

  • Business Intelligence Strategy & Leadership
  • Executive & Operational Dashboards (Power BI)
  • KPI Definition & Performance Measurement
  • Data Modeling & Semantic Layers
  • Self-Service BI Enablement & Training
  • BI Governance, Standards & Quality Assurance
  • Azure BI Platforms (ADLS, ADF, Synapse)
  • Cross-Functional Collaboration
  • Agile Delivery & Continuous Improvement
  • Stakeholder & Executive Communication

Leadership and Working Style

  • Service-oriented, collaborative leadership approach
  • Strong focus on quality, consistency, and trust in data
  • Comfortable engaging with executives and non-technical audiences
  • Passionate about mentoring teams and building data confidence across the organization

Education and Certifications


  • Post Graduate Diploma – International Business
    Symbiosis Centre for Distance Learning
  • Bachelor of Engineering – Electrical & Electronics
    Sir M. Visvesvaraya Institute of Technology
  • Certified Scrum Master (CSM) – Scrum Alliance
  • Currently pursuing PMP and CFA

Timeline

Manager, Data Modelling

Metrolinx Inc.
10.2022 - Current

Capital Maintenance Program Analyst

Toronto Hydro Electric Systems Ltd.
08.2019 - 10.2022

Project Manager

Thrillworks Inc.
12.2018 - 07.2019

Assistant Vice President

JP Morgan Chase & Co
07.2010 - 09.2018

Senior Associate

Cognizant Technology Solutions
11.2006 - 07.2010
Soumya Moudgal