Paul Crane Email & Phone Number

Alpharetta, Ga, Us

Birmingham, Alabama, Us

Peachtree Corners, Ga, Us

Brightree is a SaaS and revenue cycle management division of ResMed, a $3.0B medical device manufacturer.Designed and implemented the new chart of accounts in NetSuite, transforming from an account and subsidiary driven chart of accounts to one based on attributes. Reduced the number of accounts by 75% while significantly improving reporting ability to revolve around attributes such as business units, acquisitions, and products as opposed to legal entities. Implemented Anaplan, a cloud-based enterprise FP&A tool.Implemented and developed reporting in Solution7, an Excel add-in similar to Hyperion Essbase, automating our month-end close reporting to load into Oracle, saving 8+ hours during the 4 day close.Manage the rolling forecast and annual budget, as well as all financial reporting. Have participated in the due diligence and closed on eight acquisitions over seven years.Recruited a team of four to supervise - one manager and three analysts.Oversee FP&A and financial reporting as company has grown in revenues from $80M to $200M, with double digit organic revenue growth each year in addition to multiple acquisitions. The FP&A team is diverse in areas of strategic long-term growth, partnering with business leaders, and working heavily in our detailed and robust financial models that provides all forecasting and financial reporting in a streamlined and efficient manner.Interact daily with CEO on updates to company financials and KPIs. Collaborate routinely with executive management on business unit financials. Model and perform due diligence on potential M&A opportunities. Manage internal financial reporting to business units and to the ResMed parent.Well versed in ASC606 and the company's SaaS revenue recognition.

Peachtree Corners, Ga, Us

Heavily involved in the $800 million acquisition by ResMed. Worked with the CFO and investment banking firm to package the company Teaser, CIM, and Management Presentations to potential investors. Sat on due diligence calls to answer questions related to the company financials and discuss assumptions of the Brightree Financial Model. Financial model was praised by private equity firms, as well as Deloitte and PWC, as a financial model desired all of their targets would have.Developed and maintain the company's robust financial model, forecasting the firm's financial and KPI metrics. The financial model built in Excel streamlines all operational KPIs, as well as allowing sales & operational drivers / variables to provide financial scenarios for strategic decision making by executive management. Model is used daily by the CEO and CFO.Streamlined reporting decks and presentations to automatically update upon financial close. This process reduced time from one day to ten minutes.Manage internal financial reporting to business units and to the ResMed parent. Wrote the MD&A for Wells Fargo and external reporting to Battery Ventures prior to acquisition.Forecast company's financials for all five business units, as well as the consolidated P&L, Balance Sheet, and Cash Flows.Generated FY17 and FY18 budgets that had revenue variance to actual of 0.1% and 0.003% respectively. Gross profit variances within 1% for both years. Supervise two Sr. Financial analysts.

Peachtree Corners, Ga, Us

Hired as the first FP&A employee, with primary duties to manage the rolling forecast.Developed the company's robust financial model, including its first forecasted Balance Sheet and Cash Flow Statement.Worked with department heads in implementing the company budgets, for all revenue streams and expense departments, as well as the company consolidation.Streamlined the financial and KPI reporting process from multiple files to one single document. Designed and developed financial models so all key drivers roll into the financial forecast, KPI reporting, and Board of Directors Financial Reporting for both actuals and forecast.Provided the pro forma for a consolidated forecast that included multiple acquisition scenarios, including the successful acquisitions of MedAct and Strategic AR. Forecasted an estimated purchase price acquisition that flowed through the Balance Sheet.Took the initiative to create a revenue by customer report, dating back to 2008, that details 3,000 customers and what each customer's revenue by month has been for each of our ten products. This report led to a cohort analysis; a new process of tracking new bookings and ensuring new sales delivers to revenue, as well as assisting our Sales team with a new white space project.Lead project with Sales and Professional Services teams to track revenue by customer from Sales through full implementation. Discovered nearly $1 million of unbilled annual revenue.Streamlined the monthly financial reporting process from manual data entry to calculating off an export from QuickBooks. Financial statements roll up to the consolidated P&L.Assisting in the transition and implementation from Quickbooks to NetSuite. Developed customized P&L and Balance Sheet reports in NetSuite for accounting.Wrote query reports in SalesForce for KPI reporting.

Lexington, Ma, Us

$30M revenue marketing company specializing in customer loyalty programs through credit card rewards. Acquired by Ebates in 2017.Budget and forecast revenue for National In-store, Local In-store, and Online business units. Manage finances for Local unit. Analyze KPI metrics including attrition and merchant yield. Design robust financial models for multiple what-if scenarios and present to executive team.Designed company-wide P&L models for budgets, forecasts, and variance analysis. Interact with department heads throughout company to plan and forecast company expenses.Took the initiative to develop a GL database in Access that interacts with Excel to streamline actual results for P&L reporting.Produce monthly and weekly financial reports. Prepare quarterly board slides. Interact daily with upper and executive management, as well as account management, sales, and client services.Ad-hoc financial analysis on daily basis. Perform ongoing sensitivity analysis with multiple variables that impact revenue and expenses.Due diligence reporting for prospective and existing investors.

