Jialing Guo

- Optimized logistics-related SQL code, reducing it from 196 lines to 73 lines with an optimization rate of 62.76%, and used it as a fact table in the new data pipeline - Conducted a thorough review of PG and WMS databases, detailing fields, inter-table relationships, primary keys, and foreign keys in a comprehensive reference document - Utilized SQL in Hive and Redash to address business data requirements and employed Tableau for insightful data visualization - Analyzed time points throughout the entire international supply chain process, monitoring logistic delay statuses

- Utilized Lean Six Sigma methodology and FMEA techniques to propose improvements for motor quality in mass production, leading to a 3% rise in product qualification rate and a 7.5% enhancement in OEE - Contributed to the APP310 modification project, secured a 32% cost saving, and illustrated the project's material flow and process flow diagrams by evaluating technical and product quality parameters - Analyzed vast amounts of production data using Minitab's measurement system analysis, quality analysis, and statistical process control functions - Calculated production cycle time and OEE for Stator, Rotor, impregnation, and ZSB components - Proficient in using AutoCAD to draft motor component diagrams - Evaluated processes and technical requirements, optimizing production concepts based on in-depth analysis

- Familiarized with the sorting center’s layout and the operational flow of modules such as inbound, ferry, and matrix - Suggested path optimization in workstations, used FlexSim for simulation, and implemented changes, leading to a 6.4% boost in warehouse efficiency - Utilized motion analysis to optimize workers' movement paths, resulting in a 5.2% increase in unpacking efficiency

- Organized team meetings about rack layout and AGV car's routine in consideration of improving the package-picking procedure, assigned tasks, and dealt with the unexpected issues that occurred during the project. - Proposed to locate the least efficient part in the overall system using the concept of the bottleneck operation, optimized the rack's layout, and increased AGV car's number. - Calculated the quantity and characters of the warehouse rack and the warehouse’s area needed and designed the rack’s layout and AGV car’s routine in view of the cost and efficiency. - Presented the team plan and carried out the defense on behalf of the team.

- Learned the basics of production scheduling, optimization algorithms, and computational complexity theory and discussed surrounding P, NP, NP-complete, NP-hard, and dynamic planning. - Conducted the calculations in functions using genetic algorithm and programmed in MATLAB to achieve the functions. - Analyzed the background of genetic algorithms, concepts related to biological evolution, main elements of algorithms, algorithm processes, etc., and concluded the basic steps to solve problems using genetic algorithms. - Summarized the background of the Particle Swarm Optimization application, main elements, algorithm flow, instance code implementation, etc., and produced and presented a PPT report focusing on smart manufacturing.