Amit Kumar Chauhan Email & Phone Number

Amit Kumar Chauhan is a Deputy Manager at Holtec Consulting Private Limited at Holtec Consulting Private Limited.

• 

  Deputy Manager

  Holtec Consulting Private Limited

  Apr 2023 - Present - Gurugram, Haryana, India

  • Developed a Business Forecast Model to support strategic decision making based on statistical analysis and Monte Carlo simulation• Working directly with Managing Director to design a performance appraisal system based on past attrition rate, future business outlook, industry compensation trends and group performance• Developed a framework to estimate Business Offer to Order Conversion period• Automated the generation of Quality Management Report through advanced VBA programming • Developed Project Dashboard, a MS Excel based tool to monitor, manage and score projects based on real time performance on various parameters• Developed a framework for invoicing & collections management, a VBA programming based tool for top management to monitor & manage project financials on day-to-day basis with interactive GUI & process automation• Developed a framework for project bidding based on project cost, project duration and client performance history• Designed and created Microsoft Excel spreadsheets to implement statistical data analysis models and to provide an attractive and functional user interface to access centralized international & domestic cement industry database• Developed a robust model to forecast retail prices of cement which includeda) Formulation of imaginative list of lead variablesb) Determination of statistical distributions for these variablesc) Derivation of casual inter-relationshipsd) Application of boutique quantitative techniques (conventional statistics, curve fitting, exponential smoothing, correlation exercises)• Developed a framework to calculate market share based on market dynamics and company competitiveness for cement based companies in India.