Saranya Devi Sannath Kumar

+1-925-***-**** / adrn6x@r.postjobfree.com

Pleasanton, CA

Executive Summary

7+ years of professional experience in Implementation of Data Warehousing project using Oracle11g and Informatica 10.2 with UNIX

Expertise in providing Business Intelligence solutions using Informatica power center 10.2 in Data Warehousing Systems.

Hands on experience in designing and developing mappings, sessions and workflow management.

Extensively used ETL methodologies for supporting data extraction, transformations and loading processing using Informatica Power Centre & Informatica Cloud

Experience in leading ETL teams, guiding them taking the requirement further till build phase and updating management with the updates.

Strong Database skills in writing advanced SQL queries in Oracle and good exposure to Oracle 11g.

Good understanding of PL/SQL concepts.

Good understanding of Python concepts.

Involved in Unit Testing and Integration testing.

Good Knowledge in UNIX shell scripting.

Involved in LLD (Low Level Design).

Hands on experience in all phases of SDLC in Analysis, design, development, testing & support.

Hands on experience in Agile methodologies with usage of JIRA .

Self-motivated, detail-oriented, creative, flexible and able to work effectively in a fastpaced environment.

Ability to handle multiple tasks, initiative and adaptable. Proactive team player with capability of handling responsibilities independently as well.

Excellent communication, inter personal, problem solving skills and ability to perform and lead a team.

Experience in working with geographically distributed teams

Experience in working with ServiceNow tool for the support activities .

Good understanding on the MDM tool RELTIO.

Skills

Operating Systems Windows, Unix, Android

ETL Tools Informatica 10.2, Informatica 9.2

RDBMS Oracle11g

Others C, C++, Core Java

Domain Life Science & Healthcare, Banking

Relevant Project Experience:

Project #1:

Organization SiliconTek,Inc . / Genentech,Inc.

Project US MDM - EPICX

Duration MAR 2020 – Jan 2021

Work Location San Francisco, CA

Role Technical Lead / ETL Consultant

Technologies Oracle 11g, Unix

Tools Informatica 10.2,9.1, Redwood automation,RELTIO Domain Life Science & Healthcare

Project Abstract:

Genentech, Inc., is an American biotechnology corporation which became a subsidiary of Roche. The US MDM –EPICX is long term project which is used to bring a centralized Customer Master Data Management for the downstream applications from different sources. The MDM tool used is Reltio, for which the data from different sources are collected using Informatica in the oracle landing layer and data is processed and transferred to Reltio in files in required format.

Role & Responsibilities:

Develop end to end ETL mappings using Power Center tools - designer, workflow manager, workflow monitor

Developed the workflows and work lets for the entire design.

Developed the scripts for automation the process for data validation and file transfer.

Worked on creating the generic mappings and transformations thus reusable components are used more in the code.

Coordinate with geographically distributed teams for a successful development, testing and deployment of a project.

Involved in the analysis of the existing data from upstream sources and captured the analysis.

Conduct root cause analysis of issues and failures and provide solution for the same.

Involved in creating technical design documents, build source to target mapping documents

(IDM), unit & integration test documents, leading ETL team and onsite-offshore co-ordination.

Modifying existing mappings as per the change requests from the business.

Involved in providing Knowledge transfer regarding the application to the Support team

Involved in the Negative testing, Unit testing and Integration testing.

Worked with Testing team and handling the code fixes for bugs identified.

Good understanding on the MDM concepts such as MATCH and Merge Rules and reference data management (RDM).

Good understanding on the Customer data of the Pharma and health care domain.

Conducted the interviews for the offshore resources.

Involved in the code review processes developed by the team. Project #2:

Organization TATA Consultancy Services, Pleasanton Project Application Support Activities

Duration Jul 2019 – Mar 2020

Work Location Pleasanton, CA

Role ETL Consultant

Technologies Oracle 11g, Unix

Tools Informatica 10.2,9.1,Tivoli scheduler

Domain Life Science & Healthcare

Project Abstract:

Kaiser Permanente is one of the leading health care providers and a nonprofit organization. There are many applications are used by the customers to provide the support to their daily activities. The ETL is playing a vital role in building the data warehouse for data and used for the analytical purpose to extract the business reports. Role & Responsibilities:

Handling the incidents when the jobs failed and finding the root cause for the failure and resolving the issue.

The automation of the monitoring process by automating the scripts.

The small enhancements for the code are developed.

