Fabio Casagrande Camargo

Experience

• 

  Ambev

  Feb 1993 - Dec 1994

  Junior Analyst

  - Support in the implementation of new server platforms, such as also participating in the implementation of the DATASUL accounting system module.- Development of user access routine, server maintenance and backup in version IBM-OS2.- The inventory control of servers and computers was also part of the activities.

• 

  Ford Motor Company

  Jan 1998 - Dec 2005

  Business Intelligence Developer

  • Responsible for the development and maintenance of the following systems: Bonus Payment Control Module for Ford Dealers - PL/SQL. Order and Tracking System.• Participated in a project with the federal government to create a unified market share system for car manufacturers.• Maintained processes using various data sources such as XML, flat files, and DB2, integrating them into an Oracle Data Warehouse.• Developed complex packages and procedures in PL/SQL Oracle, and utilized Crystal Reports to display data. Show less

• 

  Unilever

  Jun 2005 - Aug 2007

  Business Intelligence Specialist

  • As a specialist in Business Intelligence (BI), I worked as an analyst and developed ETL processes using PL/SQL to load data into an Oracle Data Warehouse (DW) with over 20 terabytes of data across different countries, including Central America and Mexico, for Unilever.• Implemented complex PL/SQL packages and ETL processes, sourcing data from SAP to Oracle DW, to ensure data cleansing and integrity.• Created a framework for PL/SQL procedures aimed at saving time during troubleshooting.• Collaborated with business users to gather requirements and designed user-friendly solutions. Show less

• 

  Hewlett Packard Enterprise

  Jan 2007 - May 2015

  Business Intelligence Project Manager

  • Worked in a projects at Nextel Telecommunications, managing a team of 20 professionals working with diverse data sources such as SAP, Billing, Engineering, Sales, and Oracle EBS. Ensured project integrity and seamless deployment with no impact on operations.• Directed the team in using ETL, PL/SQL, and SQL tuning to enhance performance in critical daily processes, achieving a 60% increase in efficiency.• Created an automated solution to send 40 monthly reports to the government’s regulatory agency using ETL Datastage and Oracle databases.Led the daily reconciliation process for 3.5 million customers, adhering to ITIL processes.• Actively participated in the migration from Oracle to EXADATA, resulting in a reduction of the processing window from 12 to 5 hours.• Developed KPIs and conducted pre-validation before QA to ensure best practices in simultaneous project executions.• Implemented a fast-track project using a specially developed framework, reducing processing time from 24 hours to 6 hours.• Spearheaded the creation and submission of 40 monthly reports to Brazil's government regulatory agency.• Developed processes and dashboards to track and control assets related to trucks and cellphones.• Participated in the 3G project, contributing to the nationwide deployment of this technology with teams comprising 3,500 professionals and a $50 million budget, utilizing Agile methodology.• Supported a governance project across various technologies, including SAP, billing, and security, ensuring data integrity and mitigating risks during the ETL process to the data warehouse.• Engaged with cross-functional teams and stakeholders to deploy over 100 complex processes, performing root-cause analysis, and developing pragmatic, efficient solutions.• Managed a reconciliation project for the financial data warehouse, overseeing transaction validation for 3.5 million customers to identify constraints and gaps, with the goal of driving revenue growth. Show less

• 

  Telefonica

  May 2015 - Sept 2018

  Business Intelligence Project Manager

  • Worked in projects and deliverables with a 50-member team in the Business Intelligence area, ensuring the timely update of over 200 dashboards in Power BI, Excel, and MicroStrategy. • Supported analytics projects for the sales department and ensured the correct execution of 150 monthly campaigns based on SCRUM methodology, utilizing Salesforce and Microsoft Azure.• Oversaw an outsourced development team responsible for creating, updating, and maintaining routines in TERADATA, SQL Server, SAS, Power BI, and Microsoft ETL (SSIS).• Worked with Business Intelligence team during the IT integration process following the M&A between Telefónica Telecommunications and GVT Telecommunications.• Led the team responsible for developing contingency solutions in SSIS and TERADATA to support daily operations after the SAP migration.• Managed the project to integrate data from Business Intelligence into AURA, an artificial intelligence platform, significantly reducing customer queue waiting times to near zero by leveraging various sources such as SAP, Oracle Suite, Billing, and front-end systems.• Worked in a data cleansing project that consolidated 15 dashboards into 5, eliminating inconsistencies, duplicates, and corrupted information in metrics within the TERADATA database, Power BI reports, and ad hoc analyses.• Served as the focal point for a project using Agile methodology, responsible for migrating dashboards from MicroStrategy to Tableau, and managing KPIs such as churn, ARPU, CLV, LTV, and revenue.• Led requirement-gathering sessions for low- and medium-complexity requests, identifying gaps and focusing on reducing development time, resulting in a 45% increase in monthly deliveries.• Executed a data cleansing project that streamlined dashboards from 15 to 5, effectively removing inconsistent, duplicated, and corrupted information across Teradata and Power BI. Show less

• 

  Keyrus

  Feb 2019 - Nov 2020

  Business Intelligence Project Manager

  • Interfaced directly with directors, managers, employees, clients, partners, and others to clearly define requirements, manage expectations, and conduct risk assessments.• Adapted to different environments, projects, priority changes, and demands to define skills, scope, and solutions. Responsible for creating and maintaining status reports with project progress and financial updates to ensure transparency throughout the project lifecycle.• Led a sales strategy project at ROCHE Pharmaceutical, focusing on KPI improvements such as revenue, rating, and CLV, while documenting business and technical requirements using Power BI.• Collaborated with multiple internal stakeholders to clearly define project requirements for the sales team, focusing on increasing market share by identifying gaps through analysis in Power BI at ROCHE Pharmaceutical.• Worked closely with stakeholders at ROCHE Pharmaceutical, the second-largest company in the industry, to develop new KPIs for the marketing department, focusing on product usage to identify trends and opportunities in GCP ( Google Cloud ), Alterix and Power BI• Managed a squad on a financial project utilizing Alteryx, Cloudera, and Qlik Sense at Claro Telecommunications• Spearheaded the integration project post-M&A between Claro and Net, developing robust solutions for integrating internet services and products.• Directed a major process management change at Carrefour, successfully migrating the marketplace from IBM's Cloud to Google Cloud in just one month, ahead of Black Friday, for the second-largest retail player.• Managed a project involving technological changes in the commissioning system from Oracle Database to Big Data Cloudera, reducing processing time by 40% and accelerating the availability of financial data at Claro Telecommunications.• Led a team in developing a waste control dashboard in Power BI for GPA Retail Group, resulting in savings of over $2 million within six months of implementation. Show less

• 

  Mister Sfiha

  Jun 2023 - Aug 2024

  Entrepreneur

  • Accountable for budget control, production, and delivery to ensure an exceptional customer experience• Manages operations involving inventory control for raw materials, finished goods, delivery, packinglists, invoices, and vendor payments• Developed a document production process that increased daily output from 80 to 500 units within 3months, following gap analysis and implementing process improvements based on data-driven insights• Increased revenue by 10% through conducting customer operations research and identifying newopportunities following KPI data analysis Show less

• 

  Worksport Ltd

  Aug 2024 - now

  Business System/Data Analyst

  • Provide process improvements based on data analysis, demonstrated through dashboards and KPIs• Skilled for technology services, performing onboarding and offboarding activities, and• Working as a developer to enhance processes and customer experience• Working in R&D team to support and developer new features to the product with cross-functional teams.