Dusty Juhl Resume

Dusty Juhl

 Ankeny, Iowa
 dustyjuhl@gmail.com

 About

Experienced software tester with over fifteen years of software development experience; experienced QA Lead, Analyst, and Tester performing API, functional, database, regression, accessibility and UI testing of web-based applications for web, mobile, and desktop applications; experienced in sales, enrollment, invoicing, payment, data collection, and reporting systems across a wide variety of industries including agriculture, retail, insurance, health care, staffing, home mortgage, and security.

 Skills

Platform: Windows 10, Linux Ubuntu, Mac OS, Android, iOS
Browsers: Chrome, Edge, Firefox, Safari
CI / CD: Jenkins, Bitbucket, Git, GitHub, Travis CI
Cloud: Azure Data Factory, Portal, and Storage Explorer
Applications: Atom, Microsoft Office 365, Power BI, Visual Studio Code
Databases: SQL Server, MySQL, Oracle
DBMS: SQL Server Management Studio, MySQL Workbench, phpMyAdmin, Oracle SQL Developer, PL/SQL Developer
Languages: HTML, CSS, JavaScript, SQL
Methodologies:  Agile Scrum / Kanban
Testing Tools: Chrome Dev Tools, Charles, Fiddler, Postman, Jira, Confluence, Azure DevOps, SharePoint, TalkBack, VoiceOver, XMind, Beyond Compare, Bug Magnet, LastPass, Microsoft Teams, Notepad++,  Slack, SnagIt, SQL Prompt, Win SCP, XML Pretty Print, Zoom

 Employment

QA Test Analyst (Consultant)
Corteva (via QCI)
May 2019 – March 2022
Johnston, IA

Consultant for three separate Scrum/Kanban teams with 4-5 developers each, developing two .NET/Angular web applications, and a separate data management system using Azure functions, data factories, and storage explorer.

  • Tested a new internal Azure .NET/Angular web application with features supporting configuration of sales year data for the Connex system, using Azure DevOps, Azure Data Factories/Pipelines, Power BI, and SQL Server Management Studio (SSMS)
  • Performed ETL testing on the import of flat-file data from internal (SharePoint) and external (third-party) sources into SSMS; tested the export of the data to internal and external (third-party) destinations using the Azure Portal, Storage Explorer, Data Factories/Pipelines; SharePoint, SSMS, and sFTP
  • Tested the features for a new internal Azure .NET/Angular web application creating an approval workflow for new rebate programs created by Marketing for use by Sales Reps, using Azure DevOps, SSMS, and Swagger
  • Performed database testing in SSMS using various SQL statements for data verification / validation, and data updates / inserts
  • Created Power BI reports to verify records counts for ETL data transfers via Azure data factories/pipelines
  • Conducted code reviews of pull requests to provide feedback and identify defects prior to merging code
  • Created test cases, executed tests, and recorded defects using Azure DevOps
  • Performed API testing in the Test environment using Swagger
  • Executed release testing in the Staging environment
  • Developed test automation strategy to identify / consolidate tests for automation and increased test coverage
  • Facilitated and participated in backlog grooming of user stories; prioritized and estimated stories for sprint planning; decomposed stories and added further detail for development and testing

QA Analyst (Consultant)
State of Iowa (via Beacon Hill Technologies)
January 2019 – May 2019
Des Moines, IA

Responsible for testing applications for multiple teams related to the Hawk-I data migration project to bring third-party system functionality and data in-house for mainframe and web applications.

  • Tested the new enrollment process for Hawk-I recipients, verifying new enrollments display in the Medicaid Management Information System (MMIS) mainframe application, and payments for service are processed via the Premium Payment System (PPS) web application
  • Focused on testing the integration points of all the various applications and data files, from flat files and EDI files to the mainframe application, front-end web application, and SQL Server database
  • Verified existing data migrated from the third-party system remains unchanged in the in-house applications
  • Developed test cases using Team Foundation Server (TFS) for MMIS and PPS for new enrollments, enrollment changes, payments for service, non-payment / disenrollment, reinstatements, and annual renewals
  • Recorded defects in TFS and assigned to the appropriate team; tracked defect resolution and re-tested resolved defects

Sr. QA Analyst (Consultant)
ADT (via Dynamo)
April 2017 – October 2018
Urbandale, IA