The documentation of the process and updating the support document whenever there is change request raised for the job.

Co ordinating with the various teams to get resolve incident. Co-ordinating with the offshore team for the new enhancements in the existing code. Project #3:

Organization HCL Technologies, Chennai

Project ORION

Duration Jun 2018 – Feb 2019

Work Location Chennai, India

Role Technical Lead / Senior Software Programmer

Technologies Oracle 11g, Unix

Tools Informatica 10.1

Domain Life Science & Healthcare

Project Abstract:

ORION is a front-end application used by MERCK to load data into the database. Oracle Golden Gate

(OGG) will split the data into different schemas. Using Informatica, we will successfully integrate the data from the OGG schema to a replication database. This data from replication database will be used for all the reporting purposes by MERCK.

Role & Responsibilities:

Develop end to end ETL mappings using Power Center tools - designer, workflow manager, workflow monitor

Developed the workflows and worklets for the entire design.

Developed the scripts for the delete flow and automated the process.

Worked on creating the Script for the mappings, thus automating the process.

Coordinate with geographically distributed teams for a successful development, testing and deployment of a single project

Conduct root cause analysis of issues and failures and provide solution for the same.

Involved in creating technical design documents, build source to target mapping documents

(IDM), unit & integration test documents, leading ETL team and onsite-offshore co-ordination.

Modifying existing mappings as per the change requests from the business.

Involved in providing Knowledge transfer regarding the application to the Support team

Involved in the Negative testing, Unit testing and Integration testing.

Involved in troubleshooting the issues in QAT, UAT and production environment and providing hot-fixes for the same.

Expertise in postproduction support, enhancements and performance tuning. Achievements:

• I architected the redesign of the mapping which improved the overall performance of this project. I was nominated for the “Star of the Quarter” award and received the recognition. Project #4:

Organization HCL Technologies, Chennai

Project MDM (Master Data Management), MAXX CRM (Animal Health), Bidirectional Sync Project – MERCK

Duration Jun 2012 – Aug 2015

Work Location Chennai, India

Role Senior Software Programmer

Technologies Oracle 9i, Unix

Tools Informatica 9.1

Domain Life Science & Healthcare

Project Abstract:

The Animal Health Global CRM Data Integrations will successfully facilitate the collection of AH Marketing and Sales users’ data from various countries and load them into the VEEVA System. The data integration will satisfy the Business needs of AH Marketing and Sales users at Merck across various countries.

Role & Responsibilities:

Developed the mappings in Informatica 9x according to the user requirements.

Created the scripts for the mappings, thus automating the process

Worked on each of the release activities and thus implementing the business requirements

Implemented a generalized method of scripting and mapping for around 46 countries, which was an achievement in a way that helped Client to save around 2 million dollars, thus providing a value add

Worked on adhoc activities, as and when required according to the business needs Provided support to the users on the salesforce activities

Provided Knowledge transfer regarding the application to the Support team

Documented the process and application flow

Involved in the Negative testing, Unit testing and Integration testing.

Troubleshooting the issues in QAT, UAT and production environment and providing hot-fixes for the same.

Achievements:

• Client Appreciation for excellence in customer service and devotion toward organization objectives.

• Client Appreciation for excellence in delivery quality.

• Internal appreciation for flexibility and support to organizational changes.

• Early promotion to the next designation in the organization for the commitment and excellence Project #5:

Organization HCL Technologies, Chennai

Project AEGON_NL_MOBILE_APPLICATION – AEGON

Duration Apr 2012 – Jun 2012

Work Location Chennai, India

Role Software Programmer

Tools & Technologies Android, Eclipse

Languages C++, Core Java

Domain Banking

Project Abstract:

AEGON is a successful bank in Netherland which needed an application to be developed for the customers who are served with the service of pension from the bank . This application was developed in such a way that it is compatible in all the smartphones operating on iOS and android. Responsibilities:

Development of the application in a cross platform so that it is compatible with both iOS and Android operating systems

Design of the layout and the UI of the application

Development of the application as per the requirements

Unit Testing of the application

Education

Master of Business Administration in System Management, Madras University, 2015 Bachelor of Engineering in Electronics and Communication, Anna University, 2011 Personal Details

Date of Birth 12-Jan-1990

Sex Female

Nationality Indian

Marital Status Married

Passport Valid till 2025

Visa L2S (Authorized to work in US) – Valid till Dec 2023

Contact this candidate