Jay Ren

Toronto, ON 416-***-**** ac8qnp@r.postjobfree.com https://www.linkedin.com/in/jay-ren-76755532/ Sr. Data Analyst Business Intelligence Analyst

Providing data-driven, action-oriented solutions to challenging business problems Business-minded data analyst with a demonstrated ability to deliver valuable insights via data analytics and advanced data driven methods. Relied on as a key advisor in driving multimillion-dollar growth; gains in customer loyalty; and increasing efficiency, accuracy, and utility of internal data processing.

Technical Skills

SAS (certified), SAS Enterprise Miner

Python (Pandas Numpy, SciPy, scikit-learn, Matplotlib, Seaborn, Tensorflow) SQL, MATLAB, Octave, Excel VBA, Access, Tableau

Professional Experience

Business Intelligence Analyst Nov 2016 to Present

Dentalcorp Health Services ULC (The largest network of dental clinics in Canada) Toronto ON

Furnish executive leadership team (VP Finance, CFO) with insights, analytics, reports, and recommendations enabling effective strategic planning across all business units.

Developed intricate algorithms based on deep-dive statistical analysis and predictive data modeling that was used to predict customers’ spending, deepen relationships, strengthen longevity and personalize interactions with customers.

Performed analysis and presented results using SQL, MS Access, Excel, and Visual Basic scripts.

Analyzed and processed complex data sets using advanced querying in the multi- million-row database.

Wrote and automated tools and scripts to increase departmental efficiency and automate repeatable tasks.

Applied Principle Component Analysis and proposed k-means clustering model to group customers.

Applied descriptive analytics to discover key factors affecting customer churn rate.

Helped with planning and overseeing the execution of all Paid Social, Remarketing, Display Advertising, and Email campaigns.

Helped on managing market campaign pacing and performance through meticulous data analysis.

Built, published customized interactive reports and dashboards, report scheduling using Tableau server.

Developed VBA programs to automatically generating financial statements, P&L reports and automatically sending to more than 1000 external stakeholders. Jay Ren Page 2

Sr. Financial Reporting Analyst March 2013 to Nov 2016 Rogers Communications Inc. Toronto ON

Improved data mining processes, resulting in a 50% decrease in time needed to infer insights from customer data used to develop marketing strategies.

Applied data transforming, loading, and data cleaning with SAS to over 10 million entries, transforming unstructured datasets into structured datasets.

Used predictive analytics to forecast company sales of new products with a 95% accuracy rate.

Developed macros to manage the processing of financial reporting. These macros facilitated the collection of data and automatically generating financial reports.

Completes formal monthly managerial and statutory variance reports for Finance and relevant management teams.

Data Analyst Aug 2012 – Mar 2013

Global Research Solutions, Burlington, Ontario

Prepared and cleaned datasets using SAS base and SAS EG

Analyzed and interpreted trial results and built statistical models

Conducted survival and predictive analysis

Determined the reliability and validity of data

Reporting Analyst - Marketing Jun 2010 – Jul 2012

Bell Canada, Toronto, Ontario

Performed market analysis to efficiently achieve objectives, increase sales by 20%.

Managed the planning and development of design and procedures of marketing metrics reports.

Conducted quantitative analysis of products and market conditions.

Design and conduct research and testing protocols to ensure accurate and up-to-date information on the results and effectiveness of the marketing campaigns. Education

Master in Economics

Carleton University

B.S, Actuarial Science & Statistics, Graduation with Distinction University of Toronto

Actuarial Exams completed: P/1, FM/2, MLC/3L, MFE/3F, and C/4 Certified SAS Base Programmer

Contact this candidate