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.
• Coordinated cross-functional delivery on capital projects of roughly $1M and 6+ months, involving 5 or more outside companies across vendors, engineering, electrical, sales, and general contracting.
• Transformed a TPD client's note-taking from hours of manual work into a Claude workflow that extracts notes from 500+ page PDFs into organized spreadsheets, which they now use on their own.
• Wrote the user guide and wiki, plus a developer architecture guide, changelog, and release process, making the add-in ready to hand off and support.
• Developed a dual-baseline Smartsheet schedule template through stakeholder interviews, giving project teams a repeatable way to track planned versus actual timelines.
• 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.
• Released the add-in as open source under the MIT License with the client's approval, keeping the company's name, logo, and all customer data out of the public repository while making the tool free for others to use and improve.
• Established the first standardized naming and markup conventions for equipment cut sheets which, together with the custom add-in and documentation, cut the time to prepare equipment lists, customer equipment lists, and RFQs from 10 days to 2.
• Coached a fellow TPD consultant in adopting Claude Code for engineering work and Claude for client tracking, time reporting, scheduling, and handoff documents and drawings, now part of his daily workflow.
• Delivered 11+ versioned releases, tracking work through 70+ GitHub issues and 98+ pull requests and turning team feedback into steady improvements.
• Vetted equipment quotes against the specification, competing bids, and the project schedule, keeping capital purchases accurate, fairly priced, and on time.
• Defined a repeatable release process, from release pull request through scripted build, drift check, and smoke test to a tagged release, ensuring every version ships with the same checks and updated documentation.

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

• 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.
• 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.
• Built credit-check test coverage from scratch in about two weeks for the device installment plan launch, partnering with credit, billing, and data teams to create test customers across credit classes.
• 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.
• Coordinated with partner teams to resolve data discrepancies between Verizon and partner test environments, working around partner sync jobs that lagged by minutes or hours or failed outright, and caught major issues before they reached production.
• 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.
• Led QA across project teams of up to 20, coordinating onshore and offshore testers through daily handoffs spanning multiple time zones, keeping testing momentum consistent between shifts.