We provide IT Staff Augmentation Services!

Qa Analyst/test Engineer - Consultant Resume

3.00/5 (Submit Your Rating)

Alpharetta, GA

PROFESSIONAL SUMMARY:

  • Senior Quality Assurance Analyst experienced with Web Testing (Java & .net apps).
  • Database Testing (Transactional & Data Warehousing) - Oracle & SQL SVR.
  • Backend batch processing, Error Log validation.
  • SQL Server ETL Job, Package Execution, Stored Proc Validation and error log troubleshooting.
  • ETL Source-to-Target testing.
  • ERP (Enterprise Resource Planning)-System integration testing.
  • System, Functional, End-to-End, System Integration, Sanity, Smoke, Regression Testing Experience
  • Business Analysis and Requirement Gathering.
  • UAT and Production Support Testing.
  • Web Service Testing.
  • Agile (scrum) User story creation and review, backlog grooming, sprint planning, retrospectives etc.
  • Requirements traceability of requirements using HPQC, TFS user stories (PBIs), Doors, PVCS, Etc.
  • UAT testing and team direction as needed.
  • (Java/.net Apps), Backend Testing (UNIX/Linux Batch Processing and error log testing & verification, Database testing), Data Mart/DWH ETL Testing (source to target mapping ETL Job processing & file setup) on SQL Server and Oracle databases, ODS, Migration Projects.
  • SOA, e-commerce Testing.
  • Cross-browser testing (IE, Chrome, Safari, Firefox etc.).
  • BI Report Testing-Dashboards, Business Objects Reports, Crystal Reports
  • TOAD, SQL Navigator, SQL developer, SQL Server Management Studio 2008/2012/2014.
  • Data Mapping, Data Modeling & Schema verification.
  • CRM (Customer Relationship Management) - Systems & Integration Testing
  • Loyalty Systems Experience (Hotel Loyalty- Confidential, Credit Card Loyalty Programs- Confidential ).
  • Agile Management tools: JIRA, Rally, TFS, MINGLE.
  • Test Management Tools: HPQC, ALM, Visual Studio, MTM (Microsoft Test Manger)
  • Requirement Management tools: Doors, IBM Rational Requisite Pro, HPQC, Traceability Matrixes
  • SharePoint, Wiki.
  • Experienced working/leading offshore test teams.
  • Work closely Project Managers, Scrum Masters, Business Analyst’s, and SME’s.
  • Test Case Design (from User story cards and/or Requirements),
  • Test execution using test management tools or Spreadsheets),
  • Agile Hardening (Major release regressions).
  • End-to-End, System, Iteration testing, whitebox, blackbox and UAT Testing experience.
  • UNIX, Oracle 7/8/9i/10i, Office 2003/2007,2013,
  • Familiar with the following languages: C/C++, VB, VBScript, Java, JavaScript, HTML, SQL, xml
  • Test Automation (Creation of automated regression suites) using HP QTP, Testing Anywhere, Some experience using Eclipse, Java, Junit, Gradle, Git, Spring and Custom Batch Processing Framework.
  • Experienced working independently and/or within team environments using both Agile/Scrum and Waterfall methodologies.

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, GA

QA Analyst/Test Engineer - Consultant

