Ray Peng Email & Phone Number

Majored in Management Science undergrad at NCTU and now mastered in Business Analytics in UTD. Summer intern in Engineering Consulting company last year. Now seeking a full-time opportunity in the data analytics field. Had experience using python, tableau, SAS, R, Power BI on past projects. Advanced knowledge using Excel functions and other Microsoft Access.

• 

  Material Analyst

  Sms Infocomm

  Mar 2022 - Present - Grapevine, Texas, United States

  • Oversaw and supervised the demand for out-of-warranty HP computer hardware in Northern America, successfully maintaining an order backlog rate below 3% across a portfolio of over 20,000 diverse commodities. Functioned as a key contributor to one of the largest suppliers, reviewing the product pipeline and implementing alerts for parts projected to have insufficient stock levels.• Developed a schema by integrating data from five distinct sources within an on-premises enterprise system, emphasizing data integrity. Implemented SQL in the preprocessing stage and introduced a Python-based auto-report system to mitigate inaccuracies steaming from manual pipeline updates. Achieved a 40% reduction in the time required for pipeline review.• Led a temporary project for a period of six months to transition the original ordering system. Proactively restructured and continually enhanced the strategy and workflow to accommodate evolving customer requirements. Maintained seamless communication with customers and adeptly addressed material escalations, ensuring effective resolution.• Utilized Excel and implemented VBA to generate two daily reports and two weekly reports. Collaborated with a team of four analysts to establish logical frameworks and effectively managed working priorities across six warehouse functions. Strategically optimized workflow synergy to meet customer expedites and projected consumption requirements.• Diagnosed bottlenecks in evaluating customer ordering issues. Delivered effective solutions or alternatives to customers and maintained efficient and impactful communication.