Thomas Lei Email & Phone Number

Chicago, IL, US

London, GB

Elk Grove Village, Illinois, US

• Data Analysis and Reporting Automation: Developed and automated comprehensive sales and inventory reports using Excel macros, significantly reducing manual work and increasing efficiency in generating detailed reports.
• Inbound and Outbound Shipment Management: Coordinated inbound and outbound shipments, including scheduling pickups, creating and validating Bills of Lading (BOLs), and ensuring timely delivery of goods to major clients
• Issue Resolution: Investigated and resolved discrepancies in shipments, such as missing cases and short shipments, by liaising with logistics partners to ensure accurate and timely delivery​
• Vendor and Supplier Management: Maintained communication with suppliers and vendors to ensure the timely delivery of materials and supplies, including managing inventory levels and resolving issues related to damaged.
• Standard Operating Procedures (SOPs): Created and refined SOPs for key processes, including shipping, order fulfillment, Amazon restocking, and vendor management, leading to improved efficiency and reduced errors​
• Interdepartmental Coordination: Collaborated with warehouse, IT, accounting, and sales teams to address operational challenges, implement process improvements, and ensure alignment across the supply chain

Japan, Taiwan, Mexico

Irving, Texas, US

• Created and maintained a dynamic Power BI dashboard on the most problematic part numbers and suppliers for upper management to easily access and visualize the most updated data
• Created reports on dual-sourcing for supply chain risk evaluations
• Analyzed data on problematic suppliers and located critical gaps in supply
• Utilized Snowflake to reduce the time and labor needed to obtain updated data for dashboards
• Trained new interns and created comprehensive standard work documents that new employees could reference

Irving, Texas, US

• Created new compliance dashboards that allowed management to view its performance in multiple areas while locating areas where individuals or teams can improve.
• Utilized Python to automate and combine multiple Excel file calculations, eliminating the time for updating compliance datasets by 99%.
• Analyzed multiple datasets and created a new dataset structures and drill-through-capable visualizations for use in supplier relationship management.

• Initiated and moderate a Discord server for students in the Gies College of Business
• Have drawn over 750 students to join to discuss and gain support in academic, professional, and personal ventures
• Provide and organize online resources and reminders for students

Champaign, IL, US

• Led a team of students on a project for Caterpillar's Aftermarket Parts Division:
• Analyzed aftermarket parts data and identified problems and inefficiencies
• Utilized Python to create a script that automatically cleans and prepares data for an algorithm
• Presented findings to CAT employees

Fargo, North Dakota, US

• Scanned and organized over 3000 pages of employee paperwork
• Digitally organized employee paperwork in their portal for HR to easily reference

• Determined key data measurements to track such as Daily Active Users, Retention Rate, and Session Time
• Utilized Excel to analyze data on cancer statistics on patients from the US, UK, and Canada for marketing uses
• Researched and organized cancer organizations into a chart for My Care Crew to contact about partnerships
• Tested and provided feedback through Apple’s TestFlightWebsite: https://mycarecrew.co/

• Taught English in a rural, disadvantaged area of Taiwan for 4 weeks
• Created a teaching schedule that could easily accommodate unexpected events
• Taught over 20 students English vocabulary and American gamesTheir Website: http://aidsummer.net/aidsummer/2019/bin1/InfoAdm1.aspx?pg=1&Index=1&ID=201

Rutherford, New Jersey, US

• Tutored over 25 kids for the Math department at Kumon
• Graded and organized math homework and tests

Bachelor'S Degree, Supply Chain Management, Information Systems

High School Diploma