SUMMARY:

Detail - oriented and conscientious Quality Assurance Analyst with proven expertise in software development, systems analysis, and quality assurance. Customer-focused and result-oriented professional skilled in all aspects of software testing including test management, test development, and test execution.

TECHNICAL SKILLS:

QA/Testing Tools: HP Application Lifecycle Management (ALM), Microsoft Team Foundation Server (TFS) / Test Manager, JIRA, Structured Query Language (SQL)

Databases: Teradata, Netezza, Oracle, DB2 UDB, Mainframe DB2, SQL Server

Operating Systems: Windows, UNIX (HP-UX)

Programming Languages: UNIX Korn Shell Scripting, HTML, CSS, familiar with Java, JavaScript, COBOL, JCL

Other Tools: MS Office, MS Project, MS Visio, Hyperion Interactive Reporting Studio, SPUFI, QMF, Teradata SQL Assistant, ProClarity, SharePoint, Adobe CQ/Adobe AEM, HP Web Proxy, SQL Server Management Studio

PROFESSIONAL EXPERIENCE:

Confidential, Roswell, GA

Senior IT Quality Assurance Engineer

Responsibilities:

• Serves as QA Lead for company Communications projects including an Adobe CQ implementation of the company intranet, customer-facing media site, and automotive product sites, a .Net implementation of the company’s United Way Giving website, and a Siebel application for the company’s media contacts
• Validates published sites in multiple browsers and mobile devices during System Integration Testing (SIT), Regression Testing, and production deployments
• Creates and executes SQL queries to validate Cognos reporting data as well as interfaces between internal and external systems
• Participates in various aspects of the Agile development process including daily standups, story development, grooming sessions, sprints, weekly status and planning meetings, and retrospectives
• Analyzes and reviews business and system requirements, develops software test plans, and creates test estimates for quarterly releases
• Utilizes HP ALM and MS TFS to maintain user stories, log and manage defects, and organize, develop, and execute test cases
• Mentors and leads junior QA analysts, assisting with new hire training and acclimation to team processes and procedures

Confidential, Atlanta, GA

Senior Quality Assurance Analyst

Responsibilities:

• Served as a Quality Assurance Analyst for the Enterprise Data Warehouse team responsible for performing all aspects of verification, including functional, regression, and system testing
• Validated BusinessObjects reports and online website reports, data requests from the Confidential Futures Trading Commission (CTFC), and data file submissions mandated by the Dodd-Frank Act and other government laws and regulations.
• Wrote SQL queries to validate report data and data requests against Data Warehouse tables
• Assisted with establishing and promoting team processes for task, requirement, and defect tracking in JIRA and Quality Center
• Designed and developed test artifacts such as test cases, test strategy, defect reports, and detailed test summary for bug fixes, enhancements, and major projects
• Conducted test case reviews, defect reviews, and status meetings with development team, business partners, and management team

Confidential, Atlanta, GA

Contractor - Testing Project Manager

Responsibilities:

• Served as Testing Project Manager for Positive Train Control (PTC) project test team
• Developed and maintained a MS Project workplan for unit, integration, and end-to-end testing
• Reported status to the extended project team via weekly email status updates
• Performed administrative tasks for the project team such as scheduling and coordinating team meetings, documenting and posting meeting notes to Sharepoint, and generating weekly task lists for each team member

Confidential, Atlanta, GA

Contractor - Sr. Test Engineer

Responsibilities:

• Served as Test Lead over regression testing for current Customer Management System (CMS) as well as test lead over assigned subject areas for rewrite of the CMS application
• Developed MS Project workplan, Master Test Plan and Communication Plan for assigned projects
• Coordinated the development of test scenarios and test cases for regression testing, system testing, and user acceptance testing for a flight reservation system
• Tracked system defects and manage issues related to regression and user acceptance testing efforts performed by in-house and offshore testers in HP Quality Center

Confidential, Alpharetta, GA

Software Quality Assurance Engineer IV

Responsibilities:

