Operating systems
FABIANO MARTINS
Finance Analyst
Toronto,ON
Summary
● Business Administrator experienced in financial planning, budgeting, and strategic analysis
● Bachelor’s Degree in Business Administration – BBA, Postgraduate Diploma in Strategic Account Management, Data Science and Business Analysis Certificate
● Experience in collecting data, preparing budgets, forecasting, analyzing results, monitoring variances, reconciling accounts, identifying trends, and providing insights to management
● Comprehensive financial modeling experience, including income statement, balance sheet, and cash flow
● Advanced software skills, primarily in Microsoft Excel, including design, look-ups functions, pivot tables, Power Pivots and macros, protection, drop-downs, and links
● In-depth knowledge of databases and financial management systems such as SAP, ERP (Oracle), Sysphera, MicroStrategy Business Intelligence, etc.
● A multi-tasker, with strong analytical and calculation skills, attention to detail and sensitive to the needs of employees on all levels
Overview
13
13
years of professional experience
6
6
years of post-secondary education
3
3
Languages
Work History
BUDGET CONSULTANT
Doctors Without Borders/Médecins Sans Frontières, MSF
Toronto
04.2020 - 11.2020
- Reinvented the Excel-based budgeting tool to meet MSF Canada’s needs
- Deliverables:
- Protected worksheets for unit and other budgets, incorporating the chart of accounts, 12-month cash flow forecasting, comparative period data, and dashboard
- Protected worksheet for unit FTE planning, incorporating the organization’s salary scale and dashboard
- Created a budget summary overview, a roll-up of all underlying budget worksheets, with dashboard
- Used a user-friendly extraction process for data from the budget worksheets, for import into Sage 300
- Imported function to budgets for comparative data from Sage extract of actual spending
CORPORATE FINANCIAL CONSULTANT
PSI Consulting
07.2016 - 08.2017
- Analyzed past results of five hospitals and performed variance and forecast analysis, identified trends, and made recommendations for optimizations
- Supported the assessment of corporate development plans, multi-year plans, and growth opportunities through modeling and scenario analyses
- Developed customized financial plans, and budgets according to the hospitals' needs
- Worked across all levels of the organizations to provide strategic information to business stakeholders
- Prepared financial presentations and results updates for stakeholders highlighting key findings
BUSINESS & FINANCIAL ANALYST
UNIMED Health Insurance, National Confederation of Medical Cooperatives
03.2016 - 07.2017
- Worked closely with department managers to ensure accurate financial reporting and decision support
- Worked closely with the Finance, Payroll, IT and Accounting teams to develop and implement software to support the annual budgeting and periodic forecasting process across the organization
- Responsible for monthly, quarterly, and bi-annual reporting and updates on key functional KPI, variance analysis, budget/forecast against actual financial performance
- Entered financial data into management systems such as ERP and SAP and created ad-hoc reports, and Excel dashboards
- Reviewed all materials and purchase requisitions for availability of funds
BUSINESS & FINANCIAL ANALYST
Hospital Mae de Deus
06.2005 - 12.2014
- Responsible for the annual budget and bi-annual and annual reforecast development to capture and consolidate the financial impact of nine hospitals
- Supported the transition of the budget planning to a new system and developed a training video for managers and directors to learn strategic planning on a specific software
- Developed automated reporting/forecasting tools/dashboards, trend and variance analyses and sensitivity tests
- Recommended actions by analyzing and interpreting data and making comparative/statistical analyses
- Worked closely with the financial team in tracking and reporting the cash and business management strategies
- Responsible for planning and directing the strategic and long-term objectives of the hospital together with the management team
- Conducted organizational analysis to identify action plans and related metrics, as well as assess operational effectiveness
Education
Bachelor’s Degree - Business Administration
University of the Rio dos Sinos Valley
03.2006 - 12.2011
Bachelor’s degree - undefined
World Education Services
Accounting & Bookkeeping, Certificate - undefined
01.2018 - 03.2018
Data Science, Certificate - undefined
Toronto District School Board
07.2019 - 09.2019
Business Analyst, Certificate - undefined
University of Toronto
09.2019 - 12.2019
Data Science: Visualization, Certificate February 2021 – March 2021 - undefined
Skills
Business Administrator experienced in financial planning, budgeting, and strategic analysisBachelor’s Degree in Business Administration – BBA, Postgraduate Diploma in Strategic Account Management, Data Science and Business Analysis CertificateOver 10 years of experience collecting data, preparing budgets, forecasting, analyzing results, monitoring variances, reconciling accounts, identifying trends, and providing insights to managementComprehensive financial modeling experience, including income statement, balance sheet, and cash flowAdvanced software skills, primarily in Microsoft Excel, including design, look-ups functions, pivot tables, Power Pivots and macros, protection, drop-downs, and linksIn-depth knowledge of databases and financial management systems such as SAP, ERP (Oracle), Sysphera, MicroStrategy Business Intelligence, etcA multi-tasker, with strong analytical and calculation skills, attention to detail and sensitive to the needs of employees on all levels
Accomplishments
•I developed a system that modified nurse shifts; at the time I was working in HR.
•By changing some ules and implementing biometrics, I was able to save the hospital around $600,000 (six hundred thousands) in overtime per year.
•More recently, at Doctors without Borders, the budget template I created reduced the amount of work by 2 days per month.
Software
Operating systems
Social media
Cybersecurity
Computer programming
Windows
MacOS
Microsoft Office
Word
PowerPoint
Excel
Outlook
Training
Google Slide
Tableau
Skype
Zoom
Teams
QuickBooks
ERP
SAP
MicroStrategy
Business Intelligence
Sysphera
Python
Oracle
Interests
Planning officer
Budget manager
Business analyst
Planning assistant
Financial controller
Financial planner
Strategic advisor
Budget controller
Business Planning
Financial Analyst
Financial Report
Timeline
BUDGET CONSULTANT
Doctors Without Borders/Médecins Sans Frontières, MSF
04.2020 - 11.2020
Business Analyst, Certificate - undefined
University of Toronto
09.2019 - 12.2019
Data Science, Certificate - undefined
Toronto District School Board
07.2019 - 09.2019
Accounting & Bookkeeping, Certificate - undefined
01.2018 - 03.2018
CORPORATE FINANCIAL CONSULTANT
PSI Consulting
07.2016 - 08.2017
BUSINESS & FINANCIAL ANALYST
UNIMED Health Insurance, National Confederation of Medical Cooperatives
03.2016 - 07.2017
Bachelor’s Degree - Business Administration
University of the Rio dos Sinos Valley
03.2006 - 12.2011
BUSINESS & FINANCIAL ANALYST
Hospital Mae de Deus
06.2005 - 12.2014
Bachelor’s degree - undefined
World Education Services