Yuran Pan's Location
Seattle, Washington, United States, United States
Yuran Pan's Contact Details
Yuran Pan work email
- Valid
- Valid
- Valid
Yuran Pan personal email
n/a
About Yuran Pan
Expertise:Analytics, Data Mining, Machine Learning, NLP, Deep Learning
Yuran Pan Work Experience Details
-
Data ScientistDiscord Mar 2023 - PresentSan Francisco, Ca, Us -
Data ScientistTwitter Jun 2021 - Jan 2023San Francisco, Ca, Us -
Business Intelligence Engineer, Alexa ShoppingAmazon Feb 2020 - May 2021Seattle, Wa, Us -
Data ScientistVacasa Jun 2019 - Aug 2019Portland, 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； -
Data ScientistScout. Jan 2019 - May 2019New 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 -
AssociateMiac - Mortgage Industry Advisory Corporation Jan 2018 - Jun 2018New 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 -
Financial Analyst-Capital Market GroupMiac - Mortgage Industry Advisory Corporation Sep 2015 - Dec 2017New York, Ny, Us
-
Macroeconomics TutorOberlin College Feb 2015 - May 2015Oberlin, Oh, Us -
Teaching AssistantOberlin College Aug 2012 - May 2015Oberlin, Oh, UsGrader for Chinese Studies 101Organized weekly tutorial sessions for Mandarin language students
-
Environmental Studies Department AssistantOberlin College Aug 2012 - Sep 2014Oberlin, Oh, UsWorked with the Environmental Studies Office to promote, organize, and curate departmental events, speaker series, and other departmental logistics.
-
Cbsm ResearcherOberlin College Community-Based Social Marketing (Cbsm) Group Feb 2015 - May 2015Designed 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).
-
Student AssistantOberlin College Luce Initiative On On Asian Studies And Environment (Liase) Jan 2015 - May 2015Planned 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.
-
Board MemberOberlin College Green Ecological Design And General Efficiency (Edge) Fund Feb 2014 - May 2015Worked 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
-
Sustainability InternEnvironmental Health Research Associates, Llc ; Green Buddha Life Sustainability Center Jun 2014 - Aug 2014Documented 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.
-
Research And Communication InternOberlin Bussiness Partnership Jan 2014 - May 2014Conducted 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.
-
Sustainability Task Force MemberDis – Danish Institute For Study Abroad Sep 2013 - Dec 2013København K, DkFigured 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. -
InternInstitute Of Cultural Affairs Jan 2013 - Feb 2013Chicago, Illinois, UsContributed 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. -
InternChicago Community Climate Action Toolkit Jan 2013 - Feb 2013Produced a literature review on social sustainability;Managed Toolkit social media platform.
Yuran Pan Skills
Environmental Awareness
Corporate Social Responsibility
Sustainability
Environmental Consulting
Microsoft Office
Statistical Modeling
Sustainable Business Strategies
Spss
Arcgis
Marketing
Teamwork
Energy Efficiency
Leed Projects
Data Analysis
Sql
Business Analytics
Python
Rstudio
Tableau
Cecl
Yuran Pan Education Details
-
Oberlin CollegeEnvironmental Studies -
Fordham UniversityData Science
-
Danish Institute For Study AbroadEnvironmental Sustainability
-
Nanjing Foreign Language SchoolHigh School
Frequently Asked Questions about Yuran Pan
What company does Yuran Pan work for?
Yuran Pan works for Discord
What is Yuran Pan's role at the current company?
Yuran Pan's current role is Data Scientist | Discord.
What is Yuran Pan's email address?
Yuran Pan's email address is yu****@****lin.edu
What schools did Yuran Pan attend?
Yuran Pan attended Oberlin College, Fordham University, Danish Institute For Study Abroad, Nanjing Foreign Language School.
What are some of Yuran Pan's interests?
Yuran Pan has interest in Flute, Hip Hop Dancing, Diy Crafting, Contemporary Dance, Painting, Blues Dancing.
What skills is Yuran Pan known for?
Yuran Pan has skills like Environmental Awareness, Corporate Social Responsibility, Sustainability, Environmental Consulting, Microsoft Office, Statistical Modeling, Sustainable Business Strategies, Spss, Arcgis, Marketing, Teamwork, Energy Efficiency.
Free Chrome Extension
Find emails, phones & company data instantly
Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Aero Online
Your AI prospecting assistant
Select data to include:
Total price:
$0.00
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial