Business Analyst

OBJECTIVE: Business / Reporting Analyst

QUALIFICATIONS:

1+ year of professional experience with Accounting, Business Analysis and Report Generation

Hands-on practice in financial budgeting, planning and forecasting, in addition to report generation on sales and marketing data for sensitivity / impact analysis with various statistical tools

Well-rounded capabilities in acquiring business requirements and performing further data analysis effectively to support business decision-making process and develop key performance indicators

Advanced Microsoft Excel skills (V-lookup, Macro, array formula, PivotTable, filtering, sorting, charting, and Solver) to Model business logics and represent data with summary and dashboard

Proficient with VBA/Macro to automate report generation process regarding to manipulating data records, exporting business data from excel, analyzing contributions and margins, pricing & costing

Experienced with Microsoft Access/SQL Query(DML and DDL), and database modeling

Proficient in statistical analysis tool (SPSS) to make Regression, ANOVA, and Factor Analysis

Strategic thinker with strong critical reasoning skills, Mathematical and problem-solving skills through extensive business analysis and excellent project management and organizational skills

Quick learner and initiative taker that delivers equally well with or without supervision

EXPERIENCE

Business Analyst (Part-time) MPR Consulting Inc mprconsulting.ca 2015.2-present

Gathered data and prepared data for business analysis, reporting, trend analysis or forecasting decisions, ensuring accuracy of data and assisting with problem resolution

Data explored by random dataset partitioning, correcting for outliers, missing value imputation, non-linear transformations.

Data preparation by studying the customer distribution and patterns, the customer behaviors, and the relationship between customer attrition and those business factors.

Analyzed, designed and developed the effective solutions based on Client’s Business Requirements.

Attrition modeling by dividing the customers into those groups called deciles with logistic regression;

Identified the attrition risk factors and applied the model to a target audience to improve customer’s retention.

Performed customer segmentation analysis, identified the best target segments based on customer behavior and demographic attributes analysis.

Established and maintained organized electronic filing systems to ensure that business and operational reports, forms, and other business documentation are readily available.

Prepared analysis of financial/non-financial results and other relevant business data for input into various documents (e.g. business cases, strategy documents, etc.)

Accessed, extracted and retrieved customer data from many different sources: raw data files, Microsoft Excel/Access and other relational databases (SQL Server etc.).

Manipulated and complied data sets with business rules for data validation, data cleaning and data transformation to ensure data quality and integrity using SAS Base/SQL/Macro.

Created intuitive dashboards for insight business intelligence and delivered Ad Hoc reports for management decision making and marketing activities.

Marketing Assistant (Co-op) Changhao Real Estate Development Co.,Ltd, Hongkong, 2014.9-2014.12

Used intelligent information management tools to discover and extract information to help support the decision making processes and identify revenue/costs risks and benefits

Compiled data from various sources and create a coherent report describing the data

Conducted deep dive analyzes with large volumes of data to support Revenue Assurance initiatives

Maintained an in-depth understanding of Business analysis trends and industry best practices

Developed and implementing reports to measure new initiatives

Improved existing business practices through careful analysis and research

Performed ongoing research to predict market/industry trends

Supported the creation and collection of geospatial assets

Assembles consumer rating reports by compiling, consolidating, formatting, and summarizing information, graphs, and presentations.

Updated competitor database by inputting data from field sales; compiling, consolidating, formatting, and summarizing information, graphs, and presentations; distributing reports.

Published pricing schedules by verifying freight rates, charges, and allowances.

Supported sales presentations by assembling quotations, proposals, videos, slide shows, demonstration and product capability booklets; compiling account and competitor analyses.

Prepared mailers and brochures by formatting content and graphics; arranging printing and internet packages.

Maintained marketing library by checking and replenishing inventory.

Provided marketing tracking and research information by collecting, analyzing, and summarizing data and trends.

Updated job knowledge by participating in educational opportunities.

Accomplished marketing and organization mission by completing related results as needed.

Auditing Assistant (Internship) XinLian Accounting Firm, China, 2013.8-2014.2

collated, checked and analyzed spreadsheet data

checked that financial reports and records to make sure accuracy and reliability

assisted to prepare reports, commentaries and financial statements

liaised with managerial staff and presenting findings and recommendations

EDUACATION

2014-2016 University of Windsor Master of Management International Accounting and Finance

2009-2013 Shanghai University of Political Science and Law Business Administration

MS SQL Server /Advanced MS Office Excel Training

Preparing to take SAS Certified Base Programmer

Introduction to Database / Extensive coverage of the relational model

Contact this candidate