Saurabh Joshi

TDM Analyst

+1-647-***-****/ad318r@r.postjobfree.com

CAREER SUMMARY

Overall 13+ years of experience in TDM and Data Masking, ETL, Functional and Big data testing

Extensive knowledge on CA TDM and IBM Optim tool to generate synthetic data, subsets, data masking and creating gold copy on various database like DB2, Microsoft SQL Server, Oracle, Mainframe etc.

Defined TDM strategy based on client environment and data governance policy

Defined masking rules after performing PII analysis on sensitive information

Prepared subset extract files to extract sliced data from production down to pre-production environments

·Excellent in requirement analysis, Source to target mapping analysis, Creating Test Plan, Test Strategy,

Test Scenarios and Test Cases/SQL Scripts

·Expert in activities like Estimations, Status tracking, Defect Triage, Tracking test cases through HP ALM

·Experience in working as team lead/test coordinator & mediating onsite-offshore project delivery with teams located on multiple geographical locations

·Ability to work on multiple applications/projects at a time and adapt new technologies quickly

·Skillful in writing SQL, Hive queries, Unix and HDFS commands

·Great exposure working in Agile methodology

·Familiar in automation by writing Java/Python/Shell script for file validation

TECHNICAL PROFICIENCIES

Test Data Management tools: CA TDM, IBM Optim

RDBMS/Database: DB2, Oracle, SQL server, Hive, Mainframe

Test Management Tools: HP ALM, JIRA

Defect Tracking Tools: HP ALM

ETL Tool: Informatica PowerCentre

Process: Waterfall, Agile

Operating system: Windows 7, XP, UNIX/LINUX

Programming Language: C, VB Script, Python, Shell Scripting

KEY PROJECTS

Client: Bank of Montreal

Role

Test Data Management Architect

Skills

TDM and Data Masking

Tools

CA TDM, SQL Server, Oracle, DB2

Contribution

Partner with CA TDM vendors to coordinate and install the 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 CA TDM tool

Understand the client database architecture, interfaces & external dependencies and then review the functionalities of the tool and masking so that it can be currently plugged into the client environment seamlessly

Identify PII columns in the table by running the data profiler and map the masking algorithms to PII columns using rule sets

Conduct Scrum meetings with all stakeholders to drive and accomplish tasks related to CA TDM/IBM Optim tool implementation

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

Understand the requirement for Masking and analyze the PII values for the project

Discuss with SME to confirm and finalize the PII information and start development

Develop the code in Optim and run the masking solution

Post run, validate the data before and after and notify team about the masking completion.

Start Date

08-Apr-2019

End Date

Till Date

Client: Toronto Dominion Bank

Role

Senior Test Engineer/Test Lead

Skills

Big Data Testing

Tools

HDFS, Unix File System, Sqoop, Hive, HP ALM, WinSCP, Record Editor, Podium

Contribution

Performed test planning and monitoring activities of Hadoop projects

Managed the project releases with onsite and offshore model to conduct testing for the major releases to ensure integrity of applications

Providing Estimations, Identify the scope and testing approach

Understanding Incoming Data Capture and Outgoing Data Capture Requirements and raised appropriate questions timely

Prepared test scenarios, test cases and associated Hive Queries and also reviewed test cases of other team members

Creating sample test data for validating transformation logic

Validating Schema - Data Types, Primary Checks, Null checks, Count Checks, extract Validation

Reported new problems found, debugged and provided detailed information to development

Conducting Defect Triage meeting and sending Minutes of Meeting to track the activities and action items

Reviewed testing execution and ensuring project deadlines and milestones were met utilizing various reporting on HP ALM

Groom new joiners in the team with for Quality Processes and Design understanding of the Project

Preparing Dashboard Reports and produced QA reporting deck and test closure report for project stakeholders

Ensure the timely delivery of different testing milestones

Managed the compliance requirements for TD Bank projects

Automation through python and shell scripts to do sanity/data validation

Client appreciation on collaborative working, automation efforts and excellent execution on test activities

Start Date

12-Sep-2017

End Date

31-Dec-2018

Client: Credit Suisse

Role

Senior Test Engineer/Test Lead

Skills

ETL Testing, Datawarehouse testing, Web Application Testing

Tools

Toad, PL-SQL Developer, Tectia, Informatica Powercenter, HP ALM, Control – M, SVN

Contribution

Understanding the project requirements by going through Functional Specification Documents and Technical specification documents, Mapping Sheets etc.

Analyzing Testing Requirements, Providing Estimations, Identify the Scope and testing approach.

Prepared Test Plan, Test Scenarios, Test Cases, Lesson Learnt Documents and updating WSR reports to client.

Creating SQL queries for test scenarios & test cases for each area of scope

Creating sample test data for validating complex transformation logic

Defect reporting and analysis in HP ALM.

Conducting Defect Triage meeting and sending Minutes of Meeting to track the activities and action items

Estimates for change requests and planning their tests.

Validated Schema - Data Types, Primary Checks, Null checks, Count Checks, Extract Validation

Validated transformation logic with reference to mapping document

Coordinating between BA and DEV Team for defect discussion

Excellent in co-coordinating with Upstream, downstream for upcoming plans for testing

Start Date

06-May-2012

End Date

24-Aug-2017

Client: Charles Schwab

Role

Test Engineer

Skills

ETL Testing, Functional Testing, Regression Testing, Web Application Testing

Tools

Quality Center, SQL Server, Control M, Mainframe

Contribution

Understanding the business logic and the ETL Processes.

Creating test cases for ETL mappings.

Testing - Involved in writing manual test cases & test execution.

Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements

Responsible for validation of Target data in Data Warehouse and Data Marts.

Validated data in between source and target after running Control M jobs

Handling Daily Status meetings/Calls with all groups involved in the delivery (Release management/Project Managers/Development/Business/Testing).

Preparing Testing Timelines, test planning and strategy planning for the releases.

Creating SQL queries for test scenarios & test cases for each area of scope

Identifying and reporting the bugs

Start Date

05-Jan-2010

End Date

05-May-2012

ACADEMIC QUALIFICATION

oMS degree in Software Engineering from BITS PILANI in the year 2013

oGraduated BSc. in Information Technology from Mumbai University in the year 2009

Contact this candidate