Bing Wang Cell: 672-***-****

Email: adu8uv@r.postjobfree.com

JOB OBJECTIVE

Senior Business Intelligence Analyst

HIGHLIGHTS OF QUALIFICATION

Skilled with Crystal Reports, SSRS, SSIS, SSAS, TSQL, Tableau, Business Object WebI

Created specification and technical documents, translated these requirements into reports.

Very good understanding of ERP models such as Finance, HR and Inventory, CRM

Extensive experience in Oracle, DB2, SQL Server, .NET, MS Office, SAS, Workday

Extensive experience in creation of database objects like tables, views, triggers, functions, SQL stored procedures, PL/SQL procedures-packages.

Innovative, quick learner, proven ability to adapt quickly to a challenge.

Committed to excellent service and customer satisfaction.

PROFESSIONAL EXPERIENCE

Senior Business Intelligence Analyst 12/2021 – Present

Radius Logistics

Gathered Customer requirements; analyzed and created technical documents

Developed modified reports in SSRS and Ad hoc reports in TSQL against ERP software

Designed and modified Dashboards in Tableau against CRM software

Created kind of financial reports such as P&L, KPI, Forecast Analysis and Budget report

Distributed automatically eInvoice, eAging, eBOL, eCommission to suitable recipients

Environment: SSRS, Crystal Reports, Tableau, ERP, CRM, TSQL

Senior Business Intelligence Analyst 2/2019 – 12/2021

NorLand Limited

Developed Stored Procedures, views and complex queries as data source

Designed and modified reports in Crystal Reports against SQL Server for ERP software

Designed and modified Cubes, Reports and Dashboards in Board BI

Data conversion from Legacy System to New ERP software, creating customized Crystal Reports

Provided technical support, trouble shooting and training

Environment: Crystal Reports, Board BI, ERP, SQL Server, Data Conversion

Senior Business Intelligence Analyst 2/2018 – 2/2019

TMW Systems Inc.

Designed and modified reports in Crystal Reports in ERP - TruckMate

Gathered Customer requirements; analyzed and created technical documents

Tested and debugged all reports, made reports performance better

Provided technical support, trouble shooting and training for business users

Environment: Crystal Reports, ERP - TruckMate

Senior Business Intelligence Analyst 8/2012 – 1/2018

BC Centre for Disease Control

Designed and modified reports in Crystal Reports and SSRS against Oracle and SQL Server

Gathered Customer requirements; analyzed and created technical documents

Created and Modified UDFs for the ERP software – Panorama developed by IBM Canada

Developed Stored Procedures, views and complex queries as data source

Modified and maintained reports in SAS

Provided technical support, trouble shooting and training

Environment: Crystal Reports, SSRS, Business Objects, SAS, SQL Server, Oracle

Senior Business Intelligence Analyst 12/2011 – 3/2012

Syscon Justice Systems

Gathered Customer requirements; analyzed and created technical documents

Data modeling with Oracle database for Business Objects reports developing

Designed and Developed reports in Crystal Reports XI/2008 against Oracle

Created complex reports using variable, hierarch grouping, special grouping, drill down and chart

Created Dashboards in Crystal Xcelsius 2008 against Data Warehouse

Using Live Office connection with Universe in Excel for Dashboard developing

Enhanced Business Objects Universe and developed Web Intelligence Report

Provided technical support, trouble shooting and training

Environment: Oracle, Crystal Reports, Business Objects, Xcelsius, WebI, Live Office, Excel

Senior Business Intelligence Analyst 6/2008 – 10/2011

Community Living BC

Designed and modified reports in Crystal Reports and SSRS against Oracle and SQL Server

Gathered Customer requirements; analyzed and created technical documents

Created complex reports using variable, special grouping, drill down, sub report and chart

Created Data Extracts based on users’ requirements and business rules

Published reports to SharePoint, scheduled reports running and exporting

Experience in administration of Business Objects XI Enterprise Suite

Provided training, trouble shooting and technical support

Business analysis, data model and skill in extracting data, Stored Procedures, views and Query

Environment: SQL Server, Oracle, Crystal Reports, SSRS, SSIS, SSAS, SharePoint, TOAD

BI Analyst 11/2006 – 2/2008

Contractor in Teekay Shipping

Universes enhancing for Business Objects reports creating against Oracle

Gathered Customer requirements; analyzed and created technical documents

Created and modified kind of reports in Crystal Reports for Financial Departments

Business Objects administration and data modeling in Erwin

Created complex reports using Cascading Dynamic Parameters and Business Views

Published Reports to Business Objects Enterprise XI, extract data for reports developing

Tested and debugged all reports, made reports performance better

Provided technical support, trouble shooting and training

Environment: SQL Server, Oracle, Business Objects XI, Crystal Reports, JDE, ERwin

BI Analyst 8/2006 - 9/2006

Contractor in Hemlock Printers Ltd

Created and modified reports in Crystal Reports against SQL Server

Converted 80 Crystal Reports from Version 9 to XI

Tested and debugged all reports, made reports performance better

Provided Technical support, trouble shooting and training

Modified existing Stored Procedures for reports developing

Installed reports in PSI Systems and provided technical documents

Imported data from MS Access to SQL Server

SQL Server administration and extracted data, wrote new Stored Procedures, views and Queries

Environment: SQL Server, Crystal Reports 9/XI, MS Access, PSI

BI Analyst 5/2006 - 6/2006

Contractor in Insurance Council of BC

Created reports using Crystal Reports, Access and SQL Server

Gathered Customer requirements; analyzed and created technical documents

