Xi Y. Email & Phone Number

• Developed Power BI dashboards to analyze Customer Cross shopping, DC inventory Management, Sales Performance, and Expense Control, resulting in a 20% increase in campaign effectiveness and a 15% reduction in expenses.• Monthly Financial income statement report design and development using Excel Table functions & VBA• Created Excel & Services Revenue Report using Dynamic Financial modeling in excel• BRD workflow design to standardize Business Analyzing process

• Customer Transaction Analyses - Conducted retail banking CRM analysis by utilizing RFM model, transaction and category analysis to provide key insights for redefining campaign implementation strategy • Delivered risk analysis (AML) to identify suspicious & problematic transactions base on business rules through data modeling, integration and reporting with combining and linking data from various sources• Developed solid understanding in bank lending products, credit risk measurements & credit adjudication process• Performed reconciliation between operational data & reports to ensure the accuracy of branch reporting• Led a data-driven initiative to automate manual reporting tasks, reducing report generation time by 40% and enhancing overall operational efficiency.

• Conducted e-commerce data analysis to identify patterns, sales trends, and growth opportunities; Utilized Google Analytics and web analytics tools to track website performance, user engagement, and conversion rates.• Business KPIs identification & design to measure logistics performance and track operational trending.• Analyzed logistics data, identified trends, and proposed improvements; Collaborated with cross-functional teams to reduce lead times by 15% and transportation costs by 10%.• Analyzed and compiled data to identify areas of financial risk and opportunity in forward-looking Budget & Forecast planning based on historical data• Conducted root cause analysis, improving order fulfillment rate by 12% and implementing corrective actions.• Revamped and optimized B2B sales process, introducing innovative strategies and approaches. • Devised and executed strategic marketing campaigns to expand brand presence in the USA market and on prominent E-commerce platforms (Wayfair, Overstock, Amazon, Walmart). • Demonstrated expertise in overseas transportation processes and policies, ensuring timely and sufficient inventory procurement.

Bachelor'S Degree, Communication And Media Studies

Education record