Sabyasachi Patra

QA Project Lead

Email: acz8p6@r.postjobfree.com

Contact no: 704-***-****

Summary

9.5 years of Information Technology Consulting experience at Advance Auto Parts, Cognizant Technology Solutions and Infosys, in Retail, Healthcare and Electric Utility Domain.

QA Project Lead, currently managing entire SDLC, STLC and Defect Management processes of Merchandizing Systems, Supply Chain, WMS and Web Services projects for current Client in Retail Domain.

Scrum Master Certified.

In-depth Technical Knowledge of

Software Quality Assurance,

Project and Process Management

Mobile / Tablet Testing (IOS / Android)

Oracle RMS 13.2.5

Oracle Retail Merchandise Financial Planning (MFP)

Mainframe / AS400 Testing/ Autosys Job Monitoring

Automation Testing / HP QTP/UFT

Performance Testing / JMeter

Web Application Testing

Cross Browser Testing

SSRS Report Testing

ETL Testing

Point of Sale (POS) Testing

HP Quality center 10.0 / HP ALM / JIRA

Service Testing / Parasoft SOA / SOAP UI

Microsoft Test Manager

Agile Testing

Defect Management

Database Validation / Oracle DB / MS SQL Server

.Net Framework 2003, 2007

In-depth Functional Knowledge of

Oracle Retail Merchandizing System (RMS)

E-Commerce

Content Acquisition Request System (CARS)

Size Pack Optimization (SPO)

Assortment/Merchandize Planning (RMSX / APX)

Retail Invoice Management System (REIM)

Supply Chain Management

Warehouse Management System (WMS)

Manhattan Pick Ticket Management System (PKMS)

Oracle Merchandise Financial Planning (MFP)

Purchase Order Management System (POM)

Content Management & Planning (CMP)

Healthcare Provider & Member

Electric Utility

Multiple Project Awards and Appreciations from Advance Auto Parts, Belk Inc., Cognizant Technology Solutions, Staples Inc. & Infosys.

Proficient in working in Agile Delivery Model for cross-functional teams and multiple stakeholder groups. Capable enough to handle multiple projects and assignments in same deployment schedule.

Experience Summary (9 Years & 6 Months)

Advance Auto Parts

4th May 2015 – Till Date

Cognizant Technology Solutions

7th April 2010 – 1st May 2015

Infosys Technologies Ltd

29th October 2007 – 5th April 2010

Projects Details (Isite Technologies INC @ Advance Auto Parts – Roanoke, VA)

1.Integrated Availability – Independent Channel

Business

Overview

Till date, ADVANCE AUTO PARTS is having 5200 company owned and 1300 independently owned stores. After acquiring Car Quest, Worldpac - integration between their systems is started. Now they have started to bring the Independent stores under the same AAP umbrella. That is why this Integrated Availability project is on the way by which Advance Auto parts will have the capability of keeping all the inventory, sales details of those Independent stores which will be supplied to them from AAP side and on the same independent stores will have the ability to keep other items from other vendors in their stores which is not associated with AAP.

Technical

Overview

Car Quest Independent stores uses Exploris system. Through this project, AAP will send a maintenance feed from AS400 system to Exploris system via tilde delimited flat file based on the Opt in/ Opt out criteria set in Location Master – a Java program which will determine for which Line/part Number, Independent Stores will need the inventory at their hand from AAP. And the same feed will send to different WMS systems available in Advance – those are Red Prairie, Exeter and High Jump.

Role

Integration QA Lead (Client Side – Roanoke, Virginia)

Contribution

Working as an Integration QA Lead in Retail Merchandizing team focusing on the integration between Advance Auto Parts and Car Quest Independent Stores based on HOST - AS400 systems, CAR Quest Exploris Systems, Three different WMS – Red Prairie, Exeter, High Jump along with Stores Systems (APAL)

Performed the roles of QA Lead, concentrating on Requirement Analysis, Functional Test Execution, Integration Testing Approach and Planning, Defect Management, Integration testing, Integrated Testing Report and Production Readiness Assessment. Used Microsoft Test Manager as a Test Tool.

Worked Directly with developers of undertaken company Car Quest and different key people of all different Warehouse Management Systems

Involved in all meetings & presentations, heavy co-ordination with multiple Project teams at multiple locations to facilitate the Integration testing

Period

From July 2016 Till Date

Team Size

36

Client

Advance Auto Parts

2.Lowest Selling Unit (LSU)

Business

Overview

