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.

Bachelor'S Degree, Communication And Media Studies

Education record