Sql Server Data

Sherry Tu

Email id: ******.****@*****.***

Phone:973-***-****

C2C or CTH

Professional Summary

●Over 8 years of IT experience as MS SQL Server Developer 2014/2012/2008 R2/2008/2005/2000 and MS Access in various Industry verticals like Insurance, Telecommunication and Bank.

●Strong experience in Stored Procedure, User Defined Function, TSQL coding, Performance Tuning and Query Optimization.

●Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.

●Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.

●Expert in creating all the different stages of the Data Warehousing packages includes extracting, migrating, loading data.

●Hands on experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin data model.

●Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing, complex nested queries.

●Expertise in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Data Transform Services (DTS), Bulk Insert and BCP.

●Involved in developing stored procedures, triggers for the application.

●Familiar with Metadata knowledge and experience in creating E-R Diagram

●Expert in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.

●Expertise in developing SSIS Packages and using data transformations and deploying them on various production servers. Expertise in Database Administration on Production Server with server configuration, patch, upgrade, maintain and migrate databases.

●Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2008/2005 (SSRS).

●Highly skilled in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008/2005.

●Enhanced various existing MS Access 2007 database applications. Migration of MS Access 2003 databases to MS Access 2007. Enhanced existing and designed new MS Access 2007 tables, queries, forms, reports, macros, modules and switchboards.

●Adept in defining referenced relationships and calculated members in SSAS and used MDX queries. Creating user accounts and appropriate privileges as well as maintaining database security

●Confident in work independently and proactively. Strong leadership, communication, problem-solving and multi-tasking abilities.

●Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.

●Extensive knowledge in developing and implementing Disaster Recovery Model, and Replication Models, and experience in Meta Modeling concepts

●Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.

●Maintained positive communications and working relationships at all business levels.

Education

Bachelor in Engineering

Skillset

MS SQL Server 2014/2012/2008 R2/2008/2005/2000/7.0, MS SQL Server 2008/2005 Analysis Services (SSAS), MS SQL Server Integration Service (SSIS), MS SQL Reporting Services (SSRS), Microsoft Access 2000/8.0, Business Object 3.1, Microsoft Excel, Outlook, MS SQL Profiler, SQL Query Analyzer, Database engine tuning advisor, Toad, Power Designer 16.0, 16.5, Vb.net, Erwin Data Modeler 7.2/4.2/4.1, Excel VBA, Crystal Reports 8.5, T-SQL, MS Visio 2005, Windows 2003/2000 Advanced Server/Professional, Windows NT 4.0 Server/Workstation.

Professional Experience

Client Name: Nuveen Investments, Chicago, IL December 2014 to Present

Role: Sr. Business Intelligence Developer/ Sql Developer

Nuveen Investments is a Chicago-based company in the asset management industry. Since the 19th century, Nuveen Investments has played a role in driving economic growth through the innovative financing of streets, schools and water projects. Today, investment strategies span fixed income to global equity and alternatives.

Job Description

The purpose of this project is to develop applications to integrate data from different data sources to destination databases and generate different kinds of reports using SSRS for inter user’s and do the migration of a large number of DTS packages in SQL Server.

Responsibilities

●Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.

●Complex nested queries, SQL statement knowledge to deal with ambiguous and duplicated data and using inner join/outer join in T-SQL

●Used ETL to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse.

●Involved in writing stored procedures, Triggers, User-defined Functions, sub-queries, views and Cursors for both Online and Batch requests handling business logic and functionality of various modules. Experience in creating joins for complex queries involving multiple tables.

●Implemented the Error handling in the Stored Procedures and SQL Objects and also modified already existing stored procedures, triggers, views, indexes depending on the requirement.

●Involved in query optimization and tuning stored procedures for better performance.

●Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc.

●Experience in creating complex SSIS packages using proper control and data flow elements.

●Worked on different kinds of Transformations (Data Conversion, Lookup, Derived Column, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Slowly Changing Dimension, Union All etc) in SSIS as per the clients Requirement.

●Experience in providing Error handling by using Event Handler for SSIS Packages.

●Worked with different methods of logging in SSIS.

●Configured and maintained Report Manager and Report Server for SSRS.

●Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2012.

●Done Statistical Data Modeling and worked with statistical programming languages for Data analysis and data mining.

●Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.

●Involved in Migration of SSRS 2005 to SSRS 2012.

●Created stylish Report Layouts and Deployed the Reports using SSRS 2005.

●Identified and worked with Parameters using complex expressions for parameterized reports in SSRS 2005.

●Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.

●Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.

●Knowledge in Data Warehousing, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.

●Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using, Data Transformation Services (DTS) and SSIS with MS SQL 2005/2008.

Tools & Technologies: MS SQL Server 2012/2008 R2, T-SQL, SSIS, SSRS, Business Object 3.1, Oracle 11g, ODBC, Microsoft Excel

Client Name: America Online, Dulles, VA January 2014 – November 2014

Role: Sql developer/BI Developer/Data Modeler

