Data Engineering

Joshua Gao

********@*******.*** 856-***-****

Extensive IT experience in Database Development, Administration, Data Analysis, System Analysis, Design, Development and Support of MS SQL Server 2017, 2016, 2014 in Production, Testing and Development. T ECHNICAL SKILLS

Database: SQL Server 2017, 2016, 2014

SDLC: Agile, Scrum, Waterfall, and Spiral

Data Modelling: ER-win, MS Visio

Database Programming: T-SQL, Dynamic SQL, MDX, DAX Development/ Integration Tools: SSDT, SSMS, SSIS

Analysis Services: SSAS, OLAP Cubes, Tabular Model Reporting Tools: Power BI, SSRS

Source Control & Collaboration Tool: Team Foundation Server (TFS), SharePoint, Azure DevOps Programming Language: C# & Python

Cloud Technologies: MS Azure, Azure SQL, Azure Data Warehouses WORK EXPERIENCE

Senior SQL Developer — Iowa Department of Human Services, IA 12/2019 - Present SQL Server 2017, SSIS, SSMS, SSDT, T-SQL, Erwin, Azure DevOps, TFS, SQL Profiler, C#

• Optimized performance in relational and dimensional database environments by making proper use of indexes and partitioning techniques

• Transformed business requirements into logical and physical data models

• Revamped existing stored procedures, triggers, UDFs, and views to improve the performance of queries

• Maintained data integrity and created various constraints and DML triggers on the relational databases

• Worked on look up transformations and data flow tasks using T- SQL

• Successfully created and deployed SSIS packages with transformations

• Deployed ETL (SSIS) to develop jobs for extracting, cleaning, transforming, and loading data into the data warehouse

• Solved company’s back-end database issues by using C# and queries

• Generated scripts for the company database backups and refresh SQL Server Developer California Creative Solutions, Inc., CA 07/2019 – 12/2019 SQL Server 2016, Erwin, SSDT, SSIS, T-SQL, Erwin, TFS, DTA

• Coordinated with business users and stakeholders in JRD sessions to gather business requirements.

• Designed logical and physical data models using the Erwin data modeler tool

• Ensured the validation and updating of the appropriate logical data models

• Created complex SQL queries, derived tables, common table expressions (CTEs), stored procedures, views, and user defined functions (UDF)

• Developed data reconciliation SQL queries to validate the overall data migration

• Profiled the legacy database tables using T-SQL queries to provide data cleansing issue reports to the client

• Built SSIS packages to extract data from various data sources such as Excel spreadsheet and flat files into SQL Server

• Conceptualized and developed the ETL process using SSIS with various control flow, data flow tasks and stored procedures for work order validation process

• Established TFS for version control and change management of BI solution for cross-functional communications CERTIFICATIONS

• MCSE (Microsoft Certified Solution Expert): Data management and analytics

• MCSA (Microsoft Certified Solution Associate): SQL 2016 Database Development

• MS Certification Test: Analysing and Visualizing Data with Power BI EDUCATION

STEVENS INSTITUE OF TECHNOLOGY Hoboken, NJ

Master of Science in Computer Engineering GPA:3.7

Related courses: Applied Modelling & Optimization, Database, Engineering Programming (Java & Python), Machine Learning SICHUAN UNIVERSITY Sichuan, China

Bachelor of Engineering

Contact this candidate