Experience Summary

Over ** years of experience in Data analysis, design, development, testing and implementation in Data warehouse projects primarily in Data Integration tools

Expertise in Informatica data Extraction, Transformation and Loading from source to target in a complex, high volume star and snowflake schema

Experience working with various Heterogeneous Source Systems like Oracle, DB2 UDB, MS SQL Server and Flat files

Experienced in data analysis, reconciliation, profiling, standardization using Trillium Data quality

Experienced on Informatica performance tuning of Source, Target, Mapping and Session level bottlenecks

Expert in creating complex Oracle SQLs, query tuning and debugging

Expertise in Data Analysis, requirement gathering, high-level and low-level design documents, interface and test documents

Experienced in Agile SDLC model of work, with bi-weekly Sprints and deliverables

Knowledge on Informatica Cloud features like Data Synchronization, Quality Assessment, Loader and Replication

Experience in Team and process management in onsite and offshore model

Experience working on Insurance, Supply chain, Manufacturing & Retail, Oil and Gas domains

Knowledge on the Congo’s BI report studio for report creation and data validation

Experienced in Production Support role 24/7 to resolve the issues using a trouble ticket system

Have defined and applied best practices in development and administration activities

Hands-on experience in various stages of Waterfall SDLC model including business requirement analysis, data mapping, build, unit testing and user acceptance testing

Excellent interpersonal and communication skills, with experience in working with C-level business executives and across multiple disciplines and teams

Skills Summary

Domain

Insurance, Manufacturing & Retail, Supply Chain, Oil and Gas

Programming Languages

C, SQL, PL\SQL

Operating System

Windows, Unix

Data Warehousing Tools

Informatica 9.X,8.X&7.X, Cognos, Open Text O.T.I.C. 10.6 and Trillium Data Quality

Professional Trainings

ER Modeling and Data Modeling

Data Warehousing, Oracle SQL and PL\SQL

Cognos

Work Experience

Project 1

Project Name

RPM Real Time Parts Management

Team Size

6

Start Date

Aug 2016

End Date

Till Date

Project Description

Genuine Parts Company is converting their Automotive parts Store from legacy TAMS (Total Automotive Management Systems) to Tomax (Sales Force) environment. During this migration the historical data worth last 7 years is being migrated into a new Online Transaction Processing system.

Role & Contribution

Played the role of Onsite Technical Lead, Business Analyst and Conversion Support Analyst

Analyzed legacy TAMS system with target structure and to gather requirements

Lead the offshore team by guiding and reviewing their deliverables on regular basis

Participated in daily sprint meetings for status update on JIRA tasks

Created complex queries to reconciliation the data between source and target with 100% accuracy

Identified multiple long existing defects and resolutions

Performed QA testing based on Sprint allocation

Interact with Product team, Architects, SCM - Software Configuration Management and scrum master on regular basis

Debug and enhance the Informatica code for data discrepancies for high priority defect

Participated in defect review meetings with analysis and impact

Developed the work around Pl\Sql scripts for Production defects

Provide L3 support for the application

Provide L2 store conversion technical support overnight and published the reject and scorecard reports to various stake holders

Other coordination and management activities that include providing estimates, process improvement, time\effort tracking, status updates, defect\JIRA request creation and knowledge transfers

Technology & Tools

Informatica 9.6, Oracle SQL and PL\SQL, Microsoft SQL Server, MS Access DB, and Unix

Project 2

Project Name

Global Portfolio Management

Team Size

12

Start Date

Nov 2013

End Date

Jul 2016

Project Description

G.P.M. - Global Portfolio Management is the application to store the premium and claim information data in Data Warehouse and to report the performance metric of the portfolio across the world-wide business in country level - reporting\producing offices. OGIS (Overseas General Insurance System) the only consistent method of collecting transactional data across worldwide which is the source system for G.P.M. This system is used for financial reporting and analysis

Role & Contribution

Role: Informatica Lead\Onsite S.P.O.C.

Business requirement gathering from on Actuarial and underwriting team for enhancements

Analysis of the existing legacy ETL code by reverse engineering, understanding and to create new mapping rules

Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner and Lookup to develop robust mappings in the Informatica as part of enhancements

Used SCD Type 1 and type 6 mappings to update slowly changing dimension and mini dimensions

Streamlined the team operation by creating required support documents so entire team can be cross trained

Optimized the DB back up strategy to save the DB processing time from 18 hours to 2 hours a day

Involved in Performance tuning at source, target, mappings, sessions and system levels by which reduced the complex workflow run time from 18 hours to 6 hours

