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
2017.04 - 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
2014.11 - 2017.03

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
2013.04 - 2014.10

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
2011.06 - 2013.03

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
2006.10 - 2011.05

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
2017.04 - Current

TDM Engineer

Tata Consultancy Services
2014.11 - 2017.03

Onshore QA Lead

Tata Consultancy Services Ltd
2013.04 - 2014.10

Offshore QA Lead

Tata Consultancy Services Ltd
2011.06 - 2013.03

Automation Engineer

Infosys Technologies Ltd
2006.10 - 2011.05

PG Diploma in Information Technology - Information Technology

Symbiosis University

BCA - Bachelor of Computer Applications

RKM Vivekananda College
Prabhuraj Kuppan