Profile

• Eight(8) years of strong working experience in Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL).
• Eight(8) years of strong experience in Data warehousing and ETL using Informatica Power Center/Power Mart 8.6.1/7.1/7.0/6.2/6.1/5.1 Informatica Power connect for ERP/Mainframes, Mappings, Mapplets and Transformations, Peoplesoft EPM.
• Four(4) years of experience in Requirements gathering, Analysis, Data Modeling and, Dimensional Database modeling, Star Join Schema modeling, Snowflake modeling, FACT tables, Dimension tables, OLAP.
• Worked in the entire Full life cycle of ETL in a DataWarehousing and non-DataWarehousing environments, that include requirement gathering, design the ETL architecture, creating templates, training, consulting, development, deployment, maintenance, support etc.
• Two years experience using Business Objects 6.5/5.1, Cognos and Crystal Reports. Hands on experience on Cognos Reportnet1.1 BI tool
• Extensive Experience using Oracle 11g/10i/9i/8i/7.x, Developer 2000, PL/SQL, UNIX Shell Scripting (K Shell, Bourne Shell, BASH), SQL*Plus, SQL*Loader, MS SQL Server 2000/7.0/6.5, MS Access 7.0/2000/2002, DB2, Teradata, Sybase 12.0/11.x/10, SQL, ISQL, TSQL, Perl, Win 3.x/95/98/2000, Win NT 4.0 and Sun Solaris 2.x, AIX, HP-UX., Erwin, Toad, SQL Programmer.
• Good Understanding of the Relational database concepts.
• Team player, excellent interpersonal skills and self-starter, capable of working independently and motivate a team of professional.
• MBA & BS

Data Warehousing

Informatica PowerCenter/PowerMart 8.6.1/7.1/6.2/6.1/5.2/5.1 Informatica PowerConnect, Informatica PowerAnalyzer, Data Mining, Datamart, OLAP, ROLAP, MOLAP, OLTP, SQL*Plus, SQL*Loader, Peoplesoft 8.8 EPM (Enterprise Warehouse, Financials Warehouse, HRMS Warehouse, Supply Chain Warehouse)

Programming

Unix Shell Scripting, SQL, PL/SQL, C, Java 1.1, HTML, PERL, COBOL

BI Tools

Reportnet1.0MR1, Cognos Connection, Query Studio, Content Manager, Frame Work Manager, Cognos EP Series Impromptu, Cognos Power play, Cognos Transformer, Cognos Scheduler, Cognos Script Editor, Macros, Upfront IWR, Report Administration, Power Play Web

GUI

Developer 2000, Designer 2000, Visual Basic 5.0

Databases

Oracle 11i/10i/9i/8i/7.x, MS Access 7.0/’97, DB2, dBase III+, FoxPro 2.0

Tools

PS/Query, SQR, N/Vision, SQL*Tools, Crystal Reports 7.0/6.0, Developer/2000 (Forms 5.0, Reports 3.0)

Environment

Sun Solaris, Sun OS, HP-UX, Novell 3.11, MS-DOS 6.22, Windows 95/98, Win NT 4.0, IBM-Compatibles.

Professional Summary –

Confidential, PA Oct’07 – Tilldate
Sr.DW Informatica Developer

Highmark is one of the largest health insurance companies in the United States, Highmark found it needed ways to understand its cost drivers better so that it could hold the line on premium increases—thereby retaining customers, enhancing its competitive position and protecting its financial strength. High mark has three data warehouses running within the enterprise to support the business needs of individual organizations.

Responsibilities:

