Nathan Zh

Summary:

> Over * years of experience in the IT industry as a SQL Server

Developer 2005/2008/2008R2/2012. Expert in using tools like SSIS, SSRS

and SSAS with MS SQL Server 2005/2008/2008R2/2012.

> Extensive experience in designing, development, implementation and

administration of database systems using MS SQL Server

2005/2008/2008R2/2012.

> Strong experience in using Data modeling for designing the logical and

physical data models.

> Extensive experience with ETL processing.

> Strong experience on SSIS packages and jobs for MS SQL Server

databases. And expert in creating SSIS packages using various data

transformations.

> Experienced in creating SSIS packages to transform heterogeneous data

from different sources to the data warehouse using SSIS

2005/2008/2008R2/2012.

> Strong Relational database modeling and dimensional database modeling

concepts also expert in designing of logical data models.

> Experienced in Performance Tuning, Query Optimization and running

database on SQL Server.

> Expert in creating Business Intelligence reports, defining queries for

generating drill down reports, parameterized reports and in designing

report layout using SQL Server Reporting Services(SSRS)

2005/2008/2008R2/2012.

> Expert in handling parameterized reports, formatting report layout,

sub reports using global variables, expressions, functions, sorting

the data, defining data source and subtotals for the reports for the

reports using SSRS 2005/2008/2008R2/2012.

> Worked extensively on designing and maintaining data cubes using ODBC

to access data from heterogeneous databases.

> Experienced in database programming in writing T-SQL Stored

procedures, Triggers, Constraints (Primary Key, Foreign Key, and

Unique) Indexes and Batch Scripts using various Data Definition

Language (DDL) and Data Manipulation Language (DML) commands.

> Expert in writing Complex T-SQL queries, dynamic-queries, sub-queries

and complex joins, Stored Procedures, Views, Triggers and Complex

Queries on SQL Server 2005/2008/2008R2/2012.

> Database performance monitoring, SQL tuning and analysis,

troubleshooting, and data concurrency analysis.

> SQL code optimizing to implement database logic and database

maintenance.

> Excellent problem solving, analytical, technical, interpersonal and

communication skills with strong leadership abilities. Extremely

diligent strong team player with an ability to take new roles. Well-

organized, goal oriented, highly motivated and effective team member.

Education: Master of Business Administration

Skillset:

MS SQL Server 2005/2008/2008R2/2012, Microsoft Integration Services (SSIS),

Analysis Services (SSAS), Reporting Services (SSRS), Import/Export Wizard,

BCP, MS Office,, MS SQL Server Business Intelligence Development Studio

(BIDS) 2005/2008/20008R2, MS SQL Server Management Studio 2005, Windows

98/NT/2000/XP/7/8, C, C++, SQL, VB.NET, VB 6.0, HTLM, DHTML, ORACLE 7.x/8i,

9i, 10g and Crystal Reports XI/X/9.0.

Projects Summary:

UPS, Wayne, NJ

02/2013-Present

MS SQL Server/BI/ETL Developer

United Parcel Service, Inc. commonly referred to as UPS, is a package

delivery company. It's the world's largest package delivery company and a

leading global provider of specialized transportation and logistics

services. The project involved building a decision support system which

required creating packages, defining and developing of OLAP cubes and

creating reports using the Sales Transactions data.

The project was on moving from existing AS400, MS Access and JDE to Oracle

Enterprise One and SQL Server. It also included moving/redesigning reports

form crystal reports to SSRS.

Responsibilities:

> Worked in migrating/recreating reports from existing crystal reports

and excel files into SSRS.

> Involved in transition software from an internal ETL tool into SSIS

packages.

> Involved in creating OLTP tables and Data Warehouse Fact and Dimension

tables from the existing MS Access database.

> Involved in migrating data from AS400 and MS Access to SQL Server

using SSIS.

> Created SSIS packages to send exception emails to system administrator

while extracting data from OLTP to OLAP systems.

> Designed, reviewed, and created primary objects like views, indexes,

tables, procedures and functions.

> Designed, developed and deployed reports, sub-reports, drill down

reports, drill through reports and multi value parameterized reports,

