Financial Project
Resume:
JOHN DIPALERMO
Mamaroneck, New York 10543
Home: 914-***-****
Cell: 914-***-****
Personal E-mail: ***********@*******.***
Summary of Qualifications:
Financial systems project leader with 20 years of experience in both
finance and systems with Fortune 100 finance, consumer products,
electronics, international banking, and retail companies. 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.
Experience:
Canon USA, Lake Success, NY November 2008 - November 2009
Sr. Financial Systems OLAP Analyst
. 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.
Pernod-Ricard USA, Purchase, NY November 2006 - November
2008
Financial Systems Manager
. 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.
KRAFT FOODS, Rye Brook, New York 1990-2005
Senior Financial Systems Project Leader (1997-2005)
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.
Financial Systems Specialist (1990-1997)
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.
Additional Relevant Experience:
Senior Financial Analyst 1984-1990
MIDLAND MONTAGU, USA
GENERAL INSTRUMENT, Clifton, NJ
BLOOMINGDALE'S, New York, NY
AVON, New York, NY
. 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.
Skills:
Hyperion Essbase, Hyperion Planning, Hyperion 7x, Hyperion System 9,
Microsoft Excel, Word, PowerPoint.
Education:
MBA, Marketing and Information Systems, Pace University, New York, NY,
1984
BA, Finance, Pace University, New York, NY, 1982
Contact this candidate