2010...Present
Controller, Real Estate Management Services
JLL

Oversee the full monthly financial accounting & reporting of two Industrial REIT portfolios containing 400+ assignments and 30 direct and indirect reports
Partners with internal and external stakeholders to communicate portfolio performance, address concerns, and resolves issues before they impact results
Coaches and develops staff reviewing work for quality and consistency while promoting best practices in reconciliation, variance analysis and documentation
Championed process improvement, including proposing and implementing the #FloQast close management platform to modernize JLL's monthly property closes
Serve as a technical resource for the department on accounting treatment, system issues, and complex transactions

2006...2010
Accountant
Premier Rubber Technologies

Managed the A/R, A/P and day to day bookkeeping

2000...2005
Sergeant
United States Marine Corps Honorable discharged veteran being twice awarded a Naval Achievement Medal for meritorious service above normal duty requirements
Communications technician whom maintained and repaired base telephone equipment and related infrastructure
Acted as Platoon Sergeant for Base Telephone, providing direct supervision of Marines, planning daily operations, and coordinating mission-critical activities

1997...2000
Computer Tech
Lemont Public Library

Maintained a Novell workgorup of 20 PCs and the various library systems
Worked one on one with patrons to assist with technology related questions

Contact
Here's how to get ahold of me.

Email
Derek.Harlan@gmail.com

LinkedIn
www.linkedin.com/pub/derek-harlan-cpa/9/30/74b

Education

University of Illinois at Chicago
MS in Accounting, Class of 2010

University of Illinois at Chicago
BS in Accounting, Class of 2009

Skills

Leadership Skills
Problem solving, planning, written & verbal communication, initiative, department leadership, cross functional collaboration, stakeholder communication, delegation, staff development and performance management, process improvement and change adoption

Accounting Skills
Certified Public Accountant, office and industrial commercial real estate property accounting, expense or CAM escalation, financial reporting, variance & flux analysis

Accounting Systems
JDE World, JDE Enterprise One, Yardi, MRI, Quickbooks, OneStream, #FloQast

Technology Skills
Visual Basic for Applications, Excel macros, Python, SQL, Database Admin, ChatGPT

Office Applications
Microsoft Office Suite (Word, Excel, Outlook, PowerPoint, Access)

Works Published
Beginning Microsoft Excel VBA Programming for Accountants: A Practical and Project Based Approach, 2018

Awards & Honors

Naval Achievement Medal
Twice awarded 2003 & 2005

Dean's List
Multiple awards 2005 - 2010