Lin Sun Email & Phone Number

Mississauga, Ontario, Canada

• Achievement:
• Developing RFP data model that reflecting 360 degree customer details regarding customer profile, finance, service, product, pricing, competition data etc.
• Priming data insights for 20+ strategic customer RFPs per year
• Priming 10+ important periodic reports and self-service tools that support executive and stakeholders across business units/departments, including Top 200 customer service penetration report, CRTC regulatory product.
• Priming 10+ important periodic reports and self-service tools that support executive and stakeholders across business units/departments, including Top 200 customer service penetration report, CRTC regulatory product.
• Supporting executive/director level decision making process by providing insights regarding customer profiling, marketing, segmentation, financial, product, competition, facility footprint analysis.

Milton, Ontario, Canada

• Analyzing and reporting trend, pattern and issues of business operational process, sales/purchase records and financial data by generating reports/dashboard/visualization using SQL, Power BI, and Excel
• Maintaining accuracy and availability of price/cost/revenue/financial/product/category data in related reports, ERP system and SQL server database.
• Identifying, tracking the purchase/sales/invoice data and fixing the disorder/inaccuracy/missing data in relevant reports by monitoring… Show more
• Identifying, tracking the purchase/sales/invoice data and fixing the disorder/inaccuracy/missing data in relevant reports by monitoring key indicators, tracking business and technical logics, and coordinating.
• Automation of data cleaning and reporting processing by generating storage procedures, setting up SQL agent jobs and creating interactive reports.
• Generating pricing books for general/special customers based on customer segmentation, targeting margin and market benchmark. Alarming pricing issues and initiating price adjustment by monitoring price/invoice/gross.

Beijing City, China

• Identified data requirements and data dictionary. Extracted, validated and manipulated data for accuracy and consistency, imputed missing values, standardized data, transformed variables, assigned new variables as.
• Explored, analyzed data and generated the periodic reports (e.g. market performance reports) and ad-hoc reports (e.g. Identify key factors that impact listing companies’ indicatory behaviors) for internal and external.
• Explored, analyzed data and generated the periodic reports (e.g. market performance reports) and ad-hoc reports (e.g. Identify key factors that impact listing companies’ indicatory behaviors) for internal and external.
• Collected, developed and validated business hypothesis. Identified key factors that impact business targets
• Maintained, optimized and automated periodic reporting process
• Developed meaningful segmentation and provide supportive insights to modelling team to predict propensity in upcoming actions and strategy optimization

Master Of International Business

Master Of Economics

Bachelor Of Economics, Finance, General