AOL Inc. (previously known as America Online) is an American multinational mass media corporation based in New York City that develops, grows, and invests in brands and web sites. The company's business spans digital distribution of content, products, and services, which it offers to consumers, publishers, and advertisers.

Job Description

The project was to load data from heterogeneous sources to merge into the already existing Data warehouse and create report as well as deploy the report in SSRS.

Responsibilities

●Prepared Target List For Vendors and Response Data from Vendors.

●Prepared File Interface Agreement Document.

●Working on Jobs Schedules for Vendor Requirement and Deployment in SSIS Catalog.

●Work on views and Store procedure to get data inbound and outbound.

●Create tabular and summary reports for data validation.

●Perform all SDLC phases related to extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and SQL Server T-SQL stored procedures within SQL Server 2012 environment.

●Conduct business intelligence for data transformation; develop analytics portal and create visualized reporting through Jaspersoft for stakeholders to make informed decisions.

●Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.

●Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.

●Maintained Batch logging, Error logging tables and handled errors using Event handlers.

●Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.

●Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.

●Involved in deploying, configuring and managing reports using Report Manager and Report Builder.

●Complex nested queries, SQL statement knowledge to deal with ambiguous and duplicated data and using inner join/outer join in T-SQL

●Formatted the reports using the Global variables and expressions.

●Reviewed and fine-tuned stored procedures and triggers before production migration.

●Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report, Analytical Cube or an Excel pivot table. Migration of MS Access 2003 databases to MS Access 2007.

●Produced operational reports in SSRS 2008 i.e. drill-down, drill-through, dashboard and matrix reports.

●Provided design, implementation and maintenance for custom reports and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.

●Converted manual reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2008.

●Applied data mining techniques to process and build model as to assess the effect of news on stock prices

●Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder for report server to create reports. Troubleshooting and Performance Tuning in SQL Server.

●Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.

●Worked with project manager and technical leads for resolution of technical issues.

●Defined appropriate measure groups and KPIs & deployed cubes.

●Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

●Worked on formatting SSRS reports using the Global variables and expressions.

●Created parameterized reports, Drill down and Drill through reports using SSRS.

●Diagnoses and resolved data mart access and performance issues

●Responsible for the creation and maintenance of Analysis Service objects such as Cube, Dimensions, MDX queries, and KPI’s. Experience and extensive knowledge in Meta Modeling concepts

Tools & Technologies: MS SQL Server 2012/2008 R2, T-SQL, SSIS, SSRS, SSAS, Erwin 7.2, Microsoft Access, Oracle 10g

Client Name: PNC bank, Pittsburgh, PA July 2012 – December 2013

Role: Senior MS SQL Server/SSIS/SSRS Developer/ Data Modeler

PNC Financial Services Group, Inc. is an American financial services corporation, with assets of approximately $345.2 billion.

Job Description

This project was to design, create, and administer the data from Oracle and Ms Access 2007 to SQL Server 2012 by creating various SSIS Packages, to be used for generating different reports depending on the business requirements.

Responsibilities

●Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.

●Responsible for creating database objects like Views, Store Procedure, Triggers, Functions etc. Complex nested queries, SQL statement knowledge to deal with ambiguous and duplicated data and using inner join/outer join using T-SQL 2012/2008 to store data and to maintain database efficiently.

●Responsible for the creation Dimensions, MDX queries.

●Used ETL to implement the SCD transformation, to maintain historical data in data warehouse. Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS.

●Developed and deployed data transfers packages using SSIS 2012/2008, also maintained the jobs running on Servers.

●Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Staging DB to Data warehouse and Data marts.

●Wrote SSIS Packages to migrate user’s logins, stored procedures, and functions.

●Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.

●Performed Meta data mining to uncover day facto standards and tuning objectives.

●Deploying, Testing and Scheduling SSIS packages using SQL Agent.

●Developed Custom Functions, Manual Running Totals and Complex Formulas for reports used calculations, sorts, filters and sections to enhance data presentation in reports.

●Created many Cascaded parameters in the reports using SQL SSRS 2012/2008. Developed many Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS 2012/2008).

●Highly involved in automating reports generated weekly and monthly basis for the client and business sales teams.

●Worked with production control team to deploy code and for schedule run in both staging while testing and production. Responsible for providing 24/7 on-call production support for daily job and ETL loads.

●As in development team, worked with DBA teams for database update and system restarts.

Tools & Technologies: MS SQL Server 2012/2008 R2, T-SQL, SSIS, SSRS, Win 2003 Advanced Server, Erwin v7.2,

Client Name: United Health, Orlando, FL October 2011 – July 2012

Role: MS SQL Server Developer Lead/ETL Developer

UnitedHealth Group Inc. is a diversified managed health care company headquartered in Minnetonka, Minnesota, U.S. UnitedHealth Group offers a spectrum of products and services through two operating businesses: UnitedHealthcare and Optum.

Job Description

The project involved designing a new database schema and migrating databases to Production environment, modifying database structures, providing support and guidance to operational models by checking for data quality and its consistency.

