Email: ad2orx@r.postjobfree.com

SANJEEV REDDY Mobile No: +1-502-***-****

Experience: 15 Years TDM Lead /Architect

LinkedIn : https://www.linkedin.com/in/sanjeev-reddy-a9013b52/

Career Objective

An instrumental asset Seeking a challenging position in Test Data Manager and Testing delivery in a Professional Organization, where my testing skills and domain knowledge in Logistics, Healthcare, Finance, and Insurance can add value to the growth of the organization and my professional growth.

Professional Summary

Manage the test scope and delivery for medium to large sized projects and E2E QA delivery.

Strong knowledge and working experience of DELPHIX TDM implementation.

Develop and implement TDM solutions using Delphix.

Manage test data for development, testing and production environments.

Define and implement the overall Test approach, Test planning and strategies

Hands on experience on DELPHIX tool setup and DATA MASKING

Design and Development of TDM solutions for data privatization, sub-setting, data creation and provisioning

Implementation of Test Data management process for Data Virtualization, data mining to support lower environments E2E testing.

Hands on experience in Implementing Automation framework like (Data driven/Keyword/Hybrid) and developing automation infrastructure.

Involved in stakeholders and SME meeting for requirements freezing.

Involved in creation of Proof of concept (POC) and Automation test plan

Involved in UAT Support with stakeholders like test scenarios and test data for testing

Hands on experience on handling 20+ onshore /offshore teams

Hands on experience in creating and reviewing the test scenarios and test cases

Involved In-Sprint automation and running the regression automation suite after each sprint

Hands on experience in Identifying and Creating reusable components for the automation testing

Hands on experience on SOAP UI and API web services testing using REST/POSTMAN

Hand on experience in Agile Projects. Involved in Sprint Planning, Sprint estimation, Sprint Grooming, Sprint Retrospective, and daily scrum meetings.

Involved in Sprint demo to client and stake holders for automation testing for completion each Sprint

Directing team towards automation testing approach, test case and test data approach and schedule test execution as per test plan.

Debugging tests and fixing the errors during the execution

Analyzing test results, defect reporting and tracking using HP ALM

Apply different estimating methods to estimate timescales, effort, and costs for the testing phases

Responsible for producing the overall test delivery plan and defining the business test deliverable milestones, test tasks and activities whilst determining whether automation tools can be utilized

Managed a large testing capability, resources and testing process from project initiation to post implementation review and extended wellness

Identify slippage and develop strategies to recover and resolve issues around the technical solution delivered into the business test environment

Ensure that all test phases have appropriate entry / exit criteria and for monitoring achievement of these criteria and for obtaining sign-off against these prior to Go Live

Implement a well-structured approach to test defect management and incident reporting

Monitor and report the status and progress of each test phase to different stakeholders

Organizing the testing process, Planning, coordination, and control of the various test activities

Development and definition of suitable test methods and test tools

Technical management and control of the testing team

Ensuring high-quality products are delivered to clients

Participating in preparation of quality assessments, reports, and metrics formulating go-no go statement based on reports and metrics, test progress and defect status

Presenting test improvements and developments in daily progress meetings

Develop detailed work plans for engagements, status tracking and reporting, and production of high-quality deliverables for clients

Advocating the appropriate level of quality by the resolution of important Defects

Strong Skills with Project management, reporting, team handling & Client interaction.

External Certifications

Certified Scrum Master (CSM) from EXIN INTERNATIONAL – UK

Certified with SAFe® Agilest

ISTQB Certified Testing Professional

Diploma in Software Testing (DST) from APTECH Computer Education

Previous Onsite Contribution

Year

Location

Domain

Project / Client

2013-2015

Central London - UK

Banking and Finance

FCA – Financial Conduct Authority

2018-2020

Pittsburgh (PA)- USA

Logistics

FEDEX

2022 to till

Louisville (KY) - USA

Healthcare

HUMANA

Technical Skills

Operating System

Windows 10/7/ XP, Windows 2003 Server

Automation Tools

UFT, Selenium Web driver, Kafka Topics, Stream sets

Performance Tools

Load runner

Test Management tools

