SUMMARY

• 7 years of IT industry experience with close to 3 years of MDM experience helping clients in the Analysis, Design, Development, Implementation and Deployment of Informatica MDM applications, processes and services.
• Worked with Solutions Architects and Data Stewards to deliver MDM requirements related to Business Processes and MDM Program Vision.
• Comprehensive understanding of Master Data Management concepts, methodologies and adeptness to apply this knowledge in building MDM solutions.
• MDM Hub and related configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica/Business Data Director, Entity360, Provisioning Tool, BE Workflows, ActiveVOS, UserExits.
• Defining and configuring schemas, landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries, packages, batch jobs and groups.
• Expertise in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• Experience in improving the data quality by Match analysis, analysis of the MDM system performance and tuning the performance by changing the existing cleanse function, match rules etc.
• Implementing Hierarchy Manager to depict various hierarchies by creating Entity Base Objects, Hierarchies, Foreign Key Relationship Objects, Relationship Base Objects, Packages and Profiles.
• Configuring Informatica Data Director (IDD) to meet Data Governance objectives in project life cycles.
• MDM Hub Code review, deployment, promotion across various development environments and manage code base to meet organization’s coding standards.
• Performing data standardization of addresses using Address Doctor on MDM and on IDQ.
• Experience in performing data profiling using data quality tools as developer and analyst.
• Extensive experience in Java for user exits development and MDM real-time & batch integrations with source systems using Web Services (SOAP, REST, SOA) and rest apis.
• Extensive experience in designing web applications with the help of HTML, HTML5, XML, XHTML, CSS, CSS3, DOM, JavaScript and JQuery.
• Hands on experience working with Informatica Data Integration-Quality products like Power Center, Developer and IDQ Analyst.
• Excellent communication skills, team player, quick learner and self-motivated.

TECHNICAL SKILLS

Informatica MDM Tools: Informatica MDM 9.7,10.X (MDM Hub, Informatica Data Director, SIF, Message Queues)

Application Servers: Web Logic 10.x/9.x, JBoss, IBM WebSphere 8.X

Database Systems: Oracle 11g, 10g/9i/8i, MS Access, SQL Server 2005/2008, IBM DB2, Mongo DB, Teradata

ETL / Data Quality Tools: Informatica Power center 9.X(Designer, Workflow Manager), SSIS, Informatica Data Quality 9.X/10.X

Programming Skills: Java, SQL, PL/SQL, MDX, Python, Java Script and VB

Cleanse Adapter: Address Doctor 5.X

Cloud Platforms: Amazon Web Services/ Informatica Cloud

Web Programming: HTML, HTML 5, XML, XHTML, JavaScript, CSS CSS3, Responsive Web Design, Bootstrap, JSON, JQuery, Ajax, Angular JS, React and Angular 4

Web Servers: Microsoft Internet Information Server (IIS) 5.0/4.0/3.0 & Tomcat

Operating Systems: Server 2003/ 2008/2012 , XP, UNIX, LINUX, CITRIX

Applications: Microsoft Visual Studio, MS Office Suite (Word, Excel, Power-point, Access)

Other: Web Storm, PL/SQL Developer, ERWIN 4.0/7.0, TFS, GIT, Eclipse

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Informatica MDM Consultant

Responsibilities:

• Worked with JDA MDM Product Owners, Business Teams, Analysts and Architects to understand Business requirement and translate it into technical requirements from a documentation perspective to enable development of MDM solutions.
• Utilized Informatica Data Quality to assist in the profiling of Source Data utilizing Analyst and Developer Tool.
• The KPI metrics of the profiled data was presented to Business users to make data model related decisions and documented the data model definitions for logical and physical names.
• Implemented data model that is suitable for JDA business model for Product and customer.
• Utilized Power Center resources to create mappings from source to MDM landing table transformations leveraging all capabilities.
• Configured Landing and staging and base objects and mapping to load data from landing to staging’s.
• Created Hierarchies for Customer and Product in MDM while configuring the Data Model that includes the creation of Entity Base Objects, Relationship Base Objects, Entities, Profiles, Hierarchy Packages.
• Created IDD application, which users can see the data and data stewards can steward the data.
• Created batch groups to run the regular loads and initial load and these batch groups and built power center mapping to call the batch groups through web service call.
• Executed & Analyzed Data Loads from Source to landing tables, landing to staging tables and MDM loads constantly gauging performance tuning & making recommendations.
• Participated in match and merge rule discussions and implemented the same according the business needs.
• Implemented near real time functionality as part of incremental load as per business needs.
• Provided training to various business users on the product and how to use the IDD and other required needs.

