John Steiner 585-***-****

Bound Brook, NJ adzb8s@r.postjobfree.com

****-**-** **** *

Use or disclosure of data contained on this sheet is subject to the Confidentiality and Non-Solicitation provisions of the Agreement between our companies

JOHN STEINER, M.ENG DATA ANALYST

Professional Summary

An ambitious data analyst with a record for providing reliable data validation, data governance, data processing, project management, and program delivery. An innovator who excels in the challenge of accurate solutions for difficult situations in system designs/architecture, data visualization, and automation while leveraging Python scripts, MS Excel functionality, and machine learning algorithms for production. A well-rounded and reliable leader with outstanding interpersonal and communication skills, driven to develop through hands-on design and implementation experience within a challenging and rewarding environment.

Education

• Master of Mechanical Engineering (M.Eng); Mechanical Engineering-Solid Mechanics; Johns Hopkins University (Baltimore, MD); 12/2021

• Bachelor of Science (B.S.); Mathematics; State University of New York, College at Brockport

(Brockport, NY); 05/2017

Professional Certifications and Training

Certifications

• Microsoft Certified: Azure Fundamentals (2022), Certification number: I139-7302

• AWS Certified: AWS Certified Cloud Practitioner (2022), Certification number: 75RLHK8L3NR4QHWB Training

• IBM’s Data Engineering Professional Training and Certification (Dec 2022) Relevant Technical Expertise

• Python software development

• AI/ML software design and development

• SQL

Professional Experience

Steampunk 01/2022 – Present

Data Engineer

• Lead architect and code developer of extract, transform, and load (ETL) processes for numerous projects using Apache Airflow.

• Reduced a manual 80-hour process into an automated 15-minute ETL pipeline.

• Reduced a manual 40-hour process into an automated 2-minute ETL pipeline.

• Increased the security rating of Apache Airflow by 40% by incorporating and maintaining single sign- on (SSO) with Azure AD.

• Designed an 18 unique source data extraction into a singular pipeline with parallel processing branches.

• Developed clear and concise technical writing materials, including user manuals, API documentation, security documentation, and troubleshooting guides.

• Expert in Python programming, using advanced concepts to design ETL architecture.

• Expert in SQL scripting to perform complex transformations and enhancements to the raw data.

• Created a SSO process using Azure AD and terraform to follow CI/CD best practices and improve security of data orchestration tool.

• Designed a three tier PostgreSQL database schema to retain the raw data and present the dimensional view of the data to the stakeholders.

• Implemented cloud data storage in AWS S3, EBS, and EFS to persist the raw data.

• Implemented data encryption at rest and in transit using AWS KMS and Hashicorp Vault, ensuring data security and compliance with industry standards. John Steiner 585-***-****

Bound Brook, NJ adzb8s@r.postjobfree.com 2022-09-06 Page 2

Use or disclosure of data contained on this sheet is subject to the Confidentiality and Non-Solicitation provisions of the Agreement between our companies

• Designed and implemented disaster recovery and backup plans using AWS services, ensuring business continuity in case of system failures or data loss.

• Decreased processing times for data scientists and analysts by 25% by optimizing data workflows and ensuring data quality.

• Developed and maintained infrastructure as code using tools such as Terraform and Ansible, resulting in increased infrastructure reliability and consistency.

• Architected and implemented an efficient automated pipeline, resulting in a significant one-hour reduction in daily data staging time. This initiative empowered data scientists to seamlessly access files, originally stored on SharePoint, through their dedicated EC2 server. Ideal Innovations Inc. 11/2019 – 01/2022

Data Analyst/Algorithm Development Engineer

• Evaluate system performance specifications, and perform modeling and simulation, data collection, signal processing, and test-data analysis.

• Created a data mapping of seven data sets from test events to create a homogenize data set for ML applications.

• Test and assess system performances throughout all system development phases to ensure specification compliance.

• Implemented real-time algorithms in sensor-weapon computational architecture to increase successful probability by 35%.

• Generated plots and tables, to show a 25% noise reduction in the radar data by applying different numerical methods.

• Generate white papers, final reports, and briefing materials to disseminate analytic assessments and conclusions to management.

• Collaborate with Precision Targeting Branch Chief, Integrated Product Team Leads, and CCDC-AC customers to achieve goals.

• Participate in technical solutions concepts development to address military, DoD, and intelligence community operations issues.

• Support small UAV classification network development in radar, infrared, and data source identification of different UAV threats.

• Provide machine learning AI consultation to build defense tactics to protect against development of small UAV swarm analysis.

• Conduct radar performance evaluation, modeling, and simulation to support APS program as data analyst and algorithm engineer.

• Generate intermediary study and testing progress reports and presentations for engineering team and APS program managers.

ManTech International Inc. 09/2017 – 11/2019

Jr. Software Systems Engineer

• Delivered specialized testing for multiple software products used by NAVAIR with United States Navy to ensure operations

• Created automated testing structure to reduce testing time by 60%.

• Conceptualized and designed scalable MATLAB test programs to validate weapon models and design strategies for Boeing.

• Recommended software PathIV and Symphony program modifications to increase efficiency by 10% and 25% respectively.

• Analyzed six software programs mission planning data to identify and resolve mathematical discrepancies and failures.

• Discovered potentially unsafe mission planning deficiency in aircraft maneuver model for aerospace subject matter experts.

• Participated in mission planning software deliverables reports for stakeholder reviews and product description walkthroughs.

• Team lead for four months in NAVAIR mission planning software analysis for each Symphony, eSLIC, and JSEAS programs.

John Steiner 585-***-****

Bound Brook, NJ adzb8s@r.postjobfree.com 2022-09-06 Page 3

Use or disclosure of data contained on this sheet is subject to the Confidentiality and Non-Solicitation provisions of the Agreement between our companies

• Led test engineering work in ballistic weapon software programs PathIV and CUWCE to ensure output quality control compliance.

• Led test engineering work in aircraft performance software programs ATAMS {Legacy} and JAM and validated program outputs.

Aaron’s 03/2015 – 05/2016

Sales Manager

• Sales team lead for one of the largest Aaron’s franchise stores in the nation

• Managed three to five sales associates along with managing customer payments and retail tills

• Managed store layout and in charge of moving merchandise out of the store

• Responsible for balancing the tills at the end of each shift/day

• Managed customer deliveries and delivery drivers morning and afternoon routes

• Team member in local store promotions and leveraging national promotions for the greatest effect

• Oversaw new business acquisitions through cold calling, direct mailers, and other business strategies

• Left position to finish my bachelor’s degree in one year (full time student from June 2016 to May 2017)

Security Clearance

• Secret Security Clearance – Single Scope Background Investigation

Contact this candidate