SUMMARY

• Around 8 years of experience in Quality Assurance and Software Testing of various business applications in Retail, Data - Warehousing solutions, ETL and Business Intelligence solutions.
• Excellent working knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) and Defect Life Cycle.
• Expertise in Writing, Executing and Maintaining Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases..
• Sound knowledge and exposure in working with the various relational databases like Oracle, SQL Server etc.
• Solid Back-end testing experience in writing and executing SQL Queries.
• Good knowledge on UNIX commands.
• Experience on Oracle Retail Testing (Purchase Orders, E-commerce, Interfaces, Oracle Modules and Legacy Modules).
• Experience on ETL testing.
• Worked on Reports Testing.
• Expertise in writing, maintaining, executing Test plans, Test cases and Test Scripts, analyzing bugs and Interacting with team members in fixing the errors.
• Experienced in Smoke Testing, Functional testing, System Testing, End to End Testing, Regression Testing, User Acceptance Testing.
• Strong experience in preparing documentation, preparing test environments, executing and analyzing the results.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Report, and Weekly Status Reports.
• Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like Quality Center.
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
• Experience in Data Analysis, Data Cleansing (Scrubbing), Data Validation and Verification, Data Conversion.
• Have experience working in Agile/Scrum Methodology.
• Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SKILLS

SDLC: Iterative, Agile, Waterfall and Spiral Methodology

QA Tools: Quality Center, Test Director

ETL Tools: Ab Initio 2.x

Operating Systems: Microsoft Windows - Vista, XP, 2000, NT 4.0, OS/2UNIX - Sun Solaris, HP-UX

Databases: Oracle 10g, 9i, 8i, Microsoft MS Access, SQL Server 2005/2008, Teradata

Languages: SQL, PL/SQL, UNIX Shell Scripts

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Teradata Tester

Responsibilities:

• Preparing, executing and documenting the test cases.
• Created test plan using specifications from the business requirements, which provided project wide strategic elements essential to the quality assurance processes to be employed.
• Performed Smoke testing for each new build of the application.
• Responsible for functional testing with new tasks and client Enhancements.
• Performed Regression testing frequently on each and every weekly build/release, reviewed, validated and maintained a comprehensive Regression test suite, analyzed complicated business scenarios, reporting results and issues in a timely and accurate manner
• Logging defects and resolving, Responsible for Documentation of Test Results analysis and Test matrix preparation, Test data preparation.
• Participate in weekly meeting with the management team and walkthroughs.
• Created the detailed test plan and test cases from the business requirements documents and meetings.
• Created detail Test Overview document of what needs to be covered in the testing that covers all positive and negative scenarios, Environments used, table names and reviewed with the Team of business Analysts, Developer and QA Manager and got it signed off before starting with the test cases,
• Involved in testing various Reports like RPL Query, Accuracy, SOQ Automation related to Confidential ’s in UAT environment.
• Prepared the test data for UAT users and worked on the POM.
• Worked on Suspend SOQ upload.
• Tested various Metrics in the Reports using Teradata SQL Assistant by validating the data in the report against the Database using multiple filter condition like department, sku,color,size.
• Validated various conditions as per the Data Dictionary document for all the Metrics
• Tested various divisions like BDS, MDS and for different departments and multiple time periods like 1 period, 3 period, 3 period and 1 lag.
• Tested the RPL query Metrics against the DCM Application by comparing the values against the database using Teradata.
• Logged multiple Defects in QC and coordinated with developers to fix the bugs
• Member of the User acceptance Testing Team and worked with the perspective of the user.
• Participate in weekly meeting with the management team and walkthroughs.
• Involved in maintaining Test Matrix.
• Maintain Defect Log which gives a clear indication of quality and stability of product.
• Tested applications both in QA and Production environment.

Confidential, Houston, TX

RMS Test Lead

Responsibilities:

• Worked with BA’s and gathered the requirements.
• Prepared functional test scripts for Items, Purchase Orders, Replenishment, Allocations, Interfaces and Legacy Systems based on the Business Requirements and Functional Specification Documents.
• Worked with Business Leads to ensure Test Cases written gave 100 % coverage.
• Worked on executing the Test cases for various positive and negative scenarios
• RMS UAT environment->Created Purchase Orders both Domestic and Import for various items (Complex pack, Simple pack, Items with diffs, Items without Diffs) and Suppliers (EDI, Non-EDI, PO change enabled, Import, Domestic).
• Created PO’s for various scenarios like Warehouse, Pre-mark and Direct store Delivery.
• Tested various positive and negative scenarios like below supplier minimum costs and units, QC flags, factory and items country of sourcing not matching etc.
• Validated the database tables whether data is getting loaded and being sent to the suppliers (Oracle SQL)
• Worked on Interfaces whether source and target systems are integration properly (Approved Items from RMS to Clear Track).
• Worked on Oracle mods like Title Pass Location for Import PO.
• Worked on Legacy Mods like Approved Items from RMS to TMS, Items from AIX OGN server to TMS, APEX re-send items.
• Worked on Replenishment PO’s for various scenarios like DSD, CrossDock (setting up the parameter’s to run the jobs).
• Worked on Allocations (Manual and What-If Allocations) for Warehouse and Crossdock.
• Worked on end to end scenarios whether the PO’s are flowing to WMS (warehouse management systems), SIM.
• Worked on E-commerce website (Grid page, Product detail,Department,class,sublass,header links,footerlinks,Clearance Items)
• Worked on Roles testing for the security and login and edit access for Merchant Assistant, Replenishment assistant, Assistant Buyer etc.
• Worked on Nova PIM system to automate the process of creating Items in RMS.
• Educated the team on batch programs that needs to be run and data setup to test the functionality during test execution.
• Participated in Defect Triage meetings
• Have hands on HP-Quality Centre which is mainly used for uploading test cases, executing test cases and tracking defects.

Confidential, Richmond, VA

QA Tester/ETL Tester

Responsibilities:

• Designed and Created test plan, test scenarios and test cases for Data warehouse and Backend testing.
• Responsible to translate business requirements into quality assurance test cases.
• Review of test scenarios, test cases and Data warehouse Test Results.
• Involved in testing Ab Initio graphs based on data mapping requirements.
• Developed test scripts using SQL queries to validate data.
• Prepared Regression Test Plans, Requirements Traceability Metrics (RTM), positive and negative test scenarios, detailed oriented Test Scripts, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use.
• Maintain Defect logs/ report.
• Interacted with design team to decide on the various dimensions and facts to test the application.
• Planned ahead of time to test the mapping parameters and variables by discussing with BA’s.
• Worked on data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Performed back end testing using SQL scripts to verify the data integrity
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Extensively used Quality Center to track defects and managed them.
• Tested several reports detailing price/volume trends and expense variance over previous periods by using financial reporting and through the Interactive Reporting.
• Extensively involved in testing the ETL process of data sources Teradata, SQL Server, Oracle, flat files into the target Teradata, Oracle database as per the data models.
• Executed automated test scripts using QTP for Regression testing.
• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
• Responsible for documenting the process for future references.
• Responsible for in-depth knowledge of data, processes or applications in their specific area of responsibilities.
• Reviewing the test activities through daily Agile Software development stand-up meetings.
• Participated in the daily scrum meetings of the project

Confidential, Pasadena, CA

QA Tester

Responsibilities:

• Analyzed the Requirements from the client and developed Test cases based on functional requirements, general requirements and system specifications.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Performed Smoke Testing, GUI Testing, Functional Testing, Backend Testing, System Integration Testing, Sanity Testing and User Acceptance Testing (UAT).
• Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements.
• Creation, preparation and execution of testing including scheduling, test plans and test scripts.
• Logs, tracks and verifies resolution of software and specification defects. Handled test environment problems and issues.
• Verified session logs to identify the errors occurred during the execution.
• Created Test Cases, traceability matrix based on mapping document and requirements.
• Performed data validation using SQL queries. Created Entrance criteria for Shop Cart Page, Quick Info, Detail Page and Search Function.
• Performed Back end testing by writing SQL statements like Join, Inner Joins, Outer joins and Self Joins used TOAD and SQL Developer
• Performed the SQL stored proc, functions and package testing.
• Developed test plan with testing scenarios from the end user perspective for User Acceptance Testing (UAT).
• Preparation of System Test Results after Test case execution.
• Effectively coordinated with the development team for defect resolution.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Provided the management with weekly QA documents like test metrics, reports, and schedules.

Confidential

QA Engineer

Responsibilities:

• Planned and directed QA schedules and assignments to testers.
• Did complete end-end System Testing
• Wrote detail test plan, test cases, Maintain Defect logs/report.
• Also worked on Regression testing, Integration testing
• Involved in preparation and running of navigation scripts which in turn calls the action word function and interaction with application
• Maintaining the test data cluster
• Lead the creation, preparation and execution of testing including scheduling, test plans and test scripts.
• Logs, tracks and verifies resolution of software and specification defects.
• Handled test environment problems and issues.
• Worked with team members to establish and maintain a consistent test methodology and to resolve questions during testing.
• Supported the completion of QA deliverables, tracking bug reports and change requests and their resolution
• Identified test data to perform Functional, Integration and Regression testing
• Tracked Blockers, Critical and Major bugs
• Created UAT environment for Client testing.
• Interact with developers, QA team and Technical Project Managers in resolving the issues