Kevin Wu Email & Phone Number

Boston, Massachusetts, United States

- Designed and developed infrastructure to automatically trigger Data Quality jobs using python- Designed and developed dbt models to implement securities into data platform using dbt and SQL- Designed and developed data quality jobs in Collibra DQ to monitor data quality using SQL

Boston, Massachusetts, United States

• Optimized ETL batch process time by 75% by refactoring a stored procedure using Databricks, PySpark, and SQL to extract Snowflake data to AWS S3, generate hierarchical data, and upsert to PostgreSQL database• Wrote unit tests to assure data transformations and data schemas are correct

Riverwoods, Il

•Replaced a legacy third-party software with in-house solution to save AML team $10,000/year by using Ab Initio to extract Teradata and Snowflake data, check for updates, and load updates to Snowflake database •Migrated from an on-premises Teradata database to cloud Snowflake database to save IT $7,000/year by utilizing Ab Initio, XML, and SQL to update data to Snowflake instead of Teradata

Cambridge, Massachusetts, United States

•Cut down time needed for data engineering and analysis by 5+ hours per dataset by building an R script to automatically generate sharable data reports with a set of 10+ interactive visuals•Implemented KNN algorithm with 95% F1-Score to classify cells and t-tests with 95% confidence to find marker genes in cancer in order to derive stronger scRNA-seq analysis•Expanded analytical flexibility by 300% by providing options in AWS to choose dimensionality in UMAP, resolution in clustering, and database for model training

Greater Boston

•Reduced Excel search and space complexity by 60% with Pandas to clean and remodel 60,000 data entries•Read a meta-analysis of salary research and presented results to management board •Created a comments feature on Salesforce CRM with Visualforce for clients to add and display comments

Boston, Massachusetts, United States

•Improved Jenkins CI/CD detailed reporting by 200% with Groovy to include error logs in pipeline, specify failed tests, and deliver Slack error messages•Strategized with 5 engineers to identify 3 ways to enhance Jenkins report and to save 30+ minutes of debugging