Balaji Palaniappan Tamilarasan

412-***-****

adlgzp@r.postjobfree.com

SUMMARY OF QUALIFICATIONS

12+ years IT experience in developing Applications Using Informatica, Informatica B2B DX&DT, Data Modelling, Data Analytics, Data Visualization, Informatica IDQ Data Profiling, Unix Scripting, PMCMD, Oracle, Mainframe, Python, PETL, SQOOP and SQL Server

Experience in Informatica Power exchange for reading the legacy source system.

Worked on different Sources such as Oracle, Teradata, Power Exchange VSAM Files, SQL Server, Hadoop, Salesforce and Flat Files

Have been performing Project Lead for past 5 Years

Experience in SQOOP. – Oracle to Hadoop Integration, Data Robot -Data visualization tool

Experience in Tableau Data visualization

Diverse experience in HealthCare & Financial Domains

Experience in Estimation, MPP, Technical Interview Panel & Project management Activities

Involved in Preparing HLD, LLD, Test cases, Test Plan, Cut over Plan and ETL Estimation

Experience in independent team management.

Experience in leading offshore team as well as onsite team.

Have experience in both Agile & Waterfall Model project environment

Experience in EDI platform project

Experience on Data exchange file transfer management like Managed File Transfer, Message queue & Java Messaging Service

Secured Client Scope Awards for my contribution towards multiple Projects

Secured Client Award from Xerox for contribution of project.

Designed and developed EDW, Data masking Systems for prestigious clients Xerox & Ameriprise.

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

Very flexible and can work independently as well as in a team environment

Involved in migration code into different environments

Experienced in Performance and tuning of the ETL,Oracle & Linux

Shares learning and coaching experience through knowledge transfers between peers

TECHNICAL SKILLS

Tools: Informatica Power Center 10.x/9.x/8.5.1/7.x/6.x, Informatica Power Connect & Exchange for Mainframe, Informatica B2B DX & DT, Tableau, SQOOP & IDQ Data Profiling,PETL

DB: Oracle 11i/10g/9.x/8.x, MS SQL Server 2008, Teradata

Design/Application: Microsoft Visio (Visio Soft Diagram), Control-M, CA7 Scheduler, TOAD, SQL Developer.

Languages/Scripting: UNIX, PL/ SQL, UNIX Shell Scripting, Python

Operating System: Sun Solaris, UNIX/LINUX, MS-DOS, Windows 2008/2007/ NT/2000/XP

Other Tools: Sql Developer, Winscp, Putty, Jira, Quality Center, Clear Case, Harvest

PROFESSIONAL EXPERIENCE

CGI., Pittsburgh, PA

PNC Bank- Risk Rating Platform

Oct 2018 –

Senior Consultant

In Consumer Banks Risk Rating is the main process to rate the customers and provide them credit based on the decision. RRP Application provides platform to rate the customers based on the inputs provided and the relationship of the customer with the bank.

This RRP data are then provided to many down streams such as EDW and other international banking application for processing.

ETL process helps in to pull the data from various source systems as well as application to the RRP application in order to rate the customers from the input source and also migrates the data to all other downstream application from RRP.

Responsibilities:

Working as ETL Architect- independent resource supporting architecture design, data modelling & development

Working as Data Modeler and DBA support

Responsible for creating data pipeline with python to interact with the Risk platform website and check or cleanse the data.

Responsible for Design, Coding & support for all ETL & Inbound/Outbound Data.

Involved in Estimation and project management activities.

Collecting requirements from various business analysts and develop the code based on the Business requirements

Involved in ETL design, coding, testing and implementations.

Tuned the oracle query to load the huge volume of data.

Tuned the performance of complex Informatica mappings and database.

Worked with cross functional teams to resolve the issues.

Created slowly changing dimensions’ mappings to meet the business requirements.

Performed data validations.

Worked extensively on Informatica partitioning when dealing with huge volumes of data and also partitioned the tables.

Involved in the defect analysis call for UAT environment along with users to understand the data and to make any modifications to code.

Performed Root cause analysis and resolved complex issues.

Prepared the recovery process in case of workflow failure due to database issues or network issues.

Supported the applications in production on rotation basis and provided solutions for failed jobs.

Mastech Inc., Pittsburgh, PA

PNC Bank- Risk Rating Platform

July 2016 – Oct 2018

Sr ETL Lead /Appl Data Architect

In Consumer Banks Risk Rating is the main process to rate the customers and provide them credit based on the decision. RRP Application provides platform to rate the customers based on the inputs provided and the relationship of the customer with the bank.

This RRP data are then provided to many down streams such as EDW and other international banking application for processing.

ETL process helps in to pull the data from various source systems as well as application to the RRP application in order to rate the customers from the input source and also migrates the data to all other downstream application from RRP.

Responsibilities:

Responsible for Design, Coding & support for all ETL & Inbound/Outbound Data.

Involved in Estimation and project management activities.

