Prathyusha Nayeni

adgogt@r.postjobfree.com

Ph.: 646-***-****

Over 6+ years of IT experience in Informatica Master Data Management Multi Domain, 10.3 HF1, 10.2, 10.1, Software Development Life Cycle (SDLC) analysis, design, development, testing, maintenance and quality assurance with implementation of software applications in MDM and Data warehousing.

Defining and configuring Base Objects, Staging Tables, Landing Tables, Look-ups, Foreign Key Relationship, Hierarchies, Queries, Query Groups and Display/PUT Packages.

Mapping data from Landing Tables to Staging Tables.

Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.

Using Informatica Service Integration Framework (SIF) to develop the web service for MDM processes.

Good understanding of MDM requirements from the business in achieving the BVT (Best Version of Truth) Record and publish to the downstream applications.

Configuring Subject Area Groups, Subject Areas in IDD.

Experience in Provisioning Tool 10.3 HF1.

Experience in C360 10.3 HF1.

Experience in developing the Business Entity Services for generating the API’s for real-time integration.

Good knowledge on full Software Development Life Cycle (SDLC) (designing, debugging, testing, documentation, maintenance and enhancement).

Experience in Analysis of Software Requirement Specifications, Creation of Test Plans and development of Test Scripts, Test Cases and executing them.

Extended experience in systems testing, integration testing, UAT testing, positive and negative, functionality testing, and regression testing.

Experience in all phases of Software Testing Life Cycle (STLC), Software Development Life Cycle (SDLC), Bug life Cycle and Methods like Waterfall and Agile

Experienced in using HP Interactive automated testing tools like Quick Test Pro and Quality Center

Proficient in using Quality Center, Rally, JIRA, Clear Quest, Bugzilla.

Experience with the test management tools (TFS/JIRA/QC)

Experience in writing the Test plans, Test Cases, Test Scenarios and Test Strategies for web and mobile (Apple & Android) as per requirements.

Good exposure to work culture and client interaction with diverse teams. Proven ability to learn quickly and apply new technologies.

Technical Skills:

Informatica Tools:

Informatica MDM Multi-Domain 10.2, 10.3 HF1, Provisioning Tool, C360, IDD, SIF

Cleanse Adapters:

Address Doctor 5.X

Database Tools:

Oracle 10g/11g, DB2, MYSQL, SQL Server

Test Management Tools:

Quick Test Pro, HP Quality Center, JIRA, Bugzilla

Operating System

Windows 2000/XP and Unix

Application/Web Servers:

Web Logic 10.3.6, JBoss EAP 6.2/6.4, IBM WebSphere 8.5

ETL Tool:

Informatica Power Center 9.6.1

Package:

MS Office(MS Access, MS Excel, Ms Power Point, MS Word).

Educational Qualifications:

Master’s in Information Systems from Stevens Henager College, Salt Lake City, Utah.

Bachelor’s in Electronics and Communication Engineering from Jawaharlal Nehru Technological University, Hyderabad, India.

Professional Experience

Informatica MDM Consultant, Dallas, TX Toyota Financial Services June 2019 –June 2020

Project: Toyota Financial Services (TFS) is using systems like Account Master, RMD, SGI, IDMS, CDS, CVA, CDT, SRM to store the Dealer information like – dealer details, address, insurance, tax, franchise, DSSO etc. These systems being distributed, do not provide a common platform that can leverage the information available in one system to be used across the board. Also, maintenance of data in these distributed systems has introduced duplicate/unused/incorrect/incomplete data over the years.

The goal of building the MDM Dealer Master system is to bring together the available data under a single platform. This new platform is expected to have only and only the data required for business purpose from its Release 1 Day 1 – that too in its cleanest form – with either the business entity relationships unchanged from the sources OR with relationship changes as per the TFS Re-Imagined initiative.

Responsibilities:

Integrated Customer data from different sources e.g. (Account Master, RMD, SGI, IDMS, CDS, CVA, CDT, SRM) to create a Dealer Master Data to get best version of truth as golden record.

Worked closely with IDQ team for loading the data into MDM staging tables.

Created and configured Base Objects, associated staging tables, lookup tables, mappings and transformations as per business requirements.

Configured foreign-key relationships, lookups, query groups, queries/custom queries and packages in MDM.

Configured the load jobs for every source system.

Created the Source to Target Mapping sheet.

Created the SQL scripts for loading the lookup tables data manually.

