Sql Server Data

ENMING Z

732-***-****/***.**********@*******.***

I am available for Corp To Corp assignments only.

SUMMARY

. 6 years of MS SQL Server Development experience in various domains and

with expertise in SAS Programming and deep understanding of statistics

and data modeling methodologies.

. Strong experience with SQL Server and T-SQL in constructing triggers,

tables, user functions, views, indexes, user profiles, relational

database models, data dictionaries, and data integrity.

. Extensive experience with SQL scripts, stored procedures, SQL

Performance tuning and transactions analysis, thorough understanding of

indexes and statistics.

. Experienced in maintaining Batch Logging, Error Logging with Event

Handlers and Configuring Connection Managers using SSIS.

. Expert in data Extraction, Transforming and Loading (ETL) using various

tools such as SQL Server Integration Services (SSIS), creating Dynamic

packages for Incremental Loads.

. Experience in enhancing and deploying the SSIS Packages from

development server to production server by using package configurations

. Experience in Data Conversion and Data Migration using SSIS services

across different databases like Oracle, MS access and flat files.

. Experience in Dimensional Data Modelling Star and Snow Flake Schemas.

Reviewed and developed data models and database designs with

development teams.

. Expert in creating the MDX cubes and dimensions.(SSAS)

. Experience in Designing and Building the Dimensions and cubes with star

schema using SQL Server Analysis Services (SSAS).

. Experience in handling parameterized reports in SSRS and

formatting reports.

. Experience in creating Drill down, Drill through, Matrix, tabular,

graph, sub-reports, and dashboard and cross tab report using various

reporting tools like SSRS.

. Experience in deployment and Subscription of reports in SSRS.

. Experience in using Query Execution Plan to tune existing queries and

created indexes to support queries running against the db.

. Expert in SAS Programming, experience in using SAS/BASE, SAS/MACRO,

SAS/SQL, SAS/STAT, SAS Functions, SAS Formats, and ODS facility in data

scrubbing, manipulation, and preparation of producing summary datasets

and reports.

. Strong ability in analysing data, building statistical models. Thorough

knowledge in various analysis methods (regression analysis, ANOVA, time

series).

. Strong interpersonal and communication skills, able to relate

effectively with individuals at all levels of the organization.

Collaborative team player with ability to work cross-functional and

fast-paced environments.

EDUCATION

. Master of Science in Applied Statistics from Purdue University, West

Lafayette, US

CERTIFICATIONS

Oracle

. Oracle Certified Associate for Oracle database

SAS Institute, Inc.

. SAS Certified Base Programmer

. SAS Certified Advanced Programmer

Databases MS SQL server, Oracle, MS Access

Programming Languages T-SQL, SQL, python

Web Development HTML, C#.NET

Operating Systems Windows NT/98/2000/XP/Vista/7

OLAP/Reporting Tools SQL Server Analysis Service(SSAS), SQL Server

Reporting Service(SSRS), MDX

ETL Tools SQL Server Integration Services (SSIS)

Data Analysis Tools SAS/Base, SAS/Stat, SAS/Macro, SAS/Graph,

SAS/SQL,

SPSS, R

SQL Server Tools SQL server Management Studio, SQL server

Query Analyzer, SQL server mail service, BCP,

SQL server profiler

Other Tools Microsoft Office, MS Visio, Matlab

SKILLS

EXPERIENCE

Nov. 12 - Till Date SQL BI / ETL Developer Confidential, Washington D.C

Responsible for implementing and maintaining MS SQL Server databases, and

designing reports using SSRS. Write new store procedures and functions

depending on the business requirements and tune them for optimum

performance.

. Involve in requirement gathering, analysis, design, development, change

management, deployment and user training.

. Actively participate in developing logical design of database

incorporating business logic and user requirements.

. Create and develop the stored procedures, triggers to handle complex

business rules, history data and audit analysis.

. Design dynamic SSIS Packages to transfer data crossing different

platforms, validate data during transferring, and archive data files

for different DBMS.

. Create packages SSIS for data extraction from Flat Files, Excel Files,

OLEDB to SQL Server using ETL Tool.

. Performance tuning the Stored Procedures used in SSIS Packages and SSRS

Reports.

. Develop parameterized reports, and implemented various reporting

features such as Chart Control, interactive sorting, expressions and

writing custom functions.

. Use SSRS subscriptions to schedule automatic delivery of SSRS reports.

. Involve in Performance tuning of ETL transformations, data validations

and stored procedures.

. Generate database monitoring and data validation reports in SQL Server

Reporting Service (SSRS) in Report writing according to business

requirement using SSRS.

. Design Cubes, Star Schema and Data models for Data Warehousing

Applications.

. Develop reports where the data extracted from SSAS cubes in SSRS.

. Use the Report Manager to create folder structures, modify data

sources, controlling access to Report Services resources.

. Optimize query performance by creating indexes.

. Move the static data from various text files to SQL Server 2012

database using BCP Import and Export, Bulk Insert.

. Write T-SQL statements for retrieval of data and Involved in

performance tuning of T-SQL queries and Stored Procedures.

. Provide support to the application developers on the application

databases.

. Configure and Deploy different reports in the Servers using SQL Server

2012 Reporting Services.

Environment: MS SQL Server 2012, Enterprise Manager, Management Studio,

Integration Services, Reporting Services, SSRS, DTS, Data Modeling,

Analysis Services, T-SQL, DB2, Tuning Advisor, ETL, SQL Profiler, SQL

Server Agent, BCP, and Microsoft Visual Basic, Windows Server 2000/XP

Jan 12 - Oct 12 SQL Server BI Developer Confidential Ashburn, VA

National Management Console (NMC) enables the creation, maintenance and

viewing of Verizon Product and Reference (Telecom) to support Ordering,

Provisioning and Billing applications from single source. National Console

is a common Repository for all retail telecom products & services for

Verizon. This is a 4-tier application with the client written in ASP.NET,

in-house Workflow engine to control role privileges, Validation engine on

BizTalk and SQL Server as its Relational database.

. Installed and configured SQL SERVER 2008 enterprise edition per client

request.

. Actively involved in creation of database, modified tables, triggers,

and store procedures to clean and validate the data about the cable

layout, so as to meet the company specifications.

. Designed automated scripts in T-SQL, and BCP to import data from

various ODBC sources into SQL Server databases to maintain the

consistency and data integrity.

. Exposed to data conversion from different data sources to SQL Server

2008 using SSIS.

. Involved in ETL (Extracting, Transforming and Loading) development

using SSIS for migration of data between legacy systems to SQL Server

2008.

. Developed scripts for tables, Stored Procedures, and SSIS, (SQL 2K5)

tasks.

. Generated database monitering and data validation reports in SQL Server

Reporting Service (SSRS).

. Developed parameterized reports, and implemented various reporting

features such as Chart control, interactive sorting, expressions and

writing custom functions. Used SSRS subscriptions to schedule automatic

delivery of SSRS reports.

. Created several Dashboards and Scorecards with Key Performance

Indicators (KPI) in SQL Server 2008 Analysis Services (SSAS).

. Extensively involved in writing MDX queries for various calculated

members.

. Created Maintenance plans for the Data Integrity and Backups.

. Maintained system monitoring jobs and provide high availability

support.

. Created partition table for very large database for good performance.

. Participated Databases Architecture and Data Modeling design.

. Reported all events and requirements through established reporting

mechanisms.

. Generated test data and tested database to meet the functionalities

deliverables in the project documentation and specifications.

Environment: SQL Server Reporting Services (SSRS), SQL Server Integration

Services (SSIS), SQL Server 2008, Windows XP.

Oct 10 - Nov 11 SQL Server Developer Confidential, Edgewood

NY

Broadridge is a leading provider of investor communications and technology-

driven-solutions to banks, broker-dealers, mutual funds, and corporations

globally.

. Understanding the requirement and technical direction of the

programming from BAs and Architectures.

. Involved in designing the data warehouse and core Database for the

system using Star Schema including tables, Stored Procedures, Indexes

etc. in SQL Server 2008.

. Served as technical expert guiding choices to implement analytical and

reporting solutions for complex financial scenarios

. Created/Updated Stored Procedures, Triggers, Functions, Cursor, Views,

and Indexes with extensive use of T-SQL.

. Design and develop SSIS (ETL) packages for loading data from Oracle 10g

and Flat files (3GB) to SQL Server and Oracle Database. Used Lookup,

Script Task, Oracle Bulk Loader, and Conditional Split, Derived Column,

Fuzzy Lookup, and Partition task, For-Each loop container in SSIS;

scheduled the same SSIS packages by creating the job tasks.

. Participated in creating Jobs for various packages that run at specific

schedule every day based on some dependencies.

. Created clustered and non-clustered indexes on tables for new database

to faster retrieval of data for the Reports.

. Used Bulking techniques, Table Partitioning to increase database

performance (40TB).

. Created various complex reports and manage those using SQL Server

Reporting Services.

. Created SSRS Report Model Projects in BI studio as well as created,

modified and managed various report models with multiple model objects,

source fields and expressions.

. Worked with .net Developers for developing custom codes for reporting

and excel services as well as for creating SQL Server Objects.

. Highly involved in creating, structuring, formatting using Report

Designer and Report Builder.

Environment: Windows 2003 Server, SQL 2008 Enterprise Edition, Oracle 10g,

Performance Point Sever 2007,T-SQL, ASP.NET2.0, C#.NET, ADO.NET, Microsoft

Visual Studio.Net 2005, .NET Framework 2.0, EXCEL2007

Contact this candidate