Sandeep Kumar Gupta_Resume

SANDEEP KUMAR GUPTA

E-Mail: [email protected]

Cell No. +1.412.245.8050

EducationBachelor of Technology with specialization in Electronics & Communication Engineering from Uttar Pradesh Technical University, Lucknow, Uttar Pradesh, India in June 2007.

Current Project: Walgreens Co. Central Specialty This project aims at enhancing the Creehan’s ScriptMed(SM) Specialty Phar-macy Platform for Walgreens Specialty Pharmacy Prescription fulfillment solu-tion and to successfully maintain the application and its integration with the Walgreens enterprise systems to share patient, prescription and other infor-mation to improve efficiency and reduce operating costs.Walgreens uses ScriptMed as a Single platform for patient, prescription, refer-ral, order fulfillment, clinical care management, inventory, pricing, billing, re-ceivables and reporting.

Applications/tools worked on: ScriptMed 6.1, 7.3 and 8.2 SQL Developer IC+ SR2 Cognos HPQC ALM 11.52/12.53 Test Management Application

Experience Summary:I am an associate with Tata Consultancy Services for the last 9 years. My main area of experience has been Project Management, leading the manual testing and test automation activities for various web based applications, database and ETL automation. I’ve been doing Systems Analysis and Quality Assurance of application systems. I’m well versed with Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Methodologies & Validations to ensure the Quality Assurance Control.My technological forte includes:

9 years of experience in Software Testing (Manual & Automation). ISTQB, MCP, QTP 10, HP QC 10 certified, CCNA Certified. Experience in CE based testing and HLD, LLD and Process Design docu-

mentation. Experience in End to End testing, System Integration testing, Component

testing, Network Testing and Regression testing and good knowledge of SDLC, STLC and Test Methodologies.

Experience in preparation on Test strategy, Test Plans, Test Scenarios, Test Cases, Test Summary Reports and Traceability Matrix (To ensure compre-hensive test coverage of requirements)

Experience in handling Clients/Business Stake holders over demos, Defects discussions, test execution status and automation discussions.

Thorough hands on experience with designing test scenarios covering all test conditions eliminating redundancy and duplications.

Experience in drafting Automation test strategy/ framework for Web based applications, ETL workflows and MS SQL database.

Experience in defect/Test management using HP Quality Center and SQuIDS.

Experience in - Client Interaction, Meetings and Presentations, offshore/on-shore coordination.

Involved in account & organizational level initiatives. And I’m having experience in the below mentioned computer languages /

tools/ application

C/C++/Core Java VB Script Informatica PowerCenter 9.1 Microsoft SQL Server 2005/2008/2008R2 IBM DB2 IBM Mainframe HP Quick Test Professional 9.2/9.5/10.0/11.0/11.52 UFT SQuIDS Test Management Application HPQC ALM 11.52/12.53

Areas/Domain

Life Sciences & Healthcare AssuranceClient: Walgreen Co.Client: CVS Health Client: Humana Inc.

Telecom Services AssuranceClient: British Telecom Plc.

Computers/Technology/Tools Worked on

Operating System

Programming Languages

Special Software

WIN 95 WIN XP WIN 7 Linux Fedora UNIX

C C++ Core Java Java Script Web Services VB Script XML

Informatica PowerCenter 8.6.0 Microsoft SQL Server 2008 Microsoft SQL Server 2008 R2 IBM DB2 IBM Mainframe HP Quick Test Professional 11.0 UFT 11.50 SQuIDS Test Management

Application HP Quality Center 10.0 HP Quality Center ALM 11.52/12.53 DVT

Career Profile:

From Today to 2007 Tata Consultancy Services______________________________________________________________________

1.

Project Walgreens Co. Central Specialty PharmacyClient Walgreens Co.Role Test Lead (Functional)Applications/Tools