Delphix, Data Masking, Informatica TDM, HP ALM, QTEST, JIRA, GenRocket

Middleware Tools

JMS Data Publisher (Queue and Topic)

Data bases

SQL Developer, MS Access, Oracle 10g/11g, Teradata

Web service testing tool

SOAP UI 5.2, POSTMAN

Functional Domain Area

Healthcare, Logistics, Telecom, Banking & Finance

Project 1

Project

PHARMACY ELIGIBILITY HUB (Cloud 3.0 Migration)

Client

HUMANA

Domain

Healthcare

Role

TDM Lead/ Architect (Onsite)

Team Size

12

Duration

April 2020 – Till Date

Description:

This project deals with Humana Pharmacy which is an IT enable service for Pharmacy applications; it has various applications like Rx Audit, RX Mentor, Pharmacy benefit manager, Pharmacy Campaign Management systems, Centralized Formulary, Pharmacy Eligibility and Right source ecommerce etc.

Roles and Responsibilities:

●Worked on highly agile environment and Participated in Sprint Planning, Sprint Grooming and Sprint Retrospective meetings.

●Involved in Clients and Business Stakeholders requirements meeting.

●Design a test strategy and write a detailed test plan

●Strong knowledge and working experience of TDM solutions using DELPHIX.

●Manage test data for development, testing and production environments.

●Implementing DELPHIX tool setup and DATA MASKING

●Design and Development of TDM solutions for data privatization, sub-setting, data creation and data provisioning

● Implementation of Test Data management process for Data Virtualization, data mining to support lower environments E2E testing.

●Capturing the Environment details of the application

●Delphix enable implementation script creation.

●Adding Oracle details into the delphix engine

●Adding dsource links to delphix engine

●Create dSource which initial copy of original data base.

●Creating Virtual copies of dsources

●Connecting to Masking engine (Delphix)

●Creating different rules to mask the data in the column in DB

●Running the rules for mask the data

●Selecting 5-10 rows data from DB and identify the data to be masked.

●Extracting the replica copy of masked data from DB like DOB, SSN Number/Address and Zip code etc

●Replicate the masked data to different environments like Test/SIT/UAT

●Creation of Gold copy of data from Parent

●Then creating Child copies for different environments for testing the applications

●Creation of shell scripting to change the password for lower environment.

●Creating VDB FROM dSource for different environments

●Refreshing the VDB every one hour so that new data will be adding to the VDB from data source

●Running the pipelines using Github and comparing the results

Environment:Windows10,dotnet, Cloud 3.0, Kafka Topics, Stream Sets and Delphix for TDM

Project 2

Project

FedEx Services - P&D

Client

FedEx Ground

Domain

Logistics

Role

TDM Lead (Onsite)

Team Size

10

Duration

April 2018 – March 2020

Description:

Vision is the application suite of technology to simplify and improve the efficiency of FedEx ground station operations. Vision systems simplify the assignment of stops to work areas, Inbound sortation, and promote the on-road efficiency of CSPs.

There are four main primary systems comes under Vision.

1.Kick out Resolution (KOR) - is an interactive application designed to allow the station users to resolve the problem with invalid addresses by minor edits to the addresses and manually plot the addresses on AWAP maps.

2.Automated Work Area Design (AWAD) - a Web-based mapping application that provides the platform to geographically define Work Areas and vehicle load sections.

3.Preload Assist (PLA) - Scanner application that provides Work Area and vehicle load section information from AWADA to package handlers via both Preload Assist Label and Scanner screen.

4.Delivery Manifest (DMM) - Generated through Work Area scans, Delivery Manifest shows drivers their stops for the day and the location of each stop’s package(s) within the vehicle

Environment:Windows10,Java,Jenkins Server, Continous Integration.Delphix for TDM

Roles and Responsibilities:

●Worked on highly agile environment and Participated in Sprint Planning, Sprint Grooming and Sprint Retrospective meetings

●Involved in Clients and Business Stake holders meeting

●Design a test strategy and write a detailed test plan

●Implementing the Delphix tool in different project for test data management

●Involved in Creating VDB (Virtual Data Base) for different environments

●Refreshing the VDBs from parent VDB OR dSource

