CLARK BOYCE

about

work

contact

Education


B.A. Economics, Minor in Data Science | GPA: 3.70
Coursework

Economics and Finance: Corporate Finance, Financial Accounting, Econometrics, Micro & Macroeconomics, International Trade & Finance, Development Economics Data Science and Computing: Data Structures, Principals & Techniques of Data Science, Applied Geographical Data Science, Linear Algebra, Web Development Other: Supply Chain Network Design, International SME Consulting, Tourism Development, Oil & Gas Operations and Markets

Languages: English (Fluent), Chinese (Intermediate)

Technical Skills: Python, Java, SQL, Tableau, Power BI, Financial Modeling (3-statement, DCF, CRE)

Experience

Newmark

Debt and Structured Finance Intern
  • Underwrote over $400 million in debt financing for senior and bridge loans and $80 million in retail property sales using DCF models.
  • Engineered a VBA script to reformat leasing information imported from Argus to Excel; effectively saving two hours for each property.
  • Created a comprehensive dashboard of generative AI applications and funding in the bay area to be used in future debt pitches; Power BI dashboard includes summary information for 40+ companies and highlights corollary impacts to commercial real estate.

Berkeley International Consulting

President and Senior Advisor
  • Founding member of BIC which has expanded from its inception with seven members to over 40 members representing 20+ countries.
  • Led project planning for four projects across Asia, Europe, North and South America each semester working together with executives and start-up founders from companies in various industries including Adobe, Beforepay, Nestle, and Emirates Airlines.
  • Project Manager for Centroid, Bobacino, So-Syncd, & LATAM Airlines

UC Berkeley Scholarships Office

Assistant Analyst
  • Oversaw cleaning, transformation, and migration of data concerning ~1200 scholarships and grants to new SQL database which helped remove data inaccuracies and streamline financial reporting processes with Berkely endowment and other external awarding entities.
  • Leveraged new data systems to identify funding gaps based on select demographics and performed outreach to potential donors.

Projects

LATAM Airlines

Created an automated workflow in Pipedream which utilized Google Bard, GPT-3.5, and Google Maps APIs to create a personalized trip plan based on a LATAM destination. Additional API’s were used to pull and utilize flight, hotel, and activity data for final result. Designed front-end mockups for AI chatbot, transportation, and trip planning app features dedicated to passenger experience.

So-Syncd Dating

Developed go-to-market strategy for UK-based dating app in five US metros with budgets between $5k and $50k. Created stakeholder interview and performed user journey mapping to find pain points affecting customer retention and ease of use. Prototyped 10 new features in Figma focused around in-app navigation, profile personalization, and increasing user engagement.

Bread for the World

Worked with the data management team and utilized Python to clean and format large datasets from FAO (140k entries) and the World Bank (69k entries). Focused on enhancing data quality for advanced visualizations and regional analysis of political and economic stability on food security indicators. We employed logistic regression analysis to identify four key indicators including national cereal import dependency ratio, absence of violence and terrorism, and total retail distribution losses.

CampusTicket

Created a website with classmates to simplify peer-to-peer ticket resales for popular campus events.


You can contact me