Guilherme Dias

Website developed in Python-Django for Arquitetura de Eventos (a company that rents rooms for parties and sells services for these parties, such as music, food, drinks, decoration, etc.). The website consists of two main modules: - Sales: allows the seller to select services, prices, discounts, etc. for every party - Management: allows menage financial results. Profit and loss, cash flow, etc. Main tech stacks used: Django class-based views, Django ORM, Django Templates The site is currently being evaluated for the client https://arquiteturadeeventos.herokuapp.com/

TAX FRAUD AND TAX EVASION DETECTION (SINCE 2019) The work involves detecting tax fraud and tax evasion, i.e., from a poll of data to identify which taxpayer has the highest probability of being involved in tax fraud or tax evasion in a significant value. The first step of analysis consists in retrieving de data from a data lake (big data) using SQL. Then the retrieved data is analyzed using Python (Pandas and other technologies). Main development project: Accounting entry visualization through graph theory A data visualization tool to represent account entries with graphs (neo4j). This visual representation simplifies the analysis (of accounting information) and helps to identify tax fraud and tax evasion. LARGE TAXPAYERS COORDINATOR AND UNDER COORDINATOR (5 YEARS) Head of the Large Taxpayers national coordination with about 20 direct reports. Main development project: Large Taxpayer Dataviz Development of a data visualization tool to help to understand the tax behavior of the largest Brazilian taxpayers. The tool is responsible for extracting data (SQL), and processing data into visual information using the internal framework. LARGE TAXPAYERS LEADER Leader of the Large Taxpayers division with 6 direct reports. Main development project: Large Taxpayer Comparison through economic sector Tool that allows the comparison of the larger taxpayers with statistical information of the economic sector and other similar taxpayers. TAX FRAUD AND TAX EVASION DETECTION UNDER LEADER (3 YEARS) Team Management of an internal development team to build an internal framework for data analysis. The framework was mentioned by OECD as an international benchmark. Main development project: - Portal Copes Website developed in java that allows target and goals control for the tax fraud and tax evasion detection team. - Visual Script “No-code” programming platform to allow people who are not proficient in programming languages to develop new functionalities.

Responsible for four manufacturing areas in a powder detergent industry with 200 direct reports. Main development project: - Stochastic process control applied in pneumatic sulfate conveyor. The project consists in developing a tool to collect real-time data and plot charts to show if the process is working in normal conditions and reduces losses due to breakages. - Carbon footprint estimator. The project consists in developing a tool to estimate the carbon footprint of the usage of powder detergent.