Web Services Data Quality

PROFESSIONAL SUMMARY

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

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

Expertise in Entity 360, Business Entity services and BESExternalCall and SIF Framework.

Configuring and maintaining various components of the MDM Hub including the Base Object creation,

Staging and Landing tables, cleanse function, custom package and SAM configuration.

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.

Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.

Experience in IDQ profiling, design and implementing data quality rule and publishing.

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.

Analysis of data using Python.

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.

EDUCATION& TRAINING

Mater Of Computer Application

Certified SCJP[Sun Certified Java Programmer]

TECHNICAL SKILLS

EIM Tools: Informatica MDM Multi-Domain 9.x,10.5, IDD, SIF, BES, Entity 360.

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 19c, 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

AIG (American International Group), New York Oct 2023 – Till Date

The project is to create MDM and RDM systems to maintain the party and policy information stored in various systems to MDM. RDM system to capture the reference data across various systems and standardize so that all the teams use the same nomenclature across the company. The ETL team needs to load the data to oracle staging and the informatica MDM will run the match merge process to create the golden record.

Role and Responsibilities: Informatica MDM Architect

Configured Business entity services for Project requirement.

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

Analysis to add new source system and perform corresponding changes in MDM Hub.

Create cleanse function as per business requirement.

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

Create payload to perform the post operation.

Defining of Match merge rules, survivorship, trust and validation rules.

Implemented the data model in MDM applied the match and merge rules.

Working experience on SIF API on Soap.

Implemented ActiveVOS workflows to create and update individual records, which could be triggered by custom REST API calls in Postman.

Developed ActiveVOS workflows to create Human tasks depending on Product data updated in Entity 360, and publish those records to downstream applications.

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

Attending Scrum calls, task refinement session, PI planning, updating rally tool for task

estimation

Environment: Informatic MDM 10.5, Provisioning Tool, WebLogic, Oracle, PL/SQL, Java, ActiveVOS, Toad, Postman, java 1.8

U.S. Food and Drug Administration (FDA) Sept 2021 – Oct 2023

Supporting Integrity service, in the current role. Integrity services was institutionalized to implement support for challenges faced in data management. The users need support as their requirements are unique, this diverse need is addressed by Integrity service.

Role and Responsibilities: Informatica MDM Consultant

Configured Business entity services for Project requirement.

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

Create cleanse function as per business requirement.

Implemented custom business validations in Branch & Address domains using Business Entity Services such as ReadCO, WriteCO, ReadView, WriteView in MDM 10.5.

Developed and implemented ETL mappings using different transformations.

Involved in ETL Mappings and extensively used various Transformations like Source Qualifier, Aggregator, Lookup, Filter, Update Strategy, Expression, Sequence generator and Sorter etc.

Implement Performance Tuning techniques to load and cleanse huge volume of data at the mapping level, mapplet/rule level, source level, and the target level; follow the best practices as per Informatica World. Support to land data to make a golden copy using MDM.

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

Create payload to perform the post operation.

Analysis of data using Python.

Environment: Informatic MDM 10.4, Provisioning Tool, WebLogic, Oracle, PL/SQL, Core Java, Spring, Python

Silicon Valley Bank, Tempe - AZ Dec 2020 – May 2021

SVB Master Data Management (MDM) is a workflow-driven process in which business units and IT collaborate to harmonize, cleanse, publish the data to downstream system.

The application interfaces with several external applications to source the data. It has the capability to cleanse, de-duplicate and validate the data. The application has interfaces with several downstream systems to provide data feeds.

Role and Responsibilities: Informatica MDM Consultant

Monitoring the AWS jobs

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.

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

Created and configured Business entity services for Customer Data Management.

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

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

Implement BES External call using java 1.8 standard.

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

Environment: Informatic MDM 10.2, Provisioning Tool,Weblogic, Oracle 12c, PL/SQL, Java 1.8, IICS, AWS, IDQ

Johnson & Johnson, NJ June 2020 – Dec 2020

Johnson & Johnson Master Data Management (MDM) is a workflow-driven process in which business units and IT collaborate to harmonize, cleanse, publish and protect information assets that are shared across the enterprise. Currently MDM stores data for Customer, Product and Sales Force Alignments.

The application interfaces with several external applications to source the data. It has the capability to cleanse, de-duplicate and validate the data. The application has interfaces with several downstream systems to provide data feeds.

Role and Responsibilities: Informatica MDM Consultant

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.

Created and configured Business entity services for Customer Data Management.

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

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

Implement BES External call using java 1.8 standard.

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

Environment: Informatic MDM 10.2, Provisioning Tool,Weblogic, Oracle 12c, MBOX, PL/SQL,Java, TOAD, Trillium People Soft, Eclipse, MBOX.

Travelers – Hartford, CT July2019 –March 2020

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: Informatica MDM Consultant

Created and configured Business entity services for Agency Data Management.

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

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

Responsible for converting the business requirement into Web Services Using Microservice Architecture.

Design and develop the Entity 360 application, Business Entity Services and BESExternalCallas 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 MDM10.3, Provisioning Tool,JBOSS, Oracle 11g, PL/SQL, TOAD, Trillium People Soft, Eclipse.

Performance Food Group – Richmond, VA July2017 -July2019

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: Informatica MDM Developer

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.

Developed ActiveVOS workflows to update records, create Human tasks, and publish records to downstream apps.

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, 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-July2017

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: MDM Devloper

●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 Malaysia Jan2015 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.

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-Jan2015

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.

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 2010- 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.

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.

Contact this candidate