Responsible for manual testing on a Kanban team building features for professional security monitoring of the ADT Go, ADT SmartThings, and ADT Canopy applications.

  • Utilized custom built (in-house) simulator for testing enrollment, payment, and customer self-service processes in the Test environment for IoT devices; used the simulator to enroll, make payments, add IoT devices, and send alarm events
  • Tested hybrid mobile applications in the Sandbox environment using actual devices (Android and iOS)
  • Setup a proxy server via Fiddler to intercept network traffic during mobile application testing
  • Paired IoT devices with a mobile application and central device hub for testing by scanning device bar codes via the mobile application
  • Tested IoT devices in the Sandbox environment to monitor alarms and dispatch requests; triggered alarms for each device to verify all alarms were received, the correct events were attributed to each device, and verified continuous event monitoring
  • Performed API testing using Postman in the Test environment; used JavaScript to parse JSON API responses and create variables to tie a collection of API requests together; created tests to verify the correct HTTP response codes were received
  • Performed database testing in MySQL for Test and Sandbox databases using various SQL statements for data verification / validation, and data updates / inserts
  • Performed accessibility testing for mobile applications using TalkBack (Android) and VoiceOver (iOS) screen readers
  • Identified test data based on acceptance criteria in Jira and MySQL database queries
  • Created test cases using Google Sheets and sub-tasks in Jira stories
  • Analyzed test results, recorded defects and conducted bug regression in Jira
  • Reviewed pull requests and commit messages in Jira / Bitbucket to identify potential test scenarios and risks
  • Deployed new builds to the Test environment via Jenkins in a CI / CD environment; tagged verified builds for Bitbucket using the Terminal; used Jenkins to promote builds to upper environments (Sales, Sandbox, Training)
  • Participated in backlog grooming of user stories; decomposed stories and added further detail for development and testing
  • Screened resumes for other QA candidates

QA Test Analyst (Contractor)
DuPont Pioneer (via Aureon)
August 2014 – March 2017
Johnston, IA

Performed manual testing on a Scrum team of 3-5 developers building payment features for the Connex mobile sales application which processes 25% of annual sales revenue in just a two-week period—over $1 billion in revenue; performed backlog grooming of user stories.

  • Tested the payment features of an external-facing web application for various user workflows (internal users, external customers, and hybrid sales representatives); used a check scanning device to manually scan checks into the system for payments; tested epayments based on account and routing number; tested line of credit purchases and loan payoff
  • Tested a mobile web application (iOS) in the QA and Staging environments using both an actual device (iPad) and virtual devices via MobileLabs
  • Performed database testing in SSMS using various SQL statements for data verification / validation, and data updates / inserts
  • Identified test data based on acceptance criteria in Team Foundation Server (TFS) and SSMS database queries
  • Created test cases, executed tests, and recorded defects using Microsoft Test Manager (MTM)
  • Executed weekly release testing of customer-facing web and mobile applications (iOS) in the Staging environment using a suite of regression tests in MTM
  • Developed test automation strategy to identify / consolidate tests for automation and increased test coverage
  • Participated in backlog grooming of user stories; prioritized and estimated stories for sprint planning; decomposed stories and added further detail for development and testing

SQA Analyst (Contractor)
Wells Fargo (via Signature Consultants)
May 2013 – August 2014
West Des Moines, IA

Tested the Mortgage Servicing Package (MSP) mainframe application and the Servicing Loan Decisioning Tool (SLoaD) rules engine for the Home Affordable Modification Program (HAMP), enabling borrowers to remain in their homes.

  • Performed ambiguity reviews of business requirements in Business Requirement Documents (BRD)
  • Identified test data based on business requirements and using various SQL queries in Oracle SQL Developer and SQL Server Management Studio (SSMS)
  • Created test cases using HP ALM / Quality Center based on business requirements and functional specifications
  • Tested the SLoaD web application; performed database testing as data moved from Oracle to SQL Server
  • Executed test cases via ALM / Quality Center, analyzed results, and recorded defects
  • Managed defects in ALM / Quality Center; conducted bug regression for resolved defects
  • Organized daily standup meetings for team members

Test Analyst (Contractor)
Dice Holdings, Inc. (via The Palmer Group)
August 2011 – March 2013
Urbandale, IA

Responsible for testing on a Scum team building features for the Dice.com and ClearanceJobs.com online job boards, catering to employers and job seekers via web, mobile web, and hybrid mobile applications.

  • Tested the signup process for a new job seeker, including setting up a profile, uploading resumes of various file formats, testing OAuth login access using Facebook credentials, searching for jobs, setting up job alerts, and applying for existing jobs
  • Performed regression testing and verified new functionality in Production for each Production release
  • Executed cross-browser testing using virtual machines for various OS and browser configurations
  • Created test cases based on acceptance criteria in Jira user stories
  • Updated Selenium IDE test scripts for job seeker testing in ClearanceJobs.com
  • Tested the Dice hybrid mobile application and mobile website on Android and iOS devices
  • Participated in backlog grooming of user stories; decomposed stories and added further detail for development and testing

 Education

Bachelor of Science, Iowa State University
December 2001
MIS/Mathematics

 Continuing Education

Des Moines Area Community College (DMACC)
Advanced PowerBI
November 2019

DeltaV Code School
Code 102 – JavaScript
October/November 2019

Des Moines Area Community College (DMACC)
PowerBI Fast Track
June 2019

DeltaV Code School
Code 101 – HTML/CSS
January 2019

 Certifications

  • CSPO (Certified Scrum Product Owner) – Scrum Alliance, December 2021 – 2023
  • CSM (Certified Scrum Master) – Scrum Alliance, June 2014 – 2022

CSM badgeCSPO badge

 Professional Associations

 Publications

Back To Top