Jose Rivera

Software Engineer

Bank of America•  August 2022 - September 2023

BANK OF AMERICA: TEAM CLEARED DERIVATIVES RISK TECHNOLOGIES (CDRT) Integrate new data sources to Sandra DB organizing the acquired information to enable other teams within the bank to con-duct in-depth analyses of risk exposure and make strategic decisions. Utilizing the Bank of America Python Quartz Frame-work and various tools including Sandra DB, DB Browser, Bob Jobs, and JIRA, among additional resources. PROJECT RESPONSIBILITIES AND ROLES: • Assured the changes have been committed to the version control system. • Ensured that at least 80% of the code was covered by unit tests. • Make sure that the changes have been committed to the version control system. • Testing in a development environment. • On the testing servers, monitor the success of the execution. • Request approval of changes from a peer reviewer. Technologies: Python 3, Bank of America Python Quartz, Sandra DB, Bob Jobs, DB Browser

Software Engineer

Facebook•  February 2022 - May 2022

PROJECT: FACEBOOK (META) SCIM CONNECTORS Implementing SCIM or the System for Cross-domain Identity Management specification. PROJECT RESPONSIBILITIES AND ROLES: • Develop SCIM target connectors classes using Python 3 • Modify existing SCIM connectors for adding reconnectors to them. • Deploy for the testing environment for the review of the team. Technologies: Python 3, RESTful APIs vendor: GlobalApps

Web Architect

OxxoGas•  July 2018 - February 2022

PROJECTS LIST 1. PROJECT: SALES INFORMATION TRANSMISSIONS 2. PROJECT: ALL SALES MUST HAVE AN ELECTRONIC INVOICE 3. PROJECT: MOBILE APPLICATION FOR CLIENTS (BACKEND) 4. PROJECT: OXXOGAS MOBILE APPLICATION FOR DRIVERS OF HIGH-FREQUENCY 5. PROJECT: ALARMS TO DEPRESSURIZE HOSES 6. PROJECT: REPORT WEBSITE WHERE THERE IS NO GASOLINE 7. PROJECT: MONITOR TRANSMISSIONS TO FINANCIAL SYSTEMS 8. PROJECT: NAGIOS MONITORING AND ALARMS 1) PROJECT: SALES INFORMATION TRANSMISSIONS The availability of information on the sales of more than 550 gas stations within 30 seconds of their generation in the sys-tem following sales transactions. Including reports for monitoring information transmissions from gas stations to Azure SQL. PROJECT RESPONSIBILITIES • Generate Python program executable for transmission or retransmission of information to RabbitMQ Queue on Azure Cloud • Setup RabbitMQ server for transmissions • Create a Python process for the processing of queue messages and save data to Azure SQL • Create Python logic for retransmission logic and validations of missing information. • Create T-SQL triggers for setup data for transmission at gas stations. • Create SQL Setup scripts for the installation of triggers and create/update tables for transmissions. Technologies: MS SQL SERVER, Python, Redis DB, RabbitMQ, Django and Azure SQL 2) PROJECT: ALL SALES MUST HAVE AN ELECTRONIC INVOICE All sales tickets are billed after 23 hours and before 24 hours if there is no customer invoice, billing the general public. And Billing up to 50 thousand sales tickets in less than an hour. PROJECT RESPONSIBILITIES AND ROLES • The generation of expense invoices is automated for the sales tickets invoiced by clients when they already had an invoice to the general public. • A set of reports in Power BI for auditing the operation of the system. • Generate invoices for old 24-hour sales tickets without an invoice to the customer. • Setup reports configuration with Cypher (Neo4j's graph query language) or Gremlin (Cosmos DB query language graph mode) at the configuration file of the system. • Set up command line options to monitor the system processing the information. Environment: Python multithreading, Azure SQL, Azure Cosmos DB Graph, Neo4J, Git. 3) PROJECT: MOBILE APPLICATION FOR CLIENTS (BACKEND) A REST API that provides backend support for a mobile application for customers, offering billing services, accumulated points, redemption of accumulated points for promotional items, and configuration of the application's GUI components. PROJECT RESPONSIBILITIES AND ROLES • Provide a website to manage advertising promotions for the exchange of points accumulated for movie tickets, motor oil, etc. • A set of Web reports monitoring customer billing. • Set up the software architecture design. • Set up the automated testing using the Python unit test module. • Codify a set of web reports monitoring customer billing. • Develop an ER model that captures the schema of the following entities and their relationships: Store promotions, Customer tickets, Billings, Promotions used by customers, and Application GUI components. Technologies: Python, Django, Redis DB, pandas, Python unit tests, Django rest framework, RESTful APIs, and Azure SQL. 4) PROJECT: OXXOGAS MOBILE APPLICATION FOR DRIVERS OF HIGH-FREQUENCY RESTful APIs for the backend of the mobile application for drivers of Cabify, Uber, etc. to sell more volume. PROJECT RESPONSIBILITIES AND ROLES: • Provide a website to manage registered drivers for this mobile application. • A set of Web reports monitoring customer billing. • Set up the software architecture design. • Set up the automated testing using the Python unit test module. • Codify a set of web reports monitoring customer billing. • Develop an ER model that captures the schema of the following entities and their relationships: Store promotions, Customer tickets, Billings, Promotions used by customers, and Application GUI components. Technologies: Python, Django, Redis DB, pandas, Python unit tests, Django rest framework, RESTful APIs, and Azure SQL. 5) PROJECT: ALARMS TO DEPRESSURIZE HOSES Release pressure from hoses after 2 hours of no sales to prevent inaccurate sales measurements. To ensure liter sales, the hoses are depressurized when they do not sell in two hours, building reports and RESTful APIs Services to consult alarms. PROJECT RESPONSIBILITIES AND ROLES: • Write stored procedures to automatically identify the hoses at gas stations that have not had any sales in the last two hours. • Configure the web service to allow applications to query for the hoses at gas stations that need to be depressur-ized. Technologies: python, Django, Django rest-framework, and Azure SQL. 6) PROJECT: REPORT WEBSITE WHERE THERE IS NO GASOLINE The monitoring of inventories in gas station tanks is shared by a third company and is consulted via the Web, requiring file extraction and automatic loading every hour. PROJECT RESPONSIBILITIES AND ROLES: • Develop a RESTful API that returns gas stations and the available products by fuel type. • Automate the login and consultation of third-party web reports to upload information to the database. Technologies: Python, Django, Selenium, Django rest-framework, and Azure SQL. 7) PROJECT: MONITOR TRANSMISSIONS TO FINANCIAL SYSTEMS Portal with reports to monitor the proper transmission of information to the financial system, using control figures gener-ated from the gas station's database to ensure the integrity of the information. PROJECT RESPONSIBILITIES AND ROLES: • Write code for T-SQL triggers to calculate control figures. • Write SQL scripts to create control figure tables. • Create an ER model to store control figures. • Write T-SQL stored procedures to generate control figures in Azure SQL database to compare with gas station-generated control figures. • Codify Django web reports to compare control figures. Technologies: Python, Django, Bootstrap, Pandas, Redis DB, Azure SQL, Oracle DB 8) PROJECT: NAGIOS MONITORING AND ALARMS Using the Nagios system to monitor and set up alarms in order to ensure the system is functioning. PROJECT RESPONSIBILITIES AND ROLES: • Set up the Nagios server on a Linux server. • Install monitor agents in monitored servers. • Setup users and their permissions. • Setup alarms to notify team members. Technologies: Python, Django, Bootstrap, Pandas, Redis DB, Azure SQL, Oracle DB

