Resume

Sign in

Senior Financial Analyst

Location:
Bloomfield, Connecticut, 06002, United States
Posted:
April 16, 2018

Contact this candidate

Resume:

IAN R. GRANDE

** *********** *****

Bloomfield, CT 06002

860-***-****

ac45jh@r.postjobfree.com

EDUCATION

M.B.A., May 2002, GPA 3.9 Rensselaer at Hartford, Management with emphasis on

E-commerce and international business.

B.S., May 1985, magna cum laude University of Connecticut, major in Accounting

PROFESSIONAL EXPERIENCE:

The Hartford, Hartford, CT - February 2005 to Present

Senior Financial Analyst, Financial Planning & Analysis Unit (June 2016 – Present)

Key member of Group Benefits (GB) Financial Planning and Analysis team. Responsible for completing various parts of the annual plan as well as monthly forecasts. Interface frequently with business leaders as well as the CFO of the division. Present results to business partners regarding the plan and monthly outlooks.

Active liaison for various business units within Group Benefits (GB) in order to consolidate business drivers, created a full P&L and meet with business unit leads to explain variances to the annual plan as well as prior outlooks always with an eye toward challenged the status quo.

Regularly partner with financial reporting to understand actual results and the impact to current projections.

Assist in the creation of executive ready packages that isolates key drivers and variances compared to plan, as well as the prior month’s forecast, in order to enhance executive decision making.

Ensured understand and continually communicate ongoing risks and opportunities that may potentially impact key business drivers as well as the current forecast.

Regularly maintain existing financial models by layering in the latest results as well as any changes to drivers in future months.

Periodically assist in the creation forecasted ROEs and statutory core earnings.

Assumed an active role in the monthly premium close, reporting and analysis process.

Supported strategic business indicatives’.

Business Consultant, Sales and Distribution – Agency Management (October 2013 – Present)

Reviewed, monitored, analyzed and communicated overall production and financial performance of targeted National Brokers and VIP agencies.

Researched and communicated financial and data metrics with National Client Practices AVP’s to complete critical initiatives via data mining and external research.

Acted as key contact for brokers to resolve compensation, billing and agency coding requests.

Utilized external data sources to track broker merger and acquisitions, and work with field sales offices and home office licensing and contracting to ensure proper coding hierarchy.

Prepared various ad hoc analyses and presentations for broker meetings and national sales conferences. Offering creative alternatives for presentations.

Senior Financial Analyst, Financial Planning & Analysis Unit (May 2007 – October 2013; 3 years in International, 3 years in Group Benefits)

Prepared monthly Divisional Financial and Analysis Package for senior leaders. Interacted regularly with personnel at all levels both domestically and abroad. Presented results to all levels of management.

Prepared and analyzed key aspects of the respective operating units.

Responsible for preparing all corporate FP&A deliverables.

Active team member of IFMR and TM1 Financial planning tool replacement projects. Received Divisional Special Achievement Award for contributions for exceptional performance.

Identified and implemented various process improvements resulting providing actionable intelligence for senior leaders on a timelier basis.

Completed all SOX and external and internal audit requests.

Participated in cost benefit analysis of business expansion into new countries.

Senior Accountant and Reporting Analyst, Office of the CFO, Group Benefits Division

(February 2005 -May 2007)

Responsible for establishing and maintaining all internal and external GAAP and Statutory financial reporting for HLGIC (one of the two legal entities of Hartford Life), recently acquired from C-N-A.

Prepared monthly analysis of financial results. Prepared various Ad-hoc report requests. Participated in successful system conversion (team) for HLGIC entity (planning, testing, and implementation).

Resolved and supported key process and accounting issues related to HLGIC acquisition. Identified and implemented various process improvements.

Completed all SOX and external and internal audit requests.

Magellan Health Inc., Avon, CT – (November 2004 - February 2005) (Temporary Manager through Robert Half International)

Responsible for reporting monthly financial results and providing analysis for monthly close for the Western region health plans (5).

Automated and streamlined reporting processes.

Prepared Budget to Actual reporting and analysis.

CIGNA Corporation, Bloomfield CT & Philadelphia PA – (August 1986 to June 2004)

Assistant Director, Corporate Expense Control at CIGNA Corporation

(March 2002 -May 2004)

Responsible for financial discipline and reporting of expenses for class action defense project team.

Acted as financial liaison between Corporate Risk Management, Corporate Financial, HealthCare Financial, CIGNA IT, and CIGNA Legal departments. Performed various business continuity functions.

Senior Project Manager at CIGNA Corporation (July 2000 -March 2002)

Participated in selection of Khalix expense, budgeting and planning system, including researching various software vendors and gathering specs from accounting/budgeting areas.

Participated in implementation of expense software, including requirements gathering, systems design and testing.

Prepared and delivered training to over 400 users in both home office and in field. Identified more accurate expense drivers and worked with systems in their implementation.

Acted as chief liaison between corporate expense administration, corporate systems and CIGNA Health Care for the implementation of an additional enhanced expense reporting tool (CESII).

