PRAKASH KUMAR PANDEY
Gurugram
Summary
Skilled Data Analyst with 7+ years experience in data collection, analysis, and visualization. Proficient in advanced statistical techniques and tools like MY SQL, Power BI, and Advanced Excel. Expertise in designing and implementing data models and dashboards to enhance organizational performance. Collaborates cross-functionally to identify data needs, solve complex problems, and deliver tailored solutions. Proven track record of improving operational processes through data-driven recommendations.
Overview
9
9
years of professional experience
Work History
Officer- HR
Jaquar and Company India Pvt Ltd
Gurgaon
12.2022 - Current
- Designed comprehensive tool for monitoring staff metrics
- Collaborated with PMS team to establish policies aligned with company goals.
- Measuring success rates of employee training initiatives.
- Analyzed survey results to detect potential areas for enhancement
- Analyzed recruitment data to identify key hiring insights.
- Conducted a comprehensive absence rate analysis at the departmental level.
- Conducted impact analysis on sales vertical appraisals.
- Created reports on various HR metrics such as retention rates and turnover costs.
Assistant Manager-Sales MIS
Team Aviation India Pvt Ltd
Delhi
03.2022 - 11.2022
- Coordinated development and test phases of SAP reporting.
- Identified areas of improvement within the organization's current sales processes.
- Provided guidance and support to junior staff members on daily tasks, projects, and objectives.
- Performed consistent employee evaluations to pinpoint improvement areas
- Analyzed sales data to identify trends and patterns in customer behavior.
- Conducted research on competitors' products and pricing strategies.
- Executed data mining to identify potential business prospects.
- Developed plans to increase sales revenue, improve efficiency and optimize resources.
Deputy Manager - Strategy Operations
Haier Appliance India Pvt Ltd
Greater Noida
11.2021 - 02.2022
- Managed departmental minutes of meetings
- Analyzed factory data across multiple departments for business strategy development.
- Developed comprehensive presentations for Plant Head's monthly evaluations.
- Managed a group of associates, evaluating their output.
- Reviewed staff metrics to determine incentive eligibility.
- Analyzed business operations to identify areas of improvement and recommend solutions to increase efficiency.
MIS Executive
VE Commercial Vehicles Ltd. (Randstad Payroll)
Gurgaon
11.2018 - 09.2021
- Collaborated with the field team for effective issue resolution.
- Generated purchase orders using SAP system
- Overseeing monthly surveys to gauge customer satisfaction.
- Facilitated knowledge transfer regarding CRM, PRS, and 1-4-9 portal to enhance team performance.
- Delivered actionable recommendations to leadership
- Worked closely with the IT team to ensure the development of high-quality, business-specific reports.
- Assessed claims in the Eicher on-road service process.
- Supported regional team in action planning for various aftermarket KPIs.
- Developed MIS reports to track customer service performance and identify areas for improvement.
- Created dashboards and visualizations to present data insights in an easy-to-understand format.
- Maintained a database of customer information, including contact details, preferences and purchase histories.
Associate-Field Coordinator
Home Credit India Finance Pvt Ltd
Gurgaon
10.2015 - 08.2016
- Coordinated with field executives for loan collections.
- Managed and prepared frequent conversion MIS details for consistent managerial input.
- Managed the distribution of loan portfolios to field staff.
Education
Masters of Business Administration - Finance & HR
Swami Vivekananda Subharti University
Meerut06.2021
Bachelor of Commerce -
Swami Vivekananda Subharti University
Gurgaon06.2019
Intermediate -
UP Board, Allahabad University
Deoria03.2016
Matriculation -
UP Board, Allahabad University
Deoria03.2014
Skills
- Advanced Excel
- Presentation
- Power BI
- VBA Macros
- SAP, SD, MM
- My SQL
- Analytical thinking
- Data Visualization
- DAX Query
- Strategy planning
- Data Integrity
- Self-Directed
Hobbies and Interests
Cricket
Languages
- English
- Hindi
Personal Information
- Gender: Male
- Nationality: Indian
Timeline
Officer- HR
Jaquar and Company India Pvt Ltd
12.2022 - Current
Assistant Manager-Sales MIS
Team Aviation India Pvt Ltd
03.2022 - 11.2022
Deputy Manager - Strategy Operations
Haier Appliance India Pvt Ltd
11.2021 - 02.2022
MIS Executive
VE Commercial Vehicles Ltd. (Randstad Payroll)
11.2018 - 09.2021
Associate-Field Coordinator
Home Credit India Finance Pvt Ltd
10.2015 - 08.2016
Masters of Business Administration - Finance & HR
Swami Vivekananda Subharti University
Bachelor of Commerce -
Swami Vivekananda Subharti University
Intermediate -
UP Board, Allahabad University
Matriculation -
UP Board, Allahabad University
Similar Profiles
Ashish DandgeAshish Dandge
Area Sales Manager at Jaquar India Pvt LtdArea Sales Manager at Jaquar India Pvt Ltd
HITESH SOLANKIHITESH SOLANKI
ASM at JAQUAR & COMPANY PVT LTDASM at JAQUAR & COMPANY PVT LTD
Sourabh SinghSourabh Singh
Deputy Manager - FCNS at Jaquar and Company Pvt LtdDeputy Manager - FCNS at Jaquar and Company Pvt Ltd