Web Architect

oxxo•  February 2011 - July 2018

PROJECTS LIST 1. PROJECT: POINT OF SALE WEB PORTAL 2. PROJECT: ADVISOR PORTAL TI 3. PROJECT: INDICATORS PORTAL FOR IT 4. PROJECT: GOXXOGLE PORTAL (FEMSA COMERCIO) 5. PROJECT: POS MESSENGER PORTAL (FEMSA COMERCIO) 6. PROJECT: TRANSMISSION CONTROL VIA EMAIL 7. PROJECT: ON-DEMAND AUDIT CONTROL VIA EMAIL (FEMSA COMERCIO) 8. PROJECT: PERIODIC EXECUTION OF VARIOUS AUDITS 9. PROJECT: STORE TRANSMISSIONS PORTAL (FEMSA COMERCIO) 1) PROJECT: POINT OF SALE WEB PORTAL To have visibility of the versions of the software installed in the store machines, concentrating the information for an agile review of the situation of the distribution of the versions of the different modules of the installed software. PROJECT RESPONSIBILITIES AND ROLES: • Setup the RabbitMQ Server on Linux • Setup the Processing of Queue Messages server with Celery and Python • Create the database model and deploy it to MS SQL Server • Setup admin portal website with Django • Setup MongoDB database • Setup Redis DB server for cache • Create the reports on Django for monitoring software versions installed. • Codify Python using multithreading for connection to the remote computer’s disk and extract configuration files of the software installed. Technologies: Linux, Django, NGINX/Apache, HTML/CSS, Bootstrap, MS SQL Server, Pandas, MongoDB, Python Multithread-ing, RedisDB 2) PROJECT: ADVISOR PORTAL TI A Web dashboard is generated to easily visualize the number of reboots of the equipment and the errors recorded in error tables of the point of sale of the store computers. PROJECT RESPONSIBILITIES AND ROLES: • The generation of expense invoices is automated for the sales tickets invoiced by clients when they already had an invoice to the general public. • A set of reports in Power BI for auditing the operation. • Generate invoice for old 24-hour sales tickets without an invoice to the customer. Technologies: Linux, Django, Nginx/Apache, Bootstrap, HTML/CSS, MS SQL Server, Python Multithreading, RedisDB 3) PROJECT: INDICATORS PORTAL FOR IT All the critical factors are displayed for evaluation of the functions carried out by the IT Advisors on a monthly and annual level by the IT Adviser. more projects on resume

Universidad Autónoma de Nuevo León

Computer Science, BS•  August 1989 - December 1993

Bachelor's in Computer Sciences