Post Job Free

Resume

Sign in

Business Intelligence Analyst

Location:
Montreal, QC, Canada
Posted:
April 21, 2020

Contact this candidate

Resume:

Ben Kane

adcwo4@r.postjobfree.com

819-***-****

PROFESSIONAL PROFILE

• With a mastery of project management methodologies, I help you ensure the efficiency and the effectiveness of your projects throughout their lifecycle

• With a strong capacity in data analysis, operational analysis, control and planning, I monitor and optimize your business performance

• Good in statistics, econometrics and finance, I support you in your business analysis and help you make more rational and optimal your decisions

• Good team spirit, ability to act effectively with different stakeholders

• Result-oriented, initiative-oriented, very resourceful and rigorous

• Advanced mastery of several computer tools including Excel, Power Query and Power BI. PROFESSIONAL EXPERIENCES

Performance Analyst (Project and Finance Control) Dec 2018 Société pour l’informatique industrielle Inc. Montréal, Québec

• Controlled the process and insured the solvency of the company

• Analyzed the performance of the company's projects and activities

• Developed the monthly report of the SII group

• Extracted, analyzed and built data models to develop specific analysis reports and KPIs for Directions and marketing department

• Developed BI solutions and decision making of certain product

• Analyze needs and improve operational tools and processes. Some achievements:

Developed a visualization solution in support of our ERP system (MS Dynamics 365) so that all time entries on different projects can be controlled and approved 3 times faster.

Developed a tool to track all projects and products to be billed. Thanks to this tool, the unbilled projects at the end of the billing process are less than 1%.

Developed a tool that can track all unpaid bills. So, the account receivable in charge can easily claim them to the consumer with all the information needed.

Set up a SharePoint data library supported with an Excel file to consolidate and automate the tracking of all project and business expenses.

Implemented a cash flow management system and a statistical forecasting of revenue to better make and anticipate financial decision.

Finance control

• Analyzed cash flow, tracked the billing process and outstanding assets

• Performed financial forecasting

• Performed budget and revenue variance analyses.

Project control

• Controlled the creation, planning, resources allocation and contractual information of project portfolios

• Tracked the schedule, the earned value and various KPIs of projects

• Performed the rendering of accounts of internal projects

• Contributed to the control and the business analysis of the ERP MS Dynamics 365 Project Service Automation. Helped with different problem solving. Research Assistant (Data Analysis) Seminary Jun. 2018 University of Quebec in Outouais, Gatineau, Quebec

• Built a database

• Performed data analysis with SPSS and Minitab

• Develop the detailed report of the results with simple explanations of the tests and models used (non-parametric tests, analysis of variance, multiple comparison tests, regressions, normalization, factor analysis and principal components, clusters...). Assistant director Feb. to Jun. 2016

Organizational optimization and development project officer Internship at RNPUR, Neuilly-sur-Seine (France)

• Performed and optimized the administrative, financial and human resources functions

• Documented, optimized and automated the management process

• Implemented a quality control system for operational activities. Accounting and finance assistant Mar. 2015 to Aug. 2016 Zen DZ Solution Conseil et gestion, Montreuil (France) (Includes non-contractual period)

• Documented and recording accounting transactions

• Performed accounts checking and bank reconciliations

• Prepared financial statements and performed financial analysis. OTHER EXPERIENCES

Tutor Jan. 2017 to Dec. 2018

Self-employed Contractor, Gatineau, Ottawa area

• Gave advanced statistics courses, helped performed data analysis with SPSS, EXCEL and MINITAB.

• Gave French courses, helped pass the written and oral exams of the Government of Canada School of Public Service.

Communication agent Oct. 2016 to Apr. 2017

Association of students in Project Management and in Administration of UQO (AEGPA- UQO)

• Organized events, conferences and professional meetings

• Drafted the management report justifying the interventions and the expenses of the executive committee

EDUCATION

Master’s degree in Project Management 2018

University of Quebec in Outaouais

Master's degree in Law, Economics and Management - Organizational Expert 2017 University Paris Nanterre

Bachelor of Economics - Management of Organizations 2016 Including a certificate in Computer Science

University Paris Nanterre

LICENCES & CERTIFICATIONS

Data Analisys with Python 2020

Coursera https://www.coursera.org/account/accomplishments/certificate/V8KTP5YV9JTJ Databases and SQL for Data Science 2020

Coursera https://www.coursera.org/account/accomplishments/verify/H6TTW3AUNMYE Python for Data Science and Artificial Intelligence 2019 Coursera https://www.coursera.org/account/accomplishments/verify/dfz4fq468bmu Data Science Methodology 2019

Coursera https://www.coursera.org/account/accomplishments/verify/YVXH7PVQJYKC Open Source tools for Data Science 2019

Coursera https://www.coursera.org/account/accomplishments/verify/XJTG4NE47U2P KNOWLEDGE OF COMPUTER TOOLS

Advanced mastery of: Excel (power pivot, power query), Power BI, Minitab, SPSS, SQL, Python, Access, MS Project, SharePoint, MS Dynamics 365 PSA, Jira, SAP Fieldglass, Ciel et Sage, PowerPoint, Word, Visio

Training: Tableau, Cognos, SAS, MATLAB and R

REFERENCES AND DIPLOMAS AVAILABLE ON REQUEST



Contact this candidate