Marcus Giles Email & Phone Number

New York, Ny, Us

• Developed and managed a combined $235 million in quarterly forecasts for several business units, including defining processes, leveraging best practices, developing support documentation, and senior leader reporting.• Managed all financial modeling, ad hoc analytics, and month-end close activities using Oracle ePBCS and OTBI for assigned areas while enhancing the overall expense management process.• Ensured consistent, efficient, and cost-effective processes and procedures with appropriate accountability.

• Oversaw 1,000+ project portfolio and liaise with field engineers, finance leaders as well as project managers to lead forecasting activities for sales orders, revenue, contribution margins and cash flow.• Forecasted future savings, consolidated financial data, and reported performance on the global initiative to save $150 million in facilities maintenance costs over a 5-year timespan using Adaptive Insights, Excel and Tableau.• Performed quantitative analysis of operational and financial data on the manufacture of $4.5 billion in lead-acid batteries using JD Edwards, HFM, and Excel financial modeling.• Compared WBS Element-based project variances to annual budget, prepared monthly forecasts and presented gas pipeline transmission construction progress as a Project Controls Analyst on $125 million in capitalized expenditures.• Reviewed construction and inspection related SOWs, communicated invoice discrepancies with project managers and collaborated with vendors to rectify issues for invoice resubmission. • Developed Hyperion Smartview-based financial models on cash flow and P&L projections, monitored net working capital requirements and prepared monthly PowerPoint Board of Director presentation decks.• Gathered data from SAP FI/CO and other proprietary systems to analyze $1.5 billion in contingent worker expenditures for the SEC-mandated Executive Pay Ratio Disclosure.• Compiled and analyzed transactional data in Oracle BI for accuracy, developed Excel-based financial reports, projections and presentations for management review, and performed reconciliations on internal accounts.

Atlanta, Ga, Us

• Coordinated the annual Marketing budget, prepared actual to forecast variance analysis with explanations, supported ad-hoc requests, assisted Corporate Accounting with month-end close, and reviewed vendor sponsorship transactions.• Developed presentations and reports on benefits gained from $120 million in Sports Marketing contract spending.• Analyzed vendor invoices and other high-volume transactions in Lawson for adjusting journals and forecast updates.• Reconciled monthly balance sheet and inter-company accounts ensuring proper classification of special project expenses.• Participated in cross-functional process improvement initiatives through streamlining and documenting changes to current GAAP accounting procedures that reduced processing times by 25%.

• Presented PowerPoint summaries on impacts of marketing strategies and trends to SVPs and other non-technical personnel.• Collaborated with Marketing and FP&A to drive insight on campaigns, initiatives, and metrics through the analysis and modeling of 71.4 million subscribers generating $24.2 billion in gross data revenue.• Built working relationships with IT Professionals responsible for SQL queries, data extraction, and database management.• Partnered with operating divisions to evaluate performance, review variance drivers, identify industry trends, and prepare PowerPoint decks for senior management review.• Performed financial and operational analysis needed to support various disciplines with annual strategic plans, monthly operating budgets, and long-range projections using Hyperion Essbase and Oracle BI.• Provided ad hoc support including business case development on wireless initiatives, financial statement consolidation, financial modeling, variance reporting, and management summaries in Excel.• Tracked IT project Capex and Opex against forecast in SAP FI/CO while ensuring costs are classified and coded correctly.• Collaborated with IT project leaders to review vendor contracts ensuring strict adherence to internal corporate policies.• Monitored capital project timing and forecasted expenditures while creating subsequent SOWs for expected cost overruns.• Created Excel-based financial models utilizing pivot tables, vlookups and other functions to reviews the high volume of invoices processed through accounts payable.

Atlanta, Ga, Us

• Coordinated the month-end close process including allocations, reconciliations, accruals and other journals in Lawson.• Collaborated with Partners to update revenue and expense forecasts, review operating performance, and prepare reports.• Supported ad-hoc requests, managed budgets, provided variance explanations and prepared financial statements.• Maintained the general ledger adding new accounts, departments and upgrades to improve financial reporting accuracy.• Developed an electronic journal voucher indexing system reducing audit time by 75% while eliminating paper usage.• Implemented Equity Enterprise software used to accurately capture 1.6 million in stock grants valued at $64 million, and Up Your Cash Flow software used to budget and forecast cash flows of $117 million.

Atlanta, Georgia, Us

• Led the rolling P&L forecasting process of expenses, headcount and allocations for a total $108 million in operating costs of 199 cost centers and 2,118 employees using Hyperion Essbase and SAP FI/CO.• Provided Operational support during the annual strategic planning process including headcount, capital budgeting, operating expense analysis, consolidations and senior management PowerPoint presentation decks.• Developed balanced scorecards and dashboards of key performance indicators (KPIs) used by Operations to measure and analyze financial, operational and industry metrics, benchmarks and trends.• Prepared investment-driven business cases, created operational ad-hoc reports and analyzed actual to forecast variances for a $2.4 billion subsidiary.• Automated a comprehensive monthly financial and operational variance report reducing processing time by over 50%.• Researched expense reduction opportunities of Delta Technology’s $126 million IT budget discovering savings of 8% or $10 million.• Analyzed regional jet baggage and cargo Operations identifying $1.5 million in savings through bag claim reductions and cargo consolidation.• Coordinated the multi-level, cross-functional due diligence project for the purchase of available seat miles from Chautauqua Airlines, a deal yielding $176 million in operating revenue.

Master Of Business Administration (M.B.A.), Business Administration And Management, General

Certificate Of Completion, Financial Management Program

Bachelor Of Science, Finance