Data Analyst and QA Engineer with SQL & Automation
Resume:
Jamie Mackey
Parker CO *****
**********@*****.*** JM
Computer Skills and
Experience
Sku Vault, BCC, Print Shop Mail, Ship Station, XAnlysis, Beyond Compare, AS400- iSeries, ChangeGear, Selenium, Eclipse, Java, Jira, Rally, Salesforce, HTML, XML, SVN, Bugzilla, Testopia, TestLink, Windows OS’s, Mac, Linux, SQL, relational databases, Putty, SilkTest, Ethereal, Cygwin, Brew Emulator, NetLink, Wireless Sniffers, NetLink Wi-Fi telephones, SVP server, Gateways, Protocol PBX’s, Cisco and Symbol AP’s, QuarkXpress, Visual Source Safe, Visio, Radar, AppleScript, Access, Eggplant, C, C++, Cobol, C#, Microsoft Visual Studio, TFS (Team Foundation Server), Solstice, Android pods, iOS, C#, Javascript
Experience
Plumb Marketing – Data Analyst/Variable Data Specialist Englewood, CO -2019 - Present
• Receive data and process it according to work orders in BCC (cass, ncoa, dedupe, and output)
• Upload tracking for all mail items in snailworks
• Upload edocs to USPS for mailing purposes with bar code tracking
• Create automation processes for repeat jobs in BCC (Task Masters)
• Print Shop Mail set up post cards, letters, and envelopes for print to then mail
• Add SKUs, Warehouses, Inventory for stores in SKU vault
• Add Stores, and orders in Ship Station for fulfillment
• Digital print Postcards, billing statements, envelopes, booklets etc for mailings
• Hand work including drilling, placing stickers, stuffing, folding, cutting and more
• Inventory items for fulfillment and print (paper, and envelopes, shirts etc) in midnight
• Track and update all work orders that move through data Business Analyst/QA Engineer, Nelnet
Denver, CO — Jan 17-2029
• Test, Verify, Validate Borrower processing and reporting applications
• Test all data via SQL in iSeries
• Document Requirements
• Analyze test results
• Develop, maintain and execute manual and automated Functional, User Acceptance, Data, and Interface tests
• Automate test cases
Host/Buser, Marlowes
Denver, CO — Feb 16-Jan 17
QA Manager, Mersive
Denver, CO — Oct 15-Feb 16
• Test Solstice software on all devices and platforms
• Test hardware continuous builds on Android pods
• Manage QA processes, bug reports, metrics and test devices QA/Automation Engineer, Healthgrades
Denver, CO — May 14-Oct 15
• Test browser based HG2 (desktop), Mobile, Tablet experience external websites
• Test MMP and Admins internal systems
• Check all database entries and changes in Microsoft Sql Server
• Document all testplans and testcases for each new piece of functionality in Test Manager
• Create/Run/Analyze all automation regression suites for each team and project during the iteration/sprint and for all steps and environments during the release process
• Document/track stories and defects in TFS
• Push new builds to all environments based on check-ins and associated tickets
• Manage release tickets and all items and instructions associated with the release
• Communicate directly with the release management team to complete each release QA/Automation Engineer, Envysion
Boulder, CO — May 13-May 14
• Test browser based Mvaas complex Business Intelligence application on all browser/OS platforms.
• Document all testplans and testcases for each iteration in TestLink.
• Create/Run/Analyze complex SQL queries for data integrity testing for all Business Intelligence reports.
• Document/track stories and defects in Rally.
• Create and run automated tests in Eclipse using selenium. QA/Automation Engineer, ReadyTalk
Denver, CO — Nov 06-April 13
• Test all browser based applications both customer facing and internal systems for the company including Web and Audio Conferencing service, Conference Center, Salesforce, Jira, Billing, and Admin Center.
• Write and execute test plans for each of the projects and releases.
• Document defects, and follow all the way through to retesting when released to production.
• Use SQL to query and change data in relational databases for testing purposes.
• Researched automation tools and provided management with the information necessary to select a tool.
• Managing the automation effort for back office CRM and billing system, including documenting processes and automating framework and test cases in Eclipse using Java and selenium.
• Participated in interviewing and hiring QA Candidates.
• Automated the Jira to Salesforce integration testing.
• Trained new QA Engineers on customer facing products, and Product Manager on internal systems.
• Created documentation and flow charts for provisioning and billing systems.
• Automated the regression tests of the new admin center customer facing system that allows external customers to provision new accounts and new billing back office system.
• Created integration testing between our CRM Salesforce and ReadyTalk’s conference center both ways.
Head Volleyball Coach, KIPP Collegiate HS
Denver, CO — Sept 12-Nov 12
• CHSAA certified high school coach
• Organized and ran all practices for both jv and varsity volleyball teams
• Managed rosters, attendance, and eligibility for 35 high school girls
• Drove 35 passenger vans to games throughout Colorado
• Entered stats, rosters and profiles for the teams in maxpreps QA Engineer, Spectralink
Boulder, CO — March 05-Nov O6
• Design and implement test software for real time digital, wireless telephone systems.
• Develop and execute formal test plans for integration, functional, regression, load, performance, and acceptance testing.
• Prepare and implement testing procedures using various QA methodologies.
• Configure test environments for more than 6 protocols including; Nortel, Mitel, Avaya, Intertel, SIP, and Alcatel.
• Investigate problems using logic analyzers.
• Report and track test data and write test summary reports in several formats for distribution.
• Communicate directly with developers to ensure prompt resolution of problems. QA Engineer, 9Squared
Denver, CO — April 04-March 05
• Manually test 7 different applications on more than 85 cell phone handsets.
• Use Brew testing tools to test handsets including; Brew Simulator, Brew AppLoader, and Brew Logger.
• Test other products as needed: connection/download times and product websites.
• Package all builds for NSTL final testing.
• Create process documents for all QA processes and report weekly progress and status.
• Generate new applications and upload all new images to server.
• Submit new applications according to Qualcomm standards NSTL for testing. Aquatics Director, Jeffco Family YMCA
Denver, CO — Sept 03-April 04
• Operate and Maintain 114,000 gallon indoor lap pool and spa.
• Manage 20+ team of instructors and lifeguards.
• Coordinate all swim lessons and aquatics programs.
• Conduct monthly audits and staff meetings.
• Oversee all training and certifications for employees.
• Member of the safety committee for the facility.
• Balance and maintain various chemicals in pool and spa.
• Operate within the facility’s limited budget and started the synchronized swim team.
• Create and distribute flyers promoting Jeffco’s aquatics programs. QA Supervisor, Quark Inc.
Denver, CO — March 99-June O3
• Supervise three global groups within QuarkXPress QA: Automation, AppleScript, and XDK teams.
• Delegate, prioritize, track, and coordinate multiple projects.
• Create, improve, and document QA processes.
• Perform risk assessment on features and components.
• Provide estimates for testing milestones, testplans, automated scripts, and test drivers.
• Create a testing strategy to test 4,000+ functions in QuarkXPress.
• Generate and revise training materials.
• Conduct annual team performance reviews.
• Report weekly team status and quarterly goal status.
• Perform inspections on testplans, data input tables, and automation scripts.
• Track team defects, enhancements, and doc-issues.
• Inspect requirements, user documents, and functional specifications.
• Administer weekly meetings with teams.
• Visit customers to discuss issues and workflows.
• Conduct interviews and hire for QA.
Education
Regis Univeristy
BS CIS — 2003
Beyond the basics Bird Care Certification (Gabriel Foundation) 2025 Humane Colorado Volunteer Aug 2025-present
Six Sigma Global Institute – Scrum Master Certification 2025 5C Gov’t Security Clearance 2017 – Denver, CO
ISSO Level 1 Cert 2017 – Denver, CO
CIS Certificate 2001
Applied Agile Testing Certificate through ProtoTest 2009 – Denver, CO CWNA – Certified Wireless Network Admin 2006 – Boulder, CO Certified Pool Operator 2004 - Golden, CO
Quest– Segue Software’s Users Conference 2001 - Orlando, FL Segue Advanced 4Test Language Training 2000 - Denver, CO Metropolitan State College of Denver 1999-00 - Denver, CO Old Dominion University 1998-99 - Norfolk, VA
CHSAA Coach Cert 2012 – Denver, CO
Concussions Cert 2012 – Denver, CO
Lifeguard/CPR/First Aid/AED 2013 – Denver, CO
References provided upon request.
Contact this candidate