Brian Wong Email & Phone Number

Vancouver, Bc, Ca

Vancouver, Bc, Ca

North Vancouver, British Columbia, Canada

Vancouver, British Columbia, Canada

Vancouver, British Columbia, Canada

Oversaw projects concerning customer data and reverse logistics, making sure that project milestones were achieved and customer data was kept accurate. Projects involved optimizing the return process, leading to cost savings on shipping. Collaborated with various teams, including digital marketing, to enhance the efficiency of guiding customers through the conversion funnel. This was accomplished by transforming data and using visualization tools to aid in processes such as marketing ad engagement, newsletter signups, and transaction completion.

Vancouver, British Columbia, Canada

Modernize the data and analytics toolset from MS PowerBI to AWS Quicksight, Redshift, Glue, CodeCommit, and Athena. Assist the Product Team in analyzing cost and margins and how different product types affect KPI metrics. Curate and validate new datasets from the datalake and create dashboards for the business units. Train end users with the BI tools and curated datasets.

Vancouver, Canada Area

Improved business processes relating to the ecommerce sales channel. Supported channel growth in areas like product, inventory management, planning, logistics, and back-end systems stability. Planned and built the first data warehouse solution with the data architect and integrations developer. Wrote SQL queries for data analysis and validated data integrity. Produced BI reports using Data Studio, Sheets and Excel. QA with end-to-end testing of new Salesforce website features and bug fixes. Utilizing Salesforce Commerce Cloud, Google Analytics, BigQuery, and ERP systems to extract data.

Vancouver, Canada Area

Helping the company move the business content and process into the cloud. Building up the new SharePoint Online environments and working with teams to utilize all of its functionalities. Design and build workflows for the Accounting and Operations Team. Validate ERP data through creating financial and operational reports.

Vancouver, Canada Area

Developed reports and dashboards, then transitioned into administration of the Business Objects platform. After a several operational years, we transitioned the primary reporting platform to SSRS (Report creation and migration) and SharePoint (2007/2010/O365). Managing, training, troubleshooting and documentation for the business application platforms Sharepoint & SSRS. This included being the main point of contact for those applications, which later included Office 365 apps such as Onedrive, Delve, PowerBI. Realigning back to the analytics realm and positioned to help set up Azure/O365 systems. Assisted in understanding the meaning behind all the data, and find a "one true source" home of all our systems data in the warehouse. Led as project coordinator for BI related projects. Smaller projects included the migration of reports from older Crystal and SSRS platforms over to Power BI Report Server.

Created and maintained Crystal and Web Intelligence Reports for the client. Exported BI charts for company's board reports.

Designed Crystal Reports specific to end-user’s requirements to assist with the investigation team. Designed and executed SQL queries/commands to provide investigators with quick answers. Administrated user rights and access on the database in order to keep a secure system. Provided miscellaneous technical support.

Created and maintained an MS Access database to store Postal Code information about veteran clients. Application front also developed from ground up in Visual Basic to connect to database. Incorporated crystal interface into application. Packaged whole project into an installation file.