Kyle Kou

Contact no 732-***-****

Summary:

> Over 7 years of experience in working with Data Warehousing & Business

Intelligence solution Design, in the area of specifically related to

MS SQL server 2008/2008 R2/2012.

> Experienced in extracting, transforming and loading the data using

SSIS in SQL Server 2005/2008/R2/2012 and Data Transformation Services

in SQL Server 2000.

> Expert in data migration from OLEDB/EXCEL/FLAT file to SQL Server

2000/2005/2008/R2 and other destinations using SSIS.

> Developed database objects such as tables, views, stored procedures,

triggers, cursors, indexes, user-defined data-types, functions and

constraints.

> Experience in performance tuning in SSIS, error and event handling,

precedence constraints, break points, transactions, check points and

logging using SSIS.

> Knowledge in OLTP, OLAP and data warehouse design concepts,

experienced in relational, multi-dimensional (Star) and snowflake,

logical and physical data modeling and data mapping

> Knowledge in processing OLAP cube, creating KPIs, dimension usage,

calculated members, perspectives and hierarchies

> Extensive experience in reporting tabular forms, matrix (cross tab

report) form, conditional, list items, charts and sub reports

> Deploy reports, secure access, and schedule execution of reports and

deliver them to the Web using reporting manager, share Point, email

recipients, file shares, and more, on a scheduled basis

> Expertise in creating reports using SSRS (ad-hoc, drill-down, drill-

through, cross-tab, sub-reports, pivot, tabular and parameterized

reports)

> Experience in error and event handling, precedence constraints, break

point and logging

> Experience on framework manager modeling (Namespaces, Joins, Loops,

and Dimensions) and creating packages and deploying onto server

> Developed prompt pages and cascaded input prompts to display only the

selected entries in report studio

> Worked on administration tasks such as backup & recovery, upgrades,

creating databases/file groups/files/transactions logs

> Possess excellent management skills of outstanding decision making

with excellent verbal and written communication skills, Supervised in

preparing and assisting formal walkthroughs and presentations of

system designs for business analysts, stakeholders and clients

Education: M.S. in Applied Mathematics

Skillset:

Microsoft SQL Server 2005/2008/2008-R2/2012, SQL Server Management Studio

(SSMS), SQL Server Business Intelligence Development Studio(BIDS), SQL

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

SQL Server Reporting Services (SSRS), Oracle 8i/9i/10g/11g, MySQL, MS-

Access, MS-Excel, SQL, T-SQL, Visual Studio 2005/2008, SQL Profiler, MS

Visio, Team Foundation Server, Sharepoint, Powerpivot, Powerview .

Projects Summary

Copart, Dallas, TX 8/2012 - Present

MS SQL BI /SSAS/SSIS/SSRS Developer

Copart, Inc. is a provider of online vehicle auction and remarketing

services providing vehicle sellers with a range of services to process and

sell salvage and clean title vehicles over the Internet using its patented

virtual auction technology. The aim of the project was to design and

develop Enterprise Data warehouse and migrate the data from different

sources into the databases using SSIS and generating customer transaction

reports using SSRS.

Responsibilities:

> Responsible for Deploying the SSIS packages and scheduling the package

through Jobs in all Tiers including Dev, UAT and Prod, Setting the

Configuration files which is done in the specified tables and created

technical specs documents for all the enhancements.

> Deploy SSIS Package into Production and used Package configuration to

export various package properties to make package environment

independent.

> Implemented Event Handlers and Error Handling in SSIS packages and

notified process results to various user communities.

> Tested, Cleaned and Standardized Data meeting the business standards

using Fuzzy /exact lookups using SSIS tasks.

> Imported data from text files and excel spread sheets into SQL Server

2008 R2/2012 database using SSIS package.

> Developed physical data models and created DDL scripts to create

database schema and database objects

> Wrote complex SQL queries using joins, sub queries and correlated sub

queries to retrieve data from the database.

> Created/Updated database objects like tables, views, stored

