Post Job Free

Resume

Sign in

Data Analyst

Location:
Ottawa, ON, Canada
Posted:
August 13, 2018

Contact this candidate

Resume:

Liam Dodd

Tel: +447***-***-***

Email: L ac6ni5@r.postjobfree.com

PROFILE

A data analyst and Mathematics Masters graduate with an analytical and business focussed mind-set. Experience of working with award winning multi-national clients as well as building a data analysis function from scratch within a small business. Developed strong logical reasoning and critical thinking skills and gained a first class final year dissertation. Certified SQL programmer. Looking for a position based in analytics and business intelligence in a customer/client-centric environment. Permanent Resident of Canada. EMPLOYMENT HISTORY

Jun 17 – Jul 18 Deltra Recruitment Data Analyst

Deltra Recruitment is a niche supplier of project, programme and change professionals. Responsible for business intelligence and CRM analysis.

● Researched, selected and implemented a new CRM system, built on Microsoft Dynamics.

● Led the company’s GDPR strategy, from implementing a data retention policy to creating an automated process for candidates to request and receive their own data.

● Created a number of initiatives, increasing the number of logged activities and improving the accuracy of data.

o Calls up by 35-40% across the company due to personalised call lists being provided to consultants.

o Key data fields populated accurately at 75-180% above target due to gamification of admin tasks for consultants.

● Built live dashboards and automated reports, using T-SQL, SSIS, Excel and VBA, to enable managers and directors to make informed decisions on day to day activities and long term strategies regarding clients and consultants. o Developed tailored activity targets for consultants using correlation analysis and a linear regression model on prior activity and revenue generated.

● Sole member of technical staff so demonstrated autonomy and problem solving skills.

Nov 15 – Jun 17 Planning Inc Programmer

An award-winning agency delivering next-generation data marketing solutions. Clients included a multinational FTSE 100 retailer and an award-winning online casino.

● Responsible for developing and programming data-driven digital marketing campaigns, including maintaining the ETL process, using a number of programs such as SQL, SSIS, and Salesforce.

● Gathered requirements and managed expectations directly with clients.

● Created and maintained models to segment and target customers based on activity, value and behaviour.

Oct 14 – Oct 15 Deltra Recruitment Recruitment Consultant Deltra Recruitment is a niche supplier of project, programme and change professionals. Portfolio included clients from the Gaming and Betting industries.

● Established and maintained long term relationships with both clients and candidates.

● Researched current and prospective clients through interviewing candidates and meeting with contacts within the company.

● Coached candidates through the interview process. Nov 13 – Aug 14 Casual Work in Australia Various Roles

● Full time casual work across Australia as part of a year long working holiday, including Brisbane’s largest restaurant and a boutique winery in rural Western Australia.

May 13 – Oct 13 Sesui Customer Relationship Executive

● Built and maintained call routing trees for a varied client base including 112 emergency services and a large flight retailer.

● Dealt with sensitive information and also complied with legal requirements regarding response time to outages and relocations. Sep 12 – May 13 British Gas Business Customer Relationship Executive

● Front line of communication for a personal portfolio of over 1000 sites which involved managing all aspects of customers’ queries from initiation to completion.

● Knowledge of all teams and departments within a very large corporation which required strong interpersonal skills and an excellent telephone manner.

● Expected to comply with strict industry regulations involving the timescales of queries and the handling of complaints.

● Worked as a part of the “Strategic Broker” team, which involved working with and attending meetings with trained energy professionals from other organisations as well as members of the public.

EDUCATION & QUALIFICATIONS

2017 Microsoft Certification 70-461

● Querying Microsoft SQL Server 2012/2014

2008 – 2012 The University of Edinburgh

● MA (Hons) Mathematics and Philosophy, achieved 2:1 classification. 2001-2008 The Marlborough School, Woodstock

● A-levels: Mathematics (A), Further Mathematics (A), Chemistry (B), Physics (B)

● 10 GCSE’s (A-C)

TECHNICAL SKILLS

● SQL Server – Intermediate

● SSIS – Intermediate

● VBA- Beginner

● Python – Beginner

● R – Beginner

● Azure - Beginner

● PowerBI - Beginner



Contact this candidate