SUMMARY

• Senior Quality Assurance Analyst / Tester with over twenty years of experience in Quality Assurance and an understanding of teh QA role in teh Software Development Life Cycle (SDLC).
• Experienced in executing manual black box Tests, setting Test Conditions, Test Data, and Expected Results for Functional, Regression, Integration, Stress, and User Acceptance Testing (UAT).
• Strong SQL skills in a production environment and thorough knowledge of Relational Databases.
• Highly developed, process - oriented skills for troubleshooting, problem solving, and process streamlining.
• Highly proficient with Microsoft Office, including teh use of VBA Script Macros, Pivot Tables, Pivot Charts, and formulas.
• Extremely focused and results-oriented in supporting complex, deadline-driven operations; able to identify goals and priorities and resolve issues in initial stages; demonstrated ability to thrive in a business-critical high stress environment.

TECHNICAL SKILLS

Operating Systems: MS Windows 95 through 10 Enterprise, MS DOS, UNIX

Documentation Tools: MS Word 2017, MS Excel 2017, Mercury Quality Center, ApTest Manager, MTM, Azure DevOps

Defect Tracking Tools: Team Foundation Services (TFS), JIRA, Mercury Quality Center v8.2, MS Visual SourceSafe, PVCS Tracker, MS Excel, Lotus Notes, Azure DevOps

Databases: MS SQL Server 7.0 through 2016, Oracle v10g

Automated Testing: Mercury Quick Test Professional (QTP) v9.5, Selenium using Eclipse 2020-03

Applications: Data Junction Integration Studio 7.5.5, MS PowerPoint, MS Visual SourceSafe, MS Visio, MS Visual Studio 2003 through 2017, Red Gate Toolbelt, Inventory Management System (IMS), Oracle 10g Client, SignIQ, ZONTALK, TermMaster, VBA Script

PROFESSIONAL EXPERIENCE

Confidential, Dallas TX

Senior Quality Assurance Analyst

Responsibilities:

• Electronic Data Interface (EDI) testing for mortgage files dat get sold/transferred to investors.
• DataMarts testing for fields from teh Loan Origination System (LOS) getting uploaded correctly into teh DataMarts tables.
• ETL (Extract, Transform, and Load) testing for numerous reports from teh LOS database tables.
• Lead QA on teh integration of teh DocVelocity document repository application dat replaced teh previous XDOC document repository application.
• Lead QA on teh integration of teh Blue Sage LOS application dat replaced teh previous PrimePath LOS application.

Confidential, Allen, TX

Quality Assurance Tester

Responsibilities:

• Primary QA Tester for teh processing of Lender Files, while being teh sole QA Tester for this part of teh project for teh majority of 3 years.
• Converted Production-created Data Junction scripts for use in teh test environments.
• Modified Data Junctions for various testing scenarios.
• Create Test Cases, Scripts, and Scenarios with or without Requirement documentation provided.
• Created and executed SQL queries to ensure teh imported data updates from teh Lender Files were correct.

Confidential, Dallas, TX

Senior QA Analyst

Responsibilities:

• Teh USPS eOPF project was a web-based Ruby Rails application to track Liners, Boxes, Folders, and Documents through teh system until archived at NARA Lead QA Tester.
• Created Functional Test Cases from Business Requirement Documents.
• Supported teh Operations team and corrected user-errors when encountered by teh operators.
• Provided statistics from SQL queries of teh production databases as needed.
• Teh PCS Perform project is a web-based .NET application to track users’ performance and quality, used for performance-based or piece-meal payout.
• Performed testing for consolidating custom versions of teh application for individual locations into one build version for all locations, allowing needed customizations to be configured in database tables or configuration files.
• Created detailed Change Request templates, coordinating between IT and DBA groups for upgrades to UAT and Production environments.
• Teh PCS Track/PCS Manifest projects are web-based .NET applications to track shipments and location of boxes/containers within teh workflow and storage locations
• Created manual replacement separator sheets in MS Word for rare instances when an error prevented printing teh separator sheet using teh applications. Saved in PDF format and sent to customer so dat document could be scanned and production time was not halted.
• Teh KYDOR Corporate project is a combination of web and WinApp applications for scanning, indexing, data entry, and exporting images and metadata to teh customer. Reporting is supported using an OLAP (Analysis Services) cube.
• Performed deployments to teh QA, UAT, and Production environments.
• Maintained and updated deployment process using Robocopy and Red Gate command line scripts.
• Documented teh build process and deployment process for a less-technical user to perform teh Visual Studio application builds and deployments.
• Sole QA Tester of teh OLAP Cube used for reporting.
• Oversaw teh creation of, maintained, and updated an automated testing utility using VBA in Microsoft Excel to compare data synchronization between teh cube and transactional tables, and ensure all cube fields were reportable.Created and executed over 17,500 test cases.
• Teh Check21 project was a third-party application to convert paper checks to legal electronic copies for teh Alabama Department of Revenue
• Tested teh application prior to its implementation into Production on a hard-set cutover date from teh old system, set by teh Alabama Department of Revenue. Required working closely with teh third-party Project Manager and developers to ensure issues were addressed and corrected immediately, to avoid costly penalties by teh state of Alabama.

