Project Planning
Resume:
Professional Summary
Planning & Essbase Consultant who has personally worked on more than 50
Planning and Essbase implementations. Also a Hyperion design lead
certified Consultant with over 9 years of experience designing and
implementing solutions that have utilized the functionality of different
software packages, including the Hyperion and Cognos products. Currently
the OAUG Hyperion SIG Essbase Domain Lead.
Professional Experience
MindStream Analytics October 2009 - Present
Senior Partner
As the founder of MindStream Analytics I have participated in many
different activities, including project management and staff development,
development of sales collateral, creation of our consulting methodology as
well as the "hands on" development of projects. Some of my projects have
included:
Medical Device Manufacturer
Hyperion Planning Implementation
Managed a small team of consultants that were charged with developing a
completely customized SmartView application to replace Hyperion Planning
WebForms as well as replace the functionality of Hyperion Financial
Reports
Architected the custom solution
Performed customing coding that made up the custom solution
Pharmaceutical Consumer Products Company
Hyperion Planning Upgrade
Architected the upgrade to system 11 for an existing Hyperion Planning
customer, including the sunsetting of components such as Hyperion
Application Link and the transition to ODI
Guided client through project development with limited consulting
involvement
Titan - Pinnacle June 2005 - October 2009
Managing Director
In the role of Managing Director at Titan-Pinnacle I have created and
managed the Hyperion Planning and Essbase Practice overseeing a team of 17
consultants. Having started the practice, I have been personally
responsible for building the practice into a 7 million dollar practice with
17 employees. My responsibilities have included; helping to build the
Planning and Essbase team by finding potential new hires, helping the sales
team strategize, compose and present solutions to prospective clients
including writing RFP responses, leading projects, establishing best
practices, giving seminars, setting overall go to market strategies,
application design and validation and mentoring more junior consultants.
Some of my projects have included:
Lehigh Hanson
Hyperion Planning Migration to EPMA project
Took over project that was being mismanaged as well as lead technical
role
Led migration from existing Planning 4.0.1 to version 11.1.1.2 EPMA
Planning application
Designed and build all the technical flows dealing with EPMA and Planning
Time Warner Cable
Hyperion Planning Implementation project
Designed the Hyperion Planning application and Essbase reporting
environment
Designed Hyperion Planning customization for End User Web Form entry
Leading a team of consultants and internal resources through the
construction of the application
Chiquita
Hyperion Planning Implementation project
Designed the Hyperion Planning environment which will consist of 7
different Planning applications to support Chiquita's operational and
financial planning
The Planning implementation will also form the cornerstone of Chiquita's
Business Performance Management strategy
Leading a team of consultants and internal resources through the
construction of the application
Glaxo Smith Kline
Hyperion Planning Implementation project
Designed the Hyperion Planning application while helping the GSK team go
through a six sigma business improvement exercise and determining what
the software can help them with
Led a team of consultants through the construction of the application
Monster.com
Hyperion Planning Upgrade and Redesign project
Helped Monster.com redesign their Hyperion Planning application which
included complex data migration automation and application integration
with an in-house built resource planning application
Built the application integration and automation
Led a team of consultants through the construction of the application
First Marblehead Corporation
Activity Based Costing Essbase project
Designed and implemented an allocation model in Essbase that enables
First Marblehead to perform an initial Activity Based Costing analysis
Led a team of consultants through the construction of the application
Awarded second phase project for a more robust model, as well as
beginning to build a complete reporting environment using Hyperion's
System 9
Verizon Corporation
Financial Planning and Analysis Reporting Project
Managed a six month fixed bid project that automated the creation of the
various FP&A presentation booklets for senior management
Designed and created many automation functions for the various data sets
from multiple operating units that reported to corporate headquarters
ISA Consulting Aug 1998 - June 2005
Senior Consultant
As a Senior Consultant for Innovative Systems Associates my duties varied
from project management and mentoring of new consultants, by performing
application design reviews as well as teaching technical skills, to
designing and implementing technically challenging applications. During my
tenure at ISA I consistently grew customer accounts by achieving excellent
customer satisfaction. In addition I have been recognized for my hard
work, with awards for having the most billable hours. Some of the projects
have included:
Advo Inc.
Planning and Budgeting project
Designed a Planning and Forecasting solution in order to streamline and
simplify the Advo monthly forecasting process
Led an ISA team of consultants through the construction of the Planning
and Forecasting application, while tutoring a new consultant on Hyperion
Planning
Awarded second phase project for Forecast based on the success of the
first phase project
Edison Schools Inc.
Planning and Budgeting project
Based on assistance in a prior project was chosen for the Planning and
Budgeting redesign project
Led a redesign of an existing Planning and Budgeting solution in order to
make data entry and process flow more streamlined, due to the large
amount of Human Resources data that Edison wished to track within this
application
Medisys Health Systems
Planning and Budgeting project
With client support, grew a $60,000 proposal for a small Budgeting
solution into a $350,000 proposal to review budget processes and
implement a sophisticated budgeting application
Designed and Implemented the Planning and Budgeting solution for Medisys,
including a very sophisticated model that forecasts insurance
reimbursement for the Medisys Hospitals
Led a team from Medisys through the implementation of the Planning and
Budgeting system while training and tutoring the Medisys technical team
in how to administer the Hyperion Planning application
Puig North America Beauty
Administrative Expense Allocation Project
. Worked with the CFO and Vice-President of Finance to design and build a
Hyperion Planning application, which was used as a financial consolidation
tool as well as a budgeting tool
. Solely responsible for building the Hyperion Planning consolidation and
budgeting application which is used to streamline the flow of the
financial close, including generating journal entry amounts
. After implementation of the system I was engaged by the client to perform
their monthly financial close
Orix Financial USA
Administrative Expense Allocation Project
. Gathered an implemented requirements from Finance Dept for data mart
additions and Web enabled reporting which allowed Orix to identify and
reduce $390 million in bad debts
. Instructed future administrators how to use Web Application
Harry Fox Agency
ILS Reporting Project
. Customized all aspects of Cognos Upfront portal to provide seamless
integration with Business to Business web application. By doing this
Harry Fox was able to save a large amount of money by not having to build
an extension of their web application.
. Built reporting datamart structure and helped integrate Cognos LDAP
security with custom application LDAP security.
Park Place Entertainment
Financial Datamart Project
. Gathered requirements for additions to financial data mart. After
analysis of needs proposed and built an application to include Gaming
Commission data within the Park Place data mart so that business users
could compare their results with published results of competitors.
. Built various multidimensional cubes including Revenue Gaming cube to
show the profit per unit analysis.
Keystone Foods Inc
Planning and Budgeting Project & Weekly P&L Project
. Designed, developed, and deployed a Planning and Budgeting system in
Hyperion Planning.
. Proposed and designed a second Hyperion Planning application that
captured and reported a weekly P&L report. The weekly P&L application
reduced the preparation time of the weekly P&L report from 8 days to 2
days.
Horizon Health Care
Administrative Expense Allocation Project
. Gathered requirements from Finance Dept for expense allocations.
. Designed, developed, and deployed an automated system based on Hyperion
Essbase to allocate administrative expenses by products and market
segments, thereby creating a product and market segment P&L
New York City Board of Education
Data Warehouse Reporting Project
. Gathered requirements from management for reporting on existing Data
Warehouse data.
. Designed, developed, and deployed a web based reporting strategy using
Cognos OLAP tools.
Donaldson, Lufkin & Jenrette
Cognos Reporting Project
. Designed and Implemented Cognos reporting package for DLJ that enabled
them to analyze bonuses paid versus time spent of each project
PECO Energy
Electric deregulation project called Electric Choice
. Designed and developed automated reporting for Electric Deregulation from
a data mart, allowing PECO to forecast system load usage and constraints
. Participated in the design of the extraction, transformation, and loading
of data for the data mart
. Performed as a Team Lead, gathering requirements, laying out project
plan, and making sure goals were achieved for the Natural Gas Reporting
Project
PECO Energy
Cognos reporting for Supply Chain and Contractor Management
. Designed and developed Impromptu reports and PowerPlay Cubes to enable
the tracking of supplies for work crews to reduce the amount of wasted
materials.
PECO Energy
Impromptu reporting for marketing for electric deregulation
. Designed and developed an Impromptu reporting strategy for automated and
manual reporting that enabled PECO to focus their marketing efforts
during the electric deregulation.
Business Intelligence International 8/1997 -
8/1998
Analyst
BII developed a management philosophy that utilizes OLAP technology to
coordinate business metrics and measures to facilitate interdepartmental
communication. This enables coordinated decisions throughout a company.
This vision of a coordinated enterprise with data flowing through OLAP
cubes is being thought of as a crucial piece for companies trying to meet
the requirements of the Sarbanes-Oxley Act. BII has developed a business
simulation that illustrates its coordinated organization methodology. The
simulation is the heart of an intensive three-day workshop called the BI
University.
As an analyst in this small environment, I helped to develop and maintain
the business simulation as well as teach the three-day seminar. Clients
utilize the seminar to gain ideas for design in their own companies. After
the seminar, the analyst works with clients to facilitate the creation of a
design architecture that coordinates the clients' metrics. The
underpinning of this course is the book "24 Ways to Impact Your Bottom Line
in 90 Days".
Technical Skills
Reporting Tools:
. Hyperion Planning
. Hyperion Business Rules
. Hyperion Essbase
. Hyperion Application Link
. Cognos Impromptu Web &
Power Play
. Cognos Upfront
. Cognos Decision Stream
. Microsoft Analysis Services
Databases:
. Oracle 7.3, Oracle 8i
. Microsoft SQL Server
. Microsoft Access
Other:
. Cognos Script Language
. Java
. Java Script Language
. Visual Basic
. Visual Foxpro
. HTML
. Perl
. ASP
. Lawson Analytic Architect
Education and Certifications
Hyperion Planning Design Certification - 2004
Hyperion Planning Certification - 2003
Trinity College, Hartford, Connecticut
Bachelor of Arts; Major - History 1995
Awards
Top Revenue producer - ISA Consulting - 2004
Top Revenue producer - Pinnacle Group - 2006
Outstanding Service - Pinnacle Group - 2007
Leadership Award - Titan Technology Partners - 2008
OAUG Essbase Domain Lead - Current
Alexander H. Ladd
*****@*******************.***
Alexander H. Ladd
Contact this candidate