JOSE RIVERA MERLA

SR PYTHON DEVELOPER

BACHELOR’S IN COMPUTER SCIENCES WITH 31 YEARS OF EXPERIENCE

WORKING WITH BANK OF AMERICA PYTHON QUARTZ IN THE LAST YEAR 19 YEARS USING PYTHON AND 10 YEARS USING PANDAS, DJANGO AND MONGODB PROFESSIONAL SUMMARY:

I am an experienced IT professional with 31 years of work experience. During my last project, I collaborated with Bank of America's Cleared Derivatives Risk Technologies team, utilizing Python Quartz Framework and JIRA to sup- port their work over a year.

I have been programming with Python for the past 19 years, using parallelism, and processing large volumes of information with SQL and Non-SQL databases building projects from scratch. Thanks to the use of Django and Pandas during the last 12 years was able to quickly generate reports and charts on Websites.

Recently created from scratch the project that managed to implement key technologies to accelerate the trans- mission of sales information from more than 550 gas stations, reducing the transmission time from 2 days to 30 seconds using Python technology, Django, Azure Cloud, MS SQL Server, Azure SQL, RabbitMQ, and Ubuntu Linux. The company previously took two days using night transmissions using linked server connections to the remote databases in the gas station's computers.

I developed a project from scratch that enables the automation of billing for up to 60,000 sales tickets per hour. The system targets tickets that are over 23 hours old and have not yet been invoiced to the customer. Additionally, I created monitoring reports to ensure the system operates correctly. Using multithreading Python technology, Cosmos DB graph mode using Gremlin, Neo4J database, PowerBI, and Azure SQL Developed the REST API web services for customer mobile applications from scratch using Django Rest Framework, RedisDB, Azure SQL, and SqlAlchemy for OxxoGas (a big gas station chain company in Mexico). With extensive experience in multithreading and parallel programming for the processing of high volumes of data using Python 3.

In the "Remote Support" department of FEMSA Comercio, I built the Python project from scratch that achieved the automation of audits and transmissions of software updates to more than 40 thousand store machines, auditing files, Windows registry, Windows events, and the configuration of the machines—using Python, Django, and SQL Server relational database and NoSQL MongoDB.

I also had the experience of being the technical leader of the Data Warehouse project I developed from scratch at FEMSA Comercio for 7 years using Python2.3, T-SQL, SQL, SQL Server Integration Services (SSIS), and PowerBuilder among other tools.

I have experience working with Python versions 2.3 through 2.7 and 3.1 through 3.12. https://www.linkedin.com/in/jose-rivera-merla-python-en/?locale=en_US

+1-512-***-**** Click Here To Schedule Call / Meeting ad4w6r@r.postjobfree.com

New Jersey, USA

In addition to my role as an IT engineer, I successfully managed a consultancy firm with two skilled engineer co- workers from 2012 to 2018. In 2005, I owned a healthy fast-food restaurant. Between 2005 and 2010, I purchased foreclosed houses, renovated them, and resold them. In 2010, I opened a clothing boutique. I am thank God, a versatile and capable person, with ease to find the simple solution to problems, to be able to achieve results.

TECHNICAL SKILLS

INFORMATION TECHNOLOGIES

Programming Languages Python, SQL, T-SQL, PL-SQL, Cypher, Gremlin, C, COBOL, bash scripting, Golang Database Programming SQL, T-SQL, PL-SQL, Cypher, Gremlin Relational Databases Microsoft SQL Server, Oracle DB, sqlite, Access, MySQL, Cosmos DB NonSQL Databases Redis DB, Mongo DB, Cosmos DB, Azure SQL, Sandra DB Graph Databases Neo4J, Azure Cosmos DB (Graph mode) Frontend Frameworks Bootstrap, JavaScript, JQuery, HTML/CSS, Plone, Power BI. Message Queue Technologies RabbitMQ, Kafka

Python Web Technologies Django, Plone, Zope, Flask Testing Frameworks Unit test, mocking, pytest, Selenium. Version Control Systems Git, Mercurial, Bazaar

Container Technologies Docker, Kubernetes

Python Technologies Pandas, Celery, PySpark, SqlAlchemy ETL Tools Oracle Warehouse Builder, SQL Server Integration Services (SSIS) Agile Methodologies Scrum, Kanban

Monitoring Software Nagios, Icinga, Grafana, Prometheus Cloud Environments Azure, AWS

TECHNOLOGIES MOST RECENTLY LEARNED NOT APPLIED IN THE WORKPLACE: Golang, PySpark, Google Cloud

CERTIFICATION:

• Developing Applications on AWS Nov 05,2023 Click to See Certificate

