Caio Velasco Email & Phone Number

Barcelona, Ct, Es

Barcelona, Ct, Es

Rio De Janeiro, Brazil

Feng Brasil is an IT consulting firm that works with Brazil's top 10 football clubs. They built their online transaction systems and helped them become data-driven companies.Collaborating with Feng Brasil, an IT Consulting firm working with Brazil's top 10 football clubs.- Proposed and implemented a new Data Architecture solution to migrate their ETL processes from Pentaho to dbt-core using a 2-step approach: leveraging the dbt-DuckDB adapter for an Ingestion step from PostgreSQL to AWS… Show more Feng Brasil is an IT consulting firm that works with Brazil's top 10 football clubs. They built their online transaction systems and helped them become data-driven companies.Collaborating with Feng Brasil, an IT Consulting firm working with Brazil's top 10 football clubs.- Proposed and implemented a new Data Architecture solution to migrate their ETL processes from Pentaho to dbt-core using a 2-step approach: leveraging the dbt-DuckDB adapter for an Ingestion step from PostgreSQL to AWS S3 as parquet files, and dbt-Snowflake for a Transformation step following a Medallion Architecture, leveraging Snowflake’s External Tables as well as dbt incremental strategies for both SCD Type 1 and 2 methods.- This solution drastically reduced the time to complete their daily ETL processes from many hours to seconds, improving efficiency and cutting Snowflake compute costs.Main tech stack: Git, GitHub, AWS S3, Snowflake, dbt, SQL, Python. Show less

United Kingdom

Worked with IAG - International Airlines Group, one of the world’s leading airline groups, on a 3-month project to assist in migrating SQL code into dbt models of their ETL processes. Tech stack: PowerBI, Git, AWS, dbt, Snowflake, Python, and SQL.

New York City Metropolitan Area

Blue Orange Digital is recognized as a “Top AI Development and Consultant Agency,” by Clutch and YahooFinance, for innovations in predictive analytics, automation, and optimization with machine learning in NYC.At Blue Orange, I worked with business, product, data engineering, and data analytics. My tasks included:- Responsible for delivering customizable reporting tools (control panels, analytical dashboards, and tabular reports) for a major client in the real estate industry in… Show more Blue Orange Digital is recognized as a “Top AI Development and Consultant Agency,” by Clutch and YahooFinance, for innovations in predictive analytics, automation, and optimization with machine learning in NYC.At Blue Orange, I worked with business, product, data engineering, and data analytics. My tasks included:- Responsible for delivering customizable reporting tools (control panels, analytical dashboards, and tabular reports) for a major client in the real estate industry in the USA in topics ranging from IoT Sensors and Chatbot to Financial Reports and Property Management solutions.- Designing dbt models in SQL in Snowflake versioning with GitHub for a Unified Data Model solution that merges information across databases in a legacy system.- Supporting the development of a Semantic Layer that sits on top of a Unified Data Model by gathering information with the client to understand their business needs.- Managing multiple stakeholders (Data Engineers, Business Analysts, Product Designers) and ensuring that the client's expectations are met. Show less

United Kingdom

Used STATA and python for econometric data analysis to extract, clean, and structure micro-level data from the World Bank's Rural Socioeconomic Survey on African countries for a research project seeking to understand the relationship between climate change and agriculture productivity.Worked remotely from Brazil for Professor Juan Pablo Rud (Ph.D., London School of Economics).

Los Angeles, California

Tutor - Microeconomics, Statistics, EconometricsTeaching Assistant - Microeconomics for Public AffairsResearch Assistant for Professor Adriana Lleras-Muney in the UCLA Department of EconomicsCapstone Project (Honors): An Action Plan for Santa Clarita: Towards a Better Homeless Count in L.A. County’s 3rd-Largest City

Greater Los Angeles Area

. Jorge Paulo Lemann Fellowship for top Brazilian Students with Academic Excellence. UCLA Luskin Graduate Fellowship for Outstanding Academic Excellence. UCLA MPP Alumni Leadership and Service Fellowship. UCLA Financial Aid (Need-Based Grant). UCLA Luskin Math Review Tutor (for incoming MPP students). UCLA Club Soccer Team (Central Forward/Second Striker)

Brazil

