Erick Fernandes Email and Phone Number

• Developed and maintained a cloud-based data model using VBA and Python, achieving an 85% reduction in report update time. This improvement enhanced the efficiency of tracking major clients, workloads, and credit consumption goals for the Latin American TELCO team.• Automated weekly reports with Excel and Oracle Cloud, resulting in a 75% increase in the speed of information access and responsiveness for management. This streamlined process allowed quick data updates with minimal manual effort.• Collaborated with the Finance team to ensure the accurate calculation of metrics, utilizing direct Finance source data for visualizations and analyses. This approach improved data accuracy by 30%, reducing the likelihood of errors and enhancing decision-making reliability.• Provided strategic insights during weekly meetings with TELCO Regional Directors, influencing key decisions that helped retain approximately $3 million in the Revenue Pipeline for FY 2024.Key Technologies and Tools: Excel (VBA), Python, Oracle Cloud, SQL, MS Access, Oracle Data Visualization.

• Designed and implemented daily data extraction and loading workflows using Google CRM and Google Cloud, facilitating access to historical data that was previously unavailable. This capability supported informed weekly analyses and improved decision-making processes.• Developed automated data pipelines for report generation, reducing update times by up to 50%. This process enhanced data accuracy and the quality of performance analyses for better strategic planning.• Created performance dashboards in Google Data Studio, significantly improving the visualization and clarity of KPIs for management. This contributed to more effective decision-making and team alignment.• Initiated a Master Data project to improve data integration and expand the use of specific reports to other teams, increasing reporting efficiency by an initial goal of 30%.Key Technologies and Tools: Google CRM, Google Cloud, Google Data Studio, SQL.

• Maintained and updated reports and dashboards for the Facilities area using MS Access and Oracle DB, leading to a 50% reduction in report file sizes and an initial 12% improvement in process efficiency.• Automated data normalization and report updates in Excel using VBA, reducing manual work time by approximately 83%, significantly enhancing operational efficiency.• Developed a Telecom project to control user line registrations, resulting in more precise mapping of lines and responsible parties. The project identified discrepancies, such as device/line swaps, improving control accuracy and avoiding additional costs. Key Technologies and Tools: MS Access, Oracle DB, Excel (VBA), SQL.

As an Incentives and Compensation Analyst at IBM, I utilize QMF for SQL queries in DB2 databases and create visualizations in QMF and Excel, providing technical support to the sales team. Monitoring and analysis of North American sales data with QMF ensure the accuracy of commission payments through financial and commission adjustment management in the internal system. Collaboration with Finance and Accounting resolves payment-related issues, while internal audits of adjustments processed by peers focus on identifying and correcting errors and enhancing the documentation process.