Thomas M. Hickey 860-***-****

*** ******* ****, **********, ** 06759 ac8bhh@r.postjobfree.com

Professional Skills

PeopleSoft

Hyperion Essbase

Microsoft Access

Programming setup

Visual Basic

Pivot Tables

Cobal programming

SAP

Microsoft Excel

Microsoft Word

Microsoft Power Point

SOX Compliance

Database design

Cognos/BI Tools

Account Reconciliations

Business and Financial analysis

Professional Experience

SEK Holdings, LLC and Florida First Insurance Agency, Avon, CT

Senior Financial Analyst

Dec-2014 to May-2016

Acting CFO

May-2016 to Jul-2018

Achievements:

Implemented the software conversion for the accounting department from AMS360 to QuickBooks Online.

Implemented changes suggested by outside CPA firm, after major audit (reclassification of owner/partner draws and personal expenses).

Created an AMS360 Training Manual, conducted classes to teach AMS360 to newly acquired insurance agencies.

Responsibilities:

Set up newly acquired agencies in Quick Books, provided training of company policies and procedures utilizing AMS360 and Catalyst.

Completed Journal Entries, bank account reconciliations, and credit card reconciliations monthly.

Complete Month End and Year End Close.

Produced month P & L’s and Balance Sheets.

Analyzes, interprets, and summarizes data in preparation for generation of statistical and analytical reports.

Works closely with Sales Manager to ensure data integrity.

Proposes enhancements, modifications and corrections to ensure reporting meets owners’ satisfaction.

Norgren Inc., Farmington, CT

Jun-2011 to Dec-2014

Data/Business Analyst

Achievements:

Created three site wide Access Database Applications, which enabled a higher level of control, communication and accountability between departments.

Set up production reports for the supervisors to track labor efficiency.

Created an Excel Training Manual.

Conducted classes to teach Excel (Pivot Tables and Charts) to management and staff.

Assisted with set up of report requirements for the site system conversion to JD Edwards.

Responsibilities:

Identified all Sales and Order discrepancies between JD Edwards, and legacy system.

Assisted with month end close.

Maintained and Support the Debit Memo Application database.

Maintained and Support the Prototype/New Parts Application database.

Analyzed, interpreted, and summarized data in preparation for generation of statistical and analytical reports.

Developed predictions based on historical trends of data captured.

Prepared Daily Production and Sales & Order Reports.

Developed and maintains all reporting required by the plant.

Worked closely with Accounting Manager and to ensure data integrity.

Proposed enhancements, modifications and corrections to ensure reporting meets site satisfaction.

Presented to upper management as needed.

Costing for new jobs.

FM Facility Maintenance, Hartford, CT

May-2010 to Jun-2011

Account Analyst

Achievements:

Proposed enhancements, modifications and corrections to ensure reporting met customer satisfaction.

Identified an internal system error in the invoicing system that potentially could have provided inaccurate data in the monthly accruals for all clients.

Responsibilities:

Analyzed, interpreted, and summarized data in preparation for generation of statistical and analytical reports for all assigned clients.

Developed predictions based on historical trends of data captured.

Prepared Monthly and Annual Accruals for all assigned clients.

Worked closely with internal clients in presenting findings to both internal and external customers.

Developed and maintained all reporting required by the customers.

Worked closely with Account Coordinator and Account Manager to ensure data integrity.

Proposed enhancements, modifications and corrections to ensure reporting meets customer satisfaction.

Presented to Client(s) as needed.

United Health Group, Hartford, CT

Sep-2006 to Apr-2010

Financial Data Management Analyst

Achievements:

Developed expertise in internal financial systems including extracting and manipulating financial data.

Assisted management in the development of a corporate wide initiative to create an enterprise wide automated solution for allocating administrative expenses to regulated entities, reducing the time and cost required to perform this function.

Participated in driving the development, maintenance and enhancement of tools used in the finance reporting cycles.

Responsibilities:

Create, maintain and produce critical monthly, quarterly and annual management reporting internal and external.

Performed ad hoc reports and analysis to support statutory and GAAP disclosure requirements.

Gather, analyze, post, and reconcile base expense financial data for United Health Group’s corporate selling, general, and administrative expenses (SG&A) allocation process monthly.

Perform all ad-hoc data queries within PeopleSoft for finance department.

SEC Reporting (10Q and 10K).

Provide audit/examination support as it relates to the (SG&A) expense function.

SOX Compliance.

Health Net (formerly PHS), Shelton, CT

Sep-1998 to Aug-2005

Medicaid/Business Analyst

Achievements:

Created policy and procedures manual for reconciliations (NJ and CT).

Designed and created Database of CT Medicaid, NJ Medicaid, State of NJ employee, and MEHIP.

Created new plan code and rate set up for all groups.

Identified and recovered over 2 million dollars in lost revenue from CT Medicaid.

Reduced turnaround time for audit from 6 months to 2 weeks.

Responsibilities:

Quarterly enrollment audits; State of NJ, self funded 17,000 plus members.

A/R and enrollment reconciliation of MEHIP (110 groups)

Maintenance of database of CT Medicaid, NJ Medicaid, State of NJ employee, and MEHIP

Reconciled all billing discrepancies for all groups.

Reconciled State of NJ Cobra, Medprime, active and retired employees

Manual manipulation of NJ Medicaid 835 premium payment file

Set up and maintained maternity accruals for NJ Medicaid

Acted as liaison between business units and IS department.

Provided customer service for State of NJ and MEHIP Administrators.

Responsible for cash application and premium billing for CT Medicaid, NJ Medicaid, State of NJ and MEHIP groups, averaging $28,000,000.00 monthly

Staff training and financial reporting to upper management.

SOX Compliance.

Education

Naugatuck Valley Technical College, Waterbury, CT

US Navy, Nuclear Power Training School, Orlando, FL

References

References are available upon request.

Contact this candidate