Candidates About

 

                 Muttala  Sanjay                                                                                                                              

Summary

➢     12+ years’ of experience as QA Analyst/Business Analyst/Functional consultant in Oracle Retail and Oracle Apps Supply chain modules. Experience with major clients including The TJX Companies, Supervalu, Cisco, GE HealthCare, Xerox and Agilent.

➢     Strong experience with Oracle Retail platforms like Retail Predictive Applications Server (RPAS), Retail Merchandising System (RMS), Retail Price Management(RPM), Retail Demand Forecasting (RDF) as well as Oracle Applications Release 11i & R12 modules such as Oracle Order Management (OM), Inventory (INV), Purchasing (PO), Account Payables (AP) and Account Receivables (AR).

➢     Experienced in Order to Cash and Procure to Pay business flows.

➢     Good familiarity with Retail planning business processes and concepts such as Item Planning (IP/MUP), Merchandise Financial Planning (MFP), Location Planning (MLP) and Advanced Inventory Planning(AIP)

➢     Experienced in creation of functional test plans and test scripts, detailed design documents, Requirements Matrix documentation, and test execution during requirement, design, Integration and testing phases

➢     Expert in performing various kinds of testing including Functional, System, Regression, Integration and UAT.

➢     Experience in gathering/clarifying business requirements, performing GAP analysis between target (TO BE) and existing procedures (AS IS), and designing process and system improvements to increase productivity and reduce costs. Experience in mapping business requirements with latest Oracle retail/apps flows, preparing Use cases and functional specifications.

➢     Experience in HP Quick Test Professional / Unified Functional Testing (QTP/UFT) with Automation Framework & HP ALM Quality Center/ Administration- Upgrade & Support.

➢     Solid understanding of SDLC Processes and strong knowledge of different software development process (V-Model, Waterfall projects, AGILE Methodology) and testing concepts. Good knowledge in using various SQL Development Tools like Toad, SQL Developer.

➢     Experience with project management responsibilities including resource allocation and timeline management, and coordinating onshore/offshore efforts.

➢     Have good skill with people, quick learner and “Can Do” attitude. Excellent communication skills with leadership qualities.

Educational Background

Bachelor of Engineering from Jawaharlal Nehru National College of Engineering/Kuvempu University, year 2002

Skills:

ERP/CRM Packages(Oracle apps)	Oracle Order Management, Purchasing, Inventory, Account Payables(AP), Account Receivables(AR), Oracle CRM
Oracle Retail	Oracle Retail predictive Application Server (RPAS) v 15.0, Oracle Retail Merchandising System (ORMS) v 13.1, Retail Demand Forecasting(RDF)
Database	Oracle 9i/10g
Oracle Tools	Have working knowledge of Pl/SQL, querying data and writing SQL queries
Testing tools	Test Management tool (HPQC), HP UFT, Win Runner

 

Employment History

 

Role                           : Oracle Retail Business Analyst/QA Analyst (4/2016 – Present)

Client                        : TJX, USA

Location                   : Marlborough, Massachusetts, USA

 

Responsibilities:

·         Working as Oracle Retail Business Analyst/QA Analyst, performing analysis and providing solutions for RPAS (Oracle Retail Predictive Application Services) v15.0 application for Merchandise Unit Planning (also called as Item Planning), Plan Admin & Setup, Merchandise Financial Planning (MFP), Merchandise Location Planning (MLP) and Inventory build modules.

·         Analyzed RPAS requirements and mapped the current business process with RPAS design specifications for various modules including Merchandise Unit Planning, Plan Set and Admin and Inventory Build modules. Also responsible for overall testing activities of RPAS Planning (Oracle Retail Predictive Application Services) v15.0 for TJX’s off-price retail business.

·         Performed GAP Analysis for RPAS application in TJX, analyzed business requirements, developed process roadmaps with business users and clarified any ambiguity of requirements with technical team. I was also involved in developing functional specifications based on business requirements and ensuring technical delivery meet functional specifications for Item Planning, Plan Setup and Admin and Inventory Build modules

·         Created process flows to address business requirements, use cases & documented high level scenarios for RPAS functional testing for Item Planning, Plan Setup and Admin and Inventory Build modules which includes validating measure calculations and data flow within different workbooks.

·         Prepared test data requirements for RPAS functional testing based on the business requirement documents (BRDs) and high level scenarios. For example, Attribute-Member mapping, Division-Dept. mapping and other data needs.

·         Reviewed and participated in discussions on existing and proposed business flows, testing various standard & custom solutions proposed for RPAS v15.0, analyzing Business / Functional Requirements and Use Cases.

·         Continuous participation in meetings with team working on enhancing the legacy Merchandise Reference Data systems to run with the new planning system. 

·         Performed estimation of the effort and time required for RPAS 4 wall testing, Inbound and outbound test executions phases

