Business Analyst

MEILING LIANG

Toronto ON M*J *J* 905-***-**** *************@*****.*** https://www.linkedin.com/in/mliang1117/

SUMMARY

A recent MBA graduate, concentration in Business Analytics, with strong academic experience in database designing, data cleaning, clustering, and sampling, modeling, result analysis. Seeking opportunities to leverage my business analysis, business process analysis and project management skills.

TECHNICAL&LANGUAGE SKILLS

Proficiency in relational databases such as MS Access and usage of SQL queries;

Proficiency in Microsoft Project

Practical experience in manipulating of large volume data using analytical tools such as SPSS and Microsoft Excel

Familiar with Python and SAS

Languages: native Mandarin and native Korean

EDUCATION

MBA, concentration in Business Analytics

Goodman School of Business, Brock University, ON Sep 2017 – Dec 2018

Bachelor of Art in Sociology

Central University of Finance and Economics, Beijing, China Sep 2013 – June 2017

RELEVANT PROFESSIONAL EXPERIENCE

Student consultant for the Co-operators Insurance Apr 2018 – Aug 2018

Goodman School of Business

Arranged large data sets, cleaned over 100,000 raw data with Excel functions such as VLOOKUP, IF for higher quality data analysis

Conducted univariate and multivariate analysis by using Pivot Table and SPSS, then selected potential attributes

Built models in SAS EM by using Decision Tree, Logistic Regression and Artificial Neural Network and selected the best model for each sample group for customer insurance bounding rate prediction

Visualized the results and consolidated data to give actionable recommendations, and then also arranged the processes and outputs into a final report

Database Designing for Niagara Furniture Bank Apr 2018 – Aug 2018

Goodman School of Business

Built an Entity Relationship Diagram by Erwin for the further new database

Transferred massive transaction data from old database to the new one by using Structured Query Language (SQL) and Microsoft Access for the client to manage donors, shipments and inventory data efficiently and effectively

Reported the processes of database building and gave the user guide how to use the new database system so that the client could continue to use after consultation.

OTHER WORK EXPERIENCE

Sales Associate (Part-time)

Tommy Hilfiger Canada Nov 2018 – Jan 2019

Provided excellent customer service while on the selling floor, fitting room and front end to meet a daily sales goal

Stocked and replenished merchandise as needed and checked stock within the inventory information system to provide a good customer experience

Answered customer’s inquiries and understood customers’ needs and desires and made recommendations accordingly resulting in cross-sales and up-sales

Worked well under pressure, dealing with a high volume of products organizing

Contact this candidate