Samuel Spence

Experience

• 

  University of Oklahoma

  Jul 2010 - May 2012

  Information Technology Analyst

  ● Completely rewrote a manual Microsoft Excel reporting process into SAS Enterprise● Interfaced with IBM Mainframe reports in order to export data to Oracle Databases● Created Open Database Connectivity (ODBC) connections to support new Oracle data sources

• 

  University of Colorado

  May 2012 - Mar 2019

  ETL Developer/Data Modeler

  ● Constructed data warehouse to be used for an electronic proposal and grant submission system● Migrated legacy proposal/grant tracking system into relational framework with new management app● Collaborated with reporting end-users to gather requirements prior to implementing new capabilities

• 

  Blue Moon Digital, Inc.

  Mar 2019 - Jan 2022

  ● Self-taught in Ruby on Rails in order to contribute to new marketing campaign tracking application● Acted as senior technical resource supporting existing Revenue Equation app and client-facing work● Engaged in both formal and informal mentorship of fellow developers to create an environment of growth ● Contributed to team being named Domo Partner of the Year in both 2020 and 2021● Operated cross-industry (manufacturing, e-com, food service) and cross-area (P&L, inventory, marketing)● Consumed programmatic JSON endpoints in order to build comprehensive datasets

  • Software Developer

    Jan 2021 - Jan 2022

  • Senior ETL Developer/Data Modeler

    Mar 2019 - Jan 2021
• 

  Nayya

  Feb 2022 - now

  Senior Software Engineer

  ● Learned type checking in Ruby eventually becoming the go-to expert for the organization● Successfully built and supported API integration with ADP’s HR Open standard● Partnered with Customer Success to address ADP issues during Open Enrollment season● Implemented DDD/CQRS within application to isolate database reads and improve query efficiency● Empowered engineering organization through on-time delivery of well-written, maintainable features● Developed framework and wrote data pipelines for medical claims platform on greenfield big data project Show less