Brent Allen Email and Phone Number
Brent Allen work email
- Valid
- Valid
Brent Allen personal email
Brent Allen phone numbers
I have been a financial analyst for over 10 years, and have worked across multiple industries, including real estate, quick serve restaurants, technology and banking. While there are little common elements between the industries, I have been able to improve the way that we report our numbers in every role that I've been in.While I possess high level Excel skills, including VBA macros and pivot tables, I have also developed experience in data visualization; my more recent projects have required use of SQL and Power Pivot to represent larger data sets for audiences ranging from front line managers to executives.
Hoopp (Healthcare Of Ontario Pension Plan)
View-
Senior Business AnalystHoopp (Healthcare Of Ontario Pension Plan) Oct 2020 - PresentToronto, On, Ca- Led a system migration migration to a new Private Equity transparency platform impacting multiple key stakeholders including risk management, investment management and technology infrastructure.- Performed key report reconciliations to enable migration from the Private I system to the Investran system for the Private Equity team.- Developed a new process to eliminate manual month-end entries and enhance reconciliation between the Investran sub-ledger system and Oracle financials.- Designed and implemented new data flows in SAP HANA to enable business intelligence reporting in Tableau for real estate and private equity teams.
-
Course AuthorPluralsight Mar 2020 - PresentDraper, Ut, UsAuthored 4 courses on the Pluralsight platform:- Financial Analysis in Excel- Automating Excel using Office Scripts- Create Measures using DAX with Power BI- Modeling in DAX with Power BI -
Accounting ManagerYm Inc. Nov 2019 - Jan 2020Ca• Migrated transactions for 2019 from QuickBooks to Yardi Breeze.• Developed processes to enable automated accurate calculation of monthly recoverable amounts by property.• Documented processes for recovery reconciliation and application of credit payments to tenants. -
Business AnalystBentallgreenoak Dec 2016 - Oct 2019New York, New York, Us• Led a systems consolidation project, retiring 1 redundant ERP system and 2 redundant business intelligence platforms with estimated savings of over $500,000 USD per annum.• Implemented a company-wide update from Argus DCF to Argus Enterprise 11.6 in conjunction with the end of life of the Argus DCF product.• Developed new business intelligence reporting capabilities in a Microsoft Excel dashboard leveraging US financial information from the MRI database.• Developed business requirements documents for implementation of new business intelligence capabilities in Qlik Sense.• Managed 85 users of Argus Enterprise, serving as primary point of contact for user technical and modeling concerns as well as communication with the vendor. -
Senior Analyst, Dream Industrial ReitDream Unlimited Sep 2014 - Oct 2016Toronto, Ontario, Ca• Responsible for the development and execution of a new budgeting system for 2017, including capital expenditure tracking and net operating income forecasting.• Created new reports for tracking key profitability and tenant retention metrics for an executive and leasing manager level.• Led monthly national calls with leasing managers, portfolio managers and our executive team.• Developed strategies to present to executives regarding investment or disposition of non-core assets in the Industrial portfolio.• Prepared quarterly valuations for IFRS purposes for a 220 property portfolio. -
Lead Financial AnalystMetrus Properties Jan 2012 - Sep 2014• Acted as a leader for the 10 person Accounting team, providing support on complex technical and accounting related issues.• Led full system conversion from Yardi Gemini to Yardi Voyager 7, including general ledger, lease and tenant information and customer / supplier data.• Prepared year end working papers for external auditors with respect to a variety of properties including multi-tenant shopping centers, industrial locations and land leases.• Provided key schedules for external auditors, including straight line rent, deferred asset leasing amortization and building soft cost classification.• Continued improvement of the Yardi Voyager system, adding new functions such as tenant and joint venture subledgers and automatic management fee billing.• Developed new automated tools in SQL and Microsoft Excel to enhance Yardi Voyager, such as automating recovery journal entries and general ledger / subledger reconciliations.
-
Senior Financial Analyst, Corporate StoresMcdonald'S Restaurants Of Canada Limited Apr 2010 - Dec 2011Chicago, Illinois, Us• Created the 2011 and 2012 annual store budgets for over 300 corporate owned restaurants with over $900 million in sales using the aid of key subject matter experts.• Developed monthly projections and month end reconciliations for food costs based on inputs from subject matter experts in marketing, supply chain and business intelligence groups.• Worked with regional managers and directors to establish quarterly sales and profitability targets based in trends in revenue and key expenses.• Verified accuracy of key metrics and distributed the monthly balanced scorecard to store managers, regional managers and vice-presidents.• Provided key financial metrics including free cash flow and future capital spending to senior executives for determining the viability of new market expansion and existing market divestiture. -
Senior Financial Analyst, Ontario RegionMcdonald'S Restaurants Of Canada Limited Apr 2009 - Apr 2010Chicago, Illinois, Us• Performed variance analysis on operational cash flow to determine optimal payout for subsidies to franchisees.• Used capital budgeting techniques including NPV, IRR and residual cash flow analysis to determine the feasibility of major capital investment, including opening new stores, closing existing stores or company funded renovations.• Provided financial support for a cross-functional team responsible for new store concepts in Wal-Mart McDonald’s locations.• Developed quarterly reports for senior management to present to national operators detailing impacts of cost changes in key financial metrics such as food and labour costs.
-
Pricing AnalystSoftchoice Oct 2007 - Apr 2009Toronto, Ontario, Ca• Developed a new database to provide a balanced scorecard for customer pricing decisions.• Implemented optimal pricing levels for key customers on request from sales managers and directors.• Researched competitors pricing levels and made recommendations for default pricing levels for strategic product categories and vendors.• Enhanced reports to include sales and profit volumes, accounts receivable and discounting trends.• Documented new procedures and data sets in order to improve training for future pricing analysts.• Automated weekly and monthly reports, saving 1 hour of weekly manual processing, and 3 hours of monthly manual processing.
Brent Allen Skills
Brent Allen Education Details
-
Chartered Professional Accountants Of Canada (Cpa Canada)Certified Professional Accountant -
Chartered Professional Accountants Of Canada (Cpa Canada)Certified Management Accountant
-
Smith School Of Business At Queen'S UniversityBusiness Admin.
-
Wilfrid Laurier UniversityBusiness
Frequently Asked Questions about Brent Allen
What company does Brent Allen work for?
Brent Allen works for Hoopp (Healthcare Of Ontario Pension Plan)
What is Brent Allen's role at the current company?
Brent Allen's current role is Senior Business Analyst at HOOPP (Healthcare of Ontario Pension Plan).
What is Brent Allen's email address?
Brent Allen's email address is br****@****ers.com
What is Brent Allen's direct phone number?
Brent Allen's direct phone number is +141647*****
What schools did Brent Allen attend?
Brent Allen attended Chartered Professional Accountants Of Canada (Cpa Canada), Chartered Professional Accountants Of Canada (Cpa Canada), Smith School Of Business At Queen's University, Wilfrid Laurier University.
What are some of Brent Allen's interests?
Brent Allen has interest in Science And Technology, Education.
What skills is Brent Allen known for?
Brent Allen has skills like Budgets, Microsoft Excel, Variance Analysis, Finance, Vba, Access, Strategy, Forecasting, Analysis, Excel, Cross Functional Team Leadership, Strategic Planning.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial