SUMMARY

• Over 6 years of IT experience with expertise in QA Analyst in Retail (Supply Chain Management), Banking and Finance domains.
• Strong understanding of project life cycle and SDLC methodologies including RUP, Waterfall and Agile.
• Proficient with testing tools such as HP Quality Center, Quick Test Pro, testing client/server, web based applications, Win Runner, Test Director, Load Runner (performance) Testing and Visual Studio Team System.
• Experience designing and developing of SQL statements on Oracle Sybase, SQL Server 2000 database and SQL400 (AS400).
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Experienced in manual and automated testing for both front - end and backend.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Experienced in conducting requirement analysis, use case design, designing test plans and developed database schemas based on the logical models.
• Working noledge of implementing software development projects using methodologies such as Waterfall, Rational Unified Process, and Agile/Scrum.
• Extensive experience in conducting Joint Application Development (JAD) sessions.
• Extensive use of HP Quality Center as Test Management tool as well as defect tracking tool and also IBM Clear Quest for change management/defect tracking.
• Proven expertise in creating test plans, UML diagrams, flowcharts, screen mockups and systems requirements specifications.
• Highly motivated, result oriented professional with a short learning curve and strong communication skills.

TECHNICAL SKILLS

Methodologies: Agile Modeling, Waterfall model, Iterative model

Requirements tools: Rational Requisite Pro, DOORS and Quality Center

Domain: Retail, Banking, Finance

