Hequan(Helen) Zhang
Senior Analysis Manager at Strategic Research Insights- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Full professional proficiency
-
Chinese Native or bilingual proficiency
Topline Score
Bio
Brian Brown
Over the past year Helen has excelled in our internship program with Community Informatics Inc. She has performed a full comprehensive project ranging from data collection/scraping to data mining, analysis and ultimately representing KPI’s with interactive visuals to highlight her findings. In addition, her skill sets go beyond data analysis and presentation but also extend to her approach-ability and pleasant demeanor in assisting in on-boarding successive intern teams to pass the baton to further the long-range project.
Brian Brown
Over the past year Helen has excelled in our internship program with Community Informatics Inc. She has performed a full comprehensive project ranging from data collection/scraping to data mining, analysis and ultimately representing KPI’s with interactive visuals to highlight her findings. In addition, her skill sets go beyond data analysis and presentation but also extend to her approach-ability and pleasant demeanor in assisting in on-boarding successive intern teams to pass the baton to further the long-range project.
Brian Brown
Over the past year Helen has excelled in our internship program with Community Informatics Inc. She has performed a full comprehensive project ranging from data collection/scraping to data mining, analysis and ultimately representing KPI’s with interactive visuals to highlight her findings. In addition, her skill sets go beyond data analysis and presentation but also extend to her approach-ability and pleasant demeanor in assisting in on-boarding successive intern teams to pass the baton to further the long-range project.
Brian Brown
Over the past year Helen has excelled in our internship program with Community Informatics Inc. She has performed a full comprehensive project ranging from data collection/scraping to data mining, analysis and ultimately representing KPI’s with interactive visuals to highlight her findings. In addition, her skill sets go beyond data analysis and presentation but also extend to her approach-ability and pleasant demeanor in assisting in on-boarding successive intern teams to pass the baton to further the long-range project.
Credentials
-
SQL Tips, Tricks, & Techniques
LinkedInMar, 2020- Nov, 2024 -
CFA LEVEL III (passed)
CFA InstituteJun, 2016- Nov, 2024 -
Financial Risk Manager (FRM®)
GARP FRM ProgramMay, 2016- Nov, 2024 -
Advanced Google Analytics
GoogleAug, 2017- Nov, 2024 -
Bloomberg Market Concepts Certificate
Bloomberg LP
Experience
-
Strategic Research Insights
-
United States
-
Market Research
-
100 - 200 Employee
-
Senior Analysis Manager
-
Dec 2021 - Present
-
-
Analysis Manager
-
Aug 2020 - Dec 2021
Led market research, customer research, data analytics and predictive modeling:• Developed conjoint design and statistical models (CART & multinomial logistic regression) to assess physician prescribing habits and its sensitivity on different attribute levels of patient profiles• Built SAS macros to automatically compile, concatenate and merge multiple sources of big claims data, reducing 60% the processing time of data integration• Established and improved the process to update weekly and monthly performance metrics that provide drug’s pre-launch and post-launch market landscaping• Developed, tested and implemented robust statistical models, such as logistic regression, Dicision Tree and statistic hypothesis testing, to tease out business insights: identified business trend, derived the importance of products’ attributes, forecasted the products’ dynamics of market share• Preliminary data analysis on survey data and large secondary dataset included cleaning, pivoting and distributing: Cleaned the raw data with missing values and outliers, evaluated data quality and created analytic datasets• Finalized syntax to develop and generate monthly, quarterly dashboard and provide wave trended reports (SAS, SPSS, VBA, SQL)• Visualized data characteristics by using R and Tableau, such as perceptual map, heat map• Provided training and mentorship to a team of data analyst and assisted with prioritizing multi-projects• Managed multiple projects simultaneously and quickly responded to research requests from clients Show less
-
-
Business Data Analyst
-
Jun 2018 - Aug 2020
• Developed global physician and patient segmentation framework to identify, size and effectively reach actionable segments that will drive clients’ product uptake and growth using factor analysis, principal component analysis, classification and regression tree (CART) techniques. Helped drive insights to determine the customized marketing strategy for clients. Implemented forecasting models for new products using multiple techniques such as linear regression and conjoint analysis. Pulled and tracked weekly and monthly large-scale Rx data for clients using SQL and SAS , and provided interactive dashboards and ad hoc analysis . Extracted and cleaned primary market research data using SPSS syntax, performed data analysis using R, SPSS and Excel (Macros), and provided interactive dashboards using Tableau and Wincross. Show less
-
-
-
Community Informatics
-
United States
-
Libraries
-
Data Analyst Intern
-
Oct 2017 - May 2018
• Retrieved, extracted and transformed large-scale municipal budget data from public resources using R. • Developed Power BI dashboards that provide automated, repeatable reporting on product performance. • Retrieved, extracted and transformed large-scale municipal budget data from public resources using R. • Developed Power BI dashboards that provide automated, repeatable reporting on product performance.
-
-
-
Rutgers University
-
United States
-
Higher Education
-
700 & Above Employee
-
Graduate Teaching Assistant
-
Sep 2016 - Dec 2016
• Assisted professor with Regression analysis: organized and led study group, scheduled and held office hours, mentored students, graded exams • Assisted professor with Regression analysis: organized and led study group, scheduled and held office hours, mentored students, graded exams
-
-
-
China Mobile
-
Telecommunications
-
700 & Above Employee
-
Research Analyst
-
Apr 2013 - Apr 2015
• Conducted extensive research on internet-based industries and developed tailored solutions for subsidiaries providing support for decision making and improved subsidiaries’ operation performance.• Organized user focus groups to analyze high-value customers and proposed successful umbrella program with large service companies to extend their VIP services.• Conceptualized and constructed customer segmentation and profiled models that helped increase personalized targeting; quotation conversion rate increased by 20% after analysis was implemented.• Designed and developed a second-generation system to track, manage, and rationalize the diversity of China Mobile’s locally generated service plans and bundles, which greatly improved its user experience. Show less
-
-
Product Manager
-
Apr 2012 - Apr 2013
• Designed animations for the M701 unlock interface and function features of the M701— China Mobile’s first self-developed mobile phone.• Formulated a series of user-centric design evaluation standards and drafted reference manuals for China Mobile products (e.g. Fetion, Migu digital media, Migu music).
-
-
-
Nokia
-
Finland
-
Telecommunications
-
700 & Above Employee
-
Software engineer intern
-
Mar 2010 - Oct 2011
• Developed rapid Flash prototypes and Symbian mobile apps for the Idea Tool and Music Tuitui respectively. • Contributed to the wireframe of Pie Input Method application, and developed its prototype and mobile app using Qt C++. ▪ Co-authored a related article “PinyinPie: A Pie Menu Augmented Soft Keyboard For Chinese Pinyin Input Methods” in Proceedings of the 14th Conference on Human-Computer Interaction With Mobile Devices and Services (2012),pp. 271-280 (Best Paper Nomination). • Developed rapid Flash prototypes and Symbian mobile apps for the Idea Tool and Music Tuitui respectively. • Contributed to the wireframe of Pie Input Method application, and developed its prototype and mobile app using Qt C++. ▪ Co-authored a related article “PinyinPie: A Pie Menu Augmented Soft Keyboard For Chinese Pinyin Input Methods” in Proceedings of the 14th Conference on Human-Computer Interaction With Mobile Devices and Services (2012),pp. 271-280 (Best Paper Nomination).
-
-
Education
-
Rutgers University-New Brunswick
Master’s Degree, Financial Statistics and Risk Management -
Beijing Institute of Technology
Master’s Degree, Information & Communication Engineering