Expense Reporting App - Created & Coded by Sonam Kaloti in Microsoft Power Apps
Behind the Curtain, 
          Running the Show
I design functional systems that bring clarity, efficiency, and cohesion across business operations, project management, and event production. My work ranges from back-end infrastructure—like building floor plans, SOPs for spa scheduling in Fresha, and custom-coded Excel tools that automate AP inputs and track utility expenses—to immersive, logistics-heavy experiences like a full-scale murder mystery escape room party, complete with asset lists, gameplay flow, and site execution.
I apply project management principles to everything I build: defining scope, anticipating bottlenecks, and translating complexity into usable tools. My recent portfolio includes a visual expense report app prototype and systems for reconciling RBC Visa statements, alongside operational logs for SOP development. Every build, from spreadsheet to immersive event, is rooted in function-first design—streamlining how things work, and how teams move.
PROJECT MANAGEMENT & EVENT PLANNING
Conceptual proposal for a VOKRA community event—crafted as a demonstration of event planning, outreach, and logistical strategy.
 Staffing Requirements | Event Budget
Production Schedule | Planning Timeline
Company roles and functions - responsibility delegation and management.
Financial Actuals and Forecasting
“Carnival Noir: The Final Act”
Murder Mystery x Escape Room Event
Created and Hosted by Sonam Kaloti
custom-coded and conditionally formatted
EXCEL TOOLS & TEMPLATES
 
              
              
            GL Code Builder - Easy-Input Access to Financial GL Ledger Codes
 
              
              
            GL Code Builder - Background Coding
 
              
              
            GL Code Builder - Background Coding
 
              
              
            Utility Query - Conditionally Formatted to Auto-Update by Date, Ensuring Timely Payment Processing
 
              
              
            Utility Query - Conditional Formatting
 
              
              
            Company Bank Reconciliation Template - Coded to Automatically Match Bank Statement Deductions Against Partial File Totals
 
              
              
            Company Bank Reconciliation - Background Coding
 
              
              
            Company Credit Card Statements Template - Generates Coding Table Based on Background Coding, Data Validation, and Pivot Tables
 
              
              
            Company Credit Card Statements Template - Background Coding
 
              
              
            Company Credit Card Statements Template - Background Coding
 
              
              
            Company Credit Card Statements Template - Pivot Table With Auto-Generated Coding
 
              
              
            KPI Reports - Finance and Accounting Payment Tracking
 
              
              
            Invoice Tracker - Facilitates Communication on Invoice Processing Between AP and Plant Accounting Teams. Search Bar Coded to Use Either Invoice Number or PO Number Input to Quickly Find Details
SOP Development
Company Procedure Documentation & Training Manuals
Floor Plans & 3D Construction Models
Floor plans and 3D models created for studio construction and layout planning.
Focused on structure, spatial logic, and functional use.
 
              
              
             
              
              
             
              
              
             
              
              
            

 
            
              
            
            
          
               
            
              
            
            
          
               
            
              
            
            
          
               
            
              
            
            
          
               
            
              
            
            
          
               
            
              
            
            
          
               
            
              
            
            
          
               
            
              
            
            
          
               
            
              
            
            
          
              