Philip Niedzwiadek

Philip Niedzwiadek

Financial Planning & Analysis @

The Conference Board of Canada

Background

A Designated Accountant seeking data driven solutions for operational financial performance optimization with competencies in, but not limited to, Excel, SQL and Python. I’m enthusiastic about the potential for a digital future of money where accounting is a multi-disciplinary field built on blockchain and distributed ledger technology.

Interests
  • Data Analysis & Modeling
  • Financial Performance Optimization
  • Data Visualization & Dashboarding
  • Blockchain, Cryptoassets & On-chain Analysis
Education
  • Chartered Professional Accountant, 2020

    Chartered Professional Accountants of Ontario

  • BCom, Accounting, 2015

    Carleton University

Skills

Python
SQL
Advanced Excel
Finacial Reporting & Analysis
Performance Management
Blockchain

Currently Learning…

Data Analysis
Dashboards
Excel VBA
Statisics
R
Solidity

Experience

 
 
 
 
 
Virtual Chief Financial Officer
Jun 2021 – Present Ottawa, ON

Responsibilities include, but are not limited to:

  • Overseeing and making all adjusting entries and corrections to the bookkeeping records
  • Preparation and analysis of amortization, prepaid and accrued expense entries
  • Preparation of monthly financial analysis to determine job profitability, and preparation of internal financial statement packages for owners to analyze variances and forecast discrepanciess
  • Preparation and subsequent correspondence with the Public Accounting firm regarding fiscal year end preparation
  • Coordination with owners to prepare an annual budget each fiscal year
  • Providing ad-hoc accounting and financial advice
  • Lead the setup of new financial projects, procedures and/or financial reports, when necessary
 
 
 
 
 
Senior Financial Analyst / Systems Analyst
Apr 2021 – Present Ottawa, ON

In addition to the duties from my prior position, I am also tasked with:

  • Creating regular revenue reporting to show profits and losses over each period
  • Analyzing financial data to find trends and patterns among current and pipeline research contracts to determine where new strategies should be implemented to increase profits
  • Meeting with department heads and organization executives to plan strategies and brainstorm ideas to manage revenue maximization, expense reduction, and to deliver overall better customer content and experiences
  • Executing organizational strategies and values regarding daily operations and long-term strategic operations
  • Leveraging existing data and correspondence with management to create forecasts portraying projected revenues and associated research labour hours
  • Using my prior public account experience to recognize federal, provincial and local tax and accounting compliance matters
 
 
 
 
 
Systems Analyst / Corporate Financial Analyst
Jul 2019 – Present Ottawa, ON

Responsibilities include:

  • Prepare yearly budget, monthly forecasts and cash flow analyses for the corporate departments then following up monthly with financial reports, variance analyses and a review of KPIs; monthly risk and scenario analyses were included after the COVID-19 outbreak
  • Supporting financial month end and year end audits by validating departments’ monthly closure by creating and reviewing entries (accruals, adjustments and fixed asset depreciation) and preparing account reconciliation on a monthly basis for specific accounts
  • Closing out our Niagara satellite office in the wake of the COVID-19 economic downturn by recognizing remaining project revenues, resolving remaining liabilities, reconciling deferred revenues, writing-off remaining assets and coordinating delivery of remaining records and assets back to the Ottawa head office
  • Lead the weekly integration of ERP (MS D365) and CRM systems (iMIS) and troubleshoot integration errors
  • Leading my team in requirements gathering for a new CRM system and Financial Planning and Analysis (FP&A) tool, and currently leading the implementation for the FP&A tool
  • Test and validate MS D365 improvements in the testing environments and ensure that they have been transferred to production successfully
  • Assist in leading the finance team in executing the semi-annual MS D365 Finance & Operations ERP upgrade
  • Identify issues and implement improvements to streamline accounting processes, leading to system design changes
 
 
 
 
 
Senior Staff Accountant
Jul 2016 – Jun 2019 Ottawa, ON

