Data Analyst Power Bi
Resume:
Zhaolei (Leo) Xu
Danville, CA *****
********@*****.***
[LinkedIn]https://www.linkedin.com/in/zhaolei-xu-630328103
HIGHLIGHTS
I am a detail-oriented professional with a strong background in data analysis, experienced in developing and maintaining dashboards using Power BI to support real-time decision-making. Skilled in ensuring data integrity, troubleshooting issues, and collaborating with production teams to analyze production data. Proficient in Excel, the Microsoft Office Suite, and experienced with various data sources. Strong analytical skills and a solid understanding of business and financial data, contributing valuable insights to optimize operations and support the company's growth.
PROFESSIONAL EXPERIENCE
Business Data Analyst, Peet’s Coffee and Tea: Tracy, California Jul 2021 - Present
Led DDS (Daily Direction Strategy) meetings and reviewed previous work outcomes with 20 stakeholders by demonstrating power BI dashboard.
Collaborated with sourcing manager to measure more than 50 vendors’ performance such as supply lead time, OTIF, fill rate, maintenance request etc.
Set up daily refresh for the Power BI report and trouble shooting the error in power query.
Shared multi-channel data source with relevant stakeholders to align on the same page.
Told the logic story to the stakeholders by analyzing huge data set.
Helped Amazon team to save $250k penalty expense by analyzing Amazon carriers pick up time.
Helped Transportation team to save $300k cost by inspiring the trends of gasoline prices.
Accomplished more than 30 projects before the deadline in 2023-2024.
Created 5 BI reports for each channel and pinned the key metrics in dashboard.
Maintained more than 40 data sources and data sets.
Aggregate UPH and CPH to help distribution operation manager to make decision.
Created 4 metrics reports for process engineer.
Conducted GAP analysis with stakeholders to enhance productivity by 15%.
Enhanced Data Processing Efficiency: Streamlined data processing workflows, resulting in a 25% reduction in processing time and improved data accuracy.
Developed Predictive Models: Created predictive models using machine learning techniques that increased forecasting accuracy by 20%, aiding in strategic decision-making.
Optimized ETL Processes: Optimized ETL processes, reducing data latency by 30% and improving data availability for business intelligence.
Senior Inventory Data Analyst, Biagi Bros Warehouse and Transportation; Napa, California Oct 2017 - Jan 2021
Reviewed daily B2B reports and resolved inventory variances.
Managed over 100k SKUs for dedicated customers, overseeing daily inventory operations, reconciliation, costing, and valuation.
Conducted regular inventory audits to ensure accuracy and compliance with accounting standards.
Collaborated with cross-functional teams to develop and implement inventory control procedures.
Worked closely with IT to resolve systems integration errors and ensure accurate inventory records.
Customer Insights Analysis: Analyzed customer data to derive actionable insights, improving customer satisfaction and retention by 10%.
Training and Mentorship: Provided training and mentorship to junior analysts, enhancing team capabilities and fostering a culture of continuous learning.
Senior Inventory Analyst, INDITEX (Zara); Shanghai, China Aug 2011 – Oct 2014
Supported and managed over 100 stores and 3 local warehouses from an inventory control perspective.
Led annual cycle count projects for all retail stores in the South China Zone.
Balanced inventory levels across stores and ensured coherence between theoretical and physical stock.
Reported inventory financial statements to the Finance Manager and detected issues causing stock losses.
Logistics Analyst, PANALPINA World Transport; Shanghai, China Oct 2008 – Aug 2011
Coordinated with export and import teams for customs declarations and managed shipping orders.
Ensured timely processing of all inbound and outbound orders and prepared required reports for related parties.
Monitored agent performance and ensured adherence to instructions, assisting in cost reduction and efficiency improvements.
EDUCATION
Certificate Program in Microsoft Power BI (2023 - 2024)
Certificate Program in SQL (2023)
Certificate Program in Business Analysis, UC Berkeley Extension (2020 - 2021)
MBA in Small Business & Entrepreneurship, California Lutheran University, Thousand Oaks, CA (2014 - 2016)
Bachelor’s Degree in Accounting, University of Technology, Sydney, NSW, Australia (2005 - 2008)
SKILLS
Proficient in Excel
ETL Processes
Data Analysis
AI Data Analysis
Cost Analysis
Financial Reporting
Budget Management
Data Visualization (Power BI)
Reconciliation of Discrepancies
ERP Software (D365,JDE)
Auditing
Supply Chain Management
Data Governance
Cross-Functional Collaboration
Contact this candidate