Paul Sparrow

Six Years of Client Management Manage relationship with product and sales managers for data and insight requests Provide finished self serve reporting as well as static reporting Drive insights from data extractions for the purpose of increasing product sales Eight years of Project Development. Enterprise wide project management Project development from business case to project closing Business requirement gathering and documentation including business to functional requirements Establishing best practices, procedure and protocol documentation Twenty years as an analyst in sales, marketing and business intelligence. Segmentation modelling and development Campaign design, build and execution.

Collection, analysis and insights from various large relational database systems including Oracle, DB/2, MS SQL, Sybase. Planning, building and Q/A testing on database structures, tables and campaign cubes, both internal and external from department including elements based on client and management requirements. Map plotting including segmentation, customer base, statistical data and projected data.

Updating and running of predictive models and scorecards. Importing from external sources and parsing/rectifying any required data for merging and matching. Customer list extracts for Email Marketing, Telemarketing, Direct Mailing or Face-to-Face sales as well as email deployment and execution.

Report building for departmental and corporate purposes. Five years as trainer and mentor. Onboarding and welcoming new analysts. Setting up and training on various software platforms. Working with new analysts on business acumen.

Installing best practices and teaching policies and procedures to follow Driving motivation and group communication

Senior Performance Analyst - Telus Health

(2022-01 - 2023-12)

• Building Ontology environments for the purpose of central reporting.
• Liaison with sales, marketing, finance and clinic operations for the development of reporting requirements.
• Building and driving of KPI’s to enhance success at clinic operations.
• Data extractions and mergers to provide market insights.

Analyst (Analytic Execution Business Intelligence) - British Columbia Lottery Corp (BCLC)

(2016-07 - 2022-01)

• Project Manager for several enterprise and departmental projects
• Assemble and lead project teams for completion of project components
• PM / BA for EBI projects where requirements gathered from external clients
• Build and document best practices as well as policies and procedures for EBI department
• Provide insights through analysis for driving player and revenue growth
• Assist clients in the development of strategies with regards to product execution and development
• Understand and manage all Casino and eCasino projects and tasks to ensure timely delivery of all requirements.
• Liaison with Solutions Delivery on development of report building and post campaign analysis.
• Assist external clients with data requests for product and marketing support
• Serving as elected ACE rep (Advisory Committee of Employees) for all Digital Enterprise Services non-manager employees.
• Served as facilitator and lead of the Non Manager Department meetings.
• Trainer/Mentor for new analysts to team.

Data Analyst (Marketing / Business Intelligence) - Westminster Savings Credit Union

(2013-08 - 2016-07)

• Segmentation and member survey analysis
• Branch analysis for member penetration and product holdings
• Design and build Sql tables for campaign purposes including cleansing date and contact history development.
• Developing and integrating standards in both data processing and marketing communications.
• Provide input and consultation with various clients outside the marketing department.
• List preparation for email, direct mail, phone or branch contact including extracting data through to delivery
• Report development, production and maintenance for both Marketing department and corporate use.

Marketing Data Analyst – Contract / Employee - Blue Shore Financial (North Shore Credit Union)

(2009-09 - 2013-08)

Campaign Analyst - Marketing - Intrawest ULC.

(2005-06 - 2009-09)

Database Analyst - Telus Inc.

(2001-01 - 2003-12)

Vice President - BC Community Football Association

As Vice President I worked to manage, promote and grow the sport of football at a provincial level while maintaining core values of the program. Duties including facilitating provincial championships as well as working with local municipalities with regards to legal matters and promotions.

President and former Vice President - Vancouver Mainland Football League In charge of running the day to day operations of the league and to encourage further development of the sport in B.C. Work as zone vice president for the BC Community Football Association. Design, create and print the VMFL playoff final game day program as well as create and coordinate all media communications including web site content. Responsible for all financial dealings with municipal government officials.

Vice President / General Manager - Surrey Stickmen Lacrosse Club (Jr ‘A’ / Int ‘A’)

• Responsible of development of relationships with other local associations for the promotion of the sport as well as all marketing functions.
• Develop, maintain and execute all e-newsletter, promotions and web site content.

Associate Certificate - Database Design - BCIT