Aldo Dagio-Ortega

Aldo Dagio-Ortega

I am a Software Engineer with over three years of experience in the industry, serving as an intern from 2022-2024 and in the public sector since 2024. In my current role as an Information Systems Analyst II for San Joaquin County, as a programmer, I design many front-end solutions using a combination of HTML, CSS, and JavaScript. In unison with my front-end development, I also implement server-side programming using ColdFusion and ASP.NET frameworks to create functional and maintainable code. In this role I have been entrusted with important tasks that directly serve the interests of an entire county.

Outside of work, I am new father of a baby girl who was born December 2025. My hobbies include working on my machine learning skills, including my fantasy football project and kaggle competitions. I love spending time with my lovely girlfriend and daughter, watching movies and lounging around. I also love spending time with friends and my three brothers, usually watching sporting events like basketball, football, baseball, or boxing. I also love to workout by lifting weights, running, or playing sports. Finally, I can't forget about my dog Apollo, who is a three-year old Great Dane.

Education

2018 - 2019
Golden West College
2019 - 2021
Associate of Science in Computer Science, De Anza College
2021 - 2023
Bachelor of Science in Computer Science, California State University, Long Beach

Military Service

United States Army - Utilities Equipment Repairer
2014 - 2018

  • Troubleshot, repaired, and maintained approximately fifteen refrigeration units assigned to the Battalion to store food, drinks, and medicine on Battalion level missions or deployments.
  • Led a four-soldier team as the lead technician at the Joint Readiness Training Center and overseas during Operation Atlantic Resolve which resulted in two Army Achievement Medals for each event.

Professional Experience

San Joaquin County — Information Systems Analyst II (Software Engineer)

January 2024 – Present

  • Replaced 50+ legacy ColdFusion reports that depended on a deprecated report builder by re‑implementing them using ColdFusion logic, HTML, and CSS, restoring long‑term maintainability.
  • Designed and maintained an in‑house data warehouse (56 SQL tables) powering 30 CalSAWS reports delivered on daily, weekly, and monthly schedules.
  • Developed complex T‑SQL stored procedures, jobs, and data import pipelines, including translation of queries from PL/SQL to T‑SQL.
  • Migrated SQL databases to new schemas by writing scripts to copy views, tables, and procedures and updating all dependent application code.
  • Built and scheduled enterprise reports using SAP Crystal Reports 2020 and ChristianSteven Software (CRD).
  • Began migration of reporting solutions from Business Objects to Tableau in coordination with CWS‑CARES initiatives.
  • Contributed to development of the agency’s future public website using DNN, implementing updates based on cross‑department management feedback.
  • Maintained multiple public‑facing websites (SJCHSA.org, sjcfoodforyou.org, sanjoaquincoc.org) using DNN and WordPress, applying HTML, CSS, and JavaScript updates.
  • Developed and maintained internal and external web applications using ColdFusion, ASP.NET, SQL, HTML, CSS, and JavaScript.
  • Created extensive technical documentation in SharePoint, producing dozens of knowledge articles to support training and knowledge transfer across the agency.

Freightgate, Inc. — Software Developer Intern

May 2022 – January 2024

  • Participated in daily scrum operations including a daily stand-up meeting where all engineers discuss on-going projects with the team.
  • Solved a variety of projects in different Computer Science domains such as hardware, network, database, front-end, and back-end design, and programming.
  • Configured hardware such as servers and network switches which were booted from a Linux distribution and placed inside the company’s local area network.
  • Contributed to the migration of servers from one datacenter cage to another while delivering the minimum downtime for each server and not losing any data in the move.
  • Led a keep-alive situation for Freightgate’s in-house datacenter where a customer’s servers were kept-alive during a power outage using effective planning and execution.
  • Generated complex SQL (Structured Query Language) queries to demonstrate and employ platform solutions for customers.
  • Developed custom Alexa Skills using Node.js to create voice services to deliver customer needs, such as estimating a container’s arrival date at a port.
  • Restored a Java application back into production by configuring the way it serves requests and updating the REST (REpresentational State Transfer) controller.
  • Maintained a JavaScript front-end project which included Node.js, and GitHub opensource libraries such as bpmn.io (Business Process Model and Notation Input/Output).
  • Developed complex business processes using the bpmn.io modeler to automate and illustrate Freightgate’s rate engine process to improve the customer’s ability to find rates while shipping.
  • Maintained a full-stack web application and improved performance by reconfiguring how requests are sent to the server by updating the hibernate configuration.
  • Automated the filing process of customer export shipment declarations by mapping data of JSON (JavaScript Object Notation) format to EDI (Electronic Data Interchange) format and sending that data to Customs and Border Patrol.

Projects

Fantasy Football Machine Learning Prediction System

  • Designed and implemented a Python‑based machine learning pipeline to predict top fantasy football players using historical data from 2010–present.
  • Scraped and ingested web data into a PostgreSQL relational database, designed with a custom UML schema.
  • Developed a lightweight web interface using Flask and Bootstrap.
  • Applied predictions in competitive fantasy leagues, achieving first and second-place finishes in consecutive seasons.

Kaggle — NFL Big Data Bowl 2026

  • Solo competitor in an NFL-hosted machine learning competition focused on football analytics.
  • Performed data exploration and feature engineering on large-scale sports datasets.

GymHomie — Android Application (Senior Project)

  • Led development of a Java‑based Android fitness application using Firebase (NoSQL).
  • Implemented step tracking, workout sharing, calorie calculation via Nutritionix API, gym finder based on user location using Google Maps API, and goal tracking features.

Technical Skills

  • Languages: Python, Java, JavaScript, C#, C++, C, SQL, HTML, CSS, Kotlin, Perl, x86 Assembly, XML
  • Frameworks & Tools: Flask, ColdFusion, ASP.NET, Git, Docker, Linux, ExtJS
  • Databases: PostgreSQL, SQL Server, MySQL, MongoDB, Firebase
  • Cloud & Analytics: AWS, SAP Business Intelligence (Crystal Reports), Tableau, DNN, WordPress, Git, Docker

Contact

You can find my work and get in touch with me using the links below: