ESTHER HAN
HUNTINGTON BEACH,CA
Summary
Dynamic and results-driven professional with experience in data analysis, reporting, requirement gathering, and process improvement. Recognized for exceptional analytical thinking, problem-solving abilities, and strong communication skills that foster collaboration and drive project success. Eager to leverage skills and experiences to contribute effectively in a corporate setting after a dedicated period of raising two children
Overview
22
22
years of professional experience
Work History
Property Manager & Host
Airbnb
Mammoth Lakes, CA
01.2019 - Current
- Manage end-to-end operations for high-performing short-term rental maintaining a 4.97 star rating (150+ stays)
- Track occupancy, expense, and performance metrics to optimize profitability
- Analyze booking trends and pricing data to support revenue decisions
- Coordinate vendors and maintenance workflows to maintain operational efficiency
- Successfully resolved guest issues and property disputes while maintaining positive reviews
Volunteer - Room Parent, PTA
Hawes Elementary School
Huntington Beach, CA
01.2019 - Current
- Coordinate classroom and school events, parties, and fundraisers, including logistics and setup
- Assist teachers with classroom activities and monitored student safety during lunch and field trips
- Prepared weekly class and homework packets and compiled student portfolios
Lead Data Quality Analyst - FASTSearch
First American Corporation
Santa Ana, CA
01.2006 - 01.2011
- Gathered, analyzed and documented business requirements from clients in multiple US regions to support system initiatives
- Translated business needs into functional specifications for technical teams and developers
- Wrote SQL queries to extract, analyze and validate data, identify trends and process improvement opportunities
- Supported UAT and documented technical issues in ticketing systems, tracking issues through resolution
- Monitored, diagnosed and resolved system errors in Production and Testing environments
- Trained, onboarded and mentored new employees on department procedures and systems
Senior Underwriter - Loan Operations
Ameriquest Mortgage Company
Anaheim, CA
01.2005 - 01.2006
- Approved or declined loans based on full loan profiles, with level 2 signing authority earned in only 4 months
- Reviewed loan files and supporting documentation, verifying accuracy, consistency and completeness and compliance with all state and federal regulation as well as company policy
- Produced daily reports for senior management on daily and month-to-date numbers on loans approved, declined and funded
- Appointed Borrower Benefit Assessment point person, training team members on compliance procedures
Financial Analyst - Secondary Marketing/Trading
Countrywide Financial Corporation
Calabasas, CA
01.2004 - 01.2005
- Created weekly and monthly reports using Excel PivotTables, on all loan exceptions for executives
- Created daily reports for Treasury Bank on outstanding $2M+ loan exceptions
- Evaluated, priced, and charged risk-based add-ons on at least 75 loan exceptions daily, about 50% of all submissions to my group
- Oversaw testing and efficient improvements of the Exceptions Processing System (EPS), working closely with investors, underwriters and developers
Education
Bachelor of Arts - Economics, Minor in Business
University of Southern California (USA)
Los Angeles, CA2003
Skills
- Data & Analytics: Data Analysis, Data Quality, Trend Analysis, Root Cause Analysis
- Tools & Reporting: SQL (Querying & Data Extraction), Excel (PivotTables), Reporting & Dashboard Support, Data Visualization
- Business Analysis: Requirements Gathering, Process Analysis, UAT, Documentation, Cross-Functional Collaboration
- Operations & Communication: Process Improvement, Problem Solving, Training & Knowledge Transfer
Timeline
Property Manager & Host
Airbnb
01.2019 - Current
Volunteer - Room Parent, PTA
Hawes Elementary School
01.2019 - Current
Lead Data Quality Analyst - FASTSearch
First American Corporation
01.2006 - 01.2011
Senior Underwriter - Loan Operations
Ameriquest Mortgage Company
01.2005 - 01.2006
Financial Analyst - Secondary Marketing/Trading
Countrywide Financial Corporation
01.2004 - 01.2005
Bachelor of Arts - Economics, Minor in Business
University of Southern California (USA)