The LSU project standardizes item configuration between Advance Auto Parts (AAP) and CARQUEST (CQ) such that items are inventoried and sold at the lowest sellable unit.

Technical

Overview

This project enables a store to sell a Store Sell Quantity (SSQ) of greater than 1 by the piece or lowest sellable unit. This new SSQ field is introduced in RMS and AS400 systems for all existing and new items. A new conversion mechanism is built in RMS to convert incoming data from vendors that do not sell to Advance Auto Parts (AAP) below pack/box size for items that have an SSQ greater than 1. It creates one time conversion programs to set the SSQ for all items and blow out the on hands for all existing items with an SSQ greater than 1.

Role

Senior QA Lead (Client Side – Roanoke, Virginia)

Contribution

Involved in Test Planning, Test Design and Test Execution

Maintaining Test Artifacts in Microsoft Test Manager

Involved in Defect Management, Integration Testing

Daily Status Report, Defect Report, Executive Summary Report, Weekly Report

Period

From January 2016 to June 2016

Team Size

16

Client

Advance Auto Parts

3.Supersession

Business

Overview

This project eliminated the need to re-use AAP SKUs by creating the ability to link SKUs together for historical sales reporting, inventory tracking, and demand forecasting. It has improved the AAP customer experience by ensuring the customer receives the same item they viewed/ordered in-store or online. It provides the capability to have a one-to-one relationship between AAP SKU and CQ Line Code/Part Number, solving the many-to-one cross reference issue.

Technical

Overview

It builds the ability to link SKU’s together so that they are available to all corporate systems. Starting from AS400, RMS, AAMS Custom Mix, Store planner, IKB, ASR, AWR, WMS, Zilliant, E-commerce, EPC, EDW. AAP uses an Assortment Planning Tool i.e. Oracle RMSX – a Java Application where Linking/Delinking is done based on SKU creation from STEP application. Then Linking/Delinking information feeds into Oracle RMS and Legacy System – AS400. From AS400 the information goes to Store Systems.

Role

Senior QA Lead (Client Side – Roanoke, Virginia)

Contribution

Directly worked with Business/IT people starting from Test estimation & Planning, Test case preparation and Test Execution

Maintaining Test Artifacts in Microsoft Test Manager

Involved in Defect Management, Integration Testing

Coordinating with Other team from a different location and Generating Test Report.

Period

From October 2015 to December 2015

Team Size

10

Client

Advance Auto Parts

4.Merchandising Financial Planning Enhancements (Oracle MFP)

Business

Overview

Advance Auto Parts uses Oracle MFP for Financial Planning for their entire business. After acquiring Car Quest, AAP requires a new Sales Channel be added to the MFP solution to allow for the planning of the CARQUEST Channel for DC Sales to Independents. It has to have the ability of updating the Original plan while in-season along with the feasibility of new BOY Measure, new Turn Measure, New Budget Line, New LLY Gross Margin and so on.

Technical

Overview

Oracle MFP is a complete suite to all handle all kind of Financial Planning for a Company for multiple years. And it stores past year data as well. It deals through Original Plan, OP Plan, In Season Plan, RP Plan, WP Plan and financial Budget can be done based on Company Label or any particular sales channel based on Current Financial Year, or Past Financial Year or Future Financial Year. Total budget can be divided into Yearly, Half Yearly, Quarters, Periods and Weeks.

Role

Senior QA Lead (Client Side – Roanoke, Virginia)

Contribution

Directly worked with Business IT people starting from Test estimation & Planning, Test case preparation and Test Execution

Maintaining Test Artifacts in Microsoft Test Manager,

Involved in Defect Management, Regression Testing, Deployment Planning

Coordinating with Other team from a different location and Generating Test Report.

Period

From June 2015 to July 2015

Team Size

5

Client

Advance Auto Parts

5.New Commercial Pricing (NCP)

Business

Overview

The goal of the Commercial Exception/List Pricing project is to introduce to the pricing process the concept of pricing exceptions to be executed at the commercial customer account level. Also, it will introduce not only new methods for calculating list price for customers but will offer the ability for customers to customize the calculation of the list price to suit their needs.

Technical

Overview

The New Commercial Pricing project introduces a new pricing method that can be applied at an individual customer account level, as opposed to a grouping of customers. Referred to as exception pricing it in essence provides a systematic override of the pricing available through the customers’ normal pricing methods and addresses a need to allow pricing deviation from a customer’s assigned pricing group for specific products. The pricing can be set at any level of the merchandise hierarchy, with or without brand code restriction, or to a SKU group with one or more SKUs.

The pricing Engine is maintained in AS400, then the price feeds into CCDB which is a Oracle DB to identify the related commercial customer, then it goes to ES (Enterprise Services) as Central Repository where all pricing logic gets applied and then it feeds to APAL (store systems – POS/Point of Sale) to see it in POS register and at last it reaches to EDW for Reporting.

List pricing functions are also included in the New Commercial Pricing project. The business will have the ability to set default list pricing using the same parameters available for exception pricing

Role

Integration QA Lead (Client Side – Roanoke, Virginia)

Contribution

Working as QA Project Lead, taking care of IT project and process activities for Retail Merchandizing team of Client Advance Auto Parts. Focusing on different Pricing mechanisms generated in HOST - AS400 applications, Oracle RMS with an integration of Customer Database system, Pricing Team, Enterprise Service team, Store Systems (POS team) and EDW.

Handling the Pre-Production and Post-Production Defect Management Life Cycle Processes for multiple project tracks, resulting in the successful minimization of rectification delays.

Performed the roles of QA Lead, concentrating on Requirement Analysis, Functional Test Execution, Integration Testing Approach and Planning, Defect Management, Integrated Testing Report and Production Readiness Assessment. Used Microsoft Test Manager as a Test Tool.

Involved in all meetings & presentations, heavy co-ordination with multiple Project teams at multiple locations to get the Integrated Testing Report, Deployment Planning.

Period

From May 2015 to Oct 2015

Team Size

26

Client

Advance Auto Parts

Projects Details (Cognizant Technology Solutions @ Belk INC. – Charlotte, NC)

1.Project SMART (Oracle Retail Merchandizing System)

Business

Overview

Project SMART was aimed at bringing in new Retail Industry standards enterprise packages while sun setting majority of the older legacy applications in Belk. The new off-the shelf enterprise applications would offer more user-friendliness, robustness, maintainability along with business benefits in terms of cost, accuracy and obviously, effort savings.

Technical

Overview

The SMART enterprise architecture comprises of several integration layers. The Oracle Retail applications sit on the AIX UNIX operating system with Oracle application server and database. Oracle Retail has its internal messaging layer called RIB, which in turn integrates with the IBM ESB message gateway to communicate with the external legacy interfaces. There is an ETL layer too, which sits between Oracle Retail modules, SAS and the legacy applications to transform the data and feed the respective systems in their own format.

Role

Project Lead (Client Side – Charlotte, North Carolina)

Contribution

Working as QA Project Lead, taking care of IT project and process activities for Retail Merchandizing division of Client Belk Inc. focusing on Oracle Retail Merchandizing System (RMS), Legacy (Mainframe) applications, Manhattan PKMS, Retail Invoice Management System, Assortment Planning, Size Pack Optimization, Product Inventory Management, AUTOSYS job monitoring, Oracle DB transactions.

Handling the Pre-Production and Post-Production Defect Management Life Cycle Processes for multiple project tracks, resulting in the successful minimization of rectification delays.

Performed the roles of QA Lead, concentrating on Project Estimation, Resource Planning, Requirement Analysis, Test Execution, Defect Management and Production Readiness Assessment.

Involved in client interfacing, all client meetings & presentations, offshore coordination, Status Reporting through HP ALM, Heavy co-ordination with business & other third party vendors.

Leading the Operations and Functioning of a diverse team of 32 associates, based out of multiple locations, assisting them in attaining Organization’s IT goals.

Successfully coordinating Project’s/Organization’s Innovation initiatives in the Retail domain, which is leveraged across the numerous Consulting projects, for achieving a high standard in Customer satisfaction. Won Top Innovator award.

Period

From February 2014 to April 2015

Team Size

32

Client

Belk Inc.

2.CARS, RMS & PIM Integration - Retail Domain

Business

Overview

CARS Application is the Content Management Portal of Belk.com website. Previously all down-stream applications of CARS were from Mainframe – Legacy systems. Now Belk has implemented RMS (Retail Merchandising System from Oracle) with other third party application integration like SAS, PIM from IBM. Now CARS system is getting interlinked with RMS & PIM instead of IDB & Mainframe.

Technical

Overview

Belk has newly purchased the Oracle Retake RMS package from Oracle. It has integration with Invoice system, Inventory, Shipment, Ordering, and Purchase Order. It has a direct link with Product Inventory Mgmt (PIM – IBM Product). Now the data is flowing from RMS to PIM then it is coming to CARS via ESB layer instead of all other legacy applications like POM, VEN, RLR etc.