ScriptMed 6.1, 7.3 and 8.2, IC+, SR2, Cognos, PL/SQL Developer, HPQC ALM 11.52/12.53 Test Management Application

Duration May 2016 To till todayTeam Size 6Architecture

Client/server

RDBMS IBM DB2 Location Pittsburgh, PA-15220

This project aims at enhancing the Creehan’s ScriptMed(SM) Specialty Phar-macy Platform for Walgreens Specialty Pharmacy Prescription fulfillment solu-tion and to successfully maintain the application and its integration with the Walgreens enterprise systems to share patient, prescription and other infor-mation to improve efficiency and reduce operating costs.

Walgreens uses SriptMed as a Single platform for patient, prescription, refer-ral, order fulfillment, clinical care management, inventory, pricing, billing, re-ceivables and reporting.I have been responsible for leading the testing activities for Walgreens’s Business requirement developed on the ScriptMed platform to ensure that we have improved, efficient and stable application which enable Walgreens to operate smoothly to provide best and effective way to process the patient’s needs.

Responsibilities:

Preparing the test strategy and execution of test plan, conduct test plan review, testing schedule.

HLD and Process Design document reviews Developing Test Scenarios based on HLD, BRD and Change summary

document. Involved and Leading the E2E testing, System Integration Testing Involved in Estimation of Cost and Resources. Reporting/ tracking defects using HP ALM. Reviews product documentation with technical writers and provides in-

put to assure accuracy. Coordinating with other component Test Lead & developers for defect

analysis and their fixes. Interaction with client on a daily basis for test status/ defect and issues

discussion for E2E Test, UAT and ORT. Training to team members UAT / Production support for defect analysis and providing the test data.

2.

Project Walgreens Co. Local Specialty PharmacyClient Walgreens Co.Role Test Lead (Functional, Automation)Applications/Tools

Local Specialty-LDD,IC+, SR2, Cognos, PL/SQL Developer, HPQC ALM 11.52 Test Management Tool, UFT11.50

Duration Dec 2015 To May 2016Team Size 6Architecture

Client/server

RDBMS IBM DB2 Location Deerfield, IL-60015

Project Description:

Walgreens Co. Local Specialty:

TCS is helping here to establish a system Local Specialty-LDD, which provides access to Specialty drugs and lives across Local Specialty channels as part of Community Pharmacy/HSRx expansion for Walgreens Co.

The application will provide solution to LDD and/or Complex Specialty Medication Expansion, Pharma Desire for Robust Data/Services, Payer/PBM Desire for Robust Data/Services, and Consistent Experience across Enterprise, Compliance.The above mentioned points are key drivers of Walgreens OnePlan strategic goals to strengthen Specialty and offer seamless healthcare services per patient’s choice.

To ensure that I am working as a QA lead for the testing of Local Specialty-LDD application for Referral Management, Inventory Management, Reporting and Analytics, Logistics Management to achieve above mentioned key business drivers.

Responsibilities:


HLD, LLD and Process Design document reviews Developing Test Scenarios based on HLD, User Stories document. Involved and Leading the E2E testing, System Integration Testing Involved in Estimation of Cost and Resources. Reporting/ tracking defects using HP ALM. Reviews product documentation with technical writers and provides in-




2.

Project Caremark Specialty QA TestingClient CVS HealthRole Test Lead (Functional)Applications/Tools

HBS, SPARCS, ERP, Scan Data, McKesson, HPQC

Duration March 2015 To Oct 2015Team Size 10Architecture

Client/server

RDBMS IBM DB2 Location Monroeville, PA-15146


CVS Caremark Specialty:

This project is all about the providing the drugs/ health care services to the patients who are suffering from the diseases which are like incurable and treatment cost a lot to patients.

We were working here to establish a system, which can be used to provide them better services from CVS Caremark perspective.Here we use to test all the systems which are used for patient enrollment, their prescription processing to end of billing report.

