EXPERIENCE SUMMARY:

• Around 5 years of extensive experience working as Software Quality Analyst. Extensive experience in Agile and waterfall methodologies. Strong experience in Smoke testing, regression testing and functional testing.
• Extensive experience in functional testing in ERP (Oracle application) modules Order management & inventory. Well versed in testing the web based applications. Testing various menus corresponding to functionalities in YODA web based application in Confidential & Confidential .
• Strong knowledge of testing Integration of various applications and End to End testing. Strong in performing sanity and smoke testing.
• Strong knowledge of Change Management, bug fixing, defect logging and fixing and maintain the test cases and defects in HP ALM.
• Strong in testing the application based on Oracle database manually using SQL.
• Very good experience in Sterling Console and MQ - Explorer to test the Order Management Application.
• Experience in executing Linux commands.
• Self-motivated and strongly deadline-driven. Strong management, administrative and leadership skills to work in team.

TECHNICAL SKILLS:

Operating Systems: Window 2000/XP/VISTA/7, Linux

Databases: SQL Server, Oracle

Languages: VB Script, HTML, SQL, XML, SQL, PL/SQL

Testing Tools: HP Quick Test Professional, Load Runner, SOAP-UI, MQ Explorer, SQL Developer, ATG Database, Sterling Console, SharePoint, CVS (Concurrent Version System)

Bug Tracking Tools: Quality Center, BugZilla, Jira

Design tools: Microsoft Visio, Gliffy

Other Tools: Microsoft Office Suite (Word, Excel, PowerPoint, Outlook). Houdini

WORK EXPERIENCE:

Confidential, Clarksburg MD

ERP Functional Tester

Responsibilities: 

• Wrote test cases for testing the YODA order flow to Oracle, WMS and back to YODA. Created various type of orders depending of their functionalities (DF Order, Bulk Order and Fee Order) for the test cases and tested to ensure if the flow of these orders from YODA to Oracle to WMS and back to YODA is working as per requirements.
• Wrote test cases to test the functionalities of various menus in YODA such as Search (Order, Shipment, Serial Number, Item, Customer, Fulfillment, Credit Card Payments)
• Wrote test cases to test the functionalities of menu reference values (Commitment Pricing, Market Pricing, and Sales Rep). Tested the functionality to update the sales rep using data file template.
• Used HPALM (Application Life Cycle management) to create the test cases. Import those test cases in test lab and tested per the expected results. Logged the actual results, uploaded respective screenshots and upon failure of a test case, created defect. Assigned the defect to the development and follow up. Once the defect is fixed, retesting and closure of defect.
• Day to day job includes checking the Orders in YODA (Web based system) to release holds in YODA and Oracle, approval of ports in YODA. Adding inventory for items in Oracle in FDC (Fort Worth Distribution Centre) and MDC (Memphis Distribution Centre) organizations. Identifying where the order stuck and processing those orders further, identifying if shipping and invoicing for the orders are complete in Oracle and YODA, Adding SKU in YODA environment, processing RMA (Return Material Authorization) Orders to WMS. Running the concurrent requests in Oracle to process the deliveries stuck in Oracle-WMS interface.
• Worked on Oracle application Order Management and Inventory modules. Adding Quantity to items, running concurrent requests, releasing holds, running interfaces to create delivery for order and ensuring delivery is transferred to Oracle. Running interface to pick up the shipped delivery from WMS and invoicing the orders in Oracle and further in YODA hence completing the end to end flow of Orders.
• Assisting users from various teams in their teams by providing them their order, delivery and shipment status.
• Used Jenkins to UI testing to schedule, run and kill a job for Storm test control.
• Daily team meetings to provided/collect status of testing, following up with development team on the status of defects.
• Wrote complex SQL queries using joins, sub queries to perform SELECT, UPDATE and DELETE

