Yuran Pan Email & Phone Number

San Francisco, Ca, Us

San Francisco, Ca, Us

Seattle, Wa, Us

Portland, Or, Us

-Trained deep learning models in Python to find listings' similarities by learning users click actions for both exploratory and booked sessions；-Presented research findings on real-time personalization recommender system using embedding to Data Science team-Extracted data from Amazon Redshift in SQL and create python modules as part of ETL pipeline for feature engineering；

New York, Us

-Designed metrics and scoring system for real estate agents to be used by the ranking system;-Built innovative visualizations and interactive heatmaps with Plotly and Folium in Python and in Tableau;-Acquired real estate raw dataset from various data sources through web scraping and API;Extensive EDA Analysis to onboard new data

New York, Ny, Us

-Built forecasting models for macroeconomics indexes with Moving Average smoothing technique -Conducted pricing for multi-million transitional loans on office, residential, hospitality, and retail sectors by analyzing borrower’s business revenue streams and the loan performance-Analyzed monthly Commercial Real Estate (CRE) loan collateral performances based on attribute updates and key indicators and built SSRS reports to track monthly changes-Conducted extensive financial modeling for multi-billion-dollar transitional loan portfolio valuations-Developed and maintained a SQL-backed ETL pipeline to scrub and normalize source data sets-Wrote Ad-Hoc SQL queries to extract data for retrospective analysis on monthly basis-Led project management for proprietary valuation software and data pipelines; coordinated weekly cross-functional meetings between software developers and financial analysts

New York, Ny, Us

Oberlin, Oh, Us

Oberlin, Oh, Us

Grader for Chinese Studies 101Organized weekly tutorial sessions for Mandarin language students

Oberlin, Oh, Us

Worked with the Environmental Studies Office to promote, organize, and curate departmental events, speaker series, and other departmental logistics.

Designed and launched CBSM pilots to encourage a reduction of consumption for energy and water;Gathered data from various sources (surveys, energy dashboard, etc) conducted qualitative and quantitative data analysis;Produced a study report for publication (in progress).

Planned faculty development seminars and guest lectures for students;Planned a study trip to Japan for faculty and students;Promoted events by managing Luce Initiative website and producing brochures and posters.

Worked collaboratively to manage $ 250,000 dedicated to fund sustainability, efficiency and carbon off-set projects in Oberlin College and community;Communicated with stakeholders of all levels to follow up project development;Attended weekly meetings to provide feedback on ongoing work

Documented LEED gold certification for a commercial building and uploaded the information to USGBC; Planned and coordinated the weekly film screening events pertaining to environment and health for the community; Created and managed a website using Square Space platform; Promoted the business through marketing using Facebook and MailChimp; networked with other businesses to encourage them to participate in the Green Business Map initiative.

Conducted research and survey on potential economic development for bike-friendly communities;Communicated and cooperated with local businesses, organizations and residents for solutions;Produced a communication plan for the City of Oberlin.

København K, Dk

Figured out ways that DIS can make its practices more environmentally sustainable in relation to its facilities operations, resource consumption, waste generation, etc.; andPromoted a culture of higher environmental regard amongst DIS staff, faculty and students by raising awareness, practical know-how, and enthusiasm to act on both an individual and group level.

Chicago, Illinois, Us

Contributed to the ICA's Accelerating Green Initiatives in Chicago's 77 Neighborhood project;Generated ideas to the projects with the majority of the ICA staff during weekly meetings;Manged and revised database through online research and phone calling.

Produced a literature review on social sustainability;Managed Toolkit social media platform.

Bachelor'S Degree, Environmental Studies

Master Of Science - Ms, Data Science

Environmental Sustainability

High School