Project for CLOSE UP through Big Analytics:- Automation of background processes: Implemented a background service that monitors predefined directories, converts images to base64 format, and sends them to a REST API. The system automatically retries in case of connection failures, ensuring the delivery of images without manual intervention, even in scenarios with intermittent connectivity.- Dynamic and customizable configuration interface: Designed a configuration interface that allows users to store branch configuration data in an encrypted file, specifying the directory where the background application processes the images.- Interactive Tray App: Developed a Tray App accessible from the Windows taskbar, enabling users to interact with the application, receive notifications, and quickly access essential settings, keeping the service accessible but discreet.- Robust error handling and retry management: Implemented advanced retry logic to ensure data integrity in case of connection failures. The service queues images until the connection is restored, ensuring that no images are lost.- Simplified and robust installation process: Created an installer using Windows Installer, packaging the application to ensure a simplified installation and configuration process for end users, with no need for technical intervention.- Secure and efficient collaboration with REST API: Managed communication between the application and a REST API, ensuring that processed images were transferred securely and efficiently to an FTP server, guaranteeing a reliable and optimized data flow.

Project for MAMPA through Big Analytics:- Full platform web development from scratch: Designed and developed a web application in .NET 8, divided into a Frontend and Backend (API) connected to a PostgreSQL database. The platform was built to be scalable, secure, and modular, adapting to different user roles with controlled access to modules based on permissions.- Advanced user and role management: Implemented a user management system with specific roles. The administrator role can manage users, assign roles, and define permissions. When a new user is created, an automatic email is sent, allowing them to set up their initial password.- Image processing and advanced product search: Developed functionality allowing users to upload an image converted to base64 format. This image is sent to an external API that returns similar products. The resulting product list can be filtered based on various criteria such as color, size, brand, country, and price range.- Product detail view: When a specific product is selected, the system displays key details like completed sales, available inventory, and other relevant metrics, providing a comprehensive view of the product’s performance and availability.- Responsive web interface development: Utilized Bootstrap, HTML, CSS, and JavaScript to create a fully responsive web design, ensuring that the application functions seamlessly on any device, improving accessibility and user experience.

Project for EEGSA throug Big Analytics:- Application architecture restructuring: Migrated an existing application from an MVC model to an API-based architecture, centralizing database access through a .NET 6 API using Entity Framework Core. This improved modularity, separation of concerns, and allowed for easier system expansion.- Secure API development with JWT authentication: Implemented a secure authentication system using JSON Web Tokens (JWT), ensuring that only authenticated users could access the data stored in SQL Server.- Frontend enhancements and new feature development: Added new views and features to the existing frontend using the MVC pattern, JavaScript, jQuery, and Bootstrap. Integrated the DataTables library to create dynamic, interactive tables that enhanced user experience and enabled efficient manipulation of large datasets.- User role-based access control management: Configured a role-based access control system to ensure that each user had access to specific modules based on their role within the platform, enhancing both security and user-specific functionality.- Email notification system implementation: Developed an automated email notification system within the application, sending alerts and notifications based on user actions, improving internal communication and system responsiveness.

Project for INTCOMEX through Big Analytics:- Development of a New Complete Module: Responsible for the design and development of a comprehensive module in an existing system, covering both the Frontend and Backend using the MVC model of .NET Core 2 and SQL Server as the database. The project included creating a relational model that supported business logic and developing Stored Procedures for data manipulation.- Development of Dynamic and Responsive Web Interfaces: Implemented MVC views using Bootstrap, CSS, JavaScript, and jQuery, ensuring a responsive and interactive user interface. The controllers developed consumed Stored Procedures in SQL Server, which contained the business logic needed for data interaction.- Bulk Data Loading and Normalization: The main functionality of the system was bulk data loading, handling Excel files that were processed and normalized in the designed database. This allowed for data reconciliation from various sources along with the data loaded from Excel, and generated reports that clearly summarized the reconciliation results. I worked with large volumes of data, optimizing both system performance and accuracy.- Agile Collaboration and Version Control with Gitflow: Worked closely with an agile team under the Scrum methodology, presenting weekly progress and maintaining clear documentation of changes and new functionalities. Used the Gitflow workflow in Bitbucket for version management and source code control, ensuring efficient continuous integration.

- Database Analysis and Design: Conducted thorough analysis and design of tables in existing databases, ensuring a solid and optimized structure that aligned with business requirements, facilitating scalability and long-term maintenance.- Optimization of Database Objects: Managed and optimized database objects, including tables, indexes, and relationships, adapting them to the changing system needs, improving overall performance and reducing latency in critical operations.- Development of Business Logic in SQL: Designed and developed stored procedures, functions, and triggers that accurately captured business logic, enhancing consistency and reducing code complexity, which made system maintenance and evolution easier.- High-Performance Query Optimization: Implemented highly optimized SQL queries that ensured fast and efficient response times, significantly improving system performance in high-volume data environments.- Automation and Flexibility Through Dynamic Scripts: Developed dynamic scripts that reduced code redundancy, providing more flexible, efficient, and maintainable solutions, which accelerated the development and implementation of new functionalities.- Implementation of Security Controls in Databases: Designed and implemented database-level security controls, ensuring data integrity, confidentiality, and controlled access to information, complying with business security standards and regulations.

- Mastery of Object-Oriented Design (OOP): Developed a deep and applied understanding of Object-Oriented Design, which enabled me to create modular, scalable, and maintainable software. This strong foundation facilitated the implementation of extensible solutions that could easily adapt to changing business needs.- Efficient Database Handling with Entity Framework Core: Utilized Entity Framework Core to efficiently interact with databases, optimizing queries in SQL Server and ensuring smooth data management, which enhanced the scalability and performance of the developed applications.- Creation of Secure and Efficient APIs: Designed and developed web APIs with a focus on security and efficiency, enabling the exposure of services that improved system interoperability and enhanced data exchange between applications.- Web Application Development with Blazor: Designed and developed modern web applications using Blazor, leveraging its ability to create rich and interactive user experiences without sacrificing performance, delivering immersive Single Page Applications (SPA).- Optimized Workflow with Git: Implemented and efficiently managed version control using Git, ensuring organized, collaborative, and secure source code management, enabling an agile and conflict-free workflow within development teams.- Code Quality Through Unit Testing: Regularly developed and executed unit tests to ensure the quality and stability of implemented code, reducing production errors and improving the reliability of delivered solutions.

- Database Optimization and Security: Utilized Transact-SQL in SQL Server and Sybase environments for advanced data manipulation through stored procedures, significantly improving efficiency and security in managing large volumes of information.- SOAP Services Interoperability and Efficiency: Implemented robust SOAP services using .NET, developing in C# and Visual Basic. This enabled efficient communication between heterogeneous systems, enhancing interoperability and reducing response times for critical services.- Advanced Systems Integration: Developed SOAP services with IBM Integration Toolkit, optimizing integration between different enterprise systems and ensuring data consistency through complex workflows.- Web Development Focused on Usability: Designed and developed web applications in Classic ASP, utilizing HTML, CSS, JavaScript, and jQuery to create intuitive and functional user interfaces. This significantly improved the end-user experience and ensured optimal performance in high-traffic environments, while maintaining a solid web architecture and seamless user experience.- Agile Methodology and Teamwork: Actively participated in multidisciplinary teams under the SCRUM methodology, contributing to the timely delivery of key features and fostering effective collaboration between developers, testers, and stakeholders.- Version Control and Traceability: Implemented a rigorous version control system using TortoiseSVN, ensuring code integrity and facilitating collaboration in shared development environments, reducing the risk of conflicts and improving team productivity.