procedures, function, packages

> Generated Drill down, Drill through, Ad-hoc, Matrix Reports,

parameterized reports using SSRS.

> Involved in table and index partitioning for performance and

Manageability.

> Identified, tested, and resolved database performance issues

(monitoring and tuning) to ensure database optimization.

> Monitored the overall performance of the database to recommend and

initiate actions to improve/optimize Performance.

> Used SQL Server Profiler to trace the slow running queries and the

server activity.

> Automated and enhanced daily administrative tasks including database

backup and recovery.

> Involved in setting up SQL Server Agent Jobs for periodic Backups with

backup devices, database maintenance plans and recovery.

Environment: MS SQL Server 2008 R2/2012, T-SQL, SSIS, SSRS, SSAS, Windows

server 2008, SQL Profiler, Visual Studio 2012, Team Foundation Server

Societe Generale Corporate & Investment Banking, New York City, NY

5/2011-8/2012

MS SQL BI /SSIS/SSRS Developer

Societe Generale is a French multinational banking and financial services

company. The company is a universal bank split into three main divisions,

Retail Banking and Specialized Financial Services, Corporate and Investment

Banking and Global Investment Management and Services. The goal of this

project was to create business intelligence objects to analyze the data

acquired from the various applications and to create reports that help

higher management to make decision on budget management based on current

expenses.

Responsibilities:

> Involved in creating Tablix Reports, Matrix Reports, Parameterized

Reports, Sub reports using SQL Server Reporting Services 2008R2.

> Interacted with the Business Admin and gather the requirements and

analyzed.

> Interacted with the Project Managers and the Field Managers who would

be using the application the most.

> Created and updated complex Stored Procedures, Triggers and User

Defined Functions for logical T-SQL implementation.

> Created Views to facilitate easy user interface implementation and

Triggers on them to facilitate consistent data entry into the

database.

> Scheduled Jobs for executing the stored SSIS packages which were

developed to update the database on Daily basis.

> Developed various reports for managing various securities and assets

to meet specified investment goals.

> Involved in thinking about investing and asset allocation,

diversification, and correlation and generating various kinds of

reports.

> Created advanced objects like KPI's and Perspectives.

> Involved in SSAS storage and partitions, and Aggregations, calculation

of queries with MDX, Data Mining Models, developing reports using MDX

and SQL

> Used Performance Point Server to create interactive reports with an

ability to drill down into details.

> Actively participated in review meetings with Project Manager to

ensure that the development of projects meet business and system

requirements.

Environment: SQL Server 2008R2, Windows Server 2008, SQL Server Reporting

Services (SSRS), SQL Server Integration Services (SSIS), SQL Server

Analysis Services (SSAS), Oracle 9i, MS Visio

Juniper Networks, Sunnyvale, CA

2/2010 - 5/2011

MS SQL Server Developer/ SSRS, SSIS

Juniper Networks, Inc. is an American manufacturer of networking equipment.

The company designs and sells high-performance Internet Protocol network

products and services. Project is to develop different kinds of reports

based on different transactions and to extract data, performing various

transformations and then loading all the relevant data into a data mart and

generating reports on it.

Responsibilities:

> Used various SSIS tasks such as Conditional Split, Derived Column

etc., which did Data Scrubbing, including data validation checks

during Staging, before loading the data into the Data warehouse.

> Created reports to retrieve data using database code objects, such as

Stored Procedures, views, functions and multiple T-SQL queries.

> Included Report Design and Coding for Standard Tabular type reports,

including Drill down and Drill through functionality and Graphical

presentations such as Charts and Dashboard type metrics.

> Responsible for Monitoring and Tuning Report performance by analyzing

the execution plan of the report.

> Performed T-SQL tuning and optimization of queries for reports that

take longer execution time using MS SQL Profiler, Index Tuning Wizard

and SQL Query Analyzer in MS SQL Server 2008/2008R2.

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

Scheduled Jobs to call the packages and Stored Procedures.

