Scott Letkeman
Data Engineering Consultant at First Republic Bank- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
First Republic Bank
-
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
-
-
-
Cox Communications
-
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
-
-
-
WarnerMedia
-
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
-
-
-
Turner (Turner Broadcasting System, Inc)
-
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
-
-
-
Boeing
-
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
-
-
-
Georgia Tech Research Institute
-
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 -
Southern Polytechnic State University
Master of Science (MS), Computer Science -
Tulane University
Bachelor of Arts (B.A.), Political Science and Government