José Gabriel Email & Phone Number

State Of Minas Gerais, Brazil

Main tools used:- SQL (Construct intricate queries, including CTEs, JOINs, and Window Functions)- AWS (S3 and Athena)- Python (Develop advanced ETL and ELT processes, Functions, Classes and bug detection)- Metabase (Visualization by writing SQL queries and utilizing Metabase's built-in functions)- PowerBI (Implement advanced data modeling and analytics using DAX and M Languages)- Power Query (ETL, ELT, Data pipeline, Automation)- Dbeaver (Primary SQL database management tool)- Excel and Google Sheets (Data analysis and reporting)Main responsabilities and key achievments:- Conduct in-depth data analysis within the iGaming and Gambling industry, generating valuable insights for management. Implement ETL processes for handling billions of data points, creating metrics at both macro and micro levels—from GGR to granular analysis of individual players, including fraud detection.- Maintain strong alignment with industry trends and management objectives, bridging the gap between data-driven decision-making (soft skills) and the development and analysis of data using advanced analytical tools (hard skills) to foster a data-driven culture.- Develop and implement KPIs across all departments (internal clients), including CRM, Marketing, Technical, Customer Experience, and C-Level, empowering these teams to enhance the player experience through data insights.

São Paulo, Brazil

Main tools used:- Excel (Advanced VBA language)- Python (Data ETL, ELT, Automation, Data pipeline, Web scrapping)- PowerBI (Advanced DAX and M Languages)- Power Query (ETL, ELT, Data pipeline, Automation)- Data Warehouse (PostgreSQL)- APIs/WebAPI- Azure Virtual Machine- GIT/GitHubMain responsabilities and key achievments:- Automate data extraction, transformation, and loading (ETL) processes within Excel using Visual Basic for Applications (VBA).- Perform ETL tasks in Python using many libraries for interacting with databases (PostgreSQL, Excel)- Design and implement a data pipeline using Python, incorporating APIs for data retrieval and manipulation.- Employ Python for web scraping activities, extracting data from websites for further analysis and integration. - Implement Robotic Process Automation (RPA) using VBA, Visual Basic .Net, and Python to automate tasks across Microsoft Products, web browsers, APIs, and collect data from various software applications. Mercado Livre was one of the clients who benefited from my work as a Automation Engineer- Convert static automations created in UiPath and PowerAutomate to dynamic automations using VBA and Python for enhanced flexibility and customization.- Utilize version control with GIT/GitHub for collaborative development, tracking changes, and managing code repositories.- Develop interactive dashboards in PowerBI for external clients, providing visual representations of data insights and trends. Mercado Livre and Careplus were two clients who benefited from my work as a PowerBI Consultant.

Belo Horizonte, Minas Gerais, Brasil

Main tools used:- Google Sheets- Google Cloud Platform (GCP)- Data Warehouse (Google Big Query)- SQL Language (DQL, DTL)- Excel (Advanced VBA language)- Python (Data ETL, ELT, Automation, Data pipeline, Email integration)- PowerBI (Advanced DAX and M Languages)- Power Query (ETL)- APIs (Nibo and Pacto Softwares data retrieval)Main responsabilities and key achievments:- I automated the entire Income Statement (DRE - Demonstração do Resultado do Exercício) process for the accounting department at Pratique Fitness. Using Python for ETL automation, I initiated the process by gathering data through the Nibo and Pacto software APIs and Google Big Query. I performed data treatment on financial values, including handling semi-structured data (JSON). This involved creating tables summarizing the amounts paid/received for each unit and sending the summary to the managers and CEO via email. The automation covered all 90 gyms in the network and involved processing data for over 100 thousand gym members.- Conducted ETL processes and data analysis using PowerQuery, Excel, Google Sheets, PowerBI, Python, and Google BigQuery.- Leveraged Google Cloud Platform (GCP) tools for efficient data handling.- Developed impactful dashboards using PowerBI, collecting data from diverse sources and employing frameworks such as Python, Google BigQuery, and PowerQuery.- Ensured data accessibility to all partners and senior management, facilitating informed decision-making.

São Paulo, Brasil

Main tools:- Python (Back end)- JavaScript (Front end)- HTML- CSS- React- GraphQL- Swagger- WebAPIMain responsabilities and key achievments:- Build Front-End applications with JavaScript, HTML, CSS and React - Back-End using Python, GraphiQL and Swagger

São José Dos Campos, São Paulo, Brazil

Main tools:- Python (Automation, Data analysis)- R Language (Machine learning)- SQL Language (DQL, DTL)- Excel (Advanced VBA)- PowerBI- Oracle SQL Developer- SQL ServerMain responsabilities and key achievments:- A significant achievement was the completion of the development of a monthly report, made available to all commercial aviation clients of Embraer, as well as the entire executive leadership. It was my responsibility to segregate data from Africa and Oceania, making the report more comprehensive. Additionally, I developed the entire automation structure (pipeline) using VBA and Python.- Design and construct macros using VBA scripts with a primary focus on data analysis, ETL processes, and automation. Leverage VBA's capabilities to enhance data-driven insights and streamline operational workflows.- Use SQL language to make queries on SQL Server and SQL Developer, retrieving data from Embraer comercial aviation costumers. Use this data to build reports and dashboard in PowerBI and Excel.- Employ data analysis techniques using Python, including Pandas, Numpy, xlWings, and OpenpyXl, in conjunction with Excel. Harness the power of these tools to extract meaningful insights, manipulate data, and drive informed decision-making.

Belo Horizonte, Brasil

Main tools:- Excel (Advanced VBA, Pivot Tables)- AMOS SoftwareMain responsabilities and key achievments:- Boeing 737/700/800/MAX Work Order Management and Engineer Support- Help technicians translate Boeing work orders into technical English and improve their comprehension- Comprehensive Administrative Duties- Excel-Based Data Analysis- Data Visualization Expertise

Bachelor'S Degree, Mechanical Engineering

Data Science, Computer And Information Sciences, Math And Statistical, 9.3

Learning to deal with: - Big Data (ETL, Data Lake, FastData) - Data Engineering (SBGD's SQL e NoSQL) - Database (SQL Server, SQLite.