Environment: Informatica MDM Multi-domain9.7/10.1, Informatica Power center/Analyst 9.6, Power exchange, SQL Server, Oracle 11g, Address Doctor, Microsoft Visio, Sales force, CRM, Workday financial & Jira.

Confidential, Fort Worth, TX

Informatica MDM Developer

Responsibilities:

• Interacted with the Business Users & Enterprise Data Architects in the analysis & design of Conceptual and logical data model that is required for solid MDM implementation & ensuring that it meets the business requirements and supports the products capabilities
• Performed Data profiling of reference data for large data sets using Informatica Data Analyst tool.
• Configured and installed Informatica MDM Hub server version 9.6 for SQL SERVER 2012, cleanse, resource kit, and Address Doctor5 in all the Environments.
• Configured Address Doctor which can cleanse whole world address Data and enhanced by making some modifications during installation
• Defined the HUB Base objects, Staging tables, foreign key relationships, static lookups, and dynamic lookups, queries, packages and query groups.
• Created Informatica Power center ETL mappings & ran sessions and workflows to execute the Land Process of loading the customer/product Data Set into Informatica MDM Hub using ETL tool that was coming from various source systems
• Worked on data cleansing and standardization using cleanse functions, cleanse lists and creating custom cleanse functions (Attribute functions and Object functions) in Informatica MDM.
• Perform MDM hub store upgrade, cleanse server upgrade from 9.6 to 9.7.
• Configured match rules and rule sets property by enabling search by rules in MDM according to Business Rules
• Implemented IDD applications based on subject areas and subject area groups for search requests for Customer model
• Created and documented the secure resources, roles, users for roles, and assigned privileges to roles using Security Access Manager in development environment.
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production.

Environment: Informatica MDM 9.6 / 9.7, Informatica Data Director, Informatica Data Quality 9.1.0, Informatica Power Center, JBoss, Microsoft SQL Server, Address Doctor, DB Visualizer, Windows server 2003, Erwin.

Confidential, Atlanta, GA

Informatica Master Data Management Consultant

Responsibilities:

• Communicated with multiple cross functional internal and external teams like External Hub Data Vendors, Customer Data Warehouse, and Information Management System Units in successfully aligning the UAT Publish Process on the life cycle Reference Data Management Process. Kl
• Designed Queries and mentored offshore resources in building Test Cases (Validation SQL Queries) to verify data across File Systems, MDM System and Data Warehouses.
• Paid attention to detail in Match Tuning process particularly in the verification of Percentage of Records that matched for the Customers from different systems
• Ensured Individual Data Files were accurately updated with latest External Vendor supplied Data prior to kicking off MDM Jobs
• Executed Jobs from external Source Systems to populate the MDM Landing Tables; performed Count Validation on weekly data publish
• Manually ran weekly Staging, Load, Match, Auto merge and Auto match & Merge Jobs for Consolidating Master Records for Customer Data using Match All (Match Rule Sets)
• Addressed data issues on match results by Creating External Match Jobs to correct and re publish Master Data
• Analyzed and Published MDM Reports like “No of Physicians per Product” and Prescriber ID’s that were inactivated with each load during MDM process
• Reported Back Observations made on the Patient Status & Sales Record Counts to External Data Vendors.

Environment: Informatica MDM 9.7(HUB/Cleanse), Informatica Data Director (IDD/User Interface), IBM Data Stage(ETL), Oracle 10g(Database), PL SQL Developer, Oracle Web logic Server

