Renan Muniz Email & Phone Number

São Paulo

- Design and implement dimensional data models to facilitate the analysis of large volumes of data from various sources, using concepts such as facts, dimensions, data hierarchy, data grouping, aggregation, and others, and develop and maintain interactive dashboards and visually appealing reports in Power BI and MicroStrategy.- Collaborate with internal and external teams to understand data analysis requirements and provide solutions that meet business needs.- Design, develop, and implement efficient and scalable data pipelines using Pentaho Data Integration (PDI) and Iway Data Migrator, ensuring data integrity and reliability.- Perform complex data analysis and transformations using SQL and other tools, ensuring the delivery of actionable insights for informed decision-making.- Identify and implement performance improvements in data processes, optimizing SQL queries, adjusting pipeline configurations, and refining data models.

Campinas, São Paulo, Brasil

• Implementation of the data department.• Coordination of the data team and task assignment.• 40% reduction in customer churn rate.• Implementation of Tableau Server and Desktop in the company.• Application of statistical knowledge to conduct analyses with insights easily communicated to different sectors of the company.• Identification and tracking of primary and secondary KPIs. Development of dashboards (Tableau) providing insights and promoting self-service for stakeholders across the organization (marketing, operations, digital).• Support for executive meetings regarding the integrity of sales-related data and company results.• Leadership in creating and maintaining robust data pipelines, ensuring data integrity and availability for analysis.• Tableau Server administrator.• Data modeling in Postgres to support Salesforce users.• Conducting user panel tests (Salesforce) and collaborating with the business team and developers to resolve issues.• Development of recommendation algorithms, driving personalization and user experience.• Translation of business-related questions into data analyses and studies. Working closely with the business department to uncover insights.• Conducting meetings with different teams to clarify and address questions related to data integrity.• Monitoring data quality with data engineers to add new data fields and implement data quality rules in the data lake.• Monitoring sales reports and overseeing the remediation of data integrity issues.

Fortaleza, Ceará, Brasil

• Support for the CRM planning department in identifying the customer lifecycle and CRM campaigns for each stage, utilizing strategic triggers.• Basket Analysis and Customer Clustering.• Conducting presentations of studies and participating in briefing meetings for the studies to be developed.• Support in the execution of a product recommendation system based on purchase history, profile, and marketing strategy.• Measurement of email and SMS campaigns.• Conducting analysis of large datasets to identify patterns and trends, contributing to informed strategic decisions.• Development and implementation of predictive models to optimize operational processes, resulting in significant efficiency improvements.• Collaboration with interdisciplinary teams to develop customized BI solutions, providing valuable insights to stakeholders.• Exploratory data analysis to identify opportunities for process optimization and cost reduction.• Development of interactive dashboards to facilitate the interpretation of complex data for non-technical stakeholders.• Active participation in the identification and resolution of data issues, ensuring the accuracy and consistency of information.• Responsible for designing and executing data validation tests to ensure the quality and reliability of analyses.• Coordination of data cleaning and enrichment initiatives, resulting in significant improvements in data quality.• Development and automation of customized reports, streamlining the delivery of critical insights to leadership.• Proactive monitoring of data quality, identifying and correcting anomalies quickly.

Fortaleza, Ceará, Brasil

- Establish the best strategy to capture new leads based on the term results;- Sales Funnel analysis;- Develop ETL routines for data integration using alteryx;- Extract, transform and load (ETL) data from Salesforce (CRM) databases and Google Analitycs;- Creation of Reports and Dashboards using tools such as Tableau and Power BI;- Programming in MYSQL and SQL Server for the purpose of managing reports, reverse engineering of database, analysis and maintenance Triggers, Procedures and functions;- Analyze and interpret the performance campaign results and consolidate Web Analytics reporting data into internal reports;- Development of client's journey and relationship builder through email;- Supervision of local teams responsible for the relationship between the companies´ institutions and schools;- Process mapping: modeling, execution and control;- Develop commercial goals for customer relationship teams;- Planning and monitoring content of Enem Action, a site that helps seniors students to get into college;

Fortaleza E Região, Brasil

- Establish the best strategy do capture new leads based on the term results.- Funnel sales analysis- -Develop ETL routines for data integration using alteryx.- -Extract, transform and load (ETL) data from Salesforce (CRM) databases and Google Analitycs.- Creation of Reports and Dashboards using tools such as Tableau and Power BI.- Programming in MYSQL and SQL Server for the purpose of managing reports, reverse engineering of database, analysis and maintenance Triggers, Procedures and functions.- Analyze and interpret the performance campaign results and consolidate Web Analytics reporting data into internal reports.- - Development of client's journey and relationship builder though email.- - Supervision of local teams responsible for the relationship between the companies´s institutions and schools.- Process maping: modeling, execution and control.- - Develope comercial goals to customer relashionship teams.- -Planning and monitoring content of Enem Action, a site that helps seniors students to get into college.

Fortaleza, Ceará, Brasil

• Reverse engineering for the creation of database documentation.• Analyze large datasets to identify patterns and trends, contributing to informed strategic decisions (SQL).• Extraction, transformation, and loading (ETL) of data from databases and for the automation of customized reports in Power BI.

Toronto E Região, Canadá

Intern at CUE, Ryerson University's largest business incubator, where I had the opportunity to work with different companies.

Bacharelado, Civil Engineering

Especialização, Ciência Dos Dados

Capacitar profissionais com competência para conceber, especificar, analisar, desenvolver, implementar, adaptar, manter e evoluir soluções.

Bacharelado, Civil Engineering