Guilherme Lamb

Data extraction, transform, and loading using Python and Pyspark with Databricks and Azure Data Flow; Development of ETL/ELT pipelines using Azure Data Factory and Databricks Jobs; Data ingestion through APIs; Code versioning using GitHub; Elaboration of dashboards in Power BI; Owned end-to-end data pipelines, implementing linear regression models for FinOps, providing visibility into cost trends and enabling strategic budget optimization.

- Data collection, cleaning, and processing using Python and Pyspark inside Databricks environment; - Development of ETL/ELT processes using Azure Data Factory and Databricks Jobs; - Data ingestion through APIs; - Development of tables in different layers (Bronze, Silver and Gold); - Code versioning and CI/CD using Azure DevOps; - Query optimization; - Assist business team with complex SQL queries.

- Point of contact between technical team (data engineering/data science) and business area; - Data analysis and management of the data-driven supply; - Development of a sales forecast model based on inventory turnover; - Development of a model for detection and treatment of anomalies in sales forecast data; - Development of Python/Pyspark scripts to automate tests; - Development of ETL pipelines; - Query optimization; - Query in databases using SQL; - Development of dashboards using Power BI/Databricks.

- Worked in the data processing team, responsible for data collection, wrangling, and processing using SPSS, Alteryx, and Python; - Development of ETL process using Alteryx; - Elaboration of dashboards in Excel and Tableau; - Elaboration of a prioritization matrix, using linear regression; - Assistance in the elaboration of questionnaires using softwares like Qualtrics and Sawtooth.

- Collect, treatment, and analysis of equipment data; - Development of performance indicators (KPI's); - Preparation of consulting reports for clients; - Participation in research and development projects (acting from the elaboration of scope, requirements matrix, risk assessment, physical and financial schedules, and return on investment calculations to subsequent execution and progress measurement); - Conducting consultancy in energy efficiency (electrical, thermal, and steam reuse).

Exchange student