Practical Solutions.
Useful Insights.
Improved Outcomes.
I help businesses organize data, improve workflows, automate customer journeys, and turn operational and financial information into useful insights.
Data Management
Organize • Prepare • Maintain
Business & Org Support
Systems • Reports • Coordination
QuickBooks Online
Bookkeeping • Reporting • Insights
GHL CRM & Automation
Funnels • Pipelines • Workflows
Financial Analytics
Power BI • Dashboards • Analysis
AI-Assisted Solutions
Research • Workflow • Productivity
Problems I Help Small & Growing Businesses Solve
Practical technology is only valuable when it eliminates specific bottlenecks. Here are the common operational hurdles I resolve for clients:
Business data scattered across spreadsheets, files or mismatched tools
Pain: Teams waste hours hunting for numbers, creating version conflicts and duplicate records.
Practical Fix: Consolidated data architectures, single-source tracking, and structured staging tables.
Repetitive administrative, data entry, and manual reporting cycles
Pain: High labor cost and human errors every week copying numbers between systems.
Practical Fix: Automated ETL routines, macro/Python workflows, and templated reporting models.
Customer leads slipping through the cracks without organized follow-up
Pain: Inquiries go cold because there is no clear pipeline stage or scheduled outreach.
Practical Fix: GoHighLevel CRM pipelines with instant automated confirmation and notification triggers.
Manual appointment scheduling and friction-filled client communication
Pain: Endless email/messaging tag to pin down a meeting time, leading to drop-offs.
Practical Fix: Self-service booking calendars with automated reminders and pre-meeting questionnaires.
Financial information that is difficult to translate into management insights
Pain: Business owners review bank balances instead of understanding true operating margins.
Practical Fix: Standardized QuickBooks Online chart of accounts, variance reviews, and cash flow clarity.
Reports requiring tedious repetitive preparation before each management meeting
Pain: Decision makers get information 2-3 weeks after month-end when opportunities have passed.
Practical Fix: Automated Power BI and financial reporting dashboards refreshing on schedule.
Business workflows that lack clear operational structure and documentation
Pain: When key personnel are absent, operations stall because processes live in heads.
Practical Fix: Standard Operating Procedures (SOPs), flowcharts, and clear handoff protocols.
Wanting to leverage AI tools but not knowing how to integrate them practically
Pain: Disjointed experiments with generic chatbots that fail to produce dependable business work.
Practical Fix: Applied AI-assisted research, automated draft generation, prompt systems, and documentation.
Recognize any of these challenges in your business?
Let's map out a step-by-step solution that fits your team and budget.
Three Core Solution Areas
Clear, practical capabilities combining business-process comprehension with robust technology execution.
Business Systems & Data Support
Solid data foundations, dependable spreadsheets & operational flow
GHL Funnels, CRM & Automation
Lead capture, client journeys, calendars & reliable follow-ups
Financial Reporting & Business Analytics
Translating transactional records into executive management visibility
Selected Builds & Walkthroughs
Transparent, evidence-based presentations of systems, funnels, dashboards, and data workflows. Each project supports deep exploration across three distinct layers:
Featured Interactive Case Studies
Full Documentation
Small Business Project
Edda Vira Treasures
Edda Vira Treasures
Evolving Florida Resale Activity into an Independent Digital Commerce & CRM Presence
A genuine small-business digital-commerce initiative supporting an established Florida-based vintage, collectibles, and curated resale activity. Transitioning from marketplace dependence to an owned web presence and direct customer relations.
What Was Implemented:
Real-World Use Case / Portfolio Implementation
Adonism Art Studio
Adonism Art Studio
Creative Services, Custom Murals & High-End Art Commission Funnel
A specialized commission-oriented digital experience designed for contemporary artists offering custom original canvases, commercial/event signage, murals, and living space installations inspired by Camiguin Island.
What Was Implemented:
GHL Coursework / Demonstration Implementation
Luna Glow Beauty Studio
Luna Glow Beauty Studio
End-to-End Service Booking, Opportunity Pipeline & Automated Client Care
A comprehensive coursework demonstration illustrating how modern CRM, booking calendars, and automated customer journeys elevate client acquisition and retention in a professional aesthetic studio located in Mati City.
What Was Implemented:
Additional Applied Projects & Systems Architecture
Problem → Approach → What I Built → Tools → Deliverable
Power BI Sales & Margin Intelligence
Executive Sales Performance, Product Margin & Regional Trend Dashboard
Executive team was spending 12+ hours weekly copying data into disjointed spreadsheets without real-time gross margin or salesperson contribution insights.
- •Automated Power Query data model combining transactional sales, product SKUs, and returns
- •Interactive executive summary with drill-downs by region, product category, and monthly margin
- •DAX measures for Year-over-Year (YoY) growth, running totals, and sales target tracking
QuickBooks Online & Bookkeeping Workflow
Standardized Chart of Accounts, Bank Feed Rules & Month-End Close Architecture
Clean up messy transactional data, establish strict reconciliation protocols, and turn raw bank records into actionable P&L and Balance Sheet management packages.
- •Restructured Chart of Accounts aligned with operational cost centers
- •Automated bank feed classification rules eliminating 70% of manual entry
- •Standard operating procedure (SOP) checklist for 5-day month-end financial closing
- •Management variance report comparing monthly actuals to operating budgets
Python ETL & Data Cleansing Engine
Automated Data Ingestion, Deduplication & Transformation for Downstream BI
Replace error-prone manual copy-pasting with an automated script that validates data schemas, handles missing values, and exports clean staging tables.
- •Modular Python pipeline leveraging Pandas for robust data extraction and transformation
- •Automated string normalization, phone/email validation, and duplicate identification
- •Logging and exception handling providing clear audit trails of rejected records
- •Automated output into clean SQLite and formatted Excel outputs for management
Business MIS & Legacy Operational Systems
Operational Information Systems for Inventory, Accounts Receivable & Billing
Bridging the gap between front-line staff transactions and executive oversight through dependable, documented, and auditable record systems.
- •Custom relational business databases with strict input validation and access controls
- •Accounts receivable aging calculators with automated notification flags for overdue balances
- •Inventory batch and re-order threshold reporting preventing stockouts
- •Comprehensive user manuals and standard operating procedures (SOPs)
QR-Based Attendance Logging System
Scan-to-Log Attendance Capture with Consolidated Record Review
Replace paper-based attendance tracking with a scannable, mobile-friendly system that logs check-ins reliably and consolidates records for review and export.
- •QR code generation and scan-to-log attendance capture accessible from any mobile browser
- •Automated timestamping of each check-in entry
- •Lightweight, responsive interface requiring no app installation
- •Consolidated attendance records available for review and export
Future Self-Hosted Project Migration & Expandability
Projects such as Edda Vira Treasures and Adonism Art Studio are structured with decoupled UI and CRM layers. This design ensures they can cleanly expand from prototype workflows into independently hosted React applications while maintaining synchronized lead capture and automation pipelines.
How I Work: Practical, Repeatable Methodology
Practical solutions built around your team's genuine workflow — not technology for technology's sake.
Understand
Start with the business need, current process, data and desired outcome.
No jumping straight to tools. We map who does what, where numbers come from, and where friction happens.
Organize
Clarify information, workflow, requirements and priorities.
Standardize naming, clean messy spreadsheets, establish pipelines, and establish data integrity first.
Design
Develop a practical solution appropriate to the actual business environment.
Choose the leanest, most reliable architecture — avoiding bloated subscriptions and unnecessary complexity.
Implement
Build, configure, integrate, document and test.
Deploy landing pages, calendars, QBO workflows, or Power BI models with comprehensive SOPs.
Support & Improve
Review results, resolve issues and progressively improve the solution.
Iterative enhancements based on real staff feedback, customer behavior, and evolving business goals.
Bridging the Gap Between Business Operations and Practical Technology
I am an independent technology and business systems practitioner based at the intersection of business operations, financial accounting, and modern systems automation.
Rather than treating software as an isolated commodity, my work is built on understanding the actual operational environment first: how leads come in, how invoices get reconciled, where customer inquiries get delayed, and how management accesses critical numbers.
QuickBooks Online, Bookkeeping workflows, Chart of Accounts hygiene, MIS systems, and Standard Operating Procedures.
GoHighLevel CRM pipelines, appointment calendars, automated client notifications, and high-converting landing pages.
Power BI executive dashboards, DAX metrics, automated Python ETL pipelines, and spreadsheet modeling.
AI-assisted research, automated draft generation, prompt structuring, and documentation acceleration.
“Technology serves the process, and the process serves the people. Sustainable business systems must be clear, well-documented, and easily maintained by your team.”
Tools & Platforms Supporting Practical Solutions
Tools reinforce real capabilities. I select and configure the right platform for your operational scale.
Business & Financial Systems
QuickBooks Online
Bookkeeping, reporting, chart of accounts & bank feeds
QBO Accountant
Batch reclassification, audit tools & closing procedures
Intuit CAS Advisory
KPI tracking, management dashboards & cash flow reviews
Financial Modeling
Variance analysis, budget vs actual schedules
CRM & Funnel Automation
GoHighLevel (GHL)
Funnels, landing pages, calendars & contact pipelines
Pipeline Automation
Multi-stage opportunity tracking & automated trigger actions
Calendar Systems
Automated booking, timezone handling & SMS/email reminders
Lead Capture & Forms
Custom field mapping, qualification logic & CRM sync
Data, Analytics & ETL
Microsoft Power BI
Interactive dashboards, DAX formulas & relational data models
Power Query (M)
Data mashup, automated staging & scheduled transformation
Python 3 & Pandas
Automated ETL scripts, deduplication & data cleansing
Excel & Sheets
Advanced lookups, pivot models & operational workbooks
AI-Assisted & Web Engineering
AI Studio & Modern Stack
Clean responsive web implementation & UI components
AI Workflow Integration
Prompt-assisted research, automated documentation & testing
Structured Documentation
Standard Operating Procedures (SOPs) & system diagrams
Relational DB & SQL
Query design, data hygiene & schema normalization
Credentials & Continuous Learning
Commitment to professional standards across bookkeeping, CRM automation, and data analytics.
Intuit Bookkeeping Professional
Double-entry accounting principles, balance sheets, reconciliations & audit readiness
QuickBooks Online Level 1
Core QBO setup, bank feeds, vendor/customer cycles, invoicing & sales tax management
QuickBooks Online Accountant (QBOA)
Client management, reclassify transactions, journal adjustments & month-end reviews
Intuit ProAdvisor Client Advisory Services (CAS)
Strategic advisory, cash flow forecasting, management reporting & KPI structuring
GoHighLevel CRM & Funnel Architecture
Funnels, appointment booking engines, pipeline automation, custom fields & lead tracking
Data Analytics, Power BI & Modern AI Workflows
Data modeling, DAX measures, Python ETL pipelines, AI-assisted development & prompt systems
Have a business process, data, reporting or automation challenge? Let's discuss it.
Whether you need a QuickBooks cleanup, a GoHighLevel client acquisition funnel, a Power BI dashboard, or automated data preparation—share your requirements below.
GHL Lead & Opportunity Pipeline
This portfolio functions as a live demonstration of structured lead capture and CRM pipeline architecture. Submitting an inquiry triggers this exact flow:
Website Visitor
Explores portfolio evidence & case studies
Inquiry Form
Submits project scope or requests call
GHL Contact & Opportunity
Contact record created with 'New Inquiry' tag
Follow-Up / Conversation
Acknowledgement email & discovery call
Requirements / Discovery
Scoping business data and tech stack
Proposal / Next Step
Transparent scope, milestones & timeline
Engaged / Complete
Implementation & continuous support