ad hoc reports in MS SQL Server environment using SSRS.

> Customized reports by adding new features such as cross-tabs, running

total, sub-reports and drill-down fields.

> Created cubes by using SSAS to analyze historical data and passed that

data to create reports.

> Created steps to run though SQL Server Job engine and send an html

reports to the end users based on the email provided.

> Involved in subscription of reports and giving permissions to users

based on their department by using SQL Server Report Manager.

> Involved in understanding and gathering requirements from the end user

and create new reports based on requirement.

> Created, developed and deployed various drill through KPI reports as

per user requirements.

> Involved in modifying reports procedures to make reports run faster by

modifying procedure structures and using SQL Sentry to keep track of

server.

> Involved in improving SQL Query performance by analyzing the query

using SQL Sentry and modify queries according to it by using

appropriate joins.

Environment: MS SQL Server 2012, SSIS, SSRS, Crystal Reports, SQL Profiler,

SQL Sentry, VB.Net, ADO.Net, Oracle, AS 400.

NYU Langone Medical Center, New York, NY

10/2011-

02/2013

MS SQL Server/BI/ETL developer/DBA

NYU Langone Medical Center is an academic medical center in New York City

affiliated with New York University. NYU Langone also treats the full range

of medical conditions in outstanding programs including the Fertility

Center, Weight Management Program(including bariatric surgery), and

Institute of Reconstructive Plastic Surgery, Robotic Surgery Center,

Cochlear Implant Center, Sleep Disorders Center, and programs ranging from

maternal-fetal medicine to Alzheimer's disease. The project was on creating

Data Warehouse and migrating data into the data warehouse to store

historical data. The project was also to create cubes using analysis

services to analyze historical data and create reports using SSRS according

to the requirements.

Responsibilities:

> Migrated data from heterogeneous data sources like text files, flat

files, MS-Access, Excel, OLE DB, XML files using SSIS.

> Used Logging in packages to check who is using the package, at what

time, using data viewer to trace the data manually. Enforced data

consistency by adding data viewer to the transformations.

> Created SSIS packages to extract data from OLTP to OLAP systems and

scheduled jobs to call the packages and stored procedures.

> Applied various data transformations like Slowly Changing Dimension,

Aggregate, Sort, Multicast, Conditional Split and Derived columns.

> Using Bulk insert task in SSIS to load data from multiple flat files

into the data warehouse.

> Created ETL SSIS packages to develop jobs for extracting, cleaning,

transforming and loading data into data warehouse.

> Designed, reviewed, and created primary objects (views,indexes,etc)

based on logical design models, user requirements and physical

constraints.

> Performed daily tasks including backup and restore by using SQL Server

2008R2 tools like SQL Server Management Studio, SQL Server Profiler,

and SQL Server Agent.

> Designed, developed and deployed reports, sub-reports, drill down

reports, and drill through reports and parameterized reports and

adding new features to the reports in MS SQL Server environment using

SSRS.

> Analyzed historical data by creating SSAS cubes and passed the data to

created reports.

Environment: MS SQL Server Management Studio 2008R2, SSIS, SSRS, SQL

Profiler, XML, MS-Access, VB.Net.

Citi Bank, New York City, NY

09/2010-10/2011

MS SQL Server/BI Developer

Citi Bank is an American multinational banking and financial services

corporation headquartered in New York City. They provides personal banking,

corporate banking, wealth management, loans and other financial services.

Risk Insight is a project involve analyzing, designing, developing ETL

processes using Microsoft SQL Server Integration services (SSIS) for

aggregation of risk data coming from different sources within the

organization.

Responsibilities:

> Automated the process of extract, load data from source table, occur

on a weekly basis using SQL Agent.

> Created SSIS packages to synchronize the data between staging and

production server.

> Pull out the data from source tables to DML staging tables, check the

existence of different business files, call procedure to populate DML

tables and apply business rules, send mail to different business

people and fail the package if certain error occurs by using the

Expression feature of Send Mail Task.

> Managed package Configuration Files and added Checkpoints, Event

Handler, Logging File on different task in different package.

> Experienced in modifying and optimizing existing SSIS package.

