WALLY POWELL

** ***** ****** = Guilford, CT ***37 = 860-***-**** = advhzy@r.postjobfree.com

Summary:

•Extensive experience with corporate internal/external financial reporting

•Extensive experience in the implementation of cost saving initiatives to ensure business efficiencies

•Extensive experience with dimensional models, translating business requirements to logical models

•Extensive experience with multi-dimensional database applications to include:

EBX5 (Orchestra Networks)

Enterprise Performance Management (EPM) suite (Oracle):

Data Relationship Management

Hyperion Financial Management

Hyperion Smart View for Office

Essbase

Hyperion Financial Data Quality Management (Oracle)

PeopleSoft General Ledger (Oracle)

SAP

Corptax Compliance, Longview Tax Planning

•Extensive experience with Microsoft applications to include Excel, Word, Access, Outlook, Powerpoint

Experience:

Raytheon Technologies Corporation, Farmington, CT July 2006 – March 2021

Central Accounting Services, Accounting Operations and Process Management 03/2015 – 03/2021

•Managed all process improvement and optimization projects for a department of 50 employees

•Created and maintained all aspects of the department’s SharePoint Intranet site. (The site was accessed by 1,700+ users and was comprised of 10 pages, 30+ libraries and 40+ lists)

•Developed a SharePoint Intranet site to facilitate onboarding of all newly hired department employees. This decreased the onboarding time (delivery of required hardware/software/access to company applications) by one month.

•Developed and maintained the department’s Blackline monthly task list of over 2,000 accounting deliverables supporting 50 employees.

Tax Technology, Data Management 07/2006 – 03/2015

•Led implementation of UTC’s new Data Governance/Master-Reference Data Management application (EBX). This tool serves as the corporation’s single source for entity and account metadata, supporting Financial Reporting/Consolidations, Tax, Legal, Treasury, Business Controls and Real Estate

•Developed EBX Data models to support critical processes involving several applications, to include Longview (Tax Planning), Corptax (Tax Compliance/IRS Filing), GEMS (Legal) and BIG (Real Estate)

•Provided EBX demos and training to multiple stakeholders, including staff from UTC Tax Compliance and Planning, BU HQ Tax and finance staff, Treasury, Controllers and UT Real Estate

•Developed automated process to extract G/L (HFM) data for over 1,500 UTC Legal/Tax entities and import directly into Corptax for IRS Income Tax Annual return preparation and filing. This process eliminated what was once a manual effort of typing Trial Balance data into the tax return, and greatly improved the accuracy, consistency and timeliness of this data for all UTC BU’s. Data/Mapping related help desk tickets decreased by 90% as a result

•Assumed management of onshore/offshore staff to accomplish above

Lincoln Financial Group, Hartford, CT June 1999 – July 2006

Financial Reporting Unit, Accounting Manager

•Essbase administrator of 13 applications/databases – responsible for performance tuning, data retention, archiving, security and upgrades as well as maintenance of current applications

•Managed unit responsible for the posting of Statutory/GAAP journal entries to general ledger, input of required metric data to Hyperion database, completing required Quarterly and Annual Statement requirements

•Modeled and maintained an Essbase tax application for both actual and plan data, populating of all tax adjustments in Essbase and reporting trend results to the Tax Department

•Modeled and maintained an Essbase Claims database, moving all reporting from a manually intensive Excel process to include automated data loads and accurate and timely trend analysis

Aetna, Farmington, CT June 1992 – June 1999

External Financial Reporting

•Responsible for the preparation and analysis of financial reporting to NAIC, SEC and various state agencies (including Annual Statements (Blue/Green Books) and State Forms)

•Served as Team Captain for project to convert company’s accounting processes from using an in-house ledger system to Oracle General Ledger

Internal Financial Reporting 09/1992 – 07/1997

•Responsible for the preparation and analysis of accurate and timely Income Management financial statements on an actual and forecast basis

•Developed the Income Management Financial Database. This Hyperion based database served as the central source of financial information for the entire department and greatly improved the accuracy and timeliness of reporting

•Preparation and analysis of accurate and timely Annuity financial statements on an actual and forecast basis. Deliver analysis of unusual monthly trends through written and oral interpretation to all levels of management.

•Automated a profitability analysis report (Fixed Margin) for the Annuity Strategic Business Unit which allowed management to immediately assess the organization’s progress on a month-to-month basis

•Was part of a team which automated a manual-intensive, time-consuming voucher process into a one-step interface procedure. The implementation of this process dramatically improved the timeliness and accuracy of final reporting.

•Received 2 “Annuity Best” awards for efforts in the above areas

•Originally hired as a college intern, assisting in the preparation of monthly financial statements, running financial reports, updating projection grids, preparing closing vouchers and developing financial spreadsheets

•Simplified the process of creating the unit’s Income Statement package, allowing for more timely and accurate information to be presented to management for analysis

United States Air Force/National Security Agency August 1983– May 1987

Voice Analyst/Office Training Coordinator

•“Airman of the Month” Nomination – 6940 Electronic Security Command: (1984,1986)

•“Outstanding Technician Award” (1986)

•“Letter of Commendation” (2 in 1986)

•“Letter of Appreciation” (1984)

Education:

Central Connecticut State University, School of Business, New Britain, CT Graduated December 1992

Bachelor of Science in Accounting

Honors: Dean’s List, Business National Honor Society

Contact this candidate