Ken Tham

Experience

• 

  6 SIR

  Mar 2012 - Mar 2013

  Section Commander & Armskote In-Charge

  • Took charge of 6 soldiers’ welfare, accommodation, development and soldiering abilities.• Worked in a group of 5 commanders to coordinate 30 soldiers and execute daily operations.• Handled phone calls and made appropriate coordination between soldiers, superiors, companies and departments.• Responsible in accounting of 200 Weapons and >2000 Controlled Equipment• Ensured proper paperwork done at all times in any transfers/loans of weapons for daily, weekly, monthly and audit checks.• Ensured all equipment and weapons to be issued to 120 soldiers in 90 minutes for their missions. • Cross-checked various documents to ensure accuracy.• Assisted the Company to be known for having the best Armskote in the Battalion. Show less

• 

  Bowring Marsh Asia

  Jun 2013 - Dec 2013

  Claim Admin Officer

  •Worked in a group of 4 to coordinate and provide claims updates to reinsurers and clients world-wide.•Improved current, and created new, spreadsheets for the claims department that better tracked claims updates and its related financial account.•Managed and maintained >500 claims in both soft-copy and hard-copy files and ensuring all are up to date.

• 

  Amoeba Software Studio

  May 2016 - Aug 2016

  Business Development Intern

  •Develop a User Acceptance Test plan for an adaptive learning web application. •Perform statistical tests on students' performance in correlation with the usage of the web application.•Analyse the effectiveness of the web application and provide insights that can improve the functions based on data analysis.

• 

  Yamato Transport (S) Pte Ltd

  Jun 2018 - May 2020

  Management Executive

  Operational Analysis• Performed ABC Analysis and Statistical Demand Forecast on shipping orders to optimise picking locations, increasing operation efficiency by 10%.• Analysed customers’ operation needs, volume trend, operation capacity and prescribed solution to optimise resource planning in Delivery operations.• Geocoded more than 200,000 delivery locations for plotting on Google My Maps to perform geospatial analysis and identified areas of unprofitability.• Designed dashboards on MS Excel to monitor inventory and parcels’ follow-up statuses.Operational Improvement• Mentored and led 3 Quality Control project teams of 4 to improve operational efficiency using DMAIC methodology.• Revamped Customer Service’s processes for an account and designed a new database in MS Excel to improve data quality, reduce error and automate report-generation, increasing efficiency by 60%.• Designed effective staff database management system on MS Excel, and used gap analysis of skills proficiencies for planning of cross-training.• Implemented a simple supervised machine learning logic and process in MS Excel to automate cleaning on dataset of names, reducing time spent by 90%. Corporate Reporting & Sales Support Analysis• Derived a better variable to measure operational capacity and applied Logistic Regression analysis to devise a transparent pricing model for Over-Time charges.• Consolidated financial reports timely and accurately for regional reporting.• Performed quarterly financial variance analysis between previous and current year.• Designed simulation report for Profit/Loss, volume forecast for managers based on various variables. Show less

• 

  UPS

  May 2020 - Nov 2020

  Pricing Analyst

  • Provide competitive pricing by using competitor analysis while supporting sales requests, and maximising profitability by analysing the marginal operating ratio of Freight Forwarding trade lanes. • Design and enhance dashboards using PowerBI to perform data modelling from various database sources for the Pricing team’s ease of analysis.• Using MS Excel to input multiple data-cleaning logic to automate data cleaning process, reducing data preparation time by 80%.• Redesigned the database format of excel file for analysis, reducing error and time spent in analysis improved analytical flexibility, file size, processing speed and visualisation customisability—outperforming previous built-in macro automation version. Show less

• 

  IDEMIA

  Nov 2020 - Jun 2021

  Data Analyst

  Build 4 interactive and flexible dashboard on Excel that can be used for data exploration for the laymenInvestigate and reconcile the calculation logic between reporting tools used from different database sources.Successfully automate reports for all 6 operation sites that handle 50 million rows of data to replace current reporting system using PowerBI, reducing time spent by 70%

• 

  UPS

  Jun 2021 - Feb 2024

  Revenue Management Marketing Analyst

  - Re-structure all unstructured excel data into a normalised database format, laying down the foundation for automation of reporting, data visualisation and optimisation of data modelling, increasing analytics efficiency by 70%- Automate compilation and data restructuring of competitors' PDF files via Power Query for ease of competitive monitoring & analysis- Used Python to reduce data granularity and pivot data into a manageable size for excel users to perform analysis- Mapped out every Freight Flight Network distance between airports in the world and perform a cost analysis to optimise the zoning of destination countries- Worked with a team of 5 to start a digitalisation project using PowerApps and Power Automate, and create an Application (Minimum Viable Product) for Sales to query information from various Marketing Teams and emerged as Winner of Jumpstart Bootcamp. Show less

• 

  Ocean Network Express

  Feb 2024 - now

  Assistant Manager Global Service Management

  Provide business insights to improve service quality through statistical analysis & AB testingEnhance looker explore and dashboardsPerform UAT on dashboard enhancements & creations