Confidential, Providence, RI

Java Full Stack Consultant

Responsibilities:

• Responsible for creating the look and feel of a Web Application.
• Worked with business analysts and state to understand their business models, goals and help define strategy, content, and features.
• Worked on screens that were developed using HTML5, CSS3, JavaScript, JQuery and AngularJS.
• Developed Custom Directives and Filters using Angular.
• Worked on Bootstrap for developing the application screens.
• Created Angular services to communicate with Backend and Restful services.
• Worked on third party plugin such as Passport API for a single sign on.
• Implemented Lazy Loading and Routing.
• Worked on Oracle SQL database
• Responsible for Migrating Data from CV6 To Production.
• Used Jasmine to write test cases and Karma for testing the test case.
• Used SVN for version control.

Environment: HTML5, Angular JS, CSS3, JavaScript, TDD, jQuery, Jasmine, Web Services, JSON, SVN, Java, WebSphere, Deloitte Log4J Proprietary Framework.

Confidential

MEAN Stack Developer

Responsibilities:

• Responsible for creating the look and feel of a Hybrid Web Application.
• Worked with business analysts to understand their business models, goals and help define strategy, content, and features.
• Worked on screens that were developed using HTML5, CSS3, JavaScript, JQuery and AngularJS, Angular Material.
• Use NodeJS to write server side logic.
• Created Angular services to communicate with Backend and Restful services.
• Worked on Google Map API for geo location services.
• Implemented Lazy Loading and Routing.
• Worked on NOSQL database MongoDB.

Environment: HTML5, Angular JS, CSS3, JavaScript, TDD, jQuery, Jasmine, Web Services, JSON, GitHub, Node, Express, Mongo, Mean.

Confidential

MEAN Stack Developer

Responsibilities:

• Responsible for creating the look and feel of a Hybrid Web Application.
• Worked with business analysts to understand their business models, goals and help define strategy, content, and features.
• Worked on screens that were developed using HTML5, CSS3, JavaScript, JQuery and AngularJS, Angular Material.
• Use NodeJS to write server side logic.
• Created Angular services to communicate with Backend and Restful services.
• Worked on Google Map API for geo location services.
• Implemented Lazy Loading and Routing.
• Worked on NOSQL database MongoDB

Environment: HTML5, Angular JS, CSS3, JavaScript, TDD, jQuery, Jasmine, Web Services, JSON, GitHub, Node, Express, Mongo, Mean.

Confidential

Web Application Developer

Responsibilities:

• Worked on screens that were developed using HTML5, CSS3, JavaScript, JQuery and AngularJS
• Developed and implemented user interfaces as per latest W3C standards.
• Developed client side validation code using HTML/HTML5, CSS2/3, JavaScript, jQuery and Responsive Web Design
• Designed applications that execute on various browsers such as Internet Explorer, Mozilla Firefox, Google Chrome and Opera using various debugging tools like Firebugs/IE Developer Tools.
• Developed several REST web services and used JSON as a data exchange format.
• Extensively used/modified JQuery to perform AJAX calls for creating interactive web pages on JSON response.
• Currently using GIT as version control and stash for managing GIT repository.
• Worked with business analysts to understand their business models and goals and help define strategy, content, and features.
• Participated in day-to-day meeting, status meeting, strong reporting and effective communication with project manager and developers.

Environment: HTML5, Angular JS, CSS3, JavaScript, jQuery, Jasmine, AJAX Controls, Web Services, JSON, Oracle11g, DB2, GitHub.

Confidential

SQL Developer

Responsibilities:

• Implement changes usingtables, indexes, stored procedures, views, etc.
• Performedprofilinganddata cleaningactivities.
• Design and development of database creation and upgrade scripts.
• Reorganized thedatabase structureto generate / provide reports on a regular and required fashion.
• Generated reports on daily basis in a standardized reporting format usingSQL Queries.
• Refined and tuned the existing queries to meet the business needs.

Environment: Oracle 10G, PL/SQL, SQL, TOAD, Windows.