Responsibilities:
  • Review Project Solution documentation
  • Use of Toad for DB SQL Query design and validation in automation scripts
  • Use of WinScp for editing and Linux Log validation
  • Putty for access to Linux servers for log and job verification
  • Eclipse, JUnit, Spring, Confidential Custom Test Framework Library for use of Automated Regression Testing (Batch file processing - EBCDIC.
  • Xml files - Create data in files for insertion into EBCDIC for batch for processing for credit cards.
  • Wiki and SharePoint use for project documentation.
  • JIRA for User story assignment and task completion for 2wk Sprints.
  • Agile Methodology (scrum).
  • Work closely in team as a POD.
  • Design regression testing based off Manual testing scripts (High Risk designated).

Confidential, Marietta, GA

QA Analyst/ Test Engineer - Consultant

Responsibilities:
  • Gather Business Requirements from Business Personnel for entry into Jira User Stories.
  • Agile Scrum Methodology Implemented (14 & 21 day sprints).
  • Create Backlog from scratch initially and then conducting backlog Grooming Sessions each sprint.
  • Conduct Sprint Retrospective session Confidential closing of each sprint.
  • Designed test case coverage for Jira user stories using Zephyr Test case Jira Add-in.
  • Converted to TFS shortly after starting project: Maintained User Stories, Tasks, Bugs for each Sprint.
  • Design of simple to advanced SQL queries in a SQL Server Environment using SQL Server Management Studio.
  • Mobile Testing (HTML 5 .net web design)
  • Manual Execution of designed tests in an agile environment (14/21/30 day sprints).
  • Defect tracking done in Jira and TFS.
  • Mobile Testing (Web Application is HTML 5 compatible) - BE 2.0 runs on Mobile iOS and android.
  • Execute Services to load customer specific data into our SQL Server Database.
  • Install and make use of Visual Studio Testing Professional which allowed implementation of MTM.
  • Created Test Plans/Test Cases using MTM (TFS) and Zephyr (Jira).
  • Defect Management using TFS & Jira
  • Worked closely with full scrum team of Developers, Architects, Scrum Master, Product Manager, and Test Manager.

Confidential, Buckhead, GA

QA Test Engineer - Consultant

Responsibilities:
  • Designed test case coverage for tfs PBI’s.
  • Design of simple to advanced SQL queries in a SQL Server Environment using SQL Server Management Studio.
  • Manual Execution of designed tests in an agile environment (14/21 day sprints).
  • Defect tracking done in Visual Studio/tfs.
  • Testing of ETL, Jobs, Deployment processes, Source Data Files, SRC to Target, Dashboard Reports, Related Revenue Management web apps.
  • Production Bug Testing
  • Use of SQL Server Management Studio.
  • Executed SQL Server ETL/Job Packages and for validation of Stored Procedures etc.
  • Use automated templates designed using pwrshell for DACPAC/ISPAC deployments
  • Created Test Plans/Test Cases using MTM
  • Defect Management using tfs
  • Worked Closely with full scrum team of Developers, Architects, Scrum Master, Product Manager, and Test Manager.

Confidential, Buckhead, GA

Senior QA Analyst-Consultant

Responsibilities:
  • Designed test case coverage for user stories housed in Rally/JIRA tool using HP ALM 11 and Rally.
  • Design of simple to advanced SQL queries in a SQL Server Environment using SQL Server Management Studio.
  • Manual Execution of designed tests in an agile environment (14/30 day sprints).
  • Defect tracking done in RALLY, HP ALM11 and JIRA agile tools.
  • Testing of ETL processes, Source Data Files, SRC to Target, Dashboard Reports.
  • Visualization Testing (Dashboard Reports, SSRS Reporting).
  • Performed Pre-prod and Production deployment testing and validation.
  • Use of SQL Server Management Studio.
  • Executed SQL Server Packages and Jobs for validation of Stored Procedures.
  • Created Test Plans/Test Cases and hold review sessions with Dev/Architecture/Business.
  • Defect Management for HPQC/Rally/JIRA.
  • Worked Closely with Developers, Architects, Project Manager, and Test Manager.
  • SQL Server 2012 Cube Testing for all Dashboard/Business Intelligence reporting.
  • Data file validation (format, data) for files delivered from AMDOCS.
  • Worked with AMDOCS and Accenture team personnel outside of our DW dept.
  • Delivered Status Reports on work accomplished or Test Blockers.
  • Worked closely with other test team members on process improvement.
  • Use of file Editors for file validation (Ultra Edit, Notepad++).
  • Worked with Multiple (Stage, ODS, DW) databases.
  • Design regression testing suites in HPQC (will automate in future).
  • SharePoint, agile task planning-Backlog Grooming-Backlog User Stories, Erwin (ER), Requirements Gathering, and Visio.
  • Validation of Stored Procedures by execution and code review (selection criteria based on Business/System requirements.
  • Currently in process of Automation tool selection for data warehouse regression.
  • Production Support Testing of Defects submitted by Business.

Confidential, Alpharetta, GA

Senior SQA Test Engineer - Consultant

Responsibilities:
  • Designed test case coverage for user stories.
  • Manual Execution of designed tests in an agile environment (14 day sprints).
  • Defect tracking of issue found during test execution using test manager.
  • Use of Visual Studio, TFS, and Test Manager for user stories review/management.
  • Test case design, test execution, defect management.
  • Created SQL using SQL developer for Oracle Database.
  • Verification of Windows Logs.
  • Use of Specialized tools to communicate with Radio collector, meters etc. (Radio Shop & ETM)
  • Attended daily scrum standup meetings while working 14 day sprints.
  • Worked closely with leads to manage workload during sprints.
  • Create WebEx recordings for archive demo of actual testing that occurred during sprint to include all acceptance criteria for user stories under test.
  • Use of SoapUI for web service testing.

Confidential, Dunwoody, GA

Senior QA Analyst - Consultant

Responsibilities:
  • Designed test case coverage for functional requirements.
  • Manual Execution of designed tests.
  • Cross-browser testing.
  • Defect tracking of issue found during design (requirements) and execution.
  • Use of HP ALM 11 for all release/Cycle tracking, Requirements housing, test planning & execution, and defect management.
  • Use of Fiddler for web test verification.
  • Created SQL using SQL developer for Oracle Database.
  • Verification of UNIX Weblogs for BI tags.
  • Attended Project meetings and Defect Management meetings.
  • Worked Closely with Business Analyst, SEO Engineer, UI Engineer, and CMS personnel.

Confidential, Downtown Atlanta, GA

Senior QA Test Engineer - Consultant

Responsibilities:
  • Senior QA Test Analyst working in an Iterative/agile development environment on medical training & management applications.
  • Worked with user stories to determine requirements and test coverage.
  • Interfaced closely with Business Analyst, Client Services, Technical Services and UAT to gather information pertaining to accurate test design & execution.
  • Gathered requirements from Business Partners & BA’s as necessary.
  • Web based .net application testing.
  • SQL Server database validation as required for testing.
  • Custom Report Testing and database validation.
  • Worked one-on-one with development, BA’s, and DBA’s and Business Partners.
  • Handled all ‘Urgent’ production client issues received from Client Services & Tech Services.
  • Followed up on client issues through the testing lifecycle (system testing - production deployment).
  • Attended and participated in daily team meetings.
  • Delivered weekly status reporting to Management on testing progress.
  • Use of HP Quality Center for all test case design, test execution, defect management etc.
  • Regression test design & execution for application releases.
  • Scheduled and executed testing for production deployment of Client defect hot fixes.

Confidential, Alpharetta, GA

Senior QA Test Engineer - Consultant

Responsibilities:
  • Worked one-on-one with developers/project managers.
  • Created/maintained automated regression scripts for multi-projects on virtual test machines.

Confidential, Atlanta, GA

Senior QA Test Engineer - Consultant

  • Offshore/near shore/onsite test team management, agile (scrum), Data warehousing/Data Mart, SQL query design, Mingle agile project management tool, story card testing, Sprint/Iteration test management, hands on QA testing, defect management/resolution, Business Objects report testing, Requirements analysis (Business, Functional, Performance.
  • CRM system testing.
  • Senior Lead/QA Test Engineer working with onsite, offshore (India) and near shore (Nebraska) test team members.
  • Setup & Process DCO Flat files for simulation of incoming Hotel ‘Stay’ data.
  • Validation of Customer ‘Loyalty’ system (Java Web Based UI/ODS backend).
  • Use of SQL/TOAD for data validation and ETL processing/mapping.
  • AGILE process used for Sprints (14 day) and iteration build deliveries.
  • AGILE story cards (Mingle) used to design test cases in Quality Center.
  • Worked Business Analyst to clarify agile story cards (Mingle Management System).
  • Use of Soap UI for xml messaging validation of Services.
  • Attended and participated in daily standup scrum meetings.
  • Delivered weekly status reporting to Management on project progress/metrics.
  • Created Metrics Graphs within HP Quality Center.
  • Created Excel reports querying HP QC backend database for test metric data.
  • Reviewed Test Case coverage by the near shore/offshore teams.
  • Validated requirement coverage using HP Quality Center.
  • Worked with UNIX boxes for Log validation.
  • Validated Business Objects Reports for Layout and data accuracy.
  • Coordinated End-to-End (e2e) Testing across multiple teams and systems to validate the operation of the MAGIC system.
  • Created Regression test plans/smoke test checklists for manual/automated testing.
  • Data Mart/Data Warehouse testing, Backend Dimension/Fact table testing.
  • Worked with Star Schema Designs.
  • ETL Process validation (data mapping/data validation rules, source to target).
  • Verified New Features implemented in the data mart.
  • Designed SQL queries for validation of source to target processing to include dimension testing within the data mart tables.
  • Daily/Weekly/Monthly file reconciliation via data mart.
  • Business Object (BI) Report Testing (layout/data validation).
  • Created test plans, test cases in HP Quality Center.
  • Defect management. Test Case Design Reviews.
  • Defect Reporting and management (HP Quality Center).
  • Test Set Execution.
  • Creation of regression test sets for the system test and pre-prod test environments.
  • Participated in weekly status meetings/weekly status reports.
  • Data Validation (SRC to Target using intermediate to complex SQL queries).
  • Determined Scheduling/Test Estimations.

We'd love your feedback!