P.Srinivasulu. EmailID:ac50cn@r.postjobfree.com.

Mob No: +91-944*******.

Informatica MDM Developer

Summary: -

Having 5 years of experience in Informatica MDM, Informatica Power center, IDQ, Oracle and data warehouse.

Having experience in client location in onshore and offshore development.

Having experience in lead the MDM offshore team.

Having Experience in Informatica MDM. Design, develop, test and review & optimize Informatica MDM (Siperian).

Expertise in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.

Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties.

Expertise in Batch viewer jobs and Batch Group creation, auto command batch execution and scheduling.

Expertise in Provisioning tool/IDD and Business Entity creation and customization queries, Packages and relationships etc.

Expertise in SIF services implementing and testing in SoapUI.

Expertise in BES Both SOAP and REST services with JSON and XML coding for BES composite services like WADL/WSDL in SoapUI and creating documentation.

Expertise in REST services JSON coding.

User exists development by using eclipse.

Having experience in Message queue & Address Doctor configuration.

Good experience on Technical Document Design for end to end review and all kind of documentation for development implementations

Configuring Informatica Data Director (IDD) and Entity 360 to meet Data Governance objectives in many project life cycles.

Configuring Provisioning UI and Customer 360 to meet Data Governance objectives in many project life cycles.

Migrating the code between different env and white box and black box testing scripts for testing team and supporting offshore Java and Etl teams.

Having experience in IDQ both developer tool,analyst tool and Power center i.e transformations, mappings, services, workflow and profiling etc.

I was trained and having experience on Agile methodology and Jira dashboard.

Having experience in training internal and giving KT for client team.

Trained on Informatica Cloud Real Time(ICRT) integration.

Excellent communication, interpersonal, training internal and client developers, analytical and technical skills.

Professional Experience: -

Working as a Software Developer for ACENTURE SOLUTIONS PVT LTD, Maharastra, Pune, Magarpatta City from October 2016 to till date.

Working as a Software Consultant for TATA CONSULTANCY SERVICES, Siruseri, Chennai from April 2016 to October 2016.

Worked as a Technical Staff in GoFrugal Technology Pvt Ltd from Oct 2013 to Mar 2016.

Education Details: -

B.Tech in Electronics & Communication Engineering in 2013 from JNTU with 74.5 %.

Inter in Board of Intermediate from Himaja Jr College in 2009 with 81.1%.

SSC from ZP High School passed out in 2007 with 81%.

Project #1:

Project Name : TELUS Omni MDM

Client : TELUS

Role : Software Developer

Duration : October 2016 – Till Date

Environment : Informatica MDM 10.2, Oracle 11g.Windows server, IDQ 10.2, Providing UI & Customer 360 .

Project Description: -

Telus Communications (stylized as TELUS) is a Canadian national telecommunications company that provides a wide range of telecommunications products and services including internet access, voice, entertainment, healthcare, video, and IPTV television. The company is based in the Vancouver, British Columbia area; it was originally based in Edmonton, Alberta, before its merger with BCTel in 1999. Telus's wireless division, Telus Mobility, offers HSPA+, and LTE-based mobile phone networks. Telus is the incumbent local exchange carrier in British Columbia and Alberta. Telus's primary competitors are Shaw Communications in the Western provinces, and Bell Canada and Vidéotron General Partnership in Quebec.

Responsibilities:

Visited the client place and given demo on proof of concept (POC) model as per their major challenges and we got the project finalized after the demo.

Involved in the solution from scratch with latest versioned tools.

Implementing the IDQ mapping and profiling.

Creating documenting for all kind of development such and landing and staging and mappings and JSON code and overall Technical Documenting.

Migration from one environment to other environments and user and roles creating and migration with latest tool.

Creating landing, staging tables and base object and queries and packages.

Configuring mappings and cleanse functions and loading the data from scratch and reference lookup data.

Configuring the match and merge rules and running the jobs and creating the batch groups.

Hierarchy configuration.

Provisioning UI implementation such Business entity creating and customizing.

Expert in creating SIF and BES composite services in both SOAP and REST calls i;e WSDL and WADL.

Collaborating the clients from different location and sharing the knowledge on daily basis and giving KT to internal team.

Project #1:

Project Name : BA Customer MDM

Client : British Airways(BA)

Role : Software Consultant

Duration : April 2016 – October 2016

Environment : Informatica MDM 10.1 HF3, Oracle 11g.Windows server, IDD & Power center.

