PROFESSIONAL SUMMARY

*+ years Extensive experience in using ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and loading using SSIS 2008 R2 /2012, Informatica Power Center

Knowledge of working in the complete software development life cycle involving Analysis, Design, Development, Integration, Project documentation, Testing and post install maintenance. Was also accountable for my changes to the application performance, availability and scalability.

Knowledge in Full Life Cycle development of Data Warehousing.

Good understanding of Ralph Kimball Dimensional Modeling using Star schema methodology and Bill Inman Snow Flake schema methodology.

Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using SSIS.

Good expertise in Informatica Power center 9.6.

Good knowledge for Talend 6.1 open studio

Hands on experience with performing various SSIS data transformation & data flow tasks like SCD, Look-ups, Fuzzy Look-ups, Merge, Merge Join, Sort, Derived Column, Union-All, Conditional Splits and Event Handlers, Sequence / For Each Loop containers, control Flow Task, Execute SQL Task, Script Task, Send Mail Task, File System Task etc.

Strong experience in Extraction, Transformation, loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Metadata Manger).

Knowledge Informatica Transformation like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties.

Knowledge Big DATA Hadoop ecosystem with PIG and HIVEQL

Excellent in designing ETL procedures and strategies to extract data from different heterogeneous source systems like SQL Server 2008/2005, Flat files, XML, Cobol file etc.

Strong experience on understanding of Business Intelligence and Data Warehousing Concepts with emphasis on ETL and SDLC (Software Development Lifecycle), Quality analysis.

Dealt with Master data (MDM), Transaction data, Control data etc.

Extensively involved in creating Stored Procedures, Functions, Packages, Triggers, and Indexes with Query optimizations as part of ETL Development process.

Experienced in Quality Assurance, Manual and Automated Testing Procedures with active involvement in Database/ Session/ Mapping Level Performance Tuning and Debugging.

Worked with Business Managers, Analysts, Development, and end users to correlate Business Logic and Specifications for ETL Development.

Strong decision-making and interpersonal skills with result oriented dedication towards goals.

Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.

TECHNICAL SKILLS:

SSIS, SSRS

Informatica Power Center 9.6

MS SQL Server 2005 & 2008 R2, T-SQL

MS VSS, TFS, SVN

Hadoop Ecosystem (PIG, HIVEQL)

ASP.NET, C#.NET, ADO.NET and WCF

Visual Studio (VS 2012/2010/2008), Net Framework 4.0/3.5

WORK EXPERIENCE

Client: Emailage Corp Role: ETL developer Duration: Feb 16 – July 16

Project Overview:

Emailage Corp provide intelligent and secure risk assessment with just an email address. Provide Stop fraudsters without sharing customer’s sensitive information.

Email is a unique, global identifier that links transactions. We track emails around the world from multiple industries to prevent new fraud tactics, and provide a Risk Score allowing you to make immediate risk decisions. Don’t let customers get bogged down with verification.

Responsibilities:

Communicated with business customers to discuss the issues and requirements.

Create SSIS package using SSIS 2008 /2012.

Developed ETL programs using SSIS to implement the business requirements.

Created scripts to fine tune the ETL flow.

Unit Test Plan preparation

Worked Coding, Unit Testing using Test harness

Production Support has been done to resolve the ongoing issues and troubleshoot the problems.

Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.

Effectively used Config files for defining variables, FTP connections and relational connections.

Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.

Effectively worked on Onsite and Offshore work model.

Performed unit testing at various levels of the ETL and actively involved in team code reviews.

Identified problems in existing production data and developed one time scripts to correct them.

Client: American Honda Motor Role: ETL developer Duration: July 15 – Jan 16

Project Overview:

The iN (Interactive Network ) Plus Real Time is to enable dealers and AHM to conduct business in a “real-time” seamless environment. The system will improve Dealer efficiency by providing information to the Dealers at the optimal point in the business process. Dealers will have immediate access to AHM host information and real time transaction response.

Support the polling model for disconnected dealers

Utilize existing iN Plus Realtime infrastructure

Allow functionality to be utilized by all divisions (auto, Motor Cycle, Power equipment)

Responsibilities:

Maintained consistency in the appearance, feel and usage among all applications.

Unit Test Plan preparation

Worked Coding, Unit Testing using Test harness