$25M revenue healthcare services company specializing in workers’ compensation and auto accident claims. Parent company is Healthcare Solutions.Analyze workers compensation pharmaceutical claims. Improving processes for weekly and monthly reporting.Automated monthly financial and metrics report for Pharmacy division using ODBC connections, as well as intense SQL and Excel formulas. Reduced 6 hour manual process to click of a button.Streamlined bi-weekly report of Paper Bill revenue A/RAutomated weekly report correlating patient distribution cards and revenue for important client.

Atlanta, Ga, Us

$300M revenue marketing company in the housing industry. Brands included Apartment Guide, Rentals.com, and New Homes. Publicly held until 2011 as Primedia and is currently branded as RentPath.Develop and analyze financial metrics and key performance indicators for financial management and C-level executives. Develop complex Excel models and Access databases, including budgets and forecasts, and key metrics for quarterly 10K reporting. Improve process of gathering and reporting internal and external financial data. Consolidate and analyze large data sets.Developed financial models for the Financial Planning & Analysis group including P&L for Forecasts and Budgets, Variance Analysis, profitability reports, and other ad-hoc reports.Redesigned and developed all financial models for new Chart of Accounts.Redesigned and developed Market Profitability Report for CEO.Developed and gather Metrics report for majority stock holder KKR, containing key performance indicators and financial metrics at corporate and divisional levels.Redesigned, developed, and used VBA to consolidate all 306 company P&L budgets at company and divisional levels, improving model to be robust and replicate more efficiently.Designed, developed, and monitor CAPEX database and Fixed Assets system.Budgeted 2011 benefits allocation for all cost-centers.Generate quarterly and annual external reporting data, including 10Q / 10K. Review 10Q and 10K reports. Gather and file Census reports for US Department of Commerce.Generate monthly and quarterly internal reports including key business metrics, P&L, and variance analysis. Improved the process of gathering and verifying these metrics.Maintain and update MS Access databases, linking to Platinum and Excel models.Lead analyst for Business Continuity Plan.Document financial processes to maintain SOX compliance.

Atlanta, Ga, Us

Consultant in Supply Chain Management. Designed company Warehouse Management Systems (WMS) software to adapt to client needs. Lead project team for client support upon implementation of product at Kohls Department Stores E-Commerce site. Design and tested modification specifications for Amerisource Bergen pharmaceuticals. Tested mod specs for multiple clients. Developed and tested XML documents to test new company Integration Framework software.Developed a spreadsheet model to save weeks of manual input when converting data files to our new SharePoint system.Developed spreadsheet models and macros to save days of manual input when creating and updating thousands of SQL statements.

Notable Excel and Access Projects Design and Developed:SonicWall: Designed and developed a telecommuting and savings calculator for website used for the Great Britain office, which was published in Yahoo! Finance.EnablePath: I was the third party to develop an Excel Report analyzing SalesForce data. Accomplished this with VBA macros and Pivot Tables.DotDot Interactive: Developed accounting, payroll, record keeping, and taxes – similar to Quicken and Turbo Tax. All payroll calculations abide to Circular E (Employers Tax Guide). Southern Company Services: VBA: Automated and designed conversion of multiple power plant budgets. Developed a user interface and model for calculating annual energy and peak forecastsTai Ping Carpets: Developed database and forecasting model with graphical user-interface (GUI) for all projects.ACS Air Conditioning: Design and developed a GUI and database to keep track of leads and sales for all products and salesmen, as well as generating summarized reports, using VBAEWMS: Designed and developed GUI, master database, statistics, and calculator for time study analysis of employee equipment On and Off times, which are subpoenaed in large company law suits. This single database saves hundreds of files and a month of calculating statistics. Other: Designed and developed a user interface and database for a personal budget to keep track of income, expenses, credit cards, bills, taxes, assets, bank accounts, and other financesMay 2007 - December 2012

Bookkeeper and generate the taxes for the LLC that provides web design and photographer consulting services. May 2007 - April 2015.

Auburn, Al, Us

Math and Science Tutor for the Auburn University Athletic Department.Tutored mostly in Calculus I. Also tutored Pre-Calculus, Calculus II, and Chemistry.

Atlanta, Ga, Us

Worked in Generation Planning & Development for the largest generation of power company in the southeast. Automated and reformatted 300+ power plant budgets, saving 3 months of manual labor. Lead a team in the design and development or automating and reformatting annual energy and peak forecasts. This saves 3 weeks of manual labor a year and improved a model that had 2% user error to 0% user error. Gained valuable financial knowledge through daily collaboration with finance experts.Developed intense spreadsheet models with Visual Basic.

Armonk, New York, Ny, Us

Improved performance by implementing time saving data entry initiatives. Designed and updated training manual for new employees.Focused in the Quality Audit and Testing of Circuit boards. Developed macros within AS/400 system.

Master Of Business Administration (M.B.A.), Finance

Bachelor, Industrial & Systems Engineering