I was working as a QA lead to ensure that applications HBS/SPARCS are functionally correct and meeting the business requirements.

Responsibilities:


HLD, LLD and Process Design document reviews Developing Test Scenarios based on HLD, LLD document (Release ver-

sions). Involved and Leading the E2E testing, System Integration Testing Involved in Estimation of Cost and Resources. Extensively used HP ALM for reporting/ tracking defects and for docu-

ment control. Reviews product documentation with technical writers and provides in-




3.

Project SDR/SDS Testing TeamClient Humana Inc. US.Role Test Lead (Manual & Automation)Applications/Tools

Informatica PowerCenter 8.6.0,Microsoft SQL Server 2005/ 2008/ 2008 R2, IBM DB2,IBM Mainframe, HP Quick Test Professional 9.2/ 9.5/ 10.0/ 11.0, SQuIDS Test Management Application

Duration June 2012 To February 2015Team Size 10Architecture

Client/server

RDBMS MySql Server, IBM DB2 Location Noida V SEZ, India


SDS - Shared Data Services are the back bone services at Humana. They are used by Authentication platforms, Enrollment and Claims to know the status of Members, Coverage and Providers. Initial development, Maintenance & Support, Enhancement to SDS form the core part of the services. Two kind of services Real time & Bulk service are core component of this project. In Real time Service, implementation has been done through XML and in Bulk Service implementation has been done through SSIS Packages.These services basically interact with the core databases of Humana i.e. Shared Data Repository and Operational Data Store (ODS).This project is all about ensuring the correctness of RT and bulk services also the validation of the data for both SDR and ODS.The testing team is called as TMO (Test Management Office) which is respon-sible for carrying the testing activity for both the databases i.e. Shared data repository (SDR) and Operational database (ODS) also the testing of services (Real time and Bulk) which basically interact with both SDR and ODS data bases.

Responsibilities:



sions). Involved and Leading the E2E testing, System Integration Testing Involved in Estimation of Cost and Resources. Extensively used SQuIDS for reporting/ tracking defects and for docu-

ment control. Reviews product documentation with technical writers and provides in-

put to assure accuracy. Lead for Automation testing for all Web based and database based ap-

plications Coordinating with other component Test Lead & developers for defect


discussion forE2E Test, UAT and ORT. Training to team members QA / Production support for defect analysis and providing the test data.

4.

Project BT Global Services- GSUKClient British Telecom, UKRole Test LeadApplications

One Siebel CRM, CSS/COSMOSS, BMC Remedy (Fault Management)

Duration October 2010 To June 2012

Team Size 30Architecture

Client/server

RDBMS MySql Server Tool HPQC 10Location Gurgaon V SEZ India, London UK


The BT Global Services- UK Volume is responsible for E2E Testing for the Auto-mation of all the Volume products of BT Global Services stack, comprising a number of components like One Siebel CRM & order fulfilment systems CSS/COSMOSS including STAA, CHESS, ODM, NAD. I have been working on the ordering, provisioning and fulfillment of multiple products like Classic PSTN, Classic ISDNE 2e, Classic Featureline, WLR3 PSTN, WLR3 ISDN2e, WLR3 Featureline, Switches, Broadband, Featurenet 1K/5K, Kilostream, Megastream, SHDS, and Analogue.

Responsibilities:



sions). Involved and Lead the E2E testing, System Integration Testing, Compo-

nent testing for both the L2C and T2R journeys. Involved in Estimation of Cost and Resources. Extensively used Quality Center for reporting/tracking bugs and for doc-

ument control. Reviews product documentation with technical writers and provides in-

put to assure accuracy. Lead for Manual Testing for all applications Coordinating with other component Test Lead & developers for defect


discussion forE2E Test, UAT and ORT. Training to team members QA documentation.

5.

Project BT Global Services- GlobalClient British Telecom, UKRole Test AnalystApplications

eDCA CRM, Classic (Fulfilment System), BMC Remedy (Fault Management)

