Jacky Du Email & Phone Number

Toronto, Ontario, Canada

Collected, web scraped, researched, analyzed, and interpret market trends in quantitative and qualitative data setEvaluated business processes, anticipating requirements, uncovering areas for improvement, developing and implementingPerformed trend analysis reports on product sales documenting and communicating results.Used ETL and data integration SSIS to extract data, transform and upload to SQL server.Write database script, SQL queries using joins, grouping subqueries etc. to extract data.Created SAS macro programs, macro variable and used existing macros to develop and improve SAS codes for the project.

Guangdong, China

Analyzed trends and results for sales across the whole company.Gathered data/information and performed an analysis in support of sales strategy.Participated in cross-unit initiatives and Enterprise initiativesSupported improvement to procedures/workflow between functions and field partners.Developed collaborative relationships with field partners that support the government.

Guangdong, China

Analyzed impression, quote and sales data to improve the financial performance of Direct Markets’ acquisition (i.e., marketing & Telesales) spendIdentified opportunities to leverage analytics to support increased optimization of marketing initiatives (e.g., Paid Search campaigns, price comparison website (PCW) partner onboarding, adjacent products) for specific marketing creative and programsLeveraged transactional data to identify problems within the end-to-end quoting experience for either the consumer or the underlying technical environments (e.g., data warehouse, online quoting platform technical or underwriting knockouts, 3rd party quote or lead imports)Collaborated with Enterprise and Personal Insurance Marketing, Data Engineering, Data Science, Direct Markets Circle Team, etc. to evaluate the performance of new predictive models. Anticipate how onboarding those processes will impact our data warehouse and the evaluation of the businessCoordinated with marketing media managers on near term strategies associated with creating new campaign assets for Direct MarketsPartner with Campaign Management / Advertising Operations team to ensure go-to-market efforts have been set up correctly and align to desired end-state business outcomes

Guangdong, China

Underwrote and analyzed new and renewal business utilizing the Company way of Underwriting framework. Analyzed business reports to determine adequate exposure and loss ratingDeveloped, maintain & collaborated with Line of Business representatives on referrals and other business-related needs.Established and sustained relationships with distributors (agents & brokers) in support of business retention and acquisition and works with customers and distributors (agents & brokers) to determine their insurance-related needs and provide solutions.Cross-Sell other lines of business to increase product density with the account

Advanced Diploma, Data Science And Application

Data science, Data science, and big data analytics, SQL Programming, Python for Data Analytics, SAS, R for Data Analytics, Excel VBA.

Bachelor'S Degree, Insurance