Scott Letkeman

Data Engineering Consultant at First Republic Bank
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Atlanta Metropolitan Area

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • United States
    • Banking
    • 700 & Above Employee
    • Data Engineering Consultant
      • Apr 2021 - Present

      Developed an ETL framework as part of a larger effort to modernize the bank's analytics platform • Connected with internal customers to understand requirements and then recommended solutions • Developed Data Sherpa, an ETL framework based on Python and Snowflake SQL. The framework is configurable using JSON and is capable of ingesting data to Snowflake from CSV file, MS SQL Server, Oracle, and MongoDB • Resolved how to run instances of Data Sherpa in OCP (OpenShift Container Platform) on a scheduled basis by utilizing Devkit, a proprietary DevOps tool • Deployed more than 50 ETL jobs based on Data Sherpa and supported them in production • Continued to engage with customers throughout to gather feedback and ensure requirements were being met Show less

    • United States
    • Telecommunications
    • 700 & Above Employee
    • Senior Software Engineer
      • Feb 2021 - 2022

      Supported the Cox Business Internet network by developing automations and utilities• Automated updating router configurations across the Cox Business network. Built an inventory of 40k devices and pushed out updates on a quarterly basis using Ansible playbooks • Maintained and enhanced NEON, a web application based on PHP and MySQL for managing network device configurations. Added new features and helped network engineers contribute • Led development of a new web application based on Vue.js, FastAPI and Postgres for managing network service configurations. Mastered Cox Cloud deployments • Migrated legacy applications running on Red Hat VMs to Cox Cloud. Employed Docker for containerization and ArgoCD and Kubernetes for deployment Show less

    • United States
    • Entertainment Providers
    • 700 & Above Employee
    • Senior Software Engineer
      • Jun 2018 - Nov 2020

      Supported data analytics applications for advertisement placement and programming optimization • Built and maintained web applications with React or Vue.js frontends and Node or FastAPI backends • Deployed web applications to AWS (ECS, Fargate, and ECR) using Docker and Terraform • Debugged, Dockerized and deployed R scripts to AWS Batch to facilitate running on demand • Troubleshot web applications running in AWS by considering all possible failure points: roles and permission (IAM), networking (EC2, VPC), routing (Route 53, Certificate Manager), and container stability (CloudWatch, health checks, etc.) • Maintained Terraform templates so AWS configurations could be tracked in source control • Integrated OAuth 2.0 authentication into several web applications Show less

    • United States
    • Broadcast Media Production and Distribution
    • 700 & Above Employee
    • Full-Stack Web Developer
      • Apr 2014 - Jun 2018

      Developed several web applications, most notably "Brand Central" Turner's still image catalog • Embraced Agile Scrum methodology to gather requirements, write user stories, develop code, and verify outcomes met requirements • Created beautiful and functional user interfaces with React and Angular • Built functional and secure REST API's using the Node Express and Hapi • Integrated the REST APIs with document databases including MongoDB and RethinkDB Developed several web applications, most notably "Brand Central" Turner's still image catalog • Embraced Agile Scrum methodology to gather requirements, write user stories, develop code, and verify outcomes met requirements • Created beautiful and functional user interfaces with React and Angular • Built functional and secure REST API's using the Node Express and Hapi • Integrated the REST APIs with document databases including MongoDB and RethinkDB

    • United States
    • Aviation & Aerospace
    • 700 & Above Employee
    • Embedded Software Engineer
      • Aug 2010 - Apr 2014

      Developing code for the F/A-18 Super Hornet mission computer • Engaged flight crews in discussion to gather requirements and get feedback on new design ideas • Practiced test-driven development by first writing detailed test plans • Coded new features in C++ and debugged with Microsoft Visual Studio • Tested throughput in a lab environment to ensure software ran within hardware's physical limitations Developing code for the F/A-18 Super Hornet mission computer • Engaged flight crews in discussion to gather requirements and get feedback on new design ideas • Practiced test-driven development by first writing detailed test plans • Coded new features in C++ and debugged with Microsoft Visual Studio • Tested throughput in a lab environment to ensure software ran within hardware's physical limitations

    • United States
    • Research Services
    • 700 & Above Employee
    • Software Engineer
      • Jan 2009 - Aug 2010

      AAR-47 Missile Warning System • Writing and testing Python scripts as part of a project to automate the testing of the missile warning system • Writing a graphic user interface in C# for a new data recorder card being designed to work within the missile warning system AAR-47 Missile Warning System • Writing and testing Python scripts as part of a project to automate the testing of the missile warning system • Writing a graphic user interface in C# for a new data recorder card being designed to work within the missile warning system

Education

  • Georgia Institute of Technology
    Master of Science - MS, Data Analytics
    2018 - 2021
  • Southern Polytechnic State University
    Master of Science (MS), Computer Science
    2008 - 2010
  • Tulane University
    Bachelor of Arts (B.A.), Political Science and Government
    2003 - 2007

Community

You need to have a working account to view this content. Click here to join now