PROFESSIONAL SUMMARY

• Having around 8 years of SDLC experience in Data warehousing with extensive knowledge on Informatica 8.x, 9.x ETL tool and Business Objects XI R2 Reporting tool.
• Having strong conceptual knowledge in Data Warehousing, Extensively used ETL methodology for supporting Data Extraction, Transformation Loading processing, in a corporate-wide-ETL Solution using Informatica Power Center.
• Extensively worked on Informatica Powercenter Designer, Workflow Manager, and Workflow Monitor. Implemented Various Performance Tuning techniques on Mappings.
• Worked on different phases of data warehouse development lifecycle, from gathering requirements to testing and implementation.
• Thorough knowledge on Data warehouse Concepts like Star, Snow Flake Schemas and good understanding on Data warehouse architecture.
• Having functional experience in design, analysis and development of Universe, Creating classes and objects as per the business requirements using Universe designer.
• Involved in the Preparation, implementation and maintenance of the universe using universe designer.
• Designed and developed reports using Desktop Intelligence, Web Intelligence, and Crystal Reports.
• Extensively used Business objects reporting functionalities such as Sectioning, Grouping, Slice and Dice, Drilling methodology, Filters, alerts, Ranking and Breaks.
• Having extensive knowledge on Dashboard manager and Key Performance Indicators KPI .
• Extensively worked on large database applications and Data marts.
• Extensively worked on Databases like Oracle 11g/10g/9i/8i, SQL Scripting.
• Good knowledge on writing the PL/SQL Scripts like Procedures, Packages and Functions.
• Testing skills include performing Unit, Regression, Integration, and Volume testing as well as Development, Execution, and Maintenance of Test plans, Test specifications and Test scenarios.
• Experience in providing On Call 24 7 Support for Production Problem Resolution Resolve Production issues and problems in an expedited manner .
• Good understanding of Data warehousing, ER Modeling and Dimensional Modeling concepts.
• Worked on preparing Low level, High level design documents along with Release notes Run book.
• Good understanding of Product Life Cycle and Comprehensive Delivery Process's.
• Team player with strong People Management skills, excellent Communication and Problem Solving skills and exposed to various design and presentation tools like Visio and MS-Office utilities.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Roles Responsibilities:

• Involved in doing reverse engineering on existing EDW logic for preparing new mappings in ICDW.
• Leading as an onsite/offshore coordinator and lead team by providing ETL Technical/Functional documents and acted as a Point of Contact POC for the offshore team.
• Worked on Teradata TPT loads
• Worked on several transformations such as Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation Connected and Unconnected , Joiner Transformation, and Router Transformation, and Normalizer Transformation in Informatica.
• Interacted DBA team to make sure application data base and also created all necessary data base objects for our project in Dev and Test Environments.
• Also provided all Database Object scripts for DBA team to deploy stage and prod DB environments.
• Created and Configured Sessions, Worklets and Workflows to load the data into target/s using Informatica Workflow Manager.
• Created Mapplets and Reusable Transformations to prevent redundancy of transformation usage.
• Worked as onsite coordinator to transfer work to offshore and made sure the deliveries happen on time.
• Created sessions and workflows for the mappings.
• Involved in performance improvement on the long running jobs.
• Documented the mapping process and methodology used to facilitate future development.
• Prepared the CCR for deploying the code into production
• Involved in requirement gathering meetings with clients.
• Used performance improvement techniques in informatica for tuning mappings.
• Involved in running the loads to the data warehouse involving different environments.
• Analyzed business information requirements.
• Involved in creating jobs using control M scheduler tool.
• Involved in supporting the production jobs

Roles Responsibilities:

• Understanding the Business requirements.
• Design ETL processes using Informatica to load data from various data sources to target Data Warehouse.
• Developed mappings using Informatica Power Center for data loading.
• Developed mapplets using Mapplet designer for usage of reusable.
• Used Informatica Power Center Workflow manager to create sessions, workflows to run tasks.
• Defined Target Load Order Plan for loading data correctly into different Target Tables and also done Unit testing
• Worked with Slowly Changing Dimensions and Version Controlling.
• Used Informatica Power Center Workflow manager to create workflows and Sessions to run tasks.
• Used Debugger to debug the mappings and used target load order plan for loading data correctly into different Target Tables.
• Participated in weekly meetings with client and discussed all the week days' activities/issues.
• Improved the application performance by fixing bugs in the application.
• Responsible for communicating the support processes within the team and to the customers.

Roles Responsibilities:

• Understanding the Business requirements.
• Design ETL processes using Informatica to load data from various data sources to target Data Warehouse.
• Developed mappings using Informatica Power Center for data loading.
• Developed mapplets using mapplet designer for usage of reusable.
• Used Informatica Power Center Workflow manager to create sessions, workflows to run tasks.
• Defined Target Load Order Plan for loading data correctly into different Target Tables and also done Unit testing
• Worked with Slowly Changing Dimensions and Version Controlling.
• Used Informatica Power Center Workflow manager to create workflows and Sessions to run tasks.
• Used Debugger to debug the mappings and used target load order plan for loading data correctly into different Target Tables.
• Involving in preparation of Unit Testing, Test Case Execution. Involved in designing the universe and created classes and objects according to the requirement of the Reports using Designer.