Tian Lin Email & Phone Number

Hong Kong

香港特別行政區 香港

香港特別行政區

中國 廣東省 深圳

• Conducted risk analysis on the company's end-to-end procurement data using SQL Server and Python
• Presented analysis progress using Power BI and PowerPoint in a weekly manner
• Gained insights into procurement operations through interviews with relevant parties (suppliers, procurement staff)
• Assisted team members in developing plans for annual procurement risk assessment

Hong Kong, Hong Kong SAR

• Bank Project
• Conducted tests on the bank’s multiple systems to ensure data integrity and comprehensiveness
• Utilized SQL Server to clean, and standardize 0.7 billion rows of journal-entry data for further analysis
• Performed various tests on financial data using SQL Server and extract identified outliers using statistical and accounting knowledge
• Documented 3 data analysis reports in English and collaborated closely with the audit teamRetail Company Project
• Built statistical models to uncover financial risks from large financial datasets, e.g., conducting outlier analysis using the Generalized Additive Model and K-Means Model on the company’s financial data

Shanghai, China

• Promoted the warehouse's digital transformation, offered merchants and service providers training on the digital billing system and resolved issues in the interfacing process. Achieved a shift in expense settlement.
• Carried out consumer data analysis to collect supply chain needs for Douyin E-commerce, and proposed viable solutions to refine supply chain process
• Conducted competitor analysis of different e-commerce platforms, researched the apparel industry to build business insights, and completed C-side marketing plans for apparel quality control projects

• Undertook desk research for projects, e.g., conducting industry analysis for the machine vision industry to advise an Italian startup on its entry to China market
• Took minutes of weekly meetings, recorded projects progress and work division among employees, and assisted project management

中国 广东省 深圳

• Monitored and gathered shipment schedule error data, and conducted data analysis of shipments' schedule anomalies to find root causes
• Managed international import and export business, tracked shipments status, and communicated with related stakeholders
• Wrote one SOP document for handling shipment information with erroneous schedules to facilitate out-sourcing of business, and provided issue matrices to operations teams

Msc, Information Systems Management, 3.72/4.3

Bba, Business Analytics, 3.7/4.0

Summer School, Digital Marketing