Ted Heaney Email & Phone Number

Glastonbury, Ct

• Responsible for numerous aerospace applications written with Microsoft Access, SQL Server, complex Excel spreadsheets, and VBA. The applications analyze engine and aircraft data, track scheduled maintenance, and process sales data.• Support includes adding/updating customized Access reports, Access screens, Excel reports, Excel data connections, Excel charts, and ODBC connections. Also add/update documentation using Visio flow charts, PDFs, and Word.• Streamlined several applications by automating tasks, reordering steps, eliminating unneeded processing, and updating required documentation.• Frequently in contact with clients to answer questions, give recommendations, gather requirements, and demonstrate applications.

Hartford, Connecticut

BUSINESS INSURANCE | TrvPAS ConfigurationApril 2015 - May 2017• Designed and developed several tools to automate tasks and increase team efficiency. The tools, written with MS Access and Excel, include an automated grading tool, a log file reformatting tool, an Excel range comparison tool, a TrvPAS code lookup tool, and a TrvPAS final exam.• Supported the Business Insurance front end using Travelers proprietary TrvPAS software. PERSONAL INSURANCE | RatingMay 2011 - April 2015• Team lead for a 6-person team responsible for the design, development, testing, implementation, and documentation of all Personal Auto and Homeowner rate manual pages. The Rate Manual Page application, programmed with MS Access and Excel, automatically generates the rate manual pages filed with each state’s Department of Insurance.• Redesigned the entire Rate Manual Page application by rewriting VBA, SQL, queries, macros, tables, and forms. This greatly reduced the processing time required to run the pages, simplified the QA team testing, and reduced the maintenance required by the development team.• Lead programmer on the Travelers Insurance Score project which calculates a custom insurance score based on an individual’s credit data using vendor supplied software (Digital Matrix Systems) and Perl.• Member of 12-person Rating team responsible for updating Personal Auto and Homeowner rates using the Travelers Product Database application.PERSONAL INSURANCE | Business RulesNovember 2007 - May 2011• Member of the Business Rules team responsible for the implementation, maintenance, and support of underwriting rules for the Personal Lines Auto and Homeowner front ends using IBM’s ILOG Business Rules Management System (BRMS).

Enfield, Connecticut

• Enhanced, maintained, and supported the IT department Help Desk application. Programmed with MS Access, the application tracks hardware, software, IT work progress, and assigns ticket numbers to incoming end-user requests.• Provided phone, e-mail, and in person tech-support for 100+ end-users from all departments. Support provided for in-house software applications and vendor supplied software applications.• Lead programmer on a project team responsible for the design, development, implementation, and documentation of all Town web applications. Written with Active Server Pages, PerlScript, HTML, and ADMINS, the Town web applications were used by the Assessor, Planning, Social Services, and Town Clerk departments.

Bachelor Of Science (B.S.), Engineering

Certificate Of General Insurance, Ins 21, Ins 22, Ins 23