Knowledge on writing the Insert SQL Scripts for loading the data into the staging tables from the excel file.

Created the CDC Scripts for loading the data on the scheduled time from Staging tables to Base objects.

Created the Business Entity Services (BES) for developing the API’s for real-time integration.

Created the C360 UI Screens by using Provisioning Tool version 10.3 HF1.

Created the Business Entities (BE’s), Business Entity Views (BE View), BE to BE View Transformations, BE View to BE Transformations, and Layouts in Provisioning tool.

Configured the Address Doctor Web Service in MDM Hub and called in the Provisioning tool for cleansing the data.

Created Subject Areas in IDD for showing the Hierarchy diagram in C360.

Developed the Hierarchy of Dealer data in C360 using the Provisioning tool.

Given demos for the business users how to use the C360 screens.

Manual Deployment of the code from lower environment to higher environment.

Involved in the Production deployment and deployed the code to Production Environment manually.

Knowledge on loading the data from IDQ tables to MDM Stage tables.

Worked on EDC Catalogs manually like Structural Meaning Catalog, Data Catalog, Interface Catalog, Application Catalog, and Data Provence Catalog.

Knowledge on JENKINS for automatic deployment.

Gave the Knowledge Transfer for newly joined developers.

Gave the presentations on the C360 UI Screens for the business users for better understanding and usage.

Environments: Informatica MDM 10.3 HF1, Oracle 11g, IDQ, IDD, Provisioning Tool 10.3 HF1, C360 10.3 HF1, SOAP UI, Windows

Informatica MDM Consultant, Boston, MA Vertex Pharmaceuticals July 2018 –March 2019

Project: Vertex is a global biotechnology company that invests in scientific innovation to create transformative medicines for people with serious and life-threatening diseases. Vertex creates new possibilities in medicine to cure diseases and improve people's lives. It works with leading researchers, doctors, public health experts and other collaborators who share our vision for transforming the lives of people with serious diseases, their families and society.

Responsibilities:

Installed and Configured Informatica MDM Hub Server, Cleanse Server, Resource Kit, Cleanse adapter, IDD.

Worked with ETL Developers in creating External Batches to execute mappings to integrate data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub.

Created and configured Base Objects, associated staging tables, mappings and transformations as per business requirements.

Configured mapping with cleanse functions including Address Doctor before running the stage job.

Involved in designing, documenting and configuring Informatica Data Director for supporting management of MDM data.

Configured foreign-key relationships, lookups, query groups, queries/custom queries and packages in MDM.

Configured match paths, match columns, match rule sets and match rules according to the requirement.

Configuration and creation of landing and staging tables for newly added sources.

Added new sources to the existing MDM implementation.

Used Data manager and merge manager tools under Data Steward workbench to manually merge and unmerge records.

Defined the Trust and Validation rules and setting up the auto match/merge rule sets to get the right master records (BVT). Configured match rule set property by enabling search by rules in MDM according to Business Rules.

Environments: Informatica MDM 10.1, Oracle 11g, Address Doctor, Informatica Power Center/Analyst 9.5.1, SOAP UI, Windows

Informatica MDM Consultant Symantec, California March 2017 – June 2018

Project: Symantec around the world are developing technologies and building solutions to help customers secure and manage their information. Project involves the implementation of a Customer Master solution for the Enterprise Data Management (EDM) projects initiative. Objective of this solution is to improve customer data quality, prevent duplicate creation & Provide single identity for a given customer site.

Responsibilities:

Integrated Customer data from different sources e.g. (ERP, R12, NAM, SFDC ETC...) to create a Customer Master Data to get best version of truth as golden record.

Successfully completed the Hub configuration phase to deployment of the project.

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

Involved in creating, monitoring, modifying, & communicating the project plan with other team members.

Performed match/merge and ran match rules to check the effectiveness of MDM process on data.

Used 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 Multidomain MDM 10.1, Informatica Power Center 9.6.1, Informatica Data Quality 9.6.1, Web logic 12c, Oracle 11g, SQL Developer.

QA Analyst (MDM) Zimmer, Georgia April 2016 – February 2017

Responsibilities: As a team member, key activities performed includes

Understanding Business Requirements and providing test estimates. Creating, updating and reviewing test plan, test strategy, test cases, test scripts, test data and functional test matrix.

Working on Agile development environment.

