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.
• 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.
• Creation of queries, packages, creation and configuration of Subject areas for IDD.
• 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.

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.
• 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.
• 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++.