LC

Hi, I'm Lucas Correa

.NET Developer SQL Server · Data modeling

I build business management systems: data models that organize operations, migrations from legacy systems, and dashboards that answer in milliseconds.

  • General Las Heras, Buenos Aires, Argentina
  • Available for on-site or hybrid work

About me

For over a year and a half I worked on a custom ERP-style management suite for a passenger transport company in Greater Buenos Aires, with 180+ bus lines and about 6,000 vehicles. I started as an intern and became a full-time developer after three months.

I designed the Personnel and Claims modules from scratch and the Stock data model, and worked on seven other modules: Fleet, Fuel, Tires, Drivers, Tenders, Roadside Assistance and Security.

My strength is the database: designing tables and relationships, moving data from old systems into new ones, and making queries over millions of rows fast. I also handle hardware, Windows and network support.

I'm currently learning SAP ABAP and Qlik Sense to work on industrial management systems, as well as C#, .NET 10 and Angular. This site is built with .NET 10.

queries over ~18M rows
12 s → 0.1 s
master tables in the Personnel module
20+ tables
Jira tickets resolved
80+

Experience

Código Nativo

Client: DOTA, passenger transport, Greater Buenos Aires

Remote · Apr 2025 – Nov 2026

  • .NET Developer, full-time · Jul 2025 – Nov 2026
  • .NET Development Intern · Apr – Jun 2025

Projects

Four pieces of work that show how I think about a business system, from the database to the screen.

01 Performance · Legacy data

From 12 seconds to under 0.1

Summary tables over 18 million rows from a legacy DBF scheduling system.

Schedules (DBF) 18.2M rows fields stored as text once Km summary line · vehicle · day 5.9M rows Staff summary line · vehicle · day 11.5M rows Dashboards < 0,1 s before: ~12 s
Data is aggregated once and dashboards read only the summary.

The problem

The incident dashboards needed kilometers driven and staff on duty per line, vehicle and day. That data lived in a schedule table imported from an old DBF system, with more than 18 million rows and fields stored as text. Every query had to convert and aggregate everything again.

What I did

I designed two summary tables computed once: kilometers per line, vehicle and day (5.9 million rows) and staff per line, vehicle and day (11.5 million). The load cleans the data: safe type conversion, discarding invalid rows and filtering years. Both tables are keyed and indexed by line, vehicle and date.

Result

Queries equivalent to the dashboard's went from about 12 seconds to under 0.1: over 100 times faster. Measured on the same database, three runs per query.

SQL ServerT-SQLDBF dataECharts
02 Data modeling · Inventory

Stock movement model

Receipts, issues, adjustments and transfers between warehouses, fully traceable.

Source warehouse transfer out − subtracts stock PENDING Receipt at destination items are checked Received correctly + adds at destination Received with difference the difference is tracked Movement types: purchase · opening stock · cost-center consumption · vehicle consumption positive and negative adjustment · internal move · transfer out and in
A transfer subtracts at the source and adds at the destination only when receipt is confirmed.

The problem

The stock team needed to know at any moment what was in each warehouse and location, and why it changed: purchases, consumption by cost center or vehicle, adjustments, and transfers that can arrive with differences.

What I did

I designed the movement model: a header and its lines, a catalog of movement types that says whether each one adds or subtracts, adjustment reasons, cost centers, and a transfer flow with states. I built the operations: internal moves, transfers and receipt, issues, adjustments and the import of opening stock.

Result

Every stock change is recorded with its origin. A transfer starts as pending and closes as received correctly or received with a difference, without leaving stock out of balance.

SQL ServerStored ProceduresVB.NETASP.NET
03 Module design · HR

Personnel module from scratch

Employee records and 20+ master tables as the basis for payroll.

Banks and accounts Unions and agreements Health insurers Salary categories Cost centers Tax concepts Holidays Contract types Employee record job · family · tax (ARCA)
The employee record at the center and the master tables around it.

The problem

The company needed to centralize its staff data with everything payroll requires: employment, family, banking, union and tax authority (ARCA) data.

What I did

I designed and built the whole module, database and screens: the employee record and its master tables, including banks and accounts, unions and agreements, health insurers, salary categories, cost centers, tax concepts, holidays and contract types.

Result

More than 20 master tables linked to the employee record, each with create, edit and delete screens, leaving the data ready for payroll.

SQL ServerVB.NETASP.NETJavaScript
04 New module · Integrations

Claims with maps and dashboards

Full incident records, Google Maps geolocation and statistics.

Address typed by the user Google Maps Places Autocomplete Location latitude, longitude Incident damage · photos Dashboards heat map
From the typed address to a point on the heat map.

The problem

The company needed to record every vehicle incident with all its details, place it on a map and analyze where and how incidents happen.

What I did

I designed the module and its tables from scratch: the incident, injured people, damages, police reports and photo evidence. I integrated the Google Maps API with address autocomplete to store the exact location. I built ECharts dashboards: severity index, rankings, monthly trend and a heat map of critical areas, with PDF export. I added an optimizer that compresses photos before saving them and migrated historical records from the previous system.

Result

Every incident lands on the map, and management can see where incidents cluster and how they evolve.

SQL ServerGoogle Maps APIEChartsVB.NETJavaScript

Diagrams show the structure with simplified names. They contain no client code or data.

Skills

Databases

  • SQL Server
  • T-SQL
  • Stored Procedures
  • Query optimization
  • Summary tables
  • MySQL

Modeling and migration

  • Table and relationship design
  • Normalization
  • Legacy data migration (DBF)
  • Asynchronous loading

Development

  • VB.NET
  • ASP.NET / ASPX
  • .NET Framework
  • JavaScript
  • jQuery

Integrations and dashboards

  • Google Maps API
  • ECharts
  • PDF export

Support and infrastructure

  • PC building and repair
  • BIOS and boot
  • Windows
  • TCP/IP networks and cabling
  • DVR security cameras

Tools

  • Git
  • Bitbucket
  • Jira

Currently learning

  • C#
  • .NET 10
  • Angular
  • SAP ABAP
  • Qlik Sense

Education

  1. Systems Analyst Technician, Software Development

    ISFDyT N° 44

    2021 – 2024
  2. In progress
  3. Qlik Sense

    Qlik Learning

    In progress

Contact

I'm looking to join a team working on business management systems. If you have an opening or want to talk, get in touch.

correalucasrl@gmail.com