Resume

Sign in

Informatica MDM Devloper

Location:
Hartford, CT
Posted:
February 20, 2020

Contact this candidate

Resume:

PROFESSIONAL SUMMARY

Over ** + years of Strong experience in IT industry including 4+ years of Informatica experience. I have majorly worked on Hub configuration, Entity 360, Business Entity, IDD configuration, IDD User Exits, Web services development using SIF APIs.

I was also involved in Project analysis, Design, Development and Maintenance using technologies like Informatica MDM and Java/J2EE.

Configuring and maintaining various components of the MDM Hub including the schema, staging and landing tables, configuring base objects, Look ups, Display Package, Put Package and query groups

MDM Hub configurations - Creating match paths, match rules, match rule sets, system trust scores and trust score decay with Validation rules.

Creating mappings using cleanse functions to standardize data, custom JAVA cleanse functions to validate IDD fields and display custom error message

Involved in SIF integration to develop Restful Web Services for external applications to perform search match, Put, Get API calls against MDM Hub Data

Creating JAVA User Exits using SIF APIs to customize MDM Hub functionality.

Created and Configured Subject Areas and Subject Area Groups, related Base Object relationships with Subject Area relationships in IDD.

Created and Configured Business Entity Service in provisioning tool.

Experience in all aspects of project development life cycle – Product Road map, Project planning and estimation, Functional/Technical specification document, Design Document, Unit test plan, System test Plan, Implementation plan, Lead role in all phases involved in SDLC.

Expertise on Java/J2EE technologies (Core Java, JavaScript, JavaBeans, JDBC, Servlets, HTML, JSP, JSTL, EJB, Struts, AJAX), XML and SQL.

Experience with Object Oriented Design and Object Oriented Analysis, Complete System Life Cycle.

Excellent in Object Oriented Programming Concepts and Features, Design Patterns, Enterprise Integration Patterns, Data Structure, Functional Programming, Aspect Oriented Programming and Web Services.

Experience in using Spring Framework (Spring Core, Spring MVC, and Spring JDBC).

Understands technological trends and communicates effectively with IT developers.

Coordinate the testing cycle with the Business Analyst and Development Teams

Excellent in communicating at all levels of management with experience in coordinating various client meetings, seminars, presentations and group discussions

Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly

EDUCATION& TRAINING

Mater Of Computer Application

Certified SCJP[Sun Certified Java Programmer]

TECHNICAL SKILLS

EIM Tools: Informatica MDM Multi-Domain 9.x,10.2, IDD, SIF.

Sun Technologies: J2EE (Java 1.5 – 1.8, Servlets 2.4, JSP, JDBC and JMS)

Web Technologies: HTML, JHTML, CSS, XML and JavaScript, AJAX.

Web Servers: Web Sphere 7.1, WebLogic 10.3, Tomcat 7.X, 8.X .

Apache Projects: Log4j, Apache-Axis

RDBMS: Oracle 10g, 9x,MySql,

Source Control Management Tools: CVS, SVN, TFS, GitHub

Cloud:AWS.

Web services: Axis 1.5.2, JaxWS, Spring Web Service, RestfullWbservice.

Framework: Struts1.2, Spring 3.X

ORM Tools: Hibernate 3.4, Spring Jdbc Template.

Enterprise IDE : Eclipse.

PROFESSIONAL EXPERIENCE

Travelers – Hartford, CT July2019 - Till date

An eBus Master data Management for managing Enterprise master data for different source system and provide the ability to effectively establish Data Governance, consistency of Data across multiple Sources, which will help provide common standard information used for enterprise level business activities and also to provide the effective business intelligence. This includes work on development of Restful Web Services using SIF API from Informatica and Business Entity.

Role and Responsibilities: IDD Consultant

Created and configured Business entity services for Agency Data Management.

Implemented the RESTful webservice for the real time interaction with the downstream system Using SIF API.

Writing User Exits in MDM, this is beyond the capability of the tool.

Design and develop the Entity 360 application as per the Business requirement.

Participate in code reviews, preparation of test packages, release documentation, deployment Support representing development team.

Create BO, Stage, Landing tables and setting up relationships.

Create cleanse function and mapping

Set Trust values for different sources for each table as per business requirement.

Setup Match and merge rule functionality.

Hands on execution of MDM hub Batch Jobs (Stage, Load, Tokenize and Match Processes) and Batch Groups.

Environment: Informatic MDM 10.3, JBOSS, Oracle 11g, PL/SQL, TOAD, Trillium People Soft, Eclipse.

