ALEXIS GARCÍA

Head of the Contracting Procedures Operation Department (Full-time)

Analysis and data extraction from the Compranet 5.0 database for publication, ensuring public access to information on procurement and public works contracting procedures of the Government of Mexico through the open digital system "Histórico de Compranet 5.0".

• Objective alignment: Collaboration with the business area to analyze and establish project objectives, identifying the information intended for public release.
• Database analysis: Identification and analysis of relevant tables of the database.
• DDL translation: Translation of the schema definitions of the identified tables from the remote Oracle database to a local MariaDB database.
• Record migration: Migration of records from the previously translated tables in the remote Oracle database to the local MariaDB database, ensuring data integrity.
• JSON file generation: Creation of JSON files from the identified tables, ensuring the correct format for front-end consumption.
• Field filtering: Selection and removal of confidential attributes, keeping only the information authorized for public disclosure.
• Technologies: PHP 8.2, Oracle Database, MariaDB, Linux, Git.
• Soft skills: Requirements analysis, process optimization, confidentiality, teamwork, consistency.

Software Engineer (Project-based position)

Development of the web service for the RUCAM (Registro Único de Certificados, Almacenes y Mercancías) for Mexico's Secretariat of Economy. The service facilitates the management of deposit certificates and warehouses of General Deposit Warehouses, ensuring compliance with the new legal requirements established by the 2024 law reforms.

• Requirements Analysis: Analysis of the reforms to the General Law on Titles and Credit Operations (Ley General de Títulos y Operaciones de Crédito) and the General Law on Organizations and Auxiliary Credit Activities (Ley General de Organizaciones y Actividades Auxiliares del Crédito) for the adaptation of the existing RUCAM database.
• Reverse Engineering: Determination of the backend functionality of RUCAM through the analysis of its database.
• Development: Implementation of the RUCAM web service.
• Automated Testing: Design of execution stories and test cases. Implementation of automated tests.
• Documentation: Writing and reviewing various manuals (user, deployment, etc.) for the RUCAM web service.
• Technologies used: PHP 8.2, Oracle Database, Oracle Linux, GitHub, Oracle VM, Docker.
• Soft Skills: Clean and consistent code, requirements analysis, confidentiality, problem-solving, research, adaptability to change, teamwork.

Terminal project: Generation and solving of levels of a platform video game using neural networks

• Development of a neural network that generates level descriptions of a platform game using PyTorch and C++.
• Development of a neural network that solves levels of such game.
• Development of the platform game visualization using HTML, CSS and Javascript.

Social Service: Web system for the management of the academic tutoring program of the DCBI

• Development of the graphical interface in HTML and CSS.
• Development of the front-end functionality using Javascript.
• Creation of CSS styles.
• Responsive design for mobile devices.