Ryan Deterding Email & Phone Number

Chicago, Illinois, United States

Greater St. Louis Area

Built the foundation for the transition from HP Asset Manager to ServiceNowCreate and maintain data pulls from over 200 sources to consolidate into a single IT Data Warehouse for use of reporting in Cognos, Tableau, ApptioPerforms the design, program, test, implementation and documentation for changes to HP Asset Manager Software to meet the needs of Boeing. Design new architecture to overcome limitations of HP software. Write and compile PL/SQL code based on documented designs application architecture that integrates application software.Modifies and upgrades complex code to maintain and improve existing functionality.Identifies and resolves complex programming or HP Asset Manager Application architecture problems.Production support for HP Asset Manager, HP Service Manager, and Data Warehouse.Develop Broker Hub in Data Warehouse to successfully integrate data between multiple HP applications.

St. Louis, Mo

Analyzed and test new functionality for the MicroStrategy Full-Service Reporting team at the United States Postal ServiceWorked on an agile team that utilizes Version One to track stories, tasks, and impediments during two week sprintTake part in sprint planning, sizing, and demonstrations of current sprint updates to Product Owners and Business Analysts, and retrospectives to improve team processesInvolved with Sprint retrospectives to help improve the sprint processesAssist with ETL development in PL/SQL that includes updating stored procedures, packages, and functions to handle extracting new information required for reporting servicesAssisted with miscellaneous testing, browser upgrades, disaster recovery, to ensure that a separate production environment was available and front end reports were still accessible to clients in the event of downtimePrepared a bi-monthly report for business owners of reporting performance metrics to gauge how quickly reports are querying, errors received, and number of users to make business decisions on how to improve reporting performance by performance tuning queries, adding indexes, reducing the number of joins to a table

Kansas City, Mo

Utilized Remedy BMC software to support and track issues clients and associates working with Olympus application encounteredProvided required access to users based off of role level and client associationEnsured Altiris Server Management was installed on all Windows/Unix Servers to avoid service interruptions to clientsEnsured that the Olympus solution was installed, maintained, and updated on client servers when new functionality was added to the application

Bs, Management Information Systems

Associate, Arts

Master’S Degree, Computer Science