Data Analyst with Python, SQL & Visualization Expertise

Linlin Fan

Boston, MA 339-***-**** ***.*****@************.*** LinkedIn GitHub

Data analyst with expertise in Python, SQL, and data visualization, specializing in transforming complex datasets into actionable insights. Background in product analytics, cross-functional collaboration, and global user behavior analysis. EDUCATION

Northeastern University Boston, MA Expected Dec 2026 Master of Science, Information Systems GPA: 3.964/4.0 Guizhou University Guiyang, China Jul 2012

Bachelor of Arts, English

SKILLS AND CERTIFICATIONS

• Programming Languages: Python, Structured Query Language (SQL), Java, JavaScript, Excel

• Data & Analytics: Pandas, NumPy, Data Cleaning & Validation, Feature Engineering, Time Series Analysis Visualization & Reporting: Tableau, Plotly, Matplotlib, Seaborn, Power BI

• Databases & APIs: PostgreSQL, MongoDB, REST APIs

• Tools & Platforms: GitHub, VS Code, Anaconda, Microsoft Office, Google Workspace, Salesforce PROFESSIONAL EXPERIENCE

Teaching Assistant Northeastern University Sep 2025 - Dec 2025

• Instructed and guided 60+ students across two campuses on web development and data-driven application projects, clarifying complex technical concepts

• Delivered structured, actionable feedback on code quality, data handling, and application logic via office hours, earning consistently positive student satisfaction

Product Analyst JoyParty Information Technology Co., Ltd. Shanghai, China Feb 2022 – Jun 2023

• Analyzed user behavior, usability feedback, and competitive trends across U.S. and Asian markets, translating findings into actionable localization and product recommendations

• Improved user retention by 5% by identifying UX friction points and recommending interface and content localization improvements

• Engineered robust Excel reports focusing on user retention analytics and market response, leading to a revised product roadmap that enhanced user satisfaction scores by 30% within the next quarter Data Analyst NTS Ltd. Shanghai, China Jul 2014 – Nov 2022

• Designed and maintained automated dashboards to harmonize datasets from international clients and suppliers, improving order-tracking efficiency by 6%

• Developed data visualization dashboards analyzing supplier-client distribution for German stakeholders, accelerating decision-making speed by 7%

Senior Interpreter (Part-time) World Association of Nuclear Operators (WANO) 2015 – 2023

• Provided professional simultaneous and consecutive interpretation for WANO international review teams conducting periodic corporate and peer reviews at major nuclear power corporations and plants across China PROJECTS

Boston Blue Bike Data Analysis GitHub Python, APIs, GeoPandas, Data Visualization April 2026

• Analyzed 3 months of Bluebikes trip data across 583 stations, using time series analysis and temporal feature engineering to identify peak-hour flow patterns and commuting trends

• Identified gaps and inconsistencies in raw data pipelines (2,674 missing station IDs, removed 28K anomalous records) and engineered cleaning workflows to produce a reliable, analysis-ready dataset

• Engineered robust data pipelines joining 1.6M trip, station, and geospatial records, using GeoPandas and statistical testing

(Wilcoxon, p = 2.34e-06) to pinpoint 324 stations (55.6%) with critical supply-demand imbalances and drive data-informed rebalancing recommendations

Global Program Analytics Dashboard GitHub Python, SQL, Tableau, scikit-learn June 2026

• Built Python and SQL workflows to clean, validate, and analyze student participation, course evaluation, survey feedback, and program performance data

• Designed Tableau dashboard prototypes to visualize enrollment trends, satisfaction metrics, academic outcomes, and program effectiveness for stakeholder reporting

• Planned and executed regression, clustering, and forecasting analyses to pinpoint the top 5 high-performing academic programs, enhancing strategic planning decisions

Contact this candidate