Convert DTS package to SSIS package using SSIS 2012

Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.

Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules.

Created automated scripts to perform data cleansing and data loading.

Creating staging tables and Data-Mart or target tables using transformations.

Creating Mapping documentations

Version controlling of Code and database objects in TFS, VSS.

Client: Scripps Health Role: ETL developer Duration: Jan 15 – July 15

Project Overview:

At Health care provider, provides the technology to consolidate strategic, clinical and financial information into a single, complete picture of healthcare performance. interfaces with Eclipsys (MultiEntity- ME) to retrieve the hospital episodes’ information for costing and performance management. EDW sources to retrieve Patient, Physician, Episodes, Diagnosis, and Procedure and Cost information. This data is loaded in EDW staging area, transformed and then used for Hospital Episodes, Glycemic Control and Visits reporting.

Responsibilities:

Worked with power center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.

Extensively used Informatica Transformation like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties.

Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.

Translated Business processes into Informatica mappings for building Data marts by using Informatica Designer which populated the Data into the Target Star Schema on Oracle 9i Instance.

Followed the required client security policies and required approvals to move the code from one environment to other.

Developed ETL mappings, transformations using Informatica Power center.

Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules.

Created Informatica complex mappings with PL/SQL procedures/functions to build business rules to load data.

Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.

Performed complex defect fixes in various environments like UAT, SIT etc to ensure the proper delivery of the developed jobs into the production environment.

Attended daily stand up meeting with internal team and weekly calls with client and updated the status report.

Environment: Informatica Power Center, Oracle, MS SQL Server2008, PL/SQL

Client: Humana Role: Developer Duration: Apr’2012– Dec’2014

Project Overview:

Account Manager is a system which is used to create a quote for Small Group, enroll Small and Large Groups and also used for Benefit Maintenance for Small Group and Large Group. It is also used by the Underwriters during the Renewal Process.

Rating: Rating means the Setting the premiums for a group

Quoting: A Process in which the Benefit Package/Plan is made for a prospect. A written offer to a prospective policyholder to provide specified benefits at the Quoted premium rates.

Underwriting: A Process in which the group in enrolled into the system once the quote is approved by the group and the underwriter.

MS CRM: Effective resource utilization during peak selling period. Data uploading to CRM

Responsibilities:

Attended daily scrum meeting, sprint estimation meeting at the daily basis.

Gathered and analyzed the client requirements with discussion with SME and business user.

Understand user requirements and Data Model defined and developed by the business analysts and data architects

Extensively used Informatica to extract, transform and load data from multiple data sources.

Designed and developed mappings, defined workflows and tasks, monitored sessions, exported and imported mappings and workflows, backups, and recovery.

Handling the user queries and tickets for Informatica applications.

Mainly involved in ETL design & development.

Preparation of Low Level Designs (Mapping Documents) by understanding the system.

Responsible in developing the ETL logics and the data maps for loading the tables.

Responsible for migrating from Development to staging and to Production (deployments).

Designed for populating Tables for one-time load and Incremental loads.

Reloading of applications run and need to make sure reloading process is completed.

Analyze functional requirements provided by Business Analysts for the code changes.

Create workflows based on Dependencies in Informatica for the code changes.

Unit test the data mappings and workflows.

Validate the data loaded into database.

Provide the status report for all the application monitoring, tracking status.

Execute the Test cases for the code changes.

Provided extensive support in UAT (user acceptance testing) and deployment of mappings.

Arranged code review sessions internal as well as with tech lead.

Conducting Peer reviews and Independent Testing

Environment:

Informatica power Center 9.5

SSIS 2008, DTS

Oracle 10g

SQL Server 2008, T-SQL

