João Vitor Pinheiro Ocker Email and Phone Number
I'm a data analyst with a bachelor's degree with Summa Cum Laude in Economics from the Federal University of Santa Catarina (UFSC) and enrolled at the moment in a Master's Business Administration (MBA) in Data Science and Analytics at São Paulo University (USP), the best university in Brazil.My main bachelor's degree study subjects were econometrics, statistics, and financial markets, and in 2022 I was awarded the best undergraduate thesis in Economics in Santa Catarina, Brazil. Furthermore, I have experience as a Data Analyst and Business Intelligence Analyst from my previous and actual working experiences, with knowledge of tools such as Excel, Power BI, Tableau, SQL, and Python.I'm passionate about learning and always learning something new, as a hobby in my journey to learn the German and Spanish languages, or for my career in data analytics.Tableau profile: https://public.tableau.com/app/profile/jo.o.ocker
Ci&T
View- Website:
- ciandt.com
- Employees:
- 7593
-
Data Analyst (Systems Analyst)Ci&TState Of Santa Catarina, Brazil -
Business Intelligence AnalystUnimed Grande Florianópolis Aug 2023 - PresentTasks and achievements:- development of Extract, Transform, and Load (ETL) scripts in Python, resulting in a remarkable 80% reduction in manual Excel workload;- Integration of image recognition in the business process with Google's Tesseract OCR, to identify text and handle it as a data frame in Python, reducing the workload of at least 90% in the data wrangling;- Led the development of a web scraping (crawler) solution, designed to extract data from a website and store it in a .csv file. This initiative resulted in the complete automation of the data pipeline, significantly reducing manual workload.Tools:- Python (pandas, numpy, time, selenium, BeautifulSoup, os, re, pytesseract etc..);- Power BI;- Oracle Analytics;- SQL;- Looker;- Excel- Sheets. -
Data AnalystFepese - Fundação De Estudos E Pesquisas Socioeconômicos Apr 2022 - Feb 2023Florianópolis, Santa Catarina, BrasilParticipation in a project for the development of an intelligent environment in Power BI, focusing on the analysis and investigation of data and on understanding the needs and difficulties of stakeholders.Activities:- Development of dashboards and reports in Power BI with DAX and M language;- Data modeling;- Data wrangling with Python (Pandas, Numpy, Matplotlib, etc) and Excel;- Figma to create backgrounds. -
ConsultantLabtrans Apr 2019 - Jan 2021Florianópolis E Região, BrasilParticipation in logistics and transport projects with Brazilian national agencies linked to the Ministry of Infrastructure, such as SEP (Ports Department), SAC (National Civil Aviation Department), and ANTT (National Land Transport Agency), with the development of activities such as: - Projection of cargo movement between Brazilian port complexes and their commercial partners through econometric models within the scope of the PNLP - National Plan for Port Logistics; - Development of reports focusing on international road transport through a TED - Decentralized Execution Term - with ANTT; - Development and updating of electronic spreadsheets with different purposes, such as updating the Minimum Cost Simulator directed to SAC; - Presentation of info products to the stakeholders of the Port of Itaqui (Maranhão/Brazil).
João Vitor Pinheiro Ocker Education Details
-
Information Technology
Frequently Asked Questions about João Vitor Pinheiro Ocker
What company does João Vitor Pinheiro Ocker work for?
João Vitor Pinheiro Ocker works for Ci&t
What is João Vitor Pinheiro Ocker's role at the current company?
João Vitor Pinheiro Ocker's current role is Data Analyst (Systems Analyst).
What schools did João Vitor Pinheiro Ocker attend?
João Vitor Pinheiro Ocker attended Universidade De São Paulo, Federal University Of Santa Catarina.
Who are João Vitor Pinheiro Ocker's colleagues?
João Vitor Pinheiro Ocker's colleagues are Lucas Nery, Flávia Faria, Luis Otávio Nascimento, Pedro Vasconcelos, Helena Bulati, Camila Marchi, Anderson Barbosa.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial