Steven Locke Email & Phone Number

Allegany, Ny, Us

Allegany, Ny, Us

Buffalo, New York, Us

As a staff software engineer I am responsible for steering the direction of our data infrastructure and our data pipelines both within my team and across the organization.* Build and maintain internal airflow libraries to auto-instrument monitoring and to simplify usage of the KubernetesPodOperator* Develop internal tooling to support local airflow development in a production-like environment* Evaluated and vetted distributed database technologies to replace our 300+ RDS databases with a highly available, multi-region database platform* Modified existing helm charts to add features for local development inside of KinD* Triaged and resolved production database related SEVs* Work with the infrastructure team to build our multi-cloud airflow platform* Maintain and enhance our event driven apis backed by Kafka* Improved the reliability of our apis by setting up the framework and tooling for my team to integration test our products* Improved the reliability and performance our our CI/CD pipelines

Burlingame, California, Us

As a senior engineer on the Data Engineering team I used my experience of building stable, efficient, and maintainable pipelines to bring stability, monitoring, and maintainability to a system prone to consistent failures and incidents.* Implemented and maintained database replication* Led the effort in containerizing the codebase to support running in kubernetes* Converted collection of cron jobs and celery jobs to airflow tasks by containerizing using the KubernetesPodOperator* Incrementally made improvements to a constantly failing and unsustainable etl pipeline developing a very stable system* Converted etl jobs written in Django models into a standard ELT pipeline built on BigQuery

New York, New York, Us

As a technical lead on the devops team I rolled out improvements to our systems with an increased responsibility on training and mentorship of other engineers* Led core initiatives to automate system integrations and reduce engineering toil* Worked across engineering and non-engineering teams to compile requirements for large system transitions* Utilized AWS and Kubernetes skills to continually increase security and stability across systems* Mentored other engineers on design principles as well as troubleshooting* Automated our database RBAC with our identify management software using terraform and python

New York, New York, Us

As a software engineer on the devops team I was tasked with investigating better ways to process our data, setting up maintainable RBAC systems for our growing number of databases and users, and maintaining/improving our existing ETL process as well as setting standards.* Led many complex projects often simultaneously* Investigated and implemented improved data pipelining techniques to utilize big data solutions* Migrated 12Tb EC2 postgres database to RDS under a very tight deadline without complications* Migrated our EDW (Enterprise Data Warehouse) over to snowflake by shipping parquet extracts of our large RDS database to s3 and importing into snowflake daily* Docker-ized our terraform repo and schedule automated terraform operations inside airflow in Kubernetes

New York, New York, Us

Responsible for ETL of data, building data products, and balancing the need for quick iterations with data integrity and scalability.* Worked daily with tables with hundreds of millions of rows to billions of rows* Processed massively complex medical data from CMS (government) and private sector companies* Converted massive SAS programs into SQL with data validation* Designed and implemented a data warehouse and custom etl framework* Ported existing airflow infrastructure into our brand new Kubernetes environment* Created developer tooling for managing developer's personal airflow instances

Buffalo, New York, Us

This is an architect++ role that allows me a wealth of exposure to every aspect of the system and allots me some freedom to create proof of concepts to improve our system and move the technology forward.Provide maintainable solutions to major system deficienciesProvide guidance on working within our currently transitioning architectureIdentify and develop solutions to system bottlenecks and performance problemsPersonally audit all migration scriptsAll schema changes must be approved by meDatabase tuningMaintain database replication and currently integrating into the development life cycleDevelop tooling used by the entire development teamPersonally responsible and accountable for 11 production environments including database, redis, and IIS serversTroubleshoot production "fires"Provide support to feature delivery teams in whatever form necessary

Buffalo, New York, Us

Built consumer facing Ajax-driven components and pages utilizing MVC 4 frameworkUtilized SSIS to cleanse application data and store in a Data Warehouse used for reportingDesigned complex SQL queries to meet customer’s reporting needs. Data accuracy was crucialContinually drove to improve data accuracy and the reporting infrastructureConfigured and maintained reporting databasesBuilt templating system allowing customers to save customizations to report outputsOptimized existing code base improving performance in some cases by 90%+

Designed and developed Ajax-driven report management tool which utilizes JavaScript name- spacing and prototyping to create a maintainable object-oriented JavaScript applicationPlayed a major role engineering the back-end for the new reporting system under an extreme deadline. This required working closely with other developers to ensure that we as a team produced a sane, maintainable framework and minimized cutting corners.Optimized existing reporting queries as well as troubleshot query bugsMaintained and enhanced the reporting engine that generates and queues the reporting queriesDrove continual improvement to the framework by re-factoring legacy code

Us

Worked on a team of two developers maintaining and enhancing features on a small e-commerce applicationCreated and modified a number of admin utilities used by the sales team to maintain the e-commerce siteMade major over-hauls to the checkout code base which frequently miscalculated discounts, coupons, and taxes under certain circumstancesSignificantly reduced page load times by consolidating a number of queries that were performed in a loop into single efficient queriesImplemented Mantis ticketing systemIntroduced and implemented Git version controlCreated ajax driven search components

Buffalo, New York, Us

As a quality engineer I actively worked with developers to ensure the client received quality software. Designing detailed test cases and test plans was a crucial job responsibility that drove automated regression testing as well as manual testing.• Developed and enhanced internal tools utilizing PHP/Jquery/Javascript/MySql• Investigated and isolated design problems utilizing strong analytical skills• Utilized GIT version control software to track changes to the code base during development and testing• Created detailed training documentation• Worked closely with the engineering team to continually improve procedures

Working closely with the network administrator I maintained a network of five servers, 130 desktop computers and laptop computers dispersed across ten facilities in an Active Directory Microsoft network. My job duties included hardware and software troubleshooting as well as upgrades, network troubleshooting, and user education.• Designed web pages utilizing asp, php, html, and css skills learned on the job• Developed vbscripts and batch scripts to automate active directory changes to networked computers and perform bulk maintenance.• Developed efficient methods of imaging/re-imaging computers utilizing batch scripting and cloning software.• Saved company over $8,500 of man hours and software licensing costs by researching and implementing open-source alternatives to streamline IT operations.• Developed and implemented debian based thin clients utilizing recycled agency computers marked for disposal.• Worked closely with the network administrator to upgrade the network from a Novel network to a Microsoft network.• Prepared and taught agency wide training sessions on Microsoft Office 2007

Performed maintenance and troubleshooting on desktop and laptop computers at a campus with over 5,000 students and over 1,000 employeesResolved network issues such as mapped network drives, connectivity issues, speed issues, and network printersInstalled software, maintained hardware, transferred files, and re-imaged computers

Provided technical support concerning high-speed internetProvided support for billing inquiriesWalked users through installation of equipment, restarting modems, setting TCP/IP settings, and addressed billing concerns