Performance Food Group – Richmond, VA July2017 - July 2019

An EDM Repository for managing Enterprise master data for Item, Vendor and Customer domain of PFG Enterprise to provide the ability to effectively establish Data Governance, consistency of Data across multiple Sources, which will help provide common standard information used for enterprise level business activities and also to provide the effective business intelligence. This includes work on development of Restfull Web Services using SIF API from Informatica and Customized User Exits (IDD and Hub console).

Role and Responsibilities: IDD Consultant

Created and configured Informatica Master Data Management (MDM) and Informatica Data Director (IDD) components i.e. Base objects, Staging tables, Landing tables, Mappings, Packages and Queries, Trust and Source System, Validation Rules, Match and Merge rule sets, Cleanse list, Cleanse functions, Hub user exits, IDD Subject Area group, Subject Area, Subject Area Child and Grandchild layout.

Performed Code Migration in Hub and also in IDD (by importing BDD Configuration files, Message bundles, Error code bundles and User Exits by clearing cache and redeploying the applications) to promote changes between all environments from development to production.

Implemented the RESTful webservice for the real time interaction with the downstream system Using SIF API.

Configuring Active VOS with Provisioning Tool for custom human tasks.

IDD-Active VOS integration for data submission and tasks creation.

Writing User Exits in MDM as well as IDD to support customized requirement, this is beyond the capability of the tool.

Design and develop the IDD application as per the Business requirement.

Provided Solutions for the Bulk Upload for Vendor and Item as per the Business requirement.

Participate in code reviews, preparation of test packages, release documentation, deployment Support representing development team.

Helped Java team in creating the Service Integration framework (SIF) for integrating into User interface application to provide Insert, Delete and real time matching and merging functionality.

Set Trust values for different sources for each table as per business requirement.

Environment: InformaticaMDM 9.7.1,10.2 Informatica Data Director, ActiveVOS 9.2.4.2,Informatica Power Center 9.1, JBOSS, Oracle 11g, PL/SQL, TOAD, Address Doctor Cloud, Eclipse.

Data Analytics of BI use cases for telco in India–Airtel, India Mar 2016-July 2017

Data Analysis and Reporting System is used for customer’s Call Details Record (CDR) analysis. This system suggest promotional offers and customized calling package based on customer call record. It is also using for capturing call drop record.

Study the Use case Requirement

Identification of impacted systems

Develop HLD

Provided solution description against each impacted system

Role and Responsibilities:

●Involved with ETL team in getting the data loaded into the landing tables.

●Created and configured Informatica Master Data Management (MDM) and Informatica Data Director (IDD) components i.e. Base objects, Staging tables, Landing tables according to the data model and number of source systems

●Defined the foreign key relationships among the base objects and defined look ups on the staging tables and packages, query groups and queries/custom queries

●Exported and Imported the IDD application changes from one environment to another

●Created new Mappings and Match rules

●Hands on execution of MDM hub Batch Jobs (Stage, Load, Tokenize and Match Processes) and Batch Groups

●Set Trust values for different sources for each table as per business requirement

●Develop the web services in getting the data loaded into the Hub from the external applications, Using the SIF put and cleanse put APIs.

●Created the customized Java cleanses function.

●Worked on HUB side user exits and IDD user exits to customize and validate the data flow according the business rules

●Implemented the approval process by enabling and disabling the buttons for subject areas in IDD, according to business rules and requirements

●Developed Oracle (PL/SQL) custom procedures to provide reports and data load stats, integrate into Informatica Master Data Batch groups.

●Finalized the Match Columns and Match Rules by performing Match Tuning.

●Configured the Composite services (Rest based web services) using Informatica Provisioning tool for internal User Interface interaction and publish to the downstream consumers.

DIGI DMS Jan 2015 to Mar 2016

Description:

The Objective of Distribution Management System is to provide an interface to DTR and Dealer through which they can create Purchase Order, Sales Order, track inventory, View profiles and manage Route activities as well. This system will be integrated with various other systems to facilitate the above tasks.

Client : DIGI Malaysia.

Role : Team Lead

Environment : Java/J2EE, Spring, Hibernate, PL/SQL,Oracle 9i,Web Services, Hibernate, SVN.

Responsibilities :Participated with business analysts and team members to analyze

Clientrequirementsand also documented SRS.

Designed and developed new requirement

DTAC- DMS, Thailand Feb 2013-Jan 2015

