Adonis Villanueva

Enhanced the Health Insurance Casework System (HICS) security posture by mitigating SQL injection and XSS vulnerabilities, and modernized legacy systems to cloud-based architectures. Reduced operational costs by 30% by building Azure Data Factory pipelines integrating Dynamics CRM, Snowflake, and analytics engines.

Migrated HICS to Azure across 15 apps and 8 SQL Server databases, moving 50TB of data with zero downtime during Medicare enrollment periods. Led CMS healthcare modernization, including .NET 4.5–4.8 to .NET 6/8 migration and event-driven re-architecture that reduced latency from hours to seconds and improved reliability to 95%.

Contributed to requirements, system architecture, and design reviews, and optimized performance and resource utilization through new cloud technologies. Built Azure Data Factory pipelines and improved SQL query performance while maintaining legacy .NET web applications and CI/CD workflows.

Developed and deployed Azure data pipelines and built Azure Service Fabric clusters, improving pipeline performance through targeted optimizations. Managed Azure Key Vault/secrets and certificates, supported stakeholder activities across the SDLC, and completed thorough code reviews for quality and reliability.

Integrated ProLaw case management with M-Files document management by building a Windows service for database change detection and implementing REST-based integration. Improved application performance by optimizing SQL queries and provided strategic guidance to project managers and customers.

Supported development of Health-e-App to automate Medicaid and CHIP enrollment and contributed to One-e-App for unified applications across programs. Streamlined intake by building a single electronic application that collects, stores, screens, and delivers data electronically.

Designed and implemented a star-schema data warehouse consolidating 10+ legacy sources and migrated 15+ years of historical data with SSIS while validating data quality and integrity. Migrated Classic ASP applications to ASP.NET MVC 4 to improve maintainability and security posture.

Developed web applications and database systems to modernize legacy court platforms, including migrating 8 Classic ASP applications to ColdFusion. Consolidated 5 SQL Server databases into a unified schema and improved data integrity by replacing legacy authentication with Windows Authentication and Active Directory integration.

Maintained and enhanced a SharePoint Enterprise Portal following migration from SharePoint 2007 to SharePoint 2010. Ensured zero data loss during migration for 200+ users and refactored custom .NET Framework solutions for SharePoint 2010 compatibility.

Led CMS implementation and content migration for the California State Capitol Museum website, migrating 1,000+ artifacts and documents to the Ektron CMS platform. Migrated legacy MS Access databases to SQL Server 2005 and built custom migration tools to preserve data integrity and metadata.

Developed BI solutions and web applications supporting DOJ systems, integrating ProLaw case management and building custom ETL processes for data migration from legacy systems. Re-engineered 50+ Crystal Reports to the Cognos BI platform to improve performance and maintainability.

Led migration of mission-critical MS Access applications to a SQL Server backend, improving reliability and scalability for 150+ field biologists and wildlife officers. Built automated T-SQL procedures to migrate data from disparate legacy systems into centralized SQL Server databases.

Developed database solutions for Proposition 40 infrastructure with a focus on consolidating departmental data into centralized tracking databases. Built integration procedures and ETL-style workflows to move and standardize data from multiple legacy systems.

Supported early state service database and web development for environmental regulatory systems. Helped migrate legacy desktop applications to web-based client/server architecture and supported backend integration using SQL and Oracle technologies.

Developed custom applications in a multi-user MS Access 97 environment, including troubleshooting performance issues and compilation errors. Researched and supported initial steps toward implementing an online GIS, using MS Access VBA and enhancing Excel tools for departmental use.

Earned a bachelor's degree in Management Information Systems (MIS) at California State University, Sacramento from 1999 to 2003.