AdminIT Integration Platform
A mission-critical middleware platform bridging UC Davis's core enterprise systems with modern SaaS applications, processing millions of rows of financial data daily.
Tech Stack
Project Overview
During 2024–2025, I worked as a Student Developer on UC Davis's AdminIT team, building and maintaining a middleware integration platform that serves as the connective tissue between the university's legacy enterprise systems — Oracle Cloud/Aggie Enterprise, PeopleSoft/UCPath, and Tririga — and the modern SaaS tools relied on by departments across campus. The platform underpins critical university financial operations and data workflows at scale.
The Challenge
UC Davis's core enterprise systems expose data through legacy SOAP/XML interfaces incompatible with modern SaaS applications. Financial data from systems like Aggie Enterprise needed to be extracted, transformed, and made available reliably — with zero tolerance for downtime across university operations.
The Solution
Built a TypeScript REST API layer to abstract legacy SOAP/XML data into clean JSON interfaces, deployed containerized microservices via Docker and AWS for resilient infrastructure, and engineered automated ETL pipelines to feed the Finance Datamart with General Ledger data processed daily.
The Outcome
Achieved 99.9% uptime for university financial operations, with ETL workflows processing millions of rows of General Ledger data daily. A Docsify-powered documentation hub streamlined onboarding for internal IT teams and reduced ramp-up time for new integrations.
Development Process
Integration Architecture & Design
Mapped data flows across Oracle Cloud/Aggie Enterprise, PeopleSoft/UCPath, and Tririga to identify integration points and bottlenecks. Designed a modular middleware architecture to decouple legacy system dependencies from downstream SaaS consumers, enabling each integration to evolve independently.
API Layer & ETL Pipeline Development
Engineered a TypeScript REST API layer to translate legacy SOAP/XML responses into structured JSON, making enterprise data accessible to modern tooling without modifying upstream systems. Built automated ETL workflows for the Finance Datamart to ingest, transform, and load millions of General Ledger rows on a daily schedule, with validation and error handling to ensure data integrity.
Infrastructure, CI/CD & Documentation
Containerized services using Docker and deployed to AWS, with GitHub Actions CI/CD pipelines for automated testing and deployment. Designed a Docsify-based documentation hub covering API references, integration guides, and runbooks — making the platform maintainable and accessible for the broader internal IT team.
Key Features
REST API Abstraction Layer
TypeScript-based API layer translating legacy SOAP/XML responses from Oracle Cloud, UCPath, and Tririga into clean, versioned JSON endpoints consumable by any modern SaaS application.
Containerised Microservices
Docker-containerized services deployed on AWS with independent scaling per integration, delivering 99.9% uptime across the university's financial operations infrastructure.
Finance Datamart ETL Pipelines
Automated ETL workflows processing millions of rows of General Ledger data daily from Aggie Enterprise into the Finance Datamart, with built-in validation to maintain data integrity at scale.
Docs-as-Code Hub
A dynamic Docsify documentation site covering API references, integration runbooks, and onboarding guides — version-controlled alongside the codebase and kept in sync with every deployment.
Interested in working together?
Feel free to reach out — I'm always open to discussing new projects and opportunities.