Software: Oracle RMS, AS400, Oracle RPM, Allocation, PIM, Dematic IQ, OTM (Oracle Transportation Management, IBM Sterling Store version 9.2, IBM Sterling selling and fulfillment (OMS)version 9.2, Oracle SIM, People Soft, Service now

Languages: C, SQL, VB, HTML

Databases: Oracle, MS SQL Server, DB2400, MS Access 2000, DB2, DB visualizer

Testing Tools: QTP, Load Runner, HP Quality Center 10.0, HP ALM 12.5

Operating Systems: Windows, UNIX

Defect Management Tools: Rational Clear Quest, Quality Center, HP ALM and JIRA

Others: MS Office, MS Project, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Katy, TX

Sr. QA Analyst

Responsibilities:

• Requirements gathering and understanding from Business meetings.
• Involved in the development and implementation of Test Plan, Test Scenarios and Test Cases for functional, system requirements.
• Extensive testing is carried out in the integrated systems: Sterling Commerce for Order Management Systems, message Broker ESB, Middle ware RIB and IBM Web-Sphere Message Broker for Integration.
• Writing System/Integration Test cases for Sterling, WMS and preparation of test data.
• Involved in unit, performance testing throughout project.
• Performed Manual testing such Smoke testing, Integration testing, System Testing and Regression testing
• Used WCS Application to create orders and sterling generated shipment number that unique identifies this customer shipment.
• Used newly created RF functions for the Order fulfillments and tested them thoroughly.
• Worked with the operations to execute the different UC4 jobs on WMS, ETL data stage. Also monitored the results and captured test logs.
• Tested the WMS picking, shipment applications which involves complex business processing steps to fulfill the eCom orders.
• Tested Automated Dash board screen to track incoming, outgoing shipments and reports.
• Heavy data validation TEMPhas been done at WMS application in AS400 while communicating with Sterling and RMS applications.
• Attended daily defect-triage meetings with developers to explain the defect details.
• Use to send test execution summary report and defects report to the project team every day.
• Interacted with eCom teams for End to End validation

Environment: JIRA, Oracle RMS, MQ Series, IBM Sterling Store version 9.2, IBM Sterling selling and fulfillment (OMS)version 9.2 IBM I Series AS 400, Lotus Notes, Oracle SQL, HP ALM, UC4OPS, Wireless HIP Printer, RF Gun, TOAD,JAVA,RPG,middler ware ESB and RIB

Confidential, Katy, TX

Sr. QA Analyst

Responsibilities:

• Requirement gathering and understanding from Business meetings.
• Involved in creating data (Purchase Orders, Transfers, EDI 856, Items, Stores, allocations, transfers) at RMS application for the QA testing and Business Users to perform UAT testing.
• Interacted with Third Party Vendors (Dematic) for testing third party applications as part of the end to end testing. This involved challenges around to setup test environment with WMS through MQ messaging end.
• Involved in project status meetings, requirements gathering meetings, daily stand up meetings, status update meetings.
• Tested the MQ interfaces which loads the foundation data like Items, UPCs, Vendor, Stores details.
• Tested the interfaces which communicates the picking instructions with Dematic.
• Tested the interfaces which processes the voice picking instructions from Dematic and resolve the pick directives at Academy (WMS - AS400 system).
• Tested the Put to light interface between Dematic and Academy which creates the store containers at WMS system.
• Tested the interfaces like Divert Confirmation which updates the container information with diverted lane at WMS.
• Tested the interfaces like inventory report corrections, cycle count, re-slot SKUs at DMS location.

Environment: JIRA, Oracle RMS, RPM, Allocation, SIM, MQ Series, IBM I Series AS 400, System i navigator, Lotus Notes, Oracle SQL, HP ALM, Dematic IQ, Service now, middle ware ESB and RIB

Confidential, Katy, TX

Sr. QA Analyst

Responsibilities:

• Requirement gathering and understanding from Business meetings.
• Heavily involved in creating data for testing
• Performed Integration and System testing
• Tested newly WMS menus, screens and criteria’s to add the stock orders in Stock order Pool
• Used newly different kind of Release logics ( FIFO, Pick to Clean, Pick to Empty, Pick to Efficiency and Pick Store Pallet ) to generate dynamic pick instruction
• Co-ordinated with UC4OPS teams to run batch job and analyze the test results and test logs.
• Operated wireless printers for label generation based on the release logic
• Tested different kind of picking sorts for pick process.
• Participating in Daily stand up meeting.
• Provide weekly status report to the Project Manager and discuss issues related to quality and deadline.
• Using JIRA and HPQC to track all issues and defects.

Environment: Oracle RMS, Allocation, SIM, MQ Series, IBM I Series AS 400, System i navigator Lotus Notes, Oracle SQL, HP ALM, Wireless HIP Printer, Service Now, UC4OPS, Middleware System ESB and RIB

Confidential, Katy, TX

Sr. QA Analyst

Responsibilities:

• Reviewed the Business Requirement Document to understand the process and write Test Plan and Test cases.
• Used HP Quality Center for writing Test Cases and Defects tracking.
• Developed test scenarios and test cases based on user requirements.
• Tested foundation data (UPC) loads migration between OTM application and RMS
• Tested the interface which sends item data from RMS to OTM when items are added or changed.
• Tested the interface which sends PO data from RMS to OTM when POs are added or changed.
• Tested the interface which sends voucher (One stop and multi-Stop) information from OTM to PeopleSoft.
• Tested the interface which sends the planned shipment data (PPD, Collected and Transfer) from OTM to Inbound Cargo.
• Co-ordinated with UC4OPS team to run the batch jobs which creates the invoices in people Soft application.
• Supported the business people for UAT Testing and data validation in people soft and inbound cargo application.
• Defects and Issue resolution was conducted on a daily basis during the defect triage meeting.

Environment: Oracle RMS, Lotus Notes, Oracle SQL, HPQC, Oracle Transportation management (OTM), People Soft, Inbound Cargo, IBM Message broker, Middle ware system ESB and RIB

Confidential, Katy, TX

Sr. QA Analyst

Responsibilities:

• Developed Test Plan and wrote Test Cases.
• Co-ordinated with operations to run the ETL data stage batch Jobs and monitored the test results.
• Verified the results by running the SQL queries on the each database.
• Validated reconciliation report based on the data Mapping rules.
• Providing Weekly Status Report to all stakeholders
• Tracked all issues & defects using the HPQC.
• Participating on Daily Scrum meeting from Enterprise SQA team.

Environment: Oracle RMS, System I navigator, Lotus Notes, Oracle SQL, HPQC, UC4OPS, IBM I Series AS 400, DB Visualizer database, Allocation Application

Confidential, Katy, TX

Sr. QA Analyst

Responsibilities:

• Interacted with Business and BSA’s to get Fredo requirements finalized.
• Created Test Plan for each Scrum cycle during Functional Testing phase.
• Worked on Requirement Traceability with functional testing test cases using HPQC.
• Tested the RF function FRC for unplanned receiving and planned receiving.
• Tested complex and iterative business scenarios involved in this process.
• Tested dynamic labels creation like back stock, store label or batch labels based on the scanned data.
• Heavy data validation TEMPhas been done for Available/Unavailable inventory and pick instruction with RMS.
• Participated in Scrum Meeting from QA perspective.
• Provided support to Business and BSA’s during the UAT phase.
• Used HP Quality Center 10.0 to house all test documentation and report/track all issues and defects.
• Interacted with multiple teams for End to End testing.

Environment: JIRA, Oracle RMS, RPM, Allocation, SIM, MQ Series, AS400, IBM I Series, Lotus Notes, Oracle SQL, HPQC, Wireless HIP Printer, RF Gun

Confidential, Katy, TX

Sr. QA Analyst

Responsibilities:

• Responsible for testing the functionality of Oracle applications like RMS, SIM and Allocations across all phases as a part of Oracle implementation.
• Performed Smoke, Ad-Hoc, System, Functional, Regression and UAT testing
• As part of testing, project had both Agile and waterfall Methodologies in place.
• Involved in reviewing test plan, creation of test scripts and test data.
• Peer-reviewing test scripts created by other team members.
• Performed Interface Validation for interfaces between Oracle applications and Academy Legacy Systems.
• As part of interface testing, heavy data validation was performed between source and target.
• Conducted extensive testing on Warehouse Management System AS400 Application for data.
• As part of Interface validation, performed testing on PeopleSoft Financial and Invoice Management Modules. Validated the data within PeopleSoft Application.
• Heavily involved in creating data (Purchase Orders, Transfers, EDI 856, Items, Suppliers, allocations, transfers) for testing and Business Users to perform UAT testing.
• Co-ordinated the ETL data stage batch Jobs runs with UC4 batch admins and monitored the run results.
• Database testing was performed to validate the data integrity within the database.
• Involved in project status meeting, requirements gathering meetings, daily stand up meetings, status update meeting with offshore teams located onshore and offshore.
• Defects and Issue resolution was conducted on a daily basis during the defect triage meeting.
• Extensively used HPQC for defect and issue tracking, which followed a defect life cycle.
• Responsible for testing and documenting defects / Issues during testing.
• Support business people for UAT Testing and data validation in RMS.
• Use to send test execution summary report and defects report to the project team every day.

Environment: Quality Center, JIRA, Bugzilla, Oracle RMS, RPM, RSM, SIM,OMS, PIM, RIM, PeopleSoft Financials, Java, MQ Series, AS400, Sterling, IBM I Series, POS, SQL Server 2008, Lotus Notes, SQL View Point, UC4OPS, Middle ware system ESB and RIB, Service now

Confidential, Seattle, WS

Sr. QA Analyst

Responsibilities:

• Conducted Automation/manual testing using the Standards, guidelines and structured methodology in testing the application.
• Documented and executed Test plans, Test cases and Test scripts based on business requirement document.
• End to end execution of automated scripts, Test Result analysis.
• Prepared test cases for the system covering SRS document, design document, reviewing them with the developers and finalized the test cases.
• The primary responsibility was to work in Quality Assurance team and put in best efforts to get high quality product.
• Used HP Quality Center for writing Test plans and Test Cases
• Primarily responsible for End to end integration of Oracle Retail Merchandising systems (ORMS) with the Warehouse Management systems (ORDM and PKMS),Direct to Customer systems (CWD), Allocation Systems (SIMS), Point of Sale (POS).
• Developed test scenarios and test cases based on user requirements
• Generated the test scripts for Functional, Data driven and Regression testing using automated testing tool Quick Test Pro.
• Gatheird specifications and requirements to develop Test Plans and to create Test Cases using Quality Center
• Coordinate with Application team of Sales Order Management System, Warehouse Management System and Transport Management System.
• Excellent experience managing the whole testing process using Mercury Interactive Test Management tool Mercury Quality Center.
• Worked on a business case for the development of Oracle Retail Management System (ORMS).
• Involved in Data migration testing between HP Quality center and Rational Clear quest.
• Converted Functional requirements into detailed scenarios and test cases
• Execution of Fitness Test scenarios
• Automated the test scripts for the GUI, Functional, Data Driven and Regression testing in HP Quality Center.
• Responsible for all aspects of the testing process i.e. planning, scheduling, running tests,defect tracking and bug reporting using JIRA
• Worked closely with Business Analysis for designing Fitness test pages before iteration starts.
• Responsible for the documentation of the Test Plans. Guided the Testing team to understand the business logic.
• Performed extensive Smoke, Integration testing, Comparison, Regression and UAT testing to ensure that System is user friendly for customers.
• Database Validation (SQL) to check the updated data in the Database
• Reviewing the test cases through peer review and giving the review comments

Environment: QTP11, Quality Center 9.0, Visio, MS Office, Agile, HP Quality Center,Manual Testing,Quick Test Pro,Automation Testing, Regression Testing

Confidential, Salt Lake City, UT

QA Analyst

Responsibilities:

• Created Testing Requirements Document (TRDs) and Test Case Scenarios to test functional changes to the system/application as per the project requirements.
• Gatheird requirements for the integration of POS system with the supply chain system
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market.
• Implementing Oracle Retail Management System (ORMS) in order to provide a streamlined solution for performing an end to end process of creating a Purchase Order by buyers to Offshore Vendors.
• Created Functional Unit/String test cases for Order Management, Warehouse & Inventory Mgmt., and Planning & Procurement.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools.
• Utilized Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives.
• Use software development collaboration tool (Fitness) to develop User Acceptance Tests.
• Conducted Business Requirements, Functional and Technical meetings with Business groups.
• Developed function specifications for modifications of POS system for multiple chains.
• Create and execute automated test cases: (TFS) Fitness and Spec flow (Gherkin / Microsoft Visual Studio).
• Reported software problems using Jira bug trucking system and verified bugs fixed in new releases.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Developed a thorough noledge and maturity in all the phases of SDLC and familiar with industry standard best practices & frameworks such as RUP (Rational Unified Process), AGILE & Lean
• Came up with test cases from the requirements, validated/exercised those test cases in form of integration and regression tests.
• Coordinate with Application team of Sales Order Management System, Warehouse Management System and Transport Management System.
• Excellent experience managing the whole testing process using HP Quality Center.
• Facilitated user acceptance testing and test strategies with Information Systems Group.
• Used Agile methodology of development to improve customer satisfaction by rapid & continuous delivery of S/W
• Conducted workshops for Use Case writing with User experience groups.
• Managed the whole testing process using HP Quality Center.
• Worked as Track Lead for the Money Movement Platform. Responsibilities included creation and maintenance of Requirement Artifacts and maintenance of Issue tracker on the program management site through SharePoint and other collaboration tools.
• Created Use cases for the various functionalities of Deposit Products.
• Worked extensively on Rational Requisite Pro to create Requirements specification.
• Conducted training for new team member for the Project

Environment: MS Office Suite 2007, MS Visio 2007, SQL, HP Quality Center, Agile/Scrum, HTML, XML, Win Runner, Load Runner, Mercury Quality Center 9.0, RUP

Confidential, CO

QA Analyst

Responsibilities:

• Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation.
• Prepared Test Plans for each release, written Test Cases and executed them as part of Functional Testing. Prepared Test Reports and Deliverables and submitted for version releases.
• Throughout the project, was involved in giving clarifications on domain and product functionality for the team.
• Regular interaction with the core developers helped us in fixing the defects in less time.
• Analyzing Software Requirement Specifications (SRS), Technical Specification and Functional specification Documents for developing manual test cases.
• Developed the test cases to comprehensively cover all possible positive and negative scenarios at the functional and Schema level.
• Analyzed business requirements and system architecture/design.
• Assured that all Artifacts are in compliance with corporate AGILE Policies and guidelines.
• Interact and negotiate with Vendors to complete the tasks related to data conversion
• Followed Agile (XP) Methodology for the release.
• Prepared System Requirement Documents after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Developed Test cases for manual testing and automated them using Win Runner, Silk, Load Runner, Silk performer and QTP.
• Organize requirements into high level Use Cases and low level Use Case Specifications and modelled them into UC, Activity and Sequence Diagrams using Rational Rose and MS Visio.
• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Set up a Master Test Plan and Test schedule in regards to ETL, data warehouse inventory repository maintenance, Meta data development, reporting engine etc.
• Created UAT plans with several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes has been made.
• All the test scenarios which has been satisfied with the functionality are moved to automation testing using Quick Test Professional.
• Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files.
• Plans in MS Word for Manual Testing, System Testing, Integration Testing
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
• Prepared graphical depictions of Use Cases, Business process diagrams, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
• Performed Requirements Traceability and managed changes to requirements for this application using Rational Requisite Pro.
• Analyzed the business and functional requirements of the application and developed detailed test plans, test cases in Test Director.
• Manually tested and GTS modules using Quality Center.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product noledge.
• Conducted User Acceptance Testing, gatheird and documented User Manuals and Business Rules

Environment: Microsoft Office Suite, Microsoft Visio, MS Project, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, Agile, RUP, MS Access, HP Quality Center, Quality Center, C#. NET, ASP.NET, Business Objects, Autosys, Test Director, Load Runner.

Confidential, Boston, MA

QA Analyst

Responsibilities:

• My responsibilities included backend testing of data from warehouse inventory relating to implementation of Material Management, Transportation and Shipping Order Management Systems as well as reviewing Business Requirements & System Requirements.
• Gatheird requirements, organized team meetings requirements from business users such as insurance policy managers, generated business process models, & use-case models, and created system requirements document & functional requirements document (FRD).
• Developed and managed the formal SDLC implementation using the Lean/Agile Methodology.
• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of RUP effort in different iterations and phases of the Software Development Life Cycle.
• Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Sybase Database Servers.
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Conducting JAD Sessions to resolve open issues, change requests so that the application meets the system requirements and dead lines
• Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams
• Extensively involved in the automation of Regression Test Cases by scripting.
• Create and maintain requirements, test cases and defects in Mercury Quality Center
• Extensively used tools such as Rational Rose, Rational Requisite Pro, UML, MS Visio, MS Project, MS Office, MS Access
• Responsible for managing the documented system requirements and Requirements Traceability Matrix.
• Developed Test cases for manual testing and automated them using Win Runner, Silk, Load Runner, Silk performer and QTP.
• Automate and integrate data collection processes from databases using SQL and MS Access.
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
• Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing.
• Prepared system Test Plan and scenarios for Test Scripts.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Responsible for providing analytical support in the Design, Development and Implementation of Project.

Environment: Rational Enterprise Suite (Rose, Clear Case, Clear Quest), RUP, MS Office, MS Access, Visual Basic, SQL, SQL Server, Oracle, MS Project, Web Logic, HP Quality Center, MQ Series, Quality Center, Quick test Pro, Adobe Photoshop, Agile,, Web Forms, Load Runner, Win Runner, DOORS, Project Management.