Bowei Han
Marketing Analyst at Future Sphere- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English -
-
Chinese -
Topline Score
Bio
Credentials
-
Lean Six Sigma Green Belt
Penn State University
Experience
-
Future Sphere
-
United States
-
Education Administration Programs
-
1 - 100 Employee
-
Marketing Analyst
-
Jun 2023 - Present
• Customer analysis: Designed the data research plan for target customers of newly launched project. Conducted in-depth analysis of the customer database and evaluated current marketing outcomes. Formulated a data model to identify key characteristics of prospective customers. Performed data reconciliations and create recurring and ad-hoc reports. • Database management and support: Built and maintained datasets and queries used for reporting and customer analysis. Managed monthly ETL processes. • Experiment design: work with the architecture team to design experiments and find new ways to deliver value to the customer. Show less
-
-
-
ICAS Pharmaceutical Technology (Shanghai) Co., Ltd
-
Shanghai, China
-
Marketing Analyst
-
Sep 2019 - Sep 2021
• Data Management & Automation: Utilized SQL, Python, and R to automate data processes, ensuring timely report generation. Successfully migrated 500,000+ customer records to a MySQL database and addressed 30,000+ instances of missing data using SQL. This system processes over 500 customer acquisition data points daily. • Pharmaceutical Marketing Strategy & Physician Outreach: Drove the marketing direction of the company by analyzing SEM data and understanding physician-prescribing trends. This data-driven strategy engaged over 500 healthcare professionals daily, optimizing our outreach and education efforts. • Customer behavior analysis: Conducted thorough analysis of target customer behaviors and formulated reports and tailored strategies, resulting in a notable 70% increase in active customers from 2019 to 2021. • Cross-Functional Collaboration: Worked seamlessly with teams spanning IT, sales, and finance. This synergy ensured a comprehensive grasp of business needs, paving the way for informed, data-backed insights and recommendations. Show less
-
-
Education
-
2022 - 2023
Columbia University in the City of New York
Master's degree, Applied Analytics -
2015 - 2019
Penn State University
Bachelor's degree, Industrial Engineering
Community
