Ruilan (Helen) Zeng
Financial Mathematics & Economics — Data/Investment Analyst | AI-Driven Workflows
Los Angeles / Paris
Financial Mathematics & Statistics student at UCSB with expertise in private equity analysis, AI-powered automation, and data-driven investment strategies. Experienced in building driver-based models for $250M+ deals and engineering LLM platforms that streamline operations.
Featured Projects
A showcase of my work in financial modeling, AI automation, and data analysis — delivering measurable impact across $250M+ in deals.
LLM Adversarial & Autopatch Platform
Next.js + n8n + Supabase
Co-built a multi-agent AI workflow and web app that automates prompt-injection simulations with logging, metrics, and dashboards. Won both the n8n track & competition among 100+ teams.
Email Outreach Automation Platform
Python + Postgres + Power BI
Engineered LLM-powered platform that personalized email templates, tracked KPIs, managed 3K+ startup leads and 50+ LP/GPs, sent 1K+/day, and achieved 20% proposal conversion rate.
Real Estate Investment Models
Excel VBA + Oracle EPM + SQL
Built driver-based models for $250M+ real estate deals with automated SQL feeds into Oracle EPM, generating live CF & P&L dashboards that reduced pricing decision cycle by 30%.
Investor-Startup Matching Algorithm
Python + Pandas + Visualization
Developed Python pipeline to wrangle heterogeneous datasets into match-score algorithm for pairing investors with startups. Presented to 200+ professionals, facilitating 5 successful matches.
Professional Experience
My journey through financial analysis, private equity, and data-driven decision making.
Lead Data Analyst Intern
Silicon Valley Innovation & Entrepreneurship Forum (SVIEF)
- Engineered an LLM-powered outreach platform (Python, Postgres) that personalized templates & auto-sent emails
- Tracked open/click/reply rates, managed 3K+ leads and 50 LP/GPs, sent 1K+ emails/day, cut outreach time 90%
- Analyzed investor–startup fit in Power BI across check size, stage & geo, coordinated 15 LP/GP and founder demos
- Delivered a 20% proposal conversion rate through data-driven matching algorithms
Private Equity Analyst Intern
Lionchase North America
- Built driver-based models in Excel (macros) & EPM (Essbase) for 5 real estate deals ($250M)
- Automated SQL querying & Smart View refreshes to deliver real-time cash flow & P&L analytics, cutting projected expense 15%
- Developed & presented 3 Private Placement Memorandums at key investor conferences, secured $10M funding
- Led team of 6 to engineer a scenario-testing engine in Excel VBA for 3 private credit funds ($99M), lifted projected return by 20%
Data Analyst Intern
Triangle Accounting
- Analyzed high-volume data transactions for 30+ clients using QuickBooks & AI bookkeeping tool Datamond
- Ensured data accuracy in payroll records & tax forms, leveraging automation to identify tax savings
- Audited 1099-K and Form 1120 filings, identified discrepancies, and prevented $40K+ in IRS penalties
Skills & Technologies
Technical skills and domain expertise across finance, data analysis, and AI automation.
Finance & Analysis
Data & Programming
AI & Automation
Education
B.S. Financial Mathematics & Statistics; B.A. Economics & Accounting
UCSB
- STEM Scholarship for African and Asian Students (top 3% of students)
- Dean's Honor List
- Study abroad: Sciences Po Paris (Law & Regulation)
- University of Hong Kong (Economics & Finance)
- Coursework: Math Finance, Regression Analysis, Machine Learning, Numerical Analysis, Stochastic Processes
Awards & Achievements
Hackathon Winner — LLM Adversarial & Autopatch Platform
STEM Scholarship for African and Asian Students (top 3% of students)
Dean's Honor List