LALIT GUPTA

+1-832-***-**** admqgz@r.postjobfree.com Houston TX

SUMMARY

Supply chain operations analyst with about 3 years of experience in order processing, demand planning, forecasting, inventory management, supplier management, supply chain analytics, process improvement, six sigma, and lean

Interested in developing unique capabilities in order management, supply/demand planning functions based on JIT, six sigma, lean tools, and supply chain analytics

Proven skills in MS Excel, MS Access, SQL, Power BI, SAP for analytical modeling, planning, reporting, and forecasting

Supported and helped stakeholders, businesses in automating dashboards and creating analytical models, which helped reduce the data processing time to produce KPI’s by 30% - 50% and make data-driven business decisions to bring in the business value

SOFTWARE SKILLS

Power-Query

MS Access

MS PowerPoint

MS Visio

Power Pivot

MS Excel, VBA

MS Outlook

MS Project

Power BI

SQL

MS Word

MS Share Point

PROFESSIONAL EXPERIENCE

Hewlett-Packard Inc., Houston, TX

PARTNER BUSINESS MANAGER Jan 2019 to Present

SUPPLY CHAIN OPERATIONS ANALYST

Spear-headed meetings with planning and R&D to communicate NPI product requirements, technical design, receive notable feedback on RFQ proposal

Designed user-friendly analytical Power BI Dashboards to quantify on-time quote validation process, the dashboard helped in performing root-cause analysis which incredibly improved entire validation process. This resulted in a 90%-time reduction and heavily boosted employee performance

Acted as Liaison between Original Design Manufacturer and HP teams for regulatory cert. cost negotiation, addressing end-user product issues, communicating semi-annual product refresh requirements, assessing Document Change Reviews, and providing approval

Product end of life extension costs, non-recurring expenses for product updates led to almost 500k savings for HP

Created the cost upload process for labels by developing a robust macro which reduced the quote completion time by 70%

Significant time reduction in Graphics Card monthly quote process by automating the part pricing upload process and increasing the efficiency of the overall process by 95%

Worked with demand/shipment planners to ensure the right availability of inventory and timely shipment of products.

Support and communicate with managers in resource planning, creation of purchase requisition, and purchase orders.

Simulated and optimized logistics model for label manufacturing, minimized the logistics cost by 15%, inventory holding cost by 30% percent which resulted in annual savings of $75k

Weir Oil & Gas, Fort Worth, TX

INDUSTRIAL ENGINEER Summer 2018

Worked on iron refurbishment process improvement to improve the work efficiency, delivery process, orders in the queue, raw material acquisition, and service center management

Implemented various Six-sigma and Lean principles to improve the overall efficiency and equipment service throughput

Automated the Risk Assessment process by utilizing VBA programming. Developed automated tools to enhance the user experience with the projected process time reduction of 90%

Conducted multiple test scenarios with different refurbishment techniques to consider an effective iron refurbishment method

Researched iron cleaning techniques and analyzed the capital investment linked with each process

Performed time studies and developed a realistic business case with Return of Investment and projected time reduction of 80% with capital investment payback of 12 months

Utilized Toyota Production system techniques to eliminate overburden, inconsistency, and eliminating waste in the existing process

Designed a Simulation model of the overall refurbishment process to plan for overall machine utilization, resource utilization, capacity planning, inventory planning, and throughput analysis.

CORE COMPETENCIES

Supply chain analytics Inventory management Project management Logistics ERP MRP Procurement Six Sigma

Process improvement Lean Management Demand Forecasting Demand planning & fulfillment Network optimization

Distribution management Shipment planning Linear optimization Transportation modeling Product management

Warehouse management Budget management Vendor analysis Simulation modeling

CERTIFICATIONS

Lean Green Belt (IISE)

EDUCATION

BS Industrial Engineering The University of Texas at Arlington Graduated December 2018

Contact this candidate