Highlights:As a Velocity Specialist at NextGen Healthcare, I led initiatives to enhance client workflows and operational efficiency through data-driven solutions, including implementing predictive modeling for patient no-shows and automating targeted reminders using Python and SQL. Additionally, I managed upgrade projects for over 100 practices and presented tailored insights to clients, driving improved patient engagement and system performance. At Fidelity Investments, I spearheaded a team of five interns to develop a semantic web dashboard for visualizing financial data. Overcoming technical challenges, I mastered new programming languages under tight deadlines to deliver a high-performing solution for cryptocurrency trend analysis. During my internship at CTR Market Research, I leveraged SQL and Excel to analyze marketing strategies for Chinese media companies and identified product attributes for electronic car brands, driving data-driven improvements that enhanced customer outcomes. I also contributed to strategic analysis for the 2022 Beijing Olympic Winter Games, achieving a 20% increase in page views. My experiences at PRLab at Boston University and Gao Sheng Investment further solidified my data analysis and communication skills. At PRLab, I utilized Tableau for dynamic visualizations, doubling YouTube subscribers for Architectural Health. At Gao Sheng, I applied statistical methods to improve social media content strategies. Finally, as a Volunteer Leader for the China Children’s Fund Cultural Research Camp, I demonstrated leadership by coordinating group efforts, designing exhibition plans, and delivering impactful presentations, showcasing my ability to manage projects and inspire collaboration across teams.

Skills:SQL(PostgreSQL, MySQL), Python, Excel (Pivot Table, Oracle, NetSuite, IBM Db2, Azure, Databricks, Amaz, Tableau, R, Power BI, Microsoft Office Suite, JAVA, Database Management, Data Visualization, Data Ware, Machine Learning, Python (Scikitlearn, Pandas), Mathematical Modeling, A/B testing, Time series, API, Web Scraping, API, HTML & CSS

Goal:My career goal is to become a leading expert in leveraging data analysis and statistical methodologies to forecast optimal solutions for businesses. By integrating data-driven insights with strategic thinking, I aim to empower organizations to make informed decisions, improve operational efficiency, and drive sustainable growth. My objective is to continuously develop my analytical skills and technical expertise while collaborating with cross-functional teams to solve complex challenges and create measurable impact in dynamic business environments.

Certification:MySQL Essential Training, SQL Programming, Programming Foundations: Databases via LinkedIn

Velocity Specialist, Consultant 06/2024 - current
NextGen Healthcare, Boston, Massachusetts United States
As a Velocity Specialist, I lead initiatives to improve client workflows and operational efficiency using data-driven solutions. Notably, I implemented predictive modeling in Python and SQL to address patient no-shows, creating automated reminders that enhanced engagement. I also managed system upgrades for over 100 practices, fostering collaboration among stakeholders and ensuring smooth transitions. This role highlights my ability to leverage technical expertise and project management skills to deliver impactful solutions.
• Led a project leveraging SQL and Python to develop and deploy a Random Forest Classifier for predicting patient noshows with high accuracy, automating targeted reminder notifications, and enhancing patient engagement • Implement automated ETL pipelines to streamline data extraction and reporting, boosting operational efficiency • Utilize natural language processing to perform sentiment analysis on patient feedback, improving patient experience tracking • Routinely analyze client workflows and business processes to provide tailored, data-driven solutions, present insights, and proposing various data analysis or automation methods to enhance company operations • Collaborate with cross functional teams to ensure the success of an project consisting of more than 250 providers--
Data Analyst Intern (Capstone) 05/2023 - 08/2023
Fidelity Investments, Boston, Massachusetts United States
At Fidelity Investments, I led a team of five interns to develop a semantic web dashboard for financial data visualization. We overcame technical challenges by mastering new programming languages within tight deadlines. The final solution offered robust tools for analyzing cryptocurrency trends and enhanced decision-making for stakeholders. This experience underscored my leadership, adaptability, and technical problem-solving abilities.
• Spearheaded a team of three on the Application of Data Science on Decentralized Finance, successfully conducted exploratory data analysis using SQL, and developed a stock-market style dashboard in Dash, Python, HTML & CSS • Managed over 1k cryptocurrency time series data points, building and testing Prophet & Linear Regression models using Python, achieving over 90% accuracy on short-term price trend forecasts • Implemented SPARQL for Semantic Web data file to visualize ontology hierarchies and extract cryptocurrency data • Designed an interactive Semantic Web and Power BI dashboard that allows users to view dynamic price data and connections between the prices of different cryptocurrencies • Synthesized data from the Semantic Web into actionable insights, significantly improving the decision-making tools for DeFi stakeholders--
Data Analyst Intern 10/2021 - 01/2022
CTR Market Research Co., Ltd, Beijing, Beijing China
I utilized SQL and Excel to analyze datasets for Chinese electronic car brands and media companies, identifying key product attributes and improving pricing benchmarks. I also evaluated marketing strategies and analyzed business models for the 2022 Beijing Olympic Winter Games, resulting in a 20% increase in page views. This role sharpened my data analysis and strategic insight capabilities.
• Utilized SQL queries on 20+ Chinese electronic car brands and dataset over 8 million rows, identifying product attributes and discerning patterns, leading to better price benchmarks for potential purchasers • Utilized Excel pivot tables and VLOOKUP to analyze 100k+ operation data rows for 10+ Chinese telecoms, driving quality improvements, helped stakeholders achieve quarterly goals of deposit growth and product sales • Analyzed business models of the 2022 Beijing Olympic Winter Games, delivered weekly report to help stakeholders monitoring performance of branches, speed up decision making, leading to a 20% increase in page views--
Search Engine Optimization Analyst Executive 01/2021 - 05/2021
PRLab at Boston University, Boston, Massachusetts United States
I used Tableau to create dynamic visualizations and operational strategies for green building claims. My work on content creation and analytics doubled a client’s YouTube subscribers and increased engagement by 200%. This role demonstrated my ability to combine creativity with data-driven decision-making.
• Utilized Tableau, analyzed and visualized data related to green buildings for stakeholders’ science columns • Authored corporate news and science columns on account, improving traffic by 150% and fan engagement by 200% • Designed and edited videos for Architectural Health's YouTube channel, doubling the subscriber count--
Search Engine Optimization Analyst Intern 05/2020 - 08/2020
Gao Sheng Investment Management Co., Ltd, Beijing, Beijing China
I analyzed competitors’ social media traffic using statistical methods and presented actionable insights to improve content strategies. My efforts increased engagement and provided data-driven recommendations to enhance the company’s online presence. This role emphasized my analytical rigor and ability to translate data into actionable strategies.
• Monitored competitors' WeChat for two months, utilizing statistical methods like T-tests to analyze traffic patterns • Interpreted statistical results to identify key drivers of positive client and audience feedback, advising the company to focus on similar content, influencing a 10% increase in content engagement--
Search Engine Optimization Analyst Intern 06/2018 - 08/2018
The Hoffman Agency, Beijing, Beijing China
I authored and translated content for social media accounts, monitored industry updates, and provided recommendations for client strategies. This role honed my skills in communication, content creation, and social media analytics.
• Tracked industry news and competitor updates on social media, compiling daily reports to inform client strategies • Authored articles and blogs for client social media accounts, promoting cross-border communication--

Boston University 09/2017 - 05/2021
Boston, Massachusetts, United States
Degree: Bachelor's Degree
Major:Communications
Minor:Statistics
Majored in Public Relations, minored in Statistics: Mathematical Statistics Track

Login to view resume: YanxinPang_Resume -