Test Data Management Architect Resume

EXECUTIVE SUMMARY:

Over 12 years of overall IT experience specializing in leading and executing testing projects of various sizes, providing Test Data Management solutions using TDM tools such as Delphix, CA Grid - Tools (Datamaker, Fast Data Masker, GTSubset etc), IBM Optim
Defined TDM strategy based on client environment and data governance policy
Setup Test Data Warehouse gold copy architecture
Defined masking rules after performing PHI analysis on sensitive information (PII & PHI)
Prepared subset extract files to extract sliced data from production down to pre-production environments
Microsoft SQL Developer and IBM Cognos BI 10 Data warehouse developer certified
Have experience in project management, TDM solutions consulting, Business requirements gathering and analysis, team leading, onsite-offshore coordination.
Have experience in team management activities such as client billing, budget forecasting, preparation of estimation model, team mentoring.
Possess very good understanding on the project lifecycle and carries a strong sense of commitment
Strong knowledge on Banking and finance - Trade Finance, Retail banking, Loans and mortgages.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Test Data Management Architect

Confidential

Responsibilities:

Partner with Delphix vendor to coordinate and install Delphix tool for one of the clients Test Data Management portfolio
Develop a detailed roadmap and strategy to meet the objectives of clients' TDM goals w.r.t Delphix tool
Understand the client database architecture, interfaces & external dependencies and then review the functionalities of the tool and its capabilities on data virtualization and masking so that it can be currently plugged into the client environment seamlessly
Identify PHI columns in the table by running the data profiler and map the masking algorithms to PHI cols using rulesets
Conduct Scrum meetings with all stakeholders to drive and accomplish tasks related to Delphix tool implementation

Test Data Management Manager

Confidential

Responsibilities:

Study and understand client environment & database architecture
Define and build Test data Management framework by designing Test Data Warehouse gold copy architecture
Preparing a comprehensive and detailed project plan on implementing GridTools as the standalone end-to-end solution for all test data management requirements at an enterprise level
Perform PHI analysis on production data and identify sensitive columns in tables for obfuscation
Configuration and implementation of masking rules using GridTools for all core data sources
Perform data profiling to identify sub setting criteria and prepare subset extract scripts
Reporting and Coordinating with GridTools support team on the deficiencies of the tool and ensure complete customization of the tool based on the client’s database architecture
Estimating and Budgeting cost for TDM deliverables and operational activity services
Coordinating with DBA and release management team on data refresh and masking activities in pre-production environments.
Reporting of weekly/monthly project status, progress and metrics to clients
Feasibility analysis of synthetic data creation using GridTools

Data Analyst

Confidential

Responsibilities:

Setting up Test data management framework for data request and data reservation
Test Data Requirements gathering, review, extraction and provisioning, metrics reporting
Understanding & analysis of Data model of database of various applications of a leading bank
Define the test data strategy after analyzing different portfolios/applications groups
Identifying any gaps/lack of processes, key areas for improvement in overall TDM. Define processes, templates, guidelines and checklists to formalize them.
Setup test environments by loading subset data extracted from production environment using IBM OPTIM
Prepare & Execute SQL queries using TOAD data point. Extract data to provide to various testing teams
Perform data profiling to check for the consistency of data across databases of different applications. This is done by extracting reports of frequently asked data using JCL after each data refresh in every test environment.
Prepare data with the objective of reusability across various phases of testing
Conditioning of data using QTP automation script during non-availability of data for a scenario

Test Analyst

Confidential

Responsibilities:

Create functional and non-functional requirements documents
Prepare the Requirements Traceability Matrix
Estimate effort, prepare test plan and provide inputs to test PM for the Test Strategy definition of the project using knowledge of requirements, testing environment, tools used.
Develop/validate test design consisting of scenarios, types of testing
Review complex test case scenarios.
Validate results of test cases executed by junior members and participate in defect triages using knowledge of test execution process, test requirements and business criticality.
Ensure that the offshore counterpart is kept updated regularly and support supervisor in client interactions and reporting to the customer on the identified parameters on a regular basis.
Support the team wherever required for resolving any issues related to deliverables and provide inputs on critical capabilities.
Review knowledge management activities in the project to help track and improve knowledge management within the project and leverage information from other projects.
Provide relevant data on metrics for assigned modules.
Defect management
Process Improvements and custom automated tools (macro) development to increase the overall testing productivity
Adhering to organization testing quality standards and guidelines