Xinfa Pan

SF Express is the largest integrated logistics service provider in China and Asia. Analytics in Sales, Pricing, Revenue & Supply Chain. I lead the end-to-end pricing lifecycle and revenue operations, serving as the analytical bridge between commercial strategy and operational execution. I focus on building scalable financial models and automated data pipelines to drive profitability in complex supply chain environments. Key Achievements & Responsibilities: Strategic Pricing & Large-scale RFQs: Direct the pricing strategy for high-value Enterprise RFQs and new service launches, developing integrated cost-and-price models that balance market competitiveness with target profit margins. Collaborate across Sales, Operations, and IT to translate complex warehouse movements and logistics workflows into accurate, billable service models. Technical Automation & Business Intelligence: Engineered automated ETL pipelines using Power Query to streamline data extraction from internal CRM and shipment databases, reducing manual reporting time by 60%。 Designed self-refreshing dashboards and advanced Excel visualizations to monitor client KPIs and revenue trends, providing leadership with real-time visibility for data-driven pivots. Revenue Assurance & Root Cause Analysis: Take full ownership of billing integrity by performing deep-dive data audits on discrepancies; stress-test and validate systemic billing logic to identify root-cause errors and safeguard company revenue. Proactively identify and mitigate revenue leakage, ensuring 100% alignment between contract terms and system-generated invoices. Process Standardization & Team Enablement: Authored comprehensive SOP documents and standardized the Sales-to-Revenue Management communication framework to improve operational efficiency. Lead training sessions for Sales teams on pricing logic and product knowledge, accelerating the onboarding process and ensuring consistent client engagement standards.

-Cleansed and processed 10 years of healthcare claims data (9M+ rows) using Python (Pandas, NumPy), conducted exploratory data analysis, imputed missing values, and treated outliers to prepare data for modeling. -Conducted correlation, regression, and statistical testing (e.g., T-tests) to quantify the cost impact of comorbidities, identifying the most expensive disease combinations and validating differences in healthcare costs across patient groups. -Visualized cost trends and comorbidity patterns using Matplotlib, transforming complex analytical findings into intuitive visuals and dashboards tailored for executive stakeholders at Blue Shield of California. -Delivered a final report with three data-driven, actionable recommendations to support long-term cost-saving strategies and informed business decisions.

-Performed product research based on company's marketing strategy like competitor analysis and SWOT analysis, identified and implemented marketing opportunities to boost sales by 20%. -Designed visualization dashboards and reports for use in monitoring performance metrics while maintaining existing dashboards for accuracy and efficiency and incorporating changes using Tableau. -Analyzed data from product differences and advocated 4 actional marketing strategies with lower budget to efficiently allocate spending for the expectation of 20% reduced cost.

Predictive Analytics Machine Learning for Analytics Natural Language Processing Deep Learning Big Data Management System Business Data Management Management Science for Analytics Customer and Social Analytics Data and Programming for Analytics Statistics for Data Science