Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Prabhuraj Kuppan

Chennai

Summary

• Overall 17+ years of IT industry experience with expertise in Test Data Management and Quality Assurance.

8+ of Experience in Test Data Management

• Successful implementation of Informatica TDM tool for Test Data Management, Data Privacy in testing environments for insurance clients

• Served the roles of TDM solution Architect, TDM Consultant, TDM Engineer, Quality Assurance Manager and Automation Engineer

• Experience in client Landscape Assessment, TDM Strategy building, effort estimation, staffing Subset criteria parametrization, data profiling, masking and synthetic generation

• Extensive working experience in Informatica TDM and Powercenter tools.

Working knowledge of TDM tools like GenRocket, Talend Open studio, Delphix, Broadcom TDM, Qlik Z Gold client tools.

• Handled multiple applications on different data sources like DB2, Oracle, SQL Server, CSV files, Flat files, XML files, Mongo DB, Couch DB.

• Created Mapping and workflows in Informatica TDM tool for TDM services like Subset, Masking, synthetic generation

• Presented TDM strategy, Sub Setting, Masking, Synthetic generation solutions, POC demos to multiple clients in Insurance, Retail, Health care clients

• Collaborated with TDM tool companies like Informatica, CA TDM, Delphix, Genrocket and Qlik to facilitate Tool sales and procurement

• Collaborated with application teams to understand and document Application Architecture, Configuration, Dependencies, Data sources, Services and other interactions.

Overview

18
18
years of professional experience
1
1
Certification

Work History

TDM Architect

Tata Consultancy Services Limited
04.2017 - Current

Participate and respond to proposals and RFP for clients across Insurance, Retail and Health care domains.

As a Test Data Management Architect and consultant, roles and responsibilities are,

  • Perform TDM assessments, identify gaps and propose recommendations and strategy.
  • Taking care of expediting Data Refreshes across data bases, typically from higher environment (PROD) to lower environments.
  • Pro-Actively Collaborate with on-going project teams and assist them with their appropriate Test Data Needs
  • Regularly Audit lower environment databases to ensure no PHI or PII data is left unmasked
  • Conduct weekly meetings with Data Governance team to discuss about maintaining data in lower environment databases
  • Develop masking algorithms for various data sources and archiving them for regular re-use
  • Collaborate with Business and project teams to understand their needs for Synthetic data and generate same for load testing
  • Develop and archive SQL Scripts developed by team for various test data scenarios for efficient re-use during multiple levels of testing
  • Collaborate with Business and project teams to define strategy for Archival and purging of historical data

TDM Engineer

Tata Consultancy Services
11.2014 - 03.2017

The Hartford Insurance company one of the largest Auto and Home insurance providers in the US. Tata Consultancy Services, as a vendor delivers Test Data Management services to the client.


As a Test Data Management Engineer, I was responsible to,

- Provision and Supply relevant test data to the Business, Developers and Testing team to expedite their testing

- Perform Data Refreshes for Distributed systems like Oracle, MS SQL Server

- Search and flag the PHI and PII information in the databases

- Apply data masking to the PHI and PII Information flagged in the lower environments using Informatica TDM tool

- Create the Access Definitions, Column maps and data masking functions for repeated masking requests

- Analyze and expedite Data Refresh requests for distributed systems

- Perform Data Sub-setting, Selective Data Refresh wherever applicable to avoid frequent full refreshes and parametrize subset criteria

- Collaborate with Business Analyst and Project teams to understand their test data needs before even the development starts

- Analyze Batch jobs and setup data in intermediate flat files for service or program level testing.

Onshore QA Lead

Tata Consultancy Services Ltd
04.2013 - 10.2014

Best Buy Inc, one of the largest electronics retailer in US and Canada headquartered in Richfield, Minnesota USA.

Tata Consultancy Services, as a vendor delivers Quality Assurance services to the client.

As a Onshore Test Lead, I was responsible to:

- Understand the functional requirements and prepare testing strategy

- Devised specifications for processes.

- Reviewed Test cases and provided feedback

- Performed testing on RF devices which could not tested from Offshore location

- Mentored and encouraged employees to strive for excellence while fostering professional growth.

- Incorporated delivery requirements into planning of testing schedules.

- Evaluated quality problems and performed assessments to identify and resolve issues.

- Improved customer satisfaction with thorough validation of user requirements during the testing process.

- Gathered data on integration issues and vulnerabilities, reported findings and recommended improvements.

- Kept scripts and test cases updated with current requirements.

- Recommended changes and corrections to developers for optimal software performance and usability.

- Updated quality control standards, methods, and procedures to meet compliance requirements.

- Provided observations, took measurements, and performed tests at various stages according to quality control plan.

- Advised developers on problems with databases, performance and other issues.

- Increased customer satisfaction through adherence to quality standards and customer requirements.

Offshore QA Lead

Tata Consultancy Services Ltd
06.2011 - 03.2013

Worked as QA Lead for Multiple Customers like Target corporation, Marks & Spencer, The Hartford Insurance Company.

Tata Consultancy services was a vendor delivering Quality Assurance services to the clients.

As a Offshore QA lead, I was responsible to:

- Led cross-functional teams to ensure seamless collaboration in achieving project goals.

- Reduced defect leakage by effectively conducting regression testing after each release cycle.

- Evaluated quality problems and performed assessments to identify and resolve issues.

- Advised developers on problems with databases, performance and other issues.

- Test effort estimation and staffing

- Managed offshore Testing deliverables

- Daily status reporting

Automation Engineer

Infosys Technologies Ltd
10.2006 - 05.2011

Worked as QA and Test Automation Engineer for multiple client like

All State Insurance Company, Trizetto Corporation.

Tata Consultancy Services was vendor providing Quality Assurance services to the clients

As a QA and Test Automation Engineer, I'm responsible to:

- Improved software quality by designing and implementing automated testing solutions.

- Created plans for test method validation using research or field observations.

- Authored and maintained well-organized, efficient and successful manual test cases for entire team.

- Reduced manual testing efforts for faster product delivery by incorporating test automation frameworks.

- Created Automation scripts using BDD framework using currently called Microfocus UFT tool.

- Tested, identified and troubleshot problems with networks.

- Documented testing procedures for developers and future testing use.

- Kept scripts and test cases updated with current requirements.

- Reviewed, evaluated, and identified requirements for testability.

Education

PG Diploma in Information Technology - Information Technology

Symbiosis University
Tamil Nadu
04.2012

BCA - Bachelor of Computer Applications

RKM Vivekananda College
Chennai
04.2004

Skills

  • Test Data management consulting, solutioning and implementation
  • Testing and debugging
  • Good Knowledge on SQL
  • Informatica TDM
  • Talend Open studio
  • Delphix
  • Broadcom TDM
  • GenRocket
  • Informatica Powercenter
  • TOAD
  • MS SQL Server
  • MYSQL
  • Mongo DB
  • Couchbase DB

Certification


- Genrocket certified Engineer

Timeline

TDM Architect

Tata Consultancy Services Limited
04.2017 - Current

TDM Engineer

Tata Consultancy Services
11.2014 - 03.2017

Onshore QA Lead

Tata Consultancy Services Ltd
04.2013 - 10.2014

Offshore QA Lead

Tata Consultancy Services Ltd
06.2011 - 03.2013

Automation Engineer

Infosys Technologies Ltd
10.2006 - 05.2011

PG Diploma in Information Technology - Information Technology

Symbiosis University

BCA - Bachelor of Computer Applications

RKM Vivekananda College
Prabhuraj Kuppan