• Documented Confidential Workforce Analytics Healthcare ( Confidential ) SQL Server Reporting Services (SSRS) report functionality and functional test cases
• Developed and executed test cases, and test scripts to verify defects in Confidential Confidential report RDLs and SQL Server stored procedures in an Agile environment
• Created, tracked and maintained client-reported defects in DevTrack defect management system

Confidential, Atlanta, GA

Contractor - IT Quality Assurance Analyst

Responsibilities:

• Validated historical and ETL incremental load processes for an Enterprise Data Warehouse Re-platform project to migrate data from DB2 to Teradata
• Served as the lead tester for the Inventory implementation of the Teradata project
• Developed test strategy and executed test scripts to validate ETL graphs to load Teradata tables
• Tracked and managed defects and documented test strategy and test cases in HP Quality Center
• Created complex SQL queries in DB2 and Teradata to verify data quality and accuracy
• Served as the lead tester for validating data quality of multi-dimensional cubes built on top of warehouse tables
• Responsible for creating and customizing Quality Center project, creating roles, granting privileges and training project team members on the use of Quality Center
• Developed standard detailed test artifacts including Master Test Plans, test cases, and assessments
• Identified and tracked defects, issues, risks, and action items in HP Quality Center
• Managed testing effort for production support maintenance releases, mission-critical adhoc bug fixes, and other expense work
• Coordinated QA environment setup including database scheduling, data refresh, and application access privileges for offshore QA resources
• Designed and developed manual black box test cases to validate reports, dashboards, and ETL data transformations in a Business Intelligence/DB2 Data Warehouse environment

Confidential, Johns Creek, GA

Contractor - Test Analyst

Responsibilities:

• Compiled test estimates and assisted with determining test scope and test strategy for project
• Created and executed black box test cases from business and technical requirements
• Reduced defects by ensuring compliance with Confidential ’s quality processes
• Identified and documented application defects in Bugtracker
• Participated in daily defect meetings and defect resolution with development staff
• Mentored contract personnel on test strategy and test validation techniques using MST Mainframe legacy systems

Confidential, Atlanta, GA

Contractor - Quality Assurance Auditor

Responsibilities:

• Audited project and release deliverables for compliance with company standards
• Increased quality of project deliverables by proposing recommendations for improvement
• Created and executed both manual and automated black box test cases in HP Quality Center and QuickTest Pro
• Documented, tracked, and managed defects discovered during test cycles in HP Quality Center

Confidential, Atlanta, GA

Senior IT Quality Analyst

Responsibilities:

• Prepared test cases and SQL test scripts for Inventory, Sales, Labor, and HR Data Warehouse applications using Mercury Test Director
• Managed and coordinated requests for regression testing activities for production support defect fixes in a DB2 UDB environment
• Resolved data and functionality issues in software releases for data warehouse applications
• Certified all data warehouse applications for rollout to stores via the company’s portal
• Conducted black box testing of data warehouse web Inventory, Sales, Labor, and HR applications created in Hyperion/BRIO, .NET, and Microsoft Reporting Services (MSRS)
• Developed complex SQL queries to validate Ab Initio ETL data loads using SPUFI and QMF
• Utilized Hyperion, Access, and SAS to analyze and validate data
• Developed and implemented quality processes, resulting in increased efficiency the production support team
• Developed and executed test scenarios for validating SAP Business Warehouse reports, HD Self-Checkout Point-of-Sale terminals and Remote Attendant Post
• Managed development and testing activities of a team of four (4) technical resources in the implementation of a near real-time, Java workflow application with a DB2 backend
• Created project artifacts including use cases, sequence diagrams, system diagrams, and XML schemas
• Wrote detailed project design documentation to document system attributes and features
• Designed, coded, and tested INFORMIX 4GL online and batch programs and UNIX Korn shell scripts for various financial systems
• Customized PeopleSoft Financial Module user screens using PeopleTools
• Developed custom Crystal Reports for end-user reporting from PeopleSoft Financial Module
• Coded and tested BRIO SQRs, COBOL programs, and JCL programs in a Mainframe DB2 environment