John Di Palermo

  • Mamaroneck US-NY
John Di Palermo

Summary

Financial systems analyst and leader with 20 years of experience in both finance and systems.Results driven with the keen understanding of Financial Planning & Analysis, business requirements and financial systems.Expertise in developing, implementing and supporting end-user applications for financial planning, consolidation, reporting and business analysis.

Work History

Work History

Jun 2011 - Present

BI – Senior Hyperion Essbase Analyst

XL Group
  • Manage all phases of Project Lifecycle - requirements, design, development, implementation and ongoing maintenance - for Hyperion based Essbase Applications.
  • Identify and prioritize system enhancements and develop specifications for Hyperion Applications that meet business requirements.
  • Manage employees,and other external consultants spread over various locations in the day-to-day development and support of Hyperion applications.
  • Provide user support for Hyperion Applications and trouble shoot production problems.
  • Provide thought leadership to various Hyperion applications as well as to other BPM applications.
  • Identify, propose and apply new technology for enhanced services to improve Hyperion applications.
Jul 2010 - Jun 2011

Enterprise Hyperion Program Developer

Lockheed Martin

Working on a project to create complex allocation models for Corporate Finance.

Tasks include:

·Write business rules and calculation scripts.

·Build reports and dashboards.

·Provide expertise in software lifecycle process.

·Design and optimize Essbase cubes and Planning applications.

·Security administration and software upgrades.

·Migration of changes between non-production and production environments.

Nov 2008 - Apr 2010

Sr. Financial Systems OLAP Analyst

Canon USA
  • Administration of Hyperion financial consolidation, corporate dashboards and Hyperion System 9 Financial Planning system.
  • Enhanced, performed tuning and optimized Hyperion Essbase cubes and calculation scripts.
  • Hierarchy changes and update of substitution variables and business rules.
  • Developed and tested changes / enhancements to dashboard views, planning input forms and financial reports.
  • Security administration and software upgrades.
  • Migration of changes between non-production and production environments.
  • Supported monthly, quarterly and annual financial closing processes along with quarterly forecasting process.
  • Worked closely with other members of the FP&A team including finance teams in the business units, accounting, treasury and tax departments.
  • Maintained documentation on key systems and processes.
Nov 2006 - Nov 2008

Financial Systems Manager

Pernod-Ricard USA
  • Design and implementation of Hyperion Essbase planning and reporting systems, (including financial reporting internally and to corporate, state P&L's, budgeting and forecasting, etc) to provide management with information necessary in the strategic decision making process.
  • Worked with Director, Corporate FP&A to develop and execute ad hoc analysis as required by business situations.
  • Designed and implemented analytical tools to allow for better analysis of data for use in management decisions.
  • Control over harmonization of databases across the company and quality of data.
  • Training and development of finance employees and roll out of financial systems to non-financial employees.
  • Process redesign and improvement - sharing of best practices across company.
  • Finance representative on non-financial system project teams.
Mar 1997 - Mar 2005

Senior Financial Systems Project Leader

Kraft Foods, Inc.

Designed, implemented, and maintained Hyperion Essbase planning models to support 60 financial planning and business analysts in four company divisions.

  • Designed, developed and implemented financial planning and control processes and systems to support a large Financial Planning & Analysis group.
  • Conducted complex technical analysis to report on future and current financial performance, including analyses on budgets, forecasts, operating results, and business strategic plans.
  • Recommended technical solutions to users who made economic or business decisions.
  • Actively participated in and led continuous improvement initiatives and updating of budgeting and forecasting policies and procedures.
  • Remotely managed two junior system analysts - located in Chicago - to identify and execute new enhancements which would improve Hyperion Essbase and Planning applications.
  • Recipient of corporate award for four consecutive years for financial systems development and support.
  • Key member of team, which analyzed, identified, and implemented state of the art, user-friendly client-server software that replaced existing, mainframe based planning, analysis and reporting system.
  • Developed project plan and led 12-member cross-functional team in on-time, in-budget, system implementation.
  • Created models for two pilot divisions, lead development and implementation of automated data loads from multiple source systems, and collaborated in development of Excel front-end which reduced month-end close and planning process time.
  • Analyzed and implemented problem resolutions, reducing reoccurring systems problems, maintenance time, and improved systems utilization.
  • Designed, developed, and delivered technical training to 15 non-technical financial analysts which expedited system implementation.
Mar 1990 - Mar 1997

Financial Systems Specialist

Kraft Foods, Inc.

Managed data administration and financial planning models for corporate planning and analysis department.

  • Developed, enhanced, and supported mainframe planning and analysis models for corporate headquarters and division financial groups.
  • Provided systems support to divisions, including creating interfaces between mainframe and PC applications that increased planning and reporting productivity.
  • Implemented word processing system linking together PC's, a word processing department server and corporate network, improving electronic communication throughout organization.
Jul 1984 - Mar 1990

Senior Financial Analyst

Midland Montagu USA, New York, New York

General Instrument, Clifton, New Jersey

Bloomingdale's, New York, New York

Avon, Inc., New York, New York

  • Supported FP&A reporting month-end processes, monthly estimates, and annual Original Budget, Medium Range Plan, and other Strategic Planning processes.
  • Worked closely with corporate offices and business units to support the financial reporting and analysis necessary to meet their functional requirements.
  • Reviewed monthly forecasts, reports and variances.
  • Reviewed actual performance against authorized spending. Provided necessary guidance and management alerts identifying potential areas of exposure and recommending solutions to assess whether financial objectives were met.
  • Maintained financial reports and spreadsheets for the analysis of information.
  • Responsible for identifying improvement opportunities for our internal and external reporting and analysis requirements. Also responsible for managing projects to provide enhanced business solutions.
  • Performed process reviews, with various business units and departments, focused on the implementation of information access solutions to meet customer's business needs through the effective and efficient use of technology and systems capabilities.
  • Assisted in defining the strategic and managerial direction for information access and delivery activities geared towards the simplification of access and elimination of paper reporting with a focus on electronic information access and analysis.

Education

Education
Jun 1982 - Jun 1984

MBA

Pace Univeristy
Sep 1978 - Jun 1982

BBA

Pace University

Skills

Skills

Hyperion Suite of Products

Hyperion Essbase  Hyperion Planning Hyperion Reports  Hyperion 7x  Hyperion System 9  Microsoft Excel  Microsoft Word  Microsoft PowerPoint Microsoft Access

References

References

Richard DeSantis

Greg Konneker

Christian Betheuil