SUMMARY

• Around 9 plus years of IT experience as a Project Lead / Software Engineer involved in development, Production support.
• Expertise in Entire Software Development Life Cycle.
• Hands on experience in Extract, Transform & Load(ETL)development usingSQL ServerIntegration Services(SSIS).
• Highly Proficient in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, DB2, Excel, MS Access, CSV, flat file
• Experience in providingLogging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Block and Unblock Transformations.
• Creating Package dependencies by calling Child packages from the parent Package using SSIS.
• Hands on experience in tuning packages to identify and eliminate performance Bottlenecks and Error Handling Mechanisms.
• Experience in handling large volumes of data in Production environment.
• Hands on experience inSQLServer Reporting Service (SSRS)
• Experience in creating drill down, drill through and linked reports using SSRS (SQL Server Reporting Services).
• Knowledge of Dimensional Data Model concepts, Dimension and Fact tables Surrogate keys, Star and Snow Flake Schema.
• Expertise in implementing business logic usingTriggers, Views and Stored Procedures.
• Proficient at Performance Tuning wif a solid knowledge ofOptimizing Code.
• Experience in solving Real Time issues wifDBCC checks, Query Tuning, ErrorandEvent Handling.
• Experience in creating Indexes for faster performance
• Experience in developing applications using C#.NET 2.0/3.0, ASP.NET 2.0/3.0 and .NET Framework 2.0/3.0/3.5.
• Provided in - depth analysis to resolve production and application issues.
• Proactively monitoring the jobs and avoid the incident and Troubleshoot business facing issues and resolving incident.
• Coordinate wif multiple teams for incident resolution and break fixes.
• Provide 24x7 support to all production issues on holidays and weekends
• Ability to work wif all levels of management, willingness to learn and implement new ideas quickly and to be a collaborative team player.
• Excellent analytical, communication, documentation and interpersonal skills.
• Highly motivated resourceful team player dat takes a positive approach to problem resolution.

TECHNICAL SKILLS

Data warehousing tools: SSIS,SSRS

Languages: C, C++, SQL, Java Script

Web: ASP.NET 3.0, C#, WWF

RDBMS: Oracle 10g, 9i/8i, MS SQL Server 2008/2005, DB2 8.0, MS Access

Operating System: MSDOS, Windows 95/98/2000, Windows NT/XP

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Tech Lead

Responsibilities:

• Proactively monitoring the jobs and avoid the incident.
• Troubleshoot business facing issues and resolving incident.
• Daily support, troubleshooting, monitoring, optimization and tuning of SQL Server Jobs, Packages and SQL server environments across entire system.
• Coordinate wif multiple teams for incident resolution and break fixes.
• Implemented MERGE statement for improving the stored procedure performance.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Tested packages and fixed bugs using SQL 2008 R2 Business Intelligence development studio.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages
• Rerun the failed jobs and send the files to downstream.
• Written T- SQL, Pl/SQL queries for data retrieval.
• Created and modified complex TSQL batches / stored procedures. Involved in creating new Stored Procedures and Optimizing existing queries and Stored Procedures.
• Performing query plans and making sure each and every query is using appropriate useful Indexes
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Fine tuned SQL queries for maximum efficiency and performance.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Used SFTP tasks when required.
• Setting up User Permissions.
• Hold and release the jobs when planed CMR happened.
• Provide 24x7 supports to all production issues on holidays and weekends.

Environment: SSIS 2008, SSRS 2008, SQL Server2008.

Confidential, Louisville, KY

Senior Software

Responsibilities:

• BSPM is the application dat completely automated process.
• Systems and processes to support the identification, evaluation, and routing of members into interventions.
• Enabled and Disabled Indexes and Tables as part of performance tuning.
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
• Implemented MERGE statement for improving the Package performance.
• Deployed the created SSIS packages in Development and Testing environments.
• Developed SSIS packages as per requirements and extracted and loaded data using FTPs.
• Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to different databases.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Tested packages and fixed bugs using SQL 2008 R2 Business Intelligence development studio.
• Worked on SSIS performance tuning using error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Designed Complex SSIS ETL packages to load the data from different sources like OLEDB, EXCEL and FLAT Files.
• Configured Checkpoints on SSIS packages so dat the package would restart from the point of failure.
• Configured SQL mail agent for sending automatic emails when SSIS package fails or succeeds.
• Fine tuned SQL queries for maximum efficiency and performance.
• Created Configuration files wif XML documents to support the SSIS packages in different environments.

Environment: SSIS 2008, SSIS 2012, ASP.NET, WWF, SQL SERVER 2008, ORACLE.

Confidential, Phoenix, AZ

Senior Software

Responsibilities:

• Involved in Technical Document Design Based on Functional Specification.
• Development of packages according to the ETL specifications for the staging area.
• Pull the data from Staging Area to Data Sync Tool.
• Creating master and child packages, package configurations Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, Email Task, and Data Flow Task.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data in and from Guide Wire OLTP Data Warehouse and Data Mart.
• Created packages in SSIS wif error handling and Worked wif different methods of logging in SSIS
• Configured SQL mail agent for sending automatic emails when SSIS package fails or succeeds.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts, Pie Charts.
• Developed report parameters and performed Parameterized and cascading parameterized reports and sorting the data, defining subtotals for the reports using SSRS in Visual Studio
• Designed complex reports like Drill-Down Reports, Drill-Through Reports, and Parameterized Reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Involved in writing stored procedures, functions and created the reports (SSRS).
• Responsible for creating Tabular, Matrix and Drilldown Reports using SSRS.

Environment: Windows XP, SSIS 2005, SSRS 2005, SQL Server2005

Confidential

Senior Software

Responsibilities:

• Created different ETL packages using SSIS from UK and Non UK source to Sql server as destination. Development of packages according to the ETL.
• Development of packages according to the ETL specifications for the staging area & warehouse data loading using SQL Server Integration Services & SQL Server 2005.
• Development of packages according to the ETL specifications for the staging area & warehouse data loading using SQL Server Integration Services & SQL Server 2005.
• Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, Email Task, and Data Flow Task.
• Created SSIS packages by testing and cleaning the standardized data by using tools in Data Flow Transformation (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for the existing and new packages.
• Used different control flow and data flow tasks for creating SSIS packages, used different kinds of transformations for data conversion, sorting and data cleansing from different sources into company’s formats
• Applied various data transformations like aggregate, sort, Multicasting, Conditional Split, Derived Column etc

Environment: Windows XP, SSIS 2005, SQL Server 2005

Confidential

Software Engineer

Responsibilities:

• Created different ETL packages using SSIS from Oracle source to Sql server as destination Requirement/ design document.
• Creation of database, tables and procedures to update and clean the old data.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages. Configures SQL Mail agent for sending automated alerts/email.
• Configured SQL mail agent for sending automatic emails when SSIS package fails or succeeds.

Environment: SSIS 2005, SQL Server 2005

Confidential

Software Engineer

Responsibilities:

• Involved in coding & development of the SOE module.
• Involved in writing Business Components.
• Involved in writing stored procedures.
• Developed the module in full integration wif VSS & Source Offsite

Environment: C#, ASP.NET, SQL Server 2000

Confidential

Software Engineer

Responsibilities:

• Involved in coding & development of the extranet module.
• Involved in writing Business Components.
• Involved in writing stored procedures.
• Involved in writing a NUNIT test cases.

Environment: C#, ASP.NET, SQL Server 2000