Revathi Kaliappan
South Brunswick NJ
Professional Summary
●Over 10+ years of progressive IT experience with focus on Data Warehousing solutions,Design,Testings,supports in various Domains
●Proficient ETL working experience in data integration meta-data & big data management, building and managing datawarehousing/data marts using Informatica PowerCenter, PowerMart, PowerAnalyzer, Power Exchange and Data Quality IDQ
●Involved in various stages of Software Development Life Cycles (SDLC)
●Knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling
●Expertise in Reusable transformation and Reusable Tasks
●Expert in Database - Greenplum,Oracle 8.x/9i,10g/11g, Netezza, Teradata,DB2, MS SQL Server 2000,SQL and PL/SQL
●Experience in Oracle Data Model, Oracle Designer, Visio and Erwin tools
●Interacted with the Business users, eBusiness team to make critical decisions
●Developed ETL projects, hands on experience with testing and production support in the process of developing and managing the DW.
●Troubleshooting/debugging at different stages in database, workflows and mappings
●Performed Data Validation based on requirements
●Expertise in performance tuning of Informatica workflows, mappings and sessions
●Proficient in UNIX Shell Scripting
●Knowledge of programming languages like C++, VB, ASP,.Net, XML, JAVA, JavaScript, VBScript
●Excellent analytical, problem solving, communication and interpersonal skills, with an ability to interact with individuals at all levels
Technical Skills
Data Warehousing INFORMATICA 5.x/6.x/7.1.1/8.x/9.1.0, POWER EXCHANGE, IDQ, SQL Server 2012 SSIS
Big data technologies Pivotal Gemfire
Databases GREENPLUM,ORACLE 9.x/8.x/10g/11g,NETEZZA,TERADATA,DB2,SQL SERVER 2000/7.0/6.5,SYBASE ASE 12/12.5.3,MS ACCESS
Tools &Reporting MICROSTRATEGY 8x/9x, COGNOS 7.0/6.0, BUSINESS OBJECTS XI/6.0
Data Modeling Tools ERWIN, ORACLE DATA MODEL, ORACLE DESIGNER, VISIO
Programming PostgreSQL, VISUAL BASIC, JAVA, XML, SQL, SQL-PLUS, PL/SQL, Toads
Web Technologies ASP, VBSCRIPT, JAVASCRIPT, HTML, DHTML, CSS
Web Servers JAVA WEB SERVER, MICROSOFT WEB SERVER
Environment WIN 95/98/NT/LINUX
Experience
Senior ETL Specialist
TMG Health PA Mar 2015 – Till Date
Sr ETL Specialist
●Worked with metadata framework for the Greenplum load.
●Used DBI, GPLoad, PSQL, COPY utilities for the GP load using Perl.
●Reverse engineered the Greenplum functions and redesigned them in SSIS for the SQL Server to Gemfire extraction.
●Worked with facets data and analysis of the source data.
●Extracted CDC data from SQL Server and loaded in Pivotal Gemfire.
●Involved in Unit testing and fixes.
●Worked with Scrum methodologies to manage the sprints for the sprint planning and backlogs.
●Using the event listeners the data loaded from Gemfire to Greenplum
Environment: Pivotal Gemfire, Greenplum, SQL Server, SSIS, Perl
Chubb NJ Aug 2014 – Feb 2015
Sr Consultant
●Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
●Worked with stored procedures, transformation rules and targets definitions
●Developed mapping parameters and variables to support SQL override.
●Worked with mappings to load into staging tables and then to Dimensions and Facts.
●Used Debugger to test the mappings and fixed the bugs.
●Developed reusable sessions and Transformations.
●Worked with pre-session variable assignment.
●Interacted with business users to discuss requirements.
●Resolved issues in UAT.
●Extensively used workflow variables, mapping parameters and mapping variables.
●Involved in Unit, Integration, System, and Performance testing levels.
●Modified existing mappings for enhancements of new business requirements.
●Involved in Indexes and Constraints enable and disable.
●Involved in Unit testing and fixes.
Environment: Informatica PowerCenter 9.1, UNIX, Oracle 10i, SQL, PL/SQL, Microstrategy, Control-M.
Ralph Lauren NJ Mar 2012 –Aug 2014
Sr ETL Analyst
●Analyzed the new requirement and designed the new mapping or modifying existing mapping
●Involved in development of full life cycle implementation of data integration using Informatica with sources like Oracle, Teradata and Netezza
●Used Teradata Utilities for the loading using FLoad and Mload
●Extensively used ETL to load data from Flat files-both fixed /Delimited files and relational database
●Closely worked for requirement analysis and in Design of Data modeling structures.
●Developed the mapping to build the hierarchies
●Built complex ETL solutions using Informatica to extract source data from Netezza, flat files and load it into Oracle based EDW (Enterprise Data Warehouse).
●Implemented Joiner, Rank, Lookup, Update Strategy, and Router transformations in mapping
●Created Transformations and Mappings using Designer Tool of Informatica.
●Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
●Developed the UNIX shell scripts to manage the Informatica processes.
●Involved in testing phase for migration in to another environment.
●Performed pre-production activities and involved in documenting of all the test cases, tuning, and enhancements.
●Involved in various projects related to Data Modeling
●Extensively involved in debugging and troubleshooting.
●Used Control-M to kick off the jobs based on Daily, Weekly and Adhoc.
●Resolving Production support bug fixes, production break fixes.
●Responsible for migration between multiple environments like DEV, QA, and Production systems and involved in QA team to resolve the issues.
Environment: Informatica PowerCenter 9, ETL, UNIX, Windows XP,Teradata, Netezza, Erwin, Oracle 10i, SQL, PL/SQL, Microstrategy, Control-M.
WellPoint NY May 2011 –FEB 2012
Sr ETL Developer
●Involved in requirement analysis.
●Extensively used Mapping Designer, Workflow Manager for creating various mappings, sessions, workflows.
●Worked in Teradata as a Enterprise data warehouse.
●Implemented Joiner, Rank, Lookup, Update Strategy, and Router transformations in mapping.
●Worked with IDQ transformations and imported IDQ mapping in to PowerCenter.
●Used Mapplets extensively to design common mapping components.
●Involved in Design, development, unit testing and integration testing of new Informatica jobs.
●Extracted data from legacy systems and put it in the Flat files, DB2 tables for further processing.
●Worked with Informatica mappings to build business rules to load data by using various transformations
●Worked in UNIX environment to run the Informatica workflows.
●Modified the existing Informatica jobs being used, according to latest requirements.
●Resolving application and technical problems of the highest complexity.
●Responsible for coordinating implementation of fixes into the production environment.
Environment: Informatica PowerCenter 8.6.1/9, ETL, UNIX, Windows XP, Teradata, Oracle 10i, SQL, PL/SQL, SQL*Plus, Microstrategy, Tivoli, Toad
Bank of America NJ Nov 2010 – Apr 2011
Sr ETL Developer
●Worked on Change Data Capture on both Source and Target level for SCD (Slowly changing Dimension) Type1, Type 2 and Type 3 for loading historical data and current data into EDW.
●Extracted data from flat files and oracle database, applied business logic to load them in the Oracle database.
●Developed mappings/ Reusable Objects/ Transformation/ mapplets by using mapping designer,
and mapplet designer in Informatica Power Center 8.6.1
●Built complex ETL solutions using Informatica to extract source data from Oracle, SQLServer, flat files and load it into Oracle based EDW (Enterprise Data Warehouse).
●Importing Source/Target Tables from the respective databases and created Reusable Transformations and Mappings using Designer of Informatics.
●Using Joiner transformation for extracting data from multiple sources.
●Defined Target Load Order Plan for loading data into Target Tables.
●Implemented, reviewed the transformation logic in the ETL mappings according to the predefined ETL standards.
●Used filter, key generator, Labeler transformation in IDQ.
●Worked with Address Doctor in Data Quality for getting the valid address.
●Develop new and support existing ETL processes using the Informatica Tool.
●Performance tune databases and SQL statements in connection to ETL code as required
●Performed source system analysis as required.
●Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
●Created deployment groups, migrated the code into different environments.
Environment: Informatica PowerCenter 8.6.1/9, Power Exchange, IDQ, ETL, UNIX, Windows XP,Erwin, Oracle 10i, SQL, PL/SQL, SQL*Plus, Microstrategy, Tivoli, Toad
Campbell USA NJ May 2010 – Aug 2010
Technical Consultant
●Fixed the invalid mappings and troubleshoot the technical problems of the database.
●Created new Informatica mappings to import data from different source tables.
●Worked and developed Informatica Mappings to load data from Source systems to ODS Stage, ODS and then to Data warehouse.
●Involved performance tuning in mapping, session and Database levels.
●Worked in Database testing to check Indexes, Constrains, Stored Procedures, etc.
●Involved in the design aspects and Involved in developing various prototypes and testing them thoroughly.
●Worked on SQL, PL/SQL, Stored Procedure, Unix Shell Scripts.
●Developed the UNIX shell scripts to manage the Informatica processes.
●Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
●Created complex mappings using Connected/Unconnected Lookup, Sorter, Aggregator, dynamic Lookup and Router transformations for populating target table in efficient manner.
●Worked with reusable components such as transformation, Mapplets, lookups etc and reusable objects sources and targets (shared folder) for ETL process.
●Extensively used Mapping Variables, Mapping Parameters, and Parameter.
●Designed and executed Error and Exception handling processes and used Informatica Debugger for failures.
●Extensively worked on Informatica tools like – Designer, Workflow Manager and Repository manager.
●Created complex mappings and also tuned for better performance.
●Designed a Data Validation controls to evaluate the quality of the ETL process using UNIX scripts and ETL Mappings.
●Extensively Involved in Production support activities.
●Managed Flowcharts of Monthly, Daily and Weekly Batches using job scheduler Tivoli.
●Worked with CUSA & ANZ Batches in different Timings.
Environment: Informatica PowerCenter 8.6.1, ETL, UNIX, Windows XP, Oracle 10i, SQL, PL/SQL, SQL*Plus, Microstrategy, Tivoli, Toad
Technical Consultant
Wellington Management MA Feb 2009 – Apr2010
ETL Consultant
●Created new Informatica mappings to import data from different source tables.
●Created/Involved of new queries to support the import of new data.
●Error handling and support of various applications for failed reloads using Teradata MLOAD, BTEQ and Fast Load.
●Involved performance tuning in mapping and session and SQL level.
●Worked on SQL, PL/SQL, Stored Procedure, Unix Shell Scripts
●Developed the UNIX shell scripts to manage the Informatica processes.
●Involved Design, development and implementing the Siebel applications utilizing the Informatica ETL tool.
●Designed reusable components such as transformation, Mapplets, lookups etc and reusable objects sources and targets (shared folder) for ETL process.
●Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
●Designed and executed Error and Exception handling processes and used Informatica Debugger for failures.
●Extensively worked on Informatica tools like – Designer, Workflow Manager and Repository manager.
●Created complex mappings and also tuned for better performance.
●Designed a Data Validation controls to evaluate the quality of the ETL process using UNIX scripts and ETL Mappings.
●Manage Flowcharts for All monthly, Daily and Weekly Job scheduling.
●Involved Break fixes in Informatica Mapping and database level.
●Maintained the all incremental transaction load using Audit table.
●Monitor Production data for daily and monthly loads.
●Performed Warehouse Star Schema and created new extensions to Existing Fact – Dimension tables.
Environment: Informatica PowerCenter 8.1/7.1,Oracle Data model, Teradata, Oracle 9i/10g, XML,AS400, DB2, SQL, PL/SQL, UNIX Shell Scripting, MS SQL Server 2000/2005,Unix Sun Solaris, SQL Navigator/TOAD
Siemens Medical Solutions PA Mar 2008 – Jan 2009
Developer
●Extraction, Transformation and Load was performed using Informatica PowerCenter to build the data warehouse.
●Accomplished automated data extraction from various RDBMS via scripts, ETL processing using Informatica and loading into EMD Data Mart.
●Used data sources like relational, flat files, comma delimited files from SPD and flat files from Contracts and Warranty systems and loaded into the EMD (Oracle database).
●Created complex joiners, transformations of all types as needed to smoothly pass data through ETL maps.
●Developed stored procedures in PL/SQL and Unix Shell Scripts for automated execution of jobs.
●Tuning the PL/SQL code and SQL queries.
●Debugged various PL/SQL stored procedures that validate business rules and billing module exceptions.
●Creating /Running sessions & Batches using Autosys to load the data into the target Database.
●Used Repository Manager to create Repository, User groups, Users and managed users by setting up their privileges and profiles.
●Helped various Business Units resources in writing SQL, Shell scripts and PL/SQL blocks.
●Designed and executed Error and Exception handling processes and used Informatica Debugger for failures.
●Extensively worked on Informatica tools like – Designer, Workflow Manager and Repository manager.
●Created complex mappings and also tuned for better performance.
Assisted the BO reporting team in generating reports.
Environment : Informatica PowerCenter 7.1/6.1, ETL, UNIX (Sun Solaris 2.6), Windows XP, NT 4.0, Sybase ASE 12.5.3,Oracle 8i, SQL, PL/SQL, SQL*Plus, BO XI,Toad
Pitney Bowes CT Jun 2005 – Feb 2008
Developer
●Involved incremental delta load from OLTP database to OLAP data warehouse, Customized Informatica ETL Mappings to correspond to Siebel Extension Tables and Columns.
●Designed and developed Informatica Mappings for SDE and SIL processes using various transformations like Lookup, Joiner, Router, Aggregate, Expression, Source Qualifier, Update Strategy and Filter.
●Performance tuning of the Customized ETL Mappings and Sessions.
●Performed the Incremental ETL process to populate the Data Warehouse
●Performed Gap Analysis on Siebel Vanilla Data Warehouse Star Schema and created new extensions to Existing Fact – Dimension tables.
●Worked on customizing the Activity, Revenue fact groups by adding new columns to the fact, dimension tables
●Worked with the Siebel CRM team for modification of the base tables for adding new extension columns in OLTP
●Designed reusable components such as transformation, Mapplets, lookups etc and reusable objects sources and targets (shared folder) for ETL process.
●Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for capturing delta loads.
●Designed and executed Error and Exception handling processes and used Informatica Debugger for failures.
●Extensively worked on Informatica tools like – Designer, Workflow Manager and Repository manager.
●Created complex mappings and also tuned for better performance.
●Manage Flowcharts for All monthly, Daily and Weekly Job scheduling .
●Used Tivoli for scheduling.
●Involved Break fixes in Informatica Mapping and database level.
●Assisted the BO reporting team in generating reports.
Environment: Informatica Power Center 6.1/5.1, Siebel Data model, Siebel Analytics, Oracle 9.x/8.x, XML, PL/SQL, BO 6.0,UNIX Shell Scripting, MS SQL Server 2000, HP UX, Sun Solaris.
Staples Inc MA Apr 2003 – May 2005
Developer
●Involved in the design aspects and Involved in developing various prototypes and testing them thoroughly.
●Responsible for cleaning the source data, Extract and Transform data with business rules, and built re-usable mappings, known as Mapplets using Informatica PowerCenter Designer.
●Responsible for Databases include Oracle 8i, SQL Server, Access, Excel, flat files etc. Extensively worked on writing shell scripts for scheduling the sessions.
●Worked on calling shell scripts from post-session and pre-session events. Extensively involved in implementing performance tuning techniques for the queries. And worked under support for various existing data marts.
●Worked on installation and configuration of Informatica server and client tools. It includes creating repositories, establishing database connections, registering Informatica PowerCenter servers, server configuration etc.
●Involved in getting requirements from the users and writing specifications for data warehousing/data mart projects.
●Worked on shell scripting to manage various Informatica administrative and development tasks.
●Developed various complex mappings using Informatica PowerCenter.
Environment: Informatica PowerCenter 4.7,Power mart, Oracle 8i, Unix Shell Scripting, PL/SQL Programming, DB2, XML, Windows NT, IBM AIX,MS SQL Server.
IBS Infocom Ltd India Mar 2001 – Feb 2002
Developer
●Coordinated with business analyst team to understand the requirements.
● Produced Technical Design Documents.
● Involved in Data modeling.
● Developed rich user-friendly screens, using Forms, Classes and Modules.
● Developed VB6 Active X DLL components for business processing.
Environment: ASP, Visual Basic 6.0, ActiveX DLL, IIS 5.0, ADO, ODBC and SQL Server 2000
Education
Bachelor of Engineering in Computer Science
Madurai Kamaraj University India