Project Description: -

International Consolidated Airlines Group, S.A., often shortened to IAG, is a British-Spanish multinational airline holding company with its operational headquarters in London, England, United Kingdom and registered in Madrid, Spain. extending its services and product portfolio, such as catering benefits to loyal customers, and offering services and products with considerable added value for the targeted group.

Responsibilities:

Create Landing, staging and Base Objects.

Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.

Using Informatica MDM Hub to run Batch jobs

Loading data from Informatica MDM Landing to Stage

Configuring the mappings between landing to staging and applying cleanse functions.

Define requirements for data matching and merging rules, and data stewardship workflows.

Provided Trainings to Team members.

Designing data hierarchy management for Informatica MDM.

Technical document design.

Executing jobs in Batch Viewer and Batch Group.

The Mappings were Unit tested to check for the expected results.

SIF services and troubleshooting and sending report to the concern team if any job fails and analyzing the errors and rejected reasons.

User groups and roles creating and assigning to groups.

Migrating one ORS to another ORS.

Loading the reference data through data manager.

Creating queries and packages and customization and privileges for IDD.

IDD Configuration and migration and design.

Project #2

Project Name : McAfee ONE MDM

Client : McAfee

Role : Informatica MDM Offshore Lead

Duration : Jul 2014 – Mar 2016

Environment : Informatica MDM 9.7, Informatica Power Center 9.x,, Oracle 10g.

Project Description: -

ONE MDM is an operational data store, which collects the transactional sales data from the various upstream systems, validates, processes, and provides the quota countable data to a downstream system to calculate the compensation for Sales Representatives. ONE MDM provides sales compensation to its direct/ indirect Sales Customers and Channel Partners.

Responsibilities: -

Responsible for offshore MDM deliverables.

Create Landing, staging and Base Objects.

Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.

Using Informatica MDM Hub to run Batch jobs

Loading data from Informatica MDM Landing to Stage

Configuring the mappings between landing to staging and applying cleanse functions.

Define requirements for data matching and merging rules, and data stewardship workflows.

Provided Trainings to Team members.

Designing data hierarchy management for Informatica MDM.

Technical document design.

Executing jobs in Batch Viewer and Batch Group.

The Mappings were Unit tested to check for the expected results.

SIF services and troubleshooting and sending report to the concern team if any job fails and analyzing the errors and rejected reasons.

User groups and roles creating and assigning to groups.

Migrating one ORS to another ORS.

Loading the reference data through data manager.

Creating queries and packages and customization and privileges for IDD.

Project #3

Project Name : Zo Ho Sales Rep Incentives.

Client : Zo Ho, USA.

Role : Informatica Developer

Duration : Oct 2103 – June 2014

Environment : Informatica Power Center 9.x,Oracle 11g.

Project Description:

Zoho corporation, found in 1996, is a technology company based in California which provides SAAS services. Until 2003, the company’s business focused only on large and enterprise class customers. During the slowdown in 2003, and as a plan to bring in more, the company ventured into SMB market by offering commercial IT management products which were either stripped of their WebNMS framework, or built on top of WebNMS codebase. The company marketed their IT management products under the Manage Engine branding. The Manage Engine became

Responsibilities: -

Used Source Analyzer and Warehouse Designer to import the source and target database schemas and the Mapping Designer to map the sources to the target.

Created Reusable transformations and mapplets.

ETL implementation for designing.

Used different types of transformations like Source Qualifier, filter, Rank, Aggregator, Expression, Unconnected Lookup, Router.

Preparation of mapping documents by automation scripts using repository view concepts.

Performed data analysis for finding out the data issues and reporting it to clients.

Created Database estimation documents for Oracle.

Designed and implemented various transformations using Informatica Designer.

Extraction, Transformation and loading of data from flat file and Oracle sources.

Prepared some unit test cases for testing the data.

Created and monitored sessions using Informatica Workflow Manager and Workflow Monitor.

Responsibilities: -

Date of Birth 15/06/1991

Marital Status Single

Nationality Indian

Passport Number M2224927

Pan Card Number: CBMPP3917J

Languages Known: English, Telugu, Tamil and Hindi.

Address for Communication: Dr no:30, tansi nagar,Velachery, Chennai,600042.

Declaration: -

I do here by confirm that the information given in this form is true to the best of my

Knowledge and belief.

(P.Srinivasulu).

Contact this candidate