SUMMARY

• Over 8 years of MS SQL Server Development experience in Semiconductors, Insurance, Banking, Pharmaceuticals, Finance and Health care domains with expertise in MS SQL Server 2000/2005/2008/2012 and over4+years of experience in Confidential ’s Business intelligence stack products like SSIS and SSRS.
• Worked extensively on System Analysis, Design, Development, Testing and Implementation of Projects (Complete SDLC) in Client/Server applications using Confidential SQL Server 2005/2008/2012 and BI Suite for various domains.
• Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions and SQL joins.
• Expert level skills in Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Very good experience on Extraction, Transformation, and Loading (ETL) solutions using SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• 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.
• Expert in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Extensive level of experience in designing complex reports by using SSRS, Crystal Reports and 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.
• Expert in understanding needs, focusing on the critical issues, translating them into technical actions and implementing a resulting database.
• Excellent skills in Database backup, Replication, recovery, restoration, DTS and Linked servers.
• Optimized T-SQL queries using execution plan, update statistics and indexes to improve their performance.
• Proficient in using Index Tuning Wizard, SQL Profiler, Windows Performance Monitor, DBCC commands for monitoring and tuning MS SQLServer performance.
• Extremely motivated, diligent, conceptually strong team player with an ability to take new role.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills.

TECHNICAL SKILLS

Databases: SQL Server 2005/2008/2012, Oracle 9i/10g, DB2, 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, SharePoint 2010, Teradata SQL

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

PROFESSIONAL EXPERIENCE

Confidential, CA

SQL Application Developer

Responsibilities:

• Worked closely with the Project Manager, Business users, Lead Systems analyst and the Technical Development Lead to understand the requirements.
• Accomplished tasks by gathering the requirements and elicitation, documentedbusinessrequirements.
• Exploring and preparing the various technical design options to meet the requirements in an efficient manner. Development based on design.
• Studied the existing source tables and created facts, dimensions and star schema representation for the data mart.
• Created databases, tables, views, functions, stored procedures, cursors and triggers using T- SQL for the interaction of transferring data to and from screens to the backend, at optimum performance.
• Expertise in developing complex, legible and well-structured scripts, queries and stored procedures in SQL.
• Created indexes, Constraints and rules on database objects for optimization. Involved in performing database Backup and Recovery.
• Expertise in writing and debugging stored procedures and dynamic queries.
• Created DQ views to test Data Quality between staging and fact data.
• Functionality Testing and bug fixes/issue resolution during the various quality assurance testing cycles.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Created triggers to enforce complex business rules 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.
• Worked with complex SQL statements using joins, sub queries, correlated sub queries, error handling on SQL errors, transactions etc. Dynamic SQL statements are constructed and executed dynamically during run time, based on supplied users.
• Developed test requirements, prepared and documented test data for unit and system testing.
• Used DBCC commands to check physical and logical consistency of the databases and to rebuild indexes.
• Experience in using recursive CTEs, CTE, temporary tables, table variables 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.
• Created the clustered/non-clustered indexes on tables, and traced out for any table required any indexes and determine the type of index on it.
• Experienced in using Teradata SQL Assistant for loading EDW data to SQL Server.

Environment: MS SQL Server 2008/2012, Teradata 12/14, Visual Studio 2012, Share point, SQL Server Management Studio, SQL Server Business Intelligence Development Studio(BIDS), Agile/Scrum, Confidential Excel, SSIS 2012, Confidential access.

Confidential - Redmond, WA

MS SQL Server Developer/BI Developer

Responsibilities:

• Worked with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.
• Gathered business requirements and works with data analysts on physical database design and modeling like Tables, their relation to other tables and the fields contained within each table.
• Created technical documentation of design logic and ETL processes based on technology best practices, guidelines and repeatable processes.
• Developed migration scripts for conversion of existing systems into new Services CRM solution.
• Designed SSIS Packages to extract, transform and load (ETL) existing data into SQL Server 2012.
• Wrote complex T-SQL Queries (Stored Procedures, Merge statements, Cursors) and SQL Scripts to perform efficient data load based on complex Business rules.
• Used different Control Flow Tasks, Containers and Data flow Tasks for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and data cleansing from different Sources into Company Formats.
• Worked on different transformations like Look up, Conditional Split, Union all, Script Component, Aggregate, Data Conversion, Derived column etc.
• Experience in providing Loggings, Error handling (on Error, on Task Failed etc.) by using Event Handler and various package configurations.
• Wrote unit test cases for the build packages, and analyzed various transformation rules.
• Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server.
• 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. Used joins and sub-queries in queries to retrieve data from multiple tables.
• Created ETL packages using Heterogeneous data sources (SQL Server, Oracle, Flat Files, Excel source files, Teradata etc.,) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
• Support QA (resolve issues and release fixes) UAT and production support when required.

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

Confidential - Seattle, WA

MS SQL Server Developer/BI Developer

Responsibilities:

• Involved in planning, defining and designing data based on business requirement and provided documentation for further reference. Involved in installation and configuration of MS SQL Server 2005/2008.
• Involved in designing database and perform forward engineering, from conceptual data model to Logical and physical data model using Erwin 7.2 data modeler tool.
• Developed physical data models and create DDL scripts to create database schema and database objects.
• Wrote complex Stored Procedure, Queries, Triggers, User-defined functions as per the business requirements.
• Experience in Confidential Business intelligence stack products like SSIS and SSRS.
• 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 packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop).
• Developed Master Child Package by using Execute Package Task and Parent Package Variable Configuration.
• 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.
• 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:

• Transformed data from different data sources like Oracle, Flat files, SQL data bases to SQL Server 2008 using OLEDB connection providers by creating various SSIS packages. Data is transformed from hub (ODS) to data warehouse.
• Designed SSIS Packages to extract, transfer and load (ETL) existing data into SQL Server 2005/2008.
• Experience in enhancing and deploying the SSIS Packages from development server to production server. Migrated the data from the appropriate databases to end database and maintained batch log files. Involved in the usage of variables to make the packages dynamic and scheduling the package in SSIS (sequential scheduling).
• Implemented AD HOC reporting with the report builder for the end users. Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.
• 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.
• Enhanced the business logic using User Defined Functions to retrieve information on the services like Retailers Debit, Credit etc.
• Used Profilers and index tuning wizards for performance improvement of data issues.
• Experience in Teradata (BTEQ, Multiload, Tpump, Fast Load, Fast Export and Teradata SQL assistant).
• 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.
• Had experience in working with Risk assessment, insurance claims, when they expire, if multiple insurance which one they should choose, all this types of data.
• 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