Document the bug fixes made with testing results for easy reference of new team members

Performed ETL production data loads analysis and fixed complex problems

Wrote UNIX shell scripts using PMCMD commands for executing and scheduling workflows

Created complex SQL query for STG to Fact table’s reconciliation of business measures

Planning tasks allotted to the team based on the business provided priority and issues tracker

Coordinating the Release Management cycle with required approvals and PVCS for versioning code

Technology & Tools

Informatica, Oracle 11g, Cognos and OTIC 10.6

Project 3

Project Name

EDSAT

Team Size

6

Start Date

Jul 2011

End Date

Nov 2013

Project Description

EDSAT (Electronic Decision Support and Analysis Tool) application is used for various regions to get the business intelligence reports. EDSAT includes the ETL application with Congo’s reporting for A.I.U.’s premium / claims / operational reports. RI Vertical is Reinsurance Vertical a sub project focused on converting the existing legacy system logic in each country to more standardized approach for a region to integrate with EDSAT.

Role & Contribution

Role: Business Analyst \ Technical Lead

Business requirement gathering from Business users

Matching policy number across various front-end systems in Central European region and standardizing the format

Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts

Data Analysis of RI Vertical legacy codes and GOALD DB to derive business logic to design and implement a new standard Informatica ETL approach for Central European region

Congos report Cube, report validation with backend DB results using complex SQLs

Prepare the ETL design documents and designed DB and ETL solutions for the RI Vertical and EDSAT implementations

Co-Ordinate with various team to understand the code issues, fix the bugs and test the changes for various regions of the client

Taking care of the Release Management process

Technology & Tools

Informatica, Erwin 7.2, Genio (O.T.I.C.), Oracle 10g and Unix

Project 4

Project Name

Enterprise Data Warehouse (E.D.W.)

Team Size

6

Start Date

Jul 2010

End Date

Jul 2011

Project Description

E.D.W. is used to report multiple region profits (Premiums) and losses (Claims). In this project we extract source flat files from S.A.S. and build a D.W.H. using a bottom up approach. This in-turn helps the reporting team to fetch required reports for business operations. The E.D.W. architecture presented here is future looking to evolve in coming years.

Role & Contribution

Role: Senior Informatica Developer

Understand and Analysis the specifications, did impact analysis created technical design documents

Co-Ordinate with various teams to understand the deliverables and estimates

Created complex SQL script for Primary key and foreign key dimensional loads and optimized the performance

Design S.C.D Type 2 Informatica mappings

Developed SQL and PL\SQL scripts as per the requirement

Performance tuning of in ETL and SQL scripts

Leading a team of 5 people and provide them required inputs for their development work

Review of developed codes and performance improvements if any required

Creating and maintaining Quality\Audit documents for the deliverables

Technology & Tools

Informatica 8.1, SQL, PL\SQL and UNIX

Project 5

Project Name

Enterprise Information Quality (E.I.Q.)

Team Size

5

Start Date

Nov 2009

End Date

Jun 2010

Project Description

Enterprise Information Quality (E.I.Q.) is organizations significant project vital for the data quality standards for their data. In this project we gather data from various banners\companies which are acquired by SUPERVALU, integrate them into a single platform from various legacy systems, report the inconsistency in data across various environments and standardized data

Role & Contribution

Role: Data Quality Analyst/Informatica Developer

Developing Informatica mappings for ETL related activities

Analyzed business rules and checked the data adherence with those.

Co-Coordinating with onsite Business Analyst and Data modelers to design the ETL data warehouse

Profiling master data tables TS Discovery.

Creating reports using SSRS tool.

Loading data from various legacy systems using Informatica.

Preparing Low Level Design for the developers to develop the codes.

Scheduling the jobs using ESP Scheduler

Guiding couple of people for their deliverables.

Technology & Tools

Informatica 8.1, Trillium, Oracle, SSRS and UNIX

Earlier Assignments

Title

Informatica Developer, Data Quality Analyst

Start Date

Sep 2006

End Date

Nov 2009

Summary

Worked on various assignments for clients from varied sectors including Chemical, Oil & Gas and Supply Chain

Worked on Informatica, Trillium Data Quality and Congos

Played the roles of Developer, Data and Data Quality Analyst

Interacted with management and business stakeholders to gather requirements and analyze the data

Acquired multiple client appreciations and monthly summit awards

Educational Qualification

Education & Credentials

Bachelor of Engineering in 2006

Contact this candidate