Muskan Ahuja
Bangalore
Summary
Analytical professional with 2.5 years of experience utilizing business and financial data to enhance revenue growth and operational efficiency in agile environments. Skilled in developing forecasting models, KPI frameworks, and margin analysis reports to optimize workforce planning and cost structures. Proficient in Excel for detailed analysis, SQL for data querying, and Power BI for creating interactive dashboards and performance tracking systems. Expertise in variance analysis, trend identification, and translating complex datasets into actionable insights that drive improved margins and operational outcomes.
Overview
3
3
years of professional experience
Work History
Senior Analyst - Strategic Operation
Mphasis Ltd.
Bengaluru
06.2023 - Current
- Portfolio & Financial Planning: Analyzed $52Mn portfolio performance using headcount-to-revenue mapping models; identified margin leakages and improved profitability by optimizing bench allocation.
- Led headcount forecasting based on deal pipeline for proactive staffing; optimized cost structure by analyzing non-billable roles and integrating freshers, increasing project margins by 10-15%.
- Business Forecasting, BHC & Revenue Accuracy: Built and maintained revenue forecasting models using historical BHC data and trend analysis, achieving 92% forecast accuracy across 6 quarters.
- FP&A & P&L Support: Analyzed revenue, cost, and margin to support monthly FP&A cycles, improving financial visibility and forecast precision across 21+ accounts.
- Performance Metrics & Executive Reporting: Designed automated KPI dashboards tracking Utilization, Billing Multiple, and Margin using Excel/Power BI, improving reporting turnaround time by 40%.
- Developed demand forecasting models using deal pipeline data to predict staffing needs and optimize workforce allocation, enhancing margins by 2-3%.
- Coordinated cross-functional program execution and governance; managed SOW renewals, implemented COLA clauses, updated billing rates, and ensured SLA compliance for resource authentication.
Education
MBA - Finance
BML MUNJAL UNIVERSITY
Gurgaon, India03-2023
BBA - Finance
VISHWAKARMA UNIVERSITY
Pune, India06-2021
Skills
- Business Analysis
- Data Analysis
- Forecasting & Trend Analysis
- Root Cause Analysis
- Project Management
- Stakeholder Management
- Agile Methodology
- Excel
- SQL
- Power BI
- Python
- Financial Modeling
- problem solving
- Data analysis
Projects And Achievements
- Revenue Acceleration through Pipeline & Resource Readiness, Boosted revenue by prioritizing key pipeline deals and fast-tracking closures with sales., Optimized staffing by pre-aligning resources to demand, cutting onboarding delays and early benching.
- Non-Billable Resource Reallocation Project, Led the redeployment of 20+ non-billable lateral resources, curbing revenue leakage and improving margin by 3%., Streamlined bench tracking and alignment, saving $24K+ and enhancing billing efficiency.
Digital Presence And Side Projects
- Founder & Artist - The Clayra, Created and sold 50+ handmade artworks across India, building a personal brand and managing end-to-end creative operations.
- Founder & Writer - Musing Avenue, Authored thought-leadership articles on finance, management, and life lessons, driving reader engagement and professional visibility.
Timeline
Senior Analyst - Strategic Operation
Mphasis Ltd.
06.2023 - Current
MBA - Finance
BML MUNJAL UNIVERSITY
BBA - Finance
VISHWAKARMA UNIVERSITY