Summary:-

• Senior SSIS/SQL Developer having Masters Degree in Computer Application with 8+ years of IT experience in Requirement Gathering, Analysis, Design, Development and Implementation of Enterprise solutions.
• 6+ years of experience with MS SQL Server 2008 R2/2008/2005/2000 using SSMS/T-SQL/SSIS/SSRS.
• 6+ years of working experience on ETL Tools (SSIS and Pervasive’s Data Integrator).
• 3+ years of working experience with Oracle 10g/9i/8i databases using PL/SQL.
• Extensively worked on Design, Development, Deployment & Maintenance of ETL process using SSIS and Pervasive Data Integrator to Extract, Transform and Load (ETL) data from different sources (Flat/Excel/Access/XML/SQL/Oracle) to different targets (DB/Files).
• Worked on different SSIS transformation components like Lookup, Pivot, Unpivot, SCD, Data Conversion etc.
• Extensively worked on writing C# scripts in Script Component Task.
• Migrated DTS packages to SSIS using DTS editor wizard.
• Experience in creating Master and Child Packages, Error Handling and Logging using SSIS.
• Experience in Performance Tuning, Configurations, Deployment of SSIS Packages.
• Worked on scheduling of execution of SSIS Packages for incremental load of data.
• Experience in implementation of Checkpoints for re-execution of the failed SSIS packages.
• Excellent Programming experience in writing Complex Stored Procedures, Queries, Views, User Defined Functions, Cursors and Common Table Expressions using T-SQL.
• Excellent command in writing Dynamic and Advanced SQL queries.
• Expert in creating tables, indexes, keys, constraints and triggers to facilitate efficient data manipulation, integration and consistency.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools and utilities (SSIS, Bulk Insert and BCP).
• Good understanding of Entity-Relationship/Multidimensional Data Modeling (Star schema, Snowflake schema).
• Experience in generating reports using SSRS 2005/2000.
• Worked with tabular reports, matrix reports and parameterized reports according to business requirements in time restricted environment using SQL server reporting services (SSRS).
• Have Good understanding of SQL Server Analyses Services (SSAS).
• Extensively worked on .Net Framework 3.5/3.0/2.0, using C#.
• Working experience of Web Development using ASP.NET Web Forms, Web User controls, Custom controls, ASP.NET State Management, ASP.Net Caching, ASP, VB 6.0, JavaScript, VBScript and CSS.
• Working experience in AJILE environment.
• Had Scrum Sprint Sessions with Development Team and Product Owners.

Technical Skills:-
ETL Tools : SQL Server Integration Services (SSIS), Pervasive’s Data
Integrator (Data Junction)
Reporting Tools : Crystal Report, SSRS 2005/2000
RDBMS : MS-SQL Server 2008 R2/2008/2005/2000, Oracle 10g/9i/8i.
Programming : C#.Net, VB 6.0, PL/SQL, T-SQL.
.Net Framework : 3.5/3.0/2.0/1.1, Win Forms, Web Forms
Scripting : JavaScript, VBScript. Batch Scripts, Power Shell
Protocols : SOAP, TCP/IP, HTTP, UDP/IP and FTP.
IDE : MS Visual Studio 2008/05/03, Visual Studio 6, MS-SQL Server
Management Studio.
Tools : Subversion (SVN), Visual SourceSafe 6.0., TOAD, PL/SQL
Developer, FLUX (Process Automation Tool)
Operating Systems : Windows XP/2000/NT/98/95.

Personal Skills:-
Self driven with strong Analytical and Problem solving skills.
Good team player posses’ excellent communication and interpersonal skills.
Able to perform at high level to meet deadlines with ever changing priorities.
Quick learner and adaptive to new technologies and business processes.

Academics and Certifications:-

Master of Computer Applications (MCA)
Post Graduate Diploma in Computer Applications
IBM Certified E-Commerce Developer (Two Years Program).
Microsoft Certified System Engineer in NT Server 4.0 (MCSE).

Projects Handled:-

Project Title: Data Migration May 2012 – Till Present

Client: Confidential,Indianapolis, IN
Role: SSIS/SQL Developer

Confidential,is providing assistance with data coding of health information and with reporting quality of care information to health officials. The objective of the project is to migrate health care information data from legacy system to MS SQL Server 2008 R2.

Responsibilities:

• Coordinate with the Health Care subject matter expert to identify the Requirements for design and development of Database model and SSIS packages for Migration processes.
• Created Databases, Tables, TSQL scripts, and User Defined Functions for migration of data using SQL Server 2008 R2.
• Implemented Indexes, Keys and Constraints on tables.
• Design and developed SSIS packages to Extract, Transform and Load data from Legacy Systems to SQL Server 2008 R2.
• Created master and child packages. Executed child packages from master package passing values from master package.
• Created dynamic connections using variables and expressions in connection manager.
• Extensively worked on writing C# scripts in Script Component Task to implement business logics.
• Created configuration table to set the properties of the objects of SSIS packages at runtime.
• Worked on Error Handling and Logging in SSIS packages.
• Worked on deployment of SSIS packages using Deployment Utility.
• Implemented best practices for performance tuning of SSIS packages.
• Created SQL Server Agent jobs to automate the SSIS process.
• Participating in weekly meetings about the ongoing progress of the work.

