Experience

Precima, Inc.; Alliance Loyalty Services

• Senior Business Analyst

  • Jul 2014 - Present

  Toronto, Canada Area



LoyaltyOne

• Canada
• Advertising Services
• 500 - 600 Employee

• Senior Analyst - Analytics & Insights

  • Nov 2012 - Jun 2014

  Toronto • Responsible for consumer intelligence and analytics for AIR MILES Travel & Retail portfolio. Focused on delivering insights to help make better business decisions in marketing - Direct and Mass Marketing, Segmentation, CRM, Consumer Loyalty, clients include Budget car rental, InterContinental Hotels Group, The Bay, Rogers Media etc. • Application & execution of consumer data and analytics to support the development of customer-centric business strategies and Loyalty Marketing • Conduct… Show more • Responsible for consumer intelligence and analytics for AIR MILES Travel & Retail portfolio. Focused on delivering insights to help make better business decisions in marketing - Direct and Mass Marketing, Segmentation, CRM, Consumer Loyalty, clients include Budget car rental, InterContinental Hotels Group, The Bay, Rogers Media etc. • Application & execution of consumer data and analytics to support the development of customer-centric business strategies and Loyalty Marketing • Conduct timely quantitative and qualitative evaluation of AIR MILES Reward Program • Optimize reporting process by improving coding efficiency with more SAS/Macro and less hard coding and modularize programs for easy maintenance by adding comments and separating data extraction and analytical parts • Conduct post-campaign analysis by comparing response rates and other metrics between test and control group at different data levels in a short run, and setting up track-back and follow-up periods to monitor fluctuating response rates in a long run Show less



Analytics Resourcing Centre

• Canada
• Business Consulting and Services

• Marketing Analyst

  • Sep 2011 - Nov 2012

  Toronto, Canada Area • Conducted pre and post campaign analysis to achieve excellence on direct marketing campaign by maximizing ROI, Sales and Profit • Provided Ad Hoc analytical support to help stakeholder better understand business challenge and to meet business requirement • Improved the routine report efficiency by using SAS Macro and QA automation tools to maintain report accuracy and quality • Optimized offer type through the product association analysis about different category product within… Show more • Conducted pre and post campaign analysis to achieve excellence on direct marketing campaign by maximizing ROI, Sales and Profit • Provided Ad Hoc analytical support to help stakeholder better understand business challenge and to meet business requirement • Improved the routine report efficiency by using SAS Macro and QA automation tools to maintain report accuracy and quality • Optimized offer type through the product association analysis about different category product within same department to create a series bundle offers to increase cross sale and raise average QTY per basket from 2.5 to 4.5 • Conducted an analysis of CRM retention and provided recommendation on best target and offers to decrease customer churn rate for high value segments • Standardized SAS code about data extraction, manipulation by using SQL and macro to reduce the programming time largely. • Figured out an ETL error which missed one week transaction data through the data quality validation by using SAS proc freq and proc univariate. • Handled big data such as transaction data by inputting needed variable only and follow server usage rule which striking a balance between the processing time and resource limitations. Show less



Gay Lea Foods

• Canada
• Food and Beverage Manufacturing
• 300 - 400 Employee

• Continuous improvement Engineer

  • Dec 2009 - Mar 2011

  Toronto, Canada Area • Participated in process improvement activities including development and modification of the manufacturing operations and work flow on existing processes • Created O.E.E (Overall Equipment Effectiveness) and down time record templates and calculated daily O.E.E result by using Excel Macro to monitor daily production performance which forward Continues improvement project 5 months in advance in Ivanhoe cheese facility • Conducted process improvement project through various tools such as… Show more • Participated in process improvement activities including development and modification of the manufacturing operations and work flow on existing processes • Created O.E.E (Overall Equipment Effectiveness) and down time record templates and calculated daily O.E.E result by using Excel Macro to monitor daily production performance which forward Continues improvement project 5 months in advance in Ivanhoe cheese facility • Conducted process improvement project through various tools such as Process Mapping , Pareto Analysis, Value Stream Mapping, 5's etc. which reduced down time cause by maintenance by 10% • Conducted a statistics experiment design to analyzed different factor such as heating temperature, heating time and film type which influence the package quality to get the best combination • Statistically analyzed the relationship between the labor costs and 1% OEE and reported line cost Vs. Efficiency result to plant manager daily. • Supported stakeholder deliver process improvements regards to Safety, Quality, Cost saving ,yield improvement and waste reduction activities • Prepared inventory check list for MP2 system Show less



Decathlon Internacional

• Department Manager (Intern)

  • Dec 2008 - Nov 2009

  • Set department goals for sales and profits, supporting staff in implementing sales strategies to reach the goal • Finished department business reports including sales, Margin, category share other KPI on weekly, monthly basis • Analyzed inventory levels (Distribution Centre and store level) for 20/80 product to identify opportunities to reducing shortage of QTY of these product on-shelf-availability • Provided on-going analytical support across a wide variety of projects and… Show more • Set department goals for sales and profits, supporting staff in implementing sales strategies to reach the goal • Finished department business reports including sales, Margin, category share other KPI on weekly, monthly basis • Analyzed inventory levels (Distribution Centre and store level) for 20/80 product to identify opportunities to reducing shortage of QTY of these product on-shelf-availability • Provided on-going analytical support across a wide variety of projects and tasks, including trend reports, forecasting • Designed and co-organized a province-wide online customer survey relate to horse riding product and presented research result to help district and category manager plan product selection from French headquarter • Provided Market Basket Analysis for company’s cross-sell and up-sell campaign and analyzed which items are most frequently purchased together in my department • Train new staff, ensuring compliance and understanding of service standards and company policy Show less



National Institute for Food and Drug Control

• Quality Control Analyst

  • Jul 2005 - Jul 2007

  China - Completed quality testing and report of over hundred medicines according to the national and international standard. - Completed the research of new drug quality standard. - Performed quality inspection and quality standard check of imported medicines. - Responsible for drug supervision arranged by state food and drug administration, performing inspections of medicines available in pharmacies on shelves, ensuring compliance. - Perform demarcation of national standard for the… Show more - Completed quality testing and report of over hundred medicines according to the national and international standard. - Completed the research of new drug quality standard. - Performed quality inspection and quality standard check of imported medicines. - Responsible for drug supervision arranged by state food and drug administration, performing inspections of medicines available in pharmacies on shelves, ensuring compliance. - Perform demarcation of national standard for the substance of analysis. Show less