Summary:

• Eight years of versatile experience as a Data Warehousing consultant
• Commendable contributions towards Data Integration Projects.
• Owned the responsibilities of defining Base line Architecuture, design documents and data standards.
• Expert knowledge in Data Warehouse applications, involved in the Extraction, Transformation Loading of data from multiple sources into Data Warehouse Using Informatica PowerCenter 9.1/8.x/7.1 and Power Exchange 8.x/5.x.
• Team lead experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing, Production support and Documentation
• Experienced with reporting and data modeling tools of Cognos like Cognos 8, ReportNet Query Studio, Report Studio, Cognos Planning , Congas EP Series Impromptu, PowerPlay, Transformer, Access Manager, Upfront, IWR, PPES, and Visualizer .
• Fine-tuned catalogs and cubes to optimize performance.
• Created and managed reports in zero-footprint environment using Cognos ReportNet
• Administered security using Access Manager among Cognos applications.
• Published reports to Upfront using PowerPlay Enterprise Server and IWR.
• Provided extensive End-User Training and Support for Cognos Tools
• Proficient in writing UNIX shell scripts.
• Technical expertise in Application Performance Tuning
• Expert knowledge in SQL, PL/SQL, Procedures/Functions, Triggers and Packages experience and more than four years as Oracle 7x, 8i / 9i/10g of Oracle Database designer experience.
• Catalogued projects from conceptual phase to go-live phase by utilizing Technical and Project Management skills.
• Excellent communication and interpersonal skills.

SKILLS:

ETL Tools: Informatica Power Center 9.1/8.x/7.x, Power Exchange 8.x/5.2, B2B Data Exchange.

BI Tools: Cognos -10/8/, Cognos 7 Series, Transformer/Powerplay 7, OFA, Hyperion 11

DATA MODELING: ERWIN 4.0/3.X

RDBMS: ORACLE 10.x/9i/8i, SQL SERVER 2008/2005

O / S: RED HAT LINUX 5.0, UNIX SOLARIS8, AIX WINDOWS NT/2000

Data Quality: First Logic IQI, Oracle DQI

LANGUAGES: PL/SQL, SQL, C, C

PROFESSIONAL EXPERIENCE:

Title : Tech Lead

Confidential

• Involved in Business Requirement Analysis, Design Document, ETL Process, Testing and Deployment.
• Design of ETL processes using Informatica tool to load data from Source System like Oracle, Flat and Data Transformations and then load to the target database.
• Creating the Staging Area and OLTP to maintain valid/consistent data with implementing the data cleansing logic.
• Designed and developed mappings using various Transformations like aggregator, joiner, Lookup, Filter, Router and Update Strategy.
• Preparing Unit Test Cases for testing the Mappings.
• Created Mapplets, re-usable transformations to reduce the development time and complexity of mappings and better maintenance.
• Creating Mappings, sessions, workflow and scheduling the workflow.
• Maintaining the OLAP system to provide quality data to support DSS.

Report Development:-

• Involved in business requirement gathering and create Requirement Analysis document.
• Design of report Process, including prototype creation.
• Interact with client and give Best solution to client.
• Schedule weekly status meeting with client and offshore team.
• Development of COGNOS Report and Cubes.
• Testing and Deployment of reports to production.
• Testing individual modules of the software against unit test cases.

Environment: Informatica Power Center 9.1, Oracle 10 and UNIX, Cognos 10.

Tech Lead

ETL and Report Tech Lead

• Involved in Business Requirement Analysis
• Design of ETL processes using Informatica tool to load data from Source System like SQL Server and Data Transformations and then load to the target database.
• Creating the Staging Area and loading raw data to cleanse it over there.
• Designed and developed mappings using various Transformations like aggregator, joiner, Lookup, Filter, Router and Update Strategy.
• Preparing Unit Test Cases for testing the Mappings.
• Created Mapplets, re-usable transformations to reduce the development time and complexity of mappings and better maintenance.
• Creating Mappings, sessions, workflow and scheduling the workflow.
• Design of report Process, including prototype creation.
• Maintaining the OLAP system to provide quality data to support DSS.
• Interact with client and provide best solution

Environment: Informatica 8, Cognos 8.1, SQL Server 2005/2008, UNIX.

Tech Lead

ETL and Report Developer

• Maintaining the OLAP system to provide quality data to support DSS.
• Creating Mappings, sessions, workflow and scheduling the workflow.
• Created Mapplets, re-usable transformations to reduce the development time and complexity of mappings and better maintenance.
• Preparing Unit Test Cases for testing the Mappings.
• Account Receivable Data warehouse ARDW is a data mart in Aviation finance Warehouse. Through this application finance user of GE Aviation used to track detail Invoice information as well as account balance. There are around more than 20 cognos reports/Cubes are dependent on this warehouse. This application is a high visible application in terms of reconciling account balance at the end of the month and to understand due on different customer. We have used Informatica as ETL tool to load data from various sites including OAR ERP system .All together we have 15-20 interfaces to load data from various sources to load data to staging and then to warehouse.
• Involved in Business Requirement Analysis, Design Document, ETL Process, Testing and Deployment.
• Design of ETL processes using Informatica tool to load data from Source System like Oracle, Flat and Data Transformations and then load to the target database.
• Creating the Staging Area and OLTP to maintain valid/consistent data with implementing the data cleansing logic.
• Designed and developed mappings using various Transformations like aggregator, joiner, Lookup, Filter, Router and Update Strategy.
• Design of report Process, including prototype creation.
• Interact with client and give Best solution to client.
• Schedule weekly meeting with client and offshore team and Prepare weekly status report.

Report Development:-

• Involved in business requirement gathering and create Requirement Analysis document.
• Design of report Process, including prototype creation.
• Interact with client and give Best solution to client.
• Schedule weekly status meeting with client and offshore team.
• Development of COGNOS Report.
• Testing and Deployment of reports to production.
• Testing individual modules of the software against unit test cases.

Environment: Informatica Power Center 8.1, Cognos 8.1, Oracle 10g, UNIX.