SUMMARY PROFILE:

Over * Years of experience in gathering requirements, designing and developing applications in SAS MDM (Dataflux), Oracle MDM (Customer Data Hub) and Informatica MDM as a Functional and Technical developer. I have the US H1 visa valid till April,2020.

●Experience in Informatica Master Data Management practices and concepts. Experience working with business functions to gather requirements, design/implement solutions and development.

●Good knowledge of Master Data domains, such as Customer, Vendor and Item Master Data.

●Experience in Mastering data for Retail, Insurance and Health Care industries.

●Hands on Knowledge of Informatica MDM including IDD, HM, Match / Merge Process, various models of MDM implementation.

●Experience in MDM configuration, business rules, batch jobs, real time data loads, security management SAM, hierarchy management.

●Development skills having IDD configuration and customizations as per business needs- Experience with troubleshooting the Informatica MDM technology.

●Good Knowledge of Core Java Development experience, working with JMS queues/topics for publishing/subscribing data.

●Good knowledge on message queues, Services Integration Framework SIF, Active VOS.

●Experience in understanding End to End Architecture and working with other teams to fix the issues.

●Experience in multiple MDM tools such as SASMDM, DATAFLUX, ORACLE MDM (CDH) and Informatica MDM.

●Good knowledge on data quality tools like Data flux, Oracle EDQ and IDQ.

●Designed and developed complicated jobs and packages for Delta loading, customer creation and update in DATAFLUX DFPower studio, ORACLE CDH and Informatica MDM.

●Experience in pulling data from multiple source system and loading into MDM HUB.

●Experience in defining the business rules, validation and cluster condition on the data assets to achieve master data management “single version of truth”

●Experience in Defining Concurrent Programs, Request Sets, and Executables.

●Experience in creation of PL\SQL Packages, Procedures and Functions.

●In depth knowledge in MDM concepts, Data Profiling, Data Staging, Cleansing, Clustering, Data Migration, Data Match and Merge.

●Experience in Oracle EBusiness suite 12i integrated environment

●Undergone Corporate Training for Data Warehousing Concepts, INFORMATICA Power center, SAS DI, ODI, Hadoop, Hive, Pig and MapReduce.

●Exposure and working experience in all phases of SDLC like Requirements definition, Analysis & Design, Development, Testing and Deployment.

●Experience in training Client end users in the testing methodology, procedures and tools used to perform testing.

●Assists in enforcement of project deadlines and schedules.

●Analyze the data migrations/Conversions, Mappings and collaborate with Business Users and developers to analyze Business and functional requirements

●Verify and Validate the Upstream Systems to allow for creating and entering different new transactions in Systems.

CERTIFICATIONS:

●Completed HCL Oracle Database 11g SQL fundamentals certification

EDUCATION:

●B.Tech - Bachelor of Technology in Information science and Technology with 7.42 CGPA, Koneru Lakshmaiah College of Engineering, India.

●Intermediate in M.P.C with 93.1%, Sri Chaitanya, Guntur, Andhra Pradesh in 2007.

●10th with 93.3%, Viveka Public School, Tenali, Andhra Pradesh in 2005.

CURRENT PROFILE:

●Currently working as Project Lead in L&T Infotech, Bangalore.

TECHNICAL PROFILE:

Operating Systems: AIX 5.0, Windows, MAC

Languages: Java, SQL, PL/SQL, Shell Scripts and XML

Databases: Oracle, SQL Server.

Web Applications/Servers: WebLogic, JBOSS

Tools: SAS MDM, Oracle MDM (CDH or Customer Data Hub), Informatica MDM

Others: Informatica ETL, SAS DI, ODI, Hadoop, IDD

PROFESSIONAL EXPERIENCE:

EXPERIENCE HIGHLIGHTS

L&T Infotech

Project Lead

Project # 1 Nov 2016 – till date

J&J Health Care Service MDM Practice:

Responsibilities:

●Monitoring and troubleshooting ETL jobs and MDM Jobs.

●Experience in build reusable SQL and PL/SQL code for reports,inbound and outbound integration.

●Manage changes and service requests in IRIS service management tool.

●Profile, design and implement new data feeds into MDM.

●Work with Infrastructure Operations teams to coordinate routine maintenance activities such as patches and troubleshoot issues related to MDM system.

●Experience in doing Master data changes, Match & Merge from Backend as per user request.

●Participation in requirement analysis and preparing case studies.

●Experience in Training and helping team to on MDM configurations and issues.

Software Used: Informatica MDM 10.1, Informatica PowerCenter, SQL & PLSQL

Syntel

Technical Specialist

Project # 2 Sep 2016 – Nov 2016

MDM Practice:

Responsibilities:

• Experience in Installing Informatica MDM 10.1 and ActiveVOS in server and local.

• Experience in exploring new features in Informatica MDM 10.1.

• Experience in Working on mock projects to get projects.

• Participation in requirement analysis and preparing case studies.

• Training associates to configure MDM and IDD.

Software Used: Informatica MDM 10.1, IDD

UST Global

SYSTEMS ANALYST

Project # 3 May 2016 – Aug 2016

MDM Bench:

Responsibilities:

• Understanding the requirements and designing.

