SUMMARY

• Over 7+ years of MS SQL Server Development experience in Insurance, Banking, Pharmaceuticals, Finance and Health care domains with expertise in MS SQL Server 2005/2008/2012 and over 5 years of experience in Confidential ’s Business intelligence stack products like SSIS and SSRS.
• Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Expert in TSQL-DDL/DML/DCL, perform most of the SQL Server Management Studio functionality using T-SQL Scripts.
• Experienced in Creating, Configuring and Fine-tuning ETL workflows designed between Homogenous and Heterogeneous Systems using SSIS.
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008/2012) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Excellent skills in implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets.
• Proficient in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008/2012) generate drill down reports, drill through reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008.
• Good understanding of Normalization /De-normalization and database design methodology.
• Extensive experience in creating database objects such as Tables, Constraints, Indexes, Views, Indexed Views, Stored Procedures, Triggers and Cursors on Confidential SQL Server.
• Excellent skills in Database backup, Replication, recovery, restoration, DTS and Linked servers.
• Experience in using recursive CTEs, CTE, temporary tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Proficient in tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.

TECHNICAL SKILLS

Databases: SQL Server 2005/2008/2012, Oracle 9i/10g, MYSQL, Teradata v12/13

ETL Tools: SSIS(2005/2008/2012), SQL Server Import/Export Wizard, Informatica

Reporting Tools: SSRS (2005/2008/2012), Business Objects.

Operating Systems: All Windows client and server platform.

Programming: T-SQL, PL/SQL, C/C++, Core Java, .Net, Teradata SQL.

Software’s: MS-Office 2000/2003/2007, Adobe Dreamweaver, Rational Rose

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

MS SQL Server Developer/BI Developer

Responsibilities:

• Developed migration scripts for conversion of existing systems into new Services CRM solution (MPN membership .Next Project).
• Designed SSIS Packages to extract, transform and load (ETL) existing data into SQL Server 2012.
• Wrote highly complex T-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.
• Worked on different transformations like Merge join, Look up, Conditional Split, Union all, Script Component, Aggregate, Data Conversion etc.
• Used joins and sub-queries in queries to retrieve data from multiple tables.
• Worked individually on designing technical documents by gathering required logic for the project.
• Wrote Unit test cases for the Build packages, and analyzed various transformation rules.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Experience in creating database objects such as Tables, Constraints, Indexes, Views, Indexed Views, Stored Procedures, Triggers and Cursors on Confidential SQL Server.
• Created deployment environment for the packages in order to migrate data to CRM.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services to overcome transformation constraints.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups.
• Migrated DTS packages to SQL Server Integration Services and modified the existing packages by using the advanced features and tools.

Environment: MS SQL Server 2012, SSIS 2012, DTS, T-SQL, Visual Studio 2012, Share point, SQL Server Management Studio, SQL Server Business Intelligence Development Studio(BIDS), CRM Web Services, Agile/Scrum.

Confidential, Seattle, WA

MS SQL Server Developer/BI Developer

Responsibilities:

• Created tables, stored procedures, views, functions, indexes and triggers using T-SQL in development and production environment.
• Designed data models using Erwin.
• Experience in Confidential Business intelligence stack products like SSIS and SSRS.
• Developed physical data models and create DDL scripts to create database schema and database objects.
• Planned, created and normalized the tables for the project.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using SQL Server SSIS.
• Created ETL packages using Heterogeneous data sources (SQL Server, Oracle, Flat Files, Excel source files, XML files etc.,) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
• Used different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component etc.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and shrinking of databases and regular monitoring.
• Generated various reports with drilldowns, drill through, calculated members, and dropdowns from the cubes by connecting to Analysis server and SQL Server from SSRS.
• Developed complex stored procedure using T-SQL to generate ad hoc reports using SSRS.
• Efficient use of Joins and sub-queries in queries that retrieve data from multiple tables.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery whenever needed.
• Created triggers to enforce data and referential integrity, on the specific table which helped users to prevent inserting invalid data or to respond to a certain events like insert, update and delete.

