Headline

MBA Finance @ COEP Technological University | Aspiring FP&A & Financial Analyst | Financial Modelling | Budgeting | Finance Intern at MahaMetro | Advanced Excel | Power BI

About

I'm an MBA Finance candidate at COEP Technological University (Expected 2026) with a BE in Mechanical Engineering — a combination that gives me an edge in infrastructure, manufacturing, and corporate finance roles that most finance graduates don't have.  Most recently, I interned at MahaMetro (Maharashtra Metro Rail Corporation) where I prepared Balance Sheet and P&L Statements for ADB-funded projects with a corpus of approximately ₹814 Crore. I also proposed and presented an Electronic Bank Guarantee (e-BG) solution to senior management — the kind of work that goes beyond routine internship tasks.  I've built financial models for 4+ listed battery manufacturers (including Exide and Amara Raja) through a live project at Octarange Technologies — analyzing revenue, cost structures, margins, and efficiency ratios across companies.  I'm skilled in Advanced Excel (VLOOKUP, Pivot Tables, Macros), Power BI dashboard development, and SAP. Certified in 3-Statement Modelling and FP&A Budgeting through 365 Financial Analyst.  Targeting FP&A Analyst and Financial Analyst roles where I can contribute from Day 1. Open to opportunities in infrastructure finance, corporate finance, and manufacturing sector finance.  Feel free to connect or reach out: mayurnandankar000@gmail.com

Location

India

Work experience

Finance Intern at MahaMetro, Jul 2025 - Sep 2025 · 3 mos, Nagpur, • Prepared Balance Sheet and P&L Statements for ADB-funded projects with a corpus of approximately ₹800 Crore, focusing on loan utilization and financial reporting. • Managed Bank Guarantees by tracking expiration schedules, verifying records in SAP, and recommending process improvements. • Proposed and presented an e-BG (Electronic Bank Guarantee) solution to senior management to streamline guarantee processing and improve transparency — proposal currently under review. • Verified vendor claims and maintained payment records for multiple vendors across RA bills under Viaduct and Phase 1 & 2 construction projects. • Organized and classified financial vouchers ensuring accurate and systematic recording of payments.

Financial Analyst Intern at Octarange Technologies, Apr 2025 - Jun 2025 · 3 mos, Pune District, • Built separate financial models for 4+ listed battery manufacturers (including Exide and Amara Raja) analyzing revenue, cost structures, margins, and efficiency ratios. • Consolidated individual models into a cross-regional comparison dashboard in Excel to identify profitability and growth patterns across companies. • Key finding: Established players (Amara Raja, Exide) showed stronger operational efficiency; newer entrants posted higher revenue growth but thinner margins due to capex-heavy lithium-ion transition.

Sales and Market Research at The Humming Minds, Dec 2024 - Jan 2025 · 2 mos, Pune District

Senior Executive at Qwik Supply Chain Pvt Ltd, Jul 2022 - Dec 2022 · 6 mos, Nagpur, • Oversaw daily movement of 500+ SKUs across 4 major clients, optimizing inventory operations and reducing stock mismatches by 12%. • Reduced excess stock by 15% across client inventories through systematic tracking and demand-pattern analysis. • Processed and reconciled 300+ shipment invoices with 100% accuracy, ensuring compliance with financial and audit standards. • Generated weekly Excel-based MIS reports on inventory movement and order cycles for management review.

Student Intern at Mahindra and Mahindra Limited [Automotive and Farm Equipment Business], Feb 2022 - May 2022 · 4 mos, Nagpur, • Developed Excel-based dashboards to track production efficiency and quality metrics across 7 CNC lines. • Coordinated 30+ CMM inspections monthly, ensuring quality compliance and reducing rework by 15%.

Education

Master of Business Administration - MBA, Finance, General, COEP Technological University

Bachelor of Engineering - BE, Mechanical Engineering, Yeshwantrao Chavan College of Engineering - YCCE