Here is a list of some projects I have had the opportunity to lead and contribute with the analysis,
development and implementation. These are descriptions only since I cannot publish sensitive
information regarding my employers, like code or data.
Description:
This is a Windows application running on the sales associates' laptops with the ability to access
a local database and sync with the remote central database via a restful web service. Also,
they were able to sync inventory data with a handheld device.
Features:
Create Sales Orders
Inventory Count using a handheld
Calculate Sales by comparing inventories and sales orders
Suggest Sales Order using the Sales Calculation
Tech Specs:
Local database with SQLExpress
Windows client application in WPF
Restful API (WCF, C#) to sync the local database with the central database
Windows Mobile client application to take inventory (VB for Windows Mobile)
Description:
To keep track in real-time of the production, we installed raspberry pi computers at the end of
the production lines. The computers are low cost and have built-in connectivity features like
wifi and bluetooth, making them very convenient to install. We connected a barcode scanner to
the computers to scan the full cartons. The application record scanned cartons in the database
with information about the production team, the product inside the box, and the date time.
Features:
Scan carton labels
Detect production team automatically
Show production schedule to the team
Tech Specs:
Web application (ASP.Net, MVC) with Razor front-end and C# back-end
SQL Server Database
Description:
With the adoption of the Raspberry Pi on the production floor, we had the opportunity to gather
more information about the events that affected the production process. We created a module to
register the events that stopped the production, like machine downtime, raw material missing,
low quality, and others. The associate would open a stoppage time event, and the department in
charge of solving it would go to the production line and work to resume the production. Once
solved the problem, the associate would mark it as solved in the system.
Features:
Open a stoppage time event
Close a stoppage time event
Tech Specs:
Web application (ASP.Net, MVC) with Razor front-end and C# back-end
SQL Server Database
Articles and Repos
Photo by Markus Winkler from Unsplash
Build SQLAlchemy Model in Python Saving Classes Individually
Application Development Manager • Landau Uniforms
Sep 2021 – Oct 2024. Ontario, Canada (Remote)
Created sales forecasting data models for time series analysis in Python, utilizing XGBoost. Reducing manual
labour by 40%.
Contributed to designing and creating data pipelines between the on-premises ERP database and the business
intelligence Azure data warehouse.
Created and maintained APIs to sync orders and inventory between the ERP Dynamics AX and the company’s
websites. Created and maintained microservices built in Python and C# to process orders in EDI and other file
formats from different sources like FTP servers and Azure blob storage, processing over two thousand orders daily.
Enhanced the company’s ASP.Net-MVC websites and Windows forms-based C# applications.
Led a four-person team, dividing my time by 60% management and 40% hands-on. Participating in writing,
reviewing and testing code.
IT Manager • Land Apparel
Jul 2014 – Sep 2021. Puerto Cortes, Honduras.
Aligned annual budgets and IT assets with corporate goals, optimizing resource allocation.
Created management dashboards on PowerBI and SQLServer; implemented SSRS to enhance data-driven
decision-making.
Led the introduction of Raspberry Pi computers to scan finished goods for real-time production tracking,
downtime reporting and andon lights signalling using ASP.Net and Python.
Redesigned, migrated, and implemented production planning and payroll software using ASP.Net-MVC, and
SQLServer. Reducing production planning time by 75%.
Implemented the Scrum framework, leading a team of four and dividing my time 70% management 30% hands-on.
Analyst / Developer • Intermoda S.A.
Mar 2012 – Jul 2014. San Pedro Sula, Honduras.
Designed, developed and implemented a Windows Form- based C# point-of-sale application with database in
SQLServer.
Implemented an API to sync the remote POS software and an on-premise SQLServer database.
Built inventory count software for handheld computers featuring a sync-to-PC interface. Improving inventory
quality by 40%.
Senior Developer • Grupo Leitz
Apr 2009 – Mar 2012. San Pedro Sula, Honduras.
Preserved and improved legacy software systems to ensure ongoing operational efficiency using Windows forms,
ASP.Net and javascript.
Windows mobile application development.
Design and creation of databases, tables, stored procedures, and user-defined functions in SQL Server.
Software Analyst • Banco del País
Jul 2008 – Mar 2009. San Pedro Sula, Honduras.
Preserved and improved legacy software systems to ensure ongoing operational efficiency.
Database migration for new bank core, including table structure, data and stored procedures using SQL Server.
Creation of SQL Server Integration Services for data transformation and migration.
Junior Developer • Integrasoft
Sep 2006 – Feb 2008. San Pedro Sula, Honduras.
Development of Windows form applications.
Development of web applications with ASP and javascript.
Design and development of stored procedures and tables using SQL Server.
About
Photo by Javier Allegue Barros from Unsplash
With over 15 years of experience, I have successfully led teams in developing innovative and secure software
solutions, optimized software performance, and collaborated with stakeholders to gather requirements. I have
expertise in developing sales forecasting models, building data pipelines, and maintaining APIs and microservices
for syncing orders and inventory. I excel in balancing management responsibilities with hands-on coding tasks. I
have a proven track record of implementing secure software solutions that drive business growth and efficiency.
Education
Photo by Alexandre Van Thuan from Unsplash
Computer Science Engineering
Universidad Tecnologica Centroamericana (UNITEC)
Master in Business Administration
Universidad Tecnologica Centroamericana (UNITEC)
Master of Science in Analytics
Georgia Institute of Technology (GeorgiaTech)