Assistant Director, Expense Administration at CIGNA Corporation (December 1998 -July 2000)

Analyzed and reported $4 billion expenses, both pre-and post-allocated, on both STAT and GAAP basis.

Served as subject matter expert for new expense system initiative, preparing detailed flow documentation with recommendations for improvement.

Identified and communicated cost drivers and allocation issues, presenting findings to senior management and serving as the principal resource to other departments seeking to understand/modify the expense allocation process.

Prepared on-going management reporting, financial analysis and ad hoc reports, including monthly, quarterly, and annual reports for all levels of management as well as for external auditors. Managed staff of three professionals.

Initiated and monitored enhancements to the CIGNA Expense System. Participated in implementation of CIGNA accounts payable system.

Project Manager, Expense Administration at CIGNA (February 1998 -December 1998)

Implemented and monitored Hyperion expense reporting software.

Prepared and delivered training for 200 users in local offices across the United States.

Manager, CIGNA, Real Estate Investments (November 1994 -February 1998)

Produced internal GAAP and STAT financial reports for corporate real estate holdings.

Managed, trained and coached staff of three accountants.

Supervisor, CIGNA, Real Estate Investments (August 1992 -November 1994)

Prepared financial reports for corporate real estate holdings.

Participated in real estate ledger conversion project.

Supervised, trained and coached two accountants.

Senior Reporting Analyst, CIGNA Real Estate Investments (March 1991 -August 1992)

Reviewed and analyzed property financial statements, both wholly owned and partnerships.

Reviewed Partnership agreements to ascertain value to each partner through “Mock Liquidation Process”.

Produced numerous reports for internal and external customers.

Senior Reporting Analyst, CIGNA Mortgage Investments (May 1988 -March 1991)

Reviewed and analyzed mortgage portfolios.

Researched variance anomalies to identify loan and transaction errors.

Produced STAT reports for internal insurance portfolio customers and calculated unit values for GAAP external portfolio reporting to investors (Mortgage Backed Securities).

Financial Reporting Analyst at CIGNA, Controllers Office (August 1986 -May 1988)

Assisted in preparation of CIGNA Annual Shareholder’s Report, footnotes, and 10(K).

Prepared financial statements for several CIGNA corporate legal entities.

Assisted in CIGNA Corporation quarterly divisional consolidation process.

Staff Auditor at KPMG Peat Marwick, Hartford, CT – (May 1985 - August 1986)

Clients in Banking, Real Estate and Not-for-profit

Performed testing and prepared exception reporting and process recommendations for clients

Volunteer Experiences:

Personal coach at United Cerebral Palsy for regional completions.

Career counseling for returning veterans from Iraq & Afghanistan wars.

Participated in numerous fund raisers for health related causes.

Certifications:

Passed all parts of the Uniform Certified Public Accountants (CPA) Exam.

Certified Business Continuity Specialist.

Independent Coursework:

Completed all courses necessary to obtain a CT Certified Real Estate Appraisers License

Completed all courses necessary to become a CT Certified Real Estate Agent

Skills & Expertise: Software & Proficiencies:

Business, Financial and Variance Analysis Excel - Advanced

Business Process Improvement Word - Intermediate

GAAP & STAT Financial Reporting Access – Intermediate

Planning, Budgeting & Forecasting Hyperion Enterprise - Intermediate

Management Presentations PeopleSoft and Oracle G/L - Intermediate

Process Improvement Identification PowerPoint - Advanced

Team Player TM1 (like Hyperion Enterprise) -Intermediate

Systems and Spreadsheet Improvements Business Objects (data mining)

GAAP & STAT Financial Statements SharePoint

SOX Documentation

Recommendations: (Posted to Linked-In profile):

Rob Ecker, CFO Group Benefits, managed Ian Richard indirectly at The Hartford

"Ian works in our finance team as a financial analyst. I find his timeliness, dedication, thoroughness, positive attitude and ability to interact with various levels of our organization to be a great asset. Feedback from his managers and business partners has been consistent with these observations. I consider Ian to be a valuable member of the team."

Karyn Cavanaugh, CFA, AVP Voya Financial, managed Ian Richard indirectly at The Hartford

"It is my pleasure to highly recommend Ian Grande. I worked with Ian for several years and was continually impressed by his knowledge, skills and dedication. He is a top notch financial analyst with a wealth of experience in many facets of insurance, accounting and financial management. His skills, work ethic and his friendly personality would make him an asset to any team."

Tom Barnes, VP of Finance, The Guardian Life Insurance Company of America, managed Ian indirectly at The Hartford.

"Ian was a key member of my accounting team, who was always willing to help with anything that needed to be accomplished. He is a strong accountant with a great attitude that makes him a valuable member of any Finance team."

Marco Pace, Director of Finance, United Healthcare worked directly with Ian Richard at The Hartford

"Ian and I worked together on a financial integration project and on monthly accounting tasks. Ian has a

Strong accounting aptitude with a thorough understanding of accounting transaction flows. He provides a Professional attitude and expertise to the team. Great to work with."



Contact this candidate