> Generated reports using SSRS that could be used to send information to

different Primary Vendors, Clients, and managers and used windows

security for security purposes.

> Designed and implemented complex SSIS package to migrate data from

multiple data sources for data analyzing.

> Performed extract, transform, and load data into the repository and

Created Complex Stored procedure, Functions, Views, and Indexes for

the Logic package.

> Developed data access queries/programs using SQL Query to run in

production on a regular basis and assists end users with development

of complex Ad Hoc queries.

> Created Error and Performance reports on SSIS Packages, Jobs, Stored

procedures and Triggers.

Environment: MS SQL Server 2008, MS SQL Server Analysis Service 2008, MS

SQL Server Integration Services 2008, MS SQL Server Reporting Services

2008, T-SQL.

MetLife, New York City, NY

9/2008 - 1/2010

MS SQL Server Developer/ SSRS, SSIS, SSAS

MetLife is a leading insuring firm is being involved in insuring the lives

of people. Project is about to migrate data from 2005 to 2008, format and

generate parameterized reports which contains the detail of the different

type of insurances, the sales agents and the customer for each. Deployed

the developed reports on the server for the managers and sales agents.

Responsibilities:

> Designed and implemented complex SSIS package to migrate data from

multiple data sources for data analyzing.

> Extensively involved in generating reports like matrix, parameterized

and drill through reports using SSRS and developed stored procedures

using functions to generate various kinds of reports using SSRS.

> Extensively used T-SQL statements and created multidimensional cubes

for the analyzer and used pivot table to help the end-user get

familiar with cube.

> Incorporated the DTS Packages into MS SQL Server 2008 Integration

Services by using Package Migration Wizard and Execute DTS 2000

Package task.

> Upgraded MS SQL Server 2005 databases to 2008, using Detach/Attach,

Back up & Recovery and by Replication.

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

Scheduled Jobs to call the packages and Stored Procedures.

> Created the structure of the model and cube in SSAS and reviewed Cube

with end user and changed the cube and documentation according to

their requirements.

> Used linked server to access the objects from the Oracle data source

for the mapping of source tables to destination tables.

> Extensively involved in migration of data from MS SQL 2005 to MS SQL

2008.

> Monitored performance and optimized SQL queries for maximum efficiency

using SQL Profiler.

> Used indexes to enhance the performance of individual queries and

enhance the stored procedures.

Environment: MS SQL Server 2008, MS SQL Server Analysis Service 2008, MS

SQL Server Integration Services 2005/2008, MS SQL Server Reporting Services

2005/2008, T-SQL, MDX.

Citibank, Newark, New Jersey

10/2006 - 8/2008

MS SQL Server Developer/ SSRS, SSIS

Citibank is one of the largest full service banks in the world offering an

unparalleled range of products and service. Project objective was about to

gather requirements from end user, troubleshooting report failures, created

cubes, reviewed cube and prepared documents and according to it created

reports.

Responsibilities:

> Performed task at development environment, analyzing, testing, and

implementing systems. Designed User-Interface for the testing using

SSIS packages.

> Created Packages using ETL tool for the users to check the codes and

responsible for extracting data from huge database to manipulate and

analyze the data for the end users.

> Performed T-SQL tuning and optimization of queries for reports that

take longer execution time using MS SQL Profiler, Index Tuning Wizard

and SQL Query Analyzer in MS SQL Server 2005.

> Created Sub-Reports, Drilldown-Reports, Summary Reports, and

Parameterized Reports in SSRS.

> Migrated the entire schema as well as data into MS SQL Server 2008 and

also validated the migration process to ensure that it has been

successfully migrated.

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

Scheduled Jobs to call the packages and Stored Procedures.

Environment:MS SQL Server 2005, MS SQL Server Reporting service, MS SQL

Server Integration service, T-SQL,DTS, C#,.Net, SQL Query Analyzer, SQL

Server Index Tuning Wizard, Visual Studio 2005,MDX.

Contact this candidate