Robert J Kerwin, CPA.

***** ********** **.

Belleville, MI 48111

C: 248-***-****

Email: adu6l0@r.postjobfree.com

Highlights of Qualifications:

Analysis, general ledger, month end close, and budgeting emphasis

Certified Public Accountant since 1992

Seventeen years of property management experience and ten years of cable industry experience.

Work Experience:

Director of Property Accounting, Sun Communities & Sun Outdoors, Inc. Southfield, MI July 2016-present

Prepare actual to budget variance comments per analysis of monthly financials

Review and approve 200 monthly bank reconciliations

Review and approve 12 monthly balance sheet reconciliations

Review and resolve invoice payable issues with field teams/vendors

Collaborate with 3rd party vendor to ensure utilities are processed timely

Onboard acquired properties including utility transfers and day to day accounting

Supervise and develop property accounting supervisors and accounts payable manager

Director of Lease Administration, Ramco-Gershenson, Inc., Farmington Hills, MI

January 2015-July 2016

Review and analyze lease database input to ensure revenue accuracy

Review and analyze annual tenant expense reconciliations

Perform and analyze month end occupancy of 80 commercial properties

Perform monthly/quarterly bad debt analysis for the portfolio of 1800 leases

Review and resolve tenant billing disputes

Supervise and develop staff of seven lease administrators and three collectors

Finance Manager, Corporate Operations, General Electric Company, Belleville, MI

April 2010-December 2014

Supervise the daily accounting activities of several international residual entities

Complete the monthly and quarterly close processes to ensure GAAP compliance

Collaborate with business stakeholders to finalize and record business transactions

Prepare and review balance sheet account reconciliations.

Review and resolve intercompany variances.

Supervise and develop staff of eight accounting analysts

Sr. Financial Analyst, Michigan Region. Comcast Cable Communications

Southfield, MI. January 2009-April 2010.

Supervise the monthly accounting close; ensure accuracy and timeliness of reporting.

Prepare and review monthly operating statements.

Prepare expense and revenue variance analysis for monthly operating statements to forecast and budget.

Prepare and review technical operations budget

Act as accounting contact for division office

Mentor two financial analysts

Regional Accounting Manager, Michigan Region, Comcast Cable Communications

Southfield, MI. October 2005-January 2009

Supervise the monthly accounting close; ensure accuracy and timeliness of reporting.

Prepare and review monthly operating statements.

Prepare variance analysis for monthly operating statements to forecast and budget.

Review all month end balance sheet analysis and reconciliations.

Ensure GAAP and SOX compliance is followed in all aspects of accounting.

Create, develop, and implement financial policies and procedures.

Supervise, train, motivate and develop four staff accountants.

Manager of Financial Planning and Analysis, Midwest Division, Comcast Cable Communications

Southfield, MI. July 2003-October 2005

Responsible for the month end subscriber reporting process including review and analysis.

Analyzed monthly programming expenses for each division channel lineup card.

Review and analyzed programming audit results submitted by channels.

Reviewed and analyzed annual budget information submitted by the field offices.

Performed ad hoc analysis as assigned.

Supervised, trained, motivated and developed three financial analysts.

Sr. Financial Analyst, Midwest Division, Comcast Cable Communications

Southfield, MI. July 2001-July 2003

Reviewed and analyzed daily, weekly and monthly subscriber reporting from the field.

Prepared and analyzed the semi-annual copyright returns for the division.

Reviewed and analyzed annual budget information submitted by field offices.

Implemented process improvements for copyrights and subscriber reporting.

Sr. Staff Accountant, Comcast Cable Communications

Southfield, MI. May 2000-July 2001

Prepared journal entries and analyzed financial statements.

Analyzed monthly statements and prepared variance analysis to budget and forecast.

Prepared and analyzed detailed account reconciliations of balance sheet accounts.

Prepared work papers and worked with external auditors to ensure policy compliance.

Controller, The Livesey Company (Property Development and Management)

Madison, WI. November 1991-April 2000

Responsible for accounts payable, accounts receivable, general ledger and payroll.

Prepared and reviewed the $30 million annual operations budget.

Prepared and analyzed year end work papers for outside accountants.

Developed ad hoc analysis for development pro-formas.

Prepared and analyzed 200 commercial lease reconciliations related to CAM expenses.

Supervised, trained, motivated and developed two accounting assistants.

Served as HR administrator including health insurance, 401(k), and employee benefits.

Education:

Bachelor of Arts in Accounting

Upper Iowa University, Madison, WI.

High Honors Graduate. 3.68 G.P.A.

Software Skills: Excel, Word and PowerPoint. Oracle, Hyperion-Essbase (Citrix), Quickbooks, Peachtree, Yardi, Great Plains, MRI

References: available upon request.

Contact this candidate