Russel A. Corpuz

RUSSEL A. CORPUZ​ PROFESSIONAL SUMMARY Financial Analyst & Modeler specializing in Financial Process Automation. Successfully transformed manual accounting workflows into real-time cloud systems using Google Apps Script and Looker Studio, reducing reporting cycles by 90%. Expert in high-volume Variance Analysis (25,000+ lines) and Information Design for executive dashboards. Seeking to leverage technical accounting and automation skills to drive operational efficiency in a dynamic Financial Analyst role. WORK EXPERIENCE Salon Ariana | Contract​ Santiago City, Philippines Financial Modeling Analyst​ November 2025 - January 2026 ●​ Engineered a custom ERP and financial dashboard using Google AppSheet and Google Apps Script, transforming a manual pen-and-paper operation into a fully digital system; reduced monthly financial reporting time from 2 weeks to real-time. ●​ Automated the bi-monthly payroll process for staff (calculating basic pay + commissions), cutting processing time from 1 week to instant execution and eliminating salary payment delays. ●​ Identified and rectified recurring calculation errors in staff revenue contributions, ensuring 100% accuracy in commission payouts and establishing a reliable historical database for- performance trends. ●​ Designed dynamic visualizations in Looker Studio to track service-level profitability, enabling management to identify top-performing revenue streams previously invisible in aggregate totals. Ismael and Co., CPAs (ICC)​ Baguio City, Philippines Audit Support Staff - Internship​ May 2025 - August 2025 ●​ Executed high-volume data validation and variance analysis for over 25,000+ transaction lines, utilizing advanced Excel functions (PivotTables) to reconcile discrepancies across DAT files, E-Sales, VAT summaries, and estate taxes. ●​ Modernized audit documentation processes by transitioning the firm from manual Excel diagramming to Lucidchart, aligning internal workflows with ISO 5807:1985 and industry-standard flowcharting notations. ●​ Configured the Xero accounting environment of a non-profit client from scratch, including chart of accounts setup, bank feeds, bank reconciliations, invoice templates, and opening balances, as part of an intensive Xero training project. ●​ Facilitated a technical training seminar on process mapping and Lucidchart for audit staff developing a comprehensive user guide that was permanently adopted into the firm’s internal Knowledge Base. Freelance Graphic Designer​ Remote Upwork​ July 2023 - February 2025 ●​ Delivered high-volume, time-sensitive projects for diverse commercial clients, successfully completing 4 distinct contracts (TV assets, journal publications, document corrections and conversions) within a single 3-hour turnaround window. ●​ Specialized in ‘Information Design’ and document formatting, ensuring complex textual data was converted into intuitive, user-friendly layouts for commercial publishing. ●​ Maintained strict quality control on file conversions and edits, earning the Upwork "Accountable for Outcomes" talent badge being identified as a consistent pattern of me taking full ownership of project results, delivering high-quality work, and meeting expectations. ●​ Applied UI/UX principles to marketing and documentation materials, a skill directly transferable to designing accessible financial dashboards and system interfaces. CERTIFICATIONS QuickBooks Certified ProAdvisor| Intuit​ August 2025 - July 2026 Credential ID:​ c07e9255-a4a2-4b91-a660-4d6f6465edec​ https://www.credly.com/badges/124366db-e597-44c7-885f-e372caeebf53/public_url Link: ​ Bookkeeping Certification | Intuit​ July 2025 Credential ID:​ 30de-a-4364-91b0-48db232d838a​ https://www.credly.com/badges/e46aa507-db48-4b27-8c59-7c2201a35c27/public_url Link: ​ TECHNICAL SKILLS Financial ERP & Accounting:​ QuickBooks Online (ProAdvisor), Xero (Advisor Level), SAP S/4HANA, ​ Tax Compliance (BIR Forms), Bookkeeping, Cost Accounting Data Automation & Scripting:​ Google Apps Script, Google AppSheet, Excel VBA (Macros), Looker Studio, ​ Python (Learning) Financial Analysis:​ Financial Modeling, Variance Analysis, Sensitivity Analysis (Goal Seek/Data Tables), Forecasting, 3-Statement Modeling Information Design:​ Adobe Creative Cloud (InDesign, Illustrator, Photoshop) for Professional Reporting, Lucidchart (ISO 5807 Standards), UI/UX for Dashboards. TECHNICAL & FINANCIAL PORTFOLIOS Camp 7 Elementary School - Enhanced Basic Education Information System (EBEIS)​ Baguio City Systems Developer​ January 2025 - April 2025 ●​ Engineered a centralized Google Sheets reporting system powered by Google Apps Script, automating the processing and visualization of 32 distinct performance indicators (KPIs) for school administration. ●​ Reduced the annual reporting lifecycle from 6 months to 1 month by replacing manual data aggregation with a single-entry input interface that auto-populates all statutory reports. Budgeting and Forecasting Dashboard​ Baguio City Systems Developer​ May 2024 - August 2024 ●​ Designed an "App-Like" Excel Financial Dashboard featuring interactive navigation menus, dark-mode UI, and dynamic hyperlinking to track 13 expense categories against historical trends. ●​ Built automated forecasting visualizations that instantly update trend lines and variance analysis charts based on raw user inputs, eliminating the need for manual chart regeneration. Dynamic Relative Valuation & Sensitivity Model​ Baguio City Financial Analyst​ March 2024 - April 2024 ●​ Constructed a Comparable Company Analysis (CCA) model to determine Enterprise Value (EV) using key multiples (EV/EBITDA, P/E, EV/Sales) across different market scenarios. ●​ Performed quantitative Sensitivity Analysis using Excel Data Tables and Goal Seek, testing assumptions such as Sales Growth Rate (5%) and Operating Margins to identify investment risks. ●​ Integrated a 3-statement financial logic (Income Statement, Balance Sheet) to drive automated scenario planning, allowing investors to stress-test valuation against market volatility. EDUCATION Bachelor of Science in Accounting Information Systems (BSAIS)​ Baguio City​ University of the Cordilleras​ August 2022 - August 2026 ●​ GPA: 3.265 ●​ Relevant Coursework: Financial Analytics & Modeling, Data Warehousing, Strategic Cost Management, Accounting Information Systems and Design, IT Application Tools in Business, Project Management ●​ Awards: Dean’s Lister A.Y- RESEARCH Mountaineers Lowlanders Multipurpose Cooperative (MLMPC)​ Buguias, Benguet Researcher and UI Designer - Membership and Capital System​ December 2024 ●​ Studied the existing system of the cooperative, and outputs a proposed system that is backed with cost-benefit analysis along with a technical documentation for the software development life cycle (SDLC) — design, testing, deployment, and maintenance phases. LEADERSHIP AND INVOLVEMENT Les Aconter (Official Student Publication) | Chief Layout Artist​ ●​ Directed the visual strategy for the student journalism organization, overseeing a team of designers to produce brand-consistent publication materials under strict deadlines. College Student Council - College of Accountancy |Vice-Governor​ ●​ Managed cross-functional teams to execute college-wide events, handling logistics, documentation, and student activity processing. Student Executive Council | President​ ●​ Recognized as Gerry Roxas Leadership Awardee (GRLA) 2022 - Awarded by The Gerry Roxas Foundation (GRF)