Kumar Gaurav Email & Phone Number

India

Providing National and International Corporate Employees training from Last 6 Years. Training Mode Will be Online. Course details are as follows.1. Excel2. Power Bi3. SQL4. Python 5. MIS/WFM/Business Analyst 6. Data Analysis

Jharkhand, India

Gurugram, Haryana, India

 Maintain and Analyses workforce performance, lead analysis and staffing change data for continuous quality and productivity improvement. Assist with development of performance indicators and reporting mechanism to measure operating standards and facilitate effective decision support. Create and communicates schedules and provides regular reports to Management on workload and workforce. Work closely with operations team to analyze and help them to improve their performance.… Show more  Maintain and Analyses workforce performance, lead analysis and staffing change data for continuous quality and productivity improvement. Assist with development of performance indicators and reporting mechanism to measure operating standards and facilitate effective decision support. Create and communicates schedules and provides regular reports to Management on workload and workforce. Work closely with operations team to analyze and help them to improve their performance. Generate ideas for process and services improvement planning. Use trends and reports to forecast requirements. Engagement with Business Unit and workforce Management team leader in relation to process performance by publishing Client/TL APR, Client/TL Shrinkage, Shift adherence, FTE (People Mapping) etc. Facilitate monthly planning meetings with Management and Client. Share and adjust accurate short- and long-term workload and headcount forecasts. Identify the root causes problems and develop measurable solutions of process to eliminate re occurrence. Provide forecasting on daily, weekly, monthly and yearly basis capacity planning. Show less

Deoghar, Jharkhand, India

● Tracking Salesman & Store Performance monthly, Quarterly, Yearly on basis of different Parameters(ABV,ABS,FF,Conversion etc.)● Segregation of Sales Net Amount between Company & Franchise Business Partner as per Agreement between company & Franchise Business Partner.● Cordinating with HR. Team to get Clear Salary of Store Manager, Karigar Staff ,Salesman & Office Staff.● Calculating Tax difference between Wholesale Tax Amount & Retails Tax Amount of Same items of Same Tracking… Show more ● Tracking Salesman & Store Performance monthly, Quarterly, Yearly on basis of different Parameters(ABV,ABS,FF,Conversion etc.)● Segregation of Sales Net Amount between Company & Franchise Business Partner as per Agreement between company & Franchise Business Partner.● Cordinating with HR. Team to get Clear Salary of Store Manager, Karigar Staff ,Salesman & Office Staff.● Calculating Tax difference between Wholesale Tax Amount & Retails Tax Amount of Same items of Same Tracking ID.● Generate Report for most demanding Saleable Items, Design, Color, Size of Cloths. ● Developed Model & Track the different Lots of Clothes MTR. of different Fabrics issue to Factory Karigar & After Sewing also track how much Items quantity received into Warehouse. To know gap between actual & Expected. ● Identify the Rate mismatch of same design in different Bill No. & Report to Vendor to get clarification or Correction. ● Track Payment to Party & Purpose of expenses in New Store launch using bank statement & UPI Summary. ● Create PPT (PowerPoint Presentation) & Dashboard to Show Company Overview to Franchise Business Partner & interact with Company Employee Meetings.● Tracking Stock availability as per Items,Design ,Color & Size on different Store & info. Management & Warehouse Team to Maintain Stock on the Stores.● After Store Audit Track Pilfirage of Stock / Shortage of Stock on basis of different Parameter & get notified to Management & HR. Team to take further Action. Show less

India

Training Classes for SAS, Python, VBA, Advance Excel, SQL, Google Spreadsheet

Gurugram, Haryana, India

Develop Business architecture using as scope, processes, alternative, risks and executing client’s business requirement through work flow and quality analysis➢Engages with project stakeholders to influence direction of project to meet project expectation➢Dealing with large datasets and working on database to analysis & building model➢Implement theoretical principals & hypothetical testing on parameters to analyze data and produce result ➢Outlier treatment, Model validation… Show more Develop Business architecture using as scope, processes, alternative, risks and executing client’s business requirement through work flow and quality analysis➢Engages with project stakeholders to influence direction of project to meet project expectation➢Dealing with large datasets and working on database to analysis & building model➢Implement theoretical principals & hypothetical testing on parameters to analyze data and produce result ➢Outlier treatment, Model validation, Model implementation Show less

Gurugram, Haryana, India

➢ Developed Google Spreadsheet model to handle Pan India supply chain ➢ Planning supply chain schedules in advance in preparation for future requirements➢ Performed Trend Analysis of Data and Automation of reports, prepared variance reports such as Forecast vs. Actual dispatch.➢D2H: delivery to hotel – defined hotel inventory levels, re-orders levels and automated ordering process, escalation handling, publishing periodic dashboards.

➢ Risk classification and categorize the participants of data ➢ Review, analyze and negotiate proposed pricing with the sales force based on the competitive platform ➢ Strategic Pricing & making quotes of Insurance Plans for New Business Schemes in Group Underwriting Team.➢ Presented every price with detailed assumptions to cross functional teams for review and approval

M.Sc(Statistics), Business Analyst

B.Sc(Statistics), Statistics