QIQI CAO
Financial Analyst; Realty Advisor; Project Manager
SF Bay Area,CA
Summary
Results-driven professional with extensive experience at Stanford University in financial modeling and compliance. Achieved a 75% increase in reporting efficiency through process automation and cross-functional collaboration. Proven ability to support property management decisions with in-depth market analysis and data-driven insights. Skilled in contract negotiation and dedicated to providing exceptional service in real estate transactions.
Overview
22
22
years of professional experience
1
1
Certification
Work History
Real Estate Consultant
BQ Realty Group
San Jose, California
06.2023 - Current
- Provided expert guidance on property market trends to clients.
- Conducted comprehensive property evaluations and inspections.
- Facilitated negotiations between buyers and sellers effectively.
- Assisted clients in understanding financing options and processes.
- Cultivated strong relationships with clients to enhance service delivery.
- Prospected for new commercial and residential real estate deals.
- Negotiated with buyers, sellers, landlords and tenants to reach favorable agreements.
- Drafted and reviewed contracts, purchase agreements, deeds and leases.
- Researched zoning restrictions, deed limitations, environmental issues, title searches and other matters related to real estate transactions.
- Managed multiple projects simultaneously while meeting tight deadlines consistently.
Research Administrator
Stanford University
Stanford, CA
11.2014 - 05.2025
- Managed ~$20 million portfolio, leveraging 10 years of expertise in advanced financial modeling for budgeting and forecasting.
- Developed project orientation model with just-in-time training on new policies and procedures.
- Presented innovative solutions at the NCURA conference, receiving recognition from hundreds of professionals.
- Created automated financial reporting solutions, streamlining tracking for 30+ global research teams.
- Led financial planning and forecasting for international projects within Stanford's School of Engineering, ranked second globally in 2024.
- Contributed to new salary processing systems, establishing online signature portal serving approximately 4,700 users.
- Advised field leaders on funding opportunities, resulting in a 67% increase in awarded funds within three months.
- Ensured compliance with government regulations and university policies across numerous sponsors.
Grants Analyst
California State University, East Bay, Office of Research & Sponsored Programs
Hayward, CA
11.2012 - 11.2014
- Managed financial models for 100+ restricted research projects, overseeing budgeting, variance analysis, and compliance.
- Initiated SQL+ enabled reporting system for the university master record, led the institutional office to replace paper tracking systems successfully.
- Developed and implemented automated systems for tracking global funds, improving reporting efficiency and reducing administrative overhead.
- Led forecasting and budget planning, ensuring timely, accurate financial adjustments across multiple global projects.
- Initiated innovative automated analysis and closeout systems, increased accuracy by 50% and enhanced efficiency by 75%; made it available for institution-wide support.
- Supported faculty and staff with interpreting contract guidelines and ensuring compliance with sponsor regulations.
- Designed internal audits, identified financial discrepancies, and recommended corrective actions.
Projects & Grants Manager
Asian Medical Clinic of Fremont
Fremont, CA
03.2010 - 03.2012
- Developed financial models for capital improvement projects and government contracts, ensuring compliance with HRSA and CMS-funded initiatives.
- Led automated processes for financial tracking and project reporting, improving efficiency and accuracy across multiple projects.
- Cultivated partnerships with UCSF and St. Rose Hospital, expanding clinic operations by 25%; led the organization meeting CA Title 22 requirements.
- Increased 3-site clinic efficiency by 16x times, reduced patient waiting time from 4 hours to 15 minutes.
- Directed internal audits, established compliance policies, and trained staff on initiated SOPs and ensured federal regulatory standards.
Radio Show Host
Sing Tao Radio Station
San Francisco, California
08.2003 - 06.2009
- Facilitated live coverage of special events, promotions, and sports matches.
- Interviewed local and international celebrities to raise brand profile and build listener engagement.
- Engaged listeners through social media platforms to increase station visibility.
- Produced creative radio segments focused on music, current events and lifestyle topics.
- Recorded and edited high-quality interviews and audio clips for broadcast.
- Hosted promotional events to create station awareness and build community reach.
- Researched topics for comment and discussion.
- Conferred with advertising partners to develop and deploy effective promotional strategies.
Grants Analyst
Northern California Institute for Research & Education
San Francisco, CA
06.2006 - 06.2009
- Managed $13+ million earmarked military funds for PTSD and Alzheimer's research at UCSF and SFVAMC, ensuring compliance with federal guidelines.
- Created financial models for analyzing grants, tracking project budgets, and enhancing funding allocation transparency.
- Initiated automated reports tracking system, Coordinated financial forecasting and planning, ensuring successful project outcomes in line with sponsor regulations.
- Led fundraising initiatives and organized large-scale events for stakeholders and sponsors.
Education
Master of Business Administration (MBA) - Executive Business Administration
San Francisco State University
San Francisco, CA05.2008
Bachelor of Arts - Chinese Language & Literature Education; Communication & Journalism (2nd Major)
Guangzhou University
Guangzhou, Guangdong, China06.2001
Skills
- Financial modeling and reporting
- Budgeting and forecasting
- Process automation and improvement
- Global financial planning
- Risk assessment and compliance
- Cross-functional leadership
- Grants management and negotiation
- Financial systems management
- Project management
- Staff training and development
- International collaboration
- Governmental regulations knowledge
- Oracle financial systems expertise
- SAP financial systems expertise
- Microsoft Excel proficiency
- Tableau data analysis tools
- SQL data analysis tools
- MS Access data analysis tools
- Microsoft Office Suite project management tools
Certification
- Master of Business Administration (MBA), Graduated
- Stanford Cardinal Curriculum I & II Certification, Stanford University, 12/01/14
- Project Management Professional (PMP) Course, Stanford University, 06/01/19
- National Education Credential, Guangzhou University, China, 06/01/01
Accomplishments
- Inquired and closed large commercial lease deals promptly for clients including reputable medical corporations and dominant whole-sell leaders.
- Managed multi-million-dollar research budgets, providing comprehensive financial reports to stakeholders and ensuring compliance with all sponsor guidelines.
- Implemented process improvements that reduced financial reconciliation time by 30% at Stanford University, enhancing efficiency.
- Led teams through successful audits, ensuring 100% compliance with federal guidelines and institutional regulations.
- Negotiated with sponsors and successfully inquired more funds for clients in advance, 6%-67% more inquired.
- Successfully negotiated contracts to ensure maximum benefits, smooth operation and success for clients.
- Initiated and built financial modules to ensure efficient analysis and reporting.
- Trained and coordinated staff in different departments with different concerns to achieve the best results together.
References
Available upon request.
Languages
- English
- Mandarin
- Cantonese
Languages
Chinese (Cantonese)
Native/ Bilingual
Chinese (Mandarin)
Native/ Bilingual
References
References available upon request.
Timeline
Real Estate Consultant
BQ Realty Group
06.2023 - Current
Research Administrator
Stanford University
11.2014 - 05.2025
Grants Analyst
California State University, East Bay, Office of Research & Sponsored Programs
11.2012 - 11.2014
Projects & Grants Manager
Asian Medical Clinic of Fremont
03.2010 - 03.2012
Grants Analyst
Northern California Institute for Research & Education
06.2006 - 06.2009
Radio Show Host
Sing Tao Radio Station
08.2003 - 06.2009
Master of Business Administration (MBA) - Executive Business Administration
San Francisco State University
Bachelor of Arts - Chinese Language & Literature Education; Communication & Journalism (2nd Major)
Guangzhou University
Similar Profiles
Santos LetourneauSantos Letourneau
Cashier at Bono's Pit Bar BQCashier at Bono's Pit Bar BQ
Zulema Ramos PérezZulema Ramos Pérez
Analista químico en laboratorio de fábrica. at BQ. ISAMAR CASTILLO MARINAnalista químico en laboratorio de fábrica. at BQ. ISAMAR CASTILLO MARIN
KaiFung ChanKaiFung Chan
Teacher at BQ Tuition CentreTeacher at BQ Tuition Centre
CLAIRE TEMPORALCLAIRE TEMPORAL
Operations Support & Launch Specialist at Krispy Krunchy Foods LLCOperations Support & Launch Specialist at Krispy Krunchy Foods LLC
Jade WangJade Wang
E-commerce & Marketing Specialist at Molto Bene( Prima VINI)E-commerce & Marketing Specialist at Molto Bene( Prima VINI)