●Implementations of Test Data management, Data Virtualization, data mining to support lower environments E2E testing

●Involved in Cadence Release Status meeting to understand current updates/time Implement end-to-end Test Data Management (TDM) and tools strategies / roadmaps to efficiently make the right test data

●Available to project teams focusing on Data delivery, Data Quality, Data Security, and Infrastructure cost.

●Design and implement test data management frameworks and approaches.

●RDBMS understanding Ability to analyze complex applications and systems Query and database access tools Knowledge of databases like Oracle SQL developer

●Understand and analyze the current TDM processes includes, test data acquisition process, team alignment, portfolio release plan

●Understand and analyze and recommend procedure for data masking, data sub-setting, data generation

●Analyze data flow across applications and data dependencies. Oversee Data Validation and Data Verification steps

●Design and implement test automation in Java, and plan the work required to achieve this, including estimating the schedule

●Monitor and maintain test automation (Selenium) across multiple platforms and configurations

●Running regression automation suite

●Communicating results to the stakeholders

Environment:Windows10,Java,Jenkins Server, Continous Integration.Informatica for TDM

Project 3

Project

Commercial Acceleration Program (CAP)

Client

AUTOZONE PARTS INC

Domain

Logistics and Auto Parts

Role

Senior Automation Test Lead (Onsite)

Team Size

10

Duration

Oct 2017 – April 2018

Description:

AutoZone is rejuvenating its Commercial business by implementing Customer centric and Employee friendly Mobile Applications. AutoZone has invited Syntel to Partner with AutoZone on their commercial business transformation Journey. Syntel will conduct a Due-diligence exercise to understand AutoZone strategies/priorities/issues, ensure faster onboarding on to the program, customize operational delivery model, and identify risks and create risk management plan. Outcome of this exercise would be to provide a Digital transformation roadmap and execution plan consisting of an operating model, infrastructure plan, and recommendations for Mobile development/QA processes. Subsequently, Syntel will co-deliver the Next-gen Omni-Channel experience to AutoZone’s stakeholders.

Environment:Windows10,VB Scripting, POSTMAN, Jenkins Server, Continous Integration.CI/CD

Roles and Responsibilities:

Worked on highly agile environment and Participated in Sprint Planning, Sprint Grooming and Sprint Retrospective meetings

Involved in Clients and Business Stake holders meeting.

Involved in Cadence Release Status meeting to understand current updates/timelines.

Estimate the test effort and create the test schedule (tasks, dependencies etc.)

Involved in daily updating the User stories in JIRA

Verifying test requirements by validating test cases

Involved in identifying the regression suite for Automation testing

Involved in design of Automation scripts and also reviewing the automation scripts for team

Track the new/ updated requirements in the project and modify testing artifacts accordingly.

Involved in Checkpoint meetings to update the status of project to the TCOE and Globe teams.

Involved in Steering Committee meet to understand the scope/de scope of future releases ongoing releases.

Involved in Defect management meet to discuss about blockers/issues/defects and the impact on current release

After completion of every sprint presenting the Automation demo for completed user stories

Involved in retrospective meeting at the end of each sprints

Communicating, updating and reporting the task to client on daily basis and discussing any roadblocks

Reporting Weekly and Monthly status to the stakeholders

Project 4

Project

FCA (Financial Conduct Authority)- Regulatory System

Client

FCA – UK London

Domain

Financial and Banking

Role

SIT and TDM Lead – Onsite

Team Size

10

Duration

Jan 2015 – Sept 2017

Description:

The Financial Conduct Authority (FCA) is a regulatory body in the United Kingdom. It operates independently of the United Kingdom government. The FCA regulates financial firms providing services to consumers and maintains the integrity of the UK’s financial markets. It focuses on the regulation of conduct by both retail and wholesale financial services firms.

The CRD IV project release is planned to undertake changes to the GABRIEL application to accept COREP and FINREP data in XBRL. This release includes collection, validation and submission of COREP/FINREP XBRL data on GABRIEL and transferring the data further to the Bank of England, London Clearing House and European Banking Authority. One of the aims of CRDIV project is to achieve maximum harmonization by applying one set of rules to the whole of the European Union (EU). Harmonized Reporting is a legal necessity for all European credit institutions and investment firms under the CRR/CRDIV. The Harmonized Reporting project predominately involves the management of data and IT systems.

