Data Warehouse Architect

NHON NGUYEN

(Preferred name: ANDY NGUYEN)

************@*****.***

C: 770 – 364 – 9624

Suwanee, GA

SUMMARY

Software and Business Intelligent Developer with over 20 years of professional and technical experience

Expertise in multi-dimension data warehouse and relational data modeling

Expertise in designing and implementing ETL/ELT solutions for data warehouse application

Solid experience in develop static reports and self-service analytics

Solid experience in programming languages like C#, Python, Java

Expertise in writing T-SQL, PL/SQL and develop MSSQL Server as well as Oracle database objects

Strong analytical, critical thinking and problem-solving skills

Intense knowledge in healthcare industry

Good knowledge in machine learning

IMPACTFUL PROJECTS

Data and Application Migration on Cloud platform: Steered and executed 3+ TB Data migration, Data transformation and ingestion from 5+ enterprise systems, Migrate a daily scheduled ETL solution to a near-real- time ELT solution

Design and operate a data warehouse on Domo cloud platform, provide standard dashboards as well as self- service reports for predictive inquires. This new BI project is a strategic product to retain existing customers and attract new customers

Assist Director of BI/Reporting department to evaluate the existing transactional reporting product, evaluate business needs and overhaul the product to perform more productive and reduce cost TECHNICAL SKILLS

Competency Level Year of Experience

Microsoft SQL Server Expert 19+ years

Oracle Expert 19+ years

Microsoft SSIS Expert 12+ years

Microsoft SSRS Expert 8+ years

AWS Cloud, AWS Redshift, AWS DMS Competent 3+ years PostgreSQL Competent 2+ years

Microsoft .NET C# Competent 4+ years

Java Competent 3+ years

Python Competent 2+ year

Informatica PowerCenter Competent 2+ years

Domo Business Intelligence Competent 3+ years

Talend Cloud Integration Competent 2+ years

ER Studio, ERWin, UML, and Visio Competent 2+ years Source Control (Git, SVN, Bitbucket, TFS) Proficient 8+ years PROFESSIONCAL EXPERIENCE

Sandata Technology

Senior BI Developer/

Data Architect

2020 - Present

Project: BI and Reporting department 2020 – Present – Healthcare Industry

Design and implement the first version ETL solution with Oracle (3+TB), flat file, MS SQL Server (1+ TB) sources, MS SSIS as ETL tool, MS SQL Server database target.

Design and implement the second version of the ETL solution (to be exact, we turned the model to ELT): extract and load data using AWS Data Migration Services (replaced by Fivetran later), transform data using Talend Cloud Integration, target is Redshift data warehouse.

Implement BI dashboards using Domo visualization tool

Design and implement transactional reports using Microsoft SSRS

Design and implement database codes using MS SQL Server, Oracle, AWS Redshift PostgreSQL

Review and tune performance of SQL, T-SQL and PL/SQL codes KMS Technology, Inc.

Technical Lead/

Data Architect

2008 – 2020

Project: Sandata 2014 – 2020 – Healthcare Industry

Manage Reporting team in onshore/offshore model

Communicate with customers at all levels and translate business requirements to technical reports

Design data warehouse in Domo. Design reports and dashboard in Domo

Design and implement transactional reports using Microsoft SSRS

Design ETL framework and implement solution using Microsoft SSIS

Design and implement database codes using MS SQL Server and Oracle

Review and tune performance of SQL, T-SQL and PL/SQL codes Project: Alere DW 2011 – 2014 – Healthcare Industry

Analyze/profile source data in OLTP databases (Oracle and MS SQL Server)

Create mapping to target database warehouse (Oracle)

Design and implement an ETL solution using Informatica PowerCenter. The ETL solution also ingests data received from multiple payers

Implement automatic data export processes and transfer data files to the customers Project: Alere PCMS 2010 – 2011 – Healthcare Industry

Lead offshore team to implement a web application for Patient Care Management

Design and implement database objects using Oracle and MS SQL Server

Implement core logic using Microsoft C# code

Communicate with customer to translate business requirement to technical artifacts Project: KMS LMS 2008 – 2010 – eLearning Industry

Manage a team in KMS to build a web-based e-Learning application for domestic education system

Meet boards of schools to understand the needs and build the application

Design and implement database objects using Oracle and MS SQL Server

Implement core logic using Microsoft C# and NHibernate DXC Vietnam

Senior Software

Engineer

2003 – 2008

Project: Outstart LMS/LCMS 2003 – 2008 – Elearning Industry

Convert the whole MS SQL Server database to Oracle (both schema and code)

Implement new database objects in both MS SQL Server and Oracle

Implement core logic using Java programing language

Review and fine-tune T-SQL and PL/SQL to solve performance problems

Successfully play onshore coordinator and database team lead EDUCATION AND TRAINING

2003 – 2005: Master of Engineering in Computer Science, HCM University of Polytechnique 1998 – 2003: Bachelor of Engineering in Computer Science, HCM University of Polytechnique 2020: AWS Associate Professional Certificate, Amazon 2010: Microsoft Certified Professional Developer: Web Developer, Microsoft Corporation 2006: Sun Certified Programmer for the Java 2 Platform 1.4, Sun Corporation 2006: Oracle Certified Professional 9i, Oracle Corporation 2005: Microsoft Certified IT Professional: Database Administrator 2008, Microsoft Corporation

Contact this candidate