Full-Stack Development (Angular, Typescript, Flask, Python, Snowflake) for mobility network modeling tool

•Designed and built monthly ETL process in Databricks using pandas and timezonefinder for network record mapping table, decreased runtime by 10% using indexing and row compression•Developed Snowflake SQL queries to clean and aggregate 25TB of network records per month for marketing and network planning reports, decreased runtime by 15% using UDF caching•Created Python tool to automate generation of PNGs of custom Leaflet (HTML) map markings and increase efficiency of creating risk planning presentations•Co-developed binary classifier ML pipeline in Databricks in team of 3 for hackathon using PySpark, H2O AutoML, and scikit-learn, achieved F1 score within top 20% of teams via feature combination•Implemented Grafana dashboards with Snowflake SQL queries to automate network record quality monitoring, configured auto-alerts to email data stewards to inspect issues within 1 day of error detection

Traveled to Western Europe, used multiple languages to varying success (most successful in Spain), moved to Chicago before start at AT&T in July 2022

• Tested and wrote a PCMD analysis script in Python to yield data drop rates and QoS Class Identifier counts by device model, processing raw data at a rate of 20MB/s with parallel computation.• Tested and wrote CTR data analysis scripts in Python to output daily 5G throughput, latency, and call drop metrics, processing up to 600MB of raw data in 30 minutes.• Designed and developed backend of a web-based streaming service personalization system prototype using Flask and MongoDB as part of a 5-person Agile team.• Provided decision-making insights to engineers for 5G network improvements and maintenance, potentially increasing wireless customer satisfaction and improving the rollout of standalone 5G.

•Co-developed Python interface using Tkinter framework in Agile team of 5 for internal framework to simplify satellite data processing for Sandia developers•Implemented GUI features to guide usage and validate inputs, debugged critical graphical and data-loading issues throughout development process•Created batch processing MATLAB script to calculate output velocity and position vectors from satellite dataset by wrapping around standard orbit determination code, decreased validation runtime for internal project

• Automated collection of temperature and pressure log files from PCB pressmachine via scheduled FTP/SCP script runs onto local computer.• Configured Graylog server to collect PCB press machine data, parsed data intoreadable fields through custom Grok pattern.• Configured VPN connection through firewall device, allowing remote userssecure access to company network using 2FA (two factor authentication).• Set up and configured firewall device to replace existing equipment, implementedfirewall rules for content/software filtering to improve network security.• Coordinated installation of ethernet network adapters for industrial drillingcontrol systems, improving upon program upload speeds from previously installed short-haul modems.• Created 10+ group policy objects containing 300+ settings in total to meetcomputer and network security standards of the NIST Government Configuration Baseline.