Jean Carlos del Portillo

Fullstack Developer working with PHP and interactive interfaces built with jQuery/Ajax and Angular 18. Designed efficient and secure REST APIs with Laravel 11 and .NET 10+, managing SQL Server databases and handling pipelines and repositories through Azure DevOps.

• Developed Fullstack modules using PHP and modern JavaScript (jQuery/Ajax) to enhance UI responsiveness.
• Designed and built secure, highly efficient REST APIs using Laravel 11 and .NET 10+.
• Implemented modern and modular frontend components using Angular 18.
• Administered, maintained, and optimized robust databases in Microsoft SQL Server.
• Managed code repositories, automated builds, and set up continuous integration pipelines using Azure DevOps.

Support and maintenance of an accounting software built with PHP (Yii2) and Bootstrap. Administration of cloud infrastructure on AWS (Route 53, S3, and EC2 servers). Maintained a .NET application under Clean Architecture and Domain-Driven Design (DDD), and built the administration dashboard in Angular from scratch.

• Provided support and evolutionary maintenance for a web-based accounting application using PHP (Yii2) and Bootstrap.
• Managed cloud infrastructure on AWS, administrating Route 53, S3, and EC2 instances.
• Maintained a corporate backend application built on .NET using Clean Architecture and Domain-Driven Design (DDD).
• Designed and developed a complete administrative dashboard from the ground up using Angular.

Designed and optimized MySQL databases using stored procedures, triggers, and normalization techniques. Developed and maintained HR, accounting, and inventory modules. Built secure APIs for electronic invoicing, electronic payroll, and support documents transmission.

• Designed and optimized MySQL databases by implementing stored procedures, functions, and triggers following database design best practices.
• Administered and normalized relational schemas to ensure high-performance query execution.
• Built and maintained administrative modules covering HR, inventory, invoicing, accounts receivable/payable, and treasury.
• Developed REST APIs for official governmental transmission of electronic invoices, electronic payroll, and electronic support documents.
• Generated and optimized complex accounting reports including Balance Sheets, general ledgers, and daybooks.

Developed and optimized an accounting and logistics web application using PHP. Administered IIS web servers on Windows Server 2003/2008/2012 and optimized SQL Server databases.

• Developed and optimized core modules for a transport and accounting application using PHP.
• Managed and configured Microsoft IIS web servers under Windows Server (2003, 2008, 2012) environments.
• Designed and optimized database logic on SQL Server including stored procedures, functions, and triggers for faster processing.

Backend developer in PHP using Yii2 framework under Linux environments. Designed and implemented stored procedures, functions, and triggers in MySQL databases applying normalization rules.

• Developed and maintained backend modules in PHP using the Yii2 MVC framework in Linux environments.
• Created stored procedures and optimized MySQL databases using Git for source code control.

Processed and analyzed large volumes of health data (RIPS reports and High-Cost diseases). Designed internal web systems using PHP/HTML/CSS connected to Oracle and MySQL databases, and built BI dashboards using Power BI and DAX.

• Processed and analyzed massive datasets for healthcare reporting, such as RIPS and High-Cost reports.
• Designed and built internal web platforms using PHP, HTML, and CSS connected to MySQL and Oracle databases.
• Developed dashboards and BI reports to support executive and managerial decision-making using Power BI and DAX.

Managed operational information, handled advanced relational databases in Access, and created complex spreadsheets in Excel for health services reporting.

• Managed and organized operational information for health services.
• Maintained local databases using MS Access and designed complex reports using MS Excel.