Confidential, Addison, TX

Quality Assurance Analyst

Responsibilities:

• Teh SignIQ project is a GUI-based application for creating teh signs used in teh stores. Lead QA Tester.
• Wrote and executed SQL queries to modify test data, modified and tested local Data Transformation Services (DTS) packages, tested Stored Procedures, and tested User Defined Functions.
• Tested custom C#.NET Promotions GUI application which interacted with teh SignIQ application to create specialized signage for Rebates and Advertisements.
• Created Test Matrices and Functional Test Cases from Business Requirement Documents and Technical Specifications.
• Managed two temporary personnel testing teh Promotion Entry GUI, while continuing to test teh Credit Switch application.
• Tested client server applications used in conjunction with teh SignIQ and Promotions GUI projects and verified signage delivery to all QA store PC’s.
• Teh Credit Switch project was an application dat was to ensure security compliance for teh major credit card companies.
• Became teh lead Inventory Management System (IMS) tester with limited training and nonexistent documentation for teh Credit Switch project.
• Created Test Matrixes and performed tests using teh POS system and IMS.
• Created numerous utilities in MS Word and Excel to parse XML Tags, FID’s, and Bitmap fields from messages and compare them against each other, and against teh provider-specific documentation.
• Wrote and executed SQL queries in Oracle 10g client to ensure data written to database matched teh data received in teh messages.
• Created comparison utility in Excel for Store Planning dat allows them to compare teh original spreadsheet for an “Advertised” promotion to teh latest edition to ensure dat anything dat had changed has been updated in teh current promotion.
• Created batch jobs to halp other Analysts retrieve files from an FTP location to use locally or put those files in a different FTP location, as needed.
• Teh POS projects were on teh IBM4690 register system.
• Performed Point-of-Sale (POS) testing on teh register system as needed, including related peripherals such as printers, PINpads, and handheld scanners.

Confidential, Carrollton, TX

SQA Tester

Responsibilities:

• Created an Excel tool to compare teh production environment with staging environments, eliminating teh error-prone, visual comparison of teh multi-tier directory structure of teh website.
• Executed over 1,000 manual, Lotus Notes-based test cases prior to teh final production upgrade.

Confidential, Dallas, Texas

Deployment Manager

Responsibilities:

• Ensured a minimum 97% error-free terminal deployment rate.
• Decreased SQL setup time from 15 minutes per terminal to 15 minutes for 300 or more terminals.
• Developed Stored Procedure utility in MS Excel to create Execute statements and ran Stored Procedures on production SQL database to setup Retailers, Stores, and Terminals.
• Managed deployments of over 14,000 terminals for numerous customers including Circle K Stores, MCI, GE, Panera Bread, and Aloha Technologies; over 12,000 units deployed to Circle K Stores locations nationwide, including 3rd-party kitting materials.
• Developed and maintained deployment statistics reports for weekly meetings using MS Excel with VBA Script macros, Pivot Tables, and Pivot Charts.

Quality Assurance Technician

Responsibilities:

• Actively participated in conferences between clients, developers, Account Managers, and QA when needed.
• Performed testing of ASP web interfaces in QA, Staging, and Production environments.
• Created MS Access database to track customer’s test cards received for projects.
• Ran ad hoc SQL queries to troubleshoot production issues, created SQL queries to correct any issues, and wrapped queries into SQL transactions to ensure 100% accuracy before committal.
• Performed upgrades and testing on staging server environment prior to production upgrades and participated in server level application upgrades on production system and performed all testing.
• Performed Automated Clearing House (ACH) setup of customers' banking information into teh production server.
• Created user accounts and email accounts, assigning appropriate permissions on teh Windows Network and MS Exchange Server; created and updated user accounts in teh AUDIX telephone system.
• Provided 2nd level support for customer issues using PVCS Tracker database for accountability and traceability.
• Researched support issues to determine probable cause, and followed through to issue resolution.