SUMMARY

• Overall 12 years of extensive experience in Information Systems with a strong emphasis in Business Objects Report and ETL development.
• Seven years of work experience Informatica Power Center to extract data from various sources; included flat files, Relational Database.
• Five years of work experience in Business Objects 4/XIR2/6.x/5.x, Desktop Intelligence, Universe Designer, Web Intelligence, Reporter.
• Requirement gathering and Resource allocation for the tickets\issues based on priority
• Estimation for development and enhancement work
• Coordination between across the teams(QA, DBA, Admin teams), Onshore - Offshore and deployment teams
• Thorough knowledge of the Data Mart Development Life Cycle. Performed all dimensions of development including Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor).
• Experience in migrating business object reports and universes from Business Objects 6.x/5.x to Business Objects XI R2, 3.1 and BI 4.0.
• Worked extensively in developing and implementing Webi Reports on Business Objects Enterprise XI, XI 2, and Business Objects Universe Design.
• Complete understanding of Software Development Life Cycle (SDLC).
• Different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub reports.
• A well-organized, detail oriented team member with good analytical and trouble shooting skills.
• Created the test environments for UAT and Regression Testing.
• Configuration management and maintain the documents.
• Database refresh and backup data to compare for testing environments
• Code deployment from one environment to other environment.

TECHNICAL SKILLS

ETL tools: Informatica 5.x/6.x/7.x/8.x and 9.x (Repository Manager, Designer, Workflow Manger, Workflow Monitor).

Modeling Knowledge: Dimensional Data Modeling, Star Schema, Snow-Flake Schema

Databases: Oracle 9i.10g, Teradata and SQL server

Programming: SQL, Unix

Reporting Tools: Business Objects Universe Designer and Reports Development

Other Tools: Toad, EDI, Sterling WMS and Putty.

PROFESSIONAL EXPERIENCE

Confidential, Madison, WI

Informatica Designer and Project Lead

Responsibilities:

• Requirements Gathering and coordinating with other teams for design and implementation of requests.
• Preparation of High level design documents for the Informatica requirements.
• Developed Functional (Business terms) and Technical Design documents. And lead the team while gathering, analyzing, and documenting technical requirements from the functional requirements.
• Involved in Informatica Mappings and Transformations to load data from JBIAS and POLICY relational data and flat file sources into the Target database GreenPlum.
• Analyzing the Functional Specifications and changing necessary modifications required through client interaction.
• Extracting, Formatting and loading the data from JBIAS and POLICY database data in the data warehouse GreenPlum.
• Loading the customers invoice data from Debut application to warehouse database tables.
• Extracted data from different sources like Oracle, SQL Server and Flat files Implemented business logic and loaded into the target Warehouse (Oracle).
• Preparation on implementation spread sheets for Informatica.
• Involved in UAT testing in different cycles.
• Code deployment for UAT and Pre Prod cycles.
• Performance Testing and collection of statistics.
• Tasks assignment and status tracking.
• Project management activities and project estimations.
• Managing knowledge sharing sessions and best practices.

Environment: Informatica 9.5, Oracle 10g, GreenPlum, IDQ

Confidential, Memphis, TN

Informatica Team Lead and Designer

Responsibilities:

• Requirements Gathering and coordinating with other teams for design and implementation of requests.
• Preparation of SRS, High level design documents for the Informatica requirements.
• Developed Functional (Business terms) and Technical Design documents. And lead the team while gathering, analyzing, and documenting technical requirements from the functional requirements.
• Involved in Informatica Mappings and Transformations to load data from O2S and Sterling relational data and flat file sources into the Target database.
• Analyzing the Functional Specifications and changing necessary modifications required through client interaction.
• Extracting, Formatting and loading the data from O2S and Sterling database data in the data warehouse.
• Loading the customers invoice data from Debut application to warehouse database tables.
• Extracted data from different sources like Oracle, SQL Server and Flat files Implemented business logic and loaded into the target Warehouse (Oracle).
• Preparation on implementation spread sheets for Informatica.
• Involved in UAT testing in different cycles.
• SLA based 24X7 Production support on rotation basis.
• Code deployment for UAT and Pre Prod cycles.
• Tasks assignment and status tracking.

Environment: Informatica 9.1, Oracle 10g, Flat files

Confidential

BO Universe Designer and Report Developer

Responsibilities:

• Analysis, Design, Development, Implementation and Testing of BO applications like Reports, Universe, Scheduling
• Interacting with Business Users to understand and document the requirements and translate these to Technical Specifications for Universes and Business Object Report (Deski / Webi).
• Using various Data Providers like Universes, Stored Procedures, Free Hand SQL.
• Creating Standard monthly, weekly, daily reports and wincore, endologix, abbott … Customer specific reports
• Designed the layout for various Reports in Business Object and Integration of reports and involved in Coding, Reviewing, Formatting, Testing, Bug fixing & Integration with different classes.
• Managing and coordinating between onsite and offshore to discuss problems.
• Testing of reports by comparing the data with the database for various customer like NCC, ABBOTT … etc.
• Handling of project portfolio management and process management.
• Tasks assignment and status tracking.
• Root cause analysis and corrective actions.
• Integration of applications for EDI, order management and warehouse management.

Environment: Business Obejcts XI R3, EDI, Confidential Net, O2S, Sterling WMS, Oracle 10g

Confidential

ETL Lead Designer and Developer

Responsibilities:

• Developed Functional (Business terms) and Technical Design documents. And lead the team while gathering, analyzing, and documenting technical requirements from the functional requirements.
• Involved in Informatica Mappings and Transformations to load data from relational and flat file sources into the Target database
• Analyzing the Functional Specifications and changing necessary modifications required through client interaction.
• Extraction, transformation and loading of data from CAPITA systems to the data warehouse.
• Extracted data from different sources like Oracle, SQL Server and Flat files Implemented business logic and loaded into the target Warehouse (Oracle).
• Preparation on implementation spread sheets for Informatica, Unix and databases.
• Configuration management and code promotion activities for different environment.
• Created the test environments for the GL cycle2 testing and Phase3 environment.
• Communicating with the other teams for the follow-up for creation of environments.
• Database refresh and backup data to compare for testing environments.
• Involved in UAT testing in different cycles. Production support in warranty Phase.
• Maestro scheduling for the workflows execution.
• Code deployment for UAT and Pre Prod cycles.

Environment: Informatica 9.1, Mastro, SQL Server,unix

Confidential

Datastage Developer

Responsibilities:

• Involved in Informatica Mappings and Transformations to load data from relational and flat file sources into the Target database
• Performed all dimensions of development including Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor).
• Created Informatica Mappings with different transformations including Source Qualifier, Lookup, Filter, Expression, Rank, Aggregator, Stored Procedure, etc.
• Developed mapplets, mappings and configured sessions.
• Created workflows and tasks using Informatica Power Center Work flow Manager.
• Code migration From Dev environment to Test Environment.
• Responsible to support the issues with mappings in Informatica (UAT and Production) environments.
• Extracted data from different sources like Oracle, SQL Server and Flat files Implemented business logic and loaded into the target Warehouse (Oracle).
• Handled slowly changing dimensions type 1, 2
• Created reusable transformations and mapplets to use in multiple mappings.
• Testing the result both functionally and technically
• Look into the production activities without missing SLA’s on daily basis.
• Taking care of production releases for on time delivery without having the issues.
• Remedy tool for raising the production issues\tickets.

Environment: Informatica 8.6, Unix, Sybase, MQ Series, DB2

Confidential

BO Universe Designer and Report Developer

Responsibilities:

• Analysis, Design, Development, Implementation and Testing of BO applications like Reports, Universe, Scheduling
• Interacting with Business Users to understand and document the requirements and translate these to Technical Specifications for Universes and Business Object Report (Deski / Webi).
• Using various Data Providers like Universes, Stored Procedures, Free Hand SQL.
• Creating Standard monthly, weekly, daily reports and wincore, endologix, abbott … Customer specific reports
• Designed the layout for various Reports in Business Object and Integration of reports and involved in Coding, Reviewing, Formatting, Testing, Bug fixing & Integration with different classes.
• Managing and coordinating between onsite and offshore to discuss problems.
• Testing of reports by comparing the data with the database for various customer like NCC, ABBOTT … etc.
• Handling of project portfolio management and process management.
• Tasks assignment and status tracking.
• Root cause analysis and corrective actions.

Environment: Business Obejcts XI R2, Oracle 10g

Confidential

BO Universe Designer and Reports Developer

Responsibilities:

• Analysis, Design, Development, Implementation and Testing of BO applications like Reports, Universe, Scheduling
• Interacting with Business Users to understand and document the requirements and translate these to Technical Specifications for Universes and Business Object Report (Deski / Webi).
• Designed the layout for various Reports in Business Object and Integration of reports and involved in Coding, Reviewing, Formatting, Testing, Bug fixing & Integration with different classes.
• Testing of reports by comparing the data with the database.

Environment: Business Objects XI, Oracle

Confidential

Sr. Business Objects Developer

Responsibilities:

• Interacting with Business Users to understand and document the requirements and translate these to Technical Specifications for Universes and Business Object Report (Deski / Webi).
• Designed the layout for various Reports in Business Object and Integration of reports and involved in Coding, Reviewing, Formatting, Testing, Bug fixing & Integration with different classes
• Using various Data Providers like Universes, Stored Procedures, Free Hand SQL
• Analysis, design and Implementation of schemas for the Data Mart.
• Testing and Performance Tuning of the Informatica mappings.

Environment: Business Objects 6.5, Teradata

Confidential

Informatica Developer

Responsibilities:

• Involved in Informatica Mappings and Transformations to load data from relational and flat file sources into the Target database
• Code migration From Dev environment to Test Environment.
• Used Informatica Power Center for extraction, transformation and loading of data in the data warehouse.
• Created Informatica Mappings with different transformations including Source Analyzer, Lookup, Filter, Expression, Rank, Aggregator, Stored Procedure, etc.
• Developed mapplets, mappings and configured sessions.
• Created and monitored workflows and tasks using Informatica Power Center Work flow Manager.
• Created reusable transformations and mapplets to use in multiple mappings.
• Generating the exceptional data to staging tables for maintain Parameter tables by user.

Environment: Informatica 6, Oracle

Confidential

Informatica Developer

Responsibilities:

• Responsible for the developing ETL processes/programs with Informatica Power Center to extract data from the client's operational databases, Transform and filter the data, and Load it into Target database
• Created mappings with Informatica 5.1 using Transformations (Expression Transformation, Router Transformation, and Stored Procedure Transformation etc) and Look-ups.
• Used Informatica power Center Work Flow manager to create sessions with the task developer and workflows with workflow manager to run with the logic embedded in the mappings.
• Successfully done the unit testing for the mappings.

Environment: Informatica 5.1, Oracle

Confidential

BO Developer

Responsibilities:

• Creation of different types of reports, such as Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc.
• Use of Analyzer and Explorer to view reports from different prospect (Slice and Dice and Drill down)
• Created the report templates in Business Objects
• Scheduling the reports in Business Objects

Environment: Business Obejcts, Oracle