PROFESSIONAL SUMMARY:

• Senior Quality Assurance Analyst experienced with Web Testing, Data Base Testing, ETL Source - to Target, Web Service (SoapUI), System, Functional, End-to-End, System Integration, Sanity, Smoke, Regression, UAT and Production Support Testing.
• Recent project experience includes: Web Testing (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.
• Web Services Testing, SOA, e-commerce and cross-browser testing.
• Visualization Testing -Dashboard Reports, Business Objects Reports, MicroStrategy Reports. Microsoft Stack.
• Experience with TOAD, SQL Navigator, SQL developer, SQL Server Management Studio 2012.
• Data Mapping, Data Modeling & Schema verification, CRM, Loyalty Systems, Requirements gathering/management, Agile Methodology (scrum), Agile User Story testing, MINGLE Agile Management tool, Rally, JIRA, Sprint Planning/Task Planning.
• Visual Studio, TFS, Test Manger, SQL Server Management Studio, JIRA, Doors, HPQC ALM, SharePoint, agile task planning-Backlog Grooming-Backlog, User Stories, Erwin (ER), and Visio.
• Experienced working/leading onsite and offshore test teams.
• Work closely Project Managers, Scrum Masters, Business Analyst’s, and SME’s.
• Experienced with HP Quality Center (ALM,QC, Test Director,) in the areas of: Requirements, Test planning (test case design), Test Lab (test set execution - Manual & Automated), and Defect Module (defect creation/tracking & management).
• Also experienced using other test management systems to include: Rational SQA Manager, QA Partner, and TestLink.
• Defect tracking experience with systems such as: HP Quality Center & Test Director, Accept 360, ClearQuest, IBM Team Connection, Mingle Agile Management Tool. Traceability Matrix.
• Agile experience includes: Scrum, User Story management/review/test case design by use of JIRA, Rally, Mingle Agile project management tools.
• Work closely with agile team members (dev, PM, Scrum Master, test team members, BA’s etc.) during sprint planning, test case creation (from story cards), test execution within sprints (14, 21 & 30 day), Hardening (release regressions).
• Processes/methodologies experienced with: Iteration testing, Waterfall, CMM, ISO, Unified Process, and RUP.
• Data Modeling/Schemas, Business Objects (BI) Report Testing, Crystal Reports, and MicroStrategy.
• Oracle 7/8/9i/10i, Office 2003/2007, Visio, SoapUI, PVCS Tracker.
• Familiar with the following languages: C/C++, VB, VBScript, Java, JavaScript, HTML, soap protocol, COBOL, TSL, 4Test, SQL, SQL+, e-commerce, Testing Anywhere Automation tool & HP QTP.
• Experienced working independently and/or within team environments using both Agile and Waterfall methodologies.

PROFESSIONAL EXPERIENCE:

QA Test Engineer - Consultant

Confidential, Buckhead, GA

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 Studion/tfs.
• Testing of ETL, Jobs, Deployment processes, Source Data Files, SRC to Target, Dashboard Reports, Related RevenueManagement 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.

Senior QA Analyst-Consultant

Confidential, Buckhead, GA

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.

Senior SQA Test Engineer - Consultant

Confidential, Alpharetta, GA

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.

Senior QA Analyst - Consultant

Confidential, Dunwoody, GA

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.

Senior QA Test Engineer - Consultant

Confidential, Atlanta, GA

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.

Senior QA Test Engineer - Consultant

Confidential, Alpharetta, GA

Responsibilities:

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

Senior QA Test Engineer - Consultant

Confidential, Atlanta, GA

Responsibilities:

• 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.
• 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).

Environment: Oracle Data Warehouse/Data Mart, Informatica ETL tool, Access DB, Mercury Quality Center, Toad, UNIX