PROFESSIONAL SUMMARY:

• Oracle Retail Supply Chain ERP professional with 10+ Years of experience in Functional & Non - Functional Consulting, Analyst, Planning, Testing, Management and Deliverables. Worked on client engagements involving Functional & NF Requirements Analysis, Managing, Test Data Management,, Functional, Automation & Performance Testing and Production Support.
• Domain experience spanning the end to end Business Processes inRetail/Supply Chain/ERPdomain.
• Experience in Functional Consultant, Functional/Performance Test lead, System/Intergration Lead,Production Support, UAT Lead, Project coordinator and leading diverse team in onsite-offshore model.
• Lead QA team & Hands on Experiencce Multi & Omni channel implementation, including Foundation, Merchandising, Inventory, Pricing,Planning,Distribution,Order Management,Procurement,Batch Jobs,Payments,Returns & Supply Chain management.
• Extensive Functional experience in RPM, RMS, ReSA, RPAS (MFP,RDF & PP),Allocations, Batches, WMS, OMS,REIM, OBIEE Reports,POS,PO ASN EDI/NON EDI,EDI File Transfer,Multi Channel & Omni Channel Environment,RETL,MDM,JDA WMS (AS400), Batch Jobs Monitoring & Testing, and other END-END Systems (Pricing systems,EBS etc.) involved in Oracle Suite.
• Extensive Functional experience in OracleE-Business Testing on variousModules Order to Cash,HRMS,Payroll,SCM,Procurement,GL,Accounts Recievable & Accounts Payable.
• Extensive Functional experience in Oracle OMS, IBM Sterling OMS, Web portal, IBM Iseries AS400 and JDA WMSI (Purchase Order DC&HUB Fulfillment, DOM,Sales Audit, B2B/B2C commerce, Xstore orders, Quote Orders,Order Management,Cash Balancing, Payments,Catalog Management,Sourcing, Order API’s, XML,Webservices,RTAM,scheduling, Pipeline,SDF, Wholesale Distirbution,Web portal orders Account receivable and Inventory Control).
• Experience in gathering Functional and Non-Functional Requirements & Analysis, Documentation, Planning, Engineering, Testing and Support.
• Experience in RMS 12, 13, 14 & 15, RPM 12, 13, 14 & 15, REIM 12 & 14, RWMS 12, RPAS14,Allocations 14 versions.
• Expertise in various QA methodologies such as system testing, system integration testing, regression testing, End to End Testing, Functional testing, Unit Testing, black-box testing, Database & ETL testing, Production Support testing, Batch job, Performance testing,data conversion testing and user acceptance testing.
• Experience in Unified functional testing tool (UFT), Framework development & Informatica and Knowledge in Selenium,Continuous Integration,Delphix & Loadrunner.
• Experience in Test Data Management, ETL (Informatica) and Data checks.
• Experience in Performance engineering (Architecture, Monitoring, Trace & AWR report analysis), Gathering SLA’s, conducting walkthroughs, Batch Jobs monitoring,Session monitoring,Online tests, Bottlenecks identification,complete ownership of environments and reporting status to stake holders.
• Experience in POS functional testing like Sale, returns, promotional offer validations.
• Writing SQL queries as part of back end validationand Pl Sql Code analysis & problem solving Skills.
• As a Functional consultant, Involved in Functional design documents and business process flow documents and provided the guidance to business users and supported the development and testing team to resolve the functional queries and issues.
• Involved in UAT Planning, Execution, Support and Management.
• Well experienced in STLC Waterfall and Agile (SCRUM) methodologies.
• Experience in Functional, Performance, Prodution Support and UAT Lead (10 resources) which includes Managing team, Functional/Non-Functional Test Plan & Strategy Preparation, Defining SLA’s, Environment Ownership, Test Planning, Test data preparation, Defect Management & Analysis, Co-ordination, Partcipating in Status, Review,Defect Triage & MileStone meetings,Documentation, Communications, Processes, Constant improvements, Online testing, Batch testing and monitoring.
• Experience in Production support and implementation
• Expert in Analyzing the Business Requirements and Reviewing the Design to meet the Business Requirements.
• Designed functional specifications for various requirements of RMS & RPM based on business requirements.
• Experience in SOAP UI web services, EDI jobs & Reports Testing
• Working experience in AS400,Mainframe and Unixand Batch testing experience in Unix & Mianframe servers
• Providing on-callsupportofproductionapplications and will work closely with Business, technology groups, and other internal teams to monitor, triage, and resolve issues, responsible for and mentoring less experienced team members.
• Extensive experience in Planning Activities, Creating Test plan, estimation, requirements traceability matrix and standard templates (Test Summary Report, Daily status report, RCA, ABCD report and Defect/PM process), Internal and External Audits).
• Good Experience in Software Development Life Cycle (SDLC) & Software Testing Life Cycle (STLC).
• Collaborate between cross-functional teams to ensure system integrity
• Experience intestmanagement tools like Clear Quest, Jira,HP QC & HP ALM
• Excellent communication & interpersonal skills with proven abilities in resolving complex technical and functional issues.
• Highly motivated team player with strong communication, organizational and analytical skills, worked in/for teams and adhered to the planned development time frame.