Tested and debugged all reports, made reports performance better

Developed the program to handle and running reports using Visual Studio

Created installation Package to run the program on the client work station

Provided technical support, trouble shooting and training

Environment: SQL Server, Access, Crystal Reports XI, Visual Studio

BI Analyst 11/2005 – 3/2006

Contractor in THE NEWS GROUP (A company of Jim Pattison Group)

Created financial reports in Crystal Reports and running in Crystal Enterprise

Gathered Customer requirements; analyzed and created technical documents

Wrote Queries and Stored Procedures against Oracle for report developing

Created complex reports using user-defined functions like @variables, @prompt, condition formulas

Created Analytical Package with Budget and Actual Monthly, Quarterly, Yearly reports

Provided technical support, trouble shooting and training

Environment: Crystal Enterprise, Oracle, Crystal Reports, SUN Accounting System

BI Analyst 10/2005 –11/2005

Contractor in BC Liquor Stores

Gathered Customer requirements; analyzed and created technical documents

Created Crystal Reports and running in Crystal Enterprise

Tested and debugged all reports, made reports performance better

Wrote Queries and Stored Procedures against Oracle database

Developed Crystal Reports against Data Warehouse

Provided technical support, trouble shooting and training

Environment: Crystal Enterprise, Oracle, SQL Server, Crystal Reports, Data Warehouse, ERP

Senior Business Objects Developer 7/2005 -9/2005

Contractor in Business Objects

Created sales reports in Crystal Reports and running in Business Objects, CRM software

Modified and enhanced universes and Business Objects reports against SAP BW

Created complex reports using variable, special grouping, drill down and charts

Created reports using User Function for security control

Tested reports in Salesforce.com to confirm displaying perfect

Familiar all Business Object Tools such as BO Enterprise, Universe Designer and WebI

Environment: Business Objects XI, Oracle, Crystal Reports XI, SAP BW, CRM

Database Administrator/ Reports Analyst 4/2004 – 6/2005

Contractor with Pacific Place Inc. (Insurance Agency)

Created sales reports for Pacific Place Inc. (Insurance Agency) in Crystal Reports 9/10

SQL Server Administration, backup and extract data, tables optimization & normalization

Provided technical documents, training and trouble shooting

Environment: CRM-Goldmine, SQL Server 2000, Crystal Reports 9/10, Windows 2000

Reports Programmer 1/2004 – 2/2004

Contractor with Chancery software Ltd

Gathered Customer requirements; analyzed and created technical documents

Created demo reports in Crystal Reports 9.0 running in ERP software

Developed reports against SQL Server 2000 and data source as XML

Tested and debugged all reports, made reports performance better

Provided technical support, trouble shooting and training

Environment: SQL Server 2000, XML, ERP, Crystal Reports 9.0, Windows 2000

Database Administrator/ Reports Analyst 4/2002 – 6/2003

Contractor with Cornel Trading Inc

Created accounting/financial reports within Crystal Reports 8.5/ Access 2002

SQL Server Administration, backup and extract data, tables optimization & normalization

Translated technical information to a different level users

Creating specification, technical documents and user guide

Provided technical support, trouble shooting and training

Environment: Windows 2000, SQL Server 2000, Access 2002, Crystal Reports, Accpac

Crystal Reports Writer 10/2001-11/2001

Contractor in Boston Pizza International

Participated Data Warehouse project in Boston Pizza International

Gathered Customer requirements; analyzed and created technical documents

Designed reports in Crystal Reports 8.5 in Crystal Enterprise against SQL Server

Developed multidimensional reports in Seagate info against Data Cube

Created Cubes and Queries in SQL Server 2000 Analysis

Provided technical support, trouble shooting and training

Environment: Windows 2000, SQL Server, Crystal Reports 8.5, Crystal Enterprise 8

Reports Developer 3/2001- 5/2001

Contractor in BC Hot House Foods Inc.

Worked in BC Hot House Foods Inc. for ERP project (Epicor, TDC-Lincs, EDIBridge)

SQL Server administration and extract data, wrote Stored Procedures, views and Query

Imported Excel and Access into SQL Server for reports developing

Designed Sales, Inventory, B13, Shipping, Accounting reports in Crystal Reports 7.0/8.0

Made and customized kinds of reports in a lot of modules of ERP (Epicor) software

Worked with end user and provided technical support and troubleshooting

Environment: Windows 2000, SQL Server 2000, Crystal Reports, Crystal Analysis, ERP

Database Administrator/ Crystal Reports Programmer 4/1999- 9/2000

Cerelle Corporation, Vancouver, BC. Canada (CRM-GoldMine Parnter)

Designed reports in Crystal Reports and Cognos reports against kinds of databases such as Oracle, SQL Server, Sybase, DB2, Access, FoxPro, Dbase and Paradox

SQL Server administration and extract data, wrote Stored Procedures, views and Query

Implemented VB, SQL, FoxPro and Crystal Reports in kinds of projects

Gathered and documented end-user requirements, and translated those requirements into reports

Provided technical support, training and trouble shooting

Environment: Windows NT, Oracle, SQL Server, Crystal Reports, Cognos, VB, CRM

EDUCATION

SQL Server SSIS, SSAS, SSRS 3/2010

CTC TrainCanada, Vancouver, BC, Canada

Oracle DBA, Developer 2/2002-1/2003

Extranc Computer College, Richmond, BC, Canada

Computer Application 1984-1987

Nanjing Institute of Technology, China

REFERENCE AVAILABLE UPON REQUEST

Contact this candidate