June M. Tansil
*** ********* ***** ( Manchester, Connecticut 06040 973-***-****
************@*****.***
Senior finance/accounting manager with 15 years of experience in corporate
finance and accounting, financial analysis and reporting, financial data
management, project management and Big Four accounting experience; precise,
detail-oriented, and analytical.
SUMMARY OF QUALIFICATIONS
. AREAS OF EXPERTISE: SEC REPORTING, U.S. GAAP FINANCIAL
STATEMENTS/FOOTNOTES, ANNUAL REPORT PREPARATION, AUDIT COMPLIANCE,
INTERNAL CONTROLS, BUDGETING AND BUSINESS FORECASTING, SUPERVISING,
TRAINING AND MENTORING, VARIANCE ANALYSIS.
. Excellent leader with proven ability to communicate and maintain
effective relationships across the organization including senior
management, corporate finance, legal and segment finance areas in
relation to intersegment area.
. Consistently demonstrates high level of integrity and professional
ethics.
. Computer Proficiencies: Microsoft Excel, Word, PowerPoint, Outlook,
Access, SharePoint, Visio, PeopleSoft; Hyperion, Essbase, Lotus Notes, JD
Edwards, Business Objects, Microsoft Project
Professional Experience
Cigna Healthcare / Bloomfield, Connecticut
January 2013- Present
MANAGER/Finance & Accounting
Health Insurance Exchange Implementation
. Developed requirements that allow CIGNA to participate in the Health
Insurance Exchange Network, which serves as a new initiative for the
organization
. Recommend accounting treatment with focus on GAAP, Statutory and Health &
Human Services (HHS)
. Determine accounting impacts to business processes and systems for Health
Insurance Exchange implementation
. Provide support to develop accounting process and business system
requirements to support the overall strategic initiatives
. Serve as a subject matter expert for accounting and provide consultative
support to IT management and staff on all phases of project development
Unitedhealth group / Hartford, Connecticut
October 2004-Novovember 2012
MANAGER/ Corporate Finance
Capital Planning
. Provided monthly consolidated financial reports i.e. current
spend/forecast/budget variances
. Solicited and consolidate capital spend requests from segments
. Prioritized project demands and monitor capital spend
. Operated as a liaison between the UHC Controllership team and the segment
capital controllers
Intercompany Reporting
. Managed UnitedHealth Group's Corporate Finance -
Intercompany/Intersegment operations area.
. Directed staff in the production and monitoring of annual
intersegment/affiliated state filings; encompassing over 100 legal
entities, with approximately $9.0 billion of revenue.
. Provided guidance to the segments for the monthly accounting of
intersegment transactions in accordance with GAAP and corporate policies
and procedures.
. Communicated with all levels of the organization, including senior
management, corporate finance, legal and segment finance areas in
relation to intersegment area.
. Responsible for providing accounting guidance to segments and regulatory
reporting as it applies to accounting and insurance regulations.
. Led the effort to transition the intersegment accounting and forecasting
area through the development of an automated calculation tool.
. Directed the development and implementation of continuous process
improvements within the operations area of the department.
. Served as a liaison and subject matter expert between corporate finance
and legal related to intersegment transactions and regulatory filings.
. Set team direction, resolves issues and provides guidance to each member
of the team
. Project: Managed the development, implementation and maintenance of the
enterprise wide affiliate agreement tool. Created and developed business
requirements, coordinated project activities, developed training
materials, created the business process flow charts, developed test
scripts and scenarios. Operated as the liaison between the business and
information technology teams by directing, leading, designing and
enhancing the upgrade for United Health Group inter-segment affiliate
tool.
SUPERVISOR/Claims Data Management
. Managed, all aspects of the refund tracking system (TRACR) encompassing
over 1 billion dollars worth of transactions including monthly system
reconciliation of all transactions affecting the ledger. Conducted
monthly review to ensure data integrity. Performed quarterly and annual
review and testing with external auditors and regulators to ensure
compliance with Sarbanes-Oxley and other audit requirements. Managed a
staff of five team members.
ERNST & YOUNG, LLP/ Lyndhurst, New Jersey
June 2000 - Sept 2004
SENIOR FINANCIAL ANALYST/Ernst & Young Global Services
. Performed detailed financial statement review, reconciliation and account
analysis.
. Prepared forecast and compare actual financial results to the budget and
forecast results. Analyze trends and provided variance explanation.
. Reviewed and reconciled segment inter-company accounts as well as the
general bank account.
. Calculated and tracked monthly depreciation and approved accruals.
. Assisted in the transition of accounting support to Ernst & Young's
remote location in India.
. Lead project to resolve the segment un-reconciled balance sheet.
. Assisted in the development, implementation and maintenance of financial
agreement system.
EMERSON RADIO CORPORATION/Parsippany, New Jersey
April 1998 - May 2000
STAFF ACCOUNTANT/Corporate Accounting
1. Coordinated the preparation of Security and Exchange Commission(SEC)
filing and compiled, created and filed 10-Q's and 10-K's
. Supplied financial information for monthly, quarterly and year-end
reporting.
. Reconciled inter-company transactions, miscellaneous receivables,
prepayment accounts, bank accounts and analyzed and valued inventory.
GALE & WENTWORTH, INC/ Florham Park, New Jersey
February 1997 -March 1998
PORTFOLIO ACCOUNTANT/ Gale & Wentworth Property Management
. Analyzed and prepared monthly and annual financial statements including
balance sheet and Income statement. Provided full suite of accounting
services for several managed properties. Responsibilities included:
accounts payable, accounts receivable, monthly bank reconciliation,
journal entries, monthly income & expense detail and weekly account
sweeps via wire transfer.
. Coordinated accounting services for clients and property owners through
internal Property Manager.
. Provided supervision and training to accounting staff and new employees.
Education/Certifications
bachelor of science - Accounting 1996
RUTGERS, THE STATE UNIVERSITY OF NEW JERSEY Newark, New Jersey
Certification: Six Sigma Yellow Belt Certification