Sql Server Data

Professional Summary

Around * 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 using SQL Server Integration 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 providing Logging, 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).

Developed OLAP Cubes using 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 in SQL Server 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 using Triggers, Views and Stored Procedures.

Proficient at Performance Tuning with a solid knowledge of Optimizing Code.

Experience in solving Real Time issues with DBCC checks, Query Tuning, Error and Event 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

EDW, CRB AUTO, Irvine, CA Jan’15 – Till Date

Tech Lead

California Republic Bank (CRB) started Auto finance section on 2011 and the auto loans to consumer. CRB is building the EDW application to monitoring customer loan application and perform loan approval process. Perform responsibilities of reviewing and maintaining audit and financial report statements, Credit, Collections, Customer Service, Remarketing, Bankruptcy, End of term, Titles, File Maintenance, Recovery and Collection Risk Strategies.

Roles & Responsibilities:

Preparing the technical design documents for EDW 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.

Dialer Mis (RTBI), Amex, Phoenix, AZ Oct’13 – Jan’15

Tech Lead

American Express Company is a global services company. The Company's principal products and services are charge and credit payment card products and travel-related services offered to consumers and businesses worldwide.

Roles & 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.

Humana, INDIA Jan ’11 – Sep ‘13

Senior Software

Humana is one of the nation’s largest health care providers of individual & family, group, Medicare, dental, vision and life insurance products. Humana's diverse lines of business work to serve all types of consumers. From families to seniors to military members to self-employed individuals, there is a plan to meet many unique needs.

Roles & 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.

Avaya, India Apr ’10 – Dec ’10

Senior Software

Avaya University, in partnership with Avaya, develops and delivers high-quality training for their products and solutions. Avaya University’s priorities include Avaya’s product launches, sales force and channel enablement including solution and executive selling, certification and associate skills development. Avaya University supports and maintains the Avaya Learning Centre where both Avaya Professional Certification and Learning Program content can be found.

Roles & 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

Michael Page, INDIA Feb ’09 – Nov’ 09

Senior Software

Michael Page International is one of the world's leading professional recruitment consultancies. The Group has operations in the UK, Continental Europe, Asia-Pacific and the Americas. Michael Page core vertical markets are FMCG, Healthcare, Media, IT/Telco, Financial Services, Business Services and Manufacturing, Campaign Management..

Roles & 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

NHS Pro, INDIA Dec ’07 – Nov ‘08

Software Engineer

This project is related to Real Estate business. Project has been divided into Extranet and Website. Extranet is basically for Admin users who can enter the details and this is accessible only for the client. And website is for Realtors and also for the End user.

Roles & 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

Aprimo, INDIA Nov ’06 – Aug ‘07

Software Engineer

Aprimo is the global leader in delivering technology and insight that accelerates marketing productivity and the ability of marketing to document effective performance. Aprimo provides an Enterprise Marketing Management (EMM) product to leading marketing organizations around the world. Aprimo's software is built on its visionary Enterprise Marketing Backbone™ which uses a services oriented architecture (SOA) that eliminates marketing as an island of automation.

Roles & Responsibilities:

Involved in MOM.

Involved in developing a WebPages using Aprimo tool kit Program specs

Involved in creating new Data grids using Aprimo tool kit.

Involved in writing stored procedures.

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

NTL, INDIA Apr ’06 – Oct ‘06

Software Engineer

NTL is involved in telecommunication business. NTL is one of the UK's leading provider of high speed broadband internet, offering digital TV, telephone and internet services for the home. As a result of NTL acquiring a number of companies they have inherited a number of different IT systems. Harmony project aims at doing away with all the different IT systems and coming up with a single platform.

Modules of the NTL Harmony Project:

• SOE (Sales Order Entry)

• Tariff Module

• Link and Merge

• Features

.

Roles & 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 with VSS & Source Offsite

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

Academic Profile

Master of Computer Applications, Madras University, India.

Contact this candidate