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.