Cheng Yu Ting
Singapore
Summary
Experienced Data Analyst with over 2 years of expertise in developing data analytics pipeline infrastructure, data extraction, cleansing, and engineering using SSIS and SQL in current company. Skilled in leveraging DAX in Power BI and MySQL for product analysis and visualizations, collaborating with stakeholders to define business requirements, and driving targeted marketing campaigns through in-depth customer behaviour analysis. Passionate about utilizing data-driven insights to enhance decision-making and eager to explore new career opportunities for growth while contributing value to the organization.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Data Engineer
InfoCepts
09.2025 - Current
- Partnered with government agencies to refine their business processes and modernize data operations on the Government Commercial Cloud (GCC). Delivered a scalable and automated solution leveraging AWS Step Functions and Lambda, resulting in improved system resilience and measurable reductions in operational workload
Data Analyst
Bee Cheng Hiang
10.2022 - 08.2025
- Developed and maintained data analytics pipeline infrastructure and data warehousing/data marts using ETL tools like SSIS for an end-to-end project, optimizing data ingestion and processing for analysis.
- Performed data wrangling and data mining with Power BI DAX and SQL to extract insights on product sales and services, enabling analysis and visualizations that supported business marketing strategies.
- Collaborated with stakeholders to gather business requirements, with regards to analysing customer purchase behaviours (Customer Lifetime Value, Product Basket Analysis, Cohort Retention, and Customer Segmentation based on Last Purchase Date) to drive targeted marketing campaigns.
- Enhance business processes by automating reports using Power BI cloud platform and analysing insights through performance metrics and analytical frameworks, driving opportunities for sales growth.
- Worked with cross-functional teams (e.g. Accounts Dept) to analyse large datasets using SQL, resolving data integrity issues such as membership points redemption discrepancies with vendors, leading to a 25% improvement in data accuracy and cost savings.
- Streamlined accounting operations by developing Selenium-based bot scripts to automate the extraction of sales data from different channels (Rakuten, IShopChangi).
Data Analyst Trainee
Workforce Singapore
03.2022 - 08.2022
- Completed a trainee program focused on core data analytics concepts, including data cleaning, visualization, manipulation, feature engineering, feature scaling, and data wrangling, followed by model evaluation.
- Conducted dataset analysis using Python libraries like NumPy and pandas, along with BI tools such as Power BI, to identify key insights and anomalies that could impact sales growth.
Technician II
Singapore Airlines Engineering Co Ltd
01.2017 - 12.2020
- Obtained extensive experience in maintaining B737/B777/A380/A320/B787 aircrafts.
- Proficient and skilled in analysing electrical schematic diagrams and mechanical blueprints.
- Understanding the root of Aircraft defects and solve them to reduce man-hours needed thus improving efficiency.
Education
Bachelor of Engineering (Direct Honours) - Aerospace
SUSS
Singapore07.2022
Specialist Diploma - Data Analytics
Ngee Ann Polytechnic
04.2022
Diploma - Clean Energy
Temasek Polytechnic
04.2014
Skills
- Ability to work both independently and collaboratively in a team
- Effective time management skills to prioritize tasks efficiently
- Effective in stakeholder management to align business objectives
- Communication skills on clear and concise information exchange
- ETL Tools: SSIS
- Programming & Databases: Python, SQL (SSMS, MySQL, PostgreSQL), SQL Stored Procedures
- Data Visualization: Tableau Desktop, Power BI
- Microsoft Office Suite: Excel, Word, PowerPoint, Access, Visio, Power Automate
- Cloud Computing: AWS services (S3, Glue, EMR, CloudWatch, Athena, Step Functions, Lambda Functions, EC2)
Certification
- AWS Certified Solutions Architect Associate – AWS (Certified in Apr 2025)
- Certified Tableau Desktop Specialist – Tableau (Certified in Mar 2025)
- AWS Certified Cloud Practitioner – AWS (Certified in Dec 2024)
- Microsoft Certified: Power BI Data Analyst Associate – Microsoft (Certified in Dec 2024)
- AI200: Applied Machine Learning – Heicoders Academy (Certified in May 2022)
- Data Science Introductory – Hackwagon Academy (Certified in Apr 2021)
Timeline
Data Engineer
InfoCepts
09.2025 - Current
Data Analyst
Bee Cheng Hiang
10.2022 - 08.2025
Data Analyst Trainee
Workforce Singapore
03.2022 - 08.2022
Technician II
Singapore Airlines Engineering Co Ltd
01.2017 - 12.2020
Specialist Diploma - Data Analytics
Ngee Ann Polytechnic
Diploma - Clean Energy
Temasek Polytechnic
Bachelor of Engineering (Direct Honours) - Aerospace
SUSS