real estate data analysis / reporting and QA

Jace Gan

ghilliannejace.gan@gmail.com

Real Estate Data Analystcomp sheets, blended pricing, QA reporting

I turn raw property records into reports a reviewer can trust. Every number traces back to a real comp or a specific check, never a black box.

Available now Philippines based, works US hours full time or contract

27person team managed
2,000+engagements analyzed / yr
48events coordinated / yr
40%lift in attendance retention

about

Every report is only as good as the data behind it. For the past two years I've run the data and financial side of a 50+ person events operation, and I'm now applying that same discipline to real estate: pulling comparables, building pricing models, and running QA before anything ships.

Detail obsessed

Duplicate records, outlier comps, and blank fields get caught before they reach a report.

I show my work

Every price traces back to a specific comp or a blended source, never a black box.

Spreadsheet fluent

Trackers, pricing models, and QA all built with formulas I can explain line by line.

Reliable under volume

I run live reporting and reconciliation for 48+ events a year without missing a deadline.

pricing process

raw property data in, priced offer out

Pull the data

Source sold and listed property data from Zillow, Redfin, and county-level sources into structured sheets.

Organize and clean

Filter records, group by acreage, and flag outliers before anything reaches a pricing view.

Build comparative pricing

Model market comps, blended valuation, and discount pricing for each parcel.

QA and finalize

Run accuracy checks on the data and pricing before a report goes out.

real estate data examples

Battle Creek, MI · real sold comps (Redfin)

Land Comp Sheet

Real sold vacant-land comps pulled from Redfin. Grouped by acreage band for benchmark pricing.

Excel comp sheet with real Battle Creek, MI vacant land sales
RedfinGoogle SheetsAcreage banding
Same real comps · blended pricing

Blended Pricing Sheet

Band PPA to market value, a roughness discount, then a conservative offer.

Excel blended pricing sheet derived from the comp sheet
Blended valuationDiscount modeling
Illustrative log

Data QA Checklist

Checks I run before a dataset or report is finalized.

Excel data QA checklist log
Data QAAccuracy checks

Operations reporting

Parallel Dimensions · production work

Event Ops & Payout Reporting

27person team managed
2,000+engagements / yr
48events / yr
40%retention lift

Automated Google Sheets trackers and dashboards centralizing event data, team assignments, and payout records for real-time reporting, plus the financial side every cycle: salary computation, payout reconciliation, and budget tracking.

Google SheetsFinancial reconciliationLive reporting

experience

Hosting Director — Operations & Data Analytics

Parallel Dimensions, Marketing Agency (Nightlife Events Division)
  • Analyze event and promoter performance data to guide data-driven planning, contributing to a 40% lift in attendance retention.
  • Build and maintain automated Google Sheets trackers and dashboards centralizing event data, team assignments, and payout records.
  • Handle financial operations every event cycle: salary computation, payout reconciliation, budget tracking.
  • Manage a 27-person team coordinating 50+ promoters per event, 2,000+ engagements analyzed annually.
  • Oversee 4 monthly events (48+ annually) end to end: assignments, venue logistics, on-ground execution.

Land & Property Data Analysis

Independent Training, Hands-On Mentored
  • Practiced end-to-end land parcel data analysis: pulling, filtering, and organizing property datasets from Zillow and Redfin via Google Sheets pipelines.
  • Built comparative pricing analyses (market comps, blended valuation, discount modeling) and ran data QA checks before finalizing reports.

education

BS Industrial Engineering

Mapua Malayan Colleges of Laguna
  • Developing skills in systems optimization, operations management, and data-driven decision making.

BS Chemical Engineering

University of Santo Tomas
  • Built a foundation in analytical thinking, problem solving, and technical processes through engineering coursework.

data and reporting toolkit

Daily

Google SheetsZillowRedfinGoogle Workspace

Domain

Comp analysisBlended pricingFinancial reconciliation Data cleaning and QAEvent operations
Google SheetsAutomated trackers and dashboards centralizing event data, team assignments, and payout records for a 50+ person operation.
Comp analysisSold comps grouped by acreage band and benchmark priced conservatively, sourced from real Redfin data.
Data QADuplicate, outlier, and malformed-field checks run before a dataset or report is finalized.
ReconciliationPayout and budget reconciliation every event cycle, across 48+ events a year.

contact

Available for real estate data analysis, reporting, and data QA roles, full time or contract, working US hours from the Philippines.

ghilliannejace.gan@gmail.com
Document
loading document…