Eirsun LimitedCommercial Analyst
Mar. 2023 - Nov. 2025India, MumbaiCommercial Analyst – Solar Projects
• Conducted feasibility analysis and ROI modeling for 25+ solar projects (100kW-15MW) totaling €45M+ in project value using Excel financial models
• Built cost optimization models analyzing CapEx, OpEx, capacity utilization, and vendor pricing data, identifying 15-18% cost reduction opportunities
• Analyzed international pricing trends on solar components from China, Europe, US, and India, identifying 12% cost arbitrage opportunities
• Delivered executive-ready business cases combining technical specifications with 25-year financial projections, achieving 80% proposal-to-approval conversion rate
Finance & Operations Analyst – Manufacturing Division
• Built Power BI dashboards with optimized data models and DAX to track MTD/YTD sales, expenses, and margins across 3 business units.
• Designed and automated Google Sheets–based finance trackers for inter-BU bank reconciliation, payments, sales, purchases, and expense categorization.
• Automated multi-entity data consolidation using ARRAYFORMULA, FILTER, and IMPORTRANGE, reducing manual updates and errors.
• Implemented dependent dropdowns for expense categorization (category → sub-category), improving data accuracy and consistency.
• Consolidated financial data to track balances, inter-BU transfers, and shared expenses, ensuring clean audit trails.
• Identified and eliminated ₹800K in unnecessary costs, improving gross margins from ~32% to ~38%.
• Produced monthly leadership reports covering revenue, expenses, and variance analysis to support budgeting and decisions.