Real Estate Accounting

John T. Albano

*** ***** **** . ***** ****, NY **754

631-***-**** (C) . ************@***.***

Professional experience

ProUnlimited (Finance Division), MSP/VMS Staffing and Payroll Services

October 2012 to Present

Reason for Leaving: Division relocating to California

Senior Business Analyst/Financial Analyst

. Manage day-to-day accounting and finance responsibilities, including

management reports, trend analysis, system analysis, and ensure data

integrity.

. Handle month end close process reviewing, reconciling and creating

journal entries.

. Responsible for the accounting of specific balance sheet and income

statement accounts and preparation of related monthly analyses for

review.

. Possess a good understanding of the systems and how data comes together

from each source. Innate sense for details, accuracy, and the urgency for

reporting

. Preparation and communication of the Gross Profit Reports, using N-

Vision reporting to gather data and spreadsheet manipulation and

analysis to answer trends in the business.

. Special projects for the team including excel training and the creation

of templates.

. Hired specifically to teach in house excel training classes for groups or

individuals to strengthen the organization and the individual.

. Create and implement an improved process which streamlines reports,

eliminates errors and efficiently analyzes data, increasing productivity.

. Responsible for creating the weekly and monthly Borrowing Base report

reviewed by management and sent to the lending institutions.

. Expeditiously create ad hoc reports and analysis when requested by senior

management.

. Gather and analyze data to create automated processes in multiple areas

of the company.

. Act as liaison between the accounting/finance and IT departments.

. Generate customized financial reports and analysis using PeopleSoft,

Vista, and File Zilla.

. Create and maintain monthly reports in both Excel and Access (visual

basic, macros).

. Train groups in the California office on PeopleSoft queries and reporting

capabilities via the Web.

. Responsible for obtaining information and presenting supporting data to

auditors for multiple companies in a timely and accurate manner.

Willbros Group (UTD Segment), Oil and Gas Utilities April 2011 to

October 2012

Reason for Leaving: Division dissolved due to a merger and acquisition

Senior Financial Analyst (Reporting Manager)

. Manage day-to-day accounting and finance responsibilities, including

monthly closing process and budgeting, cash flow forecasting, budget to

actual reporting and evaluation, and ensure data integrity.

. Collaborate with upper management and controllers to create budget,

backlog, and cash flow reports on a monthly basis to be presented to

corporate.

. Preparation and posting of monthly journal entries including the timely

processing of accruals, amortization, pre-paids, etc. using the JD Edwards

accounting package

. Handle month end close process reviewing, reconciling and creating

journal entries.

. Possess a good understanding of the systems and how data comes together

from each source. Innate sense for details, accuracy, and the urgency for

reporting

. Compile information necessary to review and create pro-forma reporting to

measure performance

. Create pro-forma P&L

. Preparation and communication of the Cost Center Reports, using Cetova

reporting to gather data and spreadsheet manipulation and analysis to

answer trends in the business.

. Prepare and maintain updated documentation on department procedure,

definitions of data fields and process for reporting and close.

. Assist with year-end audit

. Create and maintain monthly reports in both Excel and Access (visual

basic, macros). Known throughout the entire organization as a super user

to be consulted with for special requests (including IT).

. Teach in house excel training classes for groups or individuals to

strengthen the organization and the individual. This was part of corporate

initiative that was my suggestion in a quarterly meeting with upper

management.

. Generate customized financial reports and analysis using both JDE and

Cetova.

. Create and implement an improved process which streamlines reports,

eliminates errors and efficiently analyzes data, increasing productivity.

. Responsible for obtaining information and presenting supporting data to

auditors for multiple companies in a timely and accurate manner.

. Gather and analyze data to create automated processes in multiple areas

of the company.

. Act as liaison between the accounting/finance and IT departments.

Citigroup, Banking Finance

April 2009 to April 2011

Reason for Leaving: Division was part of offshore plan to cut costs

Senior Financial Analyst (AVP level)

. Collaborate with planners and controllers to review budgets, balance

sheets and income statement reports on a monthly basis.

. Handle month end close process reviewing, reconciling and approving

journal entries on over 400 accounts.

. Prepare Hyperion Monthly Reporting

. Handle monthly and quarterly corporate reporting requirements (loads and

submissions).

. Create and maintain monthly reports in both Excel and Access (visual

basic, macros). Created processes that were considered re-engineering

value adds due to time/cost saving techniques and accuracy.

. Generate customized financial reports and analysis for adjustment of

terms (AOT), trouble debt restructuring (TDR), and loan loss reserves

(LLR).

. Responsible for obtaining information and presenting supporting data to

auditors for multiple companies in a timely and accurate manner.

. Work with all levels of management from controllers to presidents and

VP's participating in various committees due to advanced technical skills

and ability to understand the task at hand.

Benderson Development Company, Real Estate Developer/Operator

December 2005 to November 2008