• Understanding the Client Application and data Model.

• Understanding the end-to-end process of the project

• Identifying the gaps in existing model.

Software Used: Oracle MDM, Oracle EDQ

HCL TECHNOLOGIES LTD

SENIOR SOFTWARE ENGINEER

Project # 4

PFG: May 2014 – May 2016

Senior Developer

PFG (Performance Food Group) – Performance Food Group Company (PFGC) is the company that distributes a range of food products. The project is to setup an enterprise master data system providing a common enterprise HUB containing standardized data elements and one CRUD process for customer, item & Vendor. To consolidate enterprise data from diverse legacy system & provide a centralized single source of master data information for Customer, Item and Vendor domains.

Responsibilities:

●Experience working with business functions to gather requirements, design/implement solutions and development.

●Experience in creating Base Objects, Landing and Staging Tables.

●Experience in configuring Cleanse Functions, mappings for stage process.

●Experience in configuring Match rule sets, Match Columns for Match and Merge Process and Hierarchy.

●Experience in defining System Trust and Validation rules for base object column

●Experience in Creating and deploying applications in Informatica Data Director and binding application to a specific ORS

●Good knowledge on SAM configuration & Both MDM & IDD User Exits.

●Experience in Creating Queries, Query Groups and packages in MDM Hub Console.

●Identifying the gaps in requirement and being part of preparing HLD & LLD documents.

●Travelled onsite to interact with bussiness.

●Experience in working closely with ActiveVOS and ETL team to implement solution.

●Knowledge on Address doctor, Message Queues, SIF and ActiveVOS.

Software Used: Informatica MDM 9.7.1, IDD, User Exists, ActiveVOS

Project # 5

Reed Exhibitions: Oct’ 2012 – April 2014 Senior Developer

Reed Exhibitions- Reed Exhibitions primary focus is business-to-business events, although it also runs a small number of consumer events. Reed’s main industry sectors are: aerospace & aviation, automobiles, beauty & cosmetics, broadcasting, building & construction, electronics, energy, oil & gas, engineering & manufacturing, food service & hospitality, gifts, healthcare, interior design, IT & telecoms, jewelry, life science & pharmaceuticals, machinery, marketing, business services & training, medical education, printing & graphics, security & safety, sports & recreation and travel.

This Project involves loading of the Customers data into CDH and maintains Master and Unique records. Generation of reports and export files for the downstream application to migrate the data into their respective databases. The changes made to the Customers data in the CDH should reflect in the respective applications

Responsibilities:

• Understanding the requirements and designing accordingly.

• Understanding the Client Application and data Model

• Understanding the end-to-end process of the project and designing as per downstream requirements.

• Identifying the gaps in requirement

• Development of PL/SQL Packages for CRUD (Create, Update and Get) operations.

• Coordinating with Other Tracks for Integration.

• Development of De-dupe and diff Match scenarios.

• Worked on Bulk Load.

• Experience in defining Concurrent Programs, Request Sets, and SQLLoader.

Software Used: Oracle MDM (CDH or Customer Data Management)

Project # 6

SBIG (SBI General Insurance) Nov’2011 – Sep’ 2012

Developer

SBIG SAS MDM Implementation - SBI General Insurance is a competitive General Insurance for all properties of party. This project involves implementation of Customer Master and Location Master at Common Hub ensuring unique records are maintained for the same [Customer here has multiple roles such as Agent, Broker Dealer, Surveyor etc; Location ID is the risk address for the property getting insured]. Solution is based on SAS qMDM, DataFlux BRM and QKB. Business Rules Manager is implemented as part of decoupled solution where all the rules can be defined centrally and can be accessed by any COTS application. The Rules Manager is handy and can be handled even by business users. Real Time Synchronization with COTS applications through ESB. It’s a Green Field Environment.

Responsibilities:

•Understanding the requirements and designing accordingly.

•Creation of the Meta data file and data model designs.

•Involved in developing various DataFlux jobs for implementing the various services provided by MDM for SBIGI like Creating, Updating, searching a Party

•Involved in developing SQL scripts to create Tables, Views, Triggers, Functions and Procedures.

•Involved in developing Standardization jobs, generating match codes, Initial Data Load from staging table to target tables

•Standardization of Data using QKB (Quality Knowledge Base)

•Preparing SQL scripts to collect data from legacy systems of NIC

•Preparing jobs using Data Flux for Data profiling, Clustering and Data quality analysis.

•Responsible for creating repositories, Developed business rules for Party Master using DataFlux Business Rules Manager

•Involved in bug fixing and enhancements. As part of this, actively worked from offshore with the onsite developers providing solutions to the tasks assigned

•Communicating with testers, giving clarifications and resolving the problems

•Involved in developing jobs, PL/SQL Triggers for Data Steward Functionality from Scratch. Given training/presentation on Data Steward to SBIG.

•Involved in developing PL/SQL Scripts for House Hold Functionality and House Hold Publisher Program using JAVA and delivered and integrated with CRM.

•Development and enhancement of MDM Web Service and LOV Application (Reference Data).

•Involved in peer discussions with client and other tracks.

Software Used: SAS MDM, Oracle 10g, Data Flux.

Contact this candidate