SUMMARY

• 10 +years’ experience in various phases of Data warehouse Lifecycle that includes Requirements Gathering, Design, Development, Implementation and testing for end - to-end IT solution offerings.
• Strong knowledge and development Experience in Informatica Power Center, Informatica MDM, SAP Business Objects, Oracle and Data Warehouse concepts.
• MDM architecture and design in multiple implementations. Designing of Expertise in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages. Creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Informatica Data Director (IDD) configuration and customization experience. Configured Product and Customer MDM hierarchies and experience on SIF API.
• Created MDM mapping, configuration of trust and validation rules and configured match and merge rules to integrate the data received from different sources. Perform Informatica MDM design, configuration and Implementation Design, Develop IDD user exits, Match rules. Experience in creating trust and custom validation rules and Informatica Data Director Development and Hierarchy configuration.
• Configuration of MDM Stage and Base jobs and Creation of Batch Groups to execute MDM jobs.
• Created Mappings to load data using various transformations like Source Qualifier, Sorter, Lookup, Expression, Router, Joiner, Filter, Update Strategy and Aggregator transformations.
• SAP Business Objects Business Intelligence Platform 4.1, Universe Designer tool, Information Designer tool, Web Intelligence, Query As a Web Service (QaaWS), Live Office and TTMS (OMAR), Dollar Universe 2.4, and IBM Info sphere CDC 6.3, Star Team and SQW, Informatica Power Center (Repository Manager, Mapping Designer, Workflow Manager, Workflow Monitor.
• Sound knowledge of Data warehouse concepts and principles - Star, Snowflake schema, SCD, Surrogate keys, and Normalization/De normalization.
• Experience in leading a team. Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation.

TECHNICAL SKILLS

Data warehousing: Informatica Power Center 9.5/8.6, Informatica MDM, SAP Business Objects Xi 3.1/4.1,IDQ

BI Tools: SAPBO4.1, UDT, IDT, WEBI, CMC, CCM, Crystel reports

Databases: Oracle9i, MS-Access, DB2 8.0/7.0, MS-SQL Server

Languages: SQL, T-SQL, PL/SQL, UNIX

Operating System: Windows XP Professional/95/98/2000/XP/2010/Vista/Windows 8

MDM Packages: Informatica MDM 10.1/9.1,IDD,SIF API

DB Tools: SQL*Plus, SQL*Loader, Export/Import, TOAD, SQL Navigator

Tools: and Utilities: Live Office, Dollar Universe 2.4, IBM Info sphere CDC 6.3, SQW. CRM Clarify Client and TTMS, Star Team & LCM,SOAP,Control-M,SOAP, Eclipse,JBOSS

PROFESSIONAL EXPERIENCE

Informatica MDM Project Lead

Confidential

Responsibilities:

• Worked with client leads and business analysts closely in prioritizing the tasks and determining the implementation of fast track code fixes.
• Manage risks to project activities and come up with mitigation plan to ensure the assigned tasks are under control and should not affect the project delivery timelines.
• Involved in the designing of Landing, Staging and Base tables in Informatica MDM.
• Created MDM mapping and configured match and merge rules to integrate the data received from different sources.
• Applied trust and validation rules in the MDM load process.
• Confirgarion and experience on SIF API.

Environment: Informatica Power Center 9.5.1, Informatica MDM 10.1, SIP API, IDD, Oracle

Sr. Informatica/MDM Developer

Confidential

Responsibilities:

• Involved in effort estimation for the requirements in the project and prepared mapping documents based on client requirement specifications.
• Involved in the design, development and implementation of the Enterprise Data Warehousing (EDW) process.Datawarehouse Developer.
• Provided data warehouse expertise including data modeling, Extract, Transform and Load (ETL) analysis, design and development.
• Analyzing the sources and targets, transforming the data, mapping the data and populating the data into targets by using Informatica Designer, Workflow Manage and Workflow Monitor.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Worked with various Active and Passive transformations like Source Qualifier, Sorter, Aggregator, Filter, Union, and Router Transformations, Sequence Generator and Update Strategy Transformations.
• Handled versioning and dependencies in Informatica.
• Developed schedules to automate the update processes and Informatica sessions and batches.
• Resolving technical and design issues.

Environment: Informatica Power Center 9.1, Informatica MDM 9.1,IDD,Oracle, Unix

SAP Business Objects/Informatica Developer

Confidential

Responsibilities:

• Demonstrated SAP Business Objects solution and features using its suite of tools i.e. SAP Business Objects 4.1, SAP Dashboard Design Tool, Live Office, QaaWS.
• Analyzed the existing database and designed the Universes using Business Objects Designer Module.
• Involved in Installing the Business Objects, Web intelligence.
• Designing and developing universe for report generation.
• Created hierarchy and conditions in the universes.
• Improved the report performance by tuning the report query and the Universe design using Aggregate awareness, Universe Parameters, etc.
• Created WEBI reports based on end user requirements.
• Involved in creating the WEBI reports using the Cross tabs and hierarchies, writing the variables, breaks, sections and formatting the reports.
• Identified the sources, targets and developed ETL mappings using Informatica 8.6.
• Attended multiple requirement gathering discussions and created Source to Target Detailed Design Documents.
• Worked with Offshore Development team in guiding them and also participated in Daily Scrum meetings with the Manager to keep updated on the status.
• Worked extensively with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and feed in Data Warehouse.
• Interacted with Business Users and understood the design requirements of the users.
• Used different kinds of transformations like Router, Sorter, Source Qualifier, Joiner, Aggregator, Lookups both Connected and Unconnected Lookups, Expression, Expression, Sequence Generator, Union, Update Strategy to load data into target tables.

Environment: Informatica 8.6, Oracle 9i, Business Objects 4.1

SAP Business Objects /Informatica Developer

Confidential

Responsibilities:

• Interacted with Business Users and understood the design requirements of the users.
• Used different kinds of transformations like Router, Sorter, Source Qualifier, Joiner, Aggregator, Lookups both Connected and Unconnected Lookups, Expression, Sequence Generator, Union, Update Strategy to load data into target tables.
• Demonstrated SAP Business Objects solution and features using its suite of tools i.e. SAP Business Objects 4.1, SAP Dashboard Design Tool, Live Office, QaaWS.
• Analyzed the existing database and designed the Universes using Business Objects Designer Module.
• Involved in Installing the Business Objects, Web intelligence.
• Designing and developing universe for report generation.
• Created hierarchy and conditions in the universes.
• Improved the report performance by tuning the report query and the Universe design using Aggregate awareness, Universe Parameters, etc.
• Created WEBI reports based on end user requirements.
• Involved in creating the WEBI reports using the Cross tabs and hierarchies, writing the variables, logos, charts, and breaks, sections and formatting the reports.

SAP Business Objects Developer

Confidential

Responsibilities:

• Customer interaction, Business analysis and gathering of business requirements.
• Developed universe using Designer module in Business Objects
• Specified the joins and checked the cardinalities and resolved the loops, cardinalities, contexts and checked the Integrity of the Universes.
• Created Classes, Objects, LOV, Prompts and Predefined conditions and custom Hierarchies for drill down purposes.
• Created new Universes and applied row level and object level securities to restrict sensitive client information.
• Analyze and resolve the live incidents as per agreed SLA.
• Daily Monitoring of live server jobs and finishing it on time. Sending the reports to concerned persons.
• Report failure-Manually refreshed and/or re-scheduled the reports and sent across the URL of the report after refresh.
• Have provided on call support as and when required (24*7) have monitored bridge & supervisor password reset throughout the time of my shift responsibility.
• Have solved Bridge Cases ideally within 15 minutes of their assignment to our queue (please note that most cases were P3, P4 and P5 cases).
• Daily, weekly and Monthly Uploading reports from EQMS.
• Daily Job Monitoring from Clarify & Web Bridge and Re-scheduling of the reports as per User requirement.
• Daily Monitoring of live server jobs and finishing it on time. Sending the reports to concerned persons.
• Have monitored live server reports and checked for any possible discrepancies in then and finally have loaded them onto the common server for the common users and notified the intended recipients of the same within stipulated time.
• Monitoring of batch processing and resolving Dollar Universe job failures within the time in order to achieve 100% SLA’s agreed with various downstream applications.

SAP Business Objects Developer

Confidential

Responsibilities:

• Analyzed the existing database and designed the Universes using Business Objects Designer Module.
• The major data providers used are Universes, data files, Free Hand SQLs. Involved with the Enterprise Data Warehouse project and involved in part of Data analysis.
• Involved in Installing the Business Objects, Web intelligence.
• Designing and developing universe for report generation.
• Created hierarchy and conditions in the universes.
• Involved in setting up of Aggregate awareness to enhance the performance of SQL transactions.
• Resolved the loops, cardinalities, contexts and checked the Integrity of the Universes.
• Exported the universe to the Repository to make resources available to the users.
• Setting up the drill through and scope of analysis for the end users.
• Creation of detail design documents for business requirement documents.
• Creation of Schedule documents and Report Layout documents.
• Extensively used Calculations, Sorting, Formatting and Sectioning.