Responsibilities

●Planned, Defined and Designed data based on business requirement and provided documentation.

●Gathered data and documenting it for further reference.

●Designed Database using Erwin data modeler.

●Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Cache Transform, Conditional Split and Derived column etc.

●Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.

●Evaluation & selection of COTS products for data visualization (Qlikview, Tableau, Jaspersoft etc)

●Developed SSIS packages using Fuzzy Look Up and Fuzzy Grouping for data cleansing purpose.

●Used SSIS Variables for storing the values, which are used in various components of Data Flow Task. Experienced in Batch processes, Database Monitoring tools and Application support.

●Developed Unit Test Plans for SSIS packages for checking the functionality of each component.

●Modified the existing SSIS packages to meet the changes specified by the users.

●Trained on building Conceptual, Logical and Physical data model.

●Created the conceptual model for the data warehouse with emphasis on insurance (life and health)

●Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.

●Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis.

●Reviewed the conceptual EDW (Enterprise Data Warehouse) data model with business users

●Created the Load packages for loading the CSV files from DB2 into SQL Server using SSIS 2008.

●Generated parameterized reports, sub reports, tabular reports using SSRS-2008.

●Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.

●Generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using SSRS 2008.

●Created reports to retrieve data using Stored Procedures that accepts parameters. Complex nested queries, SQL statement knowledge to deal with ambiguous and duplicated data and using inner join/outer join in T-SQL

●Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard

●Responsible for Monitoring and Tuning Report performance.

●Configured the report viewing security for various users at various levels using Report Manager

●Scheduled report and exported in PDF format.

Tools & Technologies: MS SQL Server 2008, SSRS, T-SQL, SSIS, Win 2003 Advanced Server, Erwin v7.2.

Client Name: Bank of American, Plano, TX January 2010 – September 2011

Role: SQL Developer/BI Developer/Data Analyst

Bank of America is an American multinational banking and financial services corporation headquartered in Charlotte, North Carolina. It is the second largest bank holding company in the United States by assets.

Job Description

The project was mainly on migration data by utilizing SSIS from database sources like Excel, MS Access, Flat File to MS SQL server and Generate Report using SSRS.

Responsibilities:

●Reversed engineer backend database to change the T-SQL scripts, create Views, Index, Stored Procedures, Triggers, CTE, Constraints and UDF to improve performance drastically.

●Created various types of performance reports from the TFS server database using SSRS.

●Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, PSD (Staging Database) to data warehouse (PDW).

●Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS.

●Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.

●Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.

●Created jobs on daily basis and schedule job to update recent data by using SQL Server Agent jobs.

●Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment using Sql Server Reporting Services(SSRS).

●Scheduled execution and delivery of end of the day report using SSRS.

●Participated in reviews of issues related to SSRS reports and work in troubleshooting those issues, fixing, testing and deploying them.

●Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler and Database Engine Tuning Advisor.

Tools & Technologies: MS SQL Server 2008, SQL Server Reporting Services 2008, SQL Server Integration Services 2008, SQL Server Analysis Services 2008, Windows 2003/2000 and T-SQL.

Client Name: Dupont November 2007 – December 2009

Role: MS SQL Server Developer

Job Description

It provides benefits of modern IT infrastructure with powerful reporting capabilities via SSRS. Power User will leverage from analytics capabilities offered by tool in excel 2007 generate metrics/KPIs for strategic and corporate management whereas other business users will use canned reports for their operational analysis.

Responsibilities:

●Designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front-end application.

●Designed and modeled Microsoft SQL Server 2005 data warehouse and data marts, including the modification of existing Microsoft SQL Server 2000 data warehouse and data marts.

●Used SSIS packages to roll our data to Live Tables and to Processing Database. As Database Administrator in full-service event-management company I was responsible for managing and maintaining databases entry in Access, Excel and had responsibilities to assist in events organization and preparation.

●Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager

●Configure the SSIS Package for run time Parameters and Configured file

●Develop the Documents for Logging/Error Handling for SSIS Packages

●Integrate the SSIS package, converting all existing DTS packages of MS SQL 2000 to 2005 by adding extra SSIS task.

●Schedule Package using SQL Server Job for weekly/monthly basis.

● Used Checkpoint for avoiding re-executes Package from the first task.

●Develop the Slowly Changing Transformation to maintain the Historical Data.

●Handling the errors during data moving and Sequencing the task as per requirements.

●Perform T-SQL tuning and optimizing queries for Reports, which take longer, time in execution SQL Server 2005.

●Migrated some Crystal reports to SSRS reports manually. Troubleshooting and Performance Tuning in SSIS.

●XML result set from Stored Procedures to create custom XML file for third party data export.

●Extensive work on SSIS creating all the interfaces between front end application and SQL Server 2008 database, then from legacy database to SQL Server Database and vice versa.

Tools & Technologies: SSIS, MS SQL Server 2008, Windows 2003

Contact this candidate