SUMMARY

• Over 7 years of MDM experience as a MDM Technical Architect/Consultant, and over 13 years of overall Information Technology professional experience encompassing application and system architecture, application development and support, project management, upgrades and data modelling.
• Strong expertise in installing and configuring the core Informatica MDM components (Informatica MDM Hub Server and Hub Cleanse).
• Excellent understanding of MDM concepts.
• Proficient in developing solutions usingInformatica MDM.
• Configuring and maintaining various components of the MDM Hub including the schema, staging and landing tables, configuring base objects, Look ups, Hierarchies, display queries, put queries and query groups
• Expertise in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups
• Knowledge in creating IDD application and configuring application - level properties
• Created and Configured Subject Areas and Subject Area Groups, related Base Object relationships with Subject Area relationships in IDD
• Developed User Exits to perform IDD data validation
• Experience in using SOAP UI to interact with MDM using SIF calls
• Created Entity Base Objects, Hierarchies, Foreign Key Relationship Objects, Relationship Base Objects, Packages and Profiles using Hierarchy manager.
• Responsible for creating user groups, privileges and roles to the users using Security Access Manager (SAM)
• Experience in using and writing UNIX Shell Scripts
• Extensively involved in writing Oracle, Teradata, PL/SQL, Stored Procedures/ Functions/Cursors/ Packages & Triggers.
• Worked with various SQL developer tools such as TOAD, Teradata SQL Assistant, SQL Plus, and SQL Developer
• Expertise in OLTP/OLAP system study, analysis, E-R modeling and developing database schemas like Star Schema and Snowflake schema
• Experience on providing solution approach and architecture in various proposals for prospective clients and helping the pre sales and sales team.
• Experience in preparing Microsoft Project for multiple projects and across multiple tracks.
• Worked on Agile framework and methodologies on certain project and created User Stories, burn down charts and function points. Also played the role of Scrum Master in couple of projects.
• Strong analytical, logical and problem solving skills and ability to quickly adapt to new technologies by self-learning

TECHNICAL SKILLS

EIM Tools: Informatica MDM Multi-domain, Informatica Data Director (IDD)

Databases: Oracle 7x/8i/9i/10g,11g, SQL Server 2012/2008/2005

Languages: SQL, PL/SQL, Unix Shell Scripting

RDBMS Tools: TOAD (Oracle), Oracle SQL Developer, SQL*Loader (Oracle), SQL*Plus, Teradata SQL Assistant, MySQL

Modeling Tools: MS Visio

Environment: Windows 2000/ XP, Unix, Windows 7, Windows Server 2003, 2008

Packages: MS Office (MPP, Visio, MS Outlook, MS Excel, MS PowerPoint, MS Word, MS OneNote, MS Lync)

Utilities: Putty, WinSCP, REST Client, mIRC, Beyond Compare, SOAP UI

PROFESSIONAL EXPERIENCE

Confidential, Whippany, NJ

MDM Architect

Responsibilities:

• Data analysis of existing HCOs and HCPs based on Business Rules and identify discrepancies.
• Work along with Data Stewards to identify the pain points and identify an approach to fix the root cause.
• Prepare Project Plan and estimation for the overall project.
• Work along with business to identify the new HCP flow.
• Review any impact on all custom IDD user exits.

Technologies: Teradata, Informatica, Unix, Shell Scripting, MPP, Viso

Confidential

MDM Consultant

Responsibilities:

• Identify the probable approach for Infa Upgrade and highlight to business the pros and cons for each approach.
• Review all customization scripts and impact of any deprecated feature in 10.1 or earlier version.
• Identify any redundant schema objects not to be a part of Infa 10.1 and plan for their removal.
• Refer the Product Availability Matrix and ensure the compatibility of the upgrade version.
• Review of impact of deprecated DB packages to be re-written in Java.
• Review any impact on all custom IDD user exits.
• Review all additional features with new version and ensure the benefits are understood to end users.
• Document all impacts as part of Infa upgrade from 9.5.1 to 10.1 and publish Impact Assessment deliverable to business.

Technologies: Informatica MDM 9.5.1, Oracle 11g, Oracle PL-SQL, Unix, Shell Scripting

Confidential, Miamisburg, Ohio

Technical Architect - MDM

Responsibilities:

• Identify the overall approach for Infa Upgrade. Consult Infa Upgrade guide, identify challenges with custom solutions in the application.
• Resolving issues with errors in Hub before initiating the Upgrade process. Working along with Infa support team wherever applicable.
• Refer the Product Availability Matrix and ensure the compatibility on the upgrade version.
• Documenting release plan for lower environments (Dev/Cert) and ensure it has all the relevant pre-requisite checks and steps involved in the upgrade process.
• Involved in requirement elicitation and impact assessment for various enhancements in Infa 9.5 version.
• Preparing design document with documenting end to end solution.
• Design logical and physical data model changes.
• Done full implementation from design, configuration, rules setup, tuning, IDD setup, Batch group an Bach jobs execution, write and customized user exits and provide data to business and Enterprise Data Office (EDO) team, testing, work on implementation plan and implementing in production.
• Identifying alternate solution for qucker data loads for new attributes added for business requirments in data model and determination of accurate golden records.
• Promotion and migration of MDM code to various environments (Dev, Test, Cert, DR and PROD) and extensively testing them.
• Perform DB queries and data extracts using Oracle SQL Developer and also create PL/SQL Stored procedures for Publish creation.
• Created new Base Objects and added additional columns to existing Base Object’s as per the Data Model.
• Updated existing Landing tables and created new Landing tables as per the requirement.
• Developed mappings using various cleanse functions to cleanse and load the required data to the Staging tables.
• Many custom functions were created to be used in mappings.
• Configured the Foreign Key Relationships among the Base Objects and defined the lookups for the staging tables.
• Used Hierarchies tool to create hierarchical relationships between design objects using entities and hierarchies.
• Extensively unit tested the code as well as the data that was loaded in Landing, Staging and Base tables
• Worked closely with the Business in finalizing the Match rules, Validation rules, Trust rules.
• Developed the Match paths, Match Columns, Match rule sets and Match rules (Exact and Fuzzy) in the Match and Merge Process.
• Involved in preparing scripts for data profiling activities.
• Created new Systems and defined the Trust and Validation rules to get the desired golden record
• Configured Message Queues and setup Message Triggers to send messages to down streams
• Created Queries and Packages for data manipulation
• Did schema promotions using Metadata manager to promote changes between all environments from development to production
• Created new IDD Subject Area Group’s and Subject Areas and configured IDD as per the business requirement
• Created User Exits for IDD data validation
• Deployed IDD Configuration by importing BDD Configuration files, Message bundles, Error code bundles and User Exits by clearing cache and redeploying the applications
• Created roles for different domains and assigned it to users using Security Access Manager (SAM)
• Exported and Imported the IDD application changes from one environment to another
• Played a major role coordinating the release (VDD, RFC, coordinating between teams)
• Worked with Informatica support team for product related issues
• Responsible for giving access to new users to HUB and IDD in all environments
• Warranty support for the enhancement releases.

