Data Informatica
Resume:
Balaji Palaniappan Tamilarasan
********.***@*****.***
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