TECHNICAL SKILLS:

Oracle Retail/Supply Chain/ERP: Oracle Retail Merchandising System (ORMS), Pricing Management System (ORPM)Oracle Retail Sales Audit, Oracle Retail Allocations(ORESA), Oracle/JDA warehouse management (WMS), Oracle retail Invoice Matching(OREIM), Sterling Order Management System (OMS), MDM,Manhattan/Oracle Warehouse management, I series, RPAS, Oracle Financials and Oracle retail Point of Sale (ORPOS)

Programming Languages: Java, Plsql, Unix Shell scripting, VB Scripting

Database: Oracle DB, SQL & PLSQL

Integration Technologies: Abintio, TIBCO,Soap UI and RIB

Test Management Tools: HP Quality Center, HP ALM, Clear Quest & Jira

Automation Tools: HP QTP, UFT 11, Selenium IDE / Web Driver

Performance Test tools: NMON, XYMON & Load runner

Configuration & tools: VSS, SVV, TFS,Control+M, Clearcase and Github.

Servers: Unix,AS400 & Mainframe

PROFESSIONAL EXPERIENCE:

Confidential, Watsonville, CA

QA Test Support Consultant

Responsbilities:

• Interacting with Business analysts/SME’s and understanding the OMS, JDA Fullfillment, Hybris,Xstore & I series Business process flow and requirements
• Analyzing the Business requirements and Design testcases aligned to approve requirements (Traceability Matrix).
• Collaborate with business, solution architects, integration lead and functional leads to understand the system architecture and prepare the business scenarios
• Coordinating Peer Review & Global review activity to ensure sign off of deliverables
• As an Test Lead, Prepared Testplan doc, Test Strategy and support for the overall testing efforts and delivery of quality software applications.
• Co-coordinating with Offshore/Onsite Team membersfor updating the daily and weekly status.
• Create and manage overall program test scope, work plan, deliverables / milestones and align the dependencies and test dates with all internal and external stakeholder and roll up to the program plan.
• Ensure Requirements (functional & non-functional) and test cases for various test phases - (System Test, System Integration, End to End, Performance Testing, Regression test, User Acceptance Test (UAT Phase), conversion and Operation Acceptance tests) are reviewed and signed off by the Business teams
• Participating in Daily touch base, Weekly status and defect triage meetings
• Plan and facilitate test planning and review meetings
• Complete ownership on QA test environment and deliverables
• Coordinating with Oracle team for Functional and Non-Functional issues resolution
• Executing the Functional and Non-Functional Order management system (OMS) migration test scenarios (Customer creation, Bill to payment, Retail/Wholesale orders creation, fullfillment and maintenance)
• Performed Retail & Wholesale orders distribution E2E validations after performing JDA WMS fulfillment.
• Executed the Inventory adjustments, SKU creation, SKU status, Contract Pricing,Vendor status, ASN Creation, order creation, order release, Store Pick/Shipment Pick, Pack,Shipping, Drop Ship to Customer,Cash Deposit and customer maintenance for Order Fullfillment validations.
• Invoice fax and printing validations after performing pick pack & shipping (JDA WMS)
• Performed Sales receipt and Invoice validations after perofming PPS
• Web orders placement and validating the details in Hybris and Iseries and then performed JDA WMS fulfillment.
• Validation of End-to-End testing of various touch points - Order origination, Order Fulfillment, Order Settlement and Invoice & billing, Sales, inventory postings and Migration Testing orders to down streams
• Validating the batch job process
• Prepared the Functional flow documents and test reports
• Prepared the test data for UAT
• AR & GL posting validations (Oracle EBS).
• Performed online PO creations test with larger volumes as part of performance testing.
• Involved in Production implementation activities
• Conducted the Requirement review meeting with business analyst and team members
• Ensure Testscripts are documented, reported and tracked in HP Quality Centre.
• Ensuring that defects are logged with the appropriate level of detail to enable the fix team to progress with root cause analysis & problem resolution
• Effectively communicated and reported all the issues at the program level as and when required.

