Post Job Free
Sign in

Real Estate Management

Location:
Eden Prairie, MN, 55344
Posted:
September 23, 2010

Contact this candidate

Resume:

DAVID GULLICKSON

**** ****** **** **** *******, Minnesota 55344

E-mail: ***********@*****.*** Phone: 952-***-****

SUMMARY

Finance and Accounting Professional with more than 15 years of increasingly

responsible employment with small, medium and large corporations.

Diversified, progressive experience in the analysis of financial data

supporting enterprise decision making, financial planning, forecasting,

process improvement, reporting and modeling. Committed team player with

proven ability to meet and exceed goals and deadlines. Very analytical

self starter with the ability to prioritize and produce results in fast-

paced environments.

PROFESSIONAL EXPERIENCE

UnitedHealth Group, Minnetonka, Minnesota

May 2007 - Present

Real Estate Services

Financial Consultant

Manage finance functions for real estate-related matters which include

budgeting, forecasting, management reporting and financial modeling along

with month-end close. Provide superior decision analytics, reporting and

metrics relative to activities that have strategic and tactical financial

impacts.

. Finance lead for Rent and Tenant Improvement Allowance monthly

entries, forecasting and budgeting for approximately 350 locations and

$230 million in annual rent expense and 155 locations for Tenant

Improvement Allowance

. Developed multiple process improvements allowing existing staff to

remain flat while workload greatly increased due to internal and

acquisition growth

. Responsible for preparing and maintaining data for reports that

summarize real estate activity and financial position

. Create and maintain modeling tools used for Real Estate's budgeting,

forecasting and planning process

. Prepare month-end closing entries, capital reports and account

reconciliations

. Create and run PeopleSoft queries used for financial analysis and

research

. Participate in the annual budgeting and monthly forecasting process

. Responsible for maintaining Real Estate's Hyperion Forecast model

CB Richard Ellis, Bloomington, Minnesota

December 2003 - May 2007

UnitedHealth Group Account

Project Management Accountant

Responsible for reducing the amount of assets carried on the books related

to real estate projects from nearly $30 million to less than $10 million

over a four month period. Created Excel model enhancements that included

the reduction of staff and the time needed to book monthly chargeback

entries from four days to one. Worked closely with Segment Real Estate

Directors, Senior Project Managers, Project Analysts, Facility Managers,

Treasury and Corporate Systems.

. Reconciled capital real estate project activity for more than 400

projects and prepared the transfer of assets when projects were

completed

. Financial lead for Rent and Tenant Improvement Allowance monthly

entries, forecasting and budgeting

. Responsible for the collection of $50 million in Tenant Improvement

Allowance over three years and managed staff

. Prepared and maintained data for reports that summarize real estate

activity and financial position

. Created, maintained and enhanced modeling tools used for Real

Estate's chargeback process

. Prepared month-end closing entries, capital reports and account

reconciliations

. Created and ran PeopleSoft queries used for financial analysis and

research

. Participated in the annual budgeting and monthly forecasting process

. Analyzed financial data for 400+ real estate locations

. Responsible for maintaining Real Estate's Cognos ePlanning budgeting

model and Capital Planning database

Accountemps/Volt Services Group

October 2001 - December 2003

Provided financial support and maintained financial operations on a short-

term basis to companies that were transitioning and/or replacing staff.

Trained new employees to eventually take over the finance and accounting

positions.

Companies worked for included Toro, Trammell Crow Company, Snyder's Drug

Stores, M & I Bank, Advanced Communication Design, Gordon & Ferguson and

American Baptist Homes

. Implemented a cash management system to track the company's cash

situation on a daily basis

. Reconciled bank statements for several of the companies

. Researched and corrected general ledger errors

. Maintained a company's financial operation and ran the day-to-day

activities

. Researched and investigated various accounting concerns

. Prepared financial statements and reports

Resume of David Gullickson Page 2

PROFESSIONAL EXPERIENCE (Continued)

APG USA, Inc, Bloomington, Minnesota

March 1998 - September 2001

Controller

Responsible for maintaining the financial operations and day-to-day

activities for a Management and Information Systems Consulting company with

offices in four states and one province, up to $30 million in annual

revenue and more than 25 employees. Created financial, operational and

strategic metrics, line of business reporting, audit/review procedures and

action plans to improve performance.

Prepared financial statements and statistical reports for CEOP

Performed month-end closing entries and maintained general

ledger

Reconciled and maintained corporate checking and savings

accounts

Managed all aspects of accounts payable and receivable

Prepared cash flow forecasts

Created and maintained fixed asset depreciation and

amortization schedules

Managed all activities associated with human resources,

including payroll and benefits administration

Best Buy Company, Eden Prairie, Minnesota

November 1996 - March 1998

Accountant, Inventory Control

Provided critical inventory reporting on a weekly and monthly basis and was

responsible for running computer operating systems and maintaining scripts

needed to pull financial and inventory data from Best Buy's data warehouse.

Prepared weekly and monthly reports of sales, margin

and inventory

Analyzed data and wrote memorandums for distribution

to upper management

Reconciled vendor accounts and retail inventory

Prepared month-end journal entries

Funco,Inc., Eden Prairie, Minnesota

June 1996 - November 1996

Bank Reconciliation Accountant

Reconciled bank accounts for 180 stores monthly

Performed cash management functions

Set up banking for new store openings

Best Buy Company, Eden Prairie, Minnesota

August 1992 - June 1996

Accounting Associate

Created and maintained a system that increased the number of checks coded

and entered into the system over a five day period down to one day, without

sacrificing accuracy.

Prepared month-end journal entries

Coded checks received for business accounts and located correct

account for payment application

Researched and resolved problems with corporate spending accounts

Computer Experience: . Hyperion (Essbase, Planning) . PeopleSoft

(Financials, Time Reporting) . Excel . Access

. Word . PowerPoint . Cognos . Blackline . Quickbooks

. Business Works . Star PC . MAS 90 . Lotus 1-2-3 . Paradox . Millennium

PeopleSoft, Cognos, Blackline, QuickBooks, Business Works, Microsoft Excel,

Microsoft Word, Microsoft Access, StarPC, Hyperion Essbase, MAS 90, Lotus 1-

2-3, Paradox, Millennium

EDUCATION

University of Minnesota, Twin Cities

Geography Major

Accounting & Sociology minor



Contact this candidate