Yagni Patel

Developed Excel-based operational cost models supporting 15+ transformer product lines, enabling leadership to evaluate production costs, pricing strategies, and operational planning. Performed variance analysis models to track budget vs. actual performance, surfacing cost deviations for corrective action. Automated 70–90% of recurring Excel reporting workflows using Power Query, PivotTables, and Excel Macros, reducing the month-end reporting cycle from 7 days to 5 days while improving reporting consistency.

Business Operations & Cost Analytics Intern - Narendra Transformers - Himatnagar, GJ, India

(2024-02 - 2024-08)

• Developed Excel-based operational cost models supporting 15+ transformer product lines, enabling leadership to evaluate production costs, pricing strategies, and operational planning.
• Performed variance analysis models to track budget vs. actual performance, surfacing cost deviations for corrective action.
• Automated 70–90% of recurring Excel reporting workflows using Power Query, PivotTables, and Excel Macros, reducing the month-end reporting cycle from 7 days to 5 days while improving reporting consistency.
• Built standardized cost metrics framework consolidating data from 6 operating units, enabling scalable KPI reporting and repeatable month over month stakeholder comparisons.

Business Analytics & Strategy Intern - Agile Capital Services - New Delhi, DL, India

(2023-06 - 2023-08)

• Evaluated 15 companies across FinTech, Banking, SaaS, Retail, FMCG, EdTech, and HealthTech sectors to support investment research and strategic business analysis.
• Designed 5 interactive Power BI dashboards tracking approximately 25 operational and financial KPIs, enabling department heads to monitor monthly business performance.
• Conducted competitive benchmarking across 12–14 competitors against 3 anchor companies, identifying market trends and strategic opportunities for a primary internal stakeholder.
• Automated recurring reporting processes using Advanced Excel and Power Query, reducing report preparation time by 30% while improving reporting accuracy and consistency.
• Performed business analysis, market research, and scenario modeling to support investment recommendations and strategic decision-making.

Master of Science (MS) - Business Analytics - Avila University (2025-03 - 2027-05)

Bachelor's - Advance Accounting & Auditing - Som Lalit College of Commerce (2020-07 - 2023-04)