Jonas Coelho Email & Phone Number

Spain

Rio De Janeiro, Brazil

• Responsible for leveraging data to drive strategic decisions, enhance customer engagement, and optimize operational efficiencies. Here is an overview of my contributions and areas of expertise:
• Advanced Data Handling: Expert in querying and managing large data sets with AWS Athena, Redshift, and MongoDB, using SQL and NoSQL for comprehensive analysis.
• High Complexity Reporting: Skilled in generating reports and visualizations using Python, Quarto, and PowerBI, enhancing data-driven decision-making.
• Model Development: Developing predictive models for customer segmentation, behavior forecasting, and fraud detection, using Python to drive business strategies.
• Process Optimization: Proactively identifying and correcting errors in ETL processes, ensuring data accuracy and reliability across platforms.
• Strategic Tool Integration and Innovation: Skilled in utilizing industry-leading tools like Salesforce, Mixpanel, Notion and diverse APIs for effective management and validation of data along with project collaboration.

Rio De Janeiro, Brazil

• I spearheaded key data-driven projects that propelled significant social and organizational advancements. Operating within a compact, agile team, my role involved not only managing diverse datasets but also innovating.
• Structuring of massive data related to public education, acquisitions by governmentalagencies, corporate records, and other public data (R, PostgreSQL and BigQuery).
• Production of detailed and comprehensive reports based on novel findings stemmed from exten-sive data analysis (RMarkdown, GGplot, Matplotlib, Plotly).
• Automatization of data collection via web scraping and API requests (Selenium, Requests).
• Maintenance of Chatbots to integrate end-users to complex databases (PostgreSQL, Javascript,RESTful API).
• Development of predictive and classification models (scikit-learn, R-caret)

Pittsburgh, Pennsylvania, United States

Responsible for co-developing a deep learning algorithm using PyTorch, aimed at identifying structurally damaged buildings within the city of Baltimore. This algorithm harnessed aerial image processing of the city in conjunction with tabular housing data. Remarkably, it achieved a precision rate exceeding 91% in identifying high-risk structures. The.

• Produced studies and reports that aimed to assess the level of public transparency in Latin America
• Searched and obtained new databases via Freedom of Information requests

Master'S Degree, Public Administration

Classes focusing on advanced statistical methods for public policy analysis and political science studies. CAPES Scholarship

Bachelor'S Degree, Law

Exchange program Santander Ibero-American Scholarship

Minor, Applied Mathematics

Introduction to computing, mathematical modeling and programming languages.

Bachelor'S Degree, Law