Environment:Windows10, VB Scripting, Java,Jenkins Server, Load Runner, SOAP UI

Roles and Responsibilities:

Attending project kick-off/Sprint planning meetings, capturing requirements, conducting impact analysis of requirement and test strategy and time lines based on User Stories by coordinating with business units, stakeholders and product managers.

Preparing high level Design and low-level design documents based on the analysis as per the Quality Procedures and standards. Analyzing the technical requirements and translating them into well-designed test case scenarios and functional test cases.

Coding and development/enhancement/modification of new/existing automation testing scripts using Behavior Data Driven Cucumber Framework Responsible Single Point of Contact (SPoC) for the Test process

Review and analyze the project requirements

Perform automation script execution, reviewing the automation script run results, proactively tracking the defects in HP ALM tool and sharing the test reports, defect reports to business stakeholders.

Test conditions and test strategy walk through with business partners and project teams. Responsible to perform QC audits, defect analysis and metrics analysis.

Communicate with the client or on site/ offshore team by getting projects status/updates

Create/Review the test cases and test data and address the review comments

Verifying test requirements by validating test cases

Verifying Data comparisons. i.e., verifying Front Data with Back End, Data base data with Excel file data

Verifying data manipulation operations, i.e., Additions, Modifications and Deletions etc.

Project 5

Project

BUPA health & Wellbeing

Domain

Healthcare and Insurance

Client

BUPA UK - Insurance

Role

Senior Test Analyst

Team Size

5

Duration

Dec 2013 – Jan 2015

Description:

SWIFT is an end-to-end Insurance Product Management tool for Bupa UK to Manage Insurance Products for the UK Market. This includes, creating new Products with their benefit heads and eligibility rules, maintaining existing Products and if required tailoring products for a customer.

Key features of this product are,

Enroll new members and manage existing members

Transfer members

Lapse and reinstate the members

Sell insurance products to Individuals and Group /Corporate

Manage claim requests

Manage Service Providers

Manage Complaints

Environment:Windows 7,Manual testing,Jenkins Server, Continous Integration.SOAP UI

Roles and Responsibilities:

Checking the functionality of online applications in different browsers & OS.

Conducting requirement analysis & preparing SOP/POC documents to apply correct strategy & Planning towards the requirement.

Creation of the newer user account & validation of functionality.

Verification of linguistic accuracy & checking usability of the UI.

Applying permutation & combination to reduce the efforts during the execution. At the same time fetching the maximum output.

Test Execution & debugging using Automation (UFT) scripts.

Automating all the labels in localization via Selenium using Java code.

Created Object Repository for storing of Web elements values using Page Object Model.

Defect logging, analysis & validating in Quality Center tool.

Worked proactively on Project initiation audit.

Attending weekly client calls & updating the status.

Report is generated in the excel format using TestNG with description of scenario pass/fails results.

Reviewing, Modifying and Sending the Status Report on a weekly basis to the client. Status Report consists of shipping reports, defect logs, effort estimates.

Project 6

Project

Humana

Client

Humana – Texas, USA

Domain

Health Care

Role

Consultant.

Team Size

6

Duration

Dec 2013 – Jan 2015

Duration

Nov 2009 – Nov 2013

Description:

Humana offers a range of products and services in addition to group health insurance. Humana lines of business serve the military, individuals, seniors, and many others. They also offer specialty products, and other innovative consumer initiative products, services, and partnerships that are focused on consumers.

Environment:Windows 7,Manual testing,Continous Integration.

Roles and Responsibilities:

Offshore Coordination on day to day basis

Coordinating with onshore team for task allocation and assigning the team Individual task and assuring no deadlines are missed

Review of Test scripts to ensure coverage and quality.

Preparing and updating all the Queries to onshore team in Query register.

Sending the daily activity progress of offshore team to onshore coordinator.

Issue escalations to Onshore (Test data Issue, Environment issues etc.) through Issue Register.

Keeping a track of Issue register daily, to ensure proper comments from onshore for the issues logged.

Contact this candidate