Lim Wee Kiat

Data Analyst

Transforming data into insights for smarter decisions.

About Me

Data & Business Intelligence Specialist with 10+ years of experience driving performance through data storytelling, automation, and actionable insights. Proficient in SQL, Power BI, Tableau, and cloud platforms, with a proven record of reducing costs and enabling data-driven decisions. Approach challenges with a mindset of lifelong learning and curiosity.

Proficiencies

Data Analytics & Visualization

✓ SQL (MySQL, Oracle, Azure SQL, SSIS)

✓ Tableau

✓ Power BI

✓ MicroStrategy

✓ Excel (Certified)

✓ Google Analytics

✓ Descriptive & Predictive Analytics

✓ Data Visualization

Business & Project Management

✓ Vendor Collaboration

✓ Stakeholder Communication

✓ User Acceptance Testing (UAT)

✓ Microsoft Word

✓ Microsoft PowerPoint

✓ Pega CRM

Cloud, AI, Security & Automation

✓ Amazon Web Services (AWS)

✓ Microsoft Azure

✓ Python

✓ Risk Management

✓ Threat Analysis

✓ JavaScript

✓ Django

✓ Azure AI Services

✓ Web Scraping

✓ API (Postman, JSON)

Certifications

Microsoft Certified: Power BI Data Analyst Associate

Microsoft

(Jun 2024 – Jun 2026)

Tableau Certified: Tableau Desktop Specialist

Tableau

(Jul 2024)

Google Analytics Certification

Google

(Sep 2024 – Sep 2025)

Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps)

Microsoft

(Jun 2024)

AWS Certified Cloud Practitioner

Amazon Web Services

(Jul 2024 – Jul 2027)

Microsoft Certified: Azure AI Fundamental

Microsoft

(Jun 2024).

Microsoft Certified: Azure Data Fundamental

Microsoft

(Jun 2024)

CompTIA Security+ CE Certification

CompTIA

(Mar 2025 – Mar 2028)

Experiences

Systems Analyst

Bee Cheng Hiang Hup Chong Foodstuff Pte Ltd

2022 Aug – Present

Built a dynamic SSIS ELT pipeline with schema validation, execution logging, and alerting, enabling seamless raw data ingestion from MySQL to SQL Server, reducing manual intervention.
Cleaned and modeled data from MySQL and SQL Server into fact and dimension tables, resolving source-level discrepancies to improve data quality and enable accurate business reporting.
Presented data driven insights on procurement strategies and payment gateway performance, enabling leadership to make cost effective decisions.
Conducted AWS cost analysis and identified optimization strategies, proposing a new subscription plan that reduced cloud expenses by 42%.
Led stakeholder management and proposed technical solutions, aligning development with business needs and coordinating with vendors to deliver seamless app and web integration.
Discovered and reported 100+ bugs during UAT, reducing post launch issues.
Developed automated daily file downloads using Selenium and python, saving 1 hour per week.
Managed AWS IAM policies and implemented basic security monitoring, ensuring compliance and preventing potential incidents.

E-Commerce Seller (Self-Employed)

Lazada & Shopee

Apr 2018 – Jul 2022

Analyzed sales and inventory data to maintain a 95% product availability rate, balancing stock levels to prevent overstock and shortages.
Implemented bundling strategies, doubling average transaction values and boosting sales.
Tracked and analyzed KPIs (conversion rates, customer acquisition costs, ROI), adjusting marketing spend to achieve a 10% increase in ROI and a 10% improvement in conversion rates.
Gathered 3,000+ positive reviews to enhance product positioning and sales performance.

Senior Business Analyst

M1 Limited

Apr 2015 – Mar 2018

Preprocessed and cleansed large datasets, ensuring high data accuracy and completeness for business intelligence use.
Integrated and transformed data from Excel, CSV, and Oracle databases, creating comprehensive datasets for analysis and reporting.
Developed interactive dashboards aligned with business objectives, delivering insights into acquisitions, churn, renewals, and campaign performance to support faster decision-making.
Collaborated with stakeholders to gather requirements and deliver recurring performance reports supporting campaign tracking and customer segmentation.
Forecasted sales trends and analyzed customer behavior to recommend target segments, improving campaign take-up rates within budget.