Duration August 2009 to October 2010Team Size 10

Architecture

Client/server

RDBMS OracleTool HPQC 9.2Location Gurgaon V, India


BT Onevoice Global VPN is an end-to-end service for voice communications that helps you consolidate disparate networks into a single, converged infra-structure, without causing disruption or loss of business. The BT Onevoice Global VPN will provide customers with a common dial plan, on-net calling and off-net calling to over 240 fixed, mobile and satellite destinations around the world.The project involves the E2E testing of the system applications integrated to fulfill Order Management, Network Plan-and-Build, Service Delivery (Lead-to-Cash), and Service Assurance (Trouble-to-Resolve), Capacity/Threshold Man-agement functionality of the British Telecom Operational Support Systems (OSS).

Responsibilities:

Capturing and understanding the business requirements and transform-ing them into functional specifications.

Reviewing functional specifications and participating in walkthroughs. Interacting with OSS Solutions design, Service design, and Process de-

sign teams to establish E2E functional test specifications. Tracing the business and functional requirements to scope their cover-

age in testing. Technically Lead the E2E testing of Service Delivery and Service Assur-

ance functionality over different test environments (T3 - Test Environ-ment, T1- Production Environment, Live Environment)

Leading team during System Integration Testing, Regression Testing, Cutover Testing, Deployment Testing, Live Testing, UAT testing, Post De-ployment Warranty Drop Testing

6.

Project British Telecom Infra E2E : Common CapabilitiesClient British Telecom, UKRole Team MemberLanguage C++, UNIX ScriptingDuration February 2009 To August 2009Team Size 6Architecture

Client/server

RDBMS MySql Server Location TCS Tower Gurgaon, India


The aim of the Common Capabilities programme is to revolutionize the way BT plans, designs, builds and launches products by providing a toolset and ‘ecosystem’ for a product environment with a high level of automation, flexi-bility and best in class costs.The purpose of the ADQ Capability is to provide a mechanism for Service Provider's to configure Quality of Service on a broadband line. This can be done dynamically and in real time

Responsibilities:

Test case preparation for various modules according to Functional Re-quirements.

Developed Test cases for the Application under test. Update test cases and test strategies based on latest requirements. Involve in Test Case Preparation, Test Data Preparation and Test Execu-

tion.

7.

Project British Telecom Infra E2E : Network Test FactoryClient British Telecom, UKRole Team MemberLanguage C,C++, TCL/Tk, VBSriptingDuration Nov 2007 To February 2009Team Size 6Architecture

Client/server

RDBMS OracleTools Quick Test Professional, MS-VSS (for source code control), HPQC

9.0, HPQC 9.2, Lab Magic, Tyco Front End Tool, Tyco EMSLocation TCS Towers Gurgaon, India


The 21st Century Network (21CN) program is the network transformation project of the UK telecommunications company BT Group plc. It will see the UK incumbent's telephone network move from the present AXE/System X Public Switched Telephone Network (PSTN) to an Internet Protocol (IP) system. As well as switching over the PSTN, BT has revealed plans to deliver many ad-ditional services over their new network, such as on-demand interactive TV services.BT originally stated that it would accrue annual savings of £1 billion when the transition to the new network was completed, and hoped to have over 50% of its customers transferred by 2008. (See External links below for current progress.) Capital expenditure was put at £10 billion over five years, this be-ing 75% of BT's total capital spending plans in that period.Module TnD: Testing and Diagnostics is one of the major activities which constitute testing of individual network elements and also their interaction

with each other. Through this, each and every part of network can be tested in terms of network functionality. If any problem arises in network elements or among interaction with each other, then, problem can be diagnosed at very elementary level for permanent solution.

Responsibilities:

Network Troubleshooting. Automation of Test cases using TCL/Tk Writing Test Scripts in TCL for checking functionality of End to End flow

