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

Contact this candidate