• Containerized Applications on AWS Jan 15,2024 Click to See Certificate

• Microsoft Certified: Azure Fundamentals July 24, 2019 with Certification Number: H197-0019

• Hacker Rank Certificate: SQL (Advanced) September 19, 2023 Click To See Certificate

• Hacker Rank Certificate: Python (Basic) September 15, 2023 Click To See Certificate

• Microsoft Certified: Azure Administrator Associate August 28, 2019 Valid until August 28, 2021 Certification: H930-7602 EDUCATION:

Bachelor’s Degree in Computer Sciences, Universidad Autónoma de Nuevo Leon, México. 1989-1993 LANGUAGES

• Fluent in reading, writing, speaking, and listening in English.

• Native in reading, writing, speaking, and listening in Spanish.

• Basic in reading, writing, speaking, and listening in Hebrew. PROFESSIONAL EXPERIENCE:

PETCO MX QUERETARO, MX TEAM LEADER/PYTHON DEVELOPER DEC 2023 – CURRENT PETCO MEXICO PROJECTS

To lead the team in applying best practices in IT, Python, and AWS technologies for various projects. PROJECT RESPONSIBILITIES AND ROLES:

• Get an understanding of the current projects by reading the documentation available.

• Apply Test Driver Development methodology.

• To implement clean architecture in projects for easier modification and support.

• To implement decorators for system functions to implement driven by contract strategy.

• Assist the team in designing a better architectural approach.

• Suggest best practices for designing and coding the following projects. Technologies: Python 3, AWS, DynamoDB, Lambda Functions, Docker, Flask INNOVA SOLUTIONS JERSEY CITY, NJ APPLICATION DEVELOPER IV AUG 2022 – SEP 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 conduct in-depth analyses of risk exposure and make strategic decisions. Utilizing the Bank of America Python Quartz Framework 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, Flask GLOBALAPPS AUSTIN, TX, USA SR PYTHON DEVELOPER MAR 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

OXXOGAS MONTERREY, NL, MEX PYTHON WEB ARCHITECT JUL 2018 – FEB 2022 PROJECTS LIST – PROJECTS CREATED FROM SCRATCH

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 system 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 Bill- ing 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) in the configuration file of the system.

• Set up command line options to monitor the system processing the information. Technologies: 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 depressurized. 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 ex- traction 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 generated 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-gener- ated 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 OXXO, MONTERREY, MEX SENIOR PYTHON DEVELOPER FEB 2011 – JUL 2018 PROJECTS LIST – PROJECTS CREATED FROM SCRATCH

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 re- view 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 Multithreading, 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 ta- bles 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.

PROJECT RESPONSIBILITIES AND ROLES:

• Create the ER model in the Django model.

• Deploy the model to the database.

• Setup the admin page in Django for management

• Create WEB reports of evaluation of the functions carried out by IT Advisors.

• Include in the audit process to extract activities from other systems. Technologies: Django, NGINX/Apache, HTML/CSS, Bootstrap, Python Multithreading, MS SQL Server, RedisDB 4) PROJECT: GOXXOGLE PORTAL (FEMSA COMERCIO)

Google-powered web portal for POS documentation, fault situations, and their solution, using a minimalist interface similar to Google to search by words or phrases within documents, or by searching for tags. PROJECT RESPONSIBILITIES AND ROLES:

• Set up the content management system server Plone for the project.

• Install the Linux utilities needed for parsing different files like MS Word Files, and PDF Files.

• Set up the theme for the portal.

• Codify the page of the search of documents emulating Google.

• Set up the user’s permissions to upload documentation or search it.

• Set up plugins to display the PDF on the screen. Environment: Linux, Plone, HTML/CSS, Python

5) PROJECT: POS MESSENGER PORTAL (FEMSA COMERCIO)

A Web portal was enabled to send messages that appear to the cashiers in the store machines. This is in order to communicate failures of electronic services and/or their correct functionality, seeking to avoid the loss of lost sales. PROJECT RESPONSIBILITIES AND ROLES:

• Set up the Plone server for the project.

• Design an ER model to store information in a database.

• Set up default messages allowed to be sent.

• Set up the admin Django page.

• Codify the multithreaded Python program for fast transmission of messages to remote computers. Environment: Linux, Plone, HTML/CSS, Python Multithreading, Ms SQL Server 6) PROJECT: TRANSMISSION CONTROL VIA EMAIL

An interface was enabled to start, stop, and audit the transmission processes from the transmission portal to the store ma- chines.

PROJECT RESPONSIBILITIES AND ROLES:

• Codify the Python script for reading emails received from the system account

