João Cruz Email and Phone Number

During my time at Stone, I had the opportunity to lead several cross-functional projects, allowing me to engage deeply in every stage of the data life cycle—spanning bronze, silver, and gold data within an analytical platform.In the ingestion process, I was responsible for creating and maintaining data ingestion pipelines from our applications, utilizing technologies such as Python, Airflow, dataform, dbt PostgreSQL, SQL Server, Spark, and Databricks.Key projects… Show more During my time at Stone, I had the opportunity to lead several cross-functional projects, allowing me to engage deeply in every stage of the data life cycle—spanning bronze, silver, and gold data within an analytical platform.In the ingestion process, I was responsible for creating and maintaining data ingestion pipelines from our applications, utilizing technologies such as Python, Airflow, dataform, dbt PostgreSQL, SQL Server, Spark, and Databricks.Key projects included:- Data Warehouse Migration: Successfully migrated a data warehouse from Azure SQL Server to Google BigQuery, using Python, JavaScript, SQL, and Airflow as the orchestration tool.- KPI Implementation: Developed and standardized multiple KPIs across various companies within the Stone Group, ensuring consistency and alignment in measurement.- Query Migration and Schema Refactoring: Led the migration of raw queries to our BigQuery architecture while refactoring tables to align with our star schema design.I also had experience with:* Onboarding new people in my team and teaching our technologies and patterns. * Developing Platform features to be used by other's analytics engineers, such as data lineage scripts, dynamic dag generation, etc...* Refactoring queries to gain performance and reduce cost* Developing monitoring tools and creating unit tests. Show less

Creating pipelines to ingest data from multiple services into the data lake, working with the migration process of a data warehouse from Azure to GCP, supporting other team members in their jobs, planing and discuting new architetures to support different type of data demands.

Working to create machine learning and linear programming models for data-driven decision solutions. My job at the moment includes python programming, creation of data pipelines using Databricks and Kedro, also developing machine learning models using Sklearn, Keras and others ml libraries.

In this work a tool was developed from a prototype to automate the process of developing information systems. This tool follows the process model defined by the From Features to Frameworks (F3) approach, which is aimed at companies that develop several systems within a specific domain. The tool offers a graphic editor for the creation of domain models, from which the code and a domain-specific framework are generated.

Worked as assisting professor in undergraduate course of Algorithms and Data Structures III witch includes topics like graphs, algorithmic paradigm and character processing

Teaching Assistant Professor in Computer architecture 1 witch include topics like MIPS, assembly, RISC and CISC archiretures.

Worked as assisting professor in undergraduate course of Algorithms and Data Structures 1 witch includes C programming, for loops, conditional statements, conditional statement, functions and pointers.