Role

Project Lead (Client Side – Charlotte, North Carolina)

Contribution

Working as Project Lead, taking care of IT project and process activities for the integration of Oracle Retail Merchandizing, Purchase Order Management with Content Management Portal of Belk.com website using RMS, MDM, SOAP UI, Parasoft SOA Test and UNIX applications and AUTOSYS job monitoring.

Potential involvement in Project Estimation, Resource Planning, Requirement Analysis, Testing Life Cycle, Defect Management and Production Readiness Assessment.

Involved in Service Testing through Parasoft SOA Test and XML validation through SOAP UI for different Enterprise services between and Content Acquisition System and Master Data Management (MDM/PIM)

Period

From July 2013 to Jan 2014

Team Size

15

Client

Belk Inc.

3.CARS (Content Acquisition Request System) - Retail Domain

Business

Overview

CARS Application is the backbone of Belk.com. It is very crucial to Belk.com’s success over past 2 years. Before publishing in the website, all the products (along with different SKUs) used to get created in this application through different user roles maintaining a product life cycle.

Technical

Overview

CARS application is developed on Java. In this application, a product used to appear from item database, then it processed through different hierarchy and then it got transferred to a blue martini application called CMP (content Management Portal) as a XML by executing Unix Batch jobs. Then from CMP, a Blue Martini Index xml used to get created which feeds into Belk.com for publishing the product into website.

Role

Senior QA Lead (Client Side – Charlotte, North Carolina)

Contribution

Involved in client interfacing, offshore coordination, Test estimation & Planning, Test Strategy, Test Plan & test case preparation, Performance Test Monitoring

Maintaining Test Artifacts in Quality Center, JMETER Load Test Report Analysis

Test execution, Defect Life Cycle, report generation with the help of HP QC

Database Testing, SSRS Report Testing, Unix Shell Script execution

Automation testing through HP QTP for whole regression suite of CARS.

Period

From April 2012 to June 2013

Team Size

25

Client

Belk Inc.

4.Belk.com (Usability & GCR ) – Retail Domain

Business

Overview

Belk is a Fashion Retailer Giant in US and http://Belk.com is a web store which supports home products such as bedding, fine china, and other amenities, and accessories, shoes, jewelry along with the apparel collection. www.belk.com is the key application in the Belk eCommerce Suite.

Technical

Overview

Belk.com is developed on Java/J2EE in Blue Martini framework. Usability project is based on total GUI functionality of the website and GCR project is for Gift Card Redemption in the belk.com website. There are many third-party integrations exist in this project for issuing gift card, validating billing & payment, review submission, fraud detection etc. This belk.com eCommerce test suite has been executed in Mobile (Android / iPhone), tablets & iPad also with the help of JIRA & Lighthouse through another third party vendor – Moovweb in Usability mobile project and the same is tested in POS machines.

Role

Senior Quality Analyst (Client Side – Charlotte, North Carolina)

Contribution

Involved in client interfacing, offshore coordination, Test estimation & Planning, Test Strategy, Test Plan & test case preparation,

Maintaining Test Artifacts in HP QC, Issue tracking in JIRA & Lighthouse

Test execution, Defect Life Cycle, report generation with the help of QC

Mobile/Tablet testing through iPhone simulator of safari, androids,

Testing in Mac, tablets & iPad, Mobiles and in Point of Sale (POS).

Performance Test Result Analysis through JMETER

Automation testing through HP QTP for regression suite of belk.com

Period

From April 2011 to April 2012.

Team Size

17

Client

Belk Inc.

5.OFL – LCA (Order Fulfillment Logic – Least Cost Algorithm ) – Retail Domain

Business

Overview

Order fulfillment logic (OFL) is the most recent feature inducted by Staples Inc to fulfill ever growing demand of customer order automation. LCA (least cost algorithm) is a logic applied in staples wherein customer orders are fulfilled in such a manner that the cost involved will be minimum. This also takes into account the customer preferences.

Technical

Overview

OFL LCA Service, a J2EE-compliant enterprise application designed to work within Sterling Order Management to compute the Least Cost Delivery option based on the analysis of the inventory availability, customer expectations and shipping costs. Here a client web interface is used, called CITRIX. Using citrix, & with the help of Para soft SOA test tool, we used to validate XMLs.

Role

Programmer Analyst – Testing Services (Offshore – Kolkata, India)

Contribution

Involved in different types of Testing based on Manual Testing,

AS 400 Data validation, & Service Testing through automation tool – Para soft.