Environment: Oracle11g, SQL, PL/SQL, Windows 7, MS office, HP ALM (Application Life Cycle Management), SharePoint, Oracle application modules Order Management, Inventory.

Confidential, El Segundo CA

Software Quality Assurance Analyst

Responsibilities: 

• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.
• Working knowledge of Linux operating systems. 
• Working on Production Support to pick up tickets and debugged the issues in the SQL objects.
• Performed Server-Client Integrations testing, Adding/Removal of Clients. 
• Working knowledge of Linux operating systems. 
• Tested and verified new feature BBVOD and VOD 1-click playback, downloads, and recordings
• Besides feature testing also involved in testing QT/FR Test Plan using Test Link. Builds provided Confidential least twice a week used CVS as a source.
• Worked on new features of the year 2013 which were DVRLite for MRVAudit(Multi room viewing Audit) for HMC (Home Media Center).
• Have tested on IPAD and Andriod phones and iPhone as well using Confidential app sources.
• Working knowledge of Wi-Fi and networking technologies. 
• Performing functionality and regression testing, reporting bugs & verifying bugs. Involved in unit, integration, functional testing, system, smoke and acceptance testing.
• Executed test cases, analyzed problems, and created detailed defect reports, tracking, verifying and closing fixed defects using JIRA.
• Given Demonstration on the various features and also Mentor other team members.
• Participated in test case review meetings and requirements walkthroughs. 

Environment: Oracle10g, SQL, PL/SQL, Test Link, Windows XP, MS office, IE, Jira (defect tracking system), Linux, Wiki, Concurrent Versions System 1.0.4 (CVS), MS Excel, FileZilla 3.7.3 win32, Putty, VPL/Sling, Content Download Network (CDN) Simulator version 2.3, SHEF(Set Top box Http Exported Functionality), Dataport, FTP (File Transfer Protocol).

Confidential, Pittsburgh, PA

Quality Assurance Analyst

Responsibilities:

• Responsible for analyzing BRD, FRD and involved in creating test plans which elaborated the customer needs, functional areas, test requirements.
• Performed initial Manual Testing of the application after creating test scenarios.
• Performed Functional, Smoke, Sanity and Regression testing in the system using SQL Queries.
• Worked on writing/debugging PL/SQL Procedures, Functions and Packages.
• Coordinated and controlled testing through the entire Software Development Life Cycle (SDLC)
• Performed API testing of all Interfaces sterling integrated with ATG platform of AE commerce website
• Have tested on IPAD and Android phones and iPhone as well using American Eagle Outfitters app sources.
• Used XML to update inventory on API admin section. Also read and understand XML logs.
• Tested end to end flow of the orders from Order creation to Order shipped.
• Verified Inventory changes for the orders placed and shipped on Sterling Console Application.
• Performed testing different SKU and item for cancelled and backordered scenarios
• Performed International order with foreign currency for the American Eagle website
• Performed testing on different payment methods like PayPal, BML (Bill Me Later), JCB.
• Used sterling tool (Sterling Application Console) to perform Order sourcing and scheduling.
• Used Sterling console to checked inventory on SKUs and items.
• Wrote complex SQL join queries to extract data from database for unit and functional testing.
• Updated the testing related documents including testing scenarios, test cases and relevant scripts throughout the later stages.
• Tested POS application reports for reports of daily transactions, receipts of the goods purchased by the customer, a list of new products and maintain and update reports of stock.
• Worked closely with the development staff with regards to system functionality and bug fixing.
• Used Jira to track the defects and making pass-fail reports.
• Worked with the technical teams investigating and resolving bugs based on the testing results
• Attended weekly meetings and presented a progress report.

Environment: Hardware/Software: Quick Test Professional (QTP), HP Quality center/ALM, Jira, Excel Sheet, SQL Server, SQL, HP Service Test, Selenium IDE, HTML, ATG Database, Sterling Database, Jira, MS Excel, SQL Developer, IBM WebSphere MQ Explorer.