Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Hi, I’m
Gustavo Pinheiro
Data Analyst
Summary
Overview
17
years of professional experience
4
Languages
4
Certifications and counting..
Work History
Wiser Educação
Data Analyst
08.2022 - Current
Job overview
- Responsible for the backoffice Data Mart (Accounting, Financial and Conciliation)
- I increased the automatic identification of integration errors between systems by 60%, utilizing SQL Server to model a relational database and perform the cross-referencing of data between different databases.
- Conducted credit card conversion analysis using SQL queries in Google BigQuery to identify trends and patterns in customer behavior.
- In daily meetings with the IT Director, I provided several actionable insights to improve the conversion rate, including identifying the optimal timing for charge attempts, which scenarios were worth retrying after an initial rejection, and analyzing the cost-conversion ratio.
- ETL data from various sources using Python (e.g. BigQuery, SAP HANA, XLS and CSV files) into the database created.
Wiser Educacao
ERP Analyst
06.2022 - Current
Job overview
- Functional Analysis
- Technical and functional documentation
- Mapping and process optimization
Eleven Consultoria Em TI E Gestao Empresarial
IT Project Coordinator
09.2017 - 01.2022
Job overview
- Project Management with emphasis on maintenance and ERP TOTVS RM Backoffice solutions in various client organizations.
- Assisted in the setup and implementation of new features and ERP customization to maximize business efficiency and productivity.
- Project Management: Cost, Time, and Scope Management.
- Team management.
- Development of visual formulas (Microsoft Windows Workflow Foundation).
- Development of reports to the top management of the client.
Shop 126
IT Consultant
07.2015 - 06.2017
Job overview
- IT management consultancy / Functional consultant
- Development of cubes for financial analysis
- Data extraction via SQL Server with Excel integration
- Support to the IT manager in systemic and infrastructure routines
- Configuration of servers and equipment in general
- Creation of backup policy and storage parameterization
- Monitoring and corrections of integrations between Linx X TOTVS RM systems via SQL
- Cost reductions in all areas of the company, especially in the technology area
Implementation of store front and shop floor systems. - Organizational analysis for cost reduction.
- Elaboration and implementation of processes.
- Cash Flow Automation - Collection and consolidation of information from databases in real time through cubes
- Significant time savings and cost savings through the development of Excel x SQL Server Integration for automation and greater information reliability.
- I reduced the monthly cost of printing from R$48,000.00 to R$2500.00. As well as software and telephony licensing costs.
EBAM
IT Manager
02.2013 - 07.2015
Job overview
- Elaboration of the Information Technology Master Plan
- Integration of processes and ERP of the operational units in Brazil
- On-Premise Migration to Cloud Computing and server management
- Deployment of secure network with firewall (Fortinet) between branches in different states
- Survey and process optimization
- Process modeling (Bizagi) and integrations between ERP x BPM Software (Fluig)
- Technological planning of the company aligned with strategic planning and based on IT governance methodologies (ITIL, COBIT)
Solidez Assessoria em TI
Senior ERP Consultant
12.2009 - 03.2012
Job overview
- Responsible for the company's ERP – TOTVS RM
- Structuring of financial policies and ERP modeling in accordance with them
- System parameterization to fulfill all accounting and tax obligations automatically and electronically.
- Development of ERP TOTVS RM x Linx ERP integration through procedures in T-SQL
Delphi, Intech Soluções em TI
Programmer
11.2008 - 11.2009
Job overview
- Development in Delphi with Oracle and SQL Server databases.
- Analysis and restructuring of customer processes.
Prosoft By Alterdata
Support Analyst
11.2006 - 11.2008
Job overview
- Implementation and support of the Prosoft system
- Data extraction (Pervasive SQL);
- Management of the company's servers (Windows Server)
- IT consultancy to customers.
Education
Verified International Academic QualificationsWES
Bachelor of Science from Computer Science
06.2023
University Overview
Anhanguera EducacionalNiteroi
Bachelor of Science from Computer Science
06.2017
University Overview
Instituto Silva Serpa - Data ProcessingSao Pedro Da Aldeia
High School Diploma
11.2003
University Overview
Skills
Microsoft SQL Server
Transact-SQL
Microsoft Power BI
Exploratory Data Analysis
Google Cloud Platform (GCP)
Google BigQuery
Google Data Studio
Data Manipulation / Data Migration
Databases Design
Microsoft Excel
Data Analysis
Business Analysis
Python Data Analyst
Languages
English
Upper intermediate (B2)
French
Intermediate (B1)
Portuguese
Bilingual or Proficient (C2)
Spanish
Beginner (A1)
Certification
- Oracle Cloud Data Management 2023 Certified Foundations Associate
- SAS for Beginners
- SCRUM Fundamentals
- Functional Academy SAP Business One
Timeline
Data Analyst
Wiser Educação
08.2022 - Current
ERP Analyst
Wiser Educacao
06.2022 - Current
IT Project Coordinator
Eleven Consultoria Em TI E Gestao Empresarial
09.2017 - 01.2022
IT Consultant
Shop 126
07.2015 - 06.2017
IT Manager
EBAM
02.2013 - 07.2015
Senior ERP Consultant
Solidez Assessoria em TI
12.2009 - 03.2012
Programmer
Delphi, Intech Soluções em TI
11.2008 - 11.2009
Support Analyst
Prosoft By Alterdata
11.2006 - 11.2008
Verified International Academic Qualifications
Bachelor of Science from Computer Science
Anhanguera Educacional
Bachelor of Science from Computer Science
Instituto Silva Serpa - Data Processing
High School Diploma
Similar Profiles
Christopher BergeronChristopher Bergeron
VP of North American/European Sales at Wiser SolutionsVP of North American/European Sales at Wiser Solutions
Quinn RappQuinn Rapp
Property Maintenance Worker at Kerry and Christian WiserProperty Maintenance Worker at Kerry and Christian Wiser
Andressa OliveiraAndressa Oliveira
Sales Agent at Wise Up – WiserSales Agent at Wise Up – Wiser