Steve Johnson

Digital Transformation Consultant / Project Manager (Contract)

• 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.
• Developed a dual-baseline Smartsheet schedule template through stakeholder interviews, giving project teams a repeatable way to track planned versus actual timelines.
• 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.
• 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.
• 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.
• 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.
• Refactored the codebase in small, reviewable changes, removing duplicated code across five user forms and replacing silent failures with errors users can see and report.

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

• 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.
• 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.
• Enforced requirements traceability by linking every defect to its test case and requirement, making it quick to tell whether the defect, test, or requirement was at fault.
• Authored requirements and acceptance criteria for an internal mock-customer data retrieval tool and worked with developers to strengthen test coverage, giving testers up-to-date and realistic customer data through tabbed field groups and fields searchable by name or ID.
• Streamlined Agile SDLC reporting for sprint-based teams, improving story tracking and resource allocation for globally distributed teams.
• Traced defective test cases and defects back to misunderstood or flawed requirements, getting every requirement corrected at the source so testers and developers worked from the same expectation.
• Wrote test plans that defined scope by environment, flow, and platform (web, app, or both) and estimated the resources needed to cover it, giving QA and project managers a realistic basis for staffing and scheduling.
• Challenged requirements based on learned experience, drawing on US customer expectations and advocating for them in stand-ups until the requirements were corrected, presenting customers' details the way they expect to read them.