


Brian A. Schwarztrauber
Professional Summary
Accounting and Financial professional with 30+ years of experience in both public and private organizations, managing the month-end close, ensuring GAAP compliance and supervised audits as an Accounting Manager and Controller. Extensive history of process improvements and financial analysis to provide key insights to the senior management team.
Areas of Specialization
-
General Ledger Accounting (closing/analysis/reconciliation)
-
Financial Statement Preparation
-
Ensure GAAP Compliance
-
Audit/Payroll Reconciliation
-
Integration of Accounting Systems
-
Managing Process Improvement
-
Reconciliation to Sub-ledgers
-
Budgeting & Forecasting
-
Financial Analysis
-
Implementing new or upgrading Financial Application Software
Industry Experience
-
Manufacturing
-
Construction
-
Start-up Organizations
-
Healthcare
-
Professional Services
-
BioTech
-
Food and Beverage
-
Renewable Energy
Technology Expertise
-
QuickBooks Pro Advisor
-
Oracle 11i & R12, & NetSuite
-
MS Dynamics AX, Great Plains & Solomon
-
PeopleSoft
-
Excel4Apps
-
Crystal Reports
-
FRx
-
MS Excel
Organizations Served
-
Thrive Skilled Pediatric Care
-
Curis, Inc.
-
Corporate Chefs
-
Ogin, Inc.
-
CDM Smith
-
IEP Technologies
-
Ameresco, Inc.
-
Athena Health Care Systems
-
SunLife Financial
-
Visiting Nurses Assoc. of Boston
-
Saint Vincent
-
Mercury Media
-
Partners Health/Mass. General
-
Exiqon, Inc.
-
Vertex Pharmaceuticals
-
Iron Mountain, Inc.
-
Enanta Pharmaceuticals
-
Serono, Inc. Neurology
-
New England Gourmet Provisions, LLC
-
Krumm Exteriors, LLC
Education
-
BS/BA – Boston University,
cum laude; Concentrations in Finance & Marketing
Professional Work Summary
General Ledger Accounting (Month-end Close) and Audit
-
Received clean audit reviews from Deloitte and Touche, and PwC
-
Supervised accounts payable and accounts receivable personnel
-
Decreased the month-end close process by 3 days with process improvements
-
Improved Month-end Journal Entry Process for Web Time Billing by 4 days
-
Processed and reconciled payroll, prepaids, accruals, debt financing, revenue, and inventory
-
Responsible for GAAP compliant journal entries and general ledger review and reconciliation of prepaid and accrual accounts going back 7 years
-
Responsible for all aspects of payroll, and consolidated US Benefits with a Broker to reduce costs and increase efficiency
-
Setup Canadian payroll, benefits, and RRSP {401K equivalent} for a USA based firm
-
Created & reviewed month-end accruals for project-based activity, including Contract Research Organizations (CRO’s), Chemistry, Manufacturing, and Controls (CMC) for drug candidates
Financial Analysis
-
Responsible for monthly financial reporting: P&L, cash flow, forecasting, & budgeting
-
Separated Total Sun Life Financial (SLF) Expenses ($660M) into Delaware Life Holdings and SLF by business unit, major product, and cost center, and recalculated all allocations
-
Built ‘dates of service’ analysis by month to better understand current month billings, drops and rebills for a clinical home care company by location and entity
-
Learned multiple healthcare billing programs to create multi-location and entities waterfall cash to revenue streams supporting annual audit, understand % of collections & acquisition bad debt
-
Built multi-location and entity A/R roll forward
-
Enabled a clean 403(b) Plan Audit by reconciling over 250 participants correcting years of service, EE deferrals and ER matches for the 2013
-
Prepared consolidations: P&L, Balance Sheet, Cash Flow of 4 Separate Business Units and the wrote the monthly Board of Directors Analysis Memo
-
Managed & recalculated state tax audit that covered 1999-2003 reducing exposure by over $60K
-
Maintained monthly & quarterly fiscal & calendar year balance sheet, income & cash flow statements
-
Developed and updated FRx profit & loss statements, actual to budget variance analysis to the project level.In addition, rewrote Solomon Crystal reports as necessary
-
Created the analysis & reconciliation of $60M Budget for Enterprise Services
-
Created North America Operations (NAO) Financials via Line of Business and Territory & Area Consolidated via Excel from Oracle, which produced management reports driving the month-end financial review process
-
Project based multi-product Gross Margin Analysis
Financial Budgeting and Forecasting
-
Created full P&L and balance sheet 5 year budget using both top down and bottoms up approach
-
Designed and maintained forecasting system to track pre-clinical, clinical, pharmaceutical development, and drug manufacturing for month-end accruals and analysis
Business Process Improvement and System Implementation
-
Built Cash Flow Statement with Excel4Apps (Oracle R12) with International legal entities in local currency simplifying a very arduous process reducing 4 days off of the process
-
Trained multiple people in Month-end accounting, procedures, MS Excel, Oracle & MS Dynamics Great Plains
-
Responsible for and managed IT conversion from QuickBooks to MS Dynamics AX, included Production/Manufacturing
-
Supervised Solomon upgrade, and custom module for allocating costs to the department & projects
-
Created monthly North American Operations Financial Review and Financial Summary
-
Developed line item and rollup spending trend analysis to better understand monthly burn rate, and key cost drivers