Environment: Oracle, Hybris, OMS, JDA WMSi, Vertex, XStore, B2B Ecommerce, AS400,IBM iseries, EBS,GL,Account Recievables, Account Payables, PL/SQL and HPALM/QC.

Confidential

Test Lead/Functional Consultant

Responsibilities:

• Understand the business requirements, document business gaps, configurations and integrations of RMS, RPM and other legacy systems.
• Involved in preparing Testplan doc, Estimations and support for the overall testing efforts and delivery of quality software applications.
• As a Consultant, Involved in Preparation of RMS 13/15 & RPM 13/15 Business process flow documents to Business users, analyzing/resolving the production issues, SME sessions and assist the team members for functional flow/resolving testing issues.
• Responsible to work with cross-functional teams - Business Analysts / Solution architectural meetings to understand the business processes across systems, system architecture - integrations, infrastructure, application scalability, data & user growth etc. to assess the testable and non-testable functional and non-functional requirements
• Defined Master Test Strategy / Approach, testing standards, processes and tools and educated project teams, clients and vendors to standardize and industrialize the test methodologies and ensured the project test leads are adapted.
• Acted as RMS/RPM SME
• Involved in discussions withOracleSupport on various Functional and Non-Functional SRs (Service Requests).
• Coordinated with Solution architects, Service delivery team and business to understand the performance Impacts & Considerations and defining the SLA’s
• Given performance test results walkthrough with SD team for Signoff
• Coordinating & Lead the Offshore/Onsite system, performance and UAT teams.
• Involved in RMS 15 & RPM 15 Performance planning, engineering, reporting and execution.
• Supported the business users during user acceptance testing and Involved in SME sessions with Business users.
• Executed the RMS 15 & RPM 15 Batch jobs performance and online testing
• Provided the functional and batch flow process to Jr performance testers
• Prepared the higher volumes for Batch Job Performance testing
• Prepared the Functional & Performance Test plan, Test results and Test summary report
• Monitored the Sessions and reported the long running queries to technical team and
• Analyzed the trace files
• Interacted with business users, Support team and resolved the User interface issues and Performance issues during Production Support
• Evaluate risks associated with testplans and make recommendations for alternative testing approaches.
• Involved in System & integration Testing and validated the Functional flow between different Legacy systems (MDM, Purchase Order & Allocation systems, Promotional planning, RMS & RPM).
• Executing the Foundation, PO, Sales posting, stock ledger and Pricing (Price Change, Promotion and Clearance) test scenarios (RMS&RPM).
• Validated the Item, Cost, Price, Inventory, PO and Promotions functionality within RMS/RPM and between RMS/RPM - MDM, sterling OMS, KOO, EBS,KMA and Promotional planning systems.
• Performed Item, Inventory Adjustment and purchase order creation testing between RMS-MDM-KOO-OMS.
• Performed Payments,Shipping and rules validations as part of OMS testing
• Performed the Price Change, Promotions and Clearance testing between RMS-RPM-MDM-PPE & KPEP.
• Performed Purchase order, EDI and promotions data extract batch jobs and file transfer testing.
• Performed Full and delta extract batch jobs testing.
• Performed backend validations after loading the data
• Prepared and executed data conversion scripts as part of migration.
• Responsible for guiding the performance testing team to understand the functionality and batch flow.
• Responsible for Phase specific Milestone plan weekly updates.
• Responsible for maintenance of test deliverables and audit
• Implemented Defect management life cycle process.
• Daily execution and monitoring the batch jobs (UNIX and Mainframes server).Validating data in & out file & processed data in backened & Files.Log files validation in Unix server.
• Involved in implementing process improvements for Quality Assurance and Functional/ Nonfunctional testing processes through HP ALM
• Monitored the Jobs during warranty support
• Peer review Testcases, write and analyze customized HPQC Excel reports for testplan, test execution and defects
• Coordinating Peer Review & Global review activity to ensure sign off of deliverables
• Effectively communicated and reported the execution status and issues at the program level as and when required.
• Analyzing the defects by looking into the data and driving cursor which are reported by off shore team, before assigning to development team.
• Coordinating with Development team for defect fixes based on deliverable impacts.
• Preparing Weekly reports and status updates calls.

