Position: Software Engineer (January 2022 - December 2022)
Activities:Requirements Analysis:Collaborated with administrative, production staff, and stakeholders to analyze system requirements.
Database Design:Designed and optimized databases (SQL Server, MySQL, SQLite) for efficient information management.
Prototyping:Developed functional prototypes to align development with end-user expectations.
Automation and Optimization:Automated internal processes and improved high-impact system modules, increasing plant efficiency.
Documentation and Support:Prepared technical and user manuals, and provided training to ensure proper use.
Highlighted Projects:·
Production Traceability:Developed a platform to digitize the entire production flow, from fruit reception to selection, packing, packaging, and shipping. The platform includes several sections, such as reports, receptions, quality control, packing, and monitoring, allowing the generation of detailed reports and attaching photographs. By consolidating information from multiple databases (SQL Server, MySQL, and SQLite), I efficiently managed information across various departments. This platform improved operational efficiency, reduced manual errors, and provided real-time visibility of production.
·
Vendor Management Platform:Developed a platform in Next.js and .NET Core to optimize the review of supplier information and documentation, replacing manual processes based on email exchanges. Information is stored in SQL Server and documents are uploaded to the cloud (AWS S3). The platform allows suppliers to update their data and upload documents autonomously, while staff can validate and manage approvals with a few clicks.
Position: Software Engineer Jr (November 2020 - January 2022)
Highlighted Projects:·
Box Counting System:Developed a module for the ERP in .NET (C#) using Windows Forms, installing nettops with barcode scanners strategically placed on conveyor belts. Each time a box was scanned, it was recorded in the system. I used Entity Framework and SQL Server for data management, and Power BI for report generation. The platform records packed boxes in real-time and has an intuitive interface. This solution improved operational efficiency and motivated staff through a production-based incentive system.
·
Comprehensive Module for Mass Payment Management:Developed a module for the ERP in .NET (C#), automating financial transactions and filtering pending payments with associated fiscal documents. By consolidating data from different sources (SQL Server and MySQL), I optimized processes, reduced treasury errors, and accelerated payment processing times.
·
Main Website:Developed a new website for the main domain (
aztecavo.com.mx), using React to ensure a user-friendly and adaptable interface to any screen size. Implemented SEO techniques and performance optimization, increasing web traffic and improving user experience.
Additional Technologies and Tools Used:Languages and Frameworks: HTML, CSS, JavaScript, .NET Core, C#
Databases: SQL Server, MySQL, Entity Framework
Development Tools: Git, Jira, Crystal Reports, Power BI
Security and APIs: JWT, Active Directory
Infrastructure and Administration: IIS, Hyper-V, Acronis, IT Help Desk (ticket resolution system)
Position: Software Engineer Intern (January 2020 - November 2020)
Software Development internship