Office Assistant

Overview

Worked as an Office Assistant at The Salvation Army's Territorial Headquarters, focusing on financial data processing and reporting.

Responsibilities

• Analyzed over 100,000 general ledger transactions using advanced Excel functions, improving accuracy and data interpretation
• Streamlined financial reporting processes by applying automation and structured logic in Excel
• Developed Excel and Power BI dashboards to deliver actionable procurement insights across 150+ ministry units
• Supported strategic planning by identifying spending trends and preparing summarized insights for decision-making
• Coordinated cross-functional tasks with the Supplies & Purchasing team, contributing to smooth project execution
• Improved invoice filing system for 200+ records, reducing document retrieval time by 40%

Key Achievements

• Applied advanced Excel formulas (INDEX-MATCH, IFs, pivot tables) to increase processing speed and improve data reliability by 30%
• Created automated reporting templates that enhanced presentation quality and aided procurement strategy
• Successfully managed 15+ projects by prioritizing tasks, integrating feedback, and ensuring timely delivery of insights
• “Philos has shown notable development in project management skills and demonstrated a strong willingness to grow and take on challenges.” – Estee Lau, Supervisor, Summer 2024