Environment: Java, PLSQL, RMS 15, RPM 15, MDM, Sterling OMS, UNIX, Main frames, GL,SQL Developer, Github, Jira, HP ALM/QC.

Confidential

Senior Consultant

Responsibilities:

• Understand the business processes, identify gaps and recommend system modifications and processes to satisfy business requirements
• Involve in solution design and architectural meetings to understand the business requirements and document the fit gaps, test scope and integration needs of the solution
• Review and Configure Allocations base and custom measures, Size Profiles, Rules, etc., coordinate with development for the build timelines and delivery dates
• Prepare end to end / integrated high level business scenarios as per the requirements and prepare traceability matrix, work with Business process specialists and technical leads for the sign off.
• Review ST and E2E test cases and coordinate with Business specialists, Functional consultants and Solution Architects for the signoffs.
• Involved in preparing Testplan doc, Estimations and support for the overall testing efforts and delivery of quality software applications.
• Involved in Unit Testing, System Testing, System Integration, Performance Testing and Production Support.
• Prepared functional specifications document for manual allocations business requirements
• As a Consultant, Assist Team Members in the resolution to Oracle Retail functional issues
• Responsible for the Test Case Reviews for all the mods and CR’s.
• Executed the RMS Foundation, Purchase Orders, Allocations, sales, stock ledger, Inventory Adjustment, Pricing & OBIEE reports Test scenarios
• Executed appointment, shipment and receiving scenarios in JDA WMSi
• Extensively worked on creating PO, VASN, Shipment, Cartonizing ASN
• Performed inbound/outbound validations between RMS/Allocations/Manhattan WMS.
• n-callsupportofproductionapplications and interacted with management and technical teams to resolve the issues on priority
• Responsible for Production Fixes Testing and Release.
• Worked on Change Requests (CR) with Change Management and deploy the code onproduction successfully.
• Responsible for Assigning the tasks and managing the team & Corresponded with project stakeholders and management
• Performed Automation POC using UFT tool and Involved in framework design.
• Prepared test scripts using descriptive programming.
• Perform validation of applications during code release / patching.
• Providing feedback to the team and ensuring that any processes & templates are utilized correctly
• Coordinating Peer Review & Global review activity to ensure sign off of deliverables.
• Coordinating with Development team for defect fixes based on deliverable impacts.
• Capturing risks & issues (in agreed format)- Mitigation Plan
• Prepared Test Completion summary reports

Environment: Java, ADF, Allocations 14, RMS 14, RPM 14, WMSeries,PLSQL, UNIX, UFT 11, OBIEE reports, SQL Developer, SVN, HPALM/QC

Confidential

PSE

Responsbilities:

• Understand the project objective, scope and timelines from customer perspective and involve in the planning meetings and manage expectations.
• Developed Test strategy, Test Plan, Test Cases, Test Scripts and Test Execution forOracleStandard functionality and customizations.
• Worked closely with the HR department for Requirement understanding, analysis and understand the HR Processes
• Test Case identification, Preparation & Execution.
• Verfied the Buisness Group,Work structure, Employee information,Organization hierarchies
• Performed the reports testing as per customization
• Responsible for Creation of Test Plan and defining tasks to be done and estimating time for those tasks
• Responsible for Assigning the tasks and managing the team
• Responsible for test case,execution, defect management,reporting and defect triage.
• Intreatced with Business analyst and users for functional clarifications and buisnes process understanding
• Performed Order to Cash & Procurement functional testing.
• Workflow Manager & Interface validations
• Experience in testing process flow of Finance General Ledger (GL) in Oracle EBS along with the other modules like Accounts Payable and Account Receivables.
• Actively involved in any of the financial modules problem solving with respect to functional issues
• Use of HPQC for Tracking, Analyzing and reporting defects.
• Performed the Invoice, Customer statement,GL vat post,AP supplier,AR Debit and GL reconcillation validations.
• Detailed testing of the Forms and Financial reports.
• Actively involved in the testing of Cycle Releases in the agile methodology.
• SDLC standards were followed for the project.
• Sending Daily/Weekly status reports to management and stake holders

Environment: ORACLE EBS, HRMS,Payroll,OTC,GL, AR, AP,SCM,PO and SQL developer.

Confidential

 PSE

Responsibilities:

