We provide IT Staff Augmentation Services!

Test Data Management Architect Resume

SUMMARY

  • Over 13 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 TDM / Grid - Tools (Datamaker, Fast Data Masker, GTSubset etc), IBM Optim, Talend
  • 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

  • Delphix - Data virtualization & masking
  • CA Grid-Tool components - Fast Data Masker, Datamaker, GTSubset
  • IBM OPTIM
  • Talend Open Studio
  • TOAD data point
  • COBOL
  • DB2
  • Oracle 11g
  • SPUFI
  • Mainframe JCL
  • SQL Server
  • HP Application Lifecycle Management
  • HP Quick Test Professional
  • MS Access
  • VBA for MS Excel and Word

PROFESSIONAL EXPERIENCE

Test Data Management Architect

Confidential

Responsibilities:

  • Prepare detailed roadmap and strategy for test data management solution implementation at enterprise level in Confidential ’s non production environments
  • Work closely with data privacy and information security team to secure production data copied into non production environments by masking sensitive PHI-PII data elements as defined by HIPPA privacy standards
  • Identify PHI columns in the table by running the data profiler and map the masking algorithms to PHI cols using rulesets
  • As TDM architect understand the application architecture, interfaces, external vendor dependencies to prepare data flow diagram for large programs and initiatives
  • 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
  • Manage various Delphix admin related activities such as
  • Delphix engine configuration
  • Create db user & add/validate source & target environments
  • Provision, refresh and rewinding VDB
  • Create VDB template
  • 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

Hire Now