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.
• Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).
• Experience in Designing and Building the Dimensions and cubes with star and snowflake schemas using SQL Server Analysis Services (SSAS).
• DevelopedOLAP Cubesusing SSAS 2005/2008 with partitions, Calculations, actions, KPI’s, perspectives, slow moving dimensions.
• Expertise in developing and extending MS SQL Server Analysis Services 2008 (SSAS) cubes, deploying and processing SSAS objects, and writing MDX queries.
• 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 with a solid knowledge ofOptimizing Code.
• Experience in solving Real Time issues withDBCC 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 with multiple teams for incident resolution and break fixes.
• Provide 24x7 support to all production issues on holidays and weekends
• Ability to work with 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 that takes a positive approach to problem resolution.

TECHNICAL SKILLS

Data warehousing tools: SSIS,SSAS,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, Irvine, CA

Tech Lead

Responsibilities:

• Preparing the technical design documents for Confidential application.
• Involved in design the Logical and Physical Data Modeling.
• Designed Complex SSIS ETL packages to load the data from 7 Source Files.
• Implemented in creating SSIS packages and designing the dimension and facts.
• Implemented Slowly Changing Dimension (SCD) Type 2 Functionality.
• Created and modified SQL queries to load Historical Data.
• Implemented SSIS package to process all Historical data with SCD Type 2 Changes.
• Implemented master package to process all source to stage, Dim and fact Packages.
• Review and update the packages and SQL queries.
• Implemented Customized log table to track the records in each level.
• Implemented event handler mechanism to send the mail to CRB Prod Team.
• Implemented check points in Master Package.
• Implemented Transactions in master package level.
• Co-ordination with the offshore team to complete the deliverables.

Environment: SSIS 2012, SQL Server2012, MSTR.

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 with 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
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS).
• Involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX. .
• 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,SSAS 2008,SSRS 2008, SQL Server2008.

Confidential

Senior Software

Responsibilities:

• BSPM is the application that 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 that 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 with XML documents to support the SSIS packages in different environments.

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

Confidential

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 with error handling and Worked with 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:

• 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 2005

Confidential

Software Engineer

Responsibilities:

• Involved in MOM.
• Involved in developing a WebPages using Confidential tool kit Program specs
• Involved in creating new Data grids using Confidential tool kit.
• Involved in writing stored procedures.

Environment: Confidential tool Kit, C#, Sql Server 2005.