> Improved performance of long running procedures using both Execution

Plan and Index.

> Worked with the logic of generating sub-report to provide manager with

loan details using SSRS

> Developed complex reports, which includes the complicated joins and

expression for monthly and yearly calculations using SSRS.

> Created cubes using star schema, snowflakes schema and different

dimensions in SSAS.

> Created Key Performance Indicator (KPI) using MDX queries to access

cubes.

Environment: MS Visio, MS SQL Server 2008 R2, SQL Server Integration

Services (SSIS), T-SQL, Visual Studio Team Foundation 2010, Database Tuning

Advisor, SharePoint, MS Office Components.

Florida Health Care Plans, Daytona Beach, FL

08

/2009-09/2010

SQL Server/BI Developer

Florida Health Care Plans affiliates to Blue Cross Blue Shield of Florida

(BCBSFL) is an insurance company cared for over 48,000 members. It mainly

provides insurance in Volusia and Flagler County and FHCP is developing EDW

project, which is providing monthly and quarterly Reports to the State of

Florida in EDW Claims and EDW Enrollment. Worked with data modeling support

team on tool features, functionality and maintenance.

Responsibilities:

> Worked with Project Manager and Business Analyst to understand

business requirements and involved in planning, defining and designing

data based on business requirements.

> Responsible for creating database objects using T-SQL to provide

structure to store data and optimized Stored Procedures, Views,

Triggers and UDFs for the application.

> Used SSIS to create Dynamic ETL Packages to validate, extract,

transform and load data from OLTP database to data warehouse database.

> Performed data conversion from flat file into a normalized database

structure.

> Configured Server for sending automatic emails to respective people

when a SSIS process failure or success.

> Created SSIS jobs to automate the reports generation and cube refresh

packages

> Deployed SSIS package into production environment and used package

configuration to export various packages properties to make package

environment independent.

> Developed different kinds of reports such as Chart reports, Matrix

reports, Drill-down reports, Linked reports and Cascading

Parameterized reports using SSRS.

> Involved in designing, analyzing, building and testing of OLAP cubes

in SSAS

> Involved in System Study analysis for logical data model there by

defining strategy for implementing Star Schema with Fact and Dimension

tables.

Environment: MS SQL Server 2008, Integration Services (SSIS), Reporting

Service (SSRS), Analysis Services (SSAS), MS Excel, MS Access, MS Visual

Studio

Bank Atlantic, Fort Lauderdale, FL

10/2007-08/2009

MS SQL Developer/ SSIS, SSRS, SSAS

Bank Atlantic provides a full range of commercial & individual banking

products and services like online Banking, Telephone Banking, Bill Pay and

Cash management Services. The project mainly involved in maintaining and

optimizing database, creating packages to transfer data based on new

requirement, creating reports for analysis.

Responsibilities:

> Worked closely with Marketing Director and Project Manager to

understand business process and gather business requirements.

> Designed, created dimensions, tables and the requisite relationships

to meet business requirements based on ER diagram.

> Experienced in developing T-SQL (DDL, DML) statements using

dynamically generated SQL.

> Created indexes on selective columns to speed up queries and analysis

in SQL Management Studio.

> Performed tuning to optimize SQL queries using SQL profiler and data

engine tuning advisor.

> Designed and developed SSIS packages to extract data from various

upstream data sources and business files into SQL Server 2008 for

further Data Analysis and Reporting by using multiple transformations

such as Data Conversion, Conditional Split, Slowly Changing Dimension,

and Merge.

> Scheduled and maintained weekly and monthly loads of data by creating

the corresponding scheduled administrative tasks.

> Extensively used SQL Server Reporting Services to create customized

report, designed and created report templates, bar graphs and pie

charts based on financial data.

> Generated different types of reports for project manager to analyze

the data, such us Drill-Down reports, Cascading Parameterized reports

with SSRS.

> Designed and created complex cubes for analyzing the profit of

commercial and individual banking products in SSAS.

Environment: MS SQL Server 2008, T-SQL, ETL, SQL Server Integration

Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting

Services (SSRS), OLTP, OLAP, MS Excel, Visual Studio 2008.

Contact this candidate