Tommy Wei

Detail‑oriented Data Specialist with 7+ years of experience across SQL development, ETL engineering, data quality, data transformation and enterprise reporting. Strong track record of troubleshooting complex data issues, optimizing queries, and supporting large-scale data environments across finance, healthcare, and SaaS organizations. Adept at transforming messy client data into clean, structured formats for operational use, and debugging code and scripts.

Seeking opportunities in data analyst, data reporting, or SQL-focused roles. Laid off from my current role at AdvancedMD

Data Services Specialist - AdvancedMD

(2021-05 - 2026-05)

Resolved complex client data issues. Cleaned, restructured, and validated large Excel datasets for migration into AdvancedMD while collaborating with internal production teams to verify data accuracy and ensure successful client go-live readiness. Worked with implementation to coordinate data conversion process allowing clients to transition into AdvancedMD with as much data as possible.

• Successfully converted and migrated data for 150+ healthcare clients from source to live environments, ensuring data integrity and alignment with AdvancedMD system requirements while loading as much data as possible for the client
• Wrote sql scripts to update and modify the data according to client requirements. Also reviewed and tested other sql scripts for other clients before changes were made to the live environment.
• Worked with large scale clients who required extensive support and had tight deadlines. Made myself available on the weekends, worked afterhours, and was able to load data by specific timeframes to ensure their data was migrated on schedule. Transferred large amounts of data ranging over 400,000 patient records and 1,000,000 encounters
• Worked with high priority escalated clients to get data transferred over quickly and efficiently
• Assisted team members whenever needed. Helping with general client support questions, data transformation questions, conversion requirements, or other technical code related questions. Boosted team morale and productivity.
• Collaborated with implementation, validating test and live environment configurations by conducting cross-system integrity testing, while being HIPPA compliant
• Analyzed over 1 million+ healthcare records using advanced SQL queries and data cleansing techniques, identifying structural inconsistencies, formatting errors, and data quality gaps prior to staging and transferring the data into live environments
• Maintained detailed documentation and audit-ready records across healthcare implementation projects using JIRA and Confluence

ETL Engineer (Contract) - SPH Analytics

(2020-12 - 2021-03)

Analyzed Oracle-based EHR data models to support complex client reporting requirements, developing and maintaining SQL extraction queries for EMR data used in downstream analytics and reporting. Investigated data inconsistencies, validated extracted datasets, and refined extraction logic to improve data accuracy, reliability, and reporting quality

Associate Application Support Engineer - Q2 Software

(2020-05 - 2020-11)

Supported financial institutions utilizing Q2's digital banking platform by troubleshooting production issues related to money transfers, authentication, file exchange workflows, APIs, SDKs, and system integrations. Wrote T-SQL scripts to perform production and non-production data corrections, while collaborating with DBAs and engineering teams to analyze and optimize SQL performance, improving system reliability and operational efficiency.

Programmer Analyst - Texas Medical Liability Trust

(2019-07 - 2020-02)

Investigated and resolved data accuracy and reporting issues by troubleshooting PL/SQL scripts, stored procedures, and SQL queries for enterprise reporting systems. Developed new PL/SQL procedures, functions, and reporting queries, while building and enhancing Pentaho and Crystal Reports solutions with optimized SQL logic, custom calculations, and improved runtime performance, formatting, and usability

ETL/Reporting Engineer (Contract) - American Century Investments

(2019-01 - 2019-07)

Developed and maintained ETL pipelines and data integrations using Informatica, consolidating data from Oracle, SQL Server, Netezza, Salesforce, flat files, and legacy systems into a centralized data warehouse. Designed Tableau dashboards and interactive reports using custom SQL and calculated fields, automated internal processes with Python scripting, and supported code reviews and ETL pipeline deployments from testing to production environments.

Technical Solution Analyst - Cerner

(2016-10 - 2019-02)

Managed EHR data validation, transformation, and reporting support for healthcare clients, using CCL (Cerner SQL) to troubleshoot ETL processes, identify data defects, and ensure compliance with CMS, NQF, Meaningful Use, and eCQM regulatory requirements. Maintained and enhanced Business Objects reports, resolved high-priority escalated issues, collaborated with engineering teams on ETL code fixes, and trained clients on report interpretation and policy updates.

• Was available after hours, identified and resolved the issue quicky, allowing clients to fix their meaningful use reporting in time for submission
• Analyzed and troubleshooted the ETL script myself and identified over 20 code defects. Reported to engineers for the fix and improved overall data accuracy for all clients
• I would jump on calls with them, recorrect mappings, troubleshoot specific patients with them as well as explain the logic behind calculations. Improved overall client understanding of reports and in some cases dramatically increased reporting accuracy
• I would help them troubleshoot the code, explain how it works, and even write simplified code to help them. Improved technical understanding for whole team and helped resolve easy to fix tickets faster

Bachelor of Science - Information Systems & Decision Sciences - Louisiana State University