Amado Roque Email & Phone Number

State Of São Paulo, Brazil

São Paulo, Brasil

- Architected the lakehouse and created the entire data product within Databricks, using PySpark and advanced SQL for pipeline creation and Databricks Workflows for orchestration.- Led the data engineering team, responsible for the architecture of Databricks and Dataiku platforms.- Participate the creation of infrastructure for Databricks using AWS (EC2, S3, Lambda).- Integrated various platforms, including the funds platform, Financial Systems, Air Table, Cognitos Form, and the BACEN website, with Databricks, developing analytical projects and data lake governance solutions.- Generated financial data tables used for creating analytical products, utilizing Amazon Redshift to share data from Databricks to Power BI.- Utilized GitLab for version control and CI/CD.- Facilitated data sharing for financial market regulation with all banks in Brazil.- Managed stakeholders by maintaining contact with senior leadership to develop problem resolution plans and strategies for ANBIMA's data engineering area.- Oversaw the governance and architecture of developments on the platform.- Reviewed and refined tasks on the Kanban board.

São Paulo, Brasil

- Led a team of three data engineers, providing technical mentorship, conducting code reviews, and facilitating collaborative discussions.- Developed a robust data infrastructure on Google Cloud Platform (GCP) to create a Delta Lake, establishing a comprehensive Customer Data Platform (CDP) and Master Data Management (MDM) solution.- Created a unified pipeline within GCP using Kubernetes, PySpark, and Airtable, integrating Hering's entire data flow into three layers: bronze, silver, and gold.- Architected and implemented data ingestion pipelines using Kafka connectors and brokers, ensuring real-time data flow from various sources including e-commerce sites.- Generated tables to connect to analytical products, such as Power BI and Qlik Sense dashboards.- Orchestrated deployment on Google Kubernetes Engine (GKE), enhancing scalability and performance.- Implemented Trino (PrestoSQL) as the query engine for efficient data retrieval, reducing costs compared to BigQuery.

Campinas, São Paulo, Brasil

- Acquired raw data, cleaned it, and transformed it into useful information from connectors such as Amazon S3, GCP, Facebook Lead Ads, Salesforce Marketing Cloud, Mixpanel, and e-commerce platforms.- Integrated multiple data sources, unified consumer profiles, and created/enriched customer attributes for targeted marketing.- Developed robust query solutions and integrated the Consumer Data Platform (CDP) with Salesforce, GCP, and AWS.- Developed data pipelines using DigDag, advanced SQL, and JavaScript.- Ensured data readiness for activation platforms such as Salesforce Marketing Cloud, Facebook Lead Ads, and Braze by preparing PII data according to each platform's requirements.- Collaborated with marketing teams across 20+ countries to execute product strategy and prioritize backlog items in Jira for sprint planning.- Utilized Azure DevOps for version control and CI/CD.- Developed training materials for non-technical stakeholders.- Created technical documentation using markdown documents in Visual Studio Code for the internal wiki.

Campinas, São Paulo, Brasil

- Created over 50 end-to-end applications showcasing KPIs for Logistics, Supply Chain, Manufacturing Efficiency, and Quality teams. These applications were displayed on factory kiosks, televisions, and tablets used by managers.- Acted as an analytics engineer, performing data analysis with Pandas, extracting insights for industrial engineering, implementing robust data transformations, and conducting insightful KPI analyses.- Developed and deployed applications on AWS cloud services, leveraging S3 for file management, providing a scalable and secure environment for data management and analysis.- Actively collaborated with cross-functional teams, such as Logistics, Supply Chain, Manufacturing Efficiency, and Quality, to understand requirements and deliver effective data solutions.- Developed intuitive front-end interfaces using Flask and Angular frameworks, allowing users to access dynamic dashboards, resulting in enhanced data comprehension and decision-making.- Created the back-end of the application using Python and Pandas, generating JSON files to display data in the front-end.- Used REST APIs to communicate the application with data stored in Amazon S3.- Stored data in Amazon S3 in JSON and Parquet formats for use in front-end dashboards.- Retrieved data from PCS and SAP using Pandas and SQLAlchemy, manipulated and cleaned the data, generated JSON files, stored them in Amazon S3, and created front-end dashboards.- Configured Raspberry Pi devices by installing Linux.

Campinas, São Paulo

- Created over 50 end-to-end applications showcasing KPIs for Logistics, Supply Chain, Manufacturing Efficiency, and Quality teams. These applications were displayed on factory kiosks, televisions, and tablets used by managers.- Acted as an analytics engineer, performing data analysis with Pandas, extracting insights for industrial engineering, implementing robust data transformations, and conducting insightful KPI analyses.- Developed and deployed applications on AWS cloud services, leveraging S3 for file management, providing a scalable and secure environment for data management and analysis.- Actively collaborated with cross-functional teams, such as Logistics, Supply Chain, Manufacturing Efficiency, and Quality, to understand requirements and deliver effective data solutions.- Developed intuitive front-end interfaces using Flask and Angular frameworks, allowing users to access dynamic dashboards, resulting in enhanced data comprehension and decision-making.- Created the back-end of the application using Python and Pandas, generating JSON files to display data in the front-end.- Used REST APIs to communicate the application with data stored in Amazon S3.- Stored data in Amazon S3 in JSON and Parquet formats for use in front-end dashboards.- Retrieved data from PCS and SAP using Pandas and SQLAlchemy, manipulated and cleaned the data, generated JSON files, stored them in Amazon S3, and created front-end dashboards.- Configured Raspberry Pi devices by installing Linux.

Araranguá E Região, Brasil

Estagiário para edição de imagem e mídias sociais.

Araranguá E Região, Brasil

Intern - IT Equipment Maintenance

Araranguá E Região, Brasil

Educational Game Developer for Regional Culture Inclusion - PROBOLSA UFSC