SUMMARY:

• Informatica Certified in MDM Hub with IT experience in Software Development Life Cycle (SDLC) analysis, design, development, testing, maintenance and quality assurance with implementation of software applications in MDM, PIM and Data warehousing
• Experience in Master Data Management and Informatica Product Information Management concepts, Informatica Product 360, Information MDM methodologies and ability to apply this knowledge in building MDM and PIM solutions
• Experience in Installing, Configuring core Informatica/Siperian MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, Data Modeling
• Experience working on Informatica MDM to design, develop, test and review & optimize Informatica MDM (Siperian)
• Experience in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation
• Experience in creation and maintenance of entity objects, hierarchies, entity types, relationship objects
• Experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign key relationships, lookups, query groups, queries/custom queries and packages.
• Experience in creatingIDDapplication as per the business needs and Bulk Import integration by creating the subject area and subject area groups
• Experience in ImplementingHierarchy ManagerModule in addition to Match/Merge/Unmerge which aids in depicting various hierarchies
• Experience in designingmappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets
• Experience in designing and developing Informatica mappings for data loads that include Source Qualifier, Aggregator, Unconnected Lookup, Connected Lookup, Filter, Router, Update Strategy etc.
• Experience in working on installation, configuration enhancements and managing of Informatica PIM.
• Experience in designing and implementing the mappings for Import using data sheets to Informatica PIM based on the fields in Active Catalog
• Designing and Implementing the Export profiles and Export format templates to extract the data from PIM to Publish
• Creating user profile in Product Information Management tool and well understood knowledge in user access groups
• Experience in installed and configured Smart Search in all the environments
• Experience in debugging, error handling and performance tuning of sources, targets, mappings and sessions with the help of error logs generated by Informatica server
• Experience in enabling Searchable columns as per the business need
• Experience working on Control M scheduler.
• Experience working on Oracle Product Data Hub v12.2.
• Experience working on DocuSign CFR Part 11 and DocuSign Non CFR Part11 system.
• Experience in Agile, Waterfall and UML Methodologies
• Good Exposure to development, testing, debugging, implementation, documentation and Production Support
• Responsible for unit testing of the work done
• Experience in Production Support to resolve critical issues and mingle with teams to ensure successful resolution of the reported incident

TECHNICAL SKILLS:

EIM Tools: Informatica PIM 360, Informatica MDM 10.2/10.1, IDD, SIF

Programming Language: C, C++, Java, SQL, XML, PL/SQL, JavaScript, Java Beans, JSP, .Net and PHP

Web Technologies & Services: HTML, DHTML, CSS and XML,SOAP & RESTful Web Services

RDBMS: PostgreSQL, Oracle 10g, Oracle 11g, SQL Server and MYSQL

Development tools: Eclipse Oxygen, IntelliJ, NetBeans, PL/SQL Developer, SQL Server Management Studio, SOAP UI

Application Servers: JBoss 6.4, WebLogic, WebSphere

Operating Systems: Ubuntu, Windows XP/7/8/10, Unix, Linux

Microsoft Office Suite: MS Word/Excel/PowerPoint/Outlook

Methodologies Used: Agile(Scrum), Waterfall

PROFESSIONAL EXPERIENCE:

INFORMATICA MDM DEVELOPER

Confidential, Franklin Lakes, NJ

Responsibilities:

