Commercial Real Estate Analyst

EDUCATION

Sebastian Polackal

+1-747-***-**** *************@*****.*** Los Angeles, California LinkedIn University of California, Los Angeles (UCLA) Los Angeles, CA Master in Quantitative Economics Sep 2022 – Jun 2024

• Areas of Focus: Econometrics, Macroeconomics, Portfolio Design, Asset Pricing, Cloud Computing, Big Data

• Bruin Poetry, Bruin Stock Group, Bruin Real Estate Association, Advanced Degree Consulting Club Christ University, Bangalore Bangalore, India

Bachelor of Science, Economics, Mathematics, Statistics Jun 2018 – Jun 2021

• Thesis: Vehicular Green Taxes: “A comparative study of India and Israel”

• Scholarship: Extra and co-curricular activities

PROFESSIONAL EXPERIENCE

Property Tax Advisors Los Angeles, CA

Commercial Real Estate Analyst Jan 2025 – present

• Modeled 60+ real estate deals worth over $75M using DCF and valuation tools to support litigation and property valuation, sourcing data from CoStar, Chicago Title, and CRMLS to compile case-ready reports for senior management

• Created algorithm to analyze dynamics of California’s real estate market using Lasso regressions and ARIMA models to identify opportunistic submarkets and estimating deal risk for undertaking valuation cases using win ratios

• Implemented Sales Comp and Income Capitalization approach to build cashflows projections, ensuring robust property valuation, and accurate pricing benchmarks for ~20% increase in deal viability

• Appealed valuation cases under ‘Prop 8’ and base value reduction, across 14 counties in California, achieving a win ratio of ~36% through robust financial modeling and defensible property insights tailored to local real estate trends Calmwater Capital Los Angeles, CA

Intern Jul 2023 – Aug 2023

• Created financial model and deal memo for the $21M ‘Lakes at Madera’ deal, by researching and analyzing data from Costar and Apartments.com, to finance bridge loan for multifamily property based out of Baytown, Texas

• Analyzed sizers to underwrite deal, and conducted market study by compiling database of leases and rental agreements for Baytown submarket in Texas, to build DCF model for investment assessment UCLA Anderson School of Management Los Angeles, CA Graduate Student Researcher Dec 2022 – Jun 2023

• Conducted research under the Chair of Management to analyze relationship between emotions and populist tendencies, examining emotional responses and biases in datasets developed over 10 years, using regression models

• Performed due diligence on econometric models, replicated results coded in R using Stata, ensuring they matched expected formats for a journal publication in the Journal of the European Economic Association Zomato Media Ltd. Bangalore, India

Business Analyst Jun 2021 – Jul 2022

• Created business strategy and development plans for clientele enterprises of Zomato, a food tech unicorn startup, adopted for holiday season 2021-22 to drive growth and expansion and saw an uptake of 67% in sales

• Managed and contributed to growth and development of largest hospitality client by business volume; and drove innovation by re-engineering menu offerings and outreach by expanding product line by 20+ products

• Led presentations and client conversations as part of initial public offering transition team, leading to partnerships with company, support for ongoing deals and investments in advertising and selective marketing for user cohorts LEADERSHIP ROLES AND PROJECTS

UCLA Capstone Project – Author Los Angeles, CA

“Oil price increases and regional inequality” Mar 2024 – Jun 2024

• Analyzed interaction of population share engaged in oil and gas production, data from IPUMS USA, with annual crude oil prices using high dimensional fixed effect regressions, across geographies and time periods

• Summarized findings to show rise in oil prices correlates with increase in employment and income per capita, in regions with strong oil presence, results consistent across the country, published in postgraduate thesis UCLA MQE Applied Project – Data Scientist Los Angeles, CA Interscope Records Jan 2023 – May 2023

• Worked on a team of five to consult with Interscope Records team to close demand-supply gap through forecasting sales of CDs and vinyl of different artists, based on album popularity, using time-series data obtained from Spotify

• Modeled data using decision trees and machine learning models for identifying precursors for sales, gave recommendations to streamline manufacturing and manage inventory, minimizing loss by 5% of sales revenue SKILLS AND CERTIFICATIONS

• Data Modeling: R Studio, Stata, Argus, MS Excel

• Data Management: Python, SQL, Web Scraping

• Certifications: Bloomberg Market Concepts- Bloomberg, SQL Intermediate- HackerRank

• Hobbies: Hiking, Poetry, Reading, Tennis, Cooking

Contact this candidate