The DTAC which involves distributing and selling its products to distributor and point of sales channel by maintaining a route through channel and sub-channel system. The system ensures the smooth flow of business. It caters the need of different DTR’s by proving them update to date information. This drive will help them to manage the distribution channel effectively.The solution streamlines, automates and reports the following primary business transactions and business support processes:

Inventory Management

Purchase Order

Sales Order

Sales Invoice

Profile Management

Sales Organization Management

Location Management

De boarding

Role and Responsibilities: Technical Lead Java

Built an end to end JEE based solution using popular frameworks like Spring, Hibernate, MQ by applying OO design concepts, JEE &GoF design patterns, and best practices.

Designed the logical and physical data model, generated DDL scripts, and wrote DML scripts and procedure for Oracle 10 g Database.

Participate in code reviews, preparation of test packages, release documentation, deployment Support representing development team.

Supported various testing as per the specifications and test cases including Integration testing and Regression testing

PRM simplification – (Telenor India) Feb 2012-Dec2012

The Distribution Management System is an initiative taken by Uninor, which involves distributing and selling its products to distributor and point of sales channel. The system will enable the business to have supply chain visibility at the grass root level. This drive will help them to manage the distribution channel effectively.

Responsibilities:Development

Role and Responsibilities: JavaDeveloper

As application developer I worked on enhancement of the business logic and Struts framework with RESTful web services.

Supported various testing as per the specifications and test cases including Integration testing and Regression testing

Interact with production support personnel to ensure that critical and major production issues are resolved in a timely manner.

ENC Web Application –LnT Mumbai Jun2011 – Feb 2012

A web-based product procurement application for L&T – Engineering and Construction, with interactions with the SAP system via Web service. Improved cycle time by reducing manual process and paper work. The application enables the Buyers to publish Request for Quotes (RFQ) and Purchase Order (PO). Quotations submitted by various vendors are available to the Buyer and final quotation data flows to SAP via web service.

Role and Responsibilities: Senior Developer

Handling and Working on Major Enhancements

Gathering Requirements from Client

Handling Client Calls and Meetings

Prepared the Database Schema design Coding

Advanced Hospital Information Management System– CDAC INDIA Aug 2009 - May 2011

Details of AHIMS:

Healthcare is one of the most important aspects of human life. In C-DAC, HIS has been developed with the objective of streamlining the treatment flow of a patient in the hospital, while allowing doctors and other staff to perform to their peak ability, in an optimized and efficient manner.

The HIS developed by C-DAC is modular, thus ensuring sustained benefits through changes in technology, protecting and providing optimal returns from the investment. It is modeled on a unique combination of a patient centric and medical staff centric' paradigm, beneficial to the recipients and the providers of healthcare.

Module Name: Personal Information System (PIS)

Description:I have worked on the PIS System Process. At client end, I have completed the requirement analysis of PISSection for the Medical College SMS, Jaipur.

PIS Section: PersonalinformationSystem deals with various information related to recruitment, ServiceBook, Joining posting and transfers, Leaves, grant of increments, promotion, disciplinary cases and penalties, fixation of pay, change in the rate of allowance / deduction etc.

Vigilance Section:The Vigilance cell of PGIMER deals with the vigilance of various kinds of cases, reports to Chief Vigilance Commissioner of India and sends the recommendations to the concerned.

LegalCell:Legal Cell is responsible to represent PGIMER in court even though the case may be related to any particular department in PGIMER. It maintains record of writ petitions, court cases, monitors action required, decision taken, payment of advocates etc.

BUDGET Section:Budget shows the revenue received by the departments in various heads from different sources of income. Source of income is patient’s registration and re-registration, fee received from patients against various tests, house rent, swimming pool membership charges, Working Women’s Hostel charges, sale of various forms, interest received from banks on FD’s. The estimated receipt in budget is also given till 31st march of budgeting year.

Responsibilities: DevelopmentRole and Responsibilities: Developer

Successfully implemented various module using struts framework.

Supported various testing as per the specifications and test cases including Integration testing.

Interact with production support personnel to ensure that critical and major production issues are resolved in a timely manner.

National Physical Laboratory–NPL Delhi Aug 2008 – Jul 2009

NationalPhysical Laboratory is MIS Project from NPL Delhi branch of CSIR (Council of Scientific and Industrial Research) .MIS has been deployed with the objective of streamlining the manual work into single automated system for easy retrieval of information among different departments. The Solution is modular and effectively, synchronizes data It also allows reporting at various levels of user.

Role and Responsibilities: Senior Developer

Handling and Working on Major Enhancements

Handling Client Calls and Meetings

Prepared the Database Schema design Coding



Contact this candidate