Fan Jiang Email & Phone Number

Toronto, Ontario, Canada

• Responsible for the enhancement, optimization and maintenance of two key areas: HR Reporting & Analytics and HR Systems & Operations• Designed and implemented reports or dashboards that offer Senior Management Team and Board-level analytics and reporting on critical HR metrics, including talent pipeline, performance management, year-end compensation, turnover, diversity, and more• Identified HR data requirements throughout end-to-end processes and formulated and implemented solutions to enhance analytics and data quality• Assisted in the development of Employee Center platforms with supporting business case development by conducting requirements gathering, performing gap analysis, and conducting user acceptance testing (UAT) for new system solutions• Fostered collaborative partnerships with operational teams to comprehend their strategic objectives, key performance indicators, and reporting requirements

Shanghai, China

• Responsible for communicating with clients and acted as an expert in transforming clients` business needs into high-quality solutions, including but not limited to clarifying business objectives, project scope, and anchor points• Responsible for designing reports or dashboards, including designing logic about data extraction, data relationships, and developing the indicators and metrics, mainly focusing on tracking critical KPI and supporting the driving-down analysis• Designed and established the tag structure to support long-term business tracking and strategy analysis, including but not limited to empowering the personalized campaign and automatic marketing• Utilized Python to perform cluster analysis for profiling customer segmentation model, and assisted merchants in designing personalized multiple-tier marketing campaigns and maximizing campaign performance• Been prime in reviewing, analyzing, and troubleshooting client-supplied data while utilizing the Customer Data Platform (CDP) to perform customer lifecycle analysis, derive insights, and create actionable marketing strategies, including ROI analysis and continuous evaluation of strategy performance.• Completed quality assurance and testing activities to ensure development met functional specifications and client needs prior to deployment, and provided thorough post-implementation second-level support to diagnose and help resolve any issues with the solutions in production

Hangzhou, Zhejiang, China

• Participated in the project of improving delivery efficiency by analyzing the historical logistics data and combining it with the actual warehousing scenarios, conducted the gap analysis and made trackable milestones; followed up on the operation process, and monitored operation data to ensure the progress of the project• Assisted in developing and designing reports for consumer electronics, including but not only to warehouse operation, inventory planning, and logistics monitoring, explored the significance of indicators, interpreted long-term trends by following up on short-term anomalies, and warned potential problems, to maintain operational stability• Analyzed and interpreted data with excel and SQL, and cooperated with the Tmall Consumer Electronics department to improve the accuracy of supply chain data, provided inventory strategies for merchants to optimize the logistics efficiency• Identified and standardized the operation process regarding the inventory allocation• Ensured the promotion operation, cooperated with vendors and warehouses to track and control the warehouse storage capacity; by predicting the stock peak by analyzing business data, pointed out the capacity gap and brought out the scheme; appeased vendors and eliminated negative effects

Brampton, Ontario, Canada

• Participated in business-optimization projects for building business processes and workflow analysis using data capture and business intelligence technologies• Employed SAS to analyze multi-source data for operations automation projects, driving automated and dynamic improvements.• Developed MicroStrategy reports and automated auditing process in SAS to assess financial performance and support business decisions• Collaborated closely with project managers, IT, and QA to establish testing standards for integrating the new acquisition’s systems, successfully converting over 3,300 contracts into SAP for around 700 vendors from the legacy system.• Contributed in the UAT process with over 1500 scenarios and developed automation tools for supporting the testing process • Analyzed existing business validation and allocation rules to indicate potential inaccurate billing and updated business process after providing consolidation reports to the director

Brampton, Ontario, Canada

• Utilized Excel and VBA to validate input data and automated SAP upload flow to ensure the asset allocation is effective and efficient • Developed consolidation process on evaluating accrual and cash ledger, identified potential improvements, investigated the out-balanced amount, and provided analytical commentary• Analyzed extensive data from various databases, including Teradata, MS SQL Server, and MS Assess in use to validate the data integrity gap and comply with appropriate internal audit requirements• Collaborated in the cross-functional team environment (i.e., category, master data, auditing etc.) to review business cases and develop analytical plans to ensure analytical requirements are captured, and analytical requirements were well-defined, and objectives were clear and actionable• Documented business processes and project logic for internal backup purposes and created training materials for new systems and business processes, supporting both key internal and external stakeholders

Master Of Management In Artificial Intelligent

Honours Mathematics, Statistics Major & Computer Science Minor