Wayne Cao Email & Phone Number

A technically proficient professional with more than 6 years of experience in design, development, documentation and maintenance of database using various SQL Server in OLTP/OLAP/BI environment. More than 5 years of programming experience with Python, 5 years of experience with Amazon Web Services for Serverless Microservice design and Big-data process. Experienced with AWS services for serverless microservice and big-data work flow, like Kinesis, Step function, S3, API-gateway, Lambda, Aurora, Athena, Glue, EC2, EMR, ECS etc. Strong knowledge with big-data data lake design, including data validation, data ingestion, data consuming.  Experienced with python programing language to create RESTful API with Flask and use python with AWS lambda for computing. Fluent in Enterprise Data Modeling (Dimensional & Relational) with a solid understanding of the Data modeling concepts like Star-Schema Modeling, Snowflakes Modeling, Fact and Dimension Tables modeling of data at all the three levels: conceptual, logical & physical design. Involved in Agile Software Development Life Cycle (SDLC) methodologies. Proficient in writing Transact SQL queries involving creation of Tables, Views, Stored Procedures, File groups, Partitions, performing inserts, updates, deletes using Joins, Sub queries, Cursors and adding constraints on the tables. Strong knowledge of creating different indexes like cluster and non-cluster indexes from optimization point-of-view according to the business criteria.  Monitored, Optimized and Tune complex T SQL scripts and Stored Procedures based on the execution plans and also using SQL Profiler and Database Tuning Advisor (DTA). Experienced with the creation on SSIS packages in Data Extraction, Transforming, and Loading (ETL) from various sources using SQL Server Information Services, Bulk Insert, and Bulk Copy Program (BCP). Hands on experience in the entire Report Life Cycle, designing multiple types of reports in SQL Server Reporting Services (SSRS) and Tableau.

Listed skills include Python, Sql, Databases, Transact Sql, and 35 others.

• 

  Oregon State University

  Electronics And Communications Engineering