SUMMARY

• Around 7 years of IT work experience a MS SQL Server 2012/2008R 2/2008/2005/2000 developer in industries like Finance, Insurance.
• Conversant with all phases of the Software Development Life Cycle (SDLC) involving business process analysis, requirements gathering and analysis, detailed design, development, testing and post implementation support.
• Experience in writing stored procedures, creating views and triggers using MS SQL Server.
• Experience in modeling the organizational data and business rules; logical and physical designs of relational databases.
• Experience with SQL server reporting Services to generate report as per client’s requirement.
• Well verse with Relational database concepts and various data model including Star schema, Snowflake schema, and Fact and Dimension tables
• In - depth knowledge of Transact-SQL (DDL and DML). Proficient in creating Tables, Indexes, Joins, Triggers, Views, Stored Procedures, User Defined Data Types and Functions.
• Expertise in performing ETL using SSIS, DTS, Bulk Insert and BCP.
• Developed SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Expertise in upgrading/migrating from DTS to SSIS packages. Experienced in resolving complex issues and error handling in SSIS 2012/2008R 2/2008/2005.
• Experienced in report generation using Crystal Reports, XML, MS Access and Excel.
• Proficient in creating Chart reports, Drill down and Drill through reports by passing parameters using SSRS 2012/2008R 2/2008/2005.
• Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export and Troubleshooting.
• Expertise in VBA macros and MS-Excel (VLOOKUP and Pivot)
• A motivated, highly organized individual and enthusiastic team player with excellent communication, analytical and problem solving skills.

TECHNICAL SKILLS

RDBMS: MS SQL SERVER 2008 R2/2005/2000, MS Access, Oracle10g/9i/8i

Database Tools: Management Studio, Business Intelligence Development Studio, SQL Enterprise Manager, SQL Server 2005, Query Editor, Reporting Server, SQL Query Analyzer, and MS-Access

ETL Tools: Data Transformation Services (DTS), and MS SQL Server IntegrationServices (SSIS) 2008 R2/2005

Reporting Tools: MS SQL Server Reporting Services (SSRS) 2008 R2/2005

Data Modeling: MS Visio 5.0, ER-Win

BI Tools: MS SQL Business Intelligence 2008 R2

Languages: SQL, T-SQL, and PL/SQL

Operating Systems: Windows 2008 Server/7/ Vista/XP/2003 Server/2000

PROFESSIONAL EXPERIENCE

Confidential, Worcester, MA

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle db, and SQL 2005).
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.
• Filtered data from Transient Stage to EDW by using Complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.
• Used For-Each Loop Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Implemented business rules via stored procedures, middleware, or other technologies.
• Designed, coded, tested and implemented complex programs and scripts.
• Responsible for verifying accuracy of data, and maintaining and supporting the data warehouse.
• Responsible for creating database objects like Table, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Performed improvement of application by replacing the old cursor logic in various CTE by writing complex T-SQL queries.
• Used the SQL Server Profiler tool to monitor the performance of SQL Server to analyze the performance of stored procedure specific to the database.
• Worked on analyzing and performance tuning queries by looking at Query Statistics and Execution plans
• Supported and implemented BI solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity.
• Facilitated requirements gathering using expert listening skills and developed unique simple solutions to meet the immediate and long-term needs of business customers.

Environment: SQL Server 2012/2008 R2, Microsoft Visual Studio, MS Server Integration services, MS Excel, T-SQL, VB.NET, VB Scripting and Windows Server 2008.

Confidential, Buffalo, New York

MS SQL Server Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other applications in most efficient manner.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2008 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• 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.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database objects like stored procedures, functions, tables, views.
• Configured the report viewing security for various users at various levels using Report Manager.

Environment: MS SQL Server 2008R2, T-SQL, SSIS 2008, SSRS 2008, TFS 2010, Advanced Server, SSMS, Erwin.

Confidential, Marshalltown, IA

MS SQL Server Developer

Responsibilities:

• Worked in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into small iterations (of thirty days) called "sprints."
• Installing and configuring, upgrading theSQLServer Databases, Monitoring and Performances.
• Develops automated procedures to produce client data files on schedule using Microsoft Integration Services (SSIS).
• Developed and deployed SSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusingLookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimensionand more. Performed ETL mappings using MS SQL Server IntegrationServices.
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008 Reporting Services (SSRS).
• Maintaining database environments, backup and recovery, database security, tuning, administration and also involvement in the design and development of new databases.
• Installing and maintaining theSQLServer Databases, monitoringSQLagent jobs, assisting development teams with data cleansing, migration with reviewing, building, testing and maintaining database structures and SQLscripts.
• Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.
• Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future .

Environment: MS SQL Server 2008R2/2008, SQL server Reporting Services 2008R2/2008, SQL Server Integration Services (SSIS), VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, ERWIN, SQL Server Profiler, Database Engine Tuning Advisor.

Confidential

MS SQL Developer

Responsibilities:

• Collaborate with data architects for data model management and version control
• Create data objects (DDL).
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, Staging Database to data warehouse.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS.
• Developed and deployed SSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusingLookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimensionand more. Performed ETL mappings using MS SQL Server IntegrationServices.
• 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.
• Involved designing and developing packages for a Data Warehousing and Data Migrations projects using Integration services (SSIS) on different Data Sources.
• Developed Package Configuration by using SQL Server type for making Package dynamic.
• 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.
• Created reports from various migrated data sources into simple dashboards for easy reviewing.
• 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.
• Optimized schema, performance and capacity planning of various data transformation processes related to the reports.

Environment: MS SQL server 2012, MS Server Integration services, SSIS, DTS, SSRS, Profiler and Windows Server 2008, QlikView.

Confidential

MS SQL Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other applications in most efficient manner.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2008 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• 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.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database objects like stored procedures, functions, tables, views.
• Configured the report viewing security for various users at various levels using Report Manager.

Environment: MS SQL Server, T-SQL, SSIS, SSRS, TFS, SSMS, Erwin, ASP.Net, C#.