Participated in a Text-to-SQL LLM annotation project using the SuperAnnotate platform. Reviewed natural language prompts and generated SQL queries for accuracy against Databricks databases, progressing from Annotator to QA. Coordinated effectively with multiple global teams across different time zones to meet project deliverables.

Redshift Architect / Glue ELT Developer at Toptal

August 31, 2024 - August 31, 2024

Provided expert service for global clients via Toptal. Built scalable ELT pipelines using AWS Glue, AppFlow, S3 and Redshift; ingested data from backend SQL Server, MySQL, REST APIs (Salesforce, Dynamics 365) and SaaS platforms (Workday, Qualtrics). Architected Redshift data warehouse (schema design, security) and post-ELT processing for analytics and Tableau ingestion. Assisted PostgreSQL RDS deployment and performed Python development for Glue libraries and infrastructure maintenance.

Lead Data Engineer at aCommerce

June 30, 2021 - June 30, 2021

Inspiring data solutions for SE Asia's leading eCommerce provider. Maintained/enhanced Python 3.6 ETL library; ingested data from APIs, direct SQL, and RabbitMQ into AWS S3 Data Lake; loaded and cleansed data into AWS Redshift. Led ETL flows with Python/SQL, Pentaho, and NiFi; Dockerized components; CI/CD with Jenkins; implemented logging (GrayLog) and orchestration (AirFlow/Kubernetes). Built and governed data marts (PostgreSQL on AWS EC2) and supported BI reporting (Qlik Sense).

Lead BI Developer at Allianz

August 31, 2016 - August 31, 2016

Developed BI solutions (Oracle, SAS, Cognos) for SE Asia regional offices; provided backend Oracle PL/SQL support for in-house applications; maintained regional Data Warehouse and supported Global BI platform users.

Database Operations Manager at Rhenus Logistics

October 31, 2015 - October 31, 2015

Provided SQL Server support for SE Asia region; designed and implemented BI solutions for Accounting and Freight Management; authored Omnibus Reporting system (T-SQL) and built a data warehouse updated via SSIS and SQL Jobs.

Data Analyst at John Hardy International

September 30, 2014 - September 30, 2014

Standardized multiple CRM servers (Nav/Dynamics 365) across locations; rationalized back-end SQL Server DBs for distributed querying and population to data warehouse/OLAP cubes; migrated reports (SSRS) and stored procedures.

Chief Data Architect at Blackwood Ventures, Inc.

November 30, 2021 - November 30, 2021

Performed data analysis and created BI solutions for digital/retail clients in SE Asia; analyzed digital campaign data (SQL Server); built backend MySQL databases for web properties; created OLAP cubes (SSAS); modified sales tools (C#, XAML) to support sales leads.

Database Programmer/Architect at Ziios, Inc.

April 30, 2009 - April 30, 2009

Maintained SQL Server 2008 databases for UI development; created stored procedures and tables; used Team Foundation Server for source control and DB schema synchronization.

Math Teacher at The American School Of Bangkok

August 31, 2008 - August 31, 2008

Taught Calculus and Geometry to high school students; led migration of AdminPlus to a web-based CentreSIS architecture to support school operations.

SQL Server Developer at CentreSIS, Global Care Solutions

December 31, 2007 - December 31, 2007

Created UI/DB components and contributed to SSRS-based reporting; performed exploratory data warehouse design (SSAS) on existing databases.

SQL Server Developer at Microsoft

May 31, 2007 - May 31, 2007

Developed T-SQL objects for data import system; built OLAP cubes (SSAS); published data using SSRS; implemented DB synchronization via mirroring and Service Broker.

Access/SQL Developer at Abacus Consulting, Inc.

November 30, 2006 - November 30, 2006

Upgraded Access UI and SQL Server backend; migrated Legacy processing to C#.NET UI; built a legislative bill tracking system with a SQL Server backend.

DB Developer at Fred Hutchinson Cancer Research Center

November 30, 2003 - November 30, 2003

Created middle-tier object library for Call Tracking; designed SQL Server backend; used XML data types for parameterized data exchange.

Database Analyst at Nordstrom

September 30, 2004 - September 30, 2004

Migrated hundreds of stored procedures to new DB schema; leveraged VB.NET and DTS packages to support a major online retail site.

Data Analyst at ICOS

February 28, 2002 - February 28, 2002

Created SAS scripts to summarize Phase II clinical trial data; automated QA checks via SAS macros.

Data Analyst at The American School Of Bangkok

December 31, 2001 - December 31, 2001

Notable earlier role in data-related work; included for completeness of career timeline.

Data Analyst / Programmer at NYLCare Health Plans Northwest, Inc.

July 31, 1998 - July 31, 1998

Produced utilization and cost analysis reports; worked with Access/SQL Server, VB6/VB4 interfaces; supported data warehousing needs.

Health Data Statistician at Pro-West

January 31, 1997 - January 31, 1997

Led sampling, data collection and statistical analysis for healthcare improvement projects across three-state region; automated data cleansing via VBA/Stata.