Real Estate Business Analyst

With * years of experience in real estate company planning, I specialize in crafting data-driven sales strategies. My Master's degrees in Analytics and Project Management have equipped me with skills in data collection, EDA, visualization, modeling, and effective communication. Proficient in managing various aspects, such as scope, schedule, cost, and quality. I am well-versed in tools like R, Python, Tableau, MySQL, and MS Project, enhancing my ability to provide valuable insights and drive informed decisions Data Collection

Exploratory Data Analysis (EDA)

Data Visualization

Data Modeling

Effective Communication

Business Analysis

SQL

Python

Tableau

PROFILE

+626-***-**** · ***.*@************.*** · 19009 Brittany Pl, Rowland Heights, CA, 91748 https://www.linkedin.com/in/bai-qinghua/

QINGHUA BAI

STRENGTHS AND EXPERTISE

Business Analyst(Externship)

Hewlett-Packard Company(HP), New York, United States Conducted comprehensive research on HPTV's offerings, startup collaborations, and investment strategies, while acquiring a solid grasp of the startup ecosystem, venture capital, and angel funds, ultimately facilitating more informed decision-making Assessed various startups for potential collaboration and investment, meticulously analyzing critical aspects such as company size, customer base, annual revenue, product pricing, and Total Addressable Market (TAM), resulting in well-founded recommendations that guided HPTV's strategic direction

Developed persuasive presentation materials highlighting chosen startups and presented a compelling case for Zixi, which boasts a $138.6 million TAM and a clientele of over 2000 organizations during the final meeting, resulting in HPTV's leader considering Zixi as a potential partner for mutual growth and success

Sep 2023- Nov 2023

PROFESSIONAL EXPERIENCE

Business Analyst

Conducted thorough market research in Sheyang Hunnan District real estate market, identifying customer needs and prevalent market issues

Prepared comprehensive reports utilizing MS PowerPoint, integrating survey findings, and employing R and Python, leading to a 20% improvement in data driven decision-making Collaborated with leadership to leverage research insights, enabling strategic decision-making that yielded enhanced company benefits

Huamei Real Estate Co. Ltd., Shenyang, China Nov 2020 - Feb 2022 Huamei Real Estate Co. Ltd., Shenyang, China Jun 2019 - Aug 2019 Attained valuable insights into the influential role of data in shaping marketing and business decisions, facilitating a deeper understanding of data-driven strategies Proficiently acquired computer skills for comprehensive data handling, showcasing adept use of MS Excel for precise recording, processing, and insightful visual analysis, resulting in efficient data manipulation and interpretation

Developed an advanced proficiency in crafting real-world business analysis reports using MS PowerPoint, empowering the delivery of findings with clarity and contributing to well-informed decision-making processes

Business Analyst

PROJECTS

Meidi Real Taihe Prefecture Project

Business Analysis Project Jun 2021 - Feb 2022

Utilized MS Excel to analyze market conditions and historical data, identifying optimal building sales channels, house pricing, and customer types, resulting in a notable 27% month-on-month upswing in project sales volume

Optimized external sales teams, crafting impactful sales strategies through data analysis using MS Excel and Tableau, leading to a substantial 32% improvement in sales team performance compared to the previous year

Vanke China-Germany International Community Project Business Analysis Project Nov 2020 -Jun 2021

Supported the planning team as an intern planner, utilizing MS Excel for market data collection and data visualization, resulting in a streamlined process that saved the team approximately one hour daily for exploratory data analysis

Successfully sourced agents for project's festival promotion activities, overseeing budget management and achieving a cost reduction of approximately 8%, contributing to enhanced project financial efficiency

Used the data set about different startups that HP provided and analysis them. Analyzed the correlation coefficient between different variables to determine the key factors that affect the company success.

Found out that total funding amount and number of employees are the most relatively factors to company success with correlation coefficient are 0.8 and 0.5. HPTV Project

Business Analysis Project Sep 2023 - Nov 2023

LEADERSHIP EXPERIENCE

Mentor

The University of Arizona-College of Education Jan 2018 - May 2020 Exercised strong leadership skills, guiding and advising local students to enhance their academic performance

Collaborated with fellow students to strategize and deliver impactful academic lectures, contributing to enhanced comprehension and engagement Showcased adept organizational abilities by coordinating diverse student activities, effectively fostering teamwork and facilitating a 25% increase in active participation Team Lead

The University of Arizona-Confucius Institute Nov 2019 - Dec 2019 Organized and managed diverse cultural events, successfully promoting Chinese culture and enhancing diversity awareness, resulting in a 30% increase in local citizen participation Inspired heightened interest in Chinese culture, driving a 25% increase in cultural day activity engagement among the university community

Master of Professional Studies in Project Management Northeastern University

EDUCATION

April 2023

Master of Professional Studies in Analysis

Northeastern University July 2022

Contact this candidate