Ranjith Kumar CH

(Sr. ETL Informatica Consultant)

9494982875, [email protected]

Professional Summary

Having 7 years of experience in IT Industry involving Software Analysis, Design, Implementation, Coding, Development,
Testing and Maintenance with focus on Data warehousing applications using ETL tools like Informatica PowerCenter, IDQ and
IICS. Design and Development for various software applications in client-server environment and providing Business
Intelligence Solutions using ETL tools like Informatica, DataStage, MDM as staging, Teradata, and Talen din. Having hands on
experience as a ETL Development and Testing in Banking, Healthcare, and Insurance domain.

 Having complete domain and development Life Cycle knowledge of Data Warehousing.
 Worked on IICS Development in CDI and CAI.
 Developed Mappings, Taska and Task flow in IICS.
 Experience in data mart life cycle development, performed ETL procedure to load data from different sources into
Data marts, Data warehouse and DSS using Informatica Power Center 10.1.1/9.1.0/8.6.1 IDQ (Informatica Data
Quality), Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer,
Workflow Manager and Workflow Monitor.
 Have hands -on experience in performance tuning of Informatica mapping, sessions, source and target.
 Strong experience in Extraction, Transformation, loading (ETL) data from various sources into
 Data Warehouses and Data Marts using Informatica Power Center and IICS (Designer, Workflow Manager, Workflow
Monitor.
 Hands on experience in handling data from various source systems such as Mudflat Files, XML Source, Oracle, IBM
DB2 and Excel Files
 Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess
excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
 Designed, Developed and Executed Test Cases to ensure that product meets the user’s business requirements.
 Skilled in coordinating with Project Managers, Business Analysts and System Analysts to setup the pre validation and
validation environment to execute the scripts.
 Experience in developing Test Plans, Test Strategies and Test Cases for Data Warehousing projects ensuring the data
meets the business requirements
 Worked extensively on Error Handling, Performance Analysis and Performance Tuning of able to work
independently, versatility and Adaptability to any environment having good communication skills, Interpersonal
relations, hardworking and result- oriented as an Individual and in Team.
 Involved in knowledge sharing and knowledge transfer to the new members of the project & Preparation of
knowledge transfer documents
 Having good communication skills, Interpersonal relations, hardworking and result- oriented as an Individual and in
Team.
 Ability to Understand Functional requirements and interaction with Client meetings.
 Maintaining the Traceability Matrix, Test data Matrix and status report related to project.
 Hands on experience in Black Box testing, White Box Testing, Unit Testing, User acceptance testing, (UAT),
Functional, Integration, GUI, System, Usability, Regression, Smoke testing and end to end testing.
 Experience in analyzing test results and submitting bugs using Bug Tracking Tools JIRA and HP Quality Center.
 Experience in Web based testing including Unit Testing, GUI Testing, Regression Testing, Integration Testing, System
Testing, Performance Testing and Functional Testing.
 Excellent problem-solving skills with a strong technical background and result oriented team player with excellent
communication and interpersonal skills.
 Extensively used ETL methodology for supporting Data Extraction, Transformation and Loading processing, in a
corporate-wide-ETL Solution using Informatica.
 Got the opportunity to work in onsite and having good communication skills to deal with the clients.

Educational Qualification:

 Completed M.B.A from Osmania University In the year 2015.

  Completed B. Com from Osmania University in the year 2013.

Work Experience

 Sr. Informatica Developer at Halcyon Technologies

 Sr. Software Engineer at Infomerica (India) Pvt. Ltd
 Former Informatica Developer at IDC Technologies
 Former Senior Associate at Optum Global Solutions

TECHNICAL SKILLS

ETL Tools IICS, Informatica PowerCenter 10.1.1/9.1.0/8.6.0/8.1.1/7.1.1/6.2,

PowerMart6.2/5.1/4.7, Informatica Data Quality 8.5, Power Exchange 9.1

Data Modeling Erwin 7.2/4.0/3.5

Requirement Management Rational Requisite Pro V7.0.1
Databases Oracle10g/9i/8i, Teradata 12, MS SQL Server 2010/2008/2005/2000, IBM
DB2/UDB, SQL, PostgresSQL Snowflake, and Teradata
Languages SQL, PL/SQL, SQL*Plus, HTML, UNIX, DBMS, C, C++
Tools SQL plus, TOAD, Autosys, CRONTAB, IBM Infospheres, Apache Velocity Modules,
Maven PDK
Operating Systems UNIX, Windows (XP, NT/95/98/2000), WinNT4.0, MSDOS6.22
Testing Tool SILK, JIRA, Confluence, HP ALM
Management Tool HP Quality Centre
Test Approaches Waterfall, Agile/Scrum, SDLC, STLC, Bug Life Cycle

PROFESSIONAL EXPERIENCE:

Client Name :- AbbVie / ZS Associates

Duration :- Apr’23 to Sep’23
Role :- Sr Informatica Developer

Project Description: -
AbbVie Inc. is a pharmaceutical company headquartered in North Chicago, Illinois. It is ranked 6th on the list of largest
biomedical companies by revenue. The company's primary product is Humira, administered via injection. It is approved to
treat autoimmune diseases including rheumatoid arthritis, Crohn's disease, plaque psoriasis, and ulcerative colitis.

Role & Responsibilities: -

 Understanding the Business Logic from existed Informatica PowerCenter mappings.
 Migrating existing DDL scripts from TD, Creating new DDL scripts into Snowflake
 Load data from TD to Snowflake in Source by using TPT.
 Validate source query and checking performance issues, checking pre and post SQL and commands.
 Preparing Data Validation documents.
 Raise CPR request to migrate code from DEV to Prod.
 Raise RTI request from service now for scheduling jobs.
 Monitor jobs in Autosys
 Reviewing the sprint tickets and updating the status in Jira.
 Scheduling the jobs in IICS.
 Actively looking and resolving prod issues.
Environment: IICS, IDQ, Informatica PowerCenter, Jira, Teradata, Unix and Snowflake.

Client Name :- CONOCO PHILLIPS / PwC

Duration :- Apr’23 to Sep’23
Role :- Sr Informatica Developer

Project Description: -
ConocoPhillips is one of the world's largest independent exploration and production (E&P) companies based on proved
reserves and production of liquids and natural gas. We explore for, produce, transport and market crude oil, bitumen,
natural gas, natural gas liquids and liquefied natural gas on a worldwide basis. Our module will take care of loading Europe
and North America Transport data from flat files to PostgreSQL DB using IICS

Role & Responsibilities: -

 Have worked on Cloud Data Integration (CDI) and Cloud Application Integration (CAI)
 Understanding the Business Logic from existed Informatica PowerCenter mappings.
 Gathering the source and target details from existed Informatica PowerCenter mappings.
 Creating new IICS mappings, mapping tasks and task flows from scratch as equivalent to existing code in Informatica
PowerCenter.
 Preparing UT documents.
 Creating release documents and doing releases for QA and Prod using GitHub.
 Reviewing the sprint tickets and updating the status in Jira.
 Scheduling the jobs in IICS.
 Actively looking and resolving prod issues.
Environment: IICS, Jira, GitHub, Unix and Snowflake

Client Name :- Common Wealth Bank of Australia/ TCS

Duration :- Apr’23 to Sep’23
Role :- Sr Informatica Developer

Project Description: -
Colonial First State Global Asset Management (CFSGAM) is the asset management division of Commonwealth Bank of
Australia (CBA) which is one of the largest financial institutions in Australia. CBA-GAM offers tailored investment solutions for
retail, wholesale and institutional investors and aims to create wealth by applying active and disciplined approach to manage
the investments.

CBA-GAM invests across diverse range of asset classes namely Australian and global equities, cash, fixed interest and credit,
property securities, listed infrastructure and hedge funds, listed and unlisted property, private equity and infrastructure.

Role & Responsibilities: -

 Worked with Data mapping team to understand the source to target mapping rules.
 Extracting of data from flat files and loading in to Oracle using transformations in the mappings
 Analyzed the requirements and framed the business logic and implemented it using Informatica.
 Involved in ETL design and documentation.
 Worked on the design, development and testing of mapping and Workflow.
 Worked extensively with mappings using Expressions, Aggregators, Filters, Lookup, Dynamic Lookup, and Connected
and unconnected lookups, Filters, Sequence, Router and Update Strategy to develop and feed Data Warehouse.
 Worked on improving the performance of the mappings.
 Worked on Exporting and Importing of workflows.
 Implemented update strategy on tables to read data from tables to pull only newly inserted data from source tables.
 Data quality validation includes Creating test cases for Testing, and helping for UAT.
 Proper Documentation for All changes to meet the standards of the organization.
 Created Generic and Repository schemas.
 Monitored the daily runs, weekly runs and adhoc runs to load data into the target systems.

Client Name :- United Medical Resource / OPTUM Global Solutions

Duration :- Apr’23 to Sep’23
Role :- Sr Associate

Project Description: -
UMR is the third-party business of UHG. It is an American profit managed health care company provides health care products
and insurance services. UMR aims to deliver on a seamless basis, value added services such as national health care provider
network discounts, advanced claims-control functions, integrated chronic condition management and wellness programs, it
headquarters in Wausau. we load the member and provider data from flat files to relational tables using IICS.

Role & Responsibilities: -

 Gathering the requirements and reviewing.
 Developed the DDLs and mappings for source to landing tables (straight and truncate and load), land to stage
(incremental load), stage to common (business logic) and common to ops (for reporting).
  Prepared mapping specs and job inventory for some modules.
 Created the complex views on stage tables.
 Creating the AutoSys jobs and JIL file.
 Performing the UT for developed mappings
 Reviewing the other team member’s developed mappings.
Environment: IICS, Informatica PowerCenter 10.1, Greenplum, SQL server, Unix, Putty, WinSCP and Autosys.

Client Name :- WellCare / OPTUM Global Solutions

Duration :- Apr’23 to Sep’23
Role :- Sr Associate

Project Description: -
This is Health insurance project. Loaded the claims, services, member, and provider data coming from different sources like
HTR, UAMF, UAMFEODS, P2P, LAB and XCELEYS etc. The source data will be a flat file or tables from SQL server or oracle. This
is completely an ETL project.

Role & Responsibilities: -

 Working as a fully contributing team member, under broad guidance with independent planning & execution
responsibilities.
 Interacts actively with Data Modelers on Mapping documents and design process for various Sources and Targets and
the relationship involved in physical, logical design data models.
 Interaction with business analyst to understand the requirement.
 Estimation and requirement gathering.
 Analyzing the application system and their source databases
 Analyzing business information requirements
 Data Analysis
 Review with business and validate the requirement.
 Creating External Table in Oracle database
 Data Extraction from all source application
 Mapping, Sessions & Workflow creation
 Validating the testing strategy to validate the data.
 Hands on experience in handling data from various source systems such as Flat Files, XML Source, Oracle, MS SQL
Server, IBM DB2, Teradata and Excel Files
 Expert Developer skills in Teradata RDBMS, initial Teradata DBMS environment setup, development and production
DBA support, use of FASTLOAD, MULTILOAD, TPUMP, and Teradata SQL and BTEQ Teradata utilities.
 Implementing the application in production
 Software Testing including Unit, System and System Integration Testing, Test case/data preparation and execution.
 Designed Data transformation from Transient to Staging, Fact and Dimension Tables in the Warehouse.
 Used transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner,
Expression, Stored Procedure, and update strategy to meet business logic in the mappings.
 Created and tested Informatica mappings and workflows to automate Job scheduling.
 Created Workflow, Worklet, Assignment, Decision, Event Wait and Raise and Email Task, scheduled Task and Workflow
based on Client requirement.
 Created sessions, batches for full and incremental load into staging, TDH and EDW tables, and schedule them to run
daily/weekly/monthly.
 Developed various Mappings with the collection of Sources, Transformations, and Targets, using designer.
 Extensively worked on Performance tuning to increase the throughput of the data load (like read the data from flat file
& write the data into target flat files to identify the bottlenecks).
 Extensively worked on SQL tuning process to increase the source qualifier throughput by analyzing the queries with
explain plan, creating new indexes, partitions, and Materialized views.
 Developed, executed Test Plans and Test Cases to validate and check Referential integrity of data extracts before
loading it to Data Warehouse.
 Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
 Created Queries, labels and deployment groups to migrate the code from different environments.
Environment: Informatica PowerCenter 10.1, Greenplum, SQL server, Unix, Putty, WinSCP and Autosys.

RANJITH KUMAR CH