Rafael Dias Email & Phone Number

State Of São Paulo, Brazil

São Paulo, Brasil

• Designing, developing, and maintaining data solutions using Microsoft technologies such as SQL Server and Azure Databricks.• Building ETL pipelines using Python and Integration Services (SSIS) to integrate and transform data from various sources.• Developing and maintaining reports in Microsoft Report Builder (SSRS).• Leading data governance initiatives, ensuring data quality and compliance.• Facilitating access to internal areas such as Controlling, People… Show more • Designing, developing, and maintaining data solutions using Microsoft technologies such as SQL Server and Azure Databricks.• Building ETL pipelines using Python and Integration Services (SSIS) to integrate and transform data from various sources.• Developing and maintaining reports in Microsoft Report Builder (SSRS).• Leading data governance initiatives, ensuring data quality and compliance.• Facilitating access to internal areas such as Controlling, People Analytics, Human Resources, and Finance for self-service analysis using Power BI and Tableau.• Leading cloud projects on both the Microsoft Azure and AWS platforms, exploring scalable and flexible solutions for company needs.• Collaborating with internal departments to understand their data and business analysis needs and developing end-to-end solutions. Show less

São Paulo, Brasil

• Programming Logic: - Teaching fundamental concepts of programming logic, covering algorithms, control structures, and data structures, preparing students for the development of efficient and scalable software solutions.• Development in .NET Core (C#) and Python: - Conducting practical classes on .NET Core development using the C# language and Python, ranging from basic concepts to advanced object-oriented programming techniques and the development of web and desktop… Show more • Programming Logic: - Teaching fundamental concepts of programming logic, covering algorithms, control structures, and data structures, preparing students for the development of efficient and scalable software solutions.• Development in .NET Core (C#) and Python: - Conducting practical classes on .NET Core development using the C# language and Python, ranging from basic concepts to advanced object-oriented programming techniques and the development of web and desktop applications.• Data Area: - Instructing on the installation and configuration of database management systems, as well as DDL (Data Definition Language) and DML (Data Manipulation Language) commands, empowering students to design, implement, and manage efficient and secure databases.• Guidance on Integrative Projects: - Guiding classes on integrative projects, assisting students in the development of complete systems that encompass websites, desktop applications, and databases, focusing on the integration between different technologies and the delivery of functional and robust solutions.• Development of Practical Skills: - Promoting practical activities that enhance students' technical skills and problem-solving abilities, preparing them for the challenges of the technology job market.• Evaluation and Feedback: - Conducting regular assessments to track students' progress and provide constructive feedback, encouraging continuous learning and improvement of technical skills. Show less

São Paulo, Brasil

• Development of the SysPerso system: - Led the development of a complete system from scratch for the card personalization department, covering requirements gathering to product delivery and continuous maintenance. - Ensured that the developed system met the needs of all company clients, providing a flexible and scalable solution. - Developed business rules in SQL Server procedures as per management's requests. - Entire process documented and versioned for easy… Show more • Development of the SysPerso system: - Led the development of a complete system from scratch for the card personalization department, covering requirements gathering to product delivery and continuous maintenance. - Ensured that the developed system met the needs of all company clients, providing a flexible and scalable solution. - Developed business rules in SQL Server procedures as per management's requests. - Entire process documented and versioned for easy interpretation by the development team.• Construction of Data Warehouse and Dashboard: - Led the development of a data solution, from building the data warehouse to visualizing a dashboard displaying the progress of card production on a TV in the data processing department (CPD). This included data capture, transformation, and loading, as well as creating interactive dashboards for real-time monitoring. - Views of the quantity of cards produced successfully, with errors and breakdowns, by client, period, and machine. Show less

São Paulo, São Paulo, Brasil

✔ DataBricks✔ Data Factory✔ Desenvolvimento em Python✔ Data Lake✔ Responsável pela disseminação da cultura de dados da empresa.✔ Definição de Arquitetura e Engenharia de Dados utilizada para Data Analytcs e Data Science.✔ Desenvolver ETL, ELT e Ingestão de Dados✔ Conduzir o ciclo completo de análises estratégicas para suporte ao processo de tomada de decisão (Estruturação, Análise, Discussões e Conclusões)✔ Executar Análises de dados complexas (ex.: LTV, CAC… Show more ✔ DataBricks✔ Data Factory✔ Desenvolvimento em Python✔ Data Lake✔ Responsável pela disseminação da cultura de dados da empresa.✔ Definição de Arquitetura e Engenharia de Dados utilizada para Data Analytcs e Data Science.✔ Desenvolver ETL, ELT e Ingestão de Dados✔ Conduzir o ciclo completo de análises estratégicas para suporte ao processo de tomada de decisão (Estruturação, Análise, Discussões e Conclusões)✔ Executar Análises de dados complexas (ex.: LTV, CAC, Segmentação e análises comportamentais, inteligência competitiva).✔ Manter, validar e evoluir cockpits e análises estratégica✔ Criar cockpits e dashboards na ferramenta Power BI✔ Integration Services - ETL - SSIS Show less

São Paulo, São Paulo, Brasil

✔ Desenvolvimento Report com Tableau.✔ Desenvolvimento de Dashboards✔ Desenvolvimento de Padrões UX✔ Definição da Arquitetura de Dados - Star Schema✔ Desenvolvimento ETL - SSIS (Integration Services)✔ Desenvolvimento de Procedures em T-SQL e PL-SQL✔ Levantamento de Requisitos✔ Criação e Apresentação de POC.✔ Ministrar treinamentos internos

Bachelor’S Degree, Information Technology, Information Systems

Pós-Graduação Lato Sensu, Information Technology, Business Intelligence, Big Data E Analytics - Ciência De Dados

Disciplinas estudadas: • Modelagem e arquitetura do DW (Data Warehouse); • Integração e fluxo de dados (ETL); • Data Discovery, Olap e.