Rafael D.

Data Analyst

Data Analyst
1/1/2020 - 1/1/2022

Proficiency developed in SQL, R, and Python for data analysis and scripting. Extensive experience using Tableau and Power BI for data visualization. Expert knowledge of Google Analytics and Adobe Analytics for web and customer interaction tracking. Demonstrated ability in statistical analysis and predictive modeling using machine learning algorithms implemented in Python libraries such as scikit-learn and pandas. Strong skills in data extraction, transformation, and loading (ETL) processes using Talend and Apache Nifi. Effectively collaborated in an Agile environment, utilizing tools such as JIRA and Confluence for project management and documentation. Developed and maintained relational databases in MySQL and PostgreSQL, and managed NoSQL databases with MongoDB and Cassandra. Contributed to improving customer experience by analyzing user behavior, segmenting audiences, and providing actionable insights to the marketing and product teams. Enhanced team productivity by automating repetitive tasks and developing custom dashboards and reports that streamlined data accessibility and interpretation.

Business Intelligence Consultant
1/1/2019 - Present

Served as a Technical Lead specializing in Power BI and SQL Server Analysis Services (SSAS), and also functioned as a Power BI Instructor. Key projects included tech governance and data centralization for multiple sectors such as Contracts, Payments, Budgets, Billing, Third Parties, and Compliance. Utilized tools like SharePoint, Flow Automate, Power BI (Tabular Editor, Dax Studio, Dataflow) to achieve these goals.

In a project for the financial controllership of a major company, managed and monitored aspects including Revenue and Profitability, Opex Management, Results, Taxes, and Investments using SSIS, SSAS, and Power BI (Tabular Editor, Dax Studio, Workspace Governance, Development Pipeline). Executed real-time monitoring solutions for highway load transportation through the Control Tower project.

Implemented a predictive mathematical model for HR to monitor resignations and promotions, and oversaw sales monitoring and daily target calculations using SQL, SSIS, and Power BI Server for a retail pharmacy chain.

Successfully migrated existing reports from Tableau to Power BI for an international logistics company, demonstrating proficiency in Power BI’s server management and data transformation capabilities.

Co-Founder
1/1/2018 - Present

During the role developed advanced proficiency in Business Intelligence tools and methodologies. Gained in-depth knowledge of data analytics, data warehousing, and visualization tools, ensuring high-quality content delivery to assist companies in adapting to the digital age. Responsible for facilitating the creation of lasting professional relationships by networking with user groups, partners, and major organizations. Coordinated sessions that provided immediate expert responses to industry-specific questions, leveraging insights from data analysts and user group leaders. Demonstrated skills in leading workshops, managing event logistics, and utilizing BI tools to enhance event quality and attendee experience.

BI and MS Project Consultant
1/1/2017 - 12/31/2019

Implemented and managed repair indicators for those impacted by the collapse of the Fundão dam in Mariana, MG. Collaborated with the Federal Government, DATASUS, IBGE, and related NGOs. Developed monitoring and reporting systems to track progress and ensure compliance with regulatory standards. Engaged in extensive data analysis and visualization to present findings to stakeholders.

In response to the truck drivers' strike, developed a project to monitor customer service and handle complaints effectively. Utilized customer relationship management (CRM) tools to track and address service issues promptly. Employed data analytics to identify common complaints and streamline resolution processes, ensuring timely and efficient communication with affected customers. Enhanced team coordination and task management through project management software to maintain service quality during crisis periods.

Sap/Abap - SD
1/1/2017 - 12/31/2017

Acquired extensive experience in ABAP, focusing on custom report development, module pool programming, enhancements, and BAPI implementation. Developed and optimized ALV reports, smart forms, and SAP scripts to improve data visualization and reporting efficiency. Demonstrated proficiency in data dictionary elements such as tables, views, and indexes, ensuring accurate data management and retrieval processes. Conducted performance tuning and code optimization to enhance system efficiency and reduce runtime errors. Utilized tools like SAP ECC, SAP CRM, and SAP S/4HANA extensively. Gained expertise in working with user exits, BADI, and enhancement spots to tailor SAP functionalities according to business requirements. Emphasized collaborative development using SAP Transport Organizer for effective version control. Participated in end-to-end project lifecycles including requirement analysis, design, development, testing, and deployment.

IT Governance
1/1/2016 - 12/31/2017

Developed proficiency in SQL, designing and optimizing complex queries for large-scale databases. Gained extensive experience working with Azure cloud services, including managing virtual machines, configuring storage solutions, and implementing cloud-based applications. Specialized in SharePoint administration, facilitating site creation, user permissions, and custom workflow automation. Demonstrated strong object-oriented programming (OOP) skills, applying best practices in software development. Familiar with tools and frameworks such as PowerShell for scripting and automation, Azure DevOps for continuous integration and deployment, and Power BI for data visualization and reporting. Ensured collaborative project management using agile methodologies, enhancing team productivity and project delivery.

Microsoft Student Partner
1/1/2015 - 1/1/2022

Engaged in activities focused on the development of projects, studies, training, and research. Leveraged technical expertise in Microsoft technologies, ensuring direct interaction with Microsoft Corporation for optimally executed solutions. Utilized advanced tools, frameworks, and systems to support and enhance project outcomes. Developed a deep understanding of various Microsoft platforms and services, contributing to the design, implementation, and review of innovative solutions. Employed collaborative project management techniques to facilitate cohesive team efforts and effective knowledge transfer. Enhanced skills in data analysis, pattern identification, and technical documentation while supporting ongoing learning initiatives and fostering a culture of continuous improvement within the technical team.

Professor Monitor
1/1/2015 - 12/31/2017

Served as a teaching assistant for Algorithm and Data Structures I and II, focusing on aiding Computer Engineering students. Developed expertise in C and C++, facilitating student understanding and application of these programming languages. Guided students through complex algorithmic concepts and data structures, ensuring they could implement and optimize various algorithms. Supported practical coding sessions, providing insights on debugging and code efficiency. Managed coursework and evaluations, ensuring accurate and fair grading. Played a crucial role in enhancing students' proficiency in computational problem solving and algorithmic thinking, streamlining their learning process and better preparing them for advanced topics in computer engineering. Ensured effective communication of technical concepts and maintained an encouraging learning environment.

Web Development Intern
1/1/2015 - 12/31/2016

Developed proficiency in PHP through the creation of essential modules for the Human Rights System of the Government of Minas Gerais. Automated complex database interactions to enhance efficiency and accuracy. Demonstrated expertise in SQL and database design to support robust data management solutions. Utilized frameworks and tools pertinent to PHP development and database automation, ensuring a seamless integration of the system components.

Extension Professor
1/1/2014 - 12/31/2016

Developed and taught a comprehensive curriculum in basic computer science and Lego Mindstorms NXT/EV3 robotics. Gained expertise in programming languages such as Python and Java, emphasizing their application in robotics. Utilized the Lego Mindstorms software suite extensively for instructing students in both visual and text-based programming environments. Enabled students to build and program robots capable of performing complex tasks by integrating sensors and actuators. Developed strong familiarity with the EV3 and NXT hardware platforms, including configuration, troubleshooting, and optimization of robot performance.

Methodically structured lessons to cover key concepts in algorithms, data structures, and basics of artificial intelligence as applied to robotics. Leveraged project-based learning to drive engagement and deepen understanding of computational thinking. Kept detailed progress reports and customized lesson plans using educational management systems tailored for STEM education. Facilitated coding bootcamps and competitive robotics challenges to foster teamwork and problem-solving skills. Employed classroom management software to track student progress and maintain an organized digital workspace. Promoted a hands-on approach to learning, encouraging experimentation and iterative design processes within the robotics framework.

Founder and Vice-President D.A.E.C.
1/1/2014 - 12/31/2015

Led the academic department for Computer Engineering while driving initiatives in innovation. Developed proficiency in fostering academic excellence through curriculum development, faculty collaboration, and resource management. Utilized advanced knowledge in various programming languages and frameworks such as PHP, Doctrine, and Silex. Conducted extensive work with Ext JS 4.2, NodeJS, and Vue.js, showcasing capabilities in both front-end and back-end development. Ensured robust data management using PostgreSQL and MongoDB, while also spearheading collaborative code maintenance practices using SVN and Git. Managed administrative responsibilities effectively, contributing to the continuous improvement of the institution's engineering programs.

Information Systems at Pontifical Catholic University of Minas Gerais
2016 - 2019

Computer Engineering at Pontifical Catholic University of Minas Gerais
2014 - 2016

Network Systems and Telecommunications at Senac
2011 - 2012

The term Hardware doesn't specify an educational degree. Could you please provide an actual educational degree or clarify your request? at Microlins
2009 - 2010

Management of Systems, Networks, and LAN/WAN at Microsoft Innovation Center
2012 - 2012

Microsoft Certified Trainers (MCTs) at MICROSOFT
1/1/2022

PL-300 Certification at MICROSOFT
1/1/2021