Pablo Ernesto Lorenzo Méndez

Pablo Lorenzo

Software Engineer · Backend · AI · Cloud

From Santo Domingo, Dominican Republic

Software Engineer @ UNIT S.A., a digital insurance company and subsidiary of Grupo Universal, building and maintaining full-stack solutions with ASP.NET (C#), Azure, Angular, Oracle, and SQL Server. Led the development of an academic planning platform used by 1,000+ students at UNPHU.

Currently deepening my knowledge in distributed systems, networking, and cloud infrastructure, with the goal of specializing in backend engineering integrated with AI.

CV available here.

LATEST FROM MY PORTFOLIO

Unphu Academic Planner · 2025-01-30

It allows students at Pedro Henríquez Ureña University to plan their academic schedules for upcoming semesters. they can create schedules, share them with other students, compare them, view statis...

See project

Featured Projects


UNPHU Academic Planner V2

project banner

Student Planning and Academic Management System

A web app that helps students at Universidad Nacional Pedro Henríquez Urena plan their academic schedules. Students log in with their university Google Account via OpenID Connect, create and share subject calendars, compare schedules with peers, and track career progress, pending subjects, and expected graduation dates.

At UNPHU, subject selection happens three times a year. Coupon availability is competitive — prioritized by career and GPA — leaving students uncertain whether they'll secure a spot. Without visibility into academic workload or teacher profiles, many enroll in more than they can handle or have an unpleasant academic experience, leading to dropped courses, wasted coupons, and delayed graduation. Over 70% of students report having failed or dropped more than 4 classes.

This app is integrated with the university's student information system (Note: Not directly — see how it was done in the details) and was built using Next.Js as the frontend and BFF, ASP.NET core (C#) for the API, and Azure cloud services for hosting the web apps, database and supporting the Event Driven Architecture of this application, through Azure Service Bus (Events broker) and Azure Functions. This is an improved version of the first one; I was rebuilt from scratch with a different stack and architecture, providing better maintainability and scalability.

November 2025 - January 2026
csharpaspnettypescriptnextjssqlserverazureevent driven designoidc

DietBudget | Diet and Finance Planner

project banner

Diet planner that combines nutritional tracking and budget management.

DietBudget is an app that helps users plan their diet, track nutritional goals, and manage food expenses while staying within their budget. It allows users to create and manage personalized food products, set daily calorie and nutrient goals, and create diet plans for efficient meal planning.

This app distinguishes itself from other food-tracking apps by incorporating both nutritional tracking and budget management. I believe diets shouldn't be created solely by assigning high-nutritional-value foods to each meal without considering the user's financial constraints.

This app allows users to create diet plans that provide not only nutritional but also financial information. This enables them to keep track of their expenses, compare different diet plans, and choose what offers the best value for their money.

It is developed using Django (REST Framework), React, and PostgreSQL. It is also integrated with the USDA API to obtain nutritional information for food.

August 2024 - December 2024
pythondjangopostgresql

QueryBank

project banner

A console banking app demonstrating how Identity Providers and raw SQL work under the hood

A console-based bank application built to demonstrate how modern enterprise systems handle authentication and authorization. It uses two separate SQLite databases: an Identity Provider (IDP) and a Bank App database, mirroring the architecture of real-world banking systems. The IDP manages users, roles, claims, OAuth clients and authorization codes, while the Bank database handles accounts, transactions, transfers and logs. Users authenticate via OpenID Connect — the bank application exchanges authorization codes for identity tokens issued by the IDP to grant access. All database interactions are performed through raw SQL queries, with no ORM abstractions, highlighting how applications communicate with databases at the lowest level. Users can register, log in, manage bank accounts, perform deposits, withdrawals and transfers, and check their balance and activity logs.

This project highlights the details abstracted by authentication/authorization frameworks, by exposing how an IDP works. It also highlights database and sql operations abstracted by ORMS. This was built as my final project for the course CS50'Sql By Harvard University.

Built with .NET 9 (C#), SQLite, using the micro-orm Dapper to execute raw SQL Queries.

November 2025 - November 2025
csharpsqldapperoidcoauth 2.0

UNPHU Academic Planner V0

project banner

Student Planning and Academic Management System

A web app that helps students at Universidad Nacional Pedro Henríquez Urena plan their academic schedules. Students log in with their university Google Account via OpenID Connect, create and share subject calendars, compare schedules with peers, and track career progress, pending subjects, and expected graduation dates.

At UNPHU, subject selection happens three times a year. Coupon availability is competitive — prioritized by career and GPA — leaving students uncertain whether they'll secure a spot. Without visibility into academic workload or teacher profiles, many enroll in more than they can handle or have an unpleasant academic experience, leading to dropped courses, wasted coupons, and delayed graduation. Over 70% of students report having failed or dropped more than 4 classes.

This web application was developed to solve this problem, this app is integrated with the university's student information system (Note: Not directly — see how it was done in the details) and was built using React.Js (JavaScript) as the frontend, Django (Python) for the API, and Render for hosting.

This is the first version of the Unphu Academic Planner.

June 2024 - August 2024
djangoreactpythonjavascriptpostgresqloidc
View all projects →

Experience


Full Stack Software Engineer

@ UNIT S.A - Grupo Universal | Santo Domingo, Dominican Republic.

March 2025 - Present

Full-Stack Software Engineer at UNIT S.A., the Caribbean's first Insurtech company and a subsidiary of Grupo Universal, the Dominican Republic's largest insurance group. Part of a five-person engineering team building and maintaining the core insurance platform.

  • >

    Designed and built a fraud detection system for vehicle insurance quotations using Azure Document Intelligence — classifying registration document types and extracting content to cross-validate them against active quotations, catching clients insuring a different vehicle than the one being quoted.

  • >

    Developed a backend service for commercial clients (banks) enabling them to programmatically consult all insurance policies emitted through UNIT, streamlining B2B operations.

  • >

    Development of technical solutions aligned to the insurance sector, being participant of the software development process.

  • >

    Designing and developing technical solutions tailored to the insurance industry across the full software development lifecycle.

  • >

    Building, maintaining, and scaling full-stack applications using .NET (C#), Angular, SQL Server, and Oracle.

  • >

    Integrating and managing Microsoft Azure services to support application infrastructure, security, and scalability needs.

aspnetcsharpangulartypescriptazureoracle