• Set up the periodic execution of the script on the Linux server. Technologies: Linux, Python, Smtp, bash scripts, MS SQL Server 7) PROJECT: ON-DEMAND AUDIT CONTROL VIA EMAIL (FEMSA COMERCIO) To facilitate the audit of documents of the point-of-sale operation that are available for transmission and / or processing, an interface via email was enabled to trigger the audits of files in key directories of the point of sale in the machines of the stores. PROJECT RESPONSIBILITIES AND ROLES:

• Codify the Python script for reading emails received from the system account.

• Set up the periodic execution of the script on the Linux server. Environment: Linux, Python, Smtp, bash scripts, MS SQL Server. 8) PROJECT: PERIODIC EXECUTION OF VARIOUS AUDITS

Periodic execution and database storage were configured for consultation in reports via the Web of different audits, including: The devices connected, the restarts, the installed Windows updates, the list of programs installed, and settings registered in the Windows registry.

PROJECT RESPONSIBILITIES AND ROLES:

• Set up the Python program for connecting to remote computers and extracting information.

• Set up the ER model for storing the information and deploying it to the database.

• Set up the Django admin model portal.

Environment: Linux, Python, samba, winexe, bash scripts, powershell, multithreading, MongoDB, MS SQL Server 9) PROJECT: STORE TRANSMISSIONS PORTAL (FEMSA COMERCIO) This is a Web portal to configure transmissions to store machines, fulfilling a test cycle, test approval, transmission authoriza- tion, and transmission scheduling for a desired date and time. In addition to having visibility of the progress, the scope of the transmission and the update of the store machines, including a Log of the execution of the commands used during the update of each of the machines in real-time. Additionally, the transmissions have an audit process of the integrity of the transmitted files using SHA512 algorithms, thus confirming their correct transmission. The use of multipoint transmission protocols (peer-to-peer) was enabled to ensure suc- cessful transmission, ensuring the integrity of files from 3MB to 250MB or greater. PROJECT RESPONSIBILITIES AND ROLES:

• Set up a Plone server for the project.

Set up an ER model to store the information in the database.

• Codify forms for upload files to be transmitted to remote computers specifying cities, or computer names target, di- rectory, time of transmission, number of retries, and if it is going to be executed the file.

• Codify multithreaded Python program for transmission of files to specified remote computers.

• Set up Mongo DB for storing logs of the execution of files at remote computers.

• Set up the logic of Python program for transmission of big files using bit torrent protocol.

• Codify web reports for monitoring transmissions on progress status.

• Codify web reports for monitoring past transmission success. Technologies: Linux, Python, Plone, Samba, bash scripts, power shell, python multithreading, MongoDB, MS SQL Server, Tor- rents, Html/CSS

OXXO, MONTERREY, MÉXICO FREELANCER JAN 2010 – JAN 2011 PROJECT: MANAGEMENT OF ADVERTISING SPACE IN RETAIL STORES The administration of rental advertising spaces within retail stores for marketing campaigns or brand promotion of oneself or other organizations.

PROJECT RESPONSIBILITIES AND ROLES:

• Set up the Plone website and the corporation's theme.

• Codify the web page form for the management of retail spaces at the retail stores.

• Set up the ER model to store information in the database.

• Codify the web report of retail spaces at retail stores. Environment: Linux, Python, Plone, Python, MS SQL Server, Html/CSS PROJECT: OPTIMIZATIONS OF DATABASE PROCESSES

Improvements in the performance of various stored procedures for speed. PROJECT RESPONSIBILITIES AND ROLES

• Modify T-SQL stored procedures for better performance.

• Analyze indexes for fast processing of information. Environment: SQL, T-SQL, MS SQL Server

PROJECT: INDIAN CLOTHING STORE

Establish a store of imported Indian clothing for women PROJECT RESPONSIBILITIES AND ROLES

• Research for providers of products

• Find a location for a retail store

• Design marketing

• Hire sales clerk

Technologies: OpenOffice

OXXO, MONTERREY, MÉXICO PROJECT LEADER JUN 1998– JAN 2010 PROJECTS LIST

1. PROJECT: DATAWAREHOUSE PROJECT

2. PROJECT: QUALITY ASSURANCE IN THE BUSINESS INTELLIGENCE PROJECT. 3. PROJECT: A WEB PORTAL FOR THE DEVELOPMENT TEAM. 4. PROJECT: PORTAL TO REVIEW THE PROCESSING OF ALL THE TICKETS FOR SALES 5. PROJECT: PORTAL OF SALES OF MOBILE PHONE SERVICES 6. PROJECT: THE NEGATIVE INVENTORIES SYSTEM.