●     Developed test plan, defined test strategy, test scenarios and scope for RPAS functional and inbound and outbound process. Also, developed test execution plan and defect management process

●     Reviewed test cases and obtained sign-off from respective stakeholders. Managing test execution and reporting of test cases development and execution.

●     Interacted with QA’s, BA’s and Business users and created TCERs (Test Cases and Expected Results) for the identified scenarios of RPAS as per the TJX needs.

●     Worked on Measure Definition sheet which serves as a single source of truth for all the RPAS measures used in TJX Companies. This sheet includes the measure flows from one module to another and also the interaction and aggregation rules for the measures.

 

Role                           : Business Analyst/QA Automation Analyst (3/2015 – 03/2016)

Client                        : State Street Corporation, USA

Location                   : Quincy, Massachusetts, USA

 

Responsibilities:

●     Performed Business Analyst/QA Analyst role for IBOR (Investment book of records) and ERISA regulatory reporting application for State Street Corporation.

●     Involved in Automation of manual test scripts using TAF frame work and UFT tool

●     Interacted with offshore team on daily basis for knowledge transfers and addressing functional queries.

●     As a part of Agile Implementation, actively participated in Pre-planning, daily stand-up calls, Demos and Retrospective meetings

●     Demonstrated the working software to the Business at end of each Iteration.

●     Interacted with Development and Business teams for functional and technical issue resolutions that were confronted during test execution

●     Gathered and analyzed requirement documentation with business users for ERISA application.

●     Developed test plans and prioritized testing activities on a day to day basis as I was responsible for the overall testing related project activities.

●     Developed test execution and defect management plan. My role also involved assessing the problems accurately in design documents and generating a resolution. Ensured that design documents meet the business requirement specifications.

●     Reviewed test cases and received sign-off from respective stakeholders

●     Knowledge transfer to individual team members.

 

Role                           : Oracle Retail QA Analyst (3/2012 - 3/2015)

Client                        : TJX, USA

Location                   : Marlborough, Massachusetts, USA

 

Responsibilities:

●     Worked as Oracle Retail QA Analyst for RPAS (Oracle Retail Predictive Application Services) v13.0 application.

●     Defined test strategy and performed requirement analysis & GAP Analysis for RPAS application in TJX.

●     Performed estimation of the effort and time required

●     Developed test plan and defined test scenarios and scope for high and low level test cases

●     Reviewed test cases and obtained sign-off from respective stakeholders

●     Developed test execution plan and defect management process

●     Manage test execution  and reporting of test cases development and execution

●     Developed all documents for project closer

●     Interacted with BA’s and business users and created TCERs (Test Cases and Expected Results) for the identified scenarios of RPAS as per the TJX needs.

●     Worked on Measure Definition sheet which serves as a single source of truth for all the RPAS measures used in TJX Companies. This sheet includes the measure flows from one module to another and also the interaction and aggregation rules for the measures.

●     Interacted with offshore team on daily basis for knowledge transfers and addressing functional queries. Reviewed test cases/execution/ defects.

 

Role : Oracle ERP Functional Consultant – Order Management, Inventory, Purchasing and AR (12/2010 - 11/2011)

Client                        : GE Healthcare, USA

Location                   : Milwaukee, WI, USA

 

Responsibilities:

●     Responsible for Functional/testing services for GE Health Care Oracle instances namely GL Prod, Prod ERP, GPM, Bio Prod, VCP, and OTM.

●     Configuring all settings for Order Management, Inventory

●     Performed Functional and Regression testing for Oracle apps modules i.e. Order Management (OM), Purchasing (PO), and Inventory (INV).

●     Completed analysis of SCM strategies and drafted evaluative client reports. Create Sales Orders in Order Management and run whole O2C Cycle.

●     Worked on Procure-to-Pay (P2P) cycle for creation of requisitions, purchase orders and receipts.

●     Defining Suppliers and customers.

●     Sales Order, booking release, ship confirm, finished Goods.

●     Creating different kinds of purchase orders, RFQ,s as a part of functional testing of GL prod instance.

●     Invoiced or billed items are matched to the original purchase orders to ensure that you pay only for the goods or services you ordered or received.           

●     Represented functional team in the Release management calls and interacted with Release management team for detailed schedules of the Releases (GL Prod, Prod ERP, GPM, VCP Prod, and OTM) and discussed the roadblocks and issues faced during release test execution.

●     Interacted with the functional owners for defect downgrades and resolution of functional issues that were encountered during the test execution.

●     Interacted with the validation team for test script/test defect rejections and defect closures during the test execution.

●     Interacted with program teams for functional and technical issue resolutions that were confronted during test execution.

●     Interacted with the Operation Leads (client) for providing updates on the release schedules, functional issues, defect resolutions and other status.

 

