Sr. Qa Analyst Resume
Katy, TX
SUMMARY
- Over 6 years of IT experience wif 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 wif 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 teh 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 teh 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 wif 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 teh development and implementation of Test Plan, Test Scenarios and Test Cases for functional, system requirements.
- Extensive testing is carried out in teh 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 dat unique identifies dis customer shipment.
- Used newly created RF functions for teh Order fulfillments and tested them thoroughly.
- Worked wif teh operations to execute teh different UC4 jobs on WMS, ETL data stage. Also monitored teh results and captured test logs.
- Tested teh WMS picking, shipment applications which involves complex business processing steps to fulfill teh eCom orders.
- Tested Automated Dash board screen to track incoming, outgoing shipments and reports.
- Heavy data validation has been done at WMS application in AS400 while communicating wif Sterling and RMS applications.
- Attended daily defect-triage meetings wif developers to explain teh defect details.
- Use to send test execution summary report and defects report to teh project team every day.
- Interacted wif 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 teh QA testing and Business Users to perform UAT testing.
- Interacted wif Third Party Vendors (Dematic) for testing third party applications as part of teh end to end testing. dis involved challenges around to setup test environment wif WMS through MQ messaging end.
- Involved in project status meetings, requirements gathering meetings, daily stand up meetings, status update meetings.
- Tested teh MQ interfaces which loads teh foundation data like Items, UPCs, Vendor, Stores details.
- Tested teh interfaces which communicates teh picking instructions wif Dematic.
- Tested teh interfaces which processes teh voice picking instructions from Dematic and resolve teh pick directives at Academy (WMS - AS400 system).
- Tested teh Put to light interface between Dematic and Academy which creates teh store containers at WMS system.
- Tested teh interfaces like Divert Confirmation which updates teh container information wif diverted lane at WMS.
- Tested teh 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 teh 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 wif UC4OPS teams to run batch job and analyze teh test results and test logs.
- Operated wireless printers for label generation based on teh release logic
- Tested different kind of picking sorts for pick process.
- Participating in Daily stand up meeting.
- Provide weekly status report to teh 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 teh Business Requirement Document to understand teh 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 teh interface which sends item data from RMS to OTM when items are added or changed.
- Tested teh interface which sends PO data from RMS to OTM when POs are added or changed.
- Tested teh interface which sends voucher (One stop and multi-Stop) information from OTM to PeopleSoft.
- Tested teh interface which sends teh planned shipment data (PPD, Collected and Transfer) from OTM to Inbound Cargo.
- Co-ordinated wif UC4OPS team to run teh batch jobs which creates teh invoices in people Soft application.
- Supported teh 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 teh 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 wif operations to run teh ETL data stage batch Jobs and monitored teh test results.
- Verified teh results by running teh SQL queries on teh each database.
- Validated reconciliation report based on teh data Mapping rules.
- Providing Weekly Status Report to all stakeholders
- Tracked all issues & defects using teh 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 wif Business and BSA’s to get Fredo requirements finalized.
- Created Test Plan for each Scrum cycle during Functional Testing phase.
- Worked on Requirement Traceability wif functional testing test cases using HPQC.
- Tested teh RF function FRC for unplanned receiving and planned receiving.
- Tested complex and iterative business scenarios involved in dis process.
- Tested dynamic labels creation like back stock, store label or batch labels based on teh scanned data.
- Heavy data validation has been done for Available/Unavailable inventory and pick instruction wif RMS.
- Participated in Scrum Meeting from QA perspective.
- Provided support to Business and BSA’s during teh UAT phase.
- Used HP Quality Center 10.0 to house all test documentation and report/track all issues and defects.
- Interacted wif 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 teh 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 teh data wifin 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 teh ETL data stage batch Jobs runs wif UC4 batch admins and monitored teh run results.
- Database testing was performed to validate teh data integrity wifin teh database.
- Involved in project status meeting, requirements gathering meetings, daily stand up meetings, status update meeting wif offshore teams located onshore and offshore.
- Defects and Issue resolution was conducted on a daily basis during teh 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 teh 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 teh Standards, guidelines and structured methodology in testing teh 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 teh system covering SRS document, design document, reviewing them wif teh developers and finalized teh test cases.
- Teh 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) wif teh 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 teh 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 wif Application team of Sales Order Management System, Warehouse Management System and Transport Management System.
- Excellent experience managing teh whole testing process using Mercury Interactive Test Management tool Mercury Quality Center.
- Worked on a business case for teh 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 teh test scripts for teh GUI, Functional, Data Driven and Regression testing in HP Quality Center.
- Responsible for all aspects of teh testing process i.e. planning, scheduling, running tests,defect tracking and bug reporting using JIRA
- Worked closely wif Business Analysis for designing Fitness test pages before iteration starts.
- Responsible for teh documentation of teh Test Plans. Guided teh Testing team to understand teh business logic.
- Performed extensive Smoke, Integration testing, Comparison, Regression and UAT testing to ensure dat System is user friendly for customers.
- Database Validation (SQL) to check teh updated data in teh Database
- Reviewing teh test cases through peer review and giving teh 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 teh system/application as per teh project requirements.
- Gatheird requirements for teh integration of POS system wif teh 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 teh 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 wif 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 teh phases of SDLC and familiar wif industry standard best practices & frameworks such as RUP (Rational Unified Process), AGILE & Lean
- Came up wif test cases from teh requirements, validated/exercised those test cases in form of integration and regression tests.
- Coordinate wif Application team of Sales Order Management System, Warehouse Management System and Transport Management System.
- Excellent experience managing teh whole testing process using HP Quality Center.
- Facilitated user acceptance testing and test strategies wif 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 wif User experience groups.
- Managed teh whole testing process using HP Quality Center.
- Worked as Track Lead for teh Money Movement Platform. Responsibilities included creation and maintenance of Requirement Artifacts and maintenance of Issue tracker on teh program management site through SharePoint and other collaboration tools.
- Created Use cases for teh various functionalities of Deposit Products.
- Worked extensively on Rational Requisite Pro to create Requirements specification.
- Conducted training for new team member for teh 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 teh project, was involved in giving clarifications on domain and product functionality for teh team.
- Regular interaction wif teh core developers helped us in fixing teh defects in less time.
- Analyzing Software Requirement Specifications (SRS), Technical Specification and Functional specification Documents for developing manual test cases.
- Developed teh test cases to comprehensively cover all possible positive and negative scenarios at teh functional and Schema level.
- Analyzed business requirements and system architecture/design.
- Assured dat all Artifacts are in compliance wif corporate AGILE Policies and guidelines.
- Interact and negotiate wif Vendors to complete teh tasks related to data conversion
- Followed Agile (XP) Methodology for teh release.
- Prepared System Requirement Documents after teh collection of Functional Requirements from System Users dat 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 wif several test cases for each project to ensure dat teh system runs smoothly after teh proposed enhancements or changes has been made.
- All teh test scenarios which has been satisfied wif teh 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 teh source system (SQL Server) to match teh results wif teh actual report against teh 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 dis application using Rational Requisite Pro.
- Analyzed teh business and functional requirements of teh application and developed detailed test plans, test cases in Test Director.
- Manually tested and GTS modules using Quality Center.
- Assisted to develop teh 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 teh formal SDLC implementation using teh Lean/Agile Methodology.
- Used teh guidelines and artifacts of teh Rational Unified Process (RUP) to strategize teh Implementation of RUP effort in different iterations and phases of teh 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 teh Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by teh teams across teh deliverables for a project
- Conducting JAD Sessions to resolve open issues, change requests so dat teh application meets teh system requirements and dead lines
- Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams
- Extensively involved in teh 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 teh 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 teh 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 dat contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of teh Relationships between teh data elements to analyze and document teh Business Data Requirements.
- Collaborated wif Quality Assurance Analyst in Automated and Manual Black box testing.
- Prepared system Test Plan and scenarios for Test Scripts.
- Worked extensively wif teh QA team for designing Test Plan and Test Cases for teh User Acceptance Testing.
- Responsible for providing analytical support in teh 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.
