Lai Chun Kit

Junior Data Analyst at CG Ikhlas, Malaysia

Tanjong Malim, Perak. Open to hybrid work and relocation to the Klang Valley.

Monthly reporting: 2 days to 2 hours through automation

vaniepersie@gmail.com +60 17-514 2980 WhatsApp GitHub

Download my CV PDF Data analyst, one page

For data-engineering roles: analytics engineering CV

Lai Chun Kit

I analyse sales, ads and competitor prices for four stores, present findings to the Honeywell and ASUS Business brand teams, and build the reporting tools.

Selected work

Screens are shared with my employer’s agreement. Real figures are hidden or replaced with made-up ones.

Monthly ads, sales and order reports for four stores

2026 to present

Monthly sales and order reports for four stores on Shopee, Lazada and TikTok Shop; ads analysis for Shopee and Lazada.

Reporting fell from about two days to two hours.

  • Built browser tools and import checks for store, month, duplicate files and missing data.
  • Review confirmed orders, ad returns and wasted keyword spend to guide budget and campaign changes.
Honeywell June ads review page with spend, sales and ROAS figures hidden (opens larger view)
Honeywell’s June ads review, the page I take to the brand team. Figures are hidden.

Reporting process and screenshots Worked example: from ROAS to a recommendation

ASUS monthly business review

May to Aug 2026

Prepared and presented four monthly ASUS Business reviews covering sales, the shopping funnel, ad returns and next month’s plan.

One data file kept the full deck, meeting deck and web review consistent.

ASUS May to June review deck, opening slide with figures hidden (opens larger view)
Opening slide of the May to June deck. Figures are hidden.

Review decks and screenshots

Competitor price checks in Excel and Python

Aug 2025 to Jan 2026

Automated Shopee competitor checks with Python collection and an Excel workbook covering 28 brands.

Daily checks grew from about 40 to 250 products during my internship.

  • Compare each product with the three cheapest sellers and flag a suggested price action.
  • Use VBA, Power Query and lookup formulas to organise products and keep brand sheets consistent.
Excel brand sheet: made-up products with our price, three sellers' prices, suggested price, status, action, reason, gap and priority, colour-coded (opens larger view)
A brand sheet with made-up products. The mouse is 11% above the cheapest seller, so the sheet says “Lower price now” and suggests RM120. The formula bar shows the formula behind the Action column.

Workbook, formulas and screenshots

Research and competitions

2024 to 2025

  • Final-year research, 2025. Forecasting Tesla market movement from news sentiment, comparing a statistical model with a neural network; nominated for Student Research Day 2025. Poster Slides Faculty post
  • RASIO 8.0 Data Science Competition, Oct 2024. Led the team that placed third (Universitas Padjadjaran, Indonesia) with an ASEAN economic recovery dashboard. Slides Certificate
  • Nomsim, 2024. A game that teaches savings and loan choices; silver (Perak) award at Karnival Inovasi@UMT 2024. Play Slides Screenshot Certificate

Also built: tools for the team

Marketplace intelligence platform

Jan 2026 to present

Built the reporting platform, used by about 10 staff on the company server.

New data and uncertain AI product labels wait for staff review.

  • Designed the workflows, data rules and checks; used AI coding assistants for most code, then reviewed and tested changes.
  • Combined ads, income and competitor prices with staff permissions, change logs and release checks.
Single Analysis page asking Is our price right?, with an AOC monitor selected and similar listings below; prices hidden (opens larger view)
“Is our price right?”: staff pick one of our products and compare it with the other listings. Prices are hidden.

Platform, review controls and screenshots

Finance apps: supplier claims and project profit

Feb 2026 to present

Built two finance apps for supplier claims and project profit, sharing the platform’s sign-in.

The claims app replaced a spreadsheet; approved profit statements are locked.

  • In supplier claims, check AI-extracted invoice or proof rows against the printed total and send differences for human review.
  • Track claim payments and credit-note allocations, and prevent duplicate or stale submissions.
Claim proof preview: four item rows read by the AI total RM1,780 against a proof total of RM1,840; made-up data (opens larger view)
The AI has read the proof’s rows, and the total check shows they are RM60 short. Made-up data.

Finance workflows and screenshots Worked example: catching an invoice mismatch

Experience and education

Jan 2026 to present

Junior Data Analyst, CG Ikhlas Sdn. Bhd.

Income and order reporting for four Shopee, Lazada and TikTok Shop stores. Present monthly Shopee and Lazada ads analysis to the Honeywell and ASUS Business brand teams. Cut monthly reporting from 2 days to 2 hours. Built the marketplace reporting platform and two finance apps with AI coding assistants.

Aug 2025 to Jan 2026

Data Analyst Intern, CG Ikhlas Sdn. Bhd.

Automated weekly Shopee price checks and Excel price comparisons (VBA macros, Power Query, XLOOKUP). Built a campaign and discount data tool with checks before use; wrote SOPs and handover notes.

Jul to Oct 2024

Insurance Claims Specialist (part-time), EY Auto Workshop

Claim documents, workshop quotes and follow-up for vehicle damage claims at a vehicle repair workshop in Tanjong Malim.

2022 to 2026

BSc (Hons) Financial Mathematics, Universiti Malaysia Terengganu

Conferred October 2026. CGPA 3.83.

Skills

Analysis
SQL, Python (Pandas), Excel, Streamlit, Power BI (basic). ROAS, CTR, GMV, conversion, funnel, fee and margin analysis on Shopee, Lazada and TikTok Shop data.
Excel
VBA macros, Power Query, XLOOKUP, LET, FILTER and SORT, structured tables, pivot tables and charts, conditional formatting, drop-down lists.
Data collection
Chrome extensions to download marketplace reports, Python automation and import checks.
Web apps
Flask, SQLAlchemy, SQLite, JavaScript, Jinja; PostgreSQL migration in progress.
Testing and release
Git, GitHub Actions, Docker, automated tests (pytest, Playwright).
AI integration
External AI model APIs, with checks on AI answers, confidence thresholds, human review and change logs.
Modelling
Classification (scikit-learn), time-series forecasting (ARIMAX, LSTM), sentiment analysis.
AI coding agents
I plan tasks, write instructions, and review and test every change before merge. AI coding assistants write most of the code.
Languages
Mandarin, Cantonese, English, Malay. Japanese at about B2 (self-assessed, not certified). Korean at a basic level.

Contact

I’m seeking data analyst roles in e-commerce, ads and marketplace reporting, especially report automation. I’m also open to junior analytics engineering roles.

Expected salary
RM4,500 to RM6,000 a month
Start date
Negotiable; I’m currently employed
Location
Willing to relocate to the Klang Valley; open to hybrid work