Skip to main content
Wendy ChaiWC
Open to opportunities

Wendy Chai

@wendychai

Analytics Developer specializing in SQL development, data modeling, and scalable pipeline optimization.

Malaysia
Message

What I'm looking for

I’m seeking a role that leverages my SQL and data modeling background to focus on advanced data architecture and scalable engineering frameworks, building more impactful, data-driven solutions.

I’m an Analytics Developer with over 4 years of experience across analytics and data roles, specializing in SQL development, data modeling, and pipeline optimization. I focus on improving the reliability and usability of complex, legacy data backends.

In my current role, I led complex SQL development and optimization projects with independent ownership of legacy data areas to improve backend robustness and query performance. I built and maintained end-to-end data pipelines for global supply chain operations, acting as a primary point of contact for complex data issues.

I also develop KPI-focused Tableau dashboards and drive team alignment by documenting standard operating procedures (SOPs) and data workflows in Confluence and Miro. To reduce technical debt, I audited and cleaned large-scale datasets in Google BigQuery to prepare environments for future-state analytical models.

Previously, I managed APAC forecasting data processes, reduced reporting timelines through Power Query-based validation, and maintained Power BI dashboards for key stakeholders. Earlier, I automated data transformation with Python and SQL ETL scripts, monitored daily ETL operations, and ensured data integrity using Excel control workbooks with Power Query and VBA.

Experience

Work history, roles, and key accomplishments

Mattel logoMA
Current

Analytics Developer

Dec 2024 - Present (1 year 6 months)

Led complex SQL development and optimization projects by taking independent ownership of legacy data areas to improve backend robustness and query performance. Built and maintained end-to-end data pipelines and created Tableau dashboards for global supply chain KPI reporting while documenting SOPs and data workflows to support team collaboration.

Reinsurance Group of America logoRA

Business Administration Analyst

Jan 2022 - Aug 2023 (1 year 7 months)

Developed automation solutions for data transformation processes using Python and SQL, significantly reducing manual processing time to ensure timely data delivery for stakeholders. Wrote and debugged ETL scripts, monitored daily ETL operations against a five-day loading window, and maintained Excel control workbooks (Power Query and VBA) to validate post-load data integrity.

Education

Degrees, certifications, and relevant coursework

UCSI University logoUU

UCSI University

Bachelor of Science, Actuarial Science

Completed a Bachelor of Science in Actuarial Science at UCSI University in 2021.

Tech stack

Software and tools used professionally

Find your dream job

Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan