EDWARD CASTELLAN MBA

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

Oak Brook, Illinois, 60523

Cell Phone 708-***-****

adw84d@r.postjobfree.com

SUMMARY

Accomplished financial professional with an extensive background in all phases of accounting including, statement preparation, budgeting, forecasting, tax & audit report preparation, financial analysis, and account reconciliations. Demonstrated strengths in problem solving and planning. Complete proficiency in various accounting software programs including MS Office (Yardi, Excel, Power Point, Access, Personify, Concur Workday, QuickBooks, and Sage products). Strong oral and written communication skills.

PROFESSIONAL EXPERIENCE

Alzheimer’s Association. Chicago, Illinois, 2008 to 2023

Assistant Director Accounting

Reviewed Employee Expense Accounts for Receipt Compliance (Over 39,000 receipts a year)

Compiled Chapter revenue for 15 to 29 Chapters per month (Depending on Staff situation)

Reported National Revenue by eight working day for 15 to 29 chapters per month

Support Human Resources with employee expense reimbursement reports

Researched Chapter revenue discrepancies

Reviewed Chapter Journal Entries for proper account numbers and adequate support

Compiled back-up and support for external and internal auditors

Developed procedures to accomplish many tasks efficiently

Converted Sage accounting system to Workday

Calamos Real Estate, Inc., Naperville, Illinois 2007-2008

Real-Estate Accounting Manager

· Generated statement of activity and cash flow reports and reviewed for accuracy and integrity

· Communicated monthly budget variances to other departments for all properties

· Developed budgets by working closely with other departments in compliance with company accounting matrix

· Responsible for allocation of expenses and cost to various properties and entities

· Supervised Accounts Payable and Receivable Staff Accountants

· Developed CAM reconciliation worksheets for tenants and responded to internal and external questions

· Review & submit draw packages (G702 & G703 lien waivers)

· Able to coordinate & complete multiple projects to meet required deadlines

Equis Corp. Chicago, Illinois 2003-2007

Budget Manager, (AT&T Real-Estate Division)

· Prepared and managed budgets for two regions of the country (1256 leases)

· AT&T CRE Director received full bonus based on real-estate results (three years in a row)

· Saved client $1.9 million in real-estate expenses (earned Roth award)

· Developed useful reports that are used by all the real-estate regions. Result was a savings of 3 days

for month-end reporting.

· Part of the team that converted MS-Access data base files into MS-Excel files. Averted Data-base

crash as well as placing AT&T Real-Estate division in compliance with Sarbanes-Oxley

· Prepared High-Level variance reports as well as best-view reports for month end calls

· Monitored results daily and communicated as well as provided back-up for discrepancies

corrections before month end. As a result, the error rate was reduced and Equis qualified for

additional performance bonus rewards

Comcast (AT&T Media Services) Park Ridge, Illinois 1997-2003

Accounting Supervisor, Chicago Ad Sales

· Managed Accounts Payable and Cash Receipts personnel

· Coordinated monthly close process by assigning tasks and deadlines

· Reported financial results, variance analysis and balance sheet account reconciliation

· Participated in monthly financial statement review calls

· Improved commission calculations by implementing spreadsheets that reported and organized detailed data

· Led implementation of Comcast accounting and reporting procedures in order to achieve specific deadlines

AT&T Local Services/Teleport Communications Group, Chicago, Illinois 1997 – 2001

Responsible for the capital budget of $235 million

Converted capital projects to an Oracle financial system

Prepared capital project request and acted as liaison during the approval process

Evaluated status of open projects, held monthly capital project meetings to discuss results with management

Controlled purchase orders throughout the funding process

Developed Excel spreadsheets used by other regions for reporting purposes

Observed and approved inventory audits for the Great Lakes Region

Performed monthly analysis on financial statements as well as bank reconciliations

Prepared sales forecast based on detailed analysis of sales department estimates

Reconciled various Balance Sheet and Profit and Loss Statement ledger accounts

Coordinated monthly close

Established percentage of completion on open capital projects

Supervised Accounts Payable Clerk

Assisted account executives with business cases write-ups

Established relationship with City of Chicago Building Department in order to obtain permits, fees and insurance bond

EDUCATION

MBA – Dominican University, River Forest, Illinois.

BS – DePaul University (Accounting/Finance), Chicago, Illinois.

Contact this candidate