Developer Informatica

SUMMARY

Having * years of IT experience. Worked with LiquidHub, A Capgemini Company as a Team Lead.

Worked 2 years in Informatica Production Support and 7 years in Informatica development.

Involved in ETL projects based on Informatica.

Good Knowledge in Data warehousing concept and Informatica PowerCenter.

Used transformations like joiner, expression, connected and unconnected lookups, filter, aggregator, update strategy, router, sorter, sequence generator, normalizer etc.

Developed mappings, mapplet & reusable transformations using PowerCenter Designer for data loading.

Created and used workflow variables, session parameters and mapping parameters

Implemented Slowly Changing Dimension methodology for accessing the full history of accounts.

Involved in detailed analysis, design, development, maintenance and upgrading systems to support business operations.

Experience in using Power Center Designer and Workflow Manager, Workflow Monitor tools in Informatica Power Center.

Experience in preparing and running sessions, worklets and workflows in Workflow Manager.

Proven capability of meeting project goals using technical, inter personal and team work skills.

Done defect management and resolution.

TECHNICAL SKILLS:

ETL Tools

Informatica Power Center 10.2.0 & Informatica Power Center 9.5 & 8.6

Programming Languages

SQL, PL SQL and UNIX Shell Scripting

Database

Oracle

Tools

Oracle SQL Developer, Remedy, Service Now, IBM Tivoli.

Operating Systems

Windows, Unix

EDUCATION:

Degree/Year/University

Name of the Institution

Aggregate

B Tech(2004-2008)

Kerala University

Sree Buddha College of Engineering, Pattoor, Alleppey, Kerala

70.20%

12th(2002-2004)

CBSE

S N Central School, Kayamkulam, Kerala

72.00%

10th(2002)

SSLC

ST: Mary's Girls High School, Kayamkulam, Kerala.

93.80%

PROFESSIONAL EXPERIENCE:

Immediate Last Employer: LiquidHub, A Capgemini Company

Designation : Consultant

Period : 30th January 2019 to 10th April 2020

Previous Employer: Cognizant Technology Solutions

Designation : Associate

Period : 7th May 2010 to January 28th 2019

Previous Employer: Shree Ram Transport Finance Company Limited

Designation : Management Trainee

Period : 28th December 2008 to January 13th 2010

REPRESENTATIVE PROJECT EXPERIENCE SUMMARY

1. Project Name

Allergan Exec Reporting

Industry

Life Science/Pharma

Client

Allergan Public Ltd Company

Role

Offshore Team Lead

Technologies

Informatica 10.2,Oracle SQL Developer

Project Description: Allergan plc is an Irish–tax registered pharmaceutical company that acquires, develops, and markets branded drugs, and in 2017 generated 80% net sales from the U.S. healthcare system. We are dealing with one of the product Botox, which is mainly used in the treatment of migraine, muscle spasticity and in cosmetics for treating facial wrinkles and all.

Roles & Responsibilities:

Participated in daily calls, task assignment etc.

Participated in enhancement of the current code, performance tuning etc.

Maintaining task tracker sheet, leave tracker sheet etc.

Developing and delivering new requirements and CRs.

2. Project Name

Kaiser Regulatory Finance Project

Industry

Healthcare Industry

Client

Kaiser Permanente - USA

Role

Offshore Team Lead

Technologies

Informatica 10.2, Oracle SQL Developer

Project Description: This project deals with the finance side of Kaiser, like payroll, general Ledger, Travel and Expenses etc. ETL jobs are developed in Informatica to load the finance related data into their corresponding dimension/Fact tables upon which the reports are built.

Roles & Responsibilities:

Created mappings, sessions and workflows as per the requirement. Did unit testing and prepared Unit Test Cases for each new requirement.

Participated in daily calls, to discuss about the design of new requirement and defect fixes, if any. Participated in offshore task assignment and reviewing.

Handled each change requests(CRQs) independently including coding, testing, test case preparation for CAB meeting and gave KT(regarding functional and technical changes) to the Production Support team about the change.