Visual Studio.Net 2010 (C#.NET, ASP.NET, ADO.NET)

WCF

Tower group – Shared services

Client: TOWER GROUP Role: Developer Duration: FEB’2011 – Mar’2012

Project Overview:

MA-CGI PRINTING –As part of MA policy printing project a SSIS application is being developed to receive a set of flat files and process them to generate PDF forms using XF Designer tool to print policy documents

Responsibilities:

Requirement gathering and understanding the trends that is to be shown in the reports.

Used Visual SourceSafe (integrated with VS.NET 2008) for version management.

Developed new web service to consume by other system to generate policy file.

Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.

Wherever required, ETL process was created, the reports, will be stored, refreshed and utilized in the report on daily basis.

Developed parameterized SSRS reports which used grouping, summing within grouping, sub reports etc. Created and managed subscriptions on these reports for users.

Unit Test Plan preparation

Environment:

SQL Server 2008, T-SQL, SSIS, SSRS

Visual Studio.Net 2010 (C#.NET)

Web service

Humana :- WorkFlow/SAC

Client: Humana Role: Developer Duration: Sep’2010–Jan’ 2011

Project Overview:

We are enhancing audit system to capture pharmacy audit. The pharmacy Audit system is used by auditors for audit processing, capturing pertinent information about the audits and claim targets that are parts of the pharmacy audit. Workflow component of the system is used for better tracking of inventory and productivity of associates.

Responsibilities:

Attended daily scrum meeting, sprint estimation meeting at the daily basis.

Gathered and analyzed the client requirements with discussion with SME and business user.

Handled more than one task in the sprint which involved more than one development at the same time.

Worked Coding, Unit Testing using Test harness.

Arranged code review sessions internal as well as with tech lead.

Conducting Peer reviews and Independent Testing

Unit Test Plan preparation

Environment:

Visual Studio.Net 2008(ASP.net, C#)

SQL Server 2005, T-SQL

AJAX, JAVACSRIPT, VBScript

Encyclopedia Access Management System

Client: Taylor and Francis Role: Developer Duration: Oct’09- Sep'10

Client Overview:

Taylor and Francis is one of the world’s leading publishers of online journals and eBooks and reference works there content spans all areas of Humanities, Social Sciences, Behavioral Sciences, Science and Technology

Project Overview:

There are two web-based interfaces to EAMS: the administrative services component, which is the publisher-facing interface; and the subscriber services component, which is the customer's view on their account and subscription data. Both interfaces are styled with a publisher-specific look and feel as part of the configuration and deployment of the system

Responsibilities:

Coding, Unit Testing

Bug fixing

Unit Test Plan preparation

Environment:

Visual Studio.Net 2005(ASP.net, C#,ASP 3.0 )

SQL Server 2005, T-SQL

AJAX, JAVACSRIPT, VBScript

E-Commerce store and manager

Client: DBC.DK Role: Developer Duration: Sep’2008–Sepr’2009

Client Overview:

DBC is a public company, owned by Local Government Denmark and the Danish State. DBC’s main task is to develop and maintain the bibliographic and IT infrastructure in the Danish libraries

Project Overview:

The core essence of the ecommerce portal is to provide a secure portal for distributors over the internet to login and view the wide range of products and services .The ecommerce Portal will also encompass the My Account functionality where in distributors can view their past order, track pending orders, view invoices, manage their addresses, view quotes placed for them by sales people and also manage their sub user accounts..

Responsibilities:

Prepared Technical Specification

Unit Test Plan preparation

Coding & Unit testing

Bug fixing and enhancing the application

Environment:

Visual Studio.Net 2005 (ASP.net, C#)

Develop web pages using ASP 3.0, VB

Create DLL with VB 6.0

SQL Server 2005, T-SQL

JAVACSRIPT

VSS

Danish Bibliography Center

Client: DBC.DK Role: Developer Duration: Apr’2007–Sep2008

Client Overview:

DBC is a public company, owned by Local Government Denmark and the Danish State. DBC’s main task is to develop and maintain the bibliographic and IT infrastructure in the Danish libraries

Project Overview:

Bookstores are an online web portal. User can register, purchase, rent and search the e-Books on this site using metadata of the e-Books.

Integrating payment gateways for online transactions. For wallet feature, subscription of books, online eBook purchasing, it is mandatory to have payment gateway integrated with web sites. Payment gateways like Skipjack, and DIBS have been integrated for credit card payment option.

Admin Controls System has ability to Add/Delete/Modify end user information, Customer information, Book Meta data and book details are provided.

DBC Metadata Upload Tool is an application that uploads the data received from the client in xml format. The tool also generates the xmls used in the BookStore for displaying the e-Book metadata.

Responsibilities:

Coding, Unit Testing

Bug fixing and enhancing the application

Unit Test Plan preparation

Environment:

Visual Studio.Net 2005(ASP.net, C#)

SQL Server 2005, T-SQL

AJAX, JAVACSRIPT, VBScript

Contact this candidate