Weijie Shi

Passionate business data analyst with sound experience and knowledge in Managerial Accounting, Supply Chain Management, Financial Consulting, Financial Accounting, and Data Mining.

Retail Business Analyst                                                        February 2023 – March 2023

Greenware                                                                                                 Toronto, Canada

• Implemented data governance policies and procedure to enhance data quality control, optimized efficiency and effectiveness of the data management systems, ensure compliance of the regulatory requirements.
• Perform comprehensive sales pattern analysis by utilizing advanced statistical techniques, such as fitting and simulating sales goods price distributions using R, identified leading profitable goods and categories by performing category analysis, pinpointed correlations of sales and leading time by performing fit distribution for leading time.
• Developed advanced sales forecasting models employing ARIMA and Holt-wintermodel and validated the result.
  • Produced weekly sales performance report to indicate trends and patterns and report to higher management team to aid decision making on sales strategies.

Business Data Analyst                                                            October 2020 – August 2022

Decathlon                                                                                                   Shanghai, China

• As the Asia project lead of a global system migration project, communicated constantly with France head office team, effectively oversaw the transition of the data pipeline from CLIFOU (AS400) to PI4T, resulting in significant increase of system stability and accuracy, reduced 20% of the closing work.
• Facilitated the elicitation of business requirements (BRD) in collaboration with key stakeholders and translated the identified objectives into comprehensive business plans for data analytics solutions. Effectively presented reporting outcomes to senior management, thereby aiding informed business decisions.
• Developed more than 10 automated self-serve data dashboards leveraging Tableau, Google Data Studio, Qlik, effectively showcase imperative Key Performance Indicators (KPI) in manufacture and retail domains, encompass areas such as travel expense, stock turnover, inventory deficit, process preferences and customer segmentation.
• Provided maintenance solution on data dashboard process on a regular basis, ensuring optimal functionality and performance. Designed and implemented comprehensive data reconciliation process and Quality Assurance (QA) mechanism aimed at guaranteeing the accuracy and efficiency of data visualization reports.
• Liaised with Finance and Accounting Teams to deliver technical solutions in the implementation, deployment, and migration of initiatives aimed at streamlining internal process. Delivered the requisite data preparation (ETL) process including data cleaning, extracting, loading, transformation using R-programming through AWS Redshift DataLake, completed data cleaning exercises for over 5 million data points on monthly basis.
• Built multi-faceted dashboard capable of performing anomaly display and anomaly detections exercise of business and finance shipment report, effectively identified and addressed financial gaps, driving operational efficiency improvement by reducing workflow timeline from 2 days to less than an hour. 
• Extensive project management experience in project planning, organizing, and execution. Coordinated a variety of capital projects, organizational initiatives, and technical directives focused on data integration and analytics, from conceptions to completion. Maintained adherence with strict deadlines and requirements using Jira Ticket Management Platform, ensured timely milestone deliveries within stipulated budget. 
• Worked with crossed-functional teams including IT, Data Science, Sales, Finance and Accounting to achieve business synergy and collaborated on enterprise projects on potential business opportunities.
• Conducted 30+ ad-hoc requests in JDE Oracle, included but not limited to supplier price difference adjustment, chargeback report issuing and supported creating new B2B business flow.

University of Alberta                                                                                                                        Sept 2016 – June 2020

Bachelor of Commerce (Honors), Major in Operations Management                                                   Edmonton, Canada