EXPERIENCE SUMMARY:

• Analysis, design, development, testing, maintenance and quality assurance with implementation of software applications in data warehousing.
• Installed & Configured core Informatica MDM Hub components: Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, and Cleanse Adapter.
• Upgraded several versions (MDM v9.x) of Informatica MDM and applied many Hot Fixes and EBF on different Infrastructure environments.
• Administrative knowledge and expertise on Informatica MDM tool and Application server like WebLogic/jBoss.
• Business and technical knowledge for the D&B, Global Soft, Address Doctor, FIDA and other web service used in Supply Chain/Pharmaceutical domains.
• Implementation experience of Persistent IDs to accommodate downstream requirements and control the survivorship of MDM IDs.
• IDD/Custom UI out of the box functionality and customization using custom code as per the Business Requirement.
• IDD and ActiveVOS Task creation and workflow configuration with MDM.
• Configured JMS messaging and have done customization of XSDs and de - duplication process for the capability teams.
• Defining and configuring Base Objects, Staging Tables, Landing Tables, Look-ups, Foreign Key Relationship, Hierarchies, Queries, Query Groups and Update/Display Packages.
• Mapping data from Landing Tables to Staging Tables.
• Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• Designed & developed multiple cleansing functions and standardization scenarios using Address Doctor.
• Importing ORS data source in the application server environment for Informatica MDM Hub.
• Importing and exporting the ORS repositories from different environments.
• Configuring Entity Base Objects, Entity Types, Relationship Base Objects, Relationship Types, Profiles using Hierarchy tool.
• Data warehousing tools like DataStage v7.1, 8.0, 8.5 and 8.7 and Informatica v8.5 and v9.0 Power Center.
• Implementation experience in Pharmaceutical domain and Supply Chain domain.
• Handling critical situations where:
• DataStage WebSphere services are unavailable, or
• Oracle performance is reduced for Oracle EBS or
• Rebooting a cluster of Oracle/DB2 nodes or
• Reports services for intra-applications are unavailable.
• Database transformation using the DataStage - Designer and Informatica - workflow, session and mapping s.
• Monitoring performance of Oracle EBS, DB2, DataStage, Informatica, UC4 and Cron Jobs.
• Designing fact and dimensional tables, physical and logical data modeling.
• Data warehousing techniques such as Data Cleansing, Slowly Changing Dimension phenomenon, Surrogate key assignment, and change data capture.
• DataStage suite of server-side and client-side tools like Designer, Workflow Director, Workflow Manager and Repository Manager.
• Different transformation stages such as Aggregate, Joiner, Lookup, Filter, Custom and Expression Transformation.
• Complex analytical thinking ability and communication skills.
• Various phases of Project Life Cycle such as Requirement gathering, Design, Development and Testing.
• Enterprise Dataware Housing Testing - Data Integration, preparation and execution of test strategy, test plans and UAT, test scripts and performing regression testing for any business requirement for performance tuning and data validation.

TECHNICAL SKILLS:

Master Data Management: Informatica MDM 9.x Multi Domain Edition, Siperian MRM

ERP: Oracle E-Business Suite 11i and R12

Operating Systems: Vista,Windows7, Windows XP, VMware, Windows 2003, Redhat Linux, UNIX, Apple OS X and iOS

Langages: C, C++, Oracle PL/SQL

Databases Management: SQL Server 2005/2008, Oracle 11g/10g, DB2,SQL Server Management Studio, TOAD, MS Access

Tools: / Software: Informatica MDM, WebLogic, Informatica v8x and v9x, DataStage 8.0/8.1/8.5/8.7 , Oracle EBS, OEM Grid, UC4 v4/8 (Scheduler), Cron Jobs, Putty, WinScp and UltraEdit.

PROFESSIONAL EXPERIENCE:

Confidential, DC

Informatica MDM Tech Lead

Responsibilities:

• Collaborating closely with Business Analyst to understand the business data flow and in gathering requirements.
• Created Data Model in eRWIN and explained architect process to clients to get the approval for DSC 2.0 data model.
• Installed and configured new ORS for Integrity X, cleanse server setup, resource kit in Development, QA environment and assisted third Party Vendor for configuring in Pre-prod and Prod Environments.
• Converted DSC 2.0 data model into Physical MDM objects to develop the new solution for downstream users and capability teams.
• Implemented the IDD solution along with Custom UI for day-today entry and Data Steward roles.
• Implemented MDM JMS messaging and customized the XSDs and de-duplication process as per the business needs in realtime.
• Implemented Persistent Global ID solution for the downstream to control the survivorship of Parties and Address and find the BVT in DSC 2.0 solution.
• Implemented various MDM/IDD UserExits to full-fill the requirements and sustain the SOPs for Integrity Service team.
• Configured the task to handle the manual queues and provided User knowledge to perform data steward activities in real-time.
• Supported the existing MDM solution and helped Integrity Service/Data Stewards for any production issues.
• Implemented various fixes and enhancements as per CR and approved RFC in Integrity Projects.
• Applied various Hotfixes and EBFs to improve the performance and functionality in MDM.

