Objective

Independent Business Intelligence consultant seeking contract opportunity to collaborate with a forward-thinking organization to implement IT best practices and lean processes

Overview

An individual bringing over 14 years of combined experience in in Project Management, Data Warehousing and Software Development. A fast learner looking forward to new challenges

Current Areas of Expertise

Project Management (agile and waterfall)

Requirements Analysis

Process Analysis and Optimization

Data Modelling

Master Data Management

Database development

ETL Development

Analytics

Report Development

Technical Summary

Platform as a Service

Amazon Web Services: RDS, EC2, Lambda, S3, VPC, IAM, SQS, SNS

Reporting

Tableau, Microsoft SSAS and SSRS, Crystal Reports, Business Objects Enterprise, Xcelsius, Business Objects Web Intelligence

Databases and ETL

Microsoft SQL Server, Oracle, IBM DB2, Amazon Redshift, PostgreSQL, MySQL, MongoDb, Redis, Microsoft SSIS, SAP Business Objects Data Services

Programming

Python, C#, C, C++, Java, XML, Perl, PHP, JavaScript

Tools

Office 365, JIRA, Confluence, MS Project, git, Perforce, SAP Redwood, Visio

Work Experience

Univar Richmond, BC

Project Manager Jan 2016 – current

Data Integration and Accounting Reporting

Multiple data source integration and data acquisition to address escheatment auditing requirements

ERP Process Improvement

Technically challenging project to automate processes in the rebate program across US and Canada valued at more than 40 million dollars per year

Payroll Migration

Payroll software migration from on premise ADP PCPW to ADP Workforce Now cloud solution. Over 850 employees and contractors

3PL ERP System Implementation

Program Manager for system integration as part of an M&A initiative in the third-party logistics (3PL) industry. Budget of more than 2 million dollars. Manage multiple parallel work streams:

· Warehouse wireless installation to support handheld scanners

· ERP and Warehouse Management System (Royal 4) implementation

· Customer Web Portal

· Accounting and Finance System Integration

Notable project activities and requirements: Vendor selection through formal RFP. Vendor contract negotiations and vendor management. SOX Compliance. Health and Safety. Information Security and Personal Privacy

Univar Richmond, BC

Data Modeler and Database Developer Apr 2014 – Feb 2016

· Enterprise Data Warehouse data modelling

· Data rule analysis and implementation of semantic layer and data marts

· Design near-real-time ETL pipeline using Amazon Web Services and Redwood Automation

· Implement change management control and version control processes

· Tableau reporting

BC Housing Burnaby, BC

BI Developer and Analyst Sep 2012 – Apr 2014

· Data conversion and migration, reporting and dashboards for project to implement a new Subsidy Manage and Rental System

· ETL Development using Oracle 11g

· Report development

· Work with subject matter experts to gather, confirm, and refine business requirements

· Facilitate user acceptance testing with stakeholders, ensuring proper requirements are met

airG Inc. Vancouver, BC

Senior BI Business Analyst, BI Team Lead Mar 2012 – Sep 2012

· Manage business intelligence team

· Oversee BI system architecture and design direction in a high transaction volume environment

· As a product owner collaborate with stakeholders to identify opportunities, define requirements and manage expectations

· Create repeatable development practices to drastically reduce project delivery time and estimates

Univar Redmond, WA

Master Data Management (MDM) and BI Analyst Sep 2010 – Jul 2011

· MDM Analyst and Developer on a large multi-national SAP implementation

· Elicitation, analysis and documentation of business requirements, processes and workflow

· Lead system design, implementation, testing, training and support for business processes and support team processes

· Create and validate MDM Processes using SAP MDM and SAP NetWeaver Portal

· Worked closely with Dun & Bradstreet to create a data cleansing solution

· ETL Development using SAP Business Objects Data Services

Univar Richmond, BC

Data Warehouse and Report Developer Oct 2007 – Sep 2010

· Designed and developed Data Warehouse using SQL Server BI stack to support ad-hoc and scheduled reporting. Focus on procurement, inventory, sales and billing data

· Data modelling

· Database development and optimization using SQL Server

· OLAP cube design and development

· Report development for procurement, sales and finance departments using Crystal Reports

Quasar Solutions

Business Object Independent Consultant Feb 2007 – Oct 2007

Apple Inc. Cupertino, CA

· Analyze business processes and requirements to provide sound technical solutions

· Provide training in semantic layer and data model best practices using Business Objects Universe

· Demonstrate and present to executive levels business advantages of Business Objects software

· Develop proof of concept corporate dashboards using Crystal Xcelsius

Guess? Inc. Los Angeles, CA

· Crystal Enterprise sizing, installation and optimization of production enterprise environment

· Report development using Crystal Reports

Kaiser Permanente Oakland, CA

· Business process change proposal at company-wide level to leverage multi-million dollar investment in business intelligence technology

· Requirements analysis for sizing of clustered Business Objects Enterprise environment

Radical Entertainment Vancouver, BC

Game Developer Sep 2003 – Aug 2006

· Games: Simpsons Hit and Run, Scarface: The World is Yours

· C++ SDK library and game tools developer

· Design and develop scalable platform for automated game testing. Proved to significantly increase product quality and shorten testing lifecycle

Education

University of British Columbia Graduated 2014

UBC Certificate in Project Management

Simon Fraser University Graduated 2005

Bachelor of Science, School of Computing Science, specialization in Software Engineering