Cristales Autromotrices de Jalisco (EUROGLAS)
- Dramatically improve the process of the production planning tasks by creating a custom ERP system (Enterprise Resource Planning). Created as a Windows Desktop application. C# (.Net Framework, WinForms), using a persistence/business layer generated Using EntitySpaces. With a MySQL backend database, runnin on a Virtual Server(Linux Debian on Xen) Also, a REST API was created to access the same data. Using PHP and the same MySQL backend database.
- Enabled near real-time tracking of the production orders on the floorby creating a MES (manufacturing executing system), as a Windows Desktop Application, with a touch-based interface, deployed to thin-client terminals. C# (.Net Framework, WinForms), using a persistence/business layer generated Using EntitySpaces. With a MySQL backend database, runnin on a Virtual Server(Linux Debian on Xen)
- Enable wide company communication across all areas, to allow many of the processes to take place. Like, display product details, prices, sales orders, tracking of production orders, warehouse inventory levels, etc. Also, Employee information, and a place where management could place notices for all employees. Done by creating an internal website which can exchange information with the Production and Human Resources databases. Based on Drupal, using a MySQL database, amd runnin on a Virtual Server(Linux Debian on Xen) With many custome modules ( PHP, HTML, Javascript (JQuery), CSS, ) to enable all the custom functionality
- Streamline the sales process, by enabling traveling salesmen to provide customers with information, while on the road. External portal tailored for the traveling salesmen. This includes product information, personalized prices (for each customer), and be able to place sales orders. Based on Drupal with a, Responsive Design, using a MySQL database, amd runnin on a Virtual Server(Linux Debian on Xen) With many custome modules ( PHP, HTML, Javascript (JQuery), CSS, ) to enable all the custom functionality
- Custom HR system. In order to implement the exact HR policies required by our CEO, three Windows Desktop tools were created using C# .NET, with a persistence / business layer written using Microsoft's Entity Framework, with a MySQL backend running on a virtual (XEN) Linux server (Ubuntu). The main tool is used by the HR personnel to maintain all aspects of employee information. Another is used by supervisors to manage off time (vacation, personal, etc.) and shift assignments. The last one is a clock-in module which registers the employee's fingerprint to register their assistance. This module uses a custom REST API to report assistance to the back office. This allows to install remote clock-in modules all across the company.
- Constrained by a low budget, leverage the team of three developers, including the IT manager. This includes the architectural design, development, testing, code reviews, source management, implementation and maintenance.
- Same team is also in charge of all DEVOPS and SYSOPS (data security, backups, etc.). Notably, the company has been hit twice by ransomeware attacks with resulted in only minor downtime / data loss. This thanks (among other things) to the configuration of our Windows Domain Server.
- Provide IT support to all the departments in the company, this includes procurement and configuration of computers, support of the users with daily issues with all software involved, like MS Office tools like Word and Excel, AutoCAD, ASPEL and Contpaq (administrative suites, including accounting), etc., maintenance of the computers, and other equipment (like networking, UPS and communication systems)
- In progress, there is the development of a new tool to create dashboards, to better visualize business trackers. This new development includes a Front end made in VUE (javascript), talking to a REST API made in PHP and a MySQL backend.