Business Intelligence

Peiran Liu

** ****** **** ******, *******, Ontario, M1S 1Z7

Cell: 647-***-****

*************@*******.***, https://github.com/qwe3804132,

https://www.kaggle.com/peiranliu

https://www.linkedin.com/in/peiran-liu-244253139/

CORE COMPETENCE

Detail-oriented individual in Full-Stack software development and Business Intelligence development with proficiency in a variety of programming languages and software applications; Excellent programming capability, data modelling, visualization, analytical, self-learning and communicative skills to present and explain complex business issues.

HIGHLIGHTS OF QUALIFICATIONS

Demonstrated experience in Full-Stack software development and Business Intelligence development, participated in the whole MSBI development process.

Experienced meeting with senior vice presidents of the company to report on current company status and support business decisions.

Strong self-learning ability can learn new coding technology in a short time and apply it to practical work.

Programming Stack: C#, ASP.NET MVC, ASP.NET Core2.0, Web API, HTML, Bootstrap, AngularJS, Nodejs, EF, TypeScript, SQL Server, MongoDB, Python3

Business Intelligence Stack: Tableau, Power BI, SSIS, SSAS, SSRS, SSMS, DQS, PowerShell, MDX,

T - SQL, DAX, VBA, VLOOKUP, Data analysis, KPI measure

Applications: Visual Studio/Code, SSDT, Eclipse, Docker, VSTS, Git

Other: Data Vault 2, OLAP Cube, Data Warehouse, AWS, mLab, Heroku

RELATED WORK EXPERIENCE

Business Intelligence Napoleon Fireplaces Inc.

Specialist Data Integration Department

Barrie, Ontario, Canada (May 2018-Sep 2018)

•Participated in and designed the original Data Vault model, with the entire design concept referred to the Data Vault 2.0 edition.

•Designed and created many data visualization reports with Power BI and Tableau, providing effective support for data mining and data prediction.

•Analyzed and designed efficient ETL projects for different ERP systems. Successfully loaded the data from the ERP system into the stage area driven by daily database tasks.

•Hosted and participated in many UAT meeting, held meetings with the various department manager and collected their opinions.

•Deeply analyzed the impact of GDPR on current database business and participated in the re-creation process of the data warehouse in Europe.

•Coaches new or less experienced colleagues how to use pivot - table and show them how to build individual BI stacks using the Excel tabular model.

Electronics Sales Walmart Corporate

Specialist Beijing, China (Apr 2013-Sep 2013)

•Responsible for design 2013 Double 11 Shopping Festival, and successfully boosted sales and customer flow, successfully increase sales by 235% in November

•Assisted with the preparation of cargo inventory for statistics and sales

•Responsible for explaining the product parameters and the use of methods for customers

•Lead the sales team for ad planning and event design

EDUCATION

Software Engineering Centennial College

Technology (Co-op) Toronto, Canada (Sep 2017 to Apr 2019)

Advanced Diploma

Relevant Courses Include: PL-SQL Database Concepts;

Engineering Methodologies; Data Structure; System Integration;

Programming I&II&III; Data Mining; Business Intelligence;

Relevant Projects Include:

•Currently developing an online Dating application that will use asp.net core 2.0 technology, web API and SQLite databases. Temporarily planned to deploy to the Azure cloud platform.

•Designed and implemented an online Survey application using Angular7 framework and MongoDB database. The application is equipped with an NLP-based machine learning module that intelligently detects the type of question and answers automatically.

•Designed and implemented a Link sharing website that includes Paypal integration and customer service system.

•Developed Oracle database relative to Hotel rooms management system.

Computer Science Beijing Union University

Bachelor’s Degree Beijing, China (Sep 2012-May 2016)

Relevant Projects Include:

•Maintaining High Honours status throughout academics

•Having experience anticipate in building Community elderly information management (CEIM) system by the Chinese information Ministry and Responsible for 3-tier architecture database design, creation and maintenance

LANGUAGES

•English

•Mandarin

REFERENCES

Available upon request

Contact this candidate