Role                           : Quality Analyst (4/2010 - 11/2010)

Client                        : Cisco, USA

Location                   : San Jose, CA, USA

 

Responsibilities:

●     Performed System functional and Regression testing for CISCO International.

●     Interacted with the client for requirements gathering

●     Prepared test plan and test strategy

●     Set up the test execution baselines and prepared metrics summary reports

●     Drove the defect status calls and defect status reports

●     Prepared the test execution plan.

●     Walk through the test cases with the business and IT stakeholders and got sign offs for the test cases

 

  Role     : Oracle ERP Functional Consultant – Order Management and Purchasing (03/2008 -  3/2010)

  Client                      : Cisco, USA

  Location                 : Bangalore, India

 

Responsibilities:

●     Performed functional/testing activities for the Service Offer Enablement (SOE) initiative at CISCO. This project also involves the regression testing of 4 important client related applications on Quarterly releases. They are Jigsaw, eDelivery, SWIFT and SAAT.

●     Involved in gathering and analyzing the requirements.

●     Configure Order Management, Inventory, to meet client requirements and document application set-ups.

●     Oracle Quoting to submit a quote as an order, perform manual price overriding or create new customer information.

●     Configuring all settings for Order Management, Inventory

●     Involve in CRP sessions with clients and validate the systems.

●     Written/Executed regression scripts of O2C flow.

●     Prepared and executed test cases and logged defects.

●     On-site coordination for whole testing activities and provided daily and weekly project status updates.

●     Distributed work to each offshore team member and tracked the progress for each module.

●     Involved in preparing the RTM (Requirement test matrix) and test execution reports.

●     Prepared test cases for system testing and peer reviewed test cases/execution.

●     Executed test cases and tracked defects.

●     On-site coordination for whole testing activities and provided daily and weekly project status updates.

 

Role                           : Oracle Retail Business/QA Analyst (9/2007 - 02/2008)

Client                        : Supervalu, USA

Location                   : Bangalore, India

 

Responsibilities:

●     Performed testing of Oracle Retail Applications for RMS (Retail Merchandising System) and RPM(Retail price Management)

●     Involved in analyzing the requirements for ORMS application.

●     Involved in preparing test scenarios and updating them based on the change requirements.

●     Prepared test cases based on identified scenarios and performed peer reviews.

●     Executed test cases in HPQC (Quality center)

●     Involved in defect tracking and reporting in HPQC and hosted Defect Triage meeting to discuss the defects with Development and business team.

 

Role                           : Oracle ERP Functional Consultant – Order Management, Inventory, (7/2006 - 8/2007)

Client                        : Xerox, USA

Location                   : Bangalore, India

 

Responsibilities:

●     Performed testing for the managed services Business XONE which is the initial venture of moving part of the back office into Oracle.

●     Involved in analyzing the requirements, preparing  the test plans, scenarios and scripts  

●     Was involved in the preparing the training documentation and responsible for training the offshore team

●     Involved in testing and tracking the discrepancies using Test Director Tool.

 

Deloitte Consulting, Software Analyst                                                                                                       8/2004 -7/2006

 

Role                           : QA Engineer (8/2005 - 7/2006)

Client                        : Hewlett Packard, USA

Location                   : Mumbai, India

 

Responsibilities:

●     Studied the Requirements and understood the flow of the HP-IPC application.

●     Performed Testing services for HP-IPC application

●     Involved in preparing test cases.

●     Performed sanity checks on the application

●     Involved in testing and tracking web issues

●     Performed unit, functional, integration and regression testing on the application.

 

Role                           : QA Engineer (08/2004 - 7/2005)

Client                        : Agilent Technologies, USA

Location                   : Mumbai, India

 

Responsibilities:

●     Was responsible for supporting and testing various standard & custom solutions within the Oracle Supply Chain Planning & Logistics department. Provided QA services for Order Management (OM), Purchasing (PO), Inventory (INV), & Accounts Receivables (AR) modules.

●     Create Sales Orders in Order Management and run whole O2C Cycle.

●     Supported and tested various standard & custom solutions within Oracle Supply Chain Planning

●     Defining Supplier, departments, customer.

●     Sales Order, booking release, ship confirm, finished Goods.

●     Was responsible for supporting and testing various standard & custom solutions within the Oracle Supply Chain Planning & Logistics department. Provided QA services for Order Management (OM), Purchasing (PO), Inventory (INV), & Accounts Receivables (AR) modules.

●     Analyzed functional specifications for Application and created test Scenarios Order Management (OM), Purchasing (PO), Inventory (INV), & Accounts Receivables (AR) modules.

●     Performed Functional and Regression Testing

●     Involved in preparation of test plan, test strategy and test cases.

●     Executed test cases and logged defects in HPQC (Quality Center) tool.