• Work on Informatica MDM 9.1 and 10.x Hub development - sources, base objects, staging, mappings, match rules, message triggers, query and packages.
• Lead the effort to implement, develop and train on a Master Data Management system and maintenance process for member master data.
• Providing MDM functional leadership to ensure all data consumers are following the standard process and achieving data quality metrics through regular meetings.
• Assisting with the development and refinement of MDM strategy.
• Facilitating requests for changes to the MDM subject areas to manage the requests.
• Managing workflow within the MDM system identifying and correcting bottlenecks, etc.
• Creating data model and subject areas in MDM/IDD.
• Collaborating with various business as well as technical teams for Development, Quality Assurance Testing, Production Support operations, etc.
• Work on creating and configuring various landing tables in MDM Hub, get the batch data from the source system, and put it in those landing tables.
• Creating and configuring the Staging tables for each source system and move all the data from the landing tables to the staging tables, called staging process.
• Creating and configuring Mappings so that the data that is coming into the MDM maps according to the final data that is going out from MDM as per business requirements.
• Creating and configuring Base Objects which will be the final tables in the MDM.
• Production support and maintenance, handling User maintained tables for Confidential, Data discrepancies issues, find the root cause, analyze and put fixes to prevent the reoccurrences.
• Attending the CAB meeting and making sure those MDM deployments does not affect any other teams and vice versa as well.
• Involvement in UAT and mentoring business regarding new changes in system.
• Work on SQL Stored procedures and SQL queries.
• Work with business to understand business processes and requirements.
• Work on Control M v9.0 Scheduler tool
• Day to day administration of Control M server and its component and ensure continuity of business services.
• Order and Monitor jobs in Control M on Windows.
• Manage job flows, calendar requirement and scheduling criteria.
• Creating and scheduling jobs on Control M tool in both Test and Production environment.
• Work on Service Now tool for all scheduling requests for Production, Incidents and Change requests
• Work on Oracle Product Data Hub v12.2.
• Modified the existing code/flow to functional setups to include new attribute groups to Product Family.
• Work on setting up enable user access and update the Product Family in different Organizations.
• Work on DocuSign CFR Part 11 and DocuSign Non CFR system and creating user access for client users.
• Work on sending and signing documents using DocuSign Application and generate reports.
• Create the Technical Solutions Design Document for the project after conducting a thorough analysis of the documented business requirements.
• Coordinate with Offshore team.

INFORMATICA MDM/PIM DEVELOPER

Confidential, Atlanta, GA

Responsibilities:

• Monitoring the scheduled jobs, memory utilization and performance of the application
• Designing and creating BO, staging tables, mappings, transformations as per business requirements
• Creating mappings to perform the tasks such as cleansing the data and populate that into staging tables
• Using Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment
• Worked with SIF API to interact with real time applications
• Identified Golden Record (BVT) for Client Data by analyzing the data and duplicate records (in MTCH and HMRG tables) coming from different source systems.
• CreatedIDDapplication as per the business needs and Bulk Import integration by creating the subject area and subject area groups
• ImplementedHierarchy ManagerModule in addition to Match/Merge/Unmerge which aids in depicting various hierarchies
• Designing and implementing the mappings for Import using data sheets to Informatica PIM based on the fields in Active Catalog
• Designing and Implementing the Export profiles and Export format templates to extract the data from PIM to Publish
• Working on Integrating Informatica PIM 8.0 for processing tasks related to Item creation and Item Maintenance
• Creating user profile in Product Information Management tool and well understood knowledge in user access groups
• Creating Static and Dynamic Enumerations and performing several LOV refresh activities.
• Experience on multiple perspectives on Product Information Management like Data transfer perspectives such as Import, Export, Merge and Data Maintenance Perspectives such as Structure group assignments, Multimedia attachments, Prices, Attribute assignment and also Publications such as Export Format Templates
• Working on Management perspectives such as User management, Units, Process Overviews, Workflows, Organization
• Hands on Data Quality perspective, in creating DQ rules within different channels and Data quality scheduling
• Configuring the Security Checks for the fields into the repository file.
• Configuring the repository files according to the requirements
• Create and maintain new business rules, validation rules and workflows within the PIM software
• Configuring QA Pre Production and Production environments for PIM.
• Communicating with Product Stake holders and Business users regarding Business Impacts and future changes in application

ENIRONMENT: Informatica MDM - Product 360, SQL Server, Oracle DB, Microsoft SQL Server Management Studio, Eclipse, JBoss 6.4, Windows Cloud servers, Java Development Kit 1.8