Confidential, DC

Informatica MDM Hub Configuration Specialist

Responsibilities:

• Collaborating closely with Business Analyst to understand the business data flow and in gathering requirements.
• Created Data Model in eRWIN and explained architect process to clients to get the approval for Facility and IPD data model.
• Installed and configured new ORS for Integrity II, cleanse server setup, resource kit in Development, QA environment and assisted third Party Vendor for configuring in Pre-prod and Prod Environments.
• Conducted meetings and working closely with ETL architect for performing land batch process to populate data from external source system to landing tables in hub.
• Configured Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages, query groups and custom functions.
• Worked with Hierarchies tool, for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD.
• Setting up match/merge and run match rules to check the effectiveness of MDM process on data.
• Successfully implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries for searching the data for Pharmaceutical, Medicinal Product and Individual Pharmacological Class and Ingredient information in IDD.
• Implemented the approval process for subject areas in IDD, according to business rules and requirements.
• Closely worked with Data Steward Team (Integrity Service) for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Created and documented the secure resources, roles, users for roles, and assigned privileges to roles using Security Access Manager in Development, QA, Pre-prod and Prod environment.
• Defined the security such that MDM ORS schema will be secured with access only granted for specific integration uses, using users created for those specific integrations
• Used Metadata manager for validation, promotion, importing and exporting the ORS repositories to Development, QA, Pre-prod and prod environment.
• Identified Master records for Party Data by analyzing the data and duplicate records from source systems.
• Documented the issues and actions taken related to data cleansing using cleanse lists and predefined cleanse functions.
• Created Unit Test Case Document, Technical Design Document, Informatica MDM Hub batch process, Informatica Hub and IDD Migration Request Document.

Technology: Informatica Multi Domain MDM 9.5, Informatica Power Center 9.1, WebLogic, Oracle 11g, Toad, UNIX, ERwin v7.2.

Confidential, Atlanta, Georgia

Onsite Coordinator

Responsibilities:

• Coordinating with client/business users and offshore team members to deliver change requests and enhancement requirements.
• Developing/Enhancing ETL server/parallel jobs/sequence using DataStage v 8.1/8.5/8.7.
• Scheduling various DS jobs/scripts in UC4 and Running/Scheduling Concurrent requests in Oracle EBS.
• Implementing functionality to extract and analyze erroneous data (reject rows).
• Using Job Control to pass specific parameter at project level and call different jobs inside a specific job.
• Unit- and System-testing for jobs/Process.
• On Call production supports 24 by 7 to business users located over the globe and assist technical team working at onshore/offshore when and where required.

Technology: UC4 v4.0/8.0, DataStage 7.5/8.1, DB2, SQL Server, Oracle9i/10g PL/SQL, Oracle EBS.

Confidential, Orlando, Florida

ETL Developer

Responsibilities:

• Coordinating with onsite team members to understand the change requests and enhancements requirements.
• Developing/Enhancing ETL server/parallel jobs using DataStage v 8.1/8.5/8.7.
• Extracting data from various data sources to staging area and performing various transformations on the data and finally loading it to the target data warehouse.
• Designing and developing run sequences for jobs.
• Implementing functionality to extract and analyze erroneous data (reject rows).
• Using Job Control to call different jobs inside a specific job.
• Unit- and System-testing for jobs/Process.
• Always available for On Call support 24 by 7 when and where required as per the client requirement or in an emergency situation.

Technology: UC4 v4.0/8.0, DataStage 7.5/8.1/8.5/8.7 SQL Server, Oracle9i/10g PL/SQL.

Confidential, Orlando, Florida

UC4 Developer

Responsibilities:

• The Scheduling tool UC4 Operations Manager provides a scope to schedule various jobs developed in an ETL tool.
• The objects like Job, Job Plan, Call Operator, Scheduler and File Transfer facilitate the quick and easy handling of all processes. Jobs developed in any ETL tool can be integrated with this and scheduled to run according to our date and time requirements.
• Intensive hands-on capabilities in Windows-based Informatica suit of server-side and client-side tools like Designer, Workflow Director, Workflow Manager and Repository Manager.
• Some of the processes can be scheduled to run on Fiscal start day of the month, this removes the need to schedule such processes manually. This is done using the Calendar Object.
• Once the processes are included in the Job Plan or Schedule an alert or email can be sent to the users conveying process completion status.
• FTP Tools are not required here as the File Transfer replaces the FTP jobs.
• Batch Job Scheduling and Event Processing are also possible using the objects of UC4.
• Monitoring periodic jobs for various projects like Sales, Product and Souring including Electrical/Plumbing.
• Intervening in the event of an outage to fix issues and restart the UC4 job without delay.
• Scheduling backup and cleanup tasks to ensure restore capability and smooth execution in a timely manner.
• Email notification of success/failure alerts should be distributed to concerned people.

Technology: UC4 v4.0/8.0, DataStage 7.5/8.1/8.5/8.7 , Oracle9i/10g PL/SQL