Carlos Ianes

Experience

• 

  Mercedes-Benz do Brasil Ltda.

  Sept 2016 - Aug 2017

  Engineering Intern

  Concept studies in buses projectsTechnical engineering drawings

• 

  Clube Do Doce

  Sept 2017 - Dec 2021

  IT, Analytics, and Operations Manager

  - Led operation teams in HR, sales, e-commerce, IT, and analytics.- Reduced 70% of Telecom costs.- Increased sales by 20%, implementing e-commerce and sales desks.- Increased IT operation reliability by implementing internet redundancy and file backup.- Extract data from a relational database to create reports and dashboards using Python and SQL.- Set up ODBC to consult data on PowerBI.- Seek business insights supported by data analysis. Extract data from a relational database to create reports and dashboards using Python and SQL. Set up ODBC to consult data on PowerBI. Seek business insights supported by data analysis.- Computer network troubleshooting, Windows Server maintenance (AD, DNS, DHCP, GPO, VPN), Computer hardware maintenance. Computer network troubleshooting, Windows Server maintenance (AD, DNS, DHCP, GPO, VPN), Computer hardware maintenance. Show less

• 

  Idehm Instituto de Ciência e Tecnologia

  Dec 2021 - Jan 2022

  Data Analyst

  The objective of this project was to parse, clean and transform raw data from an unstructured dataset about human resources employee information using python, R, and Power BI (Power Query and DAX). After that, we were able to analyze insightful outcomes from dashboards of employee turnover and absenteeism answering questions as: What are the main reasons for employee turnover? How long in average does an employee work in the company for? What are the roles/positions that have more employee turnover? Creating data-driven decisions to improve the work environment and increase business profitability. Show less

• 

  Ultragaz

  Jan 2022 - Apr 2022

  Mid-Senior Data Analyst

  Support and collaboration to performance enhancement on ETL jobs for big volume of data using Oracle database and Microsoft SQL Server.On-demand analysis on SQL Server.Performance monitoring of daily ETL loads to the database.Development of complex analysis and dashboards on Power BI.

• 

  Emerge

  Jul 2022 - now

  Manager of the Emerge Enterprise Analytics for Growth team at Cisco Systems, Inc.- Team Leadership: Lead, mentor, and manage a team of BI analysts and professionals. Provide guidance, support, and coaching for professional development and high performance.- Strategy and Planning: Develop and execute a comprehensive BI strategy aligned with business objectives. Collaborate with key stakeholders to identify opportunities for leveraging data and analytics in driving business growth.- Project Management: Oversee the entire lifecycle of BI projects, including scoping, planning, execution, and delivery. Ensure projects are completed on time, within budget, and meet quality standards.- Data Analysis and Interpretation: Analyze complex datasets, extracting meaningful insights, trends, and patterns. Communicate findings to stakeholders and decision-makers to support informed business decisions.- BI Tools and Technologies: Stay updated on the latest BI tools and technologies. Evaluate and recommend the adoption of new tools or enhancements to existing systems for improved efficiency and effectiveness.- Collaboration and Communication: Work closely with various departments to understand their data needs and create reporting solutions that address those needs. Communicate complex technical concepts to non-technical stakeholders.- Performance Measurement: Establish KPIs and metrics to evaluate the performance and impact of BI initiatives. Regularly assess and report on the success of BI projects and solutions.Tools/Products: Python, Power BI, Jira Software Management, Agile, Leadership, Team Management, Research and Development, AWS, Azure, AWS Partner Network. Show less Emerge partner at Cisco Systems.- Development of revenue-oriented data solutions designed to solve problems and create meaningful insights for business units.- Data normalization, ETL and data modelling - Dataflow development using MS Power BI Platform- Datamart development for self-service BI on Azure SQL Database - Data extraction from Salesforce.com and load in Azure data marts through API for large datasets (7M+ records via Python script (JSON files))- Data integration between Salesforce.com and Power BI Datamarts via Salesforce connector and incremental refresh setup for large datasets.- Development of Power BI dashboardsTools: Python, Power BI, Power BI Dataflow, Power BI Datamart, Power Query, Excel, SharePoint Lists.Products: Pipeline dashboards, Bookings dashboards, Business state dashboards, large datasets cleaning and transformation, advanced data extraction, report automation. Show less

  • Business Intelligence Team Manager

    Jan 2024 - now

  • Business Intelligence Analyst

    Jul 2022 - Jan 2024