7. PROJECT: WEB PORTAL OF STORE ITEMS IN RETEK (ERP) VS CATALOGS AT POS. 8. PROJECT: WEB PORTAL OF CONVERSIONS OF GENERAL LEDGER ACCOUNTS. 9. OTHER PROJECTS

1) PROJECT: DATAWAREHOUSE PROJECT

System for analyzing sales, purchases, and inventories of products in all stores Femsa Comercio in all Mexico cities. PROJECT RESPONSIBILITIES AND ROLES

• Daily loads with automatic email notification of status and error information.

• Prepare information to load information through Batch Scripts.

• Optimizations of the database in SQL Server to speed up queries of the data warehouse project.

• Codify Powerbuilder client-server application for reporting of Data warehouse project.

• Set up reports of missing information to ensure data integrity and quality.

• Process the information and summarize the information of sales, inventory, and purchases for 12 thousand retail stores.

• Set up the “star” schema for the data warehouse project.

• Implement SSIS processes to load descriptions for dimension tables. Technologies: Python, PowerBuilder, SQL, MS SQL Server, SQL Server Integration Services (SSIS) 2) PROJECT: QUALITY ASSURANCE IN THE BUSINESS INTELLIGENCE PROJECT. Automated processes were made to accelerate the detection of problems and to help with the release on time of the Oracle BI Project. The automated processes were comparing data values between the database of the Data warehouse project and the new Business intelligence (BI) Database.

PROJECT RESPONSIBILITIES AND ROLES

• Create python processes to compare information between the data warehouse project and the BI project.

• Set up the Plone server for the project

• Codify reports for monitor differences between both projects Technologies: Linux, Python, MS SQL Server, Oracle DB, Plone, Html/CSS 3) PROJECT: A WEB PORTAL FOR THE DEVELOPMENT TEAM. A system designed to streamline communication within the team to share information about the systems, documen- tation, best practices, etc. It has been useful to accelerate the development and sharing of the experience of members to share knowledge and to save versions of software and project documents. Each team member has the freedom to organize their own information freely, automatic indexing of MS Office files, with a Blog as a fast easy view to the latest events on the computer. PROJECT RESPONSIBILITIES AND ROLES

• Set up the content management system server Plone for the project.

• Install the Linux utilities needed for parsing different files like MS Word Files, and PDF Files.

• Set up the theme for the portal.

• Codify the page of the search of documents.

• Setup the user’s permissions to upload documentation or search it

• Set up plugins to display the PDF on the screen. Technologies: Linux, Python, Plone, Html/CSS

4) PROJECT: PORTAL TO REVIEW THE PROCESSING OF ALL THE TICKETS FOR SALES Enhancements to the Tickets Web Portal to review the processing of all the tickets of sales of the more than 12,000 stores to a Data warehouse database on Oracle

Technologies: Linux, Python, Plone, MS SQL Server, Oracle DB 5) PROJECT: PORTAL OF SALES OF MOBILE PHONE SERVICES The system was created to monitor the level of sales and vendor performance. Technologies: Linux, Python, MS SQL Server, Plone, Html/CSS 6) PROJECT: THE NEGATIVE INVENTORIES SYSTEM.

The Web Dashboard to keep an eye on the existence of negative inventories in stores. This generates the indicators on inventory inconsistencies that might be problems with staff training for sales and purchases oper- ations of goods at stores or in the communications. Drill down option to look the information totalized by state, city, consultant, store, category of product and items. Indicators about the average number of items per store with a negative inventory. The Percentage of Stores that have a percentage of items above a specified percentage specified by the user with a negative in- ventory transmitted to the central systems.

Technologies: Linux, Python, MS SQL Server, Plone, Html/CSS 7) PROJECT: WEB PORTAL OF STORE ITEMS IN RETEK (ERP) VS CATALOGS AT POS. A system was created to ensure that all stores have the corrections to the catalog of items as specified in each city. Technologies: Linux, Python, Oracle DB, Plone, Html/CSS 8) PROJECT: WEB PORTAL OF CONVERSIONS OF GENERAL LEDGER ACCOUNTS. A system created to support the company's migration to Oracle Financials. The changes to accounting accounts for conversion of legacy systems to ERP and the Publication of news on the website of the conversion accounts modified or discharged, useful to track who made changes and when they were done. Technologies: Linux, Python, Oracle DB, Plone, Html/CSS OTHER PROJECTS

• Web Portal of Retail Invoices Issued.

• Project Nielsen PriceTrack

• Monitoring System of Electronic Airtime Sales

• Website to Monitor Sales in the Stores at the Customer Level

Contact this candidate