• Worked with Business Analyst in gathering the requirements and prepared Source to Target Mappings which is helpful in designing and developing Enterprise Information Store.
• Prepared Design Documents which is helpful in Analyzing how data got migrated from OLTP to EDW for production support.
• Extensively interacted with user for requirement gathering, prototyping and prepared various documents like Interface Requirement Document, Customer Requirement document, Integration test plan, Unit test plan, Release notes etc.
• Extracted data from Teradata, Oracle and Flat Files using Informatica Powercenter 8.6.1/8.1.1 and loaded it into TeraData.
• Wrote Unix Shell scripts and made Cron entries to kick off ETL jobs
• Written Oracle stored procedures as per the business requirements.
• Involved in creation of Projects for informatica Data explorer(IDE).
• Extensively performed column profiling, single table profiling, cross table profiling using informatica data explorer(IDE).
• Experience in using Defect tracking system to resolve issues on time.
• Worked with Task developer extensively in creating Reusable Sessions and created task such as email.
• Experience in using RUP in the Project life cycle for timely delivery.
• Design and development of Reporting System using Cognos 6.1/7.0.
• Worked on Cognos Report net as per the requirement of the client for detailed reporting from cubes.
• Implemented various Performance Tuning techniques in Informatica.
• Involved in doing Error Handling using session logs and workflow logs.
• Migrated developed mapping objects from one folder to other folder in DEV using Import Export facility, from Dev to QA and to Prod Repositories by creating labels.
• Created Test Plans and written test cases while doing Unit Testing, Integration Testing and worked with QA team in getting tested the code in QA Repository.

Environment:Informatica Powercenter 8.1.1,Oracle 10g, Flat Files, TeraData 12.0(V2R12), Cognos 8.3, UNIX, Erwin, SQL Assistant, BTEQ, SQl Navigator, SQL Plus, Windows XP Professional

Confidential,NJ May’06 – Sep’06
Sr.DW Informatica Developer

AT&T Inc. is the largest communications holding company in the United States and worldwide. Operating globally under the AT&T brand, AT&T is recognized as the leading worldwide provider of IP-based communications services to businesses and the leading U.S. provider of wireless, high speed Internet access, local and long distance voice, and directory publishing and advertising services.
Amdocs has implemented e-bill system for AT&T, this system maintains billing system for the enterprise level clients.This system classified the clients into different categories for easy maintenance. Data is loaded into this system using ETL

• Responsible for support ,maintenance and enhancements of the ETL for e-bill system.
• Configure Power Center 7.1/6.2 on Client (windows) for Development, Test and Production Environments.
• Worked extensively on Informatica Powercenter, Informatica Power connect for SAP, Workflow manager and Workflow Monitor.
• Extensively worked on the performance tuning of the Informatica PowerCenter mappings as well as tuning of the sessions.
• Resolving the tickets opened by the clients for the discrepencies existing in the billing system. Extensively involved with Data Modeling team to create FACT and Dimension
• Extensively used TeraData Utilities (T-Pump, M-Load, and F-Load) to load large volumes of data in to EDW.
• Created mappings using Informatica tools- Warehouse designer, Mapping and Mapplet Designer, Transformations, Informatica Repository Manager
• Extensively used the Lookup connected and Unconnected, Stored procedure, Joiner, Union, Router, Update strategy Transformations.
• Wrote PL/SQL Stored Procedures, SQL scripts and calling at pre and post session.
• Created tasks, workflows, sessions to move the data at specific intervals on demand using Workflow Manager and Workflow Monitor.
• Extensively used different transformations available in Informatica Such as Source Qualifier, Aggregator, Expression, Joiner, Union, Router, Filter, Lookup, and Normalizer while developing the mappings.
• Wrote SQL and PL/Sql scripts, Procedures, Triggers, View and Functions
• Responsible for Moving code to TEST, QA and PROD
• Fine tuning of the SQL’s in the ETL, for faster & effective processing time.
• Interaction with the team members in Isreal for co-ordination of the activities.

Environment: Informatica Power Center 7.1/6.2, Oracle 9i, PL/SQL, Erwin, MS Visio, Unix Shell Scripting, SQL Navigator 4.0, TOAD 7.5

Confidential,Hoboken,NJ May’05 - Apr’06

Marsh,one of the leading risk & insurance services firmprovides global risk management, insurance broking, insurance program management services for businesses, public entities, professional services and private clients in all over100 countries.
ECP which stands for European Client Profitability, isdesigned for the purpose of estimating profits of the clients which are based in Europe.

• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Analysis of Source Requirements, existing OLTP system and Identification of required dimensions and facts from the Database.
• Developed a system design document from Business User requirements.
• Worked on Informatica Power Center 7.1/6.2 tool -Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, Transformations, Work Flow Manager (Task Developer, Worklets, and Work Flow Designer) and Work Flow Monitor.
• Improved performance of mappings and sessions.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Normalizer, Filter, Update Strategy and Joiner transformations.
• Worked on scheduling a batch of ETL’s in an automated Perl process called Process Monitor, which has check points after every step the ETL does.
• Fine tuning of the SQL’s in the ETL, for faster & effective processing time.
• Interaction with the team members in Europe for co-ordination of the activities.

Environment: Informatica Power Center 7.1/6.2, Oracle 9i, PL/SQL, Unix Shell Scripting, SQL Navigator 4.0, TOAD 7.5

Confidential,NY Nov’04 - Apr’05

Forest Labs is one of the largest Pharma companies, which develops, manufactures and markets innovative health care products and services from prevention and diagnosis to treatment and cure. The project involves developing a Data warehouse which collects data related to medical samples provided to the doctors, its feedback and finally analyzing the data for those samples.

Responsibilities:

• Extensively used Informatica to load data from COBOL to Oracle, Flat Files to Oracle, and Oracle to Flat Files & Oracle to Oracle.
• Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Created Common objects for the ETL team to maintain the Common Code.
• Configure Power Center 7.1/6.2 on Client (windows) for Development, Test and Production Environments.
• Extensively worked on the performance tuning of the Informatica PowerCenter mappings as well as tuning of the sessions.
• Wrote PL/SQL Stored Procedures, SQL scripts and calling at pre and post session.
• Created tasks, workflows, sessions to move the data at specific intervals on demand using Workflow Manager and Workflow Monitor.
• Understand the business needs and implement the same into a functional database design.
• Worked on framework manager to import the new or customized tables from source.
• Created a new model using Framework manager with all the Calculations & Filters.
• Designed & Developed the reports for the Financial & HR Datawarehouse
• Developed cubes in Transformer & drill through to reports in Reportnet.

Environment: Informatica Power Center 7.1/6.2, Oracle 9i, PL/SQL, Erwin, MS Visio, Unix Shell Scripting, MS PowerPoint, Cognos Reportnet1.1, SQL Navigator 4.0, TOAD 7.5

Confidential,Virginia Apr’04 – Oct’04
DW Informatica Developer

Responsibilities:

• Participated in all phases of SDLC including Requirement Analysis, Client Interaction, Coding, Testing and Documentation.
• Provided Data Modeling expertise in the creation of a Star Schema Data Warehouse
• Utilized Star Schema to develop facts, dimensions, reference, and code tables in a multi fact - multi dimensional Data Mart.
• Worked extensively on Informatica Powercenter, Informatica Power connect for SAP, Workflow manager and Workflow Monitor.
• Loaded target data warehouse in Teradata.
• Performed complex queries using Teradata Queryman and worked on Winddi.
• Performed a conversion from IBM legacy to oracle 9i.
• Created Workflows, Tasks, database connections, FTP connections using Workflow Manager.
• Written UNIX shell scripts to invoke Informatica Workflows and sessions.
• Scheduled Informatica Workflows and sessions using Autosys.
• Monitored transformation processes using Informatica 6.2 Workflow monitor.
• Created different transformations for loading the data into targets like Source Qualifier, Aggregator, Joiner, Cached and Uncached lookups, Connected and Unconnected lookups, Filter, Router, Expression, Normalizer, Sequence generator. Etc
• Creating Informatica mappings to build business rules to load data.
• Working on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.

Environment: Informatica Power Center 5.1, PowerMart 4.7, Power Connect for SAP, Work Flow Manager, Work Flow Monitor, Teradata V2, Queryman 6.0, BTEQ, DB2, Multiload, SAP GUI, Oracle 9i/8i,SQL Server, Sybase, Windows NT, Unix Sun 280,Erwin, Toad, Excel and Unix Shell Scripting, Perl, Crystal Reports.