Helped the prod support team in identifying and performing a RCA for any adhoc Production failures. Coordinated with different teams like ETL Admins, DBAs, Tiwoli teams for any Preprod or Production issues.

Created/modified the tiwoli webforms whenever required.

Did history fixes by using DMLs and by developing separate Informatica mappings/workflows.

Tracked status of all the activities in accordance with the project plan to ensure the delivery dates are met.

Optimized/Tuned mappings for better performance and efficiency.

Mentored new joiners in the team and also maintained the task tracker, leave tracker etc for the offshore team.

3. Project Name

CDW Invest NW Tapestry

Industry

Healthcare Industry

Client

Kaiser Permanente - USA

Role

Offshore Team Member

Technologies

Informatica 9.1, Oracle SQL Developer

Project Description: Kaiser initiated to develop a centralized claims data warehouse to provide a consistent industry standard view of claims data to all regions to perform reporting, analytical and operational functions, such as Financial Reporting, Pricing/ Rating Function, Provider Contracting. ETL jobs are developed in Informatica to load claims data from various source systems/claim processing tools built on various applications like Oracle and in the form of flat files into a centralized Claims Data warehouse and to integrate the Claims data warehouse with the new source system going to evolve in future.

Roles & Responsibilities:

Created mappings, sessions and workflows as per the requirement.

Participated in daily calls, daily task discussions and defect fixes, if any.

Handled each iteration (CRQs) independently including coding, testing and defect fixing.

Did history fixes by using DMLs and by developing separate Informatica mappings/workflows.

Tracked status of all the activities in accordance with the project plan to ensure the delivery dates are met.

Did unit testing and prepared UTCs and the test results are documented.

Optimized/Tuned mappings for better performance and efficiency.

Mentored new joiners in the team

4. Project Name

CDW Invest EMI

Industry

Healthcare Industry

Client

Kaiser

Role

ETL Developer/Team Lead(Single member project)

Technologies

Informatica 9.1, Oracle SQL Developer

Project Description: Kaiser is operating in multiple states of US and having different claim processing tools to process the claims. As part of CDW Invest, Kaiser is performing the enhancement and bug fixing for Ambulatory claims.

Roles & Responsibilities:

Development of Informatica mappings and workflows to pull data from for the ambulatory claims.

Unit test case preparation and unit testing and test results documentation.

Participated in bug fixing and enhancement of the existing code, coordinating with the testing team for fixing bugs.

Ensured smooth delivery of the project within the scheduled time limit

Provided warranty support for the code after successful testing in QA.

5. Project Name

CDW Invest KPIC

Industry

Healthcare Industry

Client

Kaiser

Role

ETL Developer/Team Lead(Single member project)

Technologies

Informatica 9.1, Oracle SQL Developer.

Project Description: As part of CDW Invest, Kaiser is performing the development the new project for KPIC, which will process the insurance claims data.

Roles & Responsibilities:

Analysis of requirements, design, development and testing for all the new requirements.

Created mappings, sessions and workflows as per the mapping document.

Provided status to onsite and clients through daily calls and status mails.

Unit test case preparation and unit testing and test results documentation.

Status tracking of all the activities in accordance with the project plan to ensure the project schedule is met.

Provided warranty support for the code after successful completion of QA testing.

6. Project Name

PPD Corporate Integrity Agreement(PPD CIA)

Industry

Pharmaceutical Industry

Client

Abbvie

Role

ETL Developer

Technologies

Informatica 9.1, Oracle, Teradata SQL Assistant

Project Description: As part of CIA, Abbott is enforcing Best Specialty monitoring. Two universes have been designed and implemented with list of hospitals and hcps with the corresponding list of approved brands based on the specialty. All sales and promotional activities (HCP calls, Account Calls, Speaker Programs, Sample drops,Non-Retail Sales,HPDW) need to comply with the universe and will be continuously monitored. Any unapproved activity by a representative will be reported to ASPIRE and the management would need to attest them.

Roles & Responsibilities:

The job responsibilities included creating/modifying mappings, sessions and workflows as per the mapping document.

Unit test case preparation and unit testing and test results documentation.

Actively participated in defect fixes in QA and UAT environments.

Participated in daily stand up calls.

7. Project Name

ABBV BI Shared Services-Infa Upgrade

Industry

Pharmaceutical Industry

Client

Abbott/Abbvie

Role

ETL Developer

Technologies

Informatica 9.1,Informatica 8.6, Oracle SQL Developer, Teradata SQL Assistant

Project Description: Informatica Upgrade project upgraded Informatica 8.6, 8.5 versions to Informatica 9.1 for all Commercial applications in AbbVie PPD. One of the benefits with this upgrade was in migrating some of the unsupported applications to the Informatica 9.1 version.

Roles & Responsibilities:

Performed analysis and dry run of all the workflows in the system.

Have done the unit testing for selected flows in QA and prepared UTC docs.

Have resolved connection issues, modified existing connections and created few in order make the workflows compactable to 9.1 Informatica environment

Verified scripts present and changes needed for up gradation were made.

After successful completion of QA testing, the code was promoted to 9.1 Informatica Prod and the team had provided a warranty support for 2 weeks.

Coordinated with the team, mentored new joiners in the team helped them out in functional and technical aspects.

Status reporting of the project to ensure that all activities are captured and risks highlighted.

8. Project Name

UBS-Investment Banking PST

Industry

BFS

Client

UBS-IB

Role

L1/L2 Support Analyst

Technologies

Informatica 8.6, Oracle SQL Developer, Unix,

Remedy, IBM Tivoli Maestro

Project Description: Providing L1/L2 support to the Informatica jobs which process investment banking data in UBS.

Roles/ Responsibilities:

Providing daily status to client, after each load.

Ensure the timely completion of the batch cycles as per the schedule

Alert the business on time for any abnormality in the system like Jobs not running on time, online regions not being up on time or Jobs running longer

Analyse and if required co-ordinate with DBAs if any sql statements taking more time than expected or any table got locks or any performance issue.

Daily production support from offshore, special monitoring and schedule changes of batches during month end and yearend financial closings include monitoring of jobs and fixing problems if any.

Update relevant documents and report progress on maintenance.

Responsible for providing code changes required as per the CRQ, to fix any production issues.

9. Project Name

MetLife –PST

Industry

Insurance Industry

Client

MetLife

Role

L1/L2 Support Analyst

Technologies

Informatica 8.6, Oracle SQL Developer, Unix,

Remedy, IBM Tivoli Maestro

Project Description: Providing L1/L2 support to the Informatica jobs which were processing the insurance products in MetLife, Inc.

Roles/ Responsibilities:

Job Monitoring

Providing daily status to client through status mails.

Ensure the timely completion of the batch cycles as per the schedule

Ensure all the online regions are up on time

Alert the programmers/schedulers/DBAs for any abnormality in the systems like jobs not running on time, online regions not being up on time or jobs running longer

Co-ordinate with various application programmer teams to resolve abends.

Responsible for providing production support which involves fixing the production abends as per the KEDB documentation.

Previous Company: Shree Ram Transport Finance Company LTD

10. First Company Name

Shree Ram Transport Finance Company LTD(STFC)

Industry

Non Banking Finance Company

Duration

29th Dec 2008 to 13th Jan 2010

Role

Management Trainee

Technologies

Management, NBFC policies.

Roles & Responsibilities in the Shree Ram Transport Finance Company LTD

Worked in an NBFC (Shriram Transport Finance Co Ltd); as a Management Trainee. Relieved as Assistant Manager from the organization.

Understood the KYC (Know Your Customer) policies to be followed.

Undertaking the credit card accounts work for the whole TN region.

Understood the NBFC policies to be followed.

Understood the finance procedures like loan issuing, MIS, settlements etc.

PERSONAL INFORMATION:

Phone : +91-770*******

Date of Birth : 18th August 1986

Passport No : J9455031

Marital Status : Married

Contact this candidate