After self-studying for the GRE and GMAT, I learned a lot about the exam and scored on the 94th percentile in the mathematics exam. This experience motivated me to develop MePrepara. MePrepara is an fully automated online platform that provides students in Brazil with 140 carefully designed online lectures for the GRE and the GMAT quantitative sections as well as over 300 exercises and a comprehensive 60-day study plan.I believe that every student should have equal access to… Show more After self-studying for the GRE and GMAT, I learned a lot about the exam and scored on the 94th percentile in the mathematics exam. This experience motivated me to develop MePrepara. MePrepara is an fully automated online platform that provides students in Brazil with 140 carefully designed online lectures for the GRE and the GMAT quantitative sections as well as over 300 exercises and a comprehensive 60-day study plan.I believe that every student should have equal access to educational resources, such as the best advisors, relevant information, and a comprehensive preparation course for a fair price. Show less

São José Dos Campos Area, Brazil

Closely examined two major private schools’ operations (staffing structure, budget preparation, education systems).Developed an in-depth diagnosis and a plan of action for improvements.AOG Consultoria Educacional is a consulting company focused on strategic consulting projects with tailor-made solutions for major private schools in the northeast and southeast regions of Brazil.

Rio De Janeiro Area, Brazil

NASDAQ: STNEA small group of partners with strong entrepreneurial backgrounds started Stone Payments, a fintech in the Brazilian Payments and Credit Cards industry.I was Stone Payment's first employee, working directly with the founding team. I helped develop Stone's Center of Financial Operations, from scratch. COF is where all the reconciliation process happens (Chargeback, Cancellation, Anticipation, etc).I studied thoroughly the entire merchant-acquiring side of the… Show more NASDAQ: STNEA small group of partners with strong entrepreneurial backgrounds started Stone Payments, a fintech in the Brazilian Payments and Credit Cards industry.I was Stone Payment's first employee, working directly with the founding team. I helped develop Stone's Center of Financial Operations, from scratch. COF is where all the reconciliation process happens (Chargeback, Cancellation, Anticipation, etc).I studied thoroughly the entire merchant-acquiring side of the Payment Card Industry in Brazil starting with the credit cards transactions technicalities, designing everything that involves the accounting & operational flow, as well as the reconciliation process that happens among the main players in this market: Card Associations (Visa, MasterCard, Amex, Diners), Merchant-Acquirer (Paymentech, First Data, Global Payments, Cielo, Rede), Issuing Banks (Itau, Bradesco, JP Morgan Chase, Banco do Brasil, Panamericano) and Clearing Houses.The company has hit over $3 billion in valuation. Show less

Rio De Janeiro Area, Brazil

Teaching Assistant to undergraduate students.Calculus IV: Partial Differential Equations, Fourier Series, Series Solutions of Second Order Linear Equations, Laplace Transforms, Boundary Values Problems, Infinite series

Master Of Public Policy (Mpp) With Honors, Economics, Econometrics, Data Analysis

Lemann Fellow @ Jorge Paulo Lemann Fellowship for academic excellence Luskin Fellow @ UCLA Luskin for academic excellence MPP Alumni.

Phd In Economics, 5-Year Program (Unfinished), Economics

(To help my family during the Covid-19 pandemic, I had to quit the program and later transitioned into Data Science.) I was accepted.

5-Year Bachelor Of Science, Mechanical Engineering, Highest Gpa Student

• 2012 - Top 1% Student - Graduated with the highest GPA among the Mechanical Engineering Undergraduate Students • 2012 - Coppead/UFRJ.

Economics

Advanced-level preparatory course in Mathematics, Microeconomics, Macroeconomics, and Econometrics.

Certificate - Pre Mba

I was selected by the Yale School of Management among 60 high-achieving young professionals from all over the world from populations.

Study Abroad - Undergraduate Student, Mechanical Engineering - Exchange Program, Gpa 3.9

Achieve a grade of 3.9 out of 4. Senior Level Courses taken: MAE 403 - Air Conditioning MAE 407 - Steam and Gas Turbines MAE 408.

High School, Mathematics, Physics, And Chemistry

Top 10% Student (Olympiad-Level Preparation Course - Advanced Mathematics, Advanced Physics, and Advanced Chemistry) The Military School.