Sales Representative Data

Zijian (Bosco) Huang

** ***** ******* **, *******, AB Phone:780-***-**** Email: *******@********.**

Profile:

• Talented IT graduate with professional training in Oracle database architecture, administration, backup and recovery, performance tuning and auditing, and data analysis.

• Experience with PostgreSQL, SQL Server, Power BI and Tableau, RStudio, Python

• Enthusiastic professional with a strong working ethic and good time management skills.

Technical Skills:

• Database: Oracle 9i to Oracle 12c, PostgreSQL, SQL Server

• Language: Python, PL/SQL, T/SQL, R

• Software: Microsoft (Word, Excel, Access, Project, Visio, PowerPoint)

• Operation System: Windows, Linux

• Data integration: SQL Loader, Kettle

• Business Intelligence: Qlik, Tableau, Power BI

• Data Warehousing and Data Mining

• Database Backup and Recovery

• Oracle and SQL Server Database Performance Tuning

• Database Web Integration

• Database Security and Audit

• Statistics Analysis: RStudio

Education:

Southern Alberta Institute of Technology, Calgary, Alberta Certificate - Database Administration 09/2019 to 05/2020 Harvard University through Edx

Certificate – Data Science R Basic 01/2020 to 04/2020 Eyes High Education, Edmonton, Alberta

Certificate - Business Analyst Fundamental 01/2019-03/2019 University of Alberta, Edmonton, Alberta

Bachelor of Science Degree in Food Business Management 01/2011-05/2014 Relevant Experience:

Southern Alberta Institute of Technology Database Administrator Project:

• Install Oracle 12c, SQL Server under Unix and Linux environment

• Create a relational database for Travel Experts

• Use SQL loader and external table to transfer data into database

• Set up authentication and authorization for Oracle and MS SQL database Zijian (Bosco) Huang

94 Royal Terrace NW, Calgary, AB Phone:780-***-**** Email: *******@********.**

• Set up auto-update Oracle data warehouse through the trigger and materialized view

• Use SQL and Tableau to do data analysis, data mining and generating reports

• Write PL/SQL to create trigger, procedure, function according to business requirement

• Use SQL and Enterprise Manager Cloud Control to tune database performance

• Tune SQL Server database through Profiler and Database Engine Tuning Advisor

• Perform backup and recovery for Oracle database using SQL scripts and RMAN

• Write PL/SQL to improve database security and monitor internal users’ queries

• Create database Automatic backup using Korn Shell scripts in Linux. Eyes High Education Business Analyst Northwind project:

• Use SQL to query Northwind database in PostgreSQL

• Gather business questions or requirement from client

• Design and create RDBMS in PostgreSQL based on the business requirement

• Use Pentaho to extract data, clean data and loading back to PostgreSQL

• Apply proper SQL to answer the business questions

• Use Qlik to perform graphical analysis

Work Experience:

Data Analyst 2020

Tencent (remote practicum)

• Use Python pandas to analyze data

• Perform Customer Retention Rate analysis

• Use Python seaborn to perform product analysis and generate the report

• Use NLP to perform data text analysis

Accounting assistance 2018-2019

Howard Johnson Hotel, Edmonton, AB

Supervisor 2016-2018

Smashburger, St Albert, AB

Customer Service Representative 2016

TD Bank, Edmonton, AB

Sales Representative 2015

Kognitive Marketing, Edmonton, AB

Sales Associate 2014

J.W. Research, Edmonton, AB

Contact this candidate