Maintaining stable test and production environment, creating test cycle, executing tests, defect tracking and analyzing test results for the projects.

Performing functional, Integration and System testing and UAT testing.

Created Data warehouse test plans, UAT plans, test cases based on the ETL mapping document and functional design documents.

Extensively used SQL queries to perform database validation and automated the SQL scripts for re-usability.

Tested ETL mappings to extract and load data from different databases such as Oracle, SQL Server, XML files and flat files and loaded them into Oracle.

Generating testing status report and retrospection document and distributing to all project stake holders.

Effective utilization of QC by designing and developing the test cases for the entire product using Test Plan module in QC.

Involved in Risk Management (Identifying and mitigating the risks associated with testing).

Interacting with the development group and proposing solutions to minimize the defects and deliver quality project.

Managed End-To-End System Testing Manually.

Performed Database testing to verify the data using SQL to ensure integrity and consistency of data.

Experience in working with multiple efforts and delivered quality projects.

Environment: HP Quality center 9, Informatica 9.01, QTP 10.0, JIRA, UNIX, SQL Server, Oracle 10g, Windows 7 and MS Excel

Manual Tester Quomation Insurance Services, Utah November 2015 – April 2016

Responsibilities: As a team member, key activities performed includes

Performed manual testing on insurance application.

Tested application like Power Quote, Power Manage that gave the insurance quote to the clients.

Requirement gathering for testing through building test plans to execute test cases.

Participated in design reviews and quality inspections for each release.

Writing Test Plan, Test Cases and Test Scripts.

Participated in System Testing, Regression Testing and Interface Testing.

Prepared Test Data and performed Positive and Negative testing.

Created Test plans – Test cases for GUI, Regression and functional testing.

Execution of test cases, verification the actual results against the expected results and documenting in the test plan.

Analyzing specifications, identified data and test requirements, developing QA test plan and ensuring its proper and timely execution from functional specification documents.

Used HP Quality Center for viewing and analyzing test results and for defect tracking and reporting which occurred during execution of test scripts.

Tested the release builds and released the bug free applications.

Used the JIRA to log the bugs and report to the application teams.

Environment: .Net, SQL, HP Quality Centre, Microsoft Excel, JIRA

Manual Tester Dega Software Technologies, India January 2013 – August 2015

Project: Property Manager Application is designed to help single-family, low density and small residential property managers operate more efficiently daily. It provides online property marketing, management and accounting software for web-based property management. This Property Manager Team and mobile platform will provide world-class services to grow the business of the landlord, fee manager, or an asset manager of real estate owned properties and keep the tenants and owners happy.

Property Manager is designed to replace the patchwork of property management solutions with one single integrated platform. With all the data stored in the property management cloud, we can access it anytime with an internet connection. Customers can have all the information they need at their fingertips as they share leases, work order status, rental documents, owner statements and communications through customized customer portals for owners and tenants. Property Manager can help to fill more vacancies, renew more leases, save time, cut costs and boost profits.

Responsibilities:

Created Test plan & Script, Defect Management Templates and created Initial test plan and developed test cases and test scripts manually.

Used Quality Center to store all testing results, metrics, created Test Cases, and Reporting.

Reviewed Business requirements, IT Design documents and prepared Test Plans which involved various Test Cases for all assigned module/projects; Review Test Requirements, Creating Test Plans and Test Strategy documents.

Developed a Defects Tracking Log for the SharePoint Site to track defects while testing.

Involved in UAT testing, Regression Testing and Functional testing.

Daily update and managed offshore team.

Organized Test Plan during initial phase of project, prepared test scripts, created Release note in Application Lifecycle Management (ALM), setup/link Test Lab with release cycle, executed test cases and recorded results in ALM.

Wrote Structure Query Language (SQL) queries to check proper data population in application table and for data verification to perform Backend Testing against Oracle Database

Prepared meeting notes on daily execution/highlight of the project and send out the reports to managements.

Interact with Developers and Business Analysts to perform various types of testing throughout Software Testing Life Cycle (STLC) and Bug Life Cycle (BLC).

Involved with Trainer's training calls by presenting every project's new enhancements and functionality changes for the Branch Users.

Provided weekly status updates showing the progress of the Manual testing effort and open issues to be resolved.

Environment: Manual Testing, JIRA, Bugzilla, SQL, UAT Testing, Regression Testing, Functional testing, White Box and Black Box testing, STLC, Microsoft Excel.

Contact this candidate