Overview & Summary

Over ** years’ experience as a hands-on technical architect. Implemented solution design, development, and administration using a wide variety of tools and technologies in multiple year-length projects. Familiar with all traditional data and BI tools as well as new cutting-edge big data solutions. Expertise in all phases of software development life cycle (continuous integration and continuous delivery). Excellent communication skills, team management and project management.

Technical Expertise

Technologies:

Cloud Solution (Microsoft Azure, AWS; GCP)

Relational Database (Oracle, SQL Server, Sybase IQ, Sybase ASE, MySQL)

Data Warehouse (Redshift, Teradata, Sybase IQ, Netezza)

Business Intelligence Solutions (Microsoft BI Stack, Cognos BI Solution, Talend, Tableau, Qlikview, Micro Strategy)

Big Data Solutions (Cloudera, Hortonworks, HDInsight, MapReduce, Spark, Sqoop, Kafka, Hive, Pig)

Container (AKS, Docker)

DevOps (Azure DevOps, JIRA, Jenkins, Ansible, VaGrant)

NoSQL DB (Mongo DB, Cassandra, HBase)

Others (Data Migration, Dash Boarding, Project Management, Master Data Service, Data Quality Service, Clustering, Replication, Database Mirroring)

Languages:

Powershell, C#.net, Java, Python, SQL, MDX, DAX, VB.net, ASP.NET 2.0, jQuery, VBScript, JavaScript, HTML, CSS, VBA, ADO.NET 2.0, XML

Experience

Cloud Solution Architect (Zero One, LLC) Mar.2018 – Present

Led multiple projects using USQL, Java, Python, Hive SQL, Spark SQL, Data Bricks

Strong T-SQL skills with experience in Azure SQL DW

Experience handling Structured and unstructured datasets

Assessment of Cloud Migration Services (Applications and Databases)

Migration Services (Architect/Application/Schema/Data)

Advanced data analytics – designing and building solutions using technologies such as Azure Data Factory, Azure Data Lake, HD Insights, SQL DWH, stream analytics, machine learning, R server.

PoC projects with Machine Learning, AI, IoT, Advanced Analytics or Azure Data warehouse

Cloud Data/BI Architect/VP Jun. 2013 – Mar 2018

Goldman Sachs, Dallas, TX

POC on Cloud (Azure and GCP)

Led a data team to build end-to-end BI solutions from scratch

Using Python-Spark to implement data ingestion (Loan Collateral Tape)

Implemented Data Lake Project using Hadoop/Spark for Compliance Users (14m Reports/14Q Reports)

Using Kafka to re-design the system log analytics

Fully empower the business users and support Realty Management business lines.

Drove the projects of Loan Mortgage Analytics System

Re-designed Cash flow BI Project

Perform data analysis and develop visualizations via Tableau and other BI tools

BI Architect/Account Manager Oct. 2011 – May 2013

GNet Group, St. Paul, MN

BI Solution End-to-End design for multiple accounts

Work with BI Developers to deliver a compelling product that solves the critical business problems and timely delivery

Interact with customers on an ongoing basis to ensure adoption and approval of products

Prioritize a product backlog based upon business impact and effort; help make resource tradeoff decisions as needed.

Develop product vision and roadmaps, and assist in budgeting and the preparation of business cases

POC using vendors’ new technology stack

Data Architect May 2009 to Sep. 2011

StarCite Ltd., Shanghai, China

Managed the BI Reporting Team (8) for ETL Design (SSIS) and dashboards/reports creating (Cognos)

Database Architecture including HA/DR solutions, table design and performance tuning

Communicate complex topics to team through both written and oral communications

Managed the relationship with Sr. Management team in US

Reported to the local Director

Business Intelligence / Data Warehouse Architect May 2008 to May 2009

Hewlett-Packard Company, Shanghai, China

OVSD Project, Data Warehouse Architecture

OVSD is an HP world-wide internal system to log all supporting cases for IT and HR departments. The higher level managers would manually analysis some KPIs like how many cases one support engineer handles, How long one engineer to solve one case averagely…then the cost per engineer…something like that before. OVSD EDW system is to load data from the source DB to EDW then present the reporting system and create all KPI(s) to internal users.

Environment: Oracle 9i, SSIS, SSAS, SSRS

Responsibilities:

Solution Architect

DB/EDW tables Design

SSAS Cube implementation

ETL Deigning and Implementation

Reporting Design

Principal DBA December 2006 to May 2008

Hewlett-Packard Company, Shanghai, China

Managed the team to fulfil the 24*7 database (SQL Server; Oracle, DB2) management support

Designed high available solution using Symantec Clustering (S2S Project—Site to Site)

DB Architect for Web Service Application Team (wsR, wsC, wsR projects)

ETL Design to all data movement and transformation

Led the data servicer hub design (1.5 years project) for all application teams

Education

MS (Master of Science): Computer Science, Shanghai Maritime University

oMachine Learning (Facial Recognition and Gesture Recognition)

BS (Bachelor of Science): Computer Science, Shanghai Maritime University

Certifications

Azure Data Engineer Associate

MCSA with Power BI

Project Management Professional

Microsoft Certified Solutions Expert (MCSE)—BI Platform

Microsoft Certified Solutions Expert (MCSE)— Data Platform

Contact this candidate