SUMMARY

• Close to SEVEN years of experience of the Information Technology Industry. Involved in full life cycle development including Design, ETL Strategy and troubleshooting. Worked extensively with Health and Financial Domain.
• Skills in Design, Development, Testing and Implementation of various projects using Object Oriented and Multidimensional Analysis.
• Over FIVE years of experience in working with data warehouses and using Informatica PowerCenter 6.1, 7.1, 8.1, 8.6.x, 9.1, 9.5 and Proficient in using Warehouse Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Extensively used complex transformation like Source Qualifier, Lookup, Update Strategy, Router, Aggregator, Sequence Generator, Filter, Expression, Stored Procedure, External Procedure, Transactional Control for Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses using Informatica PowerCenter 9.5.
• Over FOUR years of data modeling experience using Erwin and worked with Dimensional Data Modeling, Star schema/Snowflakes schema, fact and dimension tables.
• Expertise in Extraction, Transformation and Loading the data from various heterogeneous sources like Oracle, MS SQL Server, Sybase, Teradata, IBM DB2, XML and Flat files (Fixed width and Delimited).
• Over SIX years of extensive experience with databases (Oracle 8i/9i/10g, MS SQL Server 2000/2005/2008 , DB2 9.x, Sybase, Teradata, and IBM DB2).
• Extensively worked with SQL, PL/SQL, performance tuning of Oracle procedures.
• Worked with database objects such as View (including Materialized Views), Stored Procedures, Functions, Triggers, Sequence Generator on Oracle.
• Hands on experience on Informatica Power Exchange for loading/retrieving data from mainframe.
• Extensively used TOAD, Oracle SQL Developer, Navigator, SQL*PLUS and SQL*Loader.
• Experienced in tuning Informatica mappings to identify and remove processing bottlenecks.
• Over FOUR years of UNIX shell scripting. Hands on exposure on UNIX environment and experience in using third party scheduling tools like AutoSys.
• Worked with HP ALM (Application Life Cycle Management) to detect and report the defects.
• Proficient knowledge in ETL using SQL Server Integration Services (SSIS).
• Strong skills in data analysis, data requirement analysis and data mapping for ETL processes.
• Ability to prioritize and execute tasks in a high pressure environment.
• Experience in mentoring and providing knowledge transfer to team members, support teams and customers. Reliable, proactive, responsible, hardworking, quick learner and good team player.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x, Informatica Power Exchange, DataStage, SSIS.

BI Tools: Cognos BI Suit, SSRS, Business Objects 6.5.

Databases: Oracle 8i/9i /10g/11g, MS SQL Server 2005/2008, Sybase, Teradata, IBM DB2, Sybase.

Database Skills: Functions, Views, Cursors, Stored Procedures, Triggers, and Packages.

Client Side Skills: PL/SQL, SQL, T - SQL, UNIX shell scripting, Java, C, C++, HTML, XML, CSS, JavaScript.

OS: Windows 2000/2003/Windows 7/XP/Vista, UNIX/Solaris, Red Hat Linux, AIX.

Version Control: Harvest, Visual Source Safe 6.0, CVS.

Methodologies: Scrum, Agile, Data Modeling Logical / Physical, Star/ Snowflake Schema, FACT & Dimension Tables, ETL, OLAP, RUP, Software Development Life Cycle (SDLC).

Design/Process: UML.

Tools: Toad, SQL Developer, Erwin, MS Project, Test Director, AutoSys, MS Visio, HP Application Life Cycle Management.

PROFESSIONAL EXPERIENCE

Confidential, White Plains, NY

ETL Developer - Informatica

Responsibilities:

• Involved in the designing of Dimensional Model and created Star Schema using Erwin.
• Worked with Data Analyst and Data Modeler to design and to understand the structures of dimensions and fact tables and Business Requirement Documents.
• Worked extensively on Informatica designer to design a robust end-to-end ETL process involving complex transformation like Source Qualifier, Lookup, Update Strategy, Router, Aggregator, Sequence Generator, Filter, Expression, Stored Procedure, External Procedure, Transactional Control for the efficient extraction, transformation and loading of the data to the staging and then to the Data Mart (Data Warehouse) checking the complex logics for computing the facts.
• Prepared and used the reusable transformation, mappings and codes using Mapplets for faster development and standardization.
• Used reusable Session for different level of workflows.
• Involved in Performance Tuning in Informatica for source, transformation, targets, mapping and session.
• Used variables and parameters files for the mapping and session so that Mappings can migrate easily in different environment and database.
• Implemented Slowly Changing Dimensions Type-1, Type-2 approach for loading the target tables.
• Designed various tasks using Informatica workflow manager like session, command, email, event raise, event wait and so on.
• Worked with Mainframe systems to handle COBOL files.
• Used FTP and NDM and JMS protocols to handle FLAT files with Mainframe server
• Design the architecture for production support in order to scheduling the tasks (without any manual intervention) using UNIX Shell Scripting.
• Used UNIX Command and UNIX Shell Scripting to interact with the server and to move flat files and to load the files in the server.
• Performed file archiving using UNIX Shell Scripting.
• Involved in resolving the issues related with the migration of designs from Dev Server to Prod Server and also helped in resolving issue related to the production support of the Data Warehouse.
• Wrote complex SQL queries PL/SQL function, procedure, packages, cursor and triggers to retrieve the data from sources system and to count and validate the data and data set.
• Perform Unit testing by writing simple test scripts in the database and involved in integration testing and minus SQL script comparing from source to target.
• Interacting with User Groups/ Corporate Testing Groups/Business People.

