Yafan Zeng Email & Phone Number

Remote

• Data Analytics
• Created an alert metric for Vifor Pharma to identify healthcare personnel with patients at risk of switching drugs and conducted exploratory analysis on drug switches using T-SQL
• Constructed a data pipeline web scrapping Twitter and LinkedIn posts to perform social media listening; Built a Python model dissecting sentiment metrics from the data, analyzed patients' profile based on the metrics.
• Collaborated with product team to determine KPIs on marketing operations channel and created standardized dashboards
• Utilized fuzzy match methods to link location information across different datasets and developed a dynamic sales allocation dashboard tool for client to update sales based on affiliation changesProduct Development
• Researched on current market Territory Alignment products and conducted a gap analysis to determine what features needed on company’s platform ciPARTHENON to outperform competitive products

Remote

• Built a data pipeline via Python that collect target public equities’ financial information from yahoo finance; Reported equity performance with comprehensive research on company strategies, market dynamics and growth.
• Automated the daily maintenance process to detect error information in the company’s core database using Python, reducing human-typed errors by 80% and increasing database teamwork efficiency

Beijing, China

• Completed credit reviews of the bank’s outstanding loans and evaluated the clients’ ongoing financial strength by analyzing financial data and performing in-depth interviews with client managers
• Guided and collaborated with the confirmation team in Dalian, effectively solved confirmation discrepancies, and completed the confirmation audit process 2 weeks before the required deadline
• Recognized as the top performer and received the highest-level evaluation during annual performance review

Master'S Degree, Business Analytics

Relevant Coursework: Python, SQL and NoSQL Database, Statistical Computing, A/B Testing, Data Visualization, Time Series Analysis and.

Bachelor'S Degree, Accounting

Education record