Terrence E. Slaughter, Mba Email & Phone Number

Secaucus, New Jersey, United States

 Tracks all install and commission recloser and fuse saver units for the ESII Program. Reports out weekly count of units put into service to both Division Heads & Client Executives. Forecasts three week look ahead of potential executions for various equipment asset classes. Manipulates VLookups and Pivot Tables to condense bi-weekly program activity in.

New Jersey & New York, United States

• Sanofi Inc., Bridgewater, NJ​Financial Analyst (February 2020 – May 2020)
• Supported all monthly performance reporting and analysis - US OPEX reporting to marketing, sales force, market access, commercial operations and/or medical teams
• Consolidated monthly actuals data in central tool (TM1) - From local SAP data ​MetLife Inc., New York, NY​Senior Financial Reporting Data Analyst (March 2019 – January 2020)
• Generated weekly Net Saves Reports used to track performance activity by workstream
• Manipulated VLOOKUPs and Pivot Tables to automate and streamline the refresh process of reports used to track projects as they move through the various stages of the cost savings program​​Wolters Kluwer, New York.
• Managed business case modeling and performance tracking for key IT projects and initiatives

Newark, NJ

• Worked to forecast investment and expense data used to update the annual budget model for assigned program
• Made forecast revisions to refresh model inputs used to feed the rolling 5–Year Plan
• Updated forecast tool with monthly actuals adjusting remaining subsequent months until latest target forecast total for the year had been revisited
• Performed monthly, quarterly, and semi-annual reporting of program activity to the BPU
• Executed monthly actual versus plan variance analysis and updated commentary
• Provided Sales Team with performance statistics generated by projects in the pipeline

Washington DC

• Kaiser Permanente, Rockville, MD​Senior Financial Reporting Analyst (February 2014 – December 2014)
• Served as Project Manager by overseeing the monthly Claims Metrics Reporting process
• Generated monthly performance package used by Senior Management to analyze company-wide operations ​Inovalon, Inc., Bowie, MD​Senior Financial Analyst (December 2012 – March 2013)
• Generated financial models providing a historical cost/benefit analysis and ROI yield percentages
• Participated in proposal development process leading to the creation of various pricing model strategies ​Georgetown University, Washington, DC​Senior Financial Analyst (April 2012 – September 2012)
• Manipulated Macros in Excel to generate monthly account activity for completion of data analytics process

Washington, DC

• Utilized VLOOKUPs and Pivot Table to update monthly Non-GAAP schedule which includes analyzing and stripping out lower of cost or market (LCM) YTD activity
• Updated monthly Asset Optimization report by manipulating VLOOKUPs and Pivot Tables to analyze both revenues and corresponding expense activity generated by the program ​​​
• Prepared monthly schedule of amortized option premiums and gains/losses on settled Basis and NYMEX swaps
• Amortized Utility Summer Fill pre-paid option premiums from the Mark-to-Market asset account to the appropriate Regulatory asset/liability account​​​
• Gained thorough understanding of FASB 133, 157, and 161

Washington, DC

• Oversaw the work flow distribution, quality control, and review processes of 4 employees
• Lead project coordination efforts by working with other business areas to complete both the Audit Committee Package and Board Report used to analyze and evaluate the company’s performance
• Performed statistical calculations like Basic and Diluted EPS, 52 week Hi and Low common stock price, total headcount for Non-Utility business segment, and financial statement ratio computations including Book Value.
• Assisted in ensuring that all SOX 404 controls and compliance requirements were met in conjunction with the preparation and maintenance of internal financial reports
• Maintained and updated monthly Actual vs. Forecast report submitted to Controller for review

Buffalo, NY & Washington, DC

• Early on consisted of various Accounting roles

Mba, General Management, 3.3

Bachelor'S, Economics, 3.7

Certificate Of Completion

Intensive 3-week financial modeling and valuation training program  Performed company valuations utilizing (i) comparable public company.