INFORMATICA MDM DEVELOPER

Confidential, Houston, TX

Responsibilities:

• Installation and Configuration of JBOSS Application Server, Informatica MDM Hub Console, Hub Server, Cleanse Match Server (Process Server), Resource Kit, Upgrading Master and User Specific ORS
• Understand the key business requirements of client and performed Data Analysis and abstracted the transactional nature of data.
• Analyzed the source systems for erroneous, duplicative, and integrity issues related to the data, created match rules for removing duplicates.
• Worked on Informatica MDM to design, develop, test and review & optimize Informatica MDM
• Created Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation
• Creation and maintained of entity objects, hierarchies, entity types, relationship objects
• Designed and configured of landing tables, staging tables, base objects, hierarchies, foreign key relationships, lookups, query groups, queries/custom queries and packages.
• Identified Golden Record (BVT) for Client Data by analyzing the data and duplicate records (in MTCH and HMRG tables) coming from different source systems.
• Successfully, setup the data and configured the components needed by Hierarchy Manager for MDM HUB implementation which included implementing hierarchies, relationships types, packages and profiles by using hierarchies’ tool in model workbench.
• Successfully implemented IDD using hierarchy configuration and subject area groups, subject areas, subject area child, IDD display packages in hub and search queries for searching the data.
• Created Unit Test Case Document, Technical Design Document, Informatica MDM Hub batch process, Informatica Hub and IDD Migration Request Document

Environment: Informatica MDM 10.2, 10.1, Provisioning Tool, IDD, Smart Search, SQL Server 2008/2016,, JBoss 6.4, SOAP UI, Eclipse, Windows Server 2008/2012

INFORMATICA MDM CONSULTANT

Confidential, Mountain View, CA

Responsibilities:

• Worked in integrating customer data from different sources e.g. (ERP, R12, SFDC etc...) to create Customer Master Data to acquire unsurpassed version of truth as golden recordr.
• Productively engaged in the Hub configuration phase till deployment of the project.
• Offered services in defining the landing tables, staging tables, and configured base objects
• Defined foreign-key relationships, lookups, query groups and queries
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records. Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Captured even the minute details in creating, monitoring, modifying, & communicating the project plan with other team members.
• Implemented match/merge and ran match rules to check the effectiveness of MDM process on data.
• Utilized Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Created Unit Test Case Document, Technical Design Document, Data Validation document and Knowledge Transfer Document.

Environment: Informatica MDM 10.2, Informatica Power Center 9.6.1, JBoss 6.4, Oracle 11g, SQL Developer

JAVA DEVELOPER

Confidential

Responsibilities:

• Experience in all periods of Software Development Life Cycle (SDLC) including Analysis, Design, Development, Debugging and Enhancements ofJava/J2EE Applications
• Developed java server-side components, which includes JSP, Servlets
• Responsible for unit testing of the work done
• Experience in Web Application Development and Designing
• Involved in front-end Development by utilizing JSP, HTML5, CSS3, JavaScript, AJAX, JQuery, Bootstrap3
• Implementing rendering of task from functionality usingJava, JSP, JSTL, Custom Tags, and CustomJavaclass Loader, XML
• Compiled and generated WAR and JAR files using ANT
• Developed Test Cases and Unit Tests for functionality testing using JUnit
• Experience in working with Web Services using REST, SOAP and WSDL
• Hand-on Experience with different IDE's such as IntelliJ, Eclipse, NetBeans
• Assisted in maintaining and updating existing applications and modules
• Contributed to the development of client side and server-side codes for external and internal web applications. Aided and support to programming team members as required

Environment: s: Java, HTML, CSS, CSS3, JavaScript, jQuery, Angular JS Framework, Node JS, ExtJS, JSON, Google Analytics, CS5, Apache web services, Adobe Illustrator, Oracle 11g, Agile, WordPress, Eclipse IDE, PHP, GitHub, Visio, Notepad ++.