Requests
0
Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
AB Inbev - BEESAnalytics Engineer
Nov. 2024Brazil, São PauloMain Responsibilities:
Managed CI/CD processes (Git/Azure DevOps) for Power BI dashboards,
ensuring efficiency and scalability when handling large data volumes (10
million+ rows).
Conceptualized and designed user interfaces for new dashboards using
Figma.
-
Created and validated tables within SQL databases.
-
Performed data cleaning and transformation using SQL, Python, and PySpark
on Azure Databricks.
Main Achivements:
-
Developed a Labeling Tracking Dashboard, integrating data from sources
exceeding 10 million rows.
Engineered complex SQL queries to ingest datasets with over 10 million rows
into dashboards.
Built multiple data pipelines in Databricks using Python (Pandas, PySpark) to
generate and maintain database tables.
Atmosphere CapitalData Engineer
Jun. 2024 - Nov. 2024Brazil, São PauloMain Responsibilities:
Suggest, find, and extract relevant data on invested sectors
Data extraction by web scraping (selenium, beautifulsoup) and APIs
Data pipeline automation (with Python), from extraction and cleaning to
uploading to a NoSQL (MongoDB) database.
-
Creating dashboards in PowerBI to facilitate analysis
-
Applying statistical models using Python’s library statsmodels
-
Automation of analysis spreadsheets in Excel using Python.
Main Achivements:
-
Automation with python of a spreadsheet of the price curves of many fuels
(coal, natural gas and etc) and energy prices (spot and forward) in the US
using bloomberg as a source.
Finding, extracting, cleaning ,wrangling and loading data of photovoltaic
panels in the US, Netherlands, Spain, Germany, United Kingdom, Portugal in
an automatized way on a monthly basis. And, afterward, creating a PowerBI
dashboard for visualization and monitoring of the sector.
Neogrid Infromatica LtdaData Analyst
Aug. 2023 - Jun. 2024Brazil, São PauloMain Responsibilities:
Data cleaning and wrangling (python, pandas, SQL, Excel)
Creation of PowerBI dashboards
Automatization of recurring reports
Creating reports for upper management with metrics such as MRR, Churn,
Down-sell, Upsell, Cross-Sell for each product of the company.
Data Visualization (seaborn, matplotlib, powerBI, PowerPoint)
Aid in internal database rectification tasks
Main Achievements:
Cleaning and padronization of more than 30 files from the financial
department to a SQL database.
Automatization of reports, reducing the time to make it from 1,5 weeks to 1
day.
Creation of a dashboard that facilitated the visualization of key metrics for
every product in the company.
Realization of a Study volumetry averages to update the MRR of the
company, utilizing backtesting and metrics such as standard deviation to
measure the impact.
Analysis of revenue concessions to clients (such as discounts and revenue
suspensions) recommending processes improvements and identifying
product problems.
Kinea Investimentos LtdaMiddle Office Analyst
Dec. 2021 - Mar. 2023Main Responsibilities:
- Coding scripts to automate processes (Python and SQL)
- Verify Margin Calls for Infrastructure and hedge funds
- Responding to emails from clients and service providers
- Calculate the monthly dividend distribution for infrastructure funds
- Check shares and NAV value for hedge funds.
- Lending/Borrowing Stocks (BTC)
- Uploading and checking Government Bonds operations
- Checking BM&F and Stocks operations - Maintenance of scripts in Python Main Achivements:
- Creating Python scripts for daily reconciliation of lent/borrowed stocks positions.
- Creating a Python script for daily reconciliation of uncovered short sale positions for D0.
- Ensuring that all public fixed income, equities, futures, and options operations were being settled at the correct times.
- Ensuring a response to all client emails within 1 day.
Kinea Investimentos LtdaMiddle Office Intern
Jun. 2021 - Dec. 2021São Paulo, BrazilMain Responsibilities:
- Lending/Borrowing Stocks (BTC)
- Uploading and checking Government Bonds operations
- Uploading and checking BM&F and Stocks operations - Maintenance of scripts in Python Main Achievements:
- Learning and executing vital processes to the company, which included the settlement of millions of reais (Brazil’s currency).
- Maintenance and minor improvements to code (Python and SQL)
- Daily contact with brokers to ensure settlements of stock lending and public fixed income.
Intch is a Professional Networking App for the Future of WorkSee more people like Jose Francisco on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
1026939 people
16
Diretor de Tecnologia da Informação e Comunicação
27
Project Manager (PMP) | Process Improvement, Onboarding & Workflow Optimization
194
Engenheiro de software - Sênior
78589 people
16
Diretor de Tecnologia da Informação e Comunicação
17
Data Analyst @ INOVAI DESENVOLVIMENTO DE SOFTWARES LTDA
17
Engenheiro de Planejamento @ Infotec Consultoria e Planejamento LTDA