Mingcan L. Email & Phone Number

California, United States

Atlanta, Georgia, Us

Scottsdale, Arizona, Us

- Created heatmaps using 46k+ physician addresses with Python NumPy and Matplotlib, and developed a territory algorithm to balance pharmaceutical agent workloads and increase productivity- Performed correlation analysis between COVID-19 and drug sales and visualized results and promotion plans to provide data support for marketing activities- Improved CRM system by cleaning data in Python and designing dashboards to realize the real-time update and visualization of the back-end database at the front-end

- Developed a Python-based ETL process, automated data retrieval and transformation, created 20+ dashboards, enabling self-service incrementality reports, and saved ~40 hours/week in manual labor- Optimized user engagement for 350M+ users using Machine Learning methods (decision trees, random forests, regressions), leading to a 15% increase in subscription revenue- Employed data from AWS (Amazon Redshift) to segment 12.8M+ users through user portrait analysis and K- means clustering, yielding targeted product recommendations that enhanced user conversion rate by 5%- Executed A/B testing for customer behavior data on mobile device interface to improve UI design and increased Monthly Active Users (MAU) from 8.1 million to 8.6 million- Led SQL and Excel data analysis training to colleagues, enabling a deeper understanding of business insights through a data-driven perspective

Cambridge, Gb

- Utilized Marketing Mix Modeling (MMM) and Multi-Touch Attribution (MTA) to analyze user behavior and optimize digital marketing spend, contributing to 35% annual sales growth- Increased social media following by 5,000+ in 6 months using SEO techniques and customer feedback analysis, resulting in a 15% increase in engagement and 10% increase in website traffic- Boosted new product sales revenue on Tmall.com by 40% through paid media and data-driven marketing

- Leveraged company's resource library to identify historically high-income programs using SQL, generating $60,000 in net profit monthly by re-promoting these contents through a recommendation system- Designed 30+ dashboards using Tableau to monitor key metrics to support marketing initiatives and ultimately increase promotional products’ revenue by 4.5%- Generated data-driven KPIs for teams’ performance evaluation by analyzing project ratings and profitability

Master’S Degree, Data Science

Bachelor'S Degree, Finance, General

Other, Finance, General

Education record