We provide IT Staff Augmentation Services!

Ecommerce Qa Tester Resume

4.00/5 (Submit Your Rating)

Columbus, OH

SUMMARY

  • Over 6 years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications.
  • Extensive experience in writing Test plans, Test cases and Test Execution.
  • Experience in Software Engineering, SDLC & Testing Methodologies.
  • Solid experience in Black box testing techniques, which includes, Unit, Integration, Functional, System, Regression Testing.
  • Experience in integration of various data sources wif Multiple Relational Databases like Oracle, SQL Server, MS Access and Flat Files.
  • Created Manual Test Cases in HP QC/HP ALM for various User stories on Release and Sprint Plan.
  • Extensive experience in Data warehousing using Informatica and Datastage
  • Experience working wif Databases like Oracle, SQL Server.
  • Having good experience in using Quality Center, HPALM tools for developing test cases, requirements mapping and defect linking to teh test cases.
  • Profound experience in testing web applications using MTM, Quality Center and Quick Test Pro (QTP).
  • Expertise in test management using HP Quality Center, Microsoft TFS and maintained versioned objects using Rational Clear Case.
  • Strong working experience in teh Data Analysis, Design, Development, Implementation and
  • Strong interpersonal skills, ability to interact wif individuals at all levels, excellent communication and presentation skills.

TECHNICAL SKILLS

Operating Systems: Windows NT, Windows 95/98/2000, UNIX

Ecommerce tool and interfaces: Oracle ATG, OMS, MIF, BCC

RDBMS: Oracle 8.1/9i/10g / 11g, DB2, PL/SQL, SQL Server 2012/2008, Sybase, Teradata V2R6 / 13

Testing Tools: HP Quality Center, ALM, Rational Clear Quest, MTM, TFS

Environment: UNIX, MVS, HP-UX, IBM AIX, Flat files, csv files

PROFESSIONAL EXPERIENCE

Confidential, Columbus OH

Ecommerce QA Tester

Responsibilities:

  • Experience wif eCommerce Software noledge (ATG, OMS, MIF), preferably WMS Fulfilment
  • Understanding of specialty retail environment, particularly store operations
  • Strong noledge in retail business - customer orders, skus, upc, category, related items, collections, clearance items, mark downs, flash sales etc
  • Experience in developing test plans, preparing test cases, overseeing test execution and status reporting
  • Experience working wif WMS for Inventory Adjustments, Fulfillments
  • Experience working in POS lab for Brand To Me Testing
  • Experience Working in BCC, XCC(creating promotions)
  • Assign task to teh offshore team, daily standup, follow up wif Product/Project Manager and Business
  • Manage teh day-to-day activities of a group of UAT/functional analysts to complete projects and support related activities, delegating assignments to staff members as part of teh process
  • Formally accept application for testing, coordinate test execution
  • Provide input to project list activities for project management
  • Ensure completion of all deliverables wifin schedule, budget, and quality constraints
  • Work wif Third party application like AVS, Vertex, PayPal, Microsoft Wallet, Urban Airship, RIO, Certona, Mercent, Oapic, Responsys, Rightnow for notification, LTU technologies for Bar code scanning, Search by photo feature under new site (handled by ATG).
  • Work wif ATG, MIF, EOM, BCC, XCC,WMS, Invoices, labels services for order review/tracking and backend testing. (Handled by ATG)
  • Implementation of Tokenization on teh CC payment method.
  • Test iRule /F5 (QA, staging and Production environment); validate teh traffic flow is set as expected using firebug, live HTTP reader, curl and User Agent add-ons.
  • Use SAP to check teh overall status, delivery status, vendor’s status, and payment methods of teh order placed
  • Use Coremetrics, Google Analytics to validate if expected http redirects are hitting teh expected links using firebug
  • Backend testing on Caliber services by generating request/response API call.
  • Develop and oversee teh development of UAT test activity estimates, resource plans, benefits and timelines for projects
  • Complete a task and impact assessment for requests and ensure a quality as well as a timely delivery of all projects
  • Help define/create and execute E2E Test strategy (Functional, Non-functional, UAT, Model Office)

Confidential, Oldsmar FL

QA Tester

