Edgar Leon Email & Phone Number

Chicago, Illinois, United States

Chicago, Illinois, United States

• Lead efforts in the analysis of market trends and insights internally and externally through written reports and client pitches for the Chicago suburbs corporate office market
• Execute the statistical and analytical analysis of multiple suburban submarkets while producing local research reports
• Collaborate on a high level and build a relationship with our tenant representation brokers and business development team to assist in client presentations and provide statistical analysis
• Partner with our suburban capital markets lead for projects regarding office sale activity
• Develop and share best data and research practice standards across the Americas Research Group
• Track, analyze, and help enhance JLL’s proprietary database of commercial real estate properties, lease and sale comps for corporate offices while practicing data integrity

Chicago, Illinois

• Partner with GBN C-Suite leaders to properly account for, report on and analyze their financial results, which includes various infrastructure functions, such as Senior Management, Finance (Reporting, Treasury, Tax.
• Compose & participate in the annual budgeting and mid-year forecasting activities presented to the CEO & CFO, while evaluating requests for additional costs/investments and assist in identifying opportunities for cost.
• Heavily involved in the quarterly operations review including assisting in the presentation provided to the CFO by composing the sections for my infrastructure functions
• Coordinate with outside consultants to lead the implementation of a new EBPCS Oracle budget/forecasting tool for my team and present the tool to my colleagues
• Use Excel (financial modeling), PeopleSoft (two versions), Oracle EBPCS, OneStream, and Hyperion planning (three different systems for three regions) daily

West Kingston, Rhode Island

• Lead analyst in month end closing process of evaluating and consolidating support function costs (roughly ~$120M) using cost analysis and working diligently with business partners
• Used financial modeling skills to compose the entire division’s biweekly orders and sales report analyzing data from project accounting, backlog, Oracle, and individual controller feedback to understand the risk to.
• Analyzed and created a PowerPoint Presentation to illustrate the evolution and current state of orders, sales, gross margin, and SFC for the quarterly business review
• Lead the quarterly forecast process of SFC for the entire North & Central America division
• Duties in preparing journal entries, general ledger review, and balance sheet reconciliation
• Applied skills in Excel, Essbase, Oracle Business Intelligence, GL Wand, R-12, and SQL daily

Bachelor'S Degree, Economics And Finance

Activities and Societies: Organization of Student Life and Leadership, Student Life Programming Board, Accounting chair for Relay for Life

Master'S Degree, Economics