Responsibilities included:

  • Apply a general knowledge of Canadian GAAP (ASPE & ASNFPO)
  • Using Caseware to complete notice to reader compliance engagements, review engagements and audit engagements from start to finish
  • Reconciling accounts in every accounting cycle, correcting errors and misstatements, and following up with clients of discrepancies
  • Completing personal, corporate and sales tax returns, and maintaining and referencing the working paper files
  • Performing management inquiry, analytical procedures, and a variety of audit testing for review and audit engagements
  • Peer coaching sessions for completion for notice to reader engagements, corporate tax filing and personal tax filing
 
 
 
 
 
Bookkeeper
Jun 2016 – Dec 2016 Ottawa, ON

Responsibilities included:

  • Reconcile and post journal entries for daily sales and bank deposits in Sage accounting software
  • Researching and complying to CRA sales tax regulations to thereafter calculate and file HST/GST and QST returns
  • Performing bank reconciliations using Sage accounting software and following up on any discrepancies
  • Keeping well organized electronic and physical records for future financial audits
 
 
 
 
 
Treasurer of the Board of Directors
May 2015 – Aug 2016 Ottawa, ON

Responsibilities included:

  • Chairing the finance committee, which includes creating an annual budget, implementing cost savings and surplus generating initiatives, and evaluating the effectiveness of internal controls
  • Acting as a signing authority for any payments and fixed income market investments
  • Using QuickBooks to perform accounts payable, accounts receivable and payroll functions, and reports to inform the Board at each meeting on finance related matters
  • Representing the Corporation to the auditors, bookkeepers, banks, lawyers and any other financial resources
  • Filing all relevant documentation with Corporations Canada to attain a Non-for-Profit Organization status; this includes making changes to the By-Laws and the Constitution then presenting them to the Board for approval
 
 
 
 
 
Compliance Officer
May 2013 – Aug 2014 Ottawa, ON

Responsibilities included:

  • Educate the taxpayer through a service oriented rehabilitative approach in order to obtain good filing and payment habits in the future
  • Arrange for the filing of any outstanding GST return(s) and obtain payment in full of any outstanding or anticipated balances
  • Recognize accounts requiring complex actions and referring these accounts to the appropriate Tax Services Office or National Pool
  • Provide information about the taxpayers’ responsibilities
 
 
 
 
 
Head Lifeguard / Swim & Lifesaving Instructor
Sep 2008 – Sep 2018 Ottawa, ON

Responsibilities included:

  • Supervisor on shift; responsible for overseeing up to six lifeguards or instructors
  • Responsible for teaching all ages water safety, swimming, diving, lifesaving, first aid, and aqua fitness
  • Ensuring that all safety standards are followed, solving administrative problems, addressing client concerns and complaints, and mentoring and training new inexperienced employees
  • Processing regular admission payments and registrations; documenting the float balance at the beginning and ending of each shift
  • Team leader; emphasis on strong teamwork and leadership skills in a high stress environment

Accomplish­ments

Blockchain Fundamentals Certificate
See certificate
Analyze Financial Data with Python Skill Path
See certificate
How to Analyze Business Metrics with SQL Course
See certificate
Analyze Data with SQL Skill Path
See certificate
Build a Website with HTML, CSS, and Github Pages Skill Path
See certificate
Learn Bootstrap Course
See certificate
Learn HTML Course
See certificate
Learn Data Analysis with Pandas Course
See certificate
Learn Statistics with Python Course
See certificate
Learn Python 3 Course
See certificate
Learn the Command Line Course
See certificate
Chartered Professional Accountant (CPA)
See certificate
Bloomberg Essential Market Sector Exams - Commodity Essentials
See certificate
Bloomberg Essential Market Sector Exams - Equity Essentials
See certificate
Bloomberg Essential Market Sector Exams - Foreign Exchange Essentials
See certificate

Projects

First Website Attempt

First Website Attempt

Used limited knowledge of CSS and HTML to build first website which was then used for web scraping and crawling projects

Contact