• Understand the project objective, scope and timelines from customer perspective and involve in the planning meetings and manage expectations.
• Involve in Solution design, Design Handover, Architectural meetings, Defect triage meetings to understand the business requirements and document the fit gaps, test scope and integration needs of the solution
• Responsible of Creation of Functional and Performance Project Test Plan, defining tasks to be done and estimating time for those tasks
• Responsible to work with cross-functional teams - Business Analysts / Solution architectural meetings to understand the business processes across systems, system architecture.
• Responsible for Assigning the tasks and managing the team
• Responsible for leading the E2E test cycle and coordinated with developers and representatives of external systems
• Plan and facilitate test planning meeting. Managed the Functional,Automation & Performance testing teams
• Responsible for the Test Case Identification & Reviews for all the mods and CR’s.
• Analyzing the data collected on the number of review comments received while test case definition stage and help team to continuously improve test case identifying capability.
• Wrote SQL queries using Joins,Union,having,etc for data validations in Backend.
• Performed data integrity checks after transforming the data
• Ensuring that all team members are clear about the role which they play in the team, the activities which they are expected to undertake and timescales for delivery.
• Involved in Sprint planning, Backlog, Sprint review and Daily scrum meetings
• Providing feedback to the team and ensuring that any processes & templates are utilized correctly
• Managed the Functional and Performance test environments and Interacted with DBA team for backups and restore environments.
• Performed the Pricing and RMS batch jobs functional & performance testing
• Performed the Deals, Orders, Price and Promotion approvals with higher volume and Monitored & captured the performance.
• Performed the PO,Deals and Pricing online performance tests using HP load runner tool.
• Performed Pricing scenarios Automation using UFT tool and Involved in framework development.
• Responsible for Maintainence object repository and Reporting.
• Prepared test scripts using descriptive programming.
• Extracted and Analyzed the trace files and Requested DBA’s for AWR report
• Executed the Foundation, Cost, Replenishment, Purchase Order, Deals, Inventory adjustment, Sales Audit, Stock ledger, Price Change, Clearance/Markdown, Simple and Complex promotions test scenarios
• Responsible for Production Implementation, PM Test, Regression Test and Performance Test planning and reporting.
• Performed the Load Jobs testing and validated in backend
• Performed Integration testing between RMS and WMS (Ordering, Shipment and receiving)
• Validated the Appointment and received labels.
• Sourcing rules,Pipeline & Order API Validations
• PO creation, Schedule,Release and Shipping test scenarios validation
• Performed Store Pick,Customer Pick and Store shipping validations using Sterling Store
• User roles,Organization,Payments,RTAM,Inventory Catalog management,Returns,Agents and Pricing
• Validated the stock orders distribution, DC setup, Item management,Picking and put away functionalities
• Performed the Promotional Offers End to End testing ( system includes RMS,RPM,Legacy applications & POS)
• Performed defect impact analysis and retested the impacted areas on priority before releasing patch
• Supportapplications in L2 level and communicate with L3 team for any complex issues, take the ownership of the incident/Problem till resolution.
• Direct incident recovery and cross-functional teams to collaborate on issues and working on outages till the resolutions.

Environment: RMS 12, RPM 12, RESA 12, WMS 12, POS, Java, PLSQL, RPAS,UFT,Webservices,API,Sterling OMS,ATG Commerce,Oracle Financials,UNIX, SQL Developer, AR,Informatica,Load Runner, ClearCase, ClearQuest.

Confidential

Senior Test Engineer

Responsibilities:

• Attended planning meetings to understand the scope of each module
• Prepared test cases based on Functional Requirement Specifications.
• Updated the test cases based on any implementation changes.
• Involved in System Testing, Patch Testing, Batch Testing and Integration Testing
• Defect tracking and reporting defects through CQ
• Performed Foundation replenishment, purchase orders, Resa, Deals, Pricing and Promotion execution
• Performed invoice matching testing (ReIM)
• Created a Service Request in Oracle metal link and Interacted with developers.
• Involved in Functional & Regression testing
• Designed the SQL queries to check the back-end information
• Fixed the defects raised during the system and regression testing and prepared the defect documents for the same.
• Performed Foundation,PO,Deals,Pricing,Replinshment,Stockedger,Inventory & invoice match scenarios execution
• Prepared the test data and performed batch testing.
• Performed Appointment, Shipment, Receiving and Return to vendor scenarios in WMS
• Reported the defects through Quality Center and various matrices using MS Office.
• Report defects and communicate with the development team
• Involved in System testing of the entire applications along with team members.

Environment: RMS 12, RPM 12, RESA 12, ReIM 12, GRS, WMS 12, POS, Java, PLSQL, UNIX, SQL Developer, Clear Case, Clear Quest.