ACE JOENALD E. CASTILLO

Dynamic and motivated professional eager to leverage knowledge and skills in a challenging role that fosters career advancement and personal growth. Committed to contributing effectively within a collaborative environment that encourages continuous learning and development. Aims to enhance productivity while aligning with company objectives and driving success. Passionate about achieving excellence and making a meaningful impact through dedication and hard work.

Project Cerebro: Projection Dashboard

Role: Treasury Team
Date: August 2024 – November 2024
Technologies: Google Sheets, Google Looker Studio

Project Overview:

Project Cerebro is an advanced interactive projection dashboard built to monitor and visualize key business performance metrics. It provides real-time insights into win rate, gross revenue, lost revenue, net revenue, and overall team productivity through interactive and highly visual charts. The tool enables data-driven decision-making and supports performance tracking across multiple operational areas.

Key Responsibilities:

• Dashboard Development: Designed and developed a full interactive dashboard using Google Sheets and Looker Studio to visualize core business metrics including win rate, revenue categories, and productivity indicators.
• Interactive Charts & Visualizations: Implemented dynamic charts with filtering, drill-down capabilities, and multi-layered visual elements to enhance data exploration.
• Metric Calculation: Created automated formulas and algorithms to compute real-time metrics such as gross revenue, lost revenue, net revenue, and win rate.
• Productivity Monitoring: Built features to track individual and team productivity based on revenue-generating activities, leveraging trend analysis and historical data.
• User Experience (UX): Ensured a clean, intuitive, and user-friendly dashboard layout tailored for non-technical users, prioritizing clarity and usability.
• Data Analysis: Conducted detailed data verification and analysis to maintain accuracy in projections and performance reporting.
• Stakeholder Collaboration: Worked closely with business stakeholders to gather requirements, refine key metrics, and align dashboard outputs with organizational needs.
• Testing & Optimization: Performed end-to-end testing to validate data accuracy and dashboard performance. Optimized responsiveness and scalability across devices and user groups.

Angelo Punzalan
Senior Manager – Teleperformance
6F SM Aura Office Tower, 26th Street corner McKinley Parkway, Taguig City
0915 883 4202

Kim Ramcie B. Masaganda
Team Leader – Teleperformance
G/F Le Grand Avenue, Five West Campus, McKinley Hill, Fort Bonifacio, Taguig City
0927 242 5699

Marlon De Vera
Team Leader – Teleperformance
G/F Le Grand Avenue, Five West Campus, McKinley Hill, Fort Bonifacio, Taguig City
0939 439 0187