Juan David Gomez | Integration & Automation Engineer

Professional Profile

With over 9 years of experience in both software engineering and IT operations, I focus on building resilient, scalable systems that solve real business problems. My approach combines the precision of backend development (C#, Java) with the agility of modern DevOps practices.

Currently pursuing a Master's in Computer Science, I am dedicated to modernizing legacy architectures. I excel at "bridging the gap" between traditional institutional needs and modern technology—architecting modular solutions that integrate disparate platforms while ensuring security, data integrity, and seamless user experiences.

Technical Projects

Enterprise Automation Suite

PowerShell & .NET Core

Designed a massive library of automation modules handling the entire student lifecycle (Admissions to Graduation). Replaces manual data entry with scheduled, error-checked scripts using advanced logic.

PowerShell Active Directory SMTP Automation Task Scheduling Error Handling

CRM Ecosystem

Full-Stack Modular Architecture

A comprehensive CRM solution featuring a TypeScript frontend and a Java backend microservice. Implements role-based access, sales tracking, and complex workflow automation.

Java Spring TypeScript React Docker REST Security

Multi-Tenant Inventory System

SaaS Application

Developed a scalable, multi-tenant web application for appliance inventory tracking. Integrated hardware interfaces for barcode scanning and real-time stock updates across multiple warehouse locations.

Java Spring React SQL Server Barcode Hardware Real-Time Sync

Legacy Migration Engine

ETL & Cloud Modernization

Engineered a robust ETL pipeline to migrate critical business data from legacy Visual FoxPro and DB2 systems to modern cloud-based SQL Server architectures. Reduced query reporting times by 40%.

C# / .NET Visual FoxPro DB2 Azure SQL Data Optimization

Business Process Modules

Workflow Logic

Created interconnected web modules (TMS, ITS, TPS) for ticket management, asset tracking, and task processing. Features a modular JavaScript architecture for maintainability and extensibility.

JavaScript Node.js Reporting API Integration Process Logic

Secure Home Lab

Networking & Security

Engineered a robust remote access environment. Configured network-wide ad blocking via Pi-hole and established secure tunneling for external access to local resources without exposing ports.

Linux WireGuard / Tailscale Pi-hole Network Security Raspberry Pi

Work History

Application Integration & Automation Engineer

The College of Westchester

May 2024 - Present (1 yr 9 mos) • New York City Metropolitan Area • Hybrid

Serving as the primary technical lead for system connectivity, I script complex automation tasks using PowerShell, Power Automate, and AI to orchestrate data between on-premise legacy systems and SaaS platforms.

Windows Server C# PowerShell Apache SaaS Spring Framework JSON API

Deliver Level I and II support for enterprise applications including Anthology Student, Verity IQ, and Microsoft 365.
Lead multiple system integrations, including the deployment of D2L and internal routing portals.
Design and implement automation integrations to manage workflows between D2L and Anthology to improve data consistency.
Build and maintain RESTful APIs to streamline data exchange between Anthology and internal SQL databases.

Software Engineer Developer

Aitoro Appliance | Norwalk, CT

March 2018 - Present

Develop, deploy, and maintain multiple APIs and multi-tenant desktop/web applications.
Review project specifications to design technology solutions that meet or exceed performance expectations.
Coordinate with engineering teams to evaluate and improve software and hardware interfaces.

Full Stack Software Engineer (Freelance)

New York, NY

January 2013 - Present

Design and implement scalable APIs, dashboards, and web applications using Java, PHP, C#, and ASP.NET.
Manage complex data migrations from legacy systems including VisualFox Pro 6 & 9, Db2, and Dbase 3+.
Deploy complex software solutions on both Linux and Windows Server environments.

General Manager & Developer

Skynet Limousine | Port Chester, NY

September 2012 - January 2015

Updated old code bases to modern development standards to improve system functionality.
Designed intuitive graphical user interfaces (GUI) to enhance the user experience.
Drove year-over-year business growth while leading strategic vision and operations.

Technical Skills

Languages & Frameworks

C# / .NET Core Java Spring PHP / Laravel JavaScript / TypeScript PowerShell Power Automate React & Node.js

Integration & Infrastructure

GitHub Actions (CI/CD) Docker & Containers Apache / Nginx RESTful APIs SQL Server (MSSQL) Windows Server Linux Admin

Education

Master of Science in Computer Science (In Progress)
Bachelor of Science in Information Technology - Monroe College, Bronx, NY (2015)
Programming Certificate - Norwalk Community College, CT (2005)