Summary
Overview
Work History
Education
Skills
Websites
Career Experience
Training
References
Timeline
Generic

Scott Simpson

Phoenix,Arizona

Summary

Reliable self-starter with extensive hands-on systems integration experience and broad talent stack including large datasets, SQL, ETL, EDI, file transfer, object-oriented programming, middleware, firmware, and Mainframe expertise. Proven ability to improve application performance and optimize systems with seamless software upgrades, troubleshooting, and bug fixes. Effective mentor with deep knowledge of software development lifecycle including design, documentation, coding, test, and support.

Overview

26
26
years of professional experience

Work History

One Main Financial

11.2023 - 01.2024
  • Researched and documented how to implement Rest Webservice calls to the iSeries
  • This included integrating MuleSoft, the MDCSM Rest4i platform, and the existing COBOL code base.

Knight Transportation

02.2023 - 08.2023
  • Worked on modifying the order numbering approach from numeric to alphanumeric to expand the capacity of the existing database field without requiring file reformats
  • Migrated existing FTP application to SFTP from Alliance to Goanywhere platform.

Dream City Schools

08.2022 - 02.2023
  • 6th grade Math teacher and tutor
  • Developed curriculum and taught 6th grade level math
  • Tutored Elementary to Junior high-level math.

Knight Transportation

03.2021 - 08.2022
  • Worked with NavTrac on fixing problems with an existing interface that was causing the application to halt resulting in operation downtime
  • Worked with DB2 for i
  • Used Screen Design Aid in program maintenance and screen creation
  • I worked with the Trimble/ICC trucking software
  • I applied my knowledge of IBM service program to fix signature violations on vendor code running in QA
  • Implemented service programs in multiple applications allowing modular design and re-usable code.

Programmer Analyst

Costco Wholesale Corp
Issaquah, Washington
05.1998 - 10.2019
  • Analyzed user requirements, developed detailed system design specifications and wrote program code for applications.
  • Developed and implemented software solutions to improve the efficiency of existing systems.
  • Prepared technical documentation including flowcharts, diagrams, manuals, reports. related to programming projects.
  • Performed data analysis on large datasets using SQL queries and stored procedures.
  • Utilized various source control tools like GIT and SVN for versioning of codebase during development cycle.
  • Monitored performance of applications after deployment in a production environment.
  • Resolved issues reported by users in a timely manner while adhering to SLAs.
  • Participated in regular meetings with stakeholders to discuss project progress.
  • Reviewed code written by peers for quality assurance before releasing it into production.
  • Participated in team-oriented environments, working cohesively and successfully on multiple projects.
  • Drafted design objectives and system design documents.
  • Leveraged multiple programming languages to develop applications for various platforms.

Education

Bachelor of Science - Information Science

Eastern Washington University

Bachelor of Art - English

Whitworth College

Skills

  • MS SharePoint
  • RDI
  • G-Suite
  • Eclipse SDK
  • GitHub
  • Aldon
  • MDCMS
  • Webservices
  • SQL
  • Embedded SQL
  • EDI
  • RPG
  • RPG free
  • ILE concepts
  • JSON
  • XML RESTful API’s
  • JavaScript
  • Python
  • DB2 for I
  • Oracle
  • PostgreSQL
  • Goanywhere
  • ISeries (AS/400)
  • AIX
  • Windows
  • SAP
  • Trimble/ICC Transportation software
  • Jira

Career Experience

  • One Main Financial, 11/23/2023, 01/24/2024, Researched and documented how to implement Rest Webservice calls to the iSeries. This included integrating MuleSoft, the MDCSM Rest4i platform, and the existing COBOL code base.
  • Knight Transportation, 02/23/2023, 08/23/2023, Worked on modifying the order numbering approach from numeric to alphanumeric to expand the capacity of the existing database field without requiring file reformats. Migrated existing FTP application to SFTP from Alliance to Goanywhere platform.
  • Dream City Schools, 08/22/2022, 02/23/2023, 6th grade Math teacher and tutor. Developed curriculum and taught 6th grade level math. Tutored Elementary to Junior high-level math.
  • Knight Transportation, 03/21/2021, 08/22/2022, Worked with NavTrac on fixing problems with an existing interface that was causing the application to halt resulting in operation downtime. Worked with DB2 for i. Used Screen Design Aid in program maintenance and screen creation. I worked with the Trimble/ICC trucking software. I applied my knowledge of IBM service program to fix signature violations on vendor code running in QA. Implemented service programs in multiple applications allowing modular design and re-usable code.
  • Costco Wholesale, Issaquah, Washington, 05/98/1998, 10/19/2019, Progressed through series of information systems and software development roles over 20+ years to support 250K employees and $150B in revenue.

Training

  • RPG Embedded SQL Courses
  • SAP Process Integrator Course, SAP
  • IBM MQ Administration, Admins
  • IBM MQ Broker, Messaging protocols. Point to Point and pub/sub.
  • Java Programming (80 Hours), Costco (third-party trainers)
  • Management Training for Leading Teams, Costco

References

References available upon request.

Timeline

One Main Financial

11.2023 - 01.2024

Knight Transportation

02.2023 - 08.2023

Dream City Schools

08.2022 - 02.2023

Knight Transportation

03.2021 - 08.2022

Programmer Analyst

Costco Wholesale Corp
05.1998 - 10.2019

Bachelor of Science - Information Science

Eastern Washington University

Bachelor of Art - English

Whitworth College

Similar Profiles

CREATE PROFILE
Scott Simpson