Environment: Informatica Power Center 8.6.1/9.5, Oracle 10g/11g RAC, DB2 9.7.9, Vertica, SQL, PL/SQL, TOAD 11, TOAD for DB2 5.2, Informatica Power Exchange, TOAD for Data Modelers, Mainframe for COBOL, Tectia SSH terminal and F-Secure Shell, UNIX Shell Scripting, HP ALM, Harvest.

Confidential, St Louis, MO

ETL Developer - Informatica

Responsibilities:

• Worked with architect, business managers to understand the requirement and source system in order to prepare design documents specifying the various ETL approaches, pros and cons of the different approaches with suggestion of the best approach.
• Worked with Mainframe systems.
• Used FTP and NDM protocols to handle FLAT files with Mainframe server
• Design the architecture for production support in order to scheduling the tasks (without any manual intervention) using UNIX Shell Scripting.
• Used UNIX Command and UNIX Shell Scripting to interact with the server and to move flat files and to load the files in the server.
• Performed file archiving using UNIX Shell Scripting.
• Extensively worked with Data Analyst and Data Modeler to design and to understand the structures of dimensions and fact tables and Technical Specification Document.
• Worked extensively on Informatica designer to design a robust end-to-end ETL process involving complex transformation like Source Qualifier, Lookup, Update Strategy, Router, Aggregator, Sequence Generator, Filter, Expression, Stored Procedure, External Procedure, Transactional Control for the efficient extraction, transformation and loading of the data to the staging and then to the Data Mart (Data Warehouse) checking the complex logics for computing the facts.
• Extensively used the reusable transformation, mappings and codes using Mapplets for faster development and standardization.
• Involved in Performance Tuning in Informatica for source, transformation, targets, mapping and session.
• Created variables and parameters files for the mapping and session so that it can migrate easily in different environment and database.
• Implemented Slowly Changing Dimensions Type-1, Type-2 approach for loading the target tables.
• Designed various tasks using Informatica workflow manager like session, command, email, event raise, event wait and so on.
• Involved in resolving the issues related with the migration of designs from Dev Server to Prod Server and also helped in resolving issue related to the production support of the Data Warehouse.
• Wrote complex SQL queries PL/SQL function, procedure, packages, cursor and triggers to retrieve the data from sources system and to count and validate the data and data set.
• Perform Unit testing by writing simple test scripts in the database and involved in integration testing and minus SQL script comparing from source to target.
• Worked with Informatica Power Exchange and Informatica power Studio for connecting mainframe systems.

Environment: Informatica Power Center 9.5, Oracle 11g RAC, SQL, PL/SQL, TOAD 11, SQL Developer, Informatica Power Exchange, Toad for Data Modelers, Mainframe for COBOL, Putty, UNIX Shell Scripting, HP ALM, Harvest.

Confidential, Pittsburgh, PA

ETL Developer - Informatica

Responsibilities:

• Worked with architect, business managers to understand the requirement and source system in order to prepare design documents specifying the various ETL approaches, pros and cons of the different approaches with suggestion of the best approach.
• Involved in the designing of Dimensional Model and created Star Schema using E/R studio.
• Extensively worked with Data Analyst and Data Modeler to design and to understand the structures of dimensions and fact tables and Technical Specification Document.
• Worked extensively on Informatica designer to design a robust end-to-end ETL process involving complex transformation like Source Qualifier, Lookup, Update Strategy, Router, Aggregator, Sequence Generator, Filter, Expression, Stored Procedure, External Procedure, Transactional Control for the efficient extraction, transformation and loading of the data to the staging and then to the Data Mart (Data Warehouse) checking the complex logics for computing the facts.
• Extensively used the reusable transformation, mappings and codes using Mapplets for faster development and standardization.
• Involved in Performance Tuning in Informatica for source, transformation, targets, mapping and session.
• Created variables and parameters files for the mapping and session so that it can migrate easily in different environment and database.
• Implemented Slowly Changing Dimensions Type-1, Type-2 approach for loading the target tables.
• Designed various tasks using Informatica workflow manager like session, command, email, event raise, event wait and so on.
• Worked with Mainframe systems to handle COBOL files.
• Used FTP and NDM protocols to handle FLAT files with Mainframe server
• Design the architecture for production support in order to scheduling the tasks (without any manual intervention) using UNIX Shell Scripting.
• Used UNIX Command and UNIX Shell Scripting to interact with the server and to move flat files and to load the files in the server.
• Wrote complex SQL queries PL/SQL function, procedure, packages, cursor and triggers to retrieve the data from sources system and to count and validate the data and data set.
• Perform Unit testing by writing simple test scripts in the database and involved in System integration testing and minus SQL script comparing from source to target.
• Worked with Informatica Power Exchange for connecting mainframe systems.