Environment: MS SQL Server 2008/2012, SSIS 2008/2012, SSRS 2008/2012, DTS, T-SQL, OLAP Service, Visual Studio 2005, SQL Server Profiler, Windows Sever 2003/2008, Share point, SQL Server Management Studio, SQL Server Business Intelligence Development Studio(BIDS).

Confidential, Kingston, NY

MS SQL Server Developer/BI Developer

Responsibilities:

• Installed and Configured SQL Server 2005/2008 enterprise edition per client request.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Rules, Defaults, user defined data types and functions in SQL Server.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2005/2008.
• Experience in creating SSIS packages with Error Handling.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Used incremental loads to load data from data source to SQL server.
• Migrated SSRS 2005 reports in to SSRS 2008 reports - database warehouse application for the reports was connected to their Teradata data warehouse application for importing and analyzing data.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drill down, drill-through, sub-reports, navigation reports (Hyperlink) etc.
• Changed stored procedures according to the new hierarchy.
• Configure backup/recovery strategy per client request. Full Back up database on specific time, transaction log backup using different check point per client request.
• Experience in tuning of Stored Procedures and query optimization to improve the performance and eliminate the deadlock situations and hang-ups on server.
• Involved in dimensional modeling with Star &Snowflake schemas and created the Data Source Views (DSV) and Cubes using the identified Fact and dimension tables.
• Generated Reports using Global Variables, Expressions and Functions for the reports.

Environment: Confidential SQL Server2005/2008, SQL Server Reporting Services (SSRS), Management studio, SQL Server Integration Services (SSIS), T-SQL, PL/SQL, Erwin 7.3, ER Studio 8.0.1, MS Excel, T-SQL, Teradata

Confidential, Wilmington, DE

MS SQL Server Developer

Responsibilities:

• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Used highly complex T-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Used multiple join statements to retrieve data from multiple tables.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Created various DTS packages for data transfer and migration.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Worked as a developer in creating complex Stored Procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Creation/ Maintenance of Indexes for fast and efficient reporting process.
• Created reports using stored procedure that involved in scheduling, creating snapshots and subscriptions for the reports (SSRS).
• Responsible for creating Summary reports, Sub reports, Drill Down reports, Matrix reports.
• Created ad-hoc reports using SQL server 2005 Reporting Services (SSRS).
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Involved in project planning also schedule for database module with project managers.

Environment: MS SQL Server 2005/2000, MS Excel, Windows 97/2000/XP.

Confidential

MS SQL Server Developer

Responsibilities:

• Developing T-SQL queries, triggers, functions, cursors and stored procedures.
• Responsible for logical and physical design of SQL Server databases.
• Alter the schema for the required objects.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created views to restrict access to data in a table for security.
• Expert in extracting data using SSIS from OLTP to OLAP.
• Performed Bulk data migration using DTS and SSIS from flat files.
• Designed and optimized all the SSIS packages.
• Created SSIS packages to Export data from text file to SQL Server Database.
• Designed and implemented stylish report layouts.
• Identified the Data Source and defining them to build the Data Source Views.
• Identified and defined the Datasets for report generation and also included report parameters.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Implemented full and differential backups and also created and managed DB objects.
• Make recommendations for File group Creation and Placement.
• Scheduling backups and automating weekend maintenance tasks.
• Administering MS-SQL Server, performing day-to-day tasks such as Database tuning by checking indexes.

Environment: SQL Server 2005/2000, T-SQL, MS Reporting Services, Management Studio, Query Analyzer, Windows 2003/2000 Server, Oracle.

Confidential

MS SQL Server Developer

Responsibilities:

• Carried out a developer’s role on MS SQL Server2000 and MS Access databases (using DTS, T-SQL, Stored procedures and Views).
• Involved in generating reports using third party tools.
• Worked on MS SQL server tasks such as data loading, batch jobs, BCP, DTS and indexes.
• Created and automated regular jobs such as daily/weekly report generations.
• Managed and monitored system utilization.
• Managed backup and disaster recovery of the systems.
• Managed the security of the servers, as a part of administration duties.
• Developed complex T-SQL code for the application.
• Designed and implemented the stored procedures and triggers for automating tasks.
• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.

Environment: MS SQL Server 2000, Windows NT 4.0 Server, Windows NT, T-SQL and Erwin 4.0