James A. Spatcher Email and Phone Number

-Supports deal sourcing, qualification, financial modeling, due diligence and closing activities-Coordinates cross-functional deal teams within CVS and Aetna and with external parties including legal counsel, accounting consultants, and investment bankers-Performs in depth financial statement and strategic analyses and presents key findings to executive management-Manages Virtual Data Rooms, vendor relationships, and confidentiality agreements-Stays informed of broader industry developments and key business metrics as well as macroeconomic trends

-Analyzed SG&A, revenue and income data for trends and saving opportunities to present to the Transformation CFO-Consolidated and created variance analysis for internal management reports and readouts -Developed several reporting process improvements resulting in increased efficiency and improved stakeholder outcomes

-Systems implementation project for launch of multiple petabyte Hadoop financial data infrastructure-Managed business and IT data requirements to guide project work streams in partnership with Deloitte-Developed internal project tracking tool to record progress and record meeting minutes

-Reviewed, reconciled, and completed schedule K-1 investment partnership forms for multi-million $ Aetna owned investment partnerships -Completed tax audit of historical transactions from newly acquired subsidiary-Modeled PCORI law member months reporting for annual IRS filing

-Facilitated residence hall meetings and educational programs of up to 60 residents-Communicated regularly with RA staff of 15 members and met weekly with Resident Director one on one-Served as a role model to students, parents, faculty, and staff both within and outside of the university

-Quoted new business requests for proposals and claim repricers in cases of 3001+ lives with quick turnaround time-Generated plan designs for case renewals and new business by mapping benefits of several top Aetna products-Developed, analyzed, and presented ROI for Intern Capstone Project

-Redesigned team SharePoint site, managed data sharing of site, and executed change management communication throughout corporation-Produced Underwriting Reviews Monthly Reporting graphs that increased business efficiency and are viewed by leadership team-Key contributor to Underwriter Statement of Authority Platform Tool, built to automate management and creation of more than 1000 SOAs