Financial Analyst Management

Peter Cailotto, MBA

*** ****** *****

Brentwood, CA 94513

Cell: 925-***-****

****.********@*****.***

17+ years of experience in analyzing data, forecasting results, and developing financial models. Strong budgeting, financial management and systems skills. Excellent use of VBA, SQL, pivot tables and other complex functions in software programs to develop financial models, reports, and forecasts.

Accounting and Finance and Programming Skills

●Accounting Management

●Financial Analysis

●Forecasting

●Modeling

●Macros

●Cash Management

●Budgeting

●Cost Reductions

●SQL Programming

●Reconciliations Control

●Monthly/Qrtrly/YE Close

●GAAP Financial Reporting

●Royalty/Commissions administration

●Payroll Administration

Software and systems competencies: MS – Excel, MS – Word, MS – Power Point, MS –Outlook, MS –SQL Server Management Studio and Reporting Services, MS – Visio, MS – Access, Crystal Reports, Lotus Notes, SAP FI/CO, ACCPAC Sage Pro, Adobe PDF 9.0, Lawson, Quick books, Sedona Office ERP, Oracle, ADP,Kronos, Insight

Work Experience and Achievements

Aramark Food Services at California State University East Bay Hayward, CA

Unit Controller 11-2016 to 8-2017

Processed weekly and monthly close for Dining Commons and Retail Food Service locations. Input actual data into Insight and explained weekly variances.

Oversaw local Accounting team for processing of Payroll, Accounts Receivable, Accounts Payable and Cash Processing. Reviewed aging reports, daily cash and weekly payroll for problem areas and discussed areas of concern with team.

The Alarm Guys, Inc. Brentwood, CA

Controller 10-2014 to 10-2016

Created Commissions system in reporting services to automate weekly commissions processing. As a result, commissions paid were timely and accurate.

Migrated data from Quick books to new ERP system. Created new processes to handle commission’s deductions and improved financial reporting.

University Healthcare Alliance Richmond, CA

Senior Accountant 7-2013 to 10-2014

Produced models to help automate Physician Service Agreement base compensation and IBNR monthly Journal entry. Improved documentation for monthly close entries and processes. Monthly journal entries were produced in a timely and accurate manner with proper documentation.

Reconciled fixed asset accounts to depreciation schedules. Fixed assets were properly identified and depreciated on a monthly basis.

Controlled and monitored monthly Capitation and Sub Capitation payments.

Produced reporting for UHA’s DMHC filings.

Humana (Formerly Arcadian Health Plan until March 2012) Oakland, CA

Financial Analyst 2009 – to June 2013

Assisted in financial integration of Arcadian Health plan group of companies into Humana Oracle financials. Provided coding for premiums, capitated expenses and claims payments as well as reporting and analysis of after close results for the Humana market structure. This achieved Arcadian Health Plan becoming completely integrated and transitioned into Humana Health Plans.

Marshaled reports for markets and risk pools showing results of MCR, CCR,

PCR and PMPM cost for institutional, professional, and ancillary groupings and related subgroupings. Areas of concern for rising costs were identified and controlled.

Worked with actuary to assist in production of bid process.

Cinder Block, Inc. Oakland, CA

Controller/Accounting Manager 2007 – 2009

●Set up annual budget in system for multiple companies. Created groups and helped drive reporting process for activity based costing within product channels. Accordingly, deviations from plan were addressed and resolved.

Farmers Insurance Pleasanton, CA

Financial Analyst/Research Analyst

Accounting Supervisor/Claims Adjuster 1998-2007

●Provided reports to Marketing, Underwriting and Product Management to assist in profitability management for regions and market areas they control. Tackled system cancellation issues resulting in improved acceptance percentages of over 10%.

●Generated profit and loss reports for exchanges and showed combined ratio and surplus results for business unit at a district level using pivot tables in Excel. Reported results to District Marketing Managers, Portfolio Underwriters, and other appropriate personnel. As a consequence, key drivers of results were addressed and controlled.

Took over agent premium deposit accounts and worked with Accounting Technicians to control and resolve outstanding items. Outstanding items were cut by 50%+, as well as resulting dollar volume. Aged out-of-balances were identified and controlled.

Education

MBA in Management, Golden Gate University

BBA in Business Administration, University of San Diego

Accounting Certificate (30 Unit), Golden Gate University

Six Sigma Green Belt, Toastmasters – Advanced

Communicator Bronze

Contact this candidate