Robert J. Burger
Canton, Michigan 48187
ablyp9@r.postjobfree.com
CAREER SUMMARY
Twenty years progressive experience as a finance/accounting professional.
Expertise in financial analysis, planning, budgeting, consolidations,
reporting, database management, general accounting and treasury.
Administrative support for operations and management. Strong Excel and
Access skills. A proven ability to work independently or in a group
setting. A demonstrated ability to lead a department. Expert
knowledgeable in the following software: Access, Excel, Word, PowerPoint,
Elite Enterprise, PeopleSoft, Oracle, IBM DB2.
CAREER HISTORY
DYKEMA GOSSETT, PLLC, Detroit, Michigan
A ten office, 350 attorney leading national law firm built upon its
Midwestern heritage and values headquartered in Detroit.
Accounting Manager: Jan 2008 - Current
Managed staff of 4 overseeing accounts payable, daily banking, fixed
assets, taxes, rents, and trust. Prepared monthly close, consolidations,
work papers, journal entries, bank reconcilements, surveys, variance
analysis. Managed firm's corporate credit card program, prepared annual
audit work papers, prepared audited financial statements, budgeting,
general and malpractice insurance renewals.
Prepared financial modeling for combined Dykema/Schwartz Cooper
merger in July 2008.
Created financial budget and reporting for new combined
Dykema/Schwartz Cooper entity.
Responsible for preparing over 15 surveys over the course of the
year used for internal benchmarking and to report Firm statistics
to various legal publications and required government agencies.
Prepared financial model used to calculate business interruption
insurance needs.
Analyzed and revised SBT tax calculation saving the Firm $300,000
annually.
Oversaw three general bank changes in 18 months that led to $2
million in new client fees.
Oversaw switch to new auditing firm saving the Firm $60,000.
Reduced staff two FTE by increasing efficiencies including creating
access reporting to monitor on-going vouchers on hold, AP volume,
stale checks, petty cash and missing W9s.
Financial Analyst: Sept 2001-Dec 2007
Managed finance department. Prepared monthly Executive Board financial
reporting package, tracked key performance indicators (KPIs), annual
bonus statistical reports, oversaw budget and planning process, ad hoc
reporting and analysis. "Access guru." Reconciled payroll account and
paid independent contractors monthly.
Successfully managed annual firm profit plan, forecasting, and
projections for seven years.
Responsible for tracking and reporting of Firm key performance
indicators.
Created ad hoc reporting requested by senior management including
special fees, shared billings, and practice development expense
tracking.
Microsoft Excel and Access "guru" consulting to IT and Marketing
Department.
Converted reporting process to ODBC Access links as part of
conversion from CSS to Elite Accounting Software saving the Firm
$200,000.
Worked with outside programmer on creation of Executive Information
System that was successfully rolled out to all attorneys.
Set up and maintained Redwood COGNOS profitability modeling used to
evaluate client, practice group and office profitability.
RESOURCE CONNECTION, Livonia, Michigan
Accounting and Finance Contract Staffing and Consulting
Consultant June 2001 - Sept 2001
Worked as Senior Accountant successfully implementing new
PeopleSoft Accounting system at the Arthritis Foundation. Handled
receipts, payables, month end close.
Worked on large reconcilement project at GMAC.
KMART CORPORATION, Troy, Michigan
World's third largest general merchandise retailer with over $36 billion in
sales subsequently merged into Sears Holdings Corporation.
Capital Purchase Accounting Manager May 2000- May 2001
Managed staff of twelve overseeing $300 million annually in capital
purchasing and facility management payments. Responsible for creating
and monitoring 600 closed store budget.
Department lead in successful implementation of new PeopleSoft
Purchasing / Payable system.
Developed and implemented payment validation spreadsheets to
simplify the payment process.
Reduced average weekly invoice backlog from 2500 to 500 while
reducing staff 20%.
Negotiated $30,000 savings in lawsuit settlements.
Senior Financial Analyst Mar 1999- May 2000
Supervised one analyst in preparing month-end variance analysis and
expense research for 29 department, $40 million Facility Management
Division. Prepared detailed annual expense budget and related schedules
and presentations for Senior Kmart Management. Prepared monthly store
expense accruals.
Simplified department manager budget planning process by creating
detailed workbooks utilizing Excel macros, links, and vlookups.
Researched and oversaw correction of misbooked expenses.
Senior Capital Analyst Dec 1997 - Mar 1999
Created financial modeling used to evaluate potential Super Kmart stores.
Evaluated feasibility of $23 million in operating capital expenditures.
Completed monthly store variance analysis and researched explanations.
Continued to assist in preparation of annual budget for Super Kmart.
Prepared financial analysis of over 90 Super Kmart sites of which 8
were presented to Senior Management and approved.
Conducted post audits of store performance that were presented to
the Kmart of Board of Directors.
Worked with Construction, Real Estate, Real Estate Market Strategy,
Store Operations, and outside consultants to create a model to
evaluate a new small Super Kmart format.
Financial Analyst July 1996 - Dec 1997
Worked with Super Kmart Management to prepare sales, margin, and expense
budget for 99 store, $4 billion Super Kmart sales division. Prepared
monthly Super Kmart variance analysis and forecast.
Created weekly store sales and margin budget based on historical
store performance and management projections.
Developed monthly 93 expense category budget for each Super K store
based on historical performance and agreed upon management
assumptions.
FIRST OF AMERICA BANK CORPORATION, Southgate, Michigan
$22 billion asset bank holding company acquired by National City
Corporation in 1997 and now PNC.
Senior Financial Analyst, Consumer Loans July 1994 - July 1996
Completed annual plans, monthly forecasts, variance analysis, and
profitability modeling for indirect consumer loans and residential
mortgages.
Used BASIS software and DB2 queries to plan and forecast $5 billion
residential mortgage loan portfolio used to support management in
making portfolio sell versus hold decisions.
Created detailed regional annual plan for $3.2 billion indirect
loan portfolio.
Created weekly indirect loan profitability models utilized by
management to make pricing decisions based on credit scores,
region, and product type.
Financial Analyst June 1993-July 1994
Prepared $6 billion deposit plan and monthly forecast based on management
assumptions. Completed monthly loan and deposit forecast, rate / volume
analysis, and rate shock analysis. Conducted ad hoc profitability
analysis as requested.
Helped create Activity Based Costing system used to analyze
customer and product profitability.
Created Municipality profitability model used by Senior Management
to make customer relationship decisions.
Senior Commercial Credit Analyst, Ann Arbor, Michigan Nov 1991 - June
1993
Tracked loan relationships and prepared commercial credit analysis on
bank's troubled loan portfolio. Met with customers to modify payment
terms and worked with accountants. Conducted floor plan audits.
Commercial Credit Analyst Jan 1990 - Nov 1991
Prepared detailed analysis of credit worthiness of commercial loan and
commercial real estate proposals. Prepared various loan portfolio
reports. Conducted industry research.
EDUCATION
MBA, Wayne State University, Detroit, Michigan 2001
3.9 GPA, concentration in Finance, member Beta Gamma Sigma.
1999 Wilfred Kean Scholarship for Outstanding Evening Graduate Student.
1998 Braun Scholarship for excellence in leadership, character, and
scholastic achievement.
BBA, Accounting, University of Michigan, Ann Arbor, Michigan 1989
3.3 GPA, Honors College.
Other Relevant Training:
Business Objects training by Thomson Elite 2009
COGNOS training series by Redwood 2007
Elite training by Thomson Elite 2006
Intermediate and Advanced Access training by New Horizons 2004
Kmart Training Series for Managers, Royal Oak, Michigan 2000
Enhance skills in delegating, interviewing, developing people,
communications, coaching.
Dale Carnegie Course Graduate, Warren, Michigan 1999
Certified Public Accountant CPA - State of Illinois 1997
Passed Sate of Michigan exam on first attempt and subsequently certified in
Illinois.
First of America Commercial Credit Training Camp, Kalamazoo, Michigan 1991