Etienne Lessard

• Product owner of new actuarial forecasting tool responsible for coordinating with Data Engineers to ensure proper data flow and the implementation and testing of reporting specs to meet the actuarial team’s needs and expectations
• Redesigned two GLM predictive models in python
• Redesigned data pipeline
• Proposed and implemented a predictive model based on survival curves using the python lifelines package to estimate the time remaining on files.
• Utilized advanced querying, visualization and analytics tools to analyze and process complex data sets.
• Built predictive models using python packages including pandas, sci-kit learn, statsmodels, interpretML.
• Created algorithms to compute complex problems, such ultimate costs based on predicted life-cycle and inflationary adjustments.
• Implemented randomized sampling techniques for optimized analysis of employee generated inputs into model.

• Supported senior leadership with several high impact analyses on operational processes and performance
• Utilized a wide variety of statistical and data tools to harness internal data (SQL and relational databases, SAS and Tableau)
• Actively democratized data through developing topic specific Tableau dashboards for front line managers
• Developed and maintained datasets and SQL-based views in DB2
• Contributed to the new analytics strategy by ensuring that new Big Data data solutions tools will offer quality data and be usable for immediate decision-making once implemented
• Participated in designing the new Data Governance programme at ICBC, including the operating model, onboarding junior staff, evaluating vendors for a new tool and working out the proof of concept
• Lead UAT initiatives to test new tables
• Created advanced statistical models (linear regression, logistic regression, discriminant analysis, cluster analysis, etc.) to provide in-depth analysis of business problems.

• Supported corporation by leading several high value research programs (customer value proposition, regional footprint, customer behaviour, product optimization, communication chanel strategy, etc.).
• Defined scope and structure of research projects in consultation with business areas.
• Managed external vendor relationships (RFP process and evaluation, on-boarding and coordination).
• Provided day-to-day guidance and practical research knowledge to other members of research team.

• Managed research projects from design to reporting for clients in health and pharmaceutical industry, beverage industry, construction industry and consumer goods.
• Supervised work of between 2-3 Junior Analysts and coordinated all parts of research process to ensure timely delivery of results.
• Business development activities include prospecting, presenting firm’s capabilities, responding to RFPs, writing proposals, proposing and costing out methodologies and following up with potential clients.
• Personally established long term relationships with at least two high-value clients, each bringing in over 100K annually.
• Developed and presented internal training material on sampling and weighting.
• Demonstrated ability to translate clients’ business objectives into research objectives in meaningful ways and creating visually impactful presentations that communicate insights concisely.
• Used advanced analytics including MaxDiff scaling, conjoint methods and regression analyses to derive motivations, estimate demand, establish pricing curves, optimize product features, discover purchasing drivers, etc..

MARK 4360 Customer Relations Management (CRM) (Fall 2013, Summer 2015)

MARK 1002 Introduction to Marketing (Winter 2015)

MARK 3215 Buyer Behaviour (Winter 2014)

BUSN 2429 Business Statistics I (Summer 2013)

• Planned and coordinated custom research projects including questionnaire and discussion guide design, elaborated research methodologies, analysed results as well as wrote and presented reports.
• Areas of experience: government programme evaluations, trackings (quant), ad evaluations (qual/quant), product evaluations (qual/quant), volume projections (quant), customer satisfaction (quant), U&A’s (quant) and employee satisfaction (quant).

• Part-time Marketing Analyst for the International Market Research Group, a university research center, research and writing up market profiles for specific industries in different geographical regions.