SUMMARY

• 9+ years of experience in Design, Development, Implementation and Maintenance of Data warehouse applications as an ETL/OLAP and OLTP Developer in MS SQL Server 7.0/2000/2005/2008.
• Experience in designing and implementing ETL environments using ETL strategies as well as tools like SQL Server BI Tools (SSIS and SSRS).
• Extracted data into Data warehouse Facts and Dimensions tables using SQL SERVER 2000/2005 Integrated Services (DTS/SSIS).
• Very good experience and knowledge on SCD Types (Type1, Type2) and Change Data Capture (CDC).
• Exposure in Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Fact and Dimensional tables, Physical and Logical data modeling using Erwin.
• Experience in Microsoft SQL 2005 Server migration from SQL Server 2000, Integration Service (SSIS), Crystal Reports and Reporting Service (SSRS).
• Excellent in High Level Design of ETL SSIS Package for integrating data from sources (Excel, CSV, flat file, Text Format Data).
• Expert in Creating, Implementing, Configuring and deploying the SSIS Packages from one server to other.
• Expert in migrate the DTS Packages to SSIS Packages by using Package migration Wizard.
• Expert in Designing SSIS Packages to Extract, Transform and Load (ETL)/ DTS data into the data warehouse from heterogeneous databases such as Oracle, DB2, MS Access.
• Extensive experience working with repositories such as Team Foundation Server (TFS), and Cheetah.
• 24/7 on call Production Support.

TECHNICAL SKILLS

Languages/ Web Tools: T - SQL, Visual Studio 2005/2008/2010/2012/2014 , VB.NET,C#, VBScript.

Databases/ RDBMS: SQL Server 2008R2/2008, 2005/ 2000.

Operating Systems: Windows XP/ 2000/ NT 4.0/ 98/ 95, and UNIX

Version Control: Team Foundation Server (TFS), Cheetah Tracking System

Other Packages/ Tools: MS Visio, SSIS (ETL), SSRS, Erwin, and Microsoft Office SharePoint Server 2007, Microsoft Office Access, Microsoft Excel.

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Senior Database Developer

Responsibilities:

