Informatica Data

Kumaravel Rajendran Professional Profile

Experience Summary:

Having 4.11 years of professional experience (44+ months in the design/implementation, testing and development in Data ware housing).

Trained in Informatica, Oracle.

Hands on Experience on Informatica 9.6 & 10.2, Oracle.

Knowledge of Extraction, Transformation and Loading mechanisms using Informatica, related development and testing.

Able to integrate self into the organizational Vision and goals.

Have been keen to understand the business and coming up with solutions using Data warehousing concepts.

Educations:

B.E (Electrical and Electronics Engineering)

(2011 to 2015)

Aggregate CGPA – 7.3 CGPA

GKM College of Engineering and Technology -

Chennai

HSC (2011) – 80.5%.

Mount Zion Matriculation Higher Secondary School, Pudukkottai

SSLC (2009) – 81.3%.

Mount Zion Matriculation Higher Secondary School, Pudukkottai

Employment Details:

Current Employer –Cognizant Technology Solutions

ELCOT, Sholinganallur, Chennai

Duration: Mar 4, 2019 – Till date (1 Year)

Designation: Program Analyst

Previous Employer – Capgemini, EPIP phase, Whitefield

Bangalore.

Duration: Feb 25, 2016 – Mar 1, 2019 (3 Years)

Designation: Associate

Professional Profile (Contd.)

Project Undertaken:

1.Group Benefits Data Warehouse – The Hartford Financial Services Group, inc.

The Hartford is a United States-based investment and insurance company. The Hartford is a Fortune 500 company headquartered in its namesake city of Hartford, Connecticut. They sell products primarily through a network of agents and brokers. In this project we have four main sources- AARP, Agency, Affinity, and CDRT. The main objective of this project is the enhancements in the Hartford personal lines database. This mainly includes Auto policy, Auto Quote, Property policy, Property Quote.

Responsibilities:

Developing Informatica ETL mappings, sessions, workflows for loading different stages like Dimension and Fact tables.

Development and Enhancement of PL/SQL Oracle procedures and packages.

Preparing UNIX scripting for workflow kick start, file processing and sending mails to customers.

Worked with onshore SME’s to understand the requirement.

Performed Impact Analysis, Design Preparation, Peer Review and on-time deliverables.

Supported in migration activities of Informatica Upgrade 9.6 to 10.2.

Preparation and documentation of test cases for Unit Testing.

Performing the Unit tests cases and capturing the results.

Duration: Mar 5 to till Date

Technologies: Informatica v10.2, Oracle, UNIX Scripting, Autosys Job Scheduler

Working Capital Solutions – WCS facilitates Factoring and collections related application which provides funding to mostly GE internal clients based on their unpaid invoice and credibility feedback of Clients received from third party. Deals with financial transaction where a company/business sells its accounts receivables (or invoices) at a discount to another company. This other company is then responsible for collecting on that invoice from the third party.

Responsibilities:

●Daily validations of data and loads monitoring along with the enhancement tasks.

●Working as offshore ETL developer, responsible for derivable, WSR report and status call with all stake holders.

●Analysis on existing ETL mappings

●Creation of design document for ETL transformations

● Created mappings/sessions/worklets/workflows

● Creation of parameter files for passing proper connection variables/mapping parameters/session parameters

● Performing checklist on migrations Creation of Release Notes and Packages for migration to QA and Prod environment

Duration: May 28, 2016 to Feb 28,2019

Technologies: Informatica v10.2, Oracle, Autosys Job Scheduler

Activities and Achievements –

Received appreciation from Client on successful delivering the project release in Reverse Feed Project.

Received Sparkle Award for Best Performer in 2019 Q3 Quarter.

Dedicated, focused and technically sound.

Good communication skills and analytical abilities.

Declaration:

I hereby declare that all the above-mentioned details are true to the best of my knowledge. Place:

Date: Kumaravel Rajendran

Contact this candidate