🔍 Passionate about Uncovering Insights through Data!🎓 Educational Background: Currently enriching my analytical prowess as a Master of Science in Applied Analytics candidate at Columbia University, I hold a Bachelor of Science in Economics with a minor in Mathematics from New York University. My academic journey has been marked by a deep dive into applied analytics frameworks, research design, statistics, linear algebra, and numerous relevant courses that form the backbone of my analytical skillset.💼 Professional Experience: My journey in the professional world has been diverse and enriching. At Compass Commercial Division, I delved into the real estate sector, where I collaborated on summarizing high-value properties and implementing strategic design and advertising schemes. My stint at Minmetals Securities saw me enhancing transactional integrity through rigorous security inspections and contributing to optimizing financial processes.📊 Analytical Skills & Tools: Armed with proficiency in R, Python, Tableau, and SQL, I have successfully navigated through projects involving large datasets and complex economic variables. From conducting regression analyses to uncovering trends, to utilizing PCA regression to represent financial returns, every project has been a step forward in my analytical journey.🍜 Culinary Passion & Photography: A maestro in Szechuan cuisine, I have crafted over 100 dishes and catered memorable gatherings, bringing the taste of authentic Chinese cuisine to the table. My culinary journey is well-documented through my lens, mentored by a renowned photography professor, and critiqued by my visits to 70+ eateries in New York's vibrant dining scene.🌟 What I Bring to the Table: A harmonious blend of analytical mindset, attention to detail, culinary creativity, and a penchant for solving complex problems through research and applied analytics. I am eager to leverage my skills to unearth insights that steer strategic decisions and elevate organizational success.🤝 Let's Connect!I am eager to engage with professionals who share a passion for data, analytics, and economic research. Whether it's an opportunity, a project, or just a conversation about the latest in analytics, feel free to reach out!
Shanghai Scinova Investment
-
Private Equity Investment Part-Time.Shanghai Scinova Investment Aug 2019 - PresentShanghai, China⚫ Employed Excel functions such as VLOOKUP and Pivot Tables for data organization and analysis; presented findings showcasing the cons & pros of existing investments among peers, aiding the Financial Analysis (FA) Department in having a clearer value comparison of post-investment enterprises.⚫ Utilized SQL's linear regression functions to project the future ROI of a newly invested biopharmaceutical firm, showcasing a 15% higher return compared to initial estimates.⚫ Engaged potential investors and industry peers by tailored content which identified specific data ranges illustrating company's competitive position, strengths, and investment opportunities.
-
Data Analyst Intern.Compass May 2022 - Jul 2022New York, United States⚫ Conducted analysis on high-value properties in the Queens area, gathered data from open sources, and employed SQL for data querying and manipulation, identified a rising trend in property values in specific neighborhoods, contributing to informed investment strategies.⚫ Initiated a proposal for food court enhancement based on analysis of open data platforms and field research, leading to positive feedback from management and further discussions with potential vendors.⚫ Collaborated with team to develop a food court proposal, integrating insights from data analysis, field research, and market trends, fostering a collaborative environment for idea exchange and refining the initial proposal.⚫ Conducted a user persona analysis utilizing ZoomInfo for data collection and Tableau for data analysis, leading to a data-driven advertising strategy for a new office building sale in Queens, expecting higher feedback rates from potential buyers.⚫ Utilized Tableau to visualize user persona data for a new office building sale in Queens, revealing superior accuracy over government data; the insights influenced the revision of our team's advertising strategy, ensuring targeted messaging and optimized advertising channels. -
Fraud Analyst InternMinmetals Securities., Ltd, Chongqing Branch Jul 2021 - Aug 2021Chongqing, China⚫ Automated the trade security classification process by developing an Excel bottom script, reducing classification time by 90% while ensuring accuracy, which established a new workflow, streamlining operations and setting a precedent for similar process improvements within the department.⚫ Conducted data-driven investigations into potentially fraudulent transactions using company fraud detection software, and recommended improvements to fraud detection criteria, enhancing the accuracy of the fraud detection process.⚫ Analyzed customer financial behaviors using Microsoft Excel's Data Analysis Toolpak and Pivot Tables, providing valuable insights to the sales department for tailoring sales strategies, facilitating more targeted and effective customer engagements.
Bill Yuan Education Details
Frequently Asked Questions about Bill Yuan
What company does Bill Yuan work for?
Bill Yuan works for Shanghai Scinova Investment
What is Bill Yuan's role at the current company?
Bill Yuan's current role is Aspiring Data Analyst with a background in Economics & Mathematics | MS in Applied Analytics Candidate at Columbia University | Experienced in Financial Analysis & Real Estate | Proficient in R, Python, Tableau.
What schools did Bill Yuan attend?
Bill Yuan attended Columbia University, 美国纽约大学.
Not the Bill Yuan you were looking for?
-
1asurion.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
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