Christopher Spartz Email & Phone Number

Columbus, Oh, Us

Columbus, Oh, Us

Columbus, Ohio, United States

Energy Services Finance & Reporting- Responsible for monthly variance reviews and financial support for two departments with annual budgets totaling $21M. Assist departments with ad-hoc financial needs to meet targets- Create funding actions to move around budget throughout the year due to various reasons and track daily budget movement for multiple departments with annual budget totaling around $134M- Consolidate Monthly Reporting for AEP Transmission portfolio- Monitor cancelled capital projects to ensure adherence to procedures and cross-functionally work with project teams to assist in the closure of projects identified as cancelled- Enhanced labor dollar transfer process to reduce error and consolidated into one file- Consolidation of incremental budget asks from departments for annual review process

Columbus, Ohio Metropolitan Area

- Manage asset allocation of Pension and other AEP Trusts- Created funded status variability model for OPEB trusts based on different asset return and interest rate scenarios- Led two projects to further expand the self-directed brokerage window within AEP's 401k (equities, ETFs, Fixed Income) to expand the options available to our 22,000+ participants- Automated the process of accrual entries for invoice payments, which saves 4 hours of work per quarter- Lead tax reclaim process for AEP Trusts, which brings back about $500,000 per year back to trusts- Automated the 401(k) expense ratio calculations that are reported to participants- Collaborate with HR, Legal, and other Cross-Functional Teams in the oversight of AEP's trust assets- Co-chair for the Treasury & Risk Culture Team

Columbus, Ohio Area

-Perform testing on the CCB/CB Finance Team in areas including: SOX/CCAP, FP&A, External Financial Reporting, Capital Planning, Product Pricing-Performed testing on the CCB Card Services Team in the area of Card Marketing Acquisitions-Performed testing on the CCB HL & Auto Team in the area on HL Originations and Auto Collections-Communicate with stakeholders by leading walkthroughs and maintain relationships during the audit cycle-Assist audit management with documentation, issue write-ups, and external stakeholder meetings-Lead a team of 6 that creates and organizes networking events for members of the Audit Analyst Program-Independently completed a stand-alone issue validation and presented findings to upper management

Delaware, Oh

- Completed 7 ad hoc projects upon request through the use of excel, HFM, and SBP- Forecasted units for plants for Q4 using past actuals and production days- Aided the process of monthly P&L internal reporting management books for 54 North America based plants and warehouses-Updated internal reporting files for an adjustment in inter-company regions-Gained exposure to operational finance and how key performance indicators impact a P&L

Columbus, Ohio Area

- Filled out company abstract statements in excel through pulling data from company financials and state pages- Prepared annual statements for premiums and losses incurred during the 2018 year- Updated 15 filings from a fillable pdf to an excel file in order to automate the process for annual filings

Del Mar, California

- Oversaw the family and relaxation pools at the resort and was trained to give Forbes 5-star service- Recorded food orders and retrieved the food from the kitchen and brought it to the guests

Greater San Diego Area

- Helped analysts research general data for client investments and input it into an excel file- Obtained a basic understanding of portfolio management and the investment software program Morningstar