of data (that basically covers EvoTAM, QT200 and MSAN functionality, three major devices used by Service Providers in their architecture).

Validation of these scripts through MQC on Live environment. Manual Testing of Tyco EMS and other element managers. Writing Test cases on Various Topologies using these devices and their

functionality.

Training Attended

Date Training Name Held Level Organized by

28-Nov-07 Initial Learning Program Tata Consultancy Ser-

vices26-Jun-

08 CORBA 1 - E0 Tata Consultancy Ser-vices

26-Jan-08 Knowledge of iQMS and Quality Models 1 - E0 Tata Consultancy Ser-

vices9-Jan-09 Network Security (ISM) 1 - E0 Tata Consultancy Ser-

vices30-May-

11 Old: Lean Six Sigma (LSS) 2 - E1 Tata Consultancy Ser-vices

22-Oct-09 Telecom - Assurance 1 - E0 Tata Consultancy Ser-

vices10-Nov-

08 Testing 3 – E2 Tata Consultancy Ser-vices

21-Jul-08 Visual Basic.NET 3 - E2 Tata Consultancy Ser-vices

11-Jan-12 Analytical Ability 2 - L2 Tata Consultancy Ser-

vices11-Jan-

12 Communication 3 - L3 Tata Consultancy Ser-vices

11-Jan-12 Continual Learning 2 - L2 Tata Consultancy Ser-

vices16-Apr-

08 Foundation - C 3 - E2 Tata Consultancy Ser-vices

1-Jul-08 Foundation - C++ 3 - E2 Tata Consultancy Ser-vices

26-Feb-10

Foundation - Testing Concepts, Process and Methodology 3 - E2 Tata Consultancy Ser-

vices24-Jan-

12 Innovation & Creativity 2 - L2 Tata Consultancy Ser-vices

9-Apr-12 Lean Six Sigma (LSS) 2 - E1 Tata Consultancy Ser-vices

15-Sep-08 Network Routing(WAN Technology) 1 - E0 Tata Consultancy Ser-

vices29-Aug-

08 Network Switching(LAN Technology) 3 - E2 Tata Consultancy Ser-vices

26-Jan-08 Organizational Awareness 1 - L1 Tata Consultancy Ser-

vices24-Jan-

12 Organizing & Planning 1 - L1 Tata Consultancy Ser-vices

11-Jan-12 Team Skill 2 - L2 Tata Consultancy Ser-

vices3-Jan-13 TL 9000 1 - E0 Tata Consultancy Ser-

vices29-Mar-

10 VB.NET 9.0 2 - E1 Tata Consultancy Ser-vices

Training Conducted

Year Title Presented To Location Organized by

2013

Defect Management Process Training Humana Inc. Noida Tata Consultancy Ser-

vices201

2 Concepts of Testing: Training SDR/SDSTesting Team Noida Tata Consultancy Ser-

vices201

1 QTP Training BTGS Team Guragaon Tata Consultancy Ser-vices

2011 HPQC Training BTGS Team Guragaon Tata Consultancy Ser-

vices201

0 VB Script Training BTGS Team Guragaon Tata Consultancy Ser-vices

2009 IPMS Training BTGS Team Guragaon Tata Consultancy Ser-

vices200

9 Process Compliance Training BTGS Team Guragaon Tata Consultancy Ser-vices

Personal Details

Date of Birth Jun 10th, 1985Sex MaleNationality IndianMarital Status MarriedNumber of Children One (Daughter)Employee ID 238761E-Mail ID November 28, 2007Designation I.T. AnalystLocation Pittsburgh, PA-15275, USAPassport Details Passport Number: G3553065 Issued at Lucknow on 28/06/2007 Valid up to date 27/06/2017VISA Status US Visa H1B – Stamped, Petition approved till 09/28/2018

Sandeep Kumar Gupta_Resume

Documents

Transcript of Sandeep Kumar Gupta_Resume