Bo.Cui

**** ********* **** ******* *** *G* Phone: 403-***-**** Email: ac8qo3@r.postjobfree.com

EDUCATION

**** – 2016 University of Lethbridge, Alberta, Canada

Bachelor of Science, Computer Science Major, Mathematics Minor

PROFESSIONAL SKILLS

Programming Languages:

Python, Java, C#, HTML, PHP

Database & Query Languages:

Database: Oracle, MySQL, SQL Server

Query Languages: SQL, PL/SQL

Quantitative Modeling Languages:

R, MATLAB, Excel VBA, SAS

Reporting & Analytic:

Tableau, Power BI, Lumira

MS SSIS, SSAS, SSRS, Cognos

SAP BODS, BW, HANA, Crystal Report

Data Analytic:

Data Modeling, Visualization, Hive

Data Warehousing, ETL, OLAP

PROFESSIONAL EXPERIENCE

Rifco National Auto Finance, Alberta Sept. 2018 - Nov. 2018

System and Process Analyst

Build upon and improve the pre-existing reporting structure within Loan Servicing & Recoveries group.

Provide reliable ad-hoc analysis of operational data.

Audit datasets for errors and develop correctional processes.

Communicate project requirements to external vendors or service providers.

Perform additional clerical or administrative tasks as needed.

ATB Financial, Alberta Dec.2017 – June 2018

Business Analyst, Enterprise Financial Performance, Finance Data Analytic & Services

Translate the set of financial information using Business Object tools into reports, dashboards, scorecards, and metrics to provide valuable financial insights

Extract information, design output, interpret and communicate through the relevant tool such as Excel, Access, Google sheet, and Google Apps Script

Used Google Apps(G-Suite) to re-imagine and improve the efficiency of the complex project process

Improved and automated data analysis work flows by creating new analysis scripts

Programming in Google Apps Script to automate the process of manipulating data in Google sheets

Respond to ad-hoc, on-demand and scheduled information requests related to financial data and insights

Assist team members(12) with the interpretation and use of the financial information and data products

Providing backup support to Director, Finance Data Services

Suncor Energy Inc. Alberta Jan.2016 – Jan.2017 Enterprise Business Intelligence Developer, Business Service

Early team member of EBI team(15 people) working with Data modeling, validation, and provisioning

Work with Data Scientists and Project Managers to frame a problem, both technical and within the business context

Design and develop data warehouse solutions using different data modeling techniques independently

Successfully completed multiple large analytic projects with SAP HANA data modeling using Attribute Views, Analytic Views, and Calculation Views (both Graphical and Scripted)

Successfully design and implement HANA models in LVHV project and helped the senior management team make decisions on saving a large amount of cost in the oil field.

Write complex SQL queries, developing stored procedures and performance tuning with RDBMS

Develop the team’s capabilities in data science and apply them to create data-driven insights

Develop data visualization solutions that present data in a meaningful way

Bo.Cui

11414 41 AVE NW, Edmonton T6J 0T8 Phone: 403-***-**** Email: ac8qo3@r.postjobfree.com

(Continue)

Develop test plans, test cases, unit testing, system testing, integration testing and supporting User Acceptance test(UAT) processes

Create and continuously update detailed Business Requirement Documents (BRD)

Work effectively with people at all levels at Suncor through Fort Mcmurray supporting project to develop and design web-based mapping application

Perform analytical, simulation, and optimization activities to provide actionable recommendations

Working collaboratively in a team environment and successfully completed projects under tight time

Agriculture and Agri-Food Canada, Alberta Jan.2015 – May.2015

GIS Remote Sensing Research Assistant, Remote Sensing Lab

Spatial data retrieval, compiling and manipulation of remotely sensed data

Spatial Data Analysis, Scripting Excel Macro, Statistical Analysis and Modelling, and Visualization

Research and develop Machine Learning models for security problems, in the areas of remote sensing data

Using machine learning methods to develop data models using R and Python

Data mining using Machine Learning algorithms in R and Python such as K-NN, K-means and etc.

Programming in a variety of languages to build statistical models for image analysis

Programming in Python and R for data analysis in proprietary image analysis software

Excellent understanding of statistical methods such as correlation, regression, classification

Develop prototypes and algorithms to validate the results from large data set up to 100GB+

Develop statistical methods with MS Excel mastery, including VBA, PivotTables, charts, and graphs

City of Edmonton, Alberta Jan.2014 – Sept.2014

System Analyst, Corporate Service Department IT Branch

Worked in POSSE team(20 people) on delivering and configuring the work-flow management process

Gather business requirements from customers and provide solutions independently

Strong hands-on experience with Relational Database, SQL/PL SQL, ETL, and Dashboard

Providing high-quality services in developing meaningful reports and dashboards

Successfully completed application migration projects and complex cube reporting solutions project

Managing and troubleshooting end-user problem tickets

Contact this candidate