Kevin Johnston
Salem
Summary
Results-driven professional prepared for responsibilities of systems analysis role. Brings valuable experience in optimizing system performance and delivering impactful solutions. Known for effective collaboration with cross-functional teams and adaptability to evolving project demands. Skills include data analysis, process improvement, and technical troubleshooting.
Overview
13
13
years of professional experience
Work History
Systems Analyst
Oregon Department of Transportation
11.2014 - Current
- Performed impact analysis, system documentation, and implemented changes to 58 Access applications across Finance, Human Resources, Mass Transit, ODOT Maintenance, and Rail
- Application support
- 26 business systems
- .NET Core, .NET Framework, SQL Server, DB2
- Troubleshot business applications impacted by infrastructure changes.
- Analyze and resolved day to day technical issues with business
- Coordinate and plan for migrations for multiple integrated systems with impact analysis on the planned changes.
- Access server and version upgrades/migrations
- Windows compatibility migrations
- Designed user-friendly interfaces for various software applications, increasing ease of use and functionality.
- Developed comprehensive documentation for system functionalities, improving user understanding and operational effectiveness.
- Security remediation
- File server/SQL server migrations
- Workday integration project
IT Consultant
Meridian Technology Group
03.2012 - 05.2014
- On-site support for ODOT's client-server application migration to Windows 7 that included:
- Communicated effectively with IT and business
- Provided technical support during application deployment, ensuring seamless transitions for end-users
- Updates to Crystal Reports templates
- Created and modified application installation packages
- Collaborated with project managers to deliver high-quality software applications within set deadlines.
- Updated technical documentation, product specifications, and technical training materials
- Modified in-app queries as necessary to ensure they were SQL Server and Windows 7-compliant for VB6 and C# applications
- Resolved complex queries and stored procedures using MS SQL Server Management Studio
- Developed and optimized complex SQL queries for data retrieval and reporting
- Collaborated with cross-functional teams to implement integrated software solutions across departments
Skills
- Experience with Azure DevOps tools
- Skilled in developing applications with Visual Basic
- Database development in MS Access
- C# programming
- SQL Server development
- Experienced with Visual Studio IDE
- Experience with Visual Code tools
- VBA programming expertise
- Experience with Crystal Reports
- Skilled in using Adobe Illustrator
- CNC design proficiency
- CNC machining software expertise
- Software development lifecycle
- Problem-solving
- End user support
Accomplishments
- Modernize TEAMS/Reference Table Process - 2024 - Replaced process to import TEAMS data file into MS Access database into SQL Server database and updated application that depend on data connection.
- App Migration to Microsoft Office 365 - 2024 - Migrate MS Access to Office 365 to 64-bit from Office 2016, 32-bit
- Managed Automated Time Capture Operation Changes - 2019 - Create/modify ATC code requests from HBO during transition to TAMS
- App Migration to Windows 10 - 2018 - Migrate MS Access applications to Windows 10
- App Migration to Windows 7 - 2017 - Migrate Windows XP/NT desktop application to Windows 7
Timeline
Systems Analyst
Oregon Department of Transportation
11.2014 - Current
IT Consultant
Meridian Technology Group
03.2012 - 05.2014
Similar Profiles
Matthew J. L. KilgerMatthew J. L. Kilger
REAL ID Specialist at Oregon Department of TransportationREAL ID Specialist at Oregon Department of Transportation
Henry ThomsonHenry Thomson
Heavy Equipment Technician/Fabricator at Oregon Department of TransportationHeavy Equipment Technician/Fabricator at Oregon Department of Transportation
Alex FendallAlex Fendall
Fiscal Analyst II - Statewide Programs (Public Transportation Division) STIP Coordinator at Oregon Department of TransportationFiscal Analyst II - Statewide Programs (Public Transportation Division) STIP Coordinator at Oregon Department of Transportation
Cassaundra Wynia ScottCassaundra Wynia Scott
Inventory Specialist at MII AEROInventory Specialist at MII AERO
LAWRENCE MATHENGELAWRENCE MATHENGE
High School Business Leadership Worker at West Salem High SchoolHigh School Business Leadership Worker at West Salem High School