Ricci Mae Margallo is a data-driven Virtual Assistant at 1-1 Tutors.Tech specializing in advanced reporting, dashboard creation, billing automation, fraud monitoring, and operational analytics.

With a strong academic foundation in Mathematics and hands-on experience in corporate analytics, she supports businesses that rely on accurate reporting, financial visibility, and automated systems to operate efficiently.

She is particularly valuable to organizations in Finance, Healthcare Billing, and Real Estate where structured reporting and compliance are critical.

Industries She Serves

Financial Services & Lending Institutions

• Develops fraud management dashboards to monitor suspicious activities and risk patterns

• Creates recurring and executive-level reports to track financial performance

• Builds KPI dashboards to monitor branch performance and operational efficiency

• Extracts and transforms data using SQL for structured reporting

• Standardizes reporting templates for consistency across departments

Value to you: Stronger risk control, better operational visibility, and data-backed leadership decisions.

Healthcare & Medical Billing Companies

• Automates billing and invoice reports for partner facilities

• Designs Excel-based tracking systems for claims, reimbursements, and collections

• Develops compliance-ready reporting templates for internal reviews and audits

• Creates monitoring dashboards for outstanding payments and billing accuracy

• Ensures report accuracy to minimize revenue leakage

Value to you: Improved billing efficiency, reduced manual errors, and organized compliance tracking.

Real Estate Agencies & Property Management Firms

• Tracks listings, sales performance, and agent productivity through dashboards

• Creates commission computation and payout tracking systems

• Develops automated spreadsheets for rental income and expense tracking

• Builds pipeline reports to monitor leads, closings, and conversion rates

• Assists in generating financial summaries for property portfolios

Value to you: Clear sales visibility, accurate commission tracking, and better portfolio performance monitoring.

Corporate & Enterprise Teams

• Creates ad hoc and recurring performance reports

• Develops automated reporting workflows to reduce manual preparation time

• Builds Power BI dashboards for executive-level reporting

• Streamlines data consolidation across multiple departments

• Implements structured report templates for scalable operations

Value to you: Faster reporting cycles and improved decision-making efficiency.

Startups & Growing Businesses

• Designs KPI tracking dashboards tailored to business goals

• Automates financial and operational spreadsheets

• Develops performance tracking systems

• Supports project tracking and reporting

Value to you: Enterprise-level analytics support without hiring a full-time analyst.

Expanded Professional Experience

Data Analytics Office – Officer-in-Charge

PJ Lhuillier Group of Companies

• Leads the preparation of ad hoc and recurring reports used by internal business units

• Develops automated and dynamic reporting tools to streamline performance monitoring

• Spearheaded the creation of Fraud Management reporting systems, improving detection and risk mitigation

• Ensures data accuracy and integrity before distribution to stakeholders

• Collaborates cross-functionally to gather reporting requirements and implement improvements

• Standardizes data visualization formats for executive presentation

Impact: Improved reporting efficiency, enhanced fraud visibility, and strengthened data governance practices.

CS Developer

Clinical Solutions, LLC

• Automates billing and invoice reporting processes for multiple healthcare facilities

• Develops structured Excel templates used for compliance checks and operational reviews

• Streamlines financial tracking systems to reduce manual intervention

• Creates repeatable workflows for recurring billing cycles

• Ensures billing data is organized and audit-ready

Impact: Increased billing accuracy, faster report turnaround, and improved compliance tracking.

Private Tutor

• Designed customized lesson plans tailored to student needs

• Managed scheduling and client communications

• Handled social media engagement to attract new clients

• Maintained structured progress tracking systems

Impact: Demonstrated strong communication, organization, and client-facing professionalism.

Education

Bachelor of Science in Mathematics
University of the Philippines – Diliman

Philippine Scholarships Sponsors Association (PeSSA) Scholar

Member, Analytics Association of the Philippines

Technical Tools & Expertise

Power BI
SQL
SSRS
Advanced Excel (Automation, Dynamic Reporting)
Microsoft Office Suite
MATLAB
LaTeX

Why Business Owners Work With Ricci

• Strong quantitative and analytical foundation

• Experienced in handling sensitive financial and compliance data

• Skilled in automation and report optimization

• Highly detail-oriented and structured

• Reliable, professional, and results-focused

As a Virtual Assistant of 1-1 Tutors.Tech, Ricci is backed by a managed system that ensures quality control, accountability, and consistent service delivery.