Dylan Turner Email and Phone Number

-Constructed a target screen that filtered 65 companies down to 5 and presented findings to management. The screen filtered companies by 21 metrics, and also included an accretion / dilution analysis.-Collaborated on a 30 page new business investment memo and forecasted financials by analyzing adoption rates, possible markets to enter, and how a current business unit could be incentivized to participate in the market.-Created an automated comparable company ratio analysis by utilizing Capital IQ that was distributed weekly.-Performed a DCF valuation with multiple terminal value calculations on a company owned interest in a pipeline asset to confirm the business unit’s valuation.

-Analyzed and evaluated over 50 utility owned battery storage bids by calculating revenue requirements, levelized cost of energy ratios, and converting costs to capacity payments to compare against power purchase tolling agreement bids.-Projected $2.1B post test year revenue requirement for SDG&E’s 2016 General Rate Case filing, by forecasting rate base components and modeling the impact on the revenue requirement. Wrote testimony, and responded to intervener requests in order to achieve approval with the California Public Utilities Commission.-Designed and deployed analytical tool to assist IT departments’ comparison of alternative operating options. Model identified savings opportunities to shareholders and ratepayers, and included pro forma financials, NPV’s, and various sensitivities.-Performed scenario analysis on a $500M pipeline, and developed the financial section of the Sempra Board package.-Coordinated with operational project managers to gather capital and O&M estimates for incremental projects, and then modeled revenue requirements, financial statements, and conducted variance analysis for the 5-Year Plan, and outlooks.

-Integral part of the Mexico Units 2014 – 2018 Financial Plan, creating project financial statements for a variable IRR and earnings, as well as calculating expected cash, capitalized interest, and non-controlling interest.-Developed and maintained parent company cost allocation models for Sempra LNG, Sempra International, and South America Holding Companies.-Conducted “Plan over Plan” variance analysis for generation assets and prepared Capital Expenditures schedules, which were included in presentations for senior management.-Assisted in the preparation of two quarterly Outlooks, which provided management with updated year-end forecasts.-Spearheaded the creation of an 80 plus slide monthly report for the SLNG VP of Commercial Development, which compiled and evaluated current and forecasted results.-Prepared a monthly cover gas report, which analyzed the cost of physical and financial gas to meet contractual obligations.

-Inspected, maintained, and repaired aircraft hydraulic/pneumatic and structure systems of the F/A-18 A/B/C/D.-Responsible for the prevention of the occurrence of defects.-Inspected all mechanical events from the start of the maintenance operation to its completion.-Possessed a detailed, working knowledge of all Navy/Marine Corps sponsored aviation maintenance programs and processes governed by technical publications.

-Inspected and signed off over 1,000 maintenance action forms.-Responsible for the safe and correct maintenance performed on over 35 F/A-18 aircraft.-Performed audits on technical programs to ensure proper upkeep.-Managed 15 Marines and Sailors as the night crew supervisor.-Awarded the service volunteer medal for outstanding achievements in the San Diego Community.

-Performed maintenance on 35 F/A-18 aircraft.-Appointed as Dispersed Technical Publication Librarian, and passed all audits with the highest marks.-Licensed in all qualifications that were available for my rank.-Awarded Marine of the Quarter for two consecutive quarters.