Summary
DW ETL Informatica Consultant



6+ years of total IT experience in the Analysis, Design, Development, Testing, Implementation and Production Support for various industries using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server and Web applications on Windows and Unix platforms in various verticals like Healthcare, Banking, Cruise lines and retail.
Well versed with various Informatica transformations and implemented number of complex mappings.
Hand s on experience in creating Informatica mappings, transformations, sessions and workflows to extract data from various sources and load into targets and proficient in creating workflows/ worklets and Mappings/Mapplets.
Data Modeling knowledge using Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.
Strong Experience in data analysis and reporting tool Business Objects, Crystal Reports, Cognos Series used for financial/business decisions, Strong Experience in Data Modeling, Data mart, Building Cubes and OLAP for business analysis using star and snowflake schema, for faster and effective querying.
experience experience in design and development of decision support systems DSS
Involved in Unit Testing, Integration testing and Performance Testing.
Proficient in designing, modeling, creating, maintaining and integrating databases like Oracle, DB2, Teradata, Sql Server, Sybase, Access.
Excellent skills in writing PL/SQL Stored Procedures, Functions, Triggers, Packages and Fine-Tuning them.
Knowledge on DBA activities like Performance Tuning, Backup and Recovery.
Good knowledge and experience in Developing UNIX Shell Scripts and scheduling Shell scripts by using scheduling tools.
Self-motivated, creative team player with effective communication and Leadership qualities.

Employment

January, 2008 -  Present
ETL Informatica Developer

PROJECT : Developing Sales Data Warehouse
MVP is 1 of the America s best healthcare companies which has a continued growth and success. The project involves developing a sales Data warehouse which collects data related to medical samples provided to the doctors, its feedback and analyzing the data for those samples.

Responsibilities : Requirement gathering and Business Analysis.
Played a key role in designing the application that would migrate the existing data into Annuity warehouse effectively by using Informatica Power Center.
Data modeling and design of for data warehouse and data marts in star schema methodology with conformed and granular dimensions and FACT tables.
Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
Created and managed the local repositories and permissions using Repository Manager in Oracle Database and Created users and groups and assigned privileges using Repository Manager.
Involved in the creation of Fact Tables and Cubes Dimensions and Measures.
Implemented Join, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter and Router Transformations.
Moving mapping and sessions from development to production environment.
Created Schema objects like Indexes, Views and Sequences.
Created Tasks, Workflows and Worklets using Workflow Manager. Monitoring of Workflows and Worklets using Workflow Monitor.
Tuned mappings for improving performance.
Tuned performance of Informatica sessions for large data files by increasing block size, data cache size and, sequence buffer length.
Automated load run on Informatica sessions through UNIX Corn, PL/SQL scripts and implemented pre and post-session scripts, automated load failures with successful notification through email
Involved in Working with Business Objects Supervisor for creating repository, creating and managing the universes, creating categories, creating and managing the users, giving access permissions for Business Objects Reports.

Environment : Informatica Power Center 8.1/7.1.4, SQL Server 2000 Query Analyzer, DTS, TSQL, Oracle 10g, 9i, PL/SQL, SQL, TOAD 8.5, Business Objects 6.5, Perl script, Sun Solaris 2.7.

February, 2007 -  December, 2007
ETL Informatica Developer

PROJECT : Data Modeling
Bank of America is 1 of the leading financial services companies for individuals, small businesses and commercial, corporate and institutional clients across the United States and around the world.

The project involved extracting, transforming and loading of institutional and personal loan data from different regions for business analysis on quarterly and monthly basis. The data is consolidated into the data mart which is used for the report generation.

