John Orlando Email & Phone Number

Washington, DC, US

Las Vegas, Nevada, United States

• Created monthly financials of the construction of this $3,770 Billion Resort & Casino.
• Created owner financial presentations and forecasts.
• Created construction budget and reconciliation reports.
• Created the Monthly Cash consumption and requirements forecasts.
• Reconciled General Contractor's (G.C.) invoices via AIA G702 and AIA G703 forms, > $100 M Monthly.
• Tracked trends of key performance indicators (KPI’s), and presented reports to executives.

Las Vegas, NV

• Employed at Fontainebleau Development through Orlando Analytics, LLC.
• MGM Resorts Design & Development, Las Vegas, NV -- Part of MGM’s ORACLE implementation team; assisted mapping data, SME for construction projects. Organized data from legacy accounting systems,
• Stansberry Research, Baltimore, MD -- Developed ASC 606 revenue recognition for reallocating $80 M.. Created waterfall analysis & allocating journal entries for ASC 606 revenue reallocations.
• St John’s Community Service, Washington, DC -- Developed the consolidated budget for 136 business units in 7 states, included overhead allocations. Provide board report, budget metrics, forecasts, etc.
• NIYAM IT, Washington, DC -- Created financial models & tools to track projects for headcount, burn rate, & cost forecasts. Automated reports using ODBC connections to QuickBooks & TSheets.
• Other Projects -- Developed 5-year financial forecast for a $25 million energy company: IS, BS, & CF.

National Harbor, Maryland

• Employed through MGM National Harbor, MD. I reported to the VP/CFO of MGM Resorts Design & Development (MRDD). I managed the financial analysis for the following properties:- MGM National Harbor, National Harbor, MD.
• Developed reports to track and forecast construction contracts & commitments.
• Monthly forecasted total cash to be spent through the end of construction.
• Reviewed & approved contractor invoices for accuracy and reasonableness.
• Assisted in maintaining compliance to MD and MA State gaming commissions.
• Calculated the net asset value of MGM National Harbor to sell the property to MGM's REIT.

Washington D.C. Metro Area

- MGM National Harbor Casino (Jan ’16 – Apr ’16) - National Cooperative Businesses Assoc. / Cooperative League of the USA (Oct ’14 – Jan ’16) - George Washington University / Graduate School of Education (Apr ’14 – Oct ‘14)- E*Trade (Dec ’11 – Jan 12)-- MGM National Harbor Casino (Jan ’16 – Apr ’16) $1.39B Construction Budget. Developed the Diversity.

Annapolis, Maryland

Work closely with developers and financiers to validate strategic visions using robust financial models. Developed analysis tools, Gantt fiscal projections, automated Excel applications and sophisticated Access databases. Projects included commercial Solar PV energy systems in the US, Europe, and Russia. From 2012 – 2014, my time was on retainer to develop.

Columbia, Maryland

• Managed the entire Commissions department and process.
• Improved and automated system of Excel workbooks, pivot tables and database extractions that calculated commissions for 120 payees
• Made the department Sarbanes-Oxley compliant
• Reported Sales and Use tax
• Co-developed subscription pricing model
• Developed 3 year revenue model used to justify new marketing strategies

Annapolis, MD

Develop pro-forma financial statements (Balance Sheet, Income Statement and Cash Flow Statement) for international assets in: India, Saudi Arabia, Philippines, et cetera. Statements conformed to each country’s accounting standards and included foreign currency (FX) translations. Data extracted from CostPoint

Columbia, Maryland

Ensured accurate and timely commission payments (220M/year). Simplified a department that became complex due to acquisitions. Lead inter-departmental improvement meetings. Ensured fair cost allocations. Developed commission models. Developed total cost of ownership, cost-benefit and buy-build models using DCF, NPV and Payback analysis. Developed Process.

Timonium, Maryland, United States

• (Teledyne manufactures and sells hydrogen generators, hydrogen fuel-cells, and remote power systems)
• Developed cost and financial analyses for energy systems used on off-shore platforms, gas pipelines, and remote power applications
• Developed and presented proposals both to management and the client
• Employed extensive SWOT (strength, weakness, opportunities and threats) analysis justify strategies and business decisions
• Visited Sandia Energy Labs and the National Renewable Energy Lab (NREL) investigating Transfer of Technology programs involving Hydrogen storage and Sandia’s Sterling Dish
• Clients in the US & International

Baltimore, Maryland, United States

• (Wingard and Co. is a machine shop specializing in air & spacecraft components.)
• Developed and presented proposals; and closed the deals
• Increased revenues by 200% within first 3 years
• Contracts valued to $2 million
• Products used in air and space crafts as well components in the power industry
• Briefed management on the profit potential, costs and risks of new business opportunities

Mba, Finance

• Advanced Financial Analysis (4.0) • Financial Analysis (4.0) • Mergers and Acquisitions (4.0) • Financial Modeling including pro-forma.

Bba, Management

Education record

Always looking to connect with my H.S. friends...