Environment: Informatica Power Center 8.6.1/9.5, Oracle 10g/11g RAC, SQL, PL/SQL, TOAD 11, SQL Developer, Informatica Power Exchange, TOAD for Data Modelers, Mainframe for COBOL, F-Secure Shell, UNIX Shell Scripting, HP ALM, Harvest.

Confidential, New York, NY

ETL Developer - Informatica

Responsibilities:

• Involved in the designing of Dimensional Model and created Star Schema using E/R studio.
• Extensively worked with Data Analyst and Data Modeler to design and to understand the structures of dimensions and fact tables and Technical Specification Document.
• Worked extensively on Informatica designer to design a robust end-to-end ETL process involving complex transformation like Source Qualifier, Lookup, Update Strategy, Router, Aggregator, Sequence Generator, Filter, Expression, Stored Procedure, External Procedure, Transactional Control for the efficient extraction, transformation and loading of the data to the staging and then to the Data Mart (Data Warehouse) checking the complex logics for computing the facts.
• Worked on the HIPAA 4010 transactions and HIPAA 5010 transactions as the source data like 837,837P, 835, 277,276 and more.
• Involved in analyzing the ICD 9 and ICD 10 for the data mapping from ICD 9 - ICD 10 and ICD 10 - ICD 9 in source and target level.
• Implemented Slowly Changing Dimensions Type-1, Type-2 approach for loading the target tables.
• Perform Unit testing by writing simple test scripts in the database and involved in integration testing and minus SQL script comparing from source to target.

Environment: Informatica Power Center 8.6/9.1, Oracle 10g/11g RAC, E/R Studio XE2, SQL, PL/SQL, Informatica Power Exchange, TOAD 9.7, UNIX Shell Scripting, Business Objects XIII, Win Runner.

Confidential

ETL Developer - Informatica

Responsibilities:

• Worked extensively in full System Development Life Cycle like participating in requirement gathering, business analysis, user meeting.
• Involved in ICD-9 4010 data analyzing with data analyst to define the structure of dimension and facts.
• Involved on various HIPAA claims validation and verification process to understand the source data.
• Used Informatica PowerCenter as an ETL to extract data from source like MS SQL Server, Flat files, Oracle, DB2 and loaded to target.
• Extensively used different transformations like Lookup, Joiner, Aggregator, Filter, Sorter, Expression, Update Strategy, Source Qualifier, Rank, Router to create several mapping and mapplets.
• Implemented Slowly Changing Dimension phenomenon Type-1, Type-2 using Informatica ETL mapping.
• Extensively used complex SQL queries to unit test the system and to test the existing project also used to validate the data in data warehouse.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g, SQL Server 2005, flat files, DB2, Teradata, Erwin R7, SQL, PL/SQL, SQL*PLUS, Shell Scripting, Micro Strategy 8.0, UNIX System.

Confidential

ETL Developer - Informatica

Responsibilities:

• Involved in handling and selecting heterogeneous data sources like Oracle, DB2, SQL server and Flat Files.
• Worked extensively in translation of business requirements into data warehouse design and developed ETL logic based on the requirement using Informatica PowerCenter 8.1.
• Contributed in logical and physical design of dimensional modeling and created 3rd Normal Snowflakes Schema.
• Extensively worked with all the client components of Informatica like Repository Manger, Designer, Workflow Manger, workflow Monitor.
• Developed ETL design using various transformations like Source Qualifier, Aggregator, Sorter, Joiner, Lookup, Stored Procedure, Router, Filter, Transaction Control, Sequence Generator, Expression, JAVA, and XML as per necessity for source-to-target data mappings and to load the target table.
• Worked with store procedure and packages in PL/SQL and UNIX Shell Scripting for automated execution of the job in the production environment.

Environment: Informatica PowerCenter 8.1.1, Oracle 9i, Flat Files, DB2, MS SQL Server 2005, Erwin, Oracle Designer, PL/SQL, UNIX Shell Scripting, TOAD 7.0, pmcmd command script, Micro strategy 7.0, SSRS.