DEAN G. CLARK
Ellington,CT
Summary
Business professional with broad-based experience in utilities, public power, marketing, commercial lending, insurance and banking industries. Successful track record of streamlining processes and leading high-performing teams. Known for strong analytical skills and commitment to achieving results.
Overview
28
28
years of professional experience
Work History
Manager of Energy Commodities
MASSACHUSSETS MUNICIPAL WHOLESALE ELECTRIC COMPANY
07.2022 - 10.2025
- Implemented strategy to diversify energy portfolio for members via program purchasing, developing portfolios with multiple levels of dollar cost-averaged purchases. Impact - provided a reduction in associated price risk.
- Oversaw regulatory compliance, maintaining adherence to industry standards and best practices.
- Provided portfolio guidance to members by tailoring the portfolio to each member’s unique needs and characteristics. Impact – increased customer satisfaction and reduced risk.
- Responsible for negotiating and contracting energy deals, procurement of commodities and carbon compliance obligations.
- Managed budgeting processes, ensuring resource allocation aligned with organizational goals.
- Lead development of data warehouse to manage the Renewable Energy Certificates process.
Financial Expense Consultant
THE HARTFORD STEAM BOILER INSPECTION AND INSURANCE COMPANY
01.2020 - 04.2022
- Production and distribution of monthly financial reporting package to senior leadership team. Provides ad-hoc analysis and reporting to leadership team members.
- Responsible for validation of monthly expense allocations.
- Developed VBA solution to aggregate, organize and upload multiple allocation data tables from Excel to Oracle database. Impact - reduced upload times by several hours per cycle.
- Developed VBA solution for cost center reporting tool, reducing response times to data requests. Impact - the time required to produce reports was reduced by up to 95%.
Expense Consultant
MASSMUTUAL LIFE INSURANCE COMPANY
05.2018 - 09.2019
- Developed annual operating budgets ($100M) and ongoing monthly forecasts for multiple divisions and cost centers.
- Partnered with senior leaders to provide actionable analysis to help guide and drive results empowering them to succeed.
- Managed the Cognizant, Computer Sciences Corporation, Internet Pipeline and Infosys accrual and reporting functions for IT. Responsible for coordinating the processing of transactions and managing the relationship with CapGemini partners.
- Developed VBA based solution to automate upload of project level forecast information to Hyperion. Prior to this solution, data was manually keyed into Hyperion. Impact - the team of expense consultants gained an average of 3-5 hours of productivity per consultant.
- Prepared quarterly Apptio reporting and data analysis package, for presentation to senior leadership.
Director, Financial Specialist
TRAVELERS
09.2016 - 12.2017
- Responsible for directing the execution of management reporting for the eBusiness business unit.
- Preparation, evaluation, and validation of complex financial and operational reports.
- Engaged with business partners to develop and support overall strategic plan ($40M) and assist with determination of adjustments as required.
- Developed process to shorten time to update forecast by improving the process of downloading information from time management system. Impact - several hours saved per update.
- Coordinated with Project Managers to ensure appropriate and consistent treatment of large project expenditures (capitalization/amortization), serving as subject matter expert in project accounting standards.
Manager, Planning and Analysis
PRUDENTIAL RETIREMENT SERVICES COMPANY
09.2013 - 09.2015
- Leadership role responsible for development of multi-phase, Oracle/BI/Hyperion financial reporting tool (cube based reporting).
- Performed continuous improvement review of management reporting process. Results included unification of data sources, consolidation of work flows and reduction of preparation time.
- Developed Excel (Visual Basic“VBA”) based sales management tool. Impact - reduced report preparation time from multiple days to hours, allowing report frequency to increase, creating added value for sales managers.
- Developed VBA solution for competitive analysis reporting. Impact - reduced multi-day process to less than one hour.
Business Consultant
THE HARTFORD INSURANCE COMPANY
05.2011 - 09.2013
- Provided project management expertise to ensure milestones were completed on schedule. Required establishment and maintenance of effective working relationships with all levels of staff and leaders across business areas. Impact - Project was completed on schedule.
- Large scale analysis and validation of historical data integrity, facilitation of the transition of data from the Hartford to a third party platform. Impact - Certificate of Excellence received for performance on this project.
- Developed VBA based applications, automating what were previously manual processes for Special Billing, State Tax billing, and a cash payments reconciliation system. Working with Hartford IT group, successfully integrated the cash payments reconciliation system into Hartford’s TMI platform.
- Developed SharePoint web environment to facilitate staff access to corporate policy and procedures manuals.
- Responsible for monthly calculation of and billing for the value of services provided to the buyer of the Hartford’s TPA account servicing portfolio.
- Impact - VBA based solutions have led to improved staff productivity, generating up to 1,100 hours of annual savings.
Manager, Commissions
FUTURITY FIRST INSURANCE GROUP, INC.
01.2009 - 03.2011
- Coordinated with senior management and branch managers to implement a pioneering, world class commission management and compensation system.
- Ownership of project responsibilities for scoping, implementation, testing and operation of a state-of-the-art, Variant commission system. Impact - The Company’s innovative, multi-carrier commission system was successfully installed, tested, activated and supporting 34 branch locations on April 24, 2009.
- Collaborated closely with senior management, IT and Product departments to build and maintain carrier revenue matrix, commission rates, calculations and schedules.
- Developed and maintained collection process for unearned commission payments.
- Supervised team comprised of four commission analysts.
Manager, New Business & Affinity Markets
YANKEE ENERGY SYSTEM, INC. (EVERSOURCE ENERGY)
08.1997 - 12.2008
- Responsible for all financial modeling and data analysis employed as decision making tools, to determine projects that Yankee Gas would undertake as new business opportunities.
- Developed and managed Yankee Gas’ capital budget for new business expenditures (approximately $25 million).
- Represented Sales and Marketing as a voting member in capital budget committee meetings.
- Managed and developed team of seven analysts.
- Applied continuous improvement and problem solving techniques to expedite the New Business process for approval and execution of projects. Impact - reduced the amount of time and handoffs required for project approvals by days and created a rapid approval process for projects with smaller capital requirements.
- Utilizing change management techniques integrated the financial subsidiary’s products into the marketing mix of the Yankee Gas Sales and Marketing Department. Impact - Successfully integrated financing products into sales process which was responsible for 3% of Yankee Gas annual sales.
- Oversight of market research functions for electric and gas subsidiaries. Employed regression modeling to determine those customers most likely to adopt new product and service offerings.
- Reviewed and negotiated contract terms with multiple third party suppliers of products and services.
Education
Masters in Business Administration - Finance
Nichols College
Dudley, MassachusettsBachelor of Science in Business Administration - Accounting
University of Connecticut
Storrs, ConnecticutSkills
- Advanced Microsoft Excel (pivot tables/lookups/nested functions), Visual Basic (VBA), Access, Word, PowerPoint, Project, Visio, Exchange, Sharepoint
- Oracle/BI/Essbase/Hyperion/Smart View
- Cognos/TM1
- HP Project and Portfolio Management Center (PPM)
- Apptio
- PeopleSoft
- JD Edwards
Timeline
Manager of Energy Commodities
MASSACHUSSETS MUNICIPAL WHOLESALE ELECTRIC COMPANY
07.2022 - 10.2025
Financial Expense Consultant
THE HARTFORD STEAM BOILER INSPECTION AND INSURANCE COMPANY
01.2020 - 04.2022
Expense Consultant
MASSMUTUAL LIFE INSURANCE COMPANY
05.2018 - 09.2019
Director, Financial Specialist
TRAVELERS
09.2016 - 12.2017
Manager, Planning and Analysis
PRUDENTIAL RETIREMENT SERVICES COMPANY
09.2013 - 09.2015
Business Consultant
THE HARTFORD INSURANCE COMPANY
05.2011 - 09.2013
Manager, Commissions
FUTURITY FIRST INSURANCE GROUP, INC.
01.2009 - 03.2011
Manager, New Business & Affinity Markets
YANKEE ENERGY SYSTEM, INC. (EVERSOURCE ENERGY)
08.1997 - 12.2008
Masters in Business Administration - Finance
Nichols College
Bachelor of Science in Business Administration - Accounting
University of Connecticut