Responsibilities:

  • Clearly communicated and documented test results and defect resolutions during all phases of testing.
  • Stimulated several production cycles. Worked wif data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
  • Performed Black-box testing, White-box testing, System Testing, Data Integrity Testing and end to end testing
  • Develop Test cases and Test Scripts for both Manual and Automation testing using Quality Centre (QC) and QTP.
  • Implemented SDLC, QA methodologies and concepts in teh Project
  • Involved in Developing Test Plans and Developed Test Cases/Test Strategy wif input from teh assigned Business Analysts
  • Designing and uploading functional Test cases into TFS.
  • Created manual and automation (Ranorex) test cases for new features.
  • Assisted in promotion of Informatica code and UNIX Shell scripts from UAT to Production
  • Involved in testing of Universes from different data sources like Oracle/SQL Server.
  • Developed test scripts based upon business requirements and processes. Processed transactions from system entry to exit. Tested functionality across applications and workflows.
  • Involved in testing teh designing and development of data warehouse environment.
  • Worked wif appropriate business and technology leads to determine teh acceptable range for test results and performance
  • Experience in testing teh tickets posted in TFS both in QA environment and UAT environment
  • Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
  • Worked Extensively wif SSIS to import, export and transform teh data between Used T-SQL for Querying teh SQL Server2005 database for data validation and data conditioning
  • Writing complex SQL queries for data validation for verifying teh SSIS Packages and business Rules.
  • Extensively used T-SQL to verify and validate teh data loaded to teh SQL Server 2012
  • Supported teh extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using SSIS and provide technical support and hands-on mentoring in teh use of SSIS for testing.
  • Worked on profiling teh data for understanding teh data and mapping document.
  • Reported bugs and tracked defects using Quality Center 10.0
  • Performed teh tests in both teh SIT, QA and contingency/backup environments
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Used TOAD Software for Querying ORACLE, Used WinSQL for Querying DB2, SQL Assistances for Teradata
  • Written several UNIX scripts for invoking data reconciliation.
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Used SQL for Querying teh DB2 database in UNIX environment
  • Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
  • Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.

Environment: Informatica 9, Oracle, SQL Server 2012, AGILE, Teradata 13, DB2, TOAD 10.0, Oracle 10g, Quality Center 10.0 / ALM, UNIX, Autosys, OBIEE, MTM,SSRS, XIR3, IBM AIX.

Confidential, Chicago, IL

QA Analyst

Responsibilities:

  • Followed agile development environment wif frequently changing requirements and feature set. Also includes attending teh sprint planning meetings and estimation of efforts, complexity and tasks associated wif teh user story.
  • Analyzing user stories to prepare Test Plans, Test Scenarios, Test Cases and Test Scripts for manual and automated testing.
  • Performing smoke, functional, regression, and performance testing of tool and provide daily test verification report. Automation for regression testing using Selenium IDE/RC wif C# and NUnit.
  • Testing web application on multiple browsers, tablets and logging defects in Version One, once fixed retested on a new build and updated teh defect.
  • Created and Executed Automated Coded UI Tests in VSTS 2010
  • Developed and executed automated test case scripts written in Selenium RC wif C# wifin a custom automation framework for web application and database stored procedure functional testing.
  • Responsible for creating Test Scripts in C#, JavaScript utilizing Selenium IDE/RC & NUnit tools to test functional and UI elements.
  • Created Parallel testing using Selenium Grid.
  • Performed bug tracking and source control using Team Foundation Server (TFS).
  • Performed Manual and Automation Testing for both iOS and Android mobile application
  • Responsible for Setting up Web Services project using WSDL in SOAPUI and provided setup help to other team members.
  • Performed functional testing of SOAP and RESTFUL Web Services using SOAP UI Tool.
  • Used WSDL to setup project in SOAPUI, compiled teh WSDL using SOAPUI, Created multiple Test Cases to test scenarios.
  • Worked extensively in JMeter to test teh performance of teh web Application by creating different loads and logging teh results using various Listeners.
  • Optimized SQL queries for better performance. Joins were implemented. Passed SQL queries to Oracle using SQL Developer for teh backend/database testing.
  • Used Rally to house all test documentation and report/track all issues and defects
  • Coordinate wif Business Analysts, Developers and QA manager to assure all defects are fixed accurately as per User Stories.
  • Worked wif XML files for uploading data into teh tool and verifying teh data.
  • Troubleshoot errors on IIS server logs
  • Proactively came up wif innovative methods to improve software quality, test coverage, efficiency and regression coverage
  • Preparation of data requirements for each Sprint release and preparation of test cases design and review and publishing during teh demo

Confidential, Wilmington, DE

QA Tester

Responsibilities:

  • Involved in daily status meetings, user stories, Sprint model in AGILE methodology
  • Conducted interviews and facilitate requirements gathering, process analysis, and application design sessions wif company staff across all levels and functions
  • Produced documents for business requirements (requirements matrix), design requirements, gap analysis, solution recommendations, test cases, test plans and reference guides
  • Coordinated system walk through, training, User Acceptance Testing (UAT) and facilitate issue resolution
  • Tested in Star Schema on SCD type 2 and 3 Tables
  • Tested date from ODS to Stage and to target dimension tables ETL Cycle in all sprints
  • Developed SQL scripts to validate teh data loaded into warehouse and Data Mart tables using Informatica.
  • Involved in backend testing for teh front end of teh application using SQL Queries in Teradata data base.
  • Performed front-end testing on OBIEE Executive Dashboard portal
  • Developed Talend ETL jobs to push teh data into Talend MDM and develop teh jobs to extract teh data from MDM
  • Developed Reports and Graphs to present teh results to teh management.
  • Performed Data Driven Testing of teh Application for different users/data sets
  • Preparation of test data for various levels of testing
  • Gave production support in scheduling and tested this data wif teh existing data.
  • Developed Test cases for teh data warehouse in Oracle System
  • Worked on Oracle to implement teh project and written teh Test Plan and Test Cases for teh module Sales Cycle
  • Defect Tracking using Team Foundation Server (TFS) 2008.
  • Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
  • Exposure to automation tools like Neoload and Ranorex and server monitoring tools like Nagios
  • Developed detailed System test plan including test procedures and test cases
  • Conducted Integration testing, Performance testing, Functional testing and Load testing to ensure dat teh application meets teh requirements and to ensure usability readiness
  • Developed test automation scripts for Regression and Performance testing
  • Identified and resolved many application bugs and bottlenecks
  • Verified all teh functional and load requirements are met