• Gathered requirements from business analysts and documented them based on functional specifications.
• Created design document for the package that needs to be developed which includes the name, description and mapping information of the package.
• Worked on SharePoint 2007 for storing the design documents and documentation.
• Developed ETL package with different data sources (SQL Server, Flat Files, Excel Source files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services.
• Integrating heterogeneous data from sources such as DB2, Oracle, flat files and MS Excel to SQL Using SSIS.
• SSIS Components used extensively in the project are Merge join, Derived Columns, Look UP, Conditional Split and Multicasting.
• Designed and developed various packages using various task like For Each Loop, File System Task, Execute SQL task, Execute Process Task, Execute Package Task, Send Mail Task.
• Used SharedObjects to configure the SSIS package.
• Performed activities like analyzing and improving the databases objects.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost of the existing product databases.
• Created complex Stored Procedures for validation process & for loading data from the staging area to the product database in SQL 2008.
• Developed Complex Stored Procedures views, tables and generated TSQL script for application.
• Customized & optimized the existing stored procedures according to the Technical specifications and performed troubleshooting on the existing stored procedures.
• Used TFS to work on SSIS packages, Database objects and to write unit test cases for the stored procedures written.
• Replaced old back office AS400/iSeries source files with stored procedures for new back office system.
• Recreated packages with the new source as stored procedure to meet the requirement.
• Transformed end data into xml format and sends it to message queue through SSIS packages.
• Created rollout script for all the packages and objects that are to be deployed to QALAB and QFinal.
• Fixed various issues raised in testing environments.
• Created documentation for each and every package that has been worked on.
• Provides status updates to supervisor on weekly basis.
• Maintained technical knowledge through trainings and other measures.

Environment: SQL Server 2008/ 2008R2/2014, T-SQL, SQL Server Integration Services (SSIS), Microsoft Excel 2007, Visual Studio 2008/2010/2013 , SharePoint 2007.

Confidential, VA Beach, VA

SQL(SSIS) Programmer/DBA

Responsibilities:

• Developed ETL package with different data sources (SQL Server, Flat Files, Excel Source files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services.
• Created/Migrated packages from DTS packages to SSIS2005/ 2008 to SSIS2012.
• Involved in Upgrade and Migration of SQL Server 2005/2008R2 in placed, side by side to MS SQL Server 2012.
• Involved in Server Rebuild/Migration to a new machine.
• Used Red Gate for backups and maintenance jobs which include updating statistics, database integrity checks and RichCopy for copying the files from one drive to other.
• Used Bulk insert to load huge tables.
• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases.
• Created CIFS shares to back up the database to Network Mapped Drive, so that the drive appears in SSMS backup GUI while backing up the database.
• Developed and created the new database objects including tables, views, index, stored procedures, functions, triggers, advanced queries and also updated statistics
• Modified Stored Procedures and complex T-SQL queries to improve query execution process
• Created Logins, Roles and Proxy accounts with appropriate permissions and maintaining Database Maintenance Plans
• Configured DB mail by creating accounts and profiles.
• Provided On call Production support.
• Implemented partitioning on large table to get the performance.
• Tuned stored procedures by using execution plans.
• Used table hints in the queries to avoid locks in the server.
• Worked on everyday tasks and tickets based on priority levels from TFS ticketing system and Cheetah tracking system and saved/ updated all scripts related to the tasks in TFS using visual studio 2012.
• Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
• Debugged and Deployed SSIS packages in to file system server and MS SQL Server with the help of manifest file.
• Microsoft Access database development and support of tables, reports and forms and created analysis reports as the requirement.
• Fixed various issues regarding the front end Access forms/reports.
• Provided 24/7 Support for Production, Development& Test Servers of MS SQL Servers.
• Worked on Crystal reports and created reports like Sub Reports and Parameterized reports.
• Creates stored procedure or view according to the requirement and created reports using this Stored Procedure or view.
• Used Business View Manager to create dynamic prompt for reports
• Worked with report manager for deploying the reports across all the environments
• Experience in creating multiple reports (SSRS) in Drill mode using tables.
• Created Adhoc reports based on the user requirements and worked on different on-demand reports.
• Involved in crystal report generation and also generated EXCEL based reports for business users.

Environment: SQL Server 2008, 2008R2, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Crystal Reports, Microsoft Access 2007, Visual Studio 2008,2010, Microsoft Office Access.

Confidential, Schaumburg,IL

SQL/BI Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Designed the Entity Relationship(ER) models and logical data (LDM), physical data (PDM) models based upon the design documents.
• Extensively worked on full Software Development Life Cycle (SDLC) of the project from Database Design and Modeling to implementation and maintenance.
• Designed and Developed SSIS Staging Packages to Stage Source files to SQL Server Source Database
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• SSIS Components used extensively in the project are Merge join, Derived Columns, Look UP, Conditional Split and Multicasting.
• Designed various packages using various task e.g. For Each Loop, File System Task, Execute SQL task, Execute Process Task, Execute Package Task, Send Mail Task.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost of the existing product databases.
• Created complex Stored Procedures for validation process & for loading data from the staging area to the product database in SQL 2008.
• Deployed SSIS packages from Development to Testing Servers
• Worked on all activities related to the development, implementation and Support of ETL processes for large-scale Data Warehouses using SQL Server SSIS
• Created and developed query for Tabular and Matrix Reports using SQL Server 2008 Reports Services (SSRS)
• Created Drill-through reports, parameterized reports and linked reports using SSRS 2005 and 2008.
• Worked on Report generation using SQL Server Reporting Services (SSRS) that could be used to send information to Client.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Promoted RDLs to Reporting Service Server (SSRS).

Environment: SQL Server 2008,2008R2, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Profiler, Microsoft Access 2007,Erwin,Sharepoint 2010,Visual Studio 2008,2010.

Confidential, Alpharetta GA

SQL BI and Data Warehousing Developer

Responsibilities:

• Gathered requirements from business analysts and documented them based on functional specifications.
• Integrating heterogeneous data from sources such as DB2,Oracle,MS Access, MS Excel to SQL Using SSIS.
• Worked on SSIS design pattern using parent-child package structure.
• Requirement gathering & designing for new initiatives/enhancement requests.
• Performed activities like analyzing and improving the databases, creation & indexing of the tables.
• Created Stored Procedures, triggers, views, tables and generated TSQL script for application
• Developed Complex Stored Procedures and Functions for the custom objects.
• Customized & optimized the existing stored procedures according to the Technical specifications and performed troubleshooting on the existing stored procedures.
• Created indexes for better performance
• Designed and implemented stored procedures and triggers for automating tasks.
• Performed unit testing on reports, and monitored the performance of the reports.
• Performed Optimization and Performance tuning of the Stored Procedures.
• Troubleshooting performance issues, optimizing and improving the performance of SSIS packages using performance monitoring, SSIS Logs.
• Provided ongoing technical support in the production environment.
• Tested the data with complex queries, joins and sub queries.
• Created SSIS packages to migrate data from different data sources to data warehouse.
• Successfully Extracted transformed and load data into data warehouse using SSIS.
• Modified existing SSIS packages to meet changes specified by the users
• Created Tabular and Matrix and Sub reports using the SQL Server Reporting Services SSRS.
• Used Team Foundation Server (TFS) for version control, source control and reporting.

Environment: SQL Server 2005, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Query Analyzer, MS Access, and SQL profiler.

Confidential, Yankton, SD

SQL Developer

Responsibilities:

• Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
• Successfully resolving SQL Server problems, which involve in-depth knowledge of SQL Server connectivity, replication, backup/restore, database corruption, security, SQL Server management Studio (SSMS), SQL server profiler, SQL server Agent, programming etc.
• Used the Execute DTS 2000 package task to execute DTS packages.
• Created Data Transformation tasks using BCP, BULK, INSERT to import/export data from clients
• Performed layout and installation of new computer systems and modifications of existing workstations and Windows 2000 Server
• Created DTS packages to validate, extract, transform and Load data from different sources to the data warehouse and data mart databases.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes, views and user security management.
• Developed processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations.
• Administered SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.

Environment: SQL Server 2000, T-SQL, DTS, SQL Server 2000 Reporting Service, VSS, Windows 2000 Server, MS Access, Enterprise Manager, Query Analyzer, and SQL Profiler.

Confidential

SQL Developer

Responsibilities:

• Complete analysis, requirement gathering and function design document creation.
• Written various T-SQL Statements for the purpose of application development.
• Responsible for the designing the advance SQL queries, procedure, cursor, triggers, scripts.
• Collaborated with the application developers in data modeling and E-R design of the systems.
• Also created, modified, maintained and optimized SQL server database.
• Maintained the documents and create reports for the business analysts and end-users.
• Responsible for the management of the database performance, backup, replication, capacity and security.
• Coordinating user acceptance testing amongst business users.
• Developed many T-SQL stored procedures, views, indexed views, UDF for business reporting.

Environment: SQL Server 2000, T-SQL, and Windows XP/2000.