João Rogeiro Email & Phone Number

A Coruña, GA, ES

A Coruña, Galicia, Spain

Lisbon, Portugal

• Belong to the Traffic Acquisition (Performance Marketing) team (engineering group), working with the data and analytics groups.
• Developed ETL Python code using Snowpark and Pyspark.
• Ported code from Pyspark to Snowpark with a strong focus on improving efficiency and maintainability.
• Created tools exposing their functionality through Jupyter Notebooks to be used by analysts.
• Setup of CI/CD pipelines (GitLab) and infrastructure (in AWS, moving away from on-prem Jenkins) to streamline software release and deployment processes.
• Moved some aspects of the operation from on-premise infrastructure to Snowflake and AWS (IaC using Terraform).

Lisbon, Portugal

• Worked almost 10 years in the Hydraulics and Environment department's IT group, 5+ of those leading most of the backend development and operation.
• Designed solutions in collaboration with multidisciplinary teams.
• Mentored 3 internships.
• Designed and developed a framework and platform for running production operational forecast systems, allowing to automate the whole life cycle of these systems.
• Developed software integrations (execution of Fortran modeling/simulation software, ETL data workflows, infrastructure and deployment tools, etc...), resulting in streamlined data flows.
• Developed (backend) simulation solution for energy efficiency in buildings.

Lisbon, Portugal

• Developed and implemented user interface features for the company's point-of-sale software platform.
• Collaborated with cross-functional teams to streamline and enhance the UI, resulting in a more pleasant user experience in small display devices.
• Assisted in troubleshooting and resolving technical issues, ensuring smooth functionality of the software.