Sankalp Mishra Email and Phone Number

Business optimization projectsTools - Python, Excel VBA, SQL, MS AccessConcepts- Statistical Modelling, System design, Lean Manufacturing, Continuous improvement, Database development-Developed and deployed a more accurate product costing model.- Variance analysis for monthly/ annual production costs.- Redesigned KPIs and developed a model for weekly production cost goals based of product mix being run and several other production variables. Created a dashboard tool to automate reporting process for the KPIs.-Developed a health records ERP system for calculating and tracking health insurance costs, wellness costs and benefits and monitoring wellness of employees.-Production modelling and simulation. Production data analysis to establish losses due to inefficient operation. -Cost and capacity analysis.-Labor requirement analysis for each plant. Created a tool to find labor requirement based on product mix being run.-Supplier negotiation. Supplier cost analysis.-Continuous improvement using value stream mapping and SMED. Used the same to create a model for estimation of order setup costs based on product type and order quantity.-Developed production standards and standard operating procedures for each department. Created SOP documents and training videos.-Developed a database application for production standards.

-Database design from production data spreadsheets-Application development for data storage and retrieval-Regression modelling

- Established standard operating procedure.- Developed operator training strategy and corresponding training materials.

Southern Furniture Corporation, Assembly division, Conover NC.• Analyzed time study data using value stream mapping and lean analysis and established standard production times for furniture styles.• Mapped production model and process flow design. Standardized operating procedures for production processes.• Developed a SQL based database application to store and retrieve production data. • Built a predictive model to estimate expected production time using the database application. Performed root cause analysis to identify reasons for significant differences in expected and observed production times.

Analyzed various aspects of workforce utilization, facility layout and space constraints for improving efficiency. Reduced the average storage and retrieval time.Liaised between vendors, floor workers and management by providing information assistance.Maintained the database of inventory records using MS Excel and Access. Responsible for data integrity and consistency.