Reason for Leaving: Real Estate crash caused business contraction (most

holdings were in Florida)

Senior Accountant / Financial Analyst (Manager)

. Continually met with senior level management to review project status,

budget issues, and present strategic ways to improve processes.

. Responsible for all accounting operations developing, implementing, and

documenting policies and procedures relating to all aspects of operations

relating to both commercial and residential development ($2-5 million

dollars spent per week).

. Handled various tax issues (Surtax Rules), creating chart of accounts for

each job for tracking purposes, documenting which items were to be

expensed or capitalized based on GAAP industry standards, and

reclassifying journal entries to complete the job costing cycle.

. Managed and trained a team of 6 direct reports on accounting policies and

procedures assuring all Florida projects were completed on time and in

accordance to budget.

. Oversaw the review of all purchase orders and change orders with owners

and project managers.

. Implemented a Lean Waiver System which resulted in a decrease in legal

issues and increase in the number of projects completed enhancing company

image among vendors.

Cushman & Wakefield, Global Real Estate Solutions

September 2003 to December 2005

Reason for Leaving: Relocated to care for parent

Senior Analyst - Verizon Portfolio

. Responsible for developing and analyzing long and short- term financial

forecast preparing and analyzing budget versus actual with variance

explanations.

. Used expert level Microsoft Excel and Access to streamline the budget

process for the core and wireless portfolios (2400 leases) which decreased

process completion by 3 weeks.

. Originally recruited as an analyst and was promoted to senior analyst

within a few months of hire managing a team of 2 direct reports and 1200

leases.

. Created, implemented and maintained various reporting tools to streamline

processes in both Microsoft Excel and Access for the entire portfolio.

. Abstracted various types of leases into the system that included purchase

options, early termination fees, renewal options, tenant improvements, and

right of first refusal, right of way and various other components.

. Conducted market research and analyzed business and financial data.

Swiss Re, World's 2nd Largest Re-Insurer

June 2001 to

June 2002

Reason for Leaving: Relocated from New York to Florida

Senior Financial Analyst

. Responsible for budgeting, forecasting of both individual and

consolidated business units on a quarterly and annual basis, assuring

expenses were allocated appropriately.

. Responsible for the roll out of the new employee reimbursements system,

liaising between the accounting and IT departments. The implementation

adhered to all accounting rules (GAAP) and following the new

implementation all employees received their reimbursements within 24

hours.

. Assisted the IT department database upgrade from Oracle 9 to 11i, running

our financial software systems in parallel environments to ensure a smooth

transition with data intact.

. Automated production of executive reports for management using macros and

complex formulas to reduce human error and create efficient, reliable

reporting in a timely manner.

Setai Group (Millennium Partners Spin Off), Real Estate Developer/Operator

September 2000 to May 2001

Reason for Leaving: Company failed

Senior Accountant / Assistant Controller

. Worked closely with high profile clients scheduling projects, organizing

project requirements, coordinating budgets and relaying project status.

. Created, implemented, and documented accounting procedures in accordance

with GAAP.

. Coordinated and prepared loan draws for funding by various banks for

payment to vendors including Bridge / Mezzanine loans, Hard and Soft

costs.

. Traveled to job sites to monitor construction progress, review costs, and

track actuals to planned costs to minimize cost over runs and ensure

projects were completed on time.

Marsh & McLennan, 2nd Largest Global Insurer

September 1999 to September 2000

Reason for Leaving: Left for chance to be an Assistant Controller

Accountant / Financial Analyst

. Developed, coordinated preparation of forecasts, annual budgets, and

consolidation of functional strategic plans.

. Point person with CFO during quarterly board meetings to explain

variances between actual, budget, and year over year comparisons.

. Created, and implemented a new process to track, and analyze reports

pertaining to interest income from outside offices and lines of business.

Drastically reducing the time to produce the report from a week to 10

minutes.

Millennium Partners, Real Estate Developer/Operator

May 1997 to May 1999

Reason for Leaving: Internal company issues caused turnover. Setai Group

was formed by others who left at the same time.

Accountant

. Created job costing reports to track the costs of each project separately

and then compared them to budget.

. Prepared consolidated financial statements. Responsible for all daily

accounting functions including bank reconciliations, Accounts Payable,

Journal Entries and accruals. .

. Developed and implemented standardized accounting processes that

streamlined operations and efficiently increased productivity.

. Led company through transition of two new accounting systems, training

staff on each system and its functions each time reducing errors and

increasing productivity.

Technical Skills

? Microsoft Excel Expert ? Microsoft Access ? Microsoft Word ? Visual Basic

? JD Edwards? AS-400? Peachtree ? Timberline ? Great Plains ? Oracle 9 and

11i ? PeopleSoft ? SQL ? Hyperion Essbase ? Cetova ? Business Objects ?

Vista

Education

* Pace University, Pleasantville NY - Class of 1997

BA, Business Administration and Accounting

Contact this candidate