Benjamin Johnson Email & Phone Number

Phoenix, Az, Us

- Implemented and supported software releases for the SURF-A functionality on the processing portion of the Traffic Collision Avoidance System (T3CAS) hardware to add additional functionality to support vendor requirements.- Implemented updates to existing C code, and confirmed proper code updates using lab test hardware- Documented requirement additions and changes using IBM Doors software to allow for added traceability of change requests to the connected requirements

Detroit, Michigan, Us

- Provided enhancements and feature information to loyalty ETL solutions by engaging business and management to create clear concise requirements for use in development of expandable processes.- Implemented and supported complex ETL solutions, most of which involved handling over 2 million members and their related transactions, to provide extracts to third party vendors, and supply the business team with reports on various statuses on the Rewards and GM Card programs- Verified ETL solutions through creation of test data, ensuring we have at least 90% test coverage to allow our data implementations to remain stable and work as designed and envisioned.- Provided operational support on all active GM Rewards ETL solutions, by assisting with solution adjustments, SQL optimizations, and knowledge transfers in order to support 100% uptime of all batch integration flows.- Led a team of new ETL developers by performing trainings, creating documentation and one-on-one help while continuing to support Loyalty ETL efforts- Assisted effort involving Java API development on a team outside Loyalty CRM, requiring fast ramp-up and learning several new processes and tools in order to assist with fast approaching deadlines and release.

San Antonio, Texas, Us

- Developed and supported an archival process using Python and ETL to archive over 10+ years worth of files contained on a shared drive, to adhere to legal and business requirements regarding file security and retention.- Implemented and supported ETL solutions related to External Reporting to support 100% uptime of solutions relating to weekly, monthly and yearly financial reports and delivery of these reports to the intended recipients on time.- Communicated and coordinated with the business team throughout development efforts from design to delivery to ensure clear requirements and acceptance criteria to deliver proper solutions and meet business needs.

Glen Allen, Va, Us

Contracted with USAA in a Contract-To-Hire status for the entire working period:- Converted existing prototype script of an archival process for business reports from KSH to Python, and developed it to a completed state to be used in a basic status for business files and reports to be archived before the end of their retention date.- Assisted with IBM DataStage implementations and issues related to reporting errors and troubleshooted and supported the team with optimizing and correcting those issues.

Detroit, Michigan, Us

- Supported and was on the initial team involving the inception and creation of the GM Rewards program. Was a part of the team creating and supporting all the initial ETL batch flows using DataStage and Oracle SQL used to generate timely reports, award members points, and send data files to 3rd party vendors.- Also supported and was on the initial team related to an additional Sales Dealer Incentive and Volume Bonus program, created to incentivize dealers to and dealer employees to sell more vehicles.- Gained initial experience in Shell/KSH scripting to support business processes related to file and data retention, routing files to 3rd party vendors, and archiving files where needed,- Gained initial experience working with external teams outside of America with teams in Europe to determine the best approach to receiving data securely for those brands owned by GM at the time in our systems.

Phoenix, Az, Us

- Designed and delivered the initial version of an updated user interface for a 10+ year legacy codebase used for extensive testing of collision detection systems used in the aerospace industry.- Created, tested and delivered the initial version of the VALFAC 2.0 GUI using the MFC Ribbon in Visual Studio, which has since been completed and in use today, and is fully integrated with its original code.- Gained first hand industry experience in aviation software development including daily stand-up meetings, working and testing with physical lab software, and analyzing and adjusting legacy code.

Scottsdale, Arizona, Us

- Assisted customers with timely and friendly service related to and including box office, concessions and ushering the theaters,- Assisted and performed team leader duties when needed in covering shifts to lead a team of ushers, concessions or box office to success for those shifts- Verified and performed proper money handling during lax and busy hours to ensure the register stays balanced throughout the shift