Wayne Li Email and Phone Number

Participated in system outline design, database schema design and detailed design, focus on ETL development, complete testing, data cleaning and documentation with team members. Based on business requirement and the excel form in use, designed the logical structure of the data, the organization of data and its relationships, constraints or rules for data integrity.  In ETL (Extract, Transform, Load) processing, traverse the specified folders and subfolders, search for source original… Show more Participated in system outline design, database schema design and detailed design, focus on ETL development, complete testing, data cleaning and documentation with team members. Based on business requirement and the excel form in use, designed the logical structure of the data, the organization of data and its relationships, constraints or rules for data integrity.  In ETL (Extract, Transform, Load) processing, traverse the specified folders and subfolders, search for source original excel files in different versions and transfer to structured excel files with Python scripts. Transform the extracted data and loaded into data warehouse (SQL Server Database), create views and stored procedures for preparing reports. Then, import the data into Power BI, design reports and visualization. Show less

It's a bioinformatics project involving the analysis of gene copy number aberrations in cancer.

Gather and absorb required information in question, analyze data model, design and build database or produce SAS dataset