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