Guilherme Lamb

- 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