Shubh Mody

About Shubh Mody

I like solving puzzles in data to uncover insights that solve real business problems. Over the past 3 years, I\'ve worked at the intersection of business intelligence, finance & analytics, distilling complex data to generate high impact strategies that optimize business performance and drive growth.At PG & E, I manage analytics and reporting for a $600M capital program where I\'ve improved monthly forecast accuracy by 15%, prevented $4M in budget overruns, and streamlined dashboards that track CAPEX, operational performance and work execution of a portfolio of 100+ projects across regions within Gas Distribution Main Replacement.As a BI Analyst at iConsult, I delivered end-to-end BI solutions for a SaaS platform by integrating product, usage, and revenue data to provide stakeholders with clear insights into user adoption patterns and potential churn risks. At Anuva, I developed and deployed predictive models, including uplift and propensity models, to optimize budget allocation, resulting in measurable improvements in marketing ROI.My toolkit: SQL • Excel • Power BI • Python • ETL • Financial Modeling • Machine Learning • ForecastingIf you\'re working on challenges at the intersection of data, finance, and strategy or just want to talk analytics, I\'m always happy to connect.

Experience

1. Business Analyst

   Clarisight Consulting

   Aug 2024 — Present · San Ramon, CA, US

   Client: PG & E• Improved capital spend visibility and reporting efficiency for the Gas Distribution Main Replacement program by redesigning BI workflows (SQL & Power BI) and financial models (Excel) to track $600M+ in annual capital expenditure.• Enhanced forecasting accuracy by 10 - 15% by automating cost and unit-rate analysis dashboards (Power BI), providing PMs with up-to-date cost trends, variance drivers, and productivity metrics that strengthened OPEX/CAPEX planning discipline.• Prevented $4M in budget overruns by overhauling the Earned Value Management (EVM) framework, integrating CPI/SPI and schedule-cost metrics to support earlier intervention and tighter cost controls across the program portfolio.• Collaborated cross-functionally with program and finance teams to gather business requirements, build data models, and deliver ad hoc analysis that informed program strategies and project progress.• Leveraged data mining and statistical techniques to evaluate regional construction activity, uncovering operational inefficiencies and enabling data-driven resource allocation across the Gas Distribution portfolio.

Education

• KJ Somaiya College of Engineering, Vidyavihar

  Bachelor of Technology - BTech, Electronics and Telecommunication Engineering

• Syracuse University

  Master of Science - MS, Applied Data Science