PROFESSIONAL SUMMARY:

• Overall Thirteen years of extensive experience in Information Systems with a strong emphasis in Business Objects Report and ETL development.
• Eight 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.
• Incident Management and Problem management for ONCALL support.
• SLA management for the ONCALL deliverables.

TECHNICAL EXPERTISE:

ETL: Informatica Power Center 9.x,Data Quality 9.x

OLAP Tool: Business Objects XI R3, Cognos

RDBMS: Oracle 11g, GreenPlum, Teradata,DB2, SQL server

Programming Language: SQL, PL/SQL, Unix Shell scripts

Operating System: Linux, Win NT/2003/2008

Testing: Test Director, Quality Center, JIRA

Scheduling Tools: Control-M, Auto Sys

Other Tools: TOAD, Remedy, Clarity, VSS, EDI, Sterling WMS, OOS, SQL developer

PROFESSIONAL EXPERIENCE:

Confidential

Technology : Informatica 9.6, Oracle 10g, GreenPlum, Db2, IDQ

Informatica Designer and Project lead, Madison, WI

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.
• Code deployment for UAT and Pre Prod cycles.
• Incident management and problem management for production support.
• Meeting the SLA’s on a daily basis by resolving the issues on time and escalations.
• Tasks assignment and status tracking.
• Project management activities and project estimations.
• Managing knowledge sharing sessions and best practices.

Confidential

Technology : Informatica 9.1, Oracle 10g, Flat files

Informatica Team Lead and Designer, Memphis,TN

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.
• Data migrations from legacy systems to advanced systems.
• Tasks assignment and status tracking.

Confidential

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

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.

Confidential

Technology : Informatica 9.1, Mastro, SQL Server,unix

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 followup 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.

Confidential

Technology : Informatica 8.6, Unix, Sybase, MQ Series. DB2

Informatica 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.

Confidential

Technology : Business Obejcts XI R2, Oracle 10g

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.

Confidential

Technology : Business Objects XI, Oracle

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.

Confidential

Technology : Business Objects 6.5, Teradata

Sr. Business obejcts 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.