Sacramento, California, United States
Business analyst with seven years of experience synthesizing operations data and communicating insights to executive management in the corporate sector. Specific expertise in business intelligence reporting, working cross-functionally with database managers and end users to develop KPI dashboards in both Tableau and Power BI.
- Led automation of financial reporting for division by querying data from SQL Server and SAP HANA systems to create KPI dashboards in Tableau, saving over 700 hours per year of manual updating - Worked with leadership teams across departments, including Operations, Supply Chain, and Human Resources, to gather BI requirements and developed 14 Tableau dashboards to inform key business decisions - Developed Excel models to project revenue, expenses, and profit for train manufacturing departments totaling $33M in annual budget and successfully reduced annual forecast variance by 21% - Automated weekly update of 220 Excel files using Alteryx, saving over 600 hours of annual workload
- Created KPI dashboards in Power BI to improve visibility of both project and business unit financial performance, and subsequently trained senior leadership and 180+ project management staff on dashboard use - Analyzed quantitative and qualitative data to develop revenue projections for environmental consulting projects comprising $21M in annual budget
- Synthesized department financial results into KPI dashboards in Excel and presented findings to senior management monthly - Performed data cleaning techniques in SQL and Excel to merge energy usage, weather, and geographic datasets, used to identify suitable customers for energy monitoring study
- Developed 10-year customer adoption forecasts and supporting report for emerging clean energy technologies (fuel cells and distributed wind), included in 2016 PG&E Distribution Resources Plan (DRP)