Technologies: Informatica MDM 9.5, Informatica Data Director 9.5, Informatica MDM 10.1, Informatica Data Director 10.1, Weblogic 11 g, Weblogic 12.1.3, TOAD for Oracle, UNIX, SOAP UI, MPP, Viso

Confidential

Consultant

Responsibilities:

• Involve in Design and determination of the Logical Data Model and design of Physical Data Model.
• Provide Architectural guidance to business on issues they have and provide suitable solution related to MDM Hub, match and merge rules and tuning.
• Configuration of the Informatica MDM Hub for Base Objects for Party data model and their related Child tables.
• Worked extensively on creation of staging, base objects, validation rules, match and merge rules, Hierarchy configuration, Trust and validation rules, Batch Groups and publish to downstream.
• Creation of queries, packages, creation and configuration of Subject areas for IDD.
• Done full implementation from design, configuration, rules setup, tuning, IDD setup, Batch group an Bach jobs execution, write and customized user exits and provide data to business and team, testing, work on implementation plan and implementing in production.
• Promotion and migration of MDM code to various environments (Dev, Test, Cert, DR and PROD) and extensively testing them.

Technologies: Informatica MDM 9.1, Informatica Data Director 9.1, JBoss, Oracle, TOAD for Oracle, UNIX, MPP, Visio

Confidential

Informatica Technical Architect

Responsibilities:

• Interacted with Business & Data stewards Leads to understand/clarify the business requirements
• Come up with complete solution of how to load bulk data from spreadsheet in Informatica 9.1 and create golden records.
• Prepared TDD’s for implementing the solutions as per business needs.
• Preparation of Logical and Physical data model from the beginning.
• Scripts for data profiling and identify discrepancies as per business rules from data stewards.
• Analysis of impact assessment and identifying assumptions and getting sign off from all stakeholders for a successful E2E solution implementation.
• Coming up with implementation of custom solution for data loads especially for Geography entities where huge volumes were involved.
• Done full implementation of implementing Hub changes, IDD setup, Batch group an Bach jobs execution, write and customized user exits testing, work on implementation plan and implementing in production.

Technologies: Informatica MDM 9.1, Informatica Data Director 9.1, Weblogic 11 g, Oracle, TOAD for Oracle, UNIX, HP Application Life Cycle Management, Clear Case, MPP, Visio

Confidential

Project Lead

Responsibilities:

• Lead estimation activities, review estimates and plan for required budget and resources for successful project execution.
• Detailed resource planning including people, space, infrastructure and liaison with required groups to fulfill project resource requirements.
• Preparation and baseline of detailed project schedule, project schedule tracking and managing any deviations to ensure on time delivery of project.
• Design document reviews and identify and closure on risks, challenges.
• Prepare a comprehensive quality plan to ensure high quality delivery.
• Identify risk and mitigation plan and baseline the same along with involved stakeholders to minimize any adverse impact to the project.
• Track project scope, schedule, quality, resource requirements, financial risks, SLAs on a periodic basis, take corrective actions and communicate to all stakeholders as per communication plan.
• Schedule, monitor, review and control all project phases involving requirement gathering, design, development, testing and implementation.
• Build customer relationship by engaging regularly and being SPOC to the customer on project related activities, provide regular reports, value articulation and meet expectations.
• End to End bottom line responsibility of the project.

Technologies: Clarify 10.1, Oracle, Toad, MPP, Visio

Confidential

Developer

Responsibilities:

• Understand requirements (both functional and nonfunctional) by going through the specifications
• Impact analysis of the requirement gathered.
• Preparation of low level design based on details captured in High level design.
• Develop artifacts (Code, Documentation, Unit Test scripts) and conduct peer and group reviews.
• Participation in discussions with customers to gather scope information and perform analysis of scope.
• Prepare pseudo code in order to deliver design documents as per customer requirements.
• Preparation of detailed schedule for work packages by carefully analyzing the effort and dependencies (internal and external) and provide inputs to overall project schedule in order to ensure on time delivery of the project.
• Training project team members on project processes and provide inputs on process tailoring and quality goals.
• Ensure defect free deliveries in Production environment.

Technologies: Clarify 10.1, Pl/Sql, Perl

Confidential

Trainee

Responsibilities:

• Undergoing Confidential training in Open systems.
• Working on internal assignments and in-house projects.

Technologies: Clearbasic, Shell script, C, C++.