Gauri Ferreira
Folsom,CA
Summary
Results-driven Business Analyst with expertise in SQL and Power BI, enhancing financial accuracy and operational efficiency at Insight Global. Proven track record in automating reporting processes and developing insightful dashboards, leading to significant improvements in cost control and decision-making. Strong analytical skills complemented by effective communication and collaboration abilities.
Overview
4
4
years of professional experience
Work History
Business Analyst II
Insight Global
05.2025 - Current
- Analyzed project, cost, and vendor datasets across 20+ projects to support accruals, forecasting, and cost control, improving financial accuracy and audit readiness.
- Built and maintained Power BI dashboards tracking cost performance, utilization, and forecast variance, increasing leadership visibility into KPIs.
- Queried and validated datasets using SQL and Excel to reconcile vendor invoices and hours reporting, reducing billing discrepancies.
- Implemented a consultant cost-tracking workflow using Microsoft Forms and Power BI, reducing manual reporting effort by 40%.
Business Analyst (PG&E, Meta)
Insight Global
04.2022 - 08.2024
- Analyzed SAP Business Warehouse financial and operational data with SQL, tracking budget vs. actuals for PG&E programs exceeding $5 million.
- Constructed structured datasets and executive Power BI dashboards from SAP BW data to enhance budget tracking and KPI reporting.
- Automated report refresh and distribution in Power BI using Power Automate, reducing manual efforts for recurring PG&E reports.
- Developed automated Google Sheets reporting to assess AR/VR field team allocation, increasing operational efficiency by approximately 30% for Meta's contract.
Business Operations Analyst
Adivo Associates LLC
10.2021 - 04.2022
- Developed Excel-based financial models to analyze cash flow and profitability.
- Conducted cost analysis, uncovering savings opportunities that enhanced operating margins by approximately 20%.
- Enabled leadership identification of trends through comprehensive financial modeling.
Education
Master of Science - Business Analytics
California State University, Sacramento
Sacramento, CA12-2025
Bachelor of Arts - Econometrics & Quantitative Economics
University of California, Davis
Davis, CA09-2021
Bachelor of Arts - International Relations & Affairs
University of California, Davis
Davis, CA09-2021
Skills
- SQL and R programming
- Python (Pandas) and advanced Excel
- Data visualization with Power BI and Tableau
- Forecasting and variance analysis
- Business process automation with Power Automate and Power Apps
- Google Sheets and Microsoft Forms expertise
- SAP Business Warehouse (BW) and Oracle proficiency
- Salesforce CRM management
- Project management with Jira and Smartsheet
Projects
- Supply Chain Cost Optimization, Built a Python optimization model (PuLP) to analyze production and distribution trade-offs and minimize total system cost.
- SBA Loan Default Prediction, Applied SQL and Python to develop and evaluate predictive models using ROC, lift/gain, and profit analysis.
Timeline
Business Analyst II
Insight Global
05.2025 - Current
Business Analyst (PG&E, Meta)
Insight Global
04.2022 - 08.2024
Business Operations Analyst
Adivo Associates LLC
10.2021 - 04.2022
Master of Science - Business Analytics
California State University, Sacramento
Bachelor of Arts - Econometrics & Quantitative Economics
University of California, Davis
Bachelor of Arts - International Relations & Affairs
University of California, Davis