Menu

Join MyWorkImpact

Create your portfolio and share your professional achievements

Sign up Sign in

Platform Stats

Total Entries 5
Active Today 0
This Week 0

Trending Skills

React Python AWS Machine Learning TypeScript Docker
EC
Erick Castillo

Lead .Net/Azure Developer

MySQL 5.7 → 8.0 Migration & HA Failover Validation

Hexaware Technologies Lead .Net Developer Oct 2025 - Feb 2026

Challenge:

The FEMA ELA platform's primary data store ran on MySQL 5.7, which was approaching end-of-life and lacked the security, performance, and JSON/CTE features the .NET application increasingly relied on. On a federal platform supporting emergency lodging during disaster events, the database also had to demonstrate verified high-availability failover — a documented, repeatable test, not a hope. Upgrading in place risked breaking EF Core data access, stored procedures, and existing query plans, and a botched failover during an active disaster response would have been a serious incident.

Solution:

Owned the MySQL 5.7 → 8.0 upgrade plan end-to-end and ran the HA failover validation exercise alongside it. Authored the TDD covering compatibility analysis, upgrade path, rollback strategy, and the failover test protocol. Coordinated with Corpay infrastructure, the FEMA stakeholders, and the dev team to schedule the cutover, then executed and signed off on the failover drill against the upgraded cluster.

Impact:

Brought the ELA platform onto a supported MySQL version with stronger security defaults and modern SQL features, eliminating EOL risk on a federal contract. The HA failover drill produced a signed-off, repeatable runbook — meaning the on-call team had verified evidence of failover behavior rather than a theoretical design. EF Core data access continued working without regressions across the full integration test suite, and the Azure Blob backup pipeline gave the platform a clean DR posture going into disaster season.
MySQL 5.7 MySQL 8.0 MySQL Shell ASP.NET Core .NET 9 +7 more
0
0
View full entry → View portfolio
EC
Erick Castillo

Lead .Net/Azure Developer

Financial Reporting Platform & Lease Accounting Automation

LeaseQuery .Net Developer Dec 2018 - Mar 2019

Challenge:

Financial institutions and enterprises needed compliant lease accounting solutions to meet GAAP standards. Manual data processing between systems was time-consuming and error-prone, and the existing application lacked real-time data capabilities and code reusability, hindering development velocity.

Solution:

Developed custom financial reporting solutions using ASP.NET Core with React and Angular frontends for lease accounting automation. Built complex SQL queries and stored procedures for compliance reporting. Integrated third-party APIs for automated data synchronization. Implemented component-based architecture with RESTful APIs and Vue.js for real-time data updates

Impact:

Delivered audit-ready financial compliance reporting supporting GAAP standards. Reduced manual data processing time by 50% through automated third-party API integrations. Improved code reusability and scalability through component-based architecture. Enabled real-time data updates for faster decision-making.
.Net SQL API
0
0
View full entry → View portfolio
EC
Erick Castillo

Lead .Net/Azure Developer

Cloud-Native Retail Platform & Azure Cost Optimization

Meijer .Net Developer May 2021 - Jul 2021

Challenge:

Mission-critical retail operations spanning 200+ stores required high-availability systems capable of processing 100K+ daily transactions. The existing infrastructure had high cloud costs, lacked Infrastructure as Code practices, and suffered from data latency issues across distributed environments. Junior developers needed upskilling on cloud architecture patterns.

Solution:

Developed cloud-native applications using Azure Functions, Service Bus, and Event Grid for reliable message-driven architecture. Integrated CosmosDB for high-throughput, geo-redundant data operations. Implemented CI/CD pipelines with Infrastructure as Code (ARM templates). Executed Azure cost optimization strategies and built reporting solutions with Power BI. Mentored junior developers on cloud best practices.

Impact:

Achieved 25% reduction in Azure infrastructure costs through optimization strategies. Ensured high availability and performance at scale for 200+ retail stores. Enabled low-latency data access across distributed environments with CosmosDB. Reduced manual release overhead through automated deployments and Infrastructure as Code. Accelerated team capability growth through mentorship on cloud architecture.
.Net SQL Azure Cosmos DB Service Bus
0
0
View full entry → View portfolio
EC
Erick Castillo

Lead .Net/Azure Developer

ELA Hotel Image Management Enhancement

Hexaware Technologies Lead .Net Developer Feb 2026 - Feb 2026

Challenge:

Hotel image updates on the portal depend entirely on a manual process that requires support staff to access production servers directly and modify database records by hand. This creates a bottleneck where routine image changes are delayed behind ticket queues, introduces risk of human error during manual data entry, and ties up support resources on tasks that could be handled by administrators themselves.

Solution:

Introduce a built-in image management capability within the existing admin portal that enables authorized users to upload, preview, and save hotel images through a web-based interface. The system handles file storage and database updates automatically, eliminating the need for direct server access or manual database modifications.

Impact:

 Administrators can now manage hotel images independently without submitting support tickets or waiting for manual intervention. The change is self-contained within the admin module, with no modifications to existing business logic, database schema, or the public-facing site. Support teams are freed from routine image update requests, and turnaround time for hotel image changes is reduced from days to minutes.
Php Javascript
0
0
View full entry → View portfolio
EC
Erick Castillo

Lead .Net/Azure Developer

Update Unsupported PHP and MySQL

Hexaware Technologies Lead .Net Developer Oct 2025 - Nov 2025

Challenge:

The current system relies on unsupported and end-of-life technologies, which introduces significant risk and operational limitations:

PHP 7.2 is end-of-life, meaning it no longer receives security updates or bug fixes, exposing the application to known and future vulnerabilities.

MySQL 5.7 is no longer supported, increasing the risk of data integrity issues, performance degradation, and security exploits.

Known vulnerabilities remain unpatched, leaving the system susceptible to cyberattacks, compliance violations, and potential service disruptions.

These issues collectively increase security risk, maintenance costs, and technical debt, while limiting the ability to scale or integrate modern features.

Solution:

Modernize the technology stack by upgrading to supported, secure, and actively maintained versions:

Upgrade PHP to a currently supported LTS version (e.g., PHP 8.1 or 8.2) to ensure ongoing security patches and performance improvements.

Migrate MySQL 5.7 to MySQL 8.0 (or an alternative supported database such as PostgreSQL) to gain enhanced security, improved query performance, and long-term support.

Implement a vulnerability management and patching strategy to ensure all dependencies and system components remain up to date.

This modernization will reduce security risks, improve system performance, and ensure long-term maintainability.

Impact:

After implementation, the organization will achieve:

Significantly reduced security risk through supported software and active patching.

Improved system stability and performance, with faster execution and optimized database operations.

Regained compliance readiness, supporting audits and regulatory requirements.

Lower long-term maintenance costs due to reduced technical debt and easier upgrades.

Future-ready architecture, enabling scalability, new features, and integrations.
C# ASP.NET Core SQL Server
0
0
View full entry → View portfolio