Data Test
Resume:
Vinod Gourani E-mail: ******.*****@*****.***
TDM Lead Mobile: +1-224-***-****
Experience Summary
Having 12 Plus years of experience in Test Data Management, ETL QA,API, Linux/Unix, Client/Server, Database, Salesforce, ETL, and Web based applications.
Professional Summary:
Managing TDM Team and Setting quality standards and metrics for the current project.
Experience in Designing Solutions for Different Databases and files.
Experience in Implementation, Development, Administration and Configuration of CA TDM.
Good experience in Data Discovery, Data Profiling, Modeling and Analyses
Experience in Synthetic Data Generating, Data masking and Data Subset with available TDM tools.
Experienced in Creating and Managing Seed Data for TDM needs.
Good Experience in TDM artifacts from QA to Test/Prod
Experienced in TDM DevOps Integration.
Experience in generation data for EDI Transactions, Virtual Services, and RR pairs for web services.
Having good experience in testing Data Integrity, Data mapping, Data Validations and Database Performance.
Excellent knowledge of Agile & Scrum development environment
Working with all stake holders to ensure that the quality metrics is reviewed, closed and agreed upon.
Good experience on ETL Testing, Black Box, Functional, Integration, GUI, Usability, Smoke, Adhoc, cross-browser, Web Services, Database Testing and Regression Testing.
Skilled in understanding FRS,BRS,HLD,AD software requirement specifications and preparing effective Test
Well versed with Agile, waterfall methodologies and STLC, SDLC concepts.
Expertise in Preparing Test Plan, Test Cases, RTM, Test summary, Test Results, Test Logs.
Good experience in reviewing all STLC documents and Optimizing Test Cases in Regression pack.
Certifications:
Having ISTQB/ISEB Foundation Level Certification.
Work History:
Currently working with Cognizant from June 2019 to till date.
Worked with Spruce Infotech since Dec 2018 to May 2019
Worked with Delviom LLC since Jan 2017 to March 2018.
Worked with UST Global from September 2013 to Dec 2016 & March 2018 to Dec 2018.
Worked with Sagar Soft from Jan 2012 to May 2013.
Worked with TechMahindra from Oct 2008 to Dec-2011.
Worked with Vertex from August 2007 to September 2008.
TECHNICAL SUMMARY
SKILLS
TOOLS
Operating systems
Android, Unix, Linux, Win 98/00/NT/XP/7
Databases
SQL Server, Toad, MySQL, SQL Developer, Couch Base,
Testing Tools & Other Management Tools
JIRA, ADO, HP ALM, Quality Center 10, Putty, QTP 10, Share Point, Selenium, qTest
Test Data Management Tools
CA TDM, GT Datamaker 4.7, CA TDM Portal 4.7.60.0, Fast Data masker, GT Subset, Javelin, ARD, GT EDI, Informatica TDM, Power Center 9x, 10x
Web Services Testing Tool
Soap UI 5.2.0, DHC, Lisa DevTest
Protocols
Layer 1, Layer 2 Protocols, UDP, TCP/IP, TWAMP, SAA/RTR, SNMP, FIX, OUCH, ARCADIRECT, NXMEP
POS Systems
IBM 4690, Cloud Powered POS, NCR POS
Cloud Technologies
SalesForce, OneOps, Force.com
Languages
Java, C, Apex, Shell scripting
Software Methodology
Waterfall, Agile
Educational Qualification:
B.Tech 2007(Electronics & Instrumentation Engineering) from Jawaharlal Nehru Technological University, Hyderabad.
Project #1
Client: Humana Inc. Location: Louisville, KY
Role: TDM Lead Duration: Dec 2018 to Till Date
Roles & Responsibilities:
Responsible for Test Data Management for Synthetic Data Generation, Data Sub-setting, Data Masking Using CA TDM and Informatica.
Responsible for gathering requirements enterprise wide applications
Determining refresh approach for new applications.
Responsible for quarterly data refresh.
Responsible for Data Provisioning through Self Service Portal
Requirement gathering for enterprise wide applications.
Identifying applications for Data Generation and data masking.
Conducting Change control meetings for Scope of applications for TDM
Design solutions as per data needs and requirements.
Responsible for Implementation, Configuration and Administration of CA TDM.
TDM development for Synthetic Data Using CA TDM and Data masking using Informatica Power Center.
Responsible for Managing and creating Seed data.
TDM Repository Maintenance.
Responsible for Test data Validation.
Environment: CA TDM Portal 4.7.6,ARD, Javlin, Data Maker, TDM Portal, Oracle, SQL Studio, ADO, Iserver, qTest, Informatica Power Center 9x,10x.
Project #2
Client: Ahold Inc Location: Quincy, MA
Role: TDM Lead Duration: Mar 2018 to Dec 2018
Roles & Responsibilities:
Leading the CTD (Centralized Test Data Management) for all agile teams involved in Testing, Development & Support teams.
Responsible for Test Data Management for Synthetic Data Generation, Data Sub-setting, Data Masking
TDM development for Synthetic Data and Data masking.
Responsible for Managing and creating Seed data.
CA TDM Implementation and configuration.
TDM Repository Maintenance.
TDM Administration and maintenance
Responsible for Test data Validation.
Maintaining RTM for all new data requirements.
Provisioning Test data to Functional Automation Teams.
Environment: CA TDM Portal 4.4, GT Data Maker 4.4, TDM Portal, Oracle, SQuirreL SQL, JIRA, HP ALM.
Project #3
Client: Coty Inc Location: New York, USA
Role: Test Data Engineer Duration: Jan 2017 to March 2018
Roles & Responsibilities:
Leading the CTD(Centralized Test Data Management )team in Agile Model
TDM development for Synthetic Data.
Provisioning Test data to Functional Automation Teams.
Prepared complex SQL queries for Creating Test Data based on compliance
Validating BI Reports in MicroStrategy
Prepared complex SQL queries for testing the business transformation rules
Responsible for updating jira board for QA.
Reviewed SQL queries /test scenarios/test data and involved in writing complex SQL queries for Data validations.
Providing status/ Technical discussion on daily onsite/offshore calls.
Mentoring the team on technical hurdles/identifying scenarios whenever required.
Review Validation of data`s in target tables and single point of contact between Dev
Running, monitoring of the jobs using Data Stage Director and checking logs.
Responsible for creating Test plans, Test cases, RTM, Test Summary Documents.
Responsible for the test execution from Jira and bug reporting using JIra.
Environment: SalesForce, MSTR,OneOps, Angular JS, XML, JAVA, COUCH BASE,IBM 4690
Soap UI, DevTest, Jira, Confluence, SOAP UI, TDM Portal, CA Data Maker
Project #4
Client: Walmart Location: Bentonville (USA)
Role: ETL QA & Test Data POC Duration: Feb 2014 to Oct 2015 (India)
Roles & Responsibilities
Responsible for Test Data Management for Data Generation, Data Sub-setting, Data Masking (data scrubbing, data de-identification)
Responsible for Implementation, Configuration and Administration of CA TDM.
Test Data Provisioning for POS Legacy & Cloud POS.
Responsible for Test data Validation for Quality.
Provisioning Test data to Functional Automation Teams.
Provisioning Test Data to Performance Engineering Testing for Performance Testing.
Prepared complex SQL queries for Creating Test Data based on compliance
API testing for backend services.
Functional & System testing on CPC UI.
Integration testing with legacy systems.
Ensured adequate testing is planned and coordinate/help the execution of test cycles are per plan.
Created SQL scripts –Staging Tables to Sales Audit Target Tables, Reference tables and Audit tables and identified various scenarios to be tested on every table.
Responsible for creating Test plans, Test cases, RTM, Test Summary Documents.
Responsible for the test execution from JIRA and bug reporting using JIRA.
Analyzed the defect and coordinated with the development team to solve the problems.
Involve in the Deployment of the code in production.
Environment: OneOps, Angular JS, XML, JAVA, COUCH BASE, IBM 4690, JIRA, Confluence, SOAP UI, DCH, CA DevTest, CA TestManager, Soap UI, Selenium web driver, Lisa DevTest.
Project #5
Client: CA Technologies Location: India
Role: ETL QA & TDM Engineer Duration: Jan 2013 to Jan 2014
Roles & Responsibilities:
Leading the QA and Part of Data management team.
Responsible for Data Generation using CA TDM
ETL testing from Source to Target tables.
Responsible for Test data Validation for Quality.
Prepared complex SQL queries for Creating Test Data based on compliance
Verifying Database as per requirements, Testing Reports, Reports performance, Data Validations.
Verifying Extraction from Source and loading to Stage tables.
Verifying Transformations based Transformation Rules.
Verifying Loading data to Staging, Integration, Data mart tables.
Involve in Test Plans and Test cases.
Responsible for creating Test plans, Test cases, RTM, Test Summary Documents.
Integration testing with cloud9, SalesForce teams.
Responsible for the test execution from ALM and bug reporting using ALM.
Analyzed the defect and coordinated with the development team to solve the problems.
Involve in the Deployment of the code in production.
Environment: ALM, Share point, Soap UI, CA Test Manager, CA Lisa, SAP, Salesforce
Project #6
Project Name: High Frequency OHMS Location: India
Client: SAC Capital Advisors Duration: Jan 2012 to May 2013
Role: QA
Roles & Responsibilities:
Leading the QA Team &System Testing on Applications on LINUX server.
Involved in Test Planning, Test Data Management, Defect Management.
Verifying Database as per requirements, Testing Reports, Reports performance, Data Validations.
Verification of BUY, SELL, SHORT SELL trades and positions.
Verifying FIX, OUCH, ARCADIRECT, BOE protocols.
Verifying position for all trade.
Verifying the configuration files.
Configuration Change Management
Regression testing for every release.
Responsible for setting up day to day stand up meeting and scrum calls in agile mode of SDLC.
Testing connections between application and exchanges.
Testing on live test environment.
Responsible for creating Test plans, Test cases, RTM, Test Summary Documents.
Responsible for the test execution from Quality Center and bug reporting using Quality Center.
Analyzed the defect and coordinated with the development team to solve the problems
Involve in the Deployment of the code in production.
Environment: Java, C, Shell Scripting, Solaris, SQL Server, SOAPUI, Mockitup, Jira, FIX, OUCH, ARCADIRECT, BOE, NXMEP.
Project #7
Client: AT&T Location: India
Role: CDT Member & QA Duration: Dec 2009 to Dec 2011
Roles & Responsibilities:
System Testing in scheduler Interface with UNIX
Verification of TWAMP probing data collection, data validation, data formatting, and data loading.
Alarm Generation/Clear of all types( A31,A33,A34,A37,A38)
Involved in Test Plan, Test Data creation and Test Data Creation.
Verification of sending of alarms, data feeds to downstream systems in order to generate Tickets System and Testing of WIPM GUI
Responsible for Test Data Management for PMOSS team.
Provided Test Data to 20+ Applications in PMOSS network based application. Test data related to protocols.
Configuration Change Management
Regression testing of one-way-delay/Two-way-delay measurements.
Testing Thresholds for the interconnections measurements between WIPM Server the cAT&T US SNRC (ASN-7018) and TSERV in cSBC US Mega Pops (ASN-7132)
Involve in reviewing HLD, AD, RTM, Test Plans and Test cases.
Involve in Database testing and reporting to DBA.
Creating Test plans, Test cases, RTM, Test Summary Documents.
Responsible for the test execution from Quality Center and bug reporting using SCME.
Involved in functional, Regression and integrationTesting using UNIX Scripts.
Analyzed the defect and coordinated with the development team to solve the problems
Involve in the Deployment of the code in production.
Environment: Java, C, Shell Scripting, Solaris, SQL Server, Quality Center 10, QTP 10.
Project #8
Client: AT&T Inc Location: India
Role: CDT Member & QA Duration: Sep 2008 to Dec 2009
Responsibilities:
As a Team Member of the Testing team, am responsible for the following -
Testing Database with data validations, Queries Performance, Testing Reports and Testing Database Integrity.
Involved in Test Plan, Test Data creation and Test Data Creation.
Involved in preparation of Test Cases Using Quality Center
Involved in Peer Reviews.
Involved in executing Test Cases and posting defects
Involved in retesting of fixed Defects.
Involved in Functional Testing and Regression Testing.
Involved in dry run(de-bugging) of automated scripts using QTP
Involved in the Preparation of Bug Report.
Environment: J2EE, Windows XP, Mainframes and Quality Center, SQL Server, Quality Center 9.2, QTP 9.2, SCME
Project #9
Client : United Utilities Location: Manchester (UK) & India
Role: QA Duration: Aug 2007 to Sep 2008
Roles & Responsibilities:
Responsible for the test execution of the developed test cases
Involved in functional and Regression Testing.
Analyzed the defect and coordinated with the development team to solve the problems.
Environment : Servlets, JSP, Struts, JMS, EJB, JavaScript, MySQL, windows, Quality Center 9.2, JIRA.
Contact this candidate