William j. hagist

** ****** *****, *******, ** **082

Home Phone: 860-***-**** Mobile Phone: 860-***-****

Email address: ab8wpl@r.postjobfree.com

skills/expertise

MBA Financial Controls

IT Finance Forecasting Models

Financial and Expense Management Analytical & Detail Oriented

Contract negotiation Proficient in Microsoft Office Products

Professional experience skills and experience

2002 - 2012 AETNA Inc.

Technical Infrastructure Supervisor Manager - AIS IIS Portfolio Management

2002 - 2012

Responsibilities:

Supervised the Financial support function for Aetna's mainframe hardware and

software. This required monthly monitoring & reporting on Aetna's portfolio

hardware and software spending throughout the year.

Manage the maintenance contracts on Aetna's Data Center hardware. This

required working with vendors (IBM, EMC, HP etc.) to negotiate rates and

facilitate maintenance contracts. This necessitated the need to set up

inventory procedures to ensure Aetna wasn't being overcharged for equipment

that was inactive.

Provided ad-hoc financial research and support for Aetna's IT management.

This meant providing tools, financial models, processes and needs to

successfully meet financial goals and reporting requirements.

Accomplishments:

Provided solid documentation of Aetna claims during a major legal dispute

with a vendor. This backup was instrumental in Aetna saving millions of

dollars in contract disputes and landed a refund credit of $13.7M. Senior

management recognized this accomplishment by bestowing a "Gold" award under

the "Aetna Way Excellent Award" program.

Worked with vendors to consolidate multiple maintenance contracts. These

consolidations allowed vendors to provide Aetna with deeper discounts on

maintenance costs. The annual run rate savings attributed to these higher

discounts was $1.0M.

Collaborated with Aetna's IT areas and the Fixed Asset department to "scrub"

Aetna's inventory. This generated the removal of almost 900 devices off of

Aetna's books. The net property tax savings associated with these removals

were approximately $700K.

2001 - 2002 The Hartford

Financial Manager - Life Technology & Infrastructure Services (LTIS)

2001 - 2002

Responsibilities:

Manage, develop and implement budgeting methodology for LTIS. Monitor budget

performance and provide timely feedback on expected variances.

Prepare strategic and operating plans, which provides performance analysis

and forecasting of the financial position of LTIS.

Develop comprehensive methodology for the accurate costing of LTIS Products

and Services effectively aligning LTIS expenses with a product or service.

Perform ad-hoc research and financial analysis for senior IT management

Accomplishments:

Developed a Financial Report for LTIS so that monthly, LTIS Management could

analyze and report on the department Financial results, Staff levels and

Business areas Billings.

Coordinated and developed a new Product Pricing model for LTIS. This

methodology was consolidated onto a "one" exhibit, which made it easier for

Management to analyze and comprehend the cost accounting concepts of Product

Pricing.

Developed and distributed a Quarterly "True-up" Report, which outlined to the

Hartford Life Business how the LTIS costs were distributed to Line of

Business.

1978 - 2001 AETNA Inc.

Manager - Aetna Information Management (AIM)

1993 - 2001

Responsibilities:

Manage financial control for AIM including budget, billing, expense spending

($608M in 2000), product pricing and project prices, monthly internal/CFO/

internal customers' reporting and quarterly business reporting.

Provide guidance on financial issues, control and accountability and

performance to AIM's CIO, and departmental heads (Network & Distributed

Services, Operational Services, EMS and Technical Architecture & Standards).

Become fluent in AIM business and financial drivers for best AIM

representation to the Aenta USHC and Aetna Inc. Financial Community.

Oversee financial activity for the merger and acquisition of NYLCare and

Prudential HealthCare.

Accomplishments:

1999 favorable financial results $63M expense underage in addition to $48.5M

provided to AIM customers (Aetna USHC, AFS and Corp.). Successfully met

Corporate commitment and business target.

Product Pricing, in the Computer Center, resulted in an annual 12% reduction

from 1996-2000.

Strategically developed Monthly Management Report and Monthly Financial

Performance "Flash" Report (5th business day).

Developed an Unplanned Project process which enhanced financial control and

accountability of expenses.

Expense Manager - Property Casualty Information Technology

1987 - 1993

Managed Department Budget for Property Casualty IT organization (Budget

$225M). Oversaw and monitor the implementation of rigorous controls

throughout IT organization including revamping the controls and follow-up

process with audits. Prepared monthly expense analysis reports to Senior

Management. Was the primary liaison with internal and external department

expense reporting. Designed and implemented company-wide budget reporting

system. Revamped Data Center, Telecommunication and Print charges using

activity-based accounting. Instituted financial controls for all IT purchases

and expenses. Created Expense Management manual to aid managers in

controlling costs.

Divisional Budget Coordinator - Commercial Insurance Division

1983 - 1987

Supervise and coordinate the budgeting process for Aetna's Commercial

Insurance Division. Responsibilities

included providing guidance and overall control of the total divisional

budget. Analyze the expense forecast

against prior results and Divisional senior management expectations. Ensured

that the budget structure

coincided with Corporate Planning policies. Was a key contact for all

Divisional expense results.

Expense Allocation Analyst - Property Casualty Division

1980 - 1983

Responsibilities entailed developing and researching expense allocation

ratios used to allocate expenses to

Insurance product lines. This allocation method was used to spread expenses

to product business lines to

Determine each products profit and loss result. While holding this position,

was a key resource in the

Development and implementation of a major divisional expense information

system.

Pension Account Representative - Life Division

1978 - 1980

Performed technical support for Aetna's individual Defined Benefit & Defined

Contribution pension plans. Duties included reviewing pension plans on their

annual anniversary's to ensure each plan conformed with E.R.I.S.A.

requirements, certify plans for IRS compliance, prepare Employee Benefit

Statements and calculate pension plan premium amounts.

Education

1981 - 1985 Asnuntuck Community College Computer

Science

1977 - 1980 University of Connecticut MBA

1976 - 1977 University of Connecticut

Economics Major

1972 - 1976 Central Connecticut State University BS Business

Administration -- Honors

Professional and Personal Development

CPCU 8, 7 &5 - Accounting & Finance, Management and Insurance

Company Operations

Microsoft Excel - Intermediate & Advanced

Microsoft Access - Intermediate

Volunteer Activity:

Member of Board of Directors for Enfield Community Federal Credit

Union

Prepared Tax returns as part of the IRS's VITA program

Aided individuals as a Budget Coach within Co-Opportunity of

Hartford

Participant in the Junior Achievement Project Business program

Contact this candidate