Andrew T.

Experience

• 

  Abbott

  May 2016 - Aug 2016

  Logistics Intern

  Key Responsibilities:- Streamline the Receiving Process using Industrial and Systems Engineering methods - Perform import shipment tracking and coordinate closely with 3PLs (Sankyu, DHL, APL)Key Takeaways:- Streamlined the receiving process for materials coming into Abbott Manufacturing (AMS) warehouse with reduction in work duration for Goods Received (GR) document and collection of inventory goods by 52.8% and 40% respectively- Analysed the working process of shop-floor workers and proposed a standard work based on human factor engineering- Performed import shipment tracking and coordinated closely with 3PLs as well as AMS planning and procurement department with zero error Show less

• 

  SIA Engineering Company

  Aug 2016 - Apr 2017

  Student Consultant

  Key Responsibilities:- Analyse the historical data of aircraft spare parts from the database using statistical methods- Create a platform for the company to better forecast its aircraft spare parts so as to minimise the number of Aircraft on Ground (AOG)Key Takeaways:- Reviewed and analysed various processes in SIAEC and successfully identified a pressing problem - Organised and analysed 3 years worth of historical data of over 1,333 unique rotables part numbers according to name of airline, part number, part description, request date which allows the management to review the data more efficiently- Successfully created and validated a forecasting platform that is able to produce monthly forecasts for rotable spare parts and complements the current IP by providing detailed forecasts of demand in each time interval. If implemented, it can significantly improve and minimise the total Mean Squared Error (MSE) for forecasting of aircraft spare parts which helps to eliminate the problem of Aircraft On Ground (AOG) situations which can cost up to USD$10,000 per hour Show less

• 

  Seagate Technology

  Mar 2017 - Mar 2018

  Sales Executive

  Key Takeaways:- Managed a portfolio of over 100 B2B clients, including enterprise-level organisations, smallbusinesses and schools- Successfully increased annual revenue by an average of 15% year-over-year through upselling andcross-selling efforts with existing clients and acquisition of new accounts- Coordinated with the marketing, engineering and customer support team to better position Seagateproducts and execute inventory planning to achieve sales targets

• 

  Kimberly-Clark

  Aug 2017 - Apr 2018

  Project Intern

  Key Responsibilities:- To understand and analyse the current processes for the manufacturing of the wet-tissue based product- To create current and future Value Stream Mappings (VSMs) for all manufacturing processes in the plant- To evaluate the benefits of implementation of WMS using Industrial and Systems skill sets and toolsKey Takeaways:- Successfully created the current state VSMs, a lean manufacturing tool for all processes of the production of wet wipes. The current state VSMs will allow the management to better understand and visualise their business models and the flow of production. Additionally, it also allow the management to quickly identify key muda (waste) processes for better decision making and improve its cost efficiency- Proposed the future state VSM for the receiving and storage of finished goods and recommended technology enhancement to the company’s current manual recording process- Applied mathematical calculations and analysis, the implementation of the future state could potentially eliminate the time wasted in recounting due to mismatch in quantity- Streamlined the export process in receiving of finished goods which could reduce the number of processes by as much as 50%, manpower hours by 70% and a potential savings of $21,000 - $41,953.95 per annual- Validated the amount of time and cost savings using simulation and statistical analysis- Created a self-guide document on how to perform simulation modeling for time savings validation Show less

• 

  Singapore Sports Hub

  Nov 2019 - Jun 2021

  Data Analyst

  Key takeaways:- Designed customer demographics and ticketing transaction dashboards with the marketing and commercial teams to analyse events and patrons’ purchasing pattens for marketing strategies development - Automated and streamlined data computation process, which allowed 50% reduction in the monthly venue reporting process to the management board- Facilitated the implementation of SAP S/4 HANA, SAP Analytics Cloud into the organisation and supervised financial reporting capabilities to the finance team- Analysed National Stadium F&B concessions’ sales figures and identified trends, patterns, and gaps in potential earnings for the F&B management team to increase revenue through new business models Show less

• 

  InfoCepts

  Jun 2021 - Sept 2021

  Data Scientist

  Key takeaways:- Worked closely with external clients and consolidated different business requirements from stakeholders to enhance dashboards interface for better visualizations and responsiveness so as to improve users' experience- Successfully designed a dashboard to track loading and output quantity for the client with zero error which allowed users to monitor their KPI and fulfil their monthly work orders- Validated the data from different operation data sources using Microsoft SSIS as part of data quality assurance Show less

• 

  Apple

  Aug 2021 - Apr 2022

  Allocation Execution Specialist

  Key responsibilities:- Analyzed backlog data and allocation to execute through SAP in support of operational metrics- Resolved disputes and discrepencies submitted by various channels and partners to fix issues gatingcustomer shipments through recovery actions, root cause analysis and brainstorming preventive measures- Provided updates on the current supply and backlog picture to the Supply and Demand Execution team- Worked with regional and worldwide cross functional teams to ensure the smooth delivery of Quarter End, Springback FY2022 and new product (NPI) launch Show less