Mar 2022 – Jul 2023 · 1 yr 4 mos · Gurugram, Haryana, India

Oct 2020 – Mar 2022 · 1 yr 5 mos · Gurgaon, Haryana, India

• Global Business Consulting

Oct 2017 – Nov 2020 · 3 yrs 1 mo · Gurgaon, Haryana, India

• Global Business Consulting - DS&I India
• Global Commercial Services

Apr 2016 – Oct 2017 · 1 yr 6 mos · New Delhi , India

• Providing an accurate and high quality forecast supported by Sales & Production Planning process and knowledge of statistical methods.
• Assist in preparing accurate and market driven production forecast and Trend Analysis
• Making the Weekly Business Review Reports at broader level and Monthly sales Analysis Reports for accurate Planning.

May 2014 – Apr 2016 · 1 yr 11 mos · Noida

• Production Planning & Sales Forecasting:
• Providing an accurate and high quality forecast supported by Sales & Production Planning process and knowledge of statistical methods.
• Assist in preparing accurate and market driven production forecast
• Making the Weekly Business Review Reports at broader level and Monthly sales Analysis Reports for accurate Planning.
• Data Analysis:
• Reviewing Sales & Marketing historical inputs; analyzing sales pattern, determining exceptions on monthly basis and monitoring demand forecast exceptions and ensuring to address action plans.
• Reviewing and analyzing the variance for the Actual Vs Plan Sales.
• Performing SKU-wise, category-wise sales-stock analysis, Identify slow moving categories/Articles or Dead Inventory and provide the feedback to the management for means of liquidating the same
• Automation & Process Improvement:
• Developed VB automated programs to generate the Monthly Financial reports which increased the efficiency and reduce time consumption.
• Modify financial models to enhance functionalities, such as simplifying formulae and formatting the model and enhancing the current process through macro coding.
• Created automation through macro and data validation in Excel and MS Access across all reports to ensure system is free from garbage data.
• Redesigned Excel logs into MS-Access forms for easy input of data to feed into the system.
• MIS Reporting:
• Build Excel reports based on specifications provided by the onsite team. This requires working closely with the onsite engagement team and having regular interactions to share thoughts and provide value-add.
• Providing continuous support to Dallas team by designing & generating multiple reports as per their requirement like financial report and Executive Report.

Jul 2012 – May 2014 · 1 yr 10 mos · Noida , India

• Working as IT Analyst in Remote Infrastructure Managed (RIM) division of Computer Sciences Corporation
• Supporting UK client - Royal Mail Group(RMG) as L1/L2 System(s) Analyst
• Roles:
• Analytics /Reporting :
• Analyzing information system needs and designing solutions by evaluating end users requirements
• Collect data, analyze and report on performance, usage and trends within assigned portfolio
• Create reporting templates and dashboard presentations to consistently and succinctly convey trends, consumption and performance to leadership, business partners and other technology teams
• Performed ticket audits on the basis of documentation and procedures
• Prepared presentations & training materials
• Conducting Root cause analysis for better management of severe issues in the future
• Tracking and resolving host and guest issues by liaising with Incident management and other teams.
• Leading daily service review calls to generate reports for ensuring proper adherence to SLA
• Reviewing access request and technical documents such as PTM/LTM/SA
• Reviewing change request (GCARS) and approving them
• Monitor consumption / usage metrics to understand trends to assist in the effective management of vendor partners
• Client Servicing
• Involved in regular client interaction over calls and E-mails for resolving customer issues.
• Ensured 100% client satisfaction and received appreciation for the same.
• Providing proper analysis of the issue to the client to reduce the occurrence of similar issues.
• Project Management
• Primary Quality Management Resource of the team; responsible for Maintaining Audit documents
• Delegation of tasks to the right channels for productivity & management of queues for trouble tickets
• Management of client’s user profiles in Active Directory by creating/deleting them in the system
• Housekeeping of drives, adding/deleting files and modifying size and attributes.

Mar 2012 – Jul 2012 · 4 mos · Delhi

• Joined as a Trainee - Sales Business Analyst in a recognized and reputed packaging firm at their corporate office in Delhi handling end-to-end Sales & Marketing activities.