Steve Johnson

Digital Transformation Consultant / Project Manager (Contract)

• Built and maintained an open-source VBA Excel add-in that turns Smartsheet exports into branded customer equipment lists, project schedules, and vendor quote packages, cutting a 4+ hour, several-hundred-click manual build to 4 clicks and about 10 seconds.
• Stored user settings in the Windows registry after finding that Excel never saves an add-in on close, so each user's choices now persist between sessions.
• Moved the add-in from an unversioned single file to a source-controlled project with a scripted build, making every release repeatable and every change traceable.
• Replaced confidential customer workbooks with synthetic test data that mirrors the structure of real exports, checking the generated files for leaked identifiers, letting the add-in be open-sourced for a client without exposing customer data.

• Quality Assurance Lead2017-2024(Concurrent Jira Project Lead)
• Quality Assurance Engineer2012-2017

• Owned governance for a Jira instance with 10,000+ users, establishing request and approval workflows that cut unauthorized feature additions by 90% within three months.
• Monitored Kibana error logs from launch war rooms during device launches and peak retail events, escalating live production issues while the launch was underway, and investigated defects through the logs, filing them with evidence and confirming fixes held after deploy, limiting customer impact and helping developers fix problems fast.
• Consolidated Jira labels from thousands of inconsistent variants to a couple hundred owned labels, routing defects to the teams responsible for fixing them.
• Built Kibana dashboards and saved searches the team used for error monitoring and defect investigation, giving testers one place to spot trouble and trace its cause quickly.
• Inspected network logs, session data, cookies, and mobile browser behavior in Chrome DevTools during testing, pinpointing whether a failure came from the page, the network, or the server before filing it.
• Validated 20 third-party subscription integrations end to end, using Postman to confirm subscription status and service tier against each partner's API, and SQL to verify the matching subscription and customer IDs stored on Verizon's side, confirming both companies' records agreed before customers relied on them.
• Tested the full subscription lifecycle in SQL, including activation, pause, tier changes, cancellation, and resubscription with existing or new customer details, confirming every stage was recorded correctly and each customer's subscription history stayed accurate and traceable.
• Simulated man-in-the-middle and cross-site scripting attacks with Burp Suite as part of fraud testing, probing for session-hijacking and script-injection weaknesses before real attackers could.
• Restricted label editing to a small group and published a self-service Confluence guide for requesting access and new labels.
• Owned end-to-end testing for a site serving 70M monthly visitors plus native iOS and Android apps, across multiple browsers (Chrome, Firefox, and Edge, with Internet Explorer as needed) in desktop, tablet, and mobile.
• Created Confluence guides and recorded training sessions that got new onshore and offshore testers productive in about a week, and walked product owners and PMs through testing workflows across DevTools, Kibana, databases, CRM, and employee-facing systems.