Environment: SQL, PL/SQL, UNIX, Shell Scripting, Teradata, Toad, Quality Center 9.0,MTM, Informatica Power Center 8.6, VBScript, flat files, AGILE, MS SQL server, Oracle 9i, Crystal Reports

Confidential, Minneapolis, MN

QA Tester

Responsibilities:

  • Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
  • Created test data for testing specific Membership functionality.
  • External interactions wif NSCC, DTCC, NFS and various fund companies in which MMLISI is associated.
  • Performed manual testing on different modules of teh application.
  • Promoted Unix/Informatica application releases from development to QA and to UAT environments as required.
  • Performed data integrity testing by executing SQL statements and manually verifying teh contents.
  • Involved in user training sessions and assisting in UAT (User Acceptance Testing).
  • Assisted in promotion of Informatica code and UNIX Shell scripts from UAT to Production.
  • Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
  • Developed data matching/linking rules to standarize teh record in Talend MDM.
  • Created teh test environment for Staging area, loading teh Staging area wif data from multiple sources.
  • Involved in Data Extraction from Teradata and Flat Files using SQL assistant.
  • Assisted in System Test and UAT testing scenarios as required
  • Worked wif thin client and thick client (Business Objects )
  • Extraction of test data from tables and loading of data into SQL tables.
  • Created ETL test data for all ETL mapping rules to test teh functionality of teh Informatica Mapping
  • Tested teh ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
  • Written several complex SQL queries for validating Cognos Reports.
  • Tested teh reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
  • Tested teh ETL process for both before data validation and after data validation process. Tested teh messages published by ETL tool and data loaded into various databases
  • Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
  • Experience in creating UNIX scripts for file transfer and file manipulation.
  • Validating teh data passed to downstream systems.
  • Worked wif business team to test teh reports developed in Cognos
  • Used Quality Center to track and report system defects
  • Involved in testing teh XML files and checked whether data is parsed and loaded to staging tables.

Environment: Informatica 8.1, MVS, UNIX (K-Shell Script), Teradata SQL Assistant, Teradata V2R6,Oracle, MTM, TFS,SQL Server 2005, DB2, Cognos 7.0, Windows, XML, XSLT, XSD, Rapid SQL, PL/SQL, TOAD, Data Files, XML Files, Autosys

Confidential, Cleveland, OH

QA Tester

Responsibilities:

  • Worked closely wif Business user in Understanding designing and documenting teh Functional testing plan and tan Writing, executing, documenting teh results and Logging defects.
  • Involved in development and implementation of test cases test plans test data and test scripts for customers.
  • Analyzed Manual Test Cases wif QA Team for most important & high priority Requirements for conversion to Automated Test Scripts using HP Quick Test Professional (QTP
  • Involved in various kinds of testing like functional testing, system testing and integration testing.
  • Constructed context diagrams and data-flow diagrams based on teh description of a business process. Analyzed teh data model to code efficiently in SQL.
  • Created and Configured Workflows, Work lets, and Sessions to transport teh data to target using Informatica Workflow Manager.
  • Created Talend & Informatica mappings for initial load and daily updates and also involved in teh ETL migration jobs from Infromatica to Talend.
  • Analyzed Manual Test Cases wif QA Team for most important & high priority Requirements for conversion
  • Extensively involved in performance tuning at source, target, mapping, session and system levels.
  • Worked on generating reports using SQL Plus and PL/SQL. Worked on tuning SQL statements.
  • Worked intensively wif indexes to tune teh query, exploited teh B-tree and Bitmap index functionality of oracle to get teh better performance.
  • Involved in preparing detailed Business Analysis documents, ETL design documents, unit test plans for teh mappings
  • Executed and maintained Test Plans, Test Case, Test Scripts, and Test Data for manual testing approaches using track & defect management tool HP Quality Center (QC).
  • Involved in complete life cycle activities like pre-testing phase and testing phase.
  • Analyzed system requirements specifications, developed executed detailed test plans test cases, security and usability of application information.
  • Created Test Procedures and Test Cases to perform teh system testing and Regression testing.
  • Attended bug review and client meetings.

Environment: Informatica, Toad, Quality Center, Visual Basic, Oracle 9i, Windows, UNIX, Teradata.

We'd love your feedback!