Chenyu Li Email & Phone Number

Ottawa, Ontario, Canada

Ottawa, Ontario, Canada

• Collaborating with the Corporate Marketing team to support ongoing development, refinement, additions, and evolution of CIHI’s persona framework. Synthesizing a wide range of data to find patterns and determine the.
• Leading the development, documentation, implementation of persona assignment to CRM contacts. Working with the ITS team to build Python scripts to optimize assignment methodologies and supporting the promotion of the.
• Performing client engagement analysis and reporting on results, developing client segmentation metrics across a continuum of sources, using data mining and visualization techniques, including SQL, Python, SAS, Excel.
• Supporting eMarketing campaigns, including creating new HTML templates, generating distribution lists, troubleshooting issues and providing ad hoc data exports/analysis when required.
• Collaborating with the Digital Analytics team to process Google Analytics data in BigQuery to find out how to better re-structure, re-calculate and filter the data to make it more useful after it’s captured. Developing.
• Supporting Marketo expansion and enhancements, such as automation requirements gathering and testing, subscription landing page development, test cases verification, GDPR requirements, reporting and analytics, etc..

Ottawa, Canada Area

• Entered over 3,000 catalog requests per month into the CW system, including "New Customer", "Maintenance", and "Back Orders"
• Processed US and Canada gift cards by product, catalog, and shipping method
• Filed "merge/purge" requests with reference to the customer contact information on the folder

Ottawa, Canada Area

• Supported executive director and pricing analyst in various price activities, mainly Excel based (pivot tables, pivot charts, etc.), including detailed data analysis: historical data, forecasted costs and sales, target.
• Created new populate models to upload pricing data by vendor, competitor, category, mostly based on Excel (VLOOKUP, INDEX, MATCH, IF, CHOOSE, ROW, etc.), reduced data entry time from 1 week to 2 hours, and improved.
• Prepared and loaded woodworking, gardening and hardware pricing catalogs into the system
• Researched competitive prices on competitor websites, and performed high-priority analysis through the difference between current web prices, map prices, and sales
• Validated entered pricing data using various internal reports

Telfer School Of Management, Business School In Ottawa, Ontario, Canada

• Designed, prepared and guided weekly discussions, tutorials and laboratory sections for "Statistics for Management" course (ADM 2303)
• Trained over 200 undergraduate students in advanced Excel skills, such as Functions and Formulas, Histograms, Pivot Table, etc.

Inclusive Leadership, Business Administration And Management, General

Master Of Systems Science, System Integration; Database Analysis; Modelling And Simulation; Image Processing, A

Activities and Societies: EC-PEI Competition (2014)

Bachelor Of Management, E-Commerce/Electronic Commerce; Crm; Marketing; Supply Chain Management, A-

Activities and Societies: ERP Sandbox Experiment Competition (2011)