Environment: Visual Studio 2008, MS SQL Server 2008 R2, SSIS, T-SQL, Visual Source Safe.

Project Title: ETL Process Development and Automation July 2009 – April 2012

Client: Confidential,Louisville, KY
Role: SQL Developer
Duration : 2 Years 10 Months

Confidential,is a leading independent provider of outsourced insurance subrogation, claims recovery and cost containment solutions for the healthcare payer and property and casualty industries. Founded in Louisville, Kentucky, in 1988 as Healthcare Recoveries, the company initially focused on recoveries in the healthcare segment of the insurance industry.

Responsibilities:

• Coordinate with the Client Data Managers to identify the Business Requirements for design and development of Database model and ETL processes.
• Created Databases and Tables for Landing and Staging area of Data Ware House.
• Implemented Indexes, Keys and Constraints on tables.
• Created Triggers to maintain the data integrity.
• Worked on Performance Tuning using Query Optimizer and SQL Server Profiler.
• Created Stored Procedures, Tables, Views, Indexes, TSQL scripts, and User Defined Functions for the Landing and Staging tables using SQL Server 2008.
• Design and develop SSIS packages to load data from Client Systems to Landing and Staging area of Data Ware House.
• Creates master and child packages. Executed child packages from master package passing values from master package.
• Created dynamic connections using variables and expressions in connection manager.
• Extensively worked on writing C# scripts in Script Component Task to implement business logics.
• Created configuration files for the deployment of the SSIS packages to Production.
• Worked with data modelers, data and business analysts to design and develop various processes for extraction, transformation and load of data from different data sources and of different formats (Flat/Excel/Access/XML/SQL/Oracle) to different targets (DB/Files).
• To implement best practices to maintain optimal performance for execution of SSIS packages.
• To understand the existing ETL Processes and modify them for higher performance or migrate them to newer version (DTS to SSIS migration) as per the requirements.
• Extensively worked on production issues and production cycle support & routine maintenance.
• Worked on writing Batch Scripts to automate the SSIS process.
• Participating in weekly meetings about the ongoing progress of the work.
• Very efficiently use SSIS and Pervasive’s Data Integrator (ETL tools) to Define and Develop Processes to Extract, Transform and Load data into different DBs.
• Created Views using PL/SQL to facilitate user to see data on the bases of their Roles defined in Oracle 9i database.
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Wrote complex Queries, Stored Procedures and functions using PL\\SQL for Oracle 9i.
• Fully utilized the Software Development Life Cycle processes including requirements gathering, design, development, implementation, quality and deployment of Applications.

Environment: Visual Studio 2008, MS SQL Server 2008, SSIS and Pervasive’s Data Integrator (ETL tools), MS SQL Server Reporting Services 2005/2000 (SSRS), T-SQL, Oracle 9i, PL/SQL, IDE, Visual Source Safe

Project Title: Process Development & Automation November 2007 – May 2009

Client: Confidential,Louisville, KY
Role: SQL /ETL Developer
Duration : 1 year 6 months

Confidential, is a leading, independent provider of integrated Health Solutions that improve personal health and reduce spending. By integrating traditional health management and benefits administration services, SHPS delivers people-centric solutions that empower individuals to make wise Healthcare choices. It serves large and mid-sized employers, government agencies, and third-party administrators through the company’s Carewise® Health, Landacorp, and SHPS brands.

Responsibilities:

• To work on SSIS (ETL tool) to Extract, Transform, Validate data from Heterogeneous environment and Load into different relational DB.
• Created SSIS Packages using Pivot and Unpivot Transformations, Derived Columns, Condition Split, Execute SQL Task, Data Flow Task, Execute Package Task etc to load data from Excel Spreadsheets, Text file, MS Access and CSV files to Data Warehouse.
• Extracted data from XML to SQL Server.
• Created SSIS packages for data Importing, Cleansing, Parsing and Transformation.
• To implement customized multi level Logging on the Transformation Process.
• Created Stored Procedures and Views using T-SQL.
• Implemented Indexing to enhance the performance of database.
• Worked on Performance Tuning using Database Engine Tuning Advisor (DTA).
• To write complex Queries and User Defined Functions.
• To create table level triggers to maintain data integrity in tables.
• To implement table level and column level constraints to maintain the validity and accuracy of the data in the tables in SQL Server DB.
• Wrote complex Queries, Stored Procedures and user specific functions using PL\\SQL for Oracle 10g database
• To automate the whole process of Extraction-Transformation-Load-Archiving of data using SSIS and SQL Server Agent.
• To execute the SSIS packages through ASP.Net application.
• To develop Windows and Console based applications for various Business Processes.
• To develop customized Dash Boards using Crystal Report according to the requirements of Business group to facilitate them to keep check on the health of the different processes.
• Extensively used ADO.Net objects for consistent access of SQL Server DB.
• Extensively worked on Shell Scripting on Unix.
• Created various Technical Documents to standardize the Applications and Processes.
• Contributed requirements gathering, design, development, implementation, quality and deployment of Applications.

