Badges
Certifications
ShaunW has not earned any certificates yet.
Work Experience
Analytics and Reseaerch Consultant
Oxo Group• July 2020 - Present
- As Oxo Group prepares to register business overseas in US, compiled 70+ slides analytical research on state/city selection and best fit. With the metrics focusing on, state-specific corporate income tax policies, overall tax burden ranking per state, effective total state & local tax rates on median state household, median home sales price for the state’s major city and its projected 10 year growth, cost of business registration, poverty rates, population distribution / safety ratings. Research focused on low tax states including: Florida, Delaware, Nevada, Texas, Maine, Wyoming. - Assisted in company filling and registration processes in US.
Research Assistant
Columbia University Media Center• June 2020 - August 2020
- Assisted joint-department (Data Science & Art History) computer vision project that attempted to automate half-tone differentiation tests. Catalogued 2000+ half-tone photographs / DFT-inputs in order to improve AI accuracy. Most Half-tone identifications had statistical significance, with p-value of 0.05. - With Flash Player’s 2020 EOL, was tasked to retrieved 25+ embedded SWF project files on Media Center website for archival preservation. Wrapped existing project SWF files with Ruffle Flash Player emulator.
Client Development Intern
David Zwirner• January 2020 - April 2020
- Restructured 240+ client profiles within database, pinpointing those IOUs inquiries from 2018 - 2020. Processes included targeting client contact type, net worth/assets, comparative collections, and biographies. - Compiled 200+ client preliminary pre-fair market data for Frieze LA 2020 to maximize the client’s acquisition probability. The data provided critical support and insights to primary sales team operating on the ground in order to better engage with clients.
Investment Analyst
Recharge Capital• September 2019 - December 2019
- Performed due diligence and BMC approach on Mexican co-living Real Estate Technology (LaaS Model) startup. Directly worked with the startup’s C-suite to model the company’s unit economics and contribution margins. Proposed downside risk and mitigants to further assist the VC’s commitment decision on the startup. - Since S-REITs’ 18% growth in 2019, was tasked to compile market reports on 39 S-RIETS based on Interest Coverage Rates, Yield Rates, 5-year Average Market Value, and REIT gearing averages. Reports assisted general partner's decision in macro market entry.
Strategy Consultant
Beijing Center for the Arts + MVRDV• June 2019 - August 2019
- Assisted MVRDV to strategically curate cultural, commercial, and residential real estate districts for new Hangzhou cultural heritage zone, located between AliBa-Ba’s new HQ and WisCloud Valley. Aimed to balance artistic ecology with surrounding tech-savvy audience through low Floor Area Ratios and Building Coverage Ratios, while balancing commercial capitalization rates. - Led intern team to compile data on urban development comparative analysis report. Data focused on project value-adds that has: 1. improved surrounding art / cultural ecology, 2. constructed adjacent commercial malls, and 3. allocated high-density residential buildings. - Assisted corporate structure planning and restructured revenue model that synthesized internal operations, external sponsorships, and local government support. Won bid for project with $300 million in financing.
Education
Columbia University, New York