Collecting requirements from various business analysts and develop the code based on the Business requirements

Involved in ETL design, coding, testing and implementations.

Created test cases and test scripts to validate data.

Tuned the oracle query to load the huge volume of data.

Tuned the performance of complex Informatica mappings and database.

Worked with cross functional teams to resolve the issues.

Created slowly changing dimensions’ mappings to meet the business requirements.

Performed data validations.

Worked extensively on Informatica partitioning when dealing with huge volumes of data and also partitioned the tables.

Involved in the defect analysis call for UAT environment along with users to understand the data and to make any modifications to code.

Performed Root cause analysis and resolved complex issues.

Prepared the recovery process in case of workflow failure due to database issues or network issues.

Supported the applications in production on rotation basis and provided solutions for failed jobs.

Actively attended the production support calls and pagers at all times and answered the business questions.

Cognizant,

Albany, NY

United States Federal Healthcare MMIS Product -Xerox

Mar 2011 – July 2016

Project Team Lead

Xerox to Provide BI Solutions to UHG for NY, ND, NH, AK States. “Conversion” as one of the most critical activities in the entire implementation process. The purpose of conversion project is to convert/migrate and load source data into the new MMIS database from legacy systems.

“Interface” process provides the state with information regarding inbound and outbound interface files processed within MMIS. It defines interface processes for trading partners who are authorized to submit and/or transmit interface files and have a valid Trading Partner Agreement (TPA) with Department of Health and Human Services (DHHS). The interfaces process affects various functional areas like: (EDMS, Member, Claims, Prior Authorization, Provider, Contact Management, EDI, Reference,Global,Managed Care, Claims Front End, Third Party Liability, Data Management, Administrative Reporting, Pharmacy)

Responsibilities:

Leading the team from onsite as well as offshore.

Involved in Estimation and project management activities.

Collecting requirements from client through concept sessions.

Data Profiling on Legacy source.

Discussion with various business analysts and

Created test cases and test scripts to validate data.

Tuned the oracle query to load the huge volume of data.

Tuned the performance of complex Informatica mappings and database.

Worked with cross functional teams to resolve the issues.

Created slowly changing dimensions mappings to meet the business requirements.

Performed data validations.

Worked extensively on Informatica partitioning when dealing with huge volumes of data and also partitioned the tables.

Involved in the defect analysis call for UAT environment along with users to understand the data and to make any modifications to code.

Performed Root cause analysis and resolved complex issues.

Prepared the recovery process in case of workflow failure due to database issues or network issues.

Supported the applications in production on rotation basis and provided solutions for failed jobs.

Actively attended the production support calls and pagers at all times and answered the business questions.

Environment: Informatica 8.6/9.x, Informatica Power Exchange, Informatica B2B, Oracle 10g, Windows, UNIX.

Infosys Technologies, Chennai, India

Senior Systems Engineer

Nov 2008 – Mar 2011

Ameriprise Financial needs data to be transformed from external system to their own system such as from salesforce CRM, VSAM, Mainframe DB. The data should be published daily to their portal through EODS process.

Have involved in all the streams such as files publish team, salesforce source system & EODS system.

Responsibilities:

Involved in all phases of the project life cycle including requirement gathering, analysis, design, coding, testing and implementation.

Interpreted and comprehend business/data requirements from upstream processes

Documented technical requirement specifications and detailed designs for ETL processes of moderate and high complexity.

Created and documented source-to-target mappings and ETL specifications.

Created complex Informatica mappings, mapplets and re-usable transformations and prepared various mappings to load the data into different stages like landing, staging and target tables.

Designed and performed all activities related to migration of ETL components between environments during development and deployment (Eg. Dev to SIT, SIT to UAT and UAT to PROD repositories).

Checked for missing data, negatives and consistency and completed field-by-field data verifications for source and target data consistency.

Used various transformations including Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and Optimizing. Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.

Worked extensively on Informatica Partitioning when dealing with huge volumes of data and also partitioned the tables in Oracle for optimal performance.

Handled Salesforce CRM database in ETL.

Prepared the error handling document to maintain the error handling process and created test cases for the mappings developed then created the integration testing document.

Involved in the defect analysis call for UAT environment along with users

Developed workflows using Task Developer, Worklet Designer, and Workflow Designer in Workflow manager and monitored the results using Workflow Monitor.

Informatica Mapping Design and Informatica Coding.

Oracle Test Scripts Preparation.

Handling Production data – Analysis on Client requirement and providing inputs/Suggestions on enhancement or performance which can improve business aspects.

Handling New Change request and Defect Fixing.

Working with Mainframe and UNIX Shell Scripts preparation.

Handling User Acceptance Testing, System Integration Testing and Data Validations.

.

Environment: Informatica 8.5, Oracle 10g, Windows, Informatica Power Center, UNIX & Mainframe

EDUCATION

B.E (Bachelor of Engineering) in 2008 from Anna University, Chennai-India

Contact this candidate