Environment: Visual Studio.NET 2008, C#, ASP.Net, .Net Framework 3.5, Web Forms, ADO.Net, Unix, Shell Scripting, SQL Server 2005, Oracle 10g, Visual Source Safe, SSIS.

Project Title: Human Resources Management System November 2005 – October 2007 Client: Confidential,Philadelphia

Role: SQL Developer
Duration : 2 Years

This system keeps track of the attendance and activity records of staff and uses these data to help organization to perform HR functions. The system also contains a web-based platform which allows the staff to manipulate their own records, such as applying leave, and viewing allowance and deduction.

Responsibilities:

• Created SQL Scripts, complex Queries, Stored Procedures and Views.
• Dealt with various SQL Server 2005 database issues e.g. creating tables and relation between the tables, adding, updating and deleting the data in the tables. Developed SQL Stored Procedures using T-SQL.
• Developed Data Junction Maps using Data Junction Map Designer (Pervasive’s Data Integrator) to Extract and Transform and Load data.
• Implemented Business Logic to validate data using Data Junction inbuilt functions.
• Transform Data from Source Format to Target Format using Data Junction Maps.
• Implemented Error Logging of Transformation Process of Data Junction Maps using explicitly defined function using VB.
• Validate data before Transformation from Source to Target Format in Data Junction Map.
• Involved in requirement studies by communicating with the client. Detailed analysis of Client requirements.
• Development of Web application with C# and ASP.Net 3.0.
• Involved in developing Data Access Components to access the SQL Server Database using ADO.NET.
• Used Visual Source Safe for version and project management.

Environment: Visual Studio.NET 2005, .Net Framework 3.0, ASP.NET 3.0, C#, ADO.Net, CSS, JavaScript, Web Services, T-SQL, SQL Server 2005, Visual Source Safe, Data Junction (Pervasive’s Data Integrator tool).

Project Title: Copy Right Tool May 2005 - October 2005

Client: Confidential,Redmond, USA
Role: .Net Developer
Duration : 6 months

The MSN Video team has their product soapbox on MSN Video website that allows users to search, browse and view video contents of their interest uploaded by various users and content providers. The Tool will only be accessed by the MSN Video team and its Partner’s for approving/flagging uploaded videos.

Responsibilities:

• Performed major role in SDLC standardization, workflow planning, setting short term and long term goals and achieving them.
• Involved in requirement studies by communicating with the client. Detailed analysis of Client requirements.
• Involved in designing of the operational flow, prepared design documents, E-R diagrams, Flow charts.
• Involved in UML designing for Presentation layer and Business layer.
• Involved in the Analysis, design and architecture of the overall application.
• Designed and developed web pages using ASP.Net 3.0 and C#.Net.
• Developed UI and web server controls in Visual Studio.NET.
• Worked on Client Side scripting using JavaScript.
• Used ASP.NET validation controls (Required field, regular expression, compare, range) User Controls, Custom Controls using C#.
• Extensively worked on Cross Browser Platforms (IE and Firefox) testing and Bug Fixing.
• Developed reusable components using C# along with OOP techniques.
• Implemented Role Based Security features in the application.
• Worked on ADO.NET controls for communicating with database in a structured manner.
• Worked on XML and AJAX to transport and display data.
• Used Gridviews for displaying status information of the Videos.
• Used T-SQL to write Stored Procedures, Triggers and functions to make transactions with Database.
• Participated in Software Requirement reviews, Design reviews and Code reviews using OOA and OOD.
• Developed various documents

Environment: ASP.NET 3.0, C#, AJAX, JavaScript, Visual Studio .NET 2005, .Net Framework 3.0, XML, HTML, DHTML, SQL Server 2005, T-SQL, IDE, Visual source safe.

• Project Title : Customer Relationship Management( CRM 2.0.3) May 2004 - April 2005

Client: Confidential,India
Role: .Net Developer

Duration : 1 year

Objective of this project is to develop a windows based application to maintain the record of telephonic communication between the customers and the company representatives for the future use.

Responsibilities:

• Development was performed using C#.Net.
• Implemented UI along with OOP techniques in Visual Studio.NET 2003.
• Instrumental in implementing security features in the application.
• Worked on ADO.NET controls for communicating with database in a structured manner.
• Accessed Oracle 8i through ADO.Net using OracleConnection, OracleCommand, OracleData Reader and Dataset.
• Created Queries, Stored Procedures and Views using PL/SQL.
• Fully utilized the Software Development Life Cycle processes including requirements gathering, design, implementation, quality and deployment.
• Participated in Software Requirement reviews, Design reviews and Code reviews.

Environment: Visual Studio .Net 2003, C#.Net, ADO.Net, Oracle 8i, PL/SQL, Visual source safe.