JUAN LAURETTA FULLSTACK_ENGINEER

A robust, full-stack web application engineered to centralize human resources workflows and automate employee performance reviews for MDN Publicidad. I collaborated closely with the HR department and other coworkers to map out the ideal administrative workflow before architecting and developing the tool. Core Features: Comprehensive Employee Registry: A centralized database to securely manage and maintain all employee records and corporate data. Leave Management System: Integrated tracking for employee vacations, streamlining time-off requests and administrative scheduling. Role-Specific Evaluations: Dynamic performance assessment workflows that allow managers to create tailored evaluation forms based on individual job positions. Automated Scoring Logic: End-to-end evaluation systems that simplify how managers assess and grade individual employee progress. Data Visualization & Reporting: Interactive graphical reports that track evaluation results and performance trends on a monthly basis. Note: As this is a proprietary company product, source code and live access are restricted. A demo video showcasing the system's functionality is available upon request....

A robust, full-stack warranty management and customer support platform developed for DeplusWorld, a US-based air conditioning supplier, in collaboration with the MDN Publicidad team. The application architecture consists of a responsive frontend built with React and Tailwind CSS hosted on Netlify, powered by a .NET Core API and a MySQL database deployed on Microsoft Azure. The system streamlines the post-purchase experience by allowing customers to securely register their units using a unique serial code. Upon validation, the .NET backend automatically generates a customized PDF warranty certificate, which is instantly downloaded and emailed to the user. Clients can also use the portal to retrieve past certificates and open technical support tickets for their registered products. For internal operations, the platform features a comprehensive administrative dashboard. Admins have full control to manage the product catalog, upload new valid serial numbers for registration, log ongoing maintenance services for specific units, and monitor system activity through interactive monthly registration charts....

A streamlined, React-based registration portal developed in collaboration with the MDN Publicidad team for Fein Kaffee, a well-known local coffee shop in Maracaibo, to seamlessly onboard customers into their digital rewards program. The application serves as the intuitive, customer-facing entry point. It securely captures user details and interfaces directly with the LoopyLoyalty API, which acts as the backend engine for the rewards logic. Upon successful registration, the system automatically dispatches an email to the customer containing a personalized digital loyalty card link. This allows users to conveniently save their pass directly to their Apple Wallet or Google Wallet for immediate use in-store. Behind the scenes, the platform features automated data synchronization. Every new customer registration is instantly logged into a centralized Google Sheets database. This lightweight but highly effective setup ensures the Fein Kaffee team has real-time, organized access to their growing customer roster without the overhead of managing a complex administrative dashboard....

A dynamic, React-based web catalog developed in collaboration with the MDN Publicidad team for Don Búfalo, an agricultural center specializing in the breeding and sale of high-quality Murrah buffalos. The platform serves as a modern digital storefront, allowing prospective buyers to explore available livestock, download sanitary care plans, and contact the sales team directly via WhatsApp. To meet the client's specific request for a frictionless content management experience, the platform's livestock inventory is entirely driven by Google Sheets. By utilizing Make to automate the data synchronization, the business owner can easily update animal availability, pricing (such as pregnant heifers), and details in a simple spreadsheet. These changes instantly reflect on the live website, completely bypassing the need for a complex administrative dashboard or technical training. This lightweight yet powerful architecture provides a seamless, fast browsing experience for users while dramatically reducing administrative overhead for the agricultural staff, allowing them to focus on field operations rather than software management....