Period

From April 2010 to April 2011.

Team Size

10

Client

Staples

Projects Details (Infosys Technologies Limited – INDIA Location)

1.Provider QES - SFE (Smart Front End) – Healthcare Domain

Business

Overview

It is a project of healthcare domain of the client Aetna. SFE – Smart Front End deals about the provider details. Here provider is a doctor, any Medicare provider etc. This web application takes care of all the data like Tin/address, affiliation, specialty, Network, Bank Account details etc for all the providers enlisted in Aetna.

Technical

Overview

This is a web application where front end is prepared in J2EE and backend is DB2. For testing, mainframe & HP Quality Center were used.

Role

QA Analyst (Offshore – Orissa, India)

Contribution

Involved in different types of Testing (Mostly System Testing),

Test case preparation & test case execution in QC,

Test Strategy & Test Plan preparation, Configuration Management

Period

12 Months, From March, 2009 to March, 2010.

Team Size

38

Client

Aetna

2.AMIX ETL Tool (Extract – Transform - Load Tool) – Electric Utility Domain

Business

Overview

It is a product developed for utility industries from data transformation between any cross database, xml, any type of flat file (CSV, TSV, and Fixed Length), web service, DLL of existing systems. It is Infosys Internal Product, bought by the client SCE, Itron.

Technical

Overview

This is a windows application developed in purely C# .Net. It uses .Net framework 2.0, 3.5. Scheduler is developed in visual studio 2008 for timely execution of transformation, extraction and loading of data from any database to database(SQL, Oracle,DB2), XML, Flat File, DLL; any XML to any database, Flat file, DLL, web Service, any Flat File to Database, XML, Web service, DLL etc.

Role

Software Developer (Offshore – Orissa, India)

Contribution

Involved in Design, Coding, Unit Testing, Integration Testing.

Period

4 months, From November, 2008 to Feb, 2009.

Team Size

5

3.GDT (Graphical Design Tool) – Electric Utility Domain

Business

Overview

It is another project of electric utility domain from the client SCE (South California Edison). It deals the whole design for electric set up for Transmission, Substation, and distribution to end users. This tool is used for all the services like service request, product design, costing, invoice, pricing.

Technical

Overview

This is a client server service which is purely developed in Visual studio 2003 with .Net framework 1.1, VB.Net language & Oracle 9i in backend. This is a seven-layered architecture; DVO & DTO are used for data transfer between Database & view-controller.

Role

Software Developer (Offshore – Orissa, India)

Contribution

Involved in Design, Coding, Unit Testing, Integration Testing, Configuration Controller

Period

9 months, From Feb 2008 to Oct 2008

Team Size

40

Highlights’

The project won the best project award in IBU level.

Client

SCE – South California Edison

Software Proficiency

Technologies :Testing(OracleRMS/WebBased/Service/Mobile),C#.Net, Mainframe, AS400

OS : Windows

Framework : .Net 1.1, 2.0, 3.5

Quality Assurance Tools : HP ALM/Quality Center, Para soft Service Testing Tool, JIRA, JMETER

Lighthouse, SOAP UI, Microsoft Test Manager, HP QTP/UFT

Database : Oracle, SQL Server, AS 400

Domain : Retail, HealthCare, Electric Utility Industries.

Achievements

Received IMO recognition Exceptional Performance Award two times in 2015 and 2016 @ Advance Auto Parts

Received Best Team Player award in 2013 & 2014. Top Innovator in 2014 @ Belk.

Got Excellence awards from Belk for two consecutive successful releases of CARS in 2012.

Rewarded as an ‘Extra Mile’ resource for handling multiple projects in 2012 @ Belk

Got award from ‘Belk’ for Successful July Release of Ecomm in 2011 at client side.

Got Hi 5 Certificate from Client ‘Staples’ in Cognizant in 2010.

Got Reuse Champion Award in Infosys in 2009.

Nominated twice as the Most Valuable Player in Infosys in 2008 & 2009.

Nominated for Best Fresher candidate in 2008 in Infosys.

Education

2007

Bachelor of Technology (B.Tech) in Information Technology (4 Year Degree Program)

West Bengal University of Technology, ST. Thomas College of Engg & Tech, INDIA (80.4%)

2003

W.B. Council of H.S. Education (12th Grade)

Vivekananda Institution, Howrah, INDIA (68.2%)

2001

W.B Board of Secondary Education (10th Grade)

Vivekananda Institution, Howrah, INDIA (85.25%)

Contact this candidate