ASAHI INDIA GLASS LTD | Assistant Manager – Sales MIS & Analytics | Aug 2021 –Present.

• Architected automated daily, weekly and monthly management MIS dashboards in Power BI and DAX, reducing manual consolidation and improving management visibility.

• Prepared performance reporting and variance analysis covering targets, actuals, forecasts, regional trends and business KPIs for senior leadership reviews.

• Standardized reporting workflows and data structures to improve consistency, accuracy and timely circulation of management information.

• Coordinated with Sales, Production and Logistics stakeholders to track issues, follow up on actions and improve end-to-end process visibility.

• Developed demand planning and forecasting models and aligned business projections with production schedules and regional logistics requirements.

• Governed customer master data, sales leads and pipeline stages in SAP/CRM systems, supporting data integrity across branches.

• Evaluated dealer, distributor and project-channel performance, identifying product-mix trends, contribution-margin issues and slow-moving stock.

• Prepared executive review presentations with insights and actionable observations for senior management.

PANASONIC INDIA LTD | MIS Officer – Sales & Distribution | Apr 2018 – Jul 2021

• Directed PSI (Production, Sales and Inventory) reporting to maintain visibility of stock levels across regional distribution centres.

• Designed executive dashboards covering sales achievement, dispatch velocity, stock ageing and performance trends.





• Monitored hold-order status and coordinated with regional sales managers for inter-branch stock rebalancing and issue resolution.

• Prepared monthly management review decks highlighting growth drivers, seasonal trends and target shortfalls.

AIRCEL PVT LTD | MIS Executive – Sales & Operations | Jul 2016 – Mar 2018

• Consolidated high-volume primary and secondary sales data into standardized daily and weekly management reports.

• Automated repetitive operational reporting using Advanced Excel formulas and macros, reducing reporting cycle time.

• Collaborated with Sales and Operations stakeholders to deliver performance scorecards for monthly review meetings.

SELECTED PROJECTS & INITIATIVES

• CRM Pipeline & Order Automation: Standardized order-to-dispatch workflow tracking and improved end-to-end visibility from initial lead to final billing.

IMUS - Standardized Employee workflow tracking and improved end-to-end visibility from initial lead to final billing.

EDUCATION

- Master of Business Administration (MBA) – Marketing & Finance | Chandigarh University | 2022–2024
- Bachelor of Arts (BA) | APS University, Rewa (MP) | 2008–2010
- 12th | State Board | 2006–2007

CERTIFICATIONS

- Microsoft Power BI Certification – Data Modeling, DAX & Advanced Dashboard Design
- Advanced Excel – Power Query, Pivot Tables, Advanced Lookup Functions & MIS Automation
- SQL for Data Analytics – Database Querying, Filtering, Aggregate Functions & Joins
- Enterprise Systems – SAP, ERP, CRM, HRMS, Drawing box (SD & Sales Operations)
- Contemporary AI Productivity – AI Prompt Workshop (ChatGPT, Claude, Gamma)

📌 Assistant Manager in business analysis & MIS (Gurugram)
🏢 ASHAI INDIA GLASS
📍 Gurugram