PeterDao

Education

Master of Science, Data Science with specialization in Data Engineering

2020-2022
Regis University, Denver, CO

Big data analytics tailored for the Microsoft Azure cloud services platform. In massive data pipelines, raw and structured data is imported into Azure in batches via Azure Data Factory or SQL scripts. This data is stored in a data lake for long-term sustained storage, either in Azure Blob Storage or Azure Data Lake Storage.

Big Data and Hadoop Developer

2016
Simplilearn

Machine Learning with Big Data

2016
Simplilearn

Experience

Business Intelligence Developer

Jan 2007 – Current
Sutter Health

Formulate integrated solutions (using Microsoft technologies) and leverage business/technical acumen to design, develop, and implement BI solutions, data warehouses, data marts, and web-based applications. Manage all technical aspects for product implementations and rollouts. Evaluate functionality and effectiveness of newly developed products through testing. Employ SQL Server Integration Services (SSIS) to support data warehousing and data ETL processes. Interpret and translate business requirements to support IT developers in building and modifying specific IT applications used by Sutter Health Human Resources.

Senior Application Developer

Sep 1998 2011 – Nov 2006
Vision Service Plan (IT Division), Rancho Cordova, CA

● Employed software engineering best practices to create web-based claim applications from client/server apps.
● Enhanced internal communication by designing and building an intranet site. Reduced manual tasks and elevated team efficiency by executing automated procedures.
● Improved the professional skillset of new developers by providing training and guidance.
● Delivered high-quality support to ensure proper maintenance of IDC applications. Designed and created a Lens Editor application by utilizing Cold Fusion and MS Access database.

Senior Programmer Analyst,

1989-1997
Ross Stores Inc.

Started as Programmer Analyst for Tandem applications; promoted to Senior Program Analyst for client/server applications. Developed and implemented a VB4 front end for Merchandise Reject System using RSC (Remote Server Call) and ODBC to connect Windows NT and Tandem SQL database. Designed, programmed, and implemented Data Load applications between Tandem and Sun environments. Enhanced and maintained a VB GUI system security administration module. Maintained and enhanced Decision Support System.

Design Skills

Web Design

Graphic Design

UX Design

Database Design

Database Administration SQL Server

WordPress

Woocommerce

MySQL

NoSQL

Coding Skills

HTML5

CSS3/LESS/SASS

jQuery

C# Programming

VB.NET Programming

SQL Server Development

Java Programming

C Programming

Python Programming

Transact-SQL Programming

SQL Server Integration Services (SSIS)