Responsibilities : Analysis of Source, Requirements, existing OLTP system and identification of required dimensions and facts from the Database.
Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin or Star Schema.
Created the physical and logical design using ERWIN 3.5.
analyzed Ralph-Kimball Methodology and implemented it successfully.
Designed and built Datamarts by using Star Schema s.
Designed the Dimensional Model of the Data Warehouse Confirmation of source data layouts and needs
Designed and Implemented ETL architecture with Informatica tool.
Responsible for developing, support and maintenance for the ETL Extract, Transform and Load processes using Informatica Power Center.
Parsing high-level design specification to simple ETL coding and mapping standards.
Designed new database tables to meet business information needs. Designed Mapping document which is a guideline to ETL Coding.
used Informatica to load data from Flat files to Oracle, Oracle to Flat Files and Oracle to Oracle.
Created mappings using the transformations like Source qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner and Stored Procedure transformations.
Created reusable transformations and Mapplets and used them in complex mappings.
Using Informatica designer designed worked on Views, Stored Procedures, Triggers and SQL queries and for loading the data staging.
Migrated mappings from Development to Testing and from Testing to Production.
Performed Unit Testing and tuned for better performance.
Used Cognos to generate Business reports for the end users.
Environment : Informatica Power Center 7.1/6.2, SQL Server 2000 Query Analyzer, DTS, TSQL, Oracle 9i, PL/SQL, SQL* Loader, TOAD, Business Objects 6.0, Sun Solaris 2.7.

January, 2006 -  January, 2007
ETL Informatica Developer

PROJECT : ODS and
EDW-CMA Consumer Management Analytics

Royal Caribbean Cruises Ltd is the world's second-largest cruise line company. RCCL main purpose of building data warehouse to help marketing department to do analysis of Sales based on Region, Product and Campaign Promotions which helps them to target future customers.

Responsibilities : Participated in all phases, Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation.
Used REMEDY Problem/Change Management Tool, followed CMP and PMP.

Developed mapping, workflows using Informatica Power Center 8.1. Executed Informatica Workflows, to load data from Legacy systems ex. AS/400 Oracle, Flat Files and Access databases onto the target oracle 9i.
Follow the RCCL standard for Designing, Development, Testing and Migration of objects like PL/SQL Code, ETL mappings, UNIX scripts.
Reverse engineered to debug the existing mapping to fix production issues.

Responsible for Creating Source object documents and Implementation plan related to particular Problem ticket.
Designed and developed mappings that included Source Qualifier, Aggregator, Connected and Unconnected Lookup, Expression and Update Strategy.
worked on ODS operational data source and CMA Consumer Management Analytics data mart.

Developed shell scripts, Perl scripts that runs SQL scripts from in it. Fixing invalid mappings, testing of stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
Have written Test cases and expected results to help the testing team to validate the mapping in the Test environment.
Designed and developed multiple Business Objects Universes and calculated objects for reporting.
Reports were formatted to the users according to the user requirements using Business Objects features like Slice and Dice and Drill Down.

Environment : Informatica Power Center 5.1, Oracle 8i, Datamodelling, Erwin 3.5, Cognos Impromptu and Power Play 6.6, TOAD, UNIX Shell Scripting, SQL, PL/SQL, SQL * Loader, Windows NT 4.0

Info Technology solutions, India

August, 2004 -  December, 2005
DW Informatica Developer

PROJECT : PAYROLL SYSTEM

Payroll is client-server application. The project aims to develop a powerful tool which will calculate yearly, monthly and weakly salary of employees. It can store all the information of company employees. This software is flexible such that any change in data or rule over a period of time does not impact on working of the project ; instead a small change is required to refine it.

Responsibilities : Analysis, Requirements gathering, function/technical specification, development, deploying and testing.
Involved in the Design, Development, Testing phases of Data warehouse
Logical and Physical Database Layout Design using ERwin.
Involved in Design and Data Modeling using Star schema.
Created Informatica mappings for initial load and daily updates.

Involved in fixing invalid mappings, testing of store procedures and functions, unit and integration testing of Informatica Mappings, Sessions, Workflows and the target data.
Developed several mappings to load data from multiple sources to data warehouse.
Developed, tested Store procedures, Functions and packages in PL/SQL for Data ETL
Performed Data conversions.
Involved in troubleshooting the load failure cases, database problems.
Extensively used mapping parameters, mapping variables and parameter files.
Informatica Metadata Reporter installation and Configuration
Generated Reports using Metadata Reporter
Customization of Informatica Metadata Reporter.

Environment : Informatica Power Center 6.x, Cognos 6.x, Oracle 8i, Erwin, UNIX Shell Scripts, TOAD, SQL * Loader, Windows NT.

February, 2003 -  July, 2004
Data Warehouse/ Informatica ETL Developer

PROJECT : Developing Housing Loans Data Warehouse

HDFC is the biggest housing finance institutions in India. This project aimed to develop a central Data warehouse to stage the Personal loans and housing loans data. This involved integrating 2 different data marts into 1 warehouse .I participated in full Data warehouse design and development, deployment, ETL process using Informatica and deploying Business Objects Suite for reporting purposes.

Responsibilities : Analyzed the systems, architecture, met with end users and business units in order to define the requirements.
Involved in the requirement definition and analysis in support of Data Warehousing efforts.
Developed ETL mappings, transformations using Informatica Power Center 6.x used Informatica tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Implemented various Informatica transformations like Expression, filter, Aggregator, Router, Ranker, update strategy, joiner, Lookup, Sequence generator, stored procedure and Source Qualifier. To load the data from Staging area to DW
Developed data Mappings between source systems and warehouse components using Mapping Designer and involved in the Performance Tuning.
Created and ran sessions and workflows using Workflow Manager.
Monitored the sessions and workflows using Workflow Monitor.
Trouble shooting of connectivity problems. Looked up and read session, event and error logs for troubleshooting and helped in generating reports using Cognos Power play.

Environment : Oracle 8i, Informatica 5.1, Micro strategy 7.1, PL/SQL, ERWin, TOAD 7.3 and Windows-NT, UNIX.

BIRLA SOFT, INDIA.

March, 2002 -  January, 2003
Oracle Developer

Education

Skills
Data Warehousing Informatica Power Center 8. x/7. x/6. x/5 .x, Power Mart 5.1/6.1. Dimensional Data Modeling Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 4.5/4.0/3.5/3.2. BI Tools Business Objects 6.5/6.0/5.1/5.0, Seagate Crystal Reports 8.0, Data Reports, Cognos Series 7.0/6.0, Access Reports Languages SQL, PL/SQL, C, COBOL, JAVA, C++ Databases Oracle 10g/9i/8i/8.0/7 .x, IBM DB2 UDB 8.0/7.0, Sql Server 2000/7.0/6.0, Tera data V2R5/V2R4/V2R3, Sybase 12. x/11 .x, Access. Database Tools SQL * Loader, Query Builder, Toad, SQL* plus. Web Tools : HTML, XML, JavaScript, VBScript, ASP Operating Systems Microsoft XP/2000/NT/98/95, Unix, Sun Solaris 5, Linux 4 PROFESSIONAL EXPERIENCE :. PROJECT : Shipping Information System The system is a general liner-shipping package which is designed to support a wide range of activities performed by liner shipping agents and by branch or regional offices. The main activities supported by the package include booking, container tracking, preparation of shipping documentation, registration of special freight arrangement, calculation of applicable charges, invoicing, general ledger, accounts receivable, marketing facilities and sales statistics. Responsibilities : Involved in system study, development and implementation of the project. Servlets coded to act as Controllers and Dispatchers between JSP and Beans. Developed several PL/SQL stored procedures, packages and triggers. Developed GUI using HTML and JSP for dynamic page generation. Designed and developed dynamic menus using DHTML and CSS. used JavaScript for Server-side and for client-side validations. Involved in unit and integration Testing. Environment : SQL *Plus, Oracle8.3, PL/SQL, JSP, JDBC, Servlets, SQL*Loader, Shell Scripting, UNIX, HTML.