Resume

Sign in

Data Analyst

Location:
Toronto, ON, Canada
Salary:
60000-70000
Posted:
December 02, 2019

Contact this candidate

Resume:

Echo Ren, MBA

Direct: 289-***-**** adaza3@r.postjobfree.com

SUMMARY OF QUALIFICATION

•3 years of experience working as a data analytics consultant in multiple verticals such as telecom, credit risk, banking and retail

•Specialized in marketing campaign, customer profiling, segmentation, retention, and statistical analysis

•Analyzed large and complex datasets to support business decision making process and deliver analytical solutions

•Proficiency in using compelling visual graphs and diagrams in presentations to effectively communicate data insights and summarize findings into concise yet informative reports that can be easily interpreted by business partners across the organization

•Experience in designing and developing interactive dashboards and reports using visualization tools such as Tableau, SAS Visualization and Excel

•Expert in standardizing code and processes, automate reporting or other repetitive programming tasks using advanced SAS macros

•Certified SAS programmer, ability to perform data extraction/ETL, validation, transformation, error handling, aggregation and analysis using SAS and SQL queries

•Advanced Microsoft Excel (pivot table, v-lookup, functions) and PowerPoint skills

•Efficient, organized and resourceful team player, capability to communicate complex business problems and present technical solutions in simple and clear language

•Proven time management and prioritization skills to handle multiple projects with high quality and exceeding expectation

PROFESSIONAL EXPERIENCE

MPR Consulting Inc. Toronto, Canada SENIOR DATA ANALYST Mar 2018 - Present

Accomplishments

•Increased different campaign conversion rates by 2.5 to 4.5 times better than their BAU process for a telecom client, an estimate of $46 million additional revenue per year

•Successfully help client to launch and executed a churn save outbound call program based on analysis done, reduced churn by 5 bpt per month

•Improved three months cure rate for a credit card profile by 37%

Responsibilities

•Engage with management or stakeholders to understand and clarify business requirements, project scope, evaluation criteria and KPIs and get alignment on delivery milestones and timelines

•Translate business requirements into technical and analytical language and project work plan

•Identify required data, extract and join or consolidate multiple data sources, including but not limited to, relational data bases (SQL server, Oracle), Hadoop, flat files etc.

•Understand business, processes, and logic for data to be analyzed, validate data distribution, detect outliers and anomalies, inconsistency or other data issues, and identify reasons and best methods for handling missing values

•Perform data exploration to test hypothesis, discover trends and analyze patterns

•Provide end-to-end marketing analytics solution to clients, from campaign design, leads waterfall methodology and logic, control group selection, model adoption for campaign optimization, campaign reporting and post campaign analysis

•Support marketing campaigns of all channel types, inbound and outbound (email, mobile, text, digital, social media etc.)

•Develop customized and automated periodic reporting solutions that enable data driven decision making, ad-hoc analysis and insight generation for executives and business stakeholders

•Build customer segmentation using different methodologies, such as k-means clusters, which help clients to develop business strategies based on different profiling and characteristics of customer groups

•Present key findings and data insights to stakeholders and provide documentation and training to business users as required

MPR Consulting Inc. Toronto, Canada

DATA ANALYST Feb 2017 - Feb 2018

•Worked with senior data scientists to support predictive model development and validation

•Refined and developed automated processes to reduce manual work and improve efficiency

•Extracted and validated data, provided data engineering and analysis support to senior data scientists

•Translated business logic into programming logic based on senior analysts’ requirements

•Conducted statistical analysis such as regression analysis, ANOVA, cluster analysis etc. to find the association among different variables and validate hypotheses or identify trends

Yuzu International trade Inc. Kaifeng,China

ADMINISTRATION ASSISTANT 01/2015 - 06/2015

•Provided accurate administrative support for different departments.

•Created and maintained meeting notes and files, prepare and complete invoices, reports, presentations.

•Make schedules for different events such as weekly meetings and recordings

•Managing attendance and evaluation forms

•Organizing employee personal files, documents

•Providing everyday office support for managers and other departments in order to solve problems

Jiying English School Kaifeng,China

TEACHING ASSISTANT-INTERNSHIP 07/2012 - 08/2012

•Work as a teaching assistant for the foreign teachers

•Proficiency in office software and capable of independently design courseware

•Keep updating students’ progress and keep daily communication with parents

•Help students deal with grammar, spell and pronunciation mistakes

EDUCATION

Master of Business Administration(Finance)

08/2015 – 06/2017

Goodman School of Business, Brock University, St. Catharines, Ontario

Bachelor of International Business and Trade

09/2010 – 06/2014

Henan University, Henan Province, China

•Academic Scholarship from 2010-2014

CERTIFICATION

•SAS Certified Based Programmer for SAS 9

•SAS Certified Advanced Programmer for SAS 9

REFERENCES AVAILABLE UPON REQUEST



Contact this candidate