Project Manager Management
Resume:
Todd J. Binenstock
St. Louis, Missouri 63131
***********@*****.***
Summa ry
Todd is a senior professional consultant with a unique combination of skills and experience in Business
Intelligence and Business Performance Management. He has worked for more than 20 years in consultant
and internal roles in the field. His experience includes the design, management, implementation and support
of multiple Business Intelligence systems. Todd is a Hyperion certified professional with 20 years of hands-
on experience developing applications using Hyperion Essbase and related Enterprise Performance
Management applications such as Hyperion Planning. Especially in Hyperion applications, successful
implementations can only be assured by experienced professionals with a strong track record of success.
Expe rience
I ndependent Consultant Februa ry, 2003 to Present
January, 2013 to Present
For Express Scripts, Inc., a Fortune 50 Pharmacy Benefit Management company, after merging with its
largest competitor and doubling in size to $100 Billion in annual revenues, Todd was responsible for
designing, implementing, testing and rolling out several Planning and Reporting systems. Todd architected
and led the development of a new Gross Margin Budgeting and Forecasting model which uses complex driver
based business logic to forecast all major components of client level covered lives, volume and gross margin
to support both annual budgeting and monthly forecast applications. Todd performed major modifications in
the Financial and Workforce Planning applications to streamline and optimize them for higher post-merger
data content volumes. Todd created an ASO database to replace existing payroll reporting database and
handle calculations and transformations necessary to feed Workforce Planning as well as greatly improve
query and reporting performance. Todd developed ODI interfaces to support automated metadata loads to the
Planning system. Projects also included developing calculations to align 2014 margin budgets with actual run
rates. Automation development included VBA programming of Excel templates for both Smartview and
Essbase add-ins as well as MaxL and Esscmd scripts. Software utilized was Hyperion EPM Suite Fusion
version 11.1.2.2, 11.1.2.3.5 and ODI 11.g.
August, 2011 to January, 2013
For Accenture Consulting at Ascension Health System, the nation’s largest not for profit Health Care
provider, as part of a system-wide rollout of new Oracle financial systems, Todd was responsible designing
and developing necessary changes for Hyperion Planning implementations for two already implemented
Ministries (metropolitan area hospital operating groups) and lead the design and implementation of an
expansion of the system for the entire enterprise, consisting of over 30 additional Ministries. Todd also led
integration testing and other quality and performance optimization efforts. Components designed, developed
and implemented include Webforms, Business Rules, Task Lists, security, etc. Hyperion Planning/Essbase
11.1.2.1 was utilized with ODI data and metadata interfaces on Unix servers managed by Oracle On Demand.
April, 2011 to August, 2011
For University of Texas – Medical Branch, the medical education and health care delivery branch of the state
university, Todd designed and developed multiple Essbase applications for employee and faculty workforce
and salary planning and allocations including dimension builds, data load rules and calculation scripts.
Essbase 11.1.2.1 was utilized.
December, 2010 to March, 2011
For Deloitte Consulting at Gilead Pharmaceuticals, a major pharmaceutical manufacturer and innovator, as
part of a complete financial retooling to Oracle products, Todd designed and developed various revenue and
manufacturing cost related allocations and related Oracle Hyperion Essbase (BSO) and Hyperion Planning
objects such as dimensions, calculation scripts, planning forms, business rules, etc. The system was Hyperion
Fusion Suite 11.1.2 running on Linux servers.
August, 2010 to December, 2010
For Aetna Insurance, Todd was responsible for working with users and support personnel to troubleshoot, test
and modify forms, calculations and business rules for the client’s existing highly complex driver-based
Hyperion Planning implementation designed to plan and forecast health insurance membership, costs,
premiums and margins. Todd also performed performance testing and developed automation routines to
enhance the supportability of the application. Environment was 64 bit version 9.3.1 using windows 2003
Server.
June, 2010 to July, 2010
For Guggenheim Financial Partners, an exclusive wealth management and advisory firm catering to wealthy
individuals, institutions and governments, Todd conducted a requirements discovery and analysis and
developed a Hyperion Essbase prototype for calculating and reporting revenues across all investment
management business units.
December, 2009 to June, 2010
For General Electric Transportation, a global provider of Locomotives, Rail Signaling and Marine Propulsion
products and services, Todd served on a project to implement multiple Hyperion products linked to a common
data store. As Functional Architect, Todd developed a conceptual design for the Common Data Store to
accommodate all data flow, transformation and storage requirements. As Essbase Architect, Todd was
responsible for the development of Essbase applications sourced from the Common Data Store via Essbase
Studio and Essbase Integration Services. Cubes Designed/Developed include Functional (Operational) Cost
Reporting, Accounts Receivable Reporting, and the design of a Sales and Orders reporting application.
Hyperion Suite version 11.1.1.3 Fusion Edition was employed for the project.
June, 2009 to December, 2009
For Asurion, the nation’s leading provider of mobile phone insurance and repair services, Todd was
responsible for the development and implementation of driver-based planning and forecasting applications for
the Supply Chain Management division. Applications were developed to support the expansion of Hyperion
Planning 9.3.1to the operating divisions. Freight handling and Customer phone support costs were modeled
using complex calculations as necessary. Todd wrote advanced allocations for customer profitability
reporting and developed partitions to combine area budgets for consolidated divisional and corporate
reporting.
March, 2009 to June, 2009
For Deloitte Consulting at Exelon, the northern Illinois electric utility and power generation company, Todd
developed, documented, tested and optimized processes and objects for the client’s Hyperion Planning 9.3.1
implementation including business rules, calc scripts, forms, MaxL scripts and partitions. Todd additionally
helped coordinate performance testing and the resolution of performance and other issues. Environment was
Hyperion Planning 9.3.1 on Sun Solaris UX.
March, 2009
For Oracle Consulting Services, Todd was asked to come into URS Corporation, a client experiencing
performance and other challenges with their very large Hyperion Essbase ASO (9.2.x) application. Todd
successfully tuned and optimized the application leaving the client in a position to roll out the application
with confidence. Server platform was AIX.
January, 2009
For Birks and Mayor, a Ft. Lauderdale, Florida based luxury jewelry retailer, developed a series of
calculations used to forecast future unit sales and revenues. Todd worked with the client to test and validate
these calculations, including implementing Todd’s suggested business logic improvements. Hyperion
Essbase 9.3.1 was the environment.
September, 2008 to December, 2008
For Express Scripts, Inc., a Fortune 500 Pharmacy Benefit Management company, Todd was responsible for
addressing various issues with the Hyperion Planning (9.3.1 Windows 2003) implementation including data
transfer and reconciliation, providing application stability and optimizing calculations/business rules. Todd
was also responsible for implementing business reorganizations in the reporting system.
May, 2008 to August, 2008
For Applica, Inc., a major manufacturer of small home appliances under such brands as Black & Decker,
Salton, George Foreman, and Windmere, Todd was responsible for leading the entire implementation of
Hyperion System 9(.3.1) Analytics (Essbase) on Red Hat Linux (Unix) for Corporate Financial Reporting
against Oracle Financials ERP replacing existing OFA (Oracle Financial Analyzer) system. Todd
simultaneously led a project to analyze the company’s planning and budgeting process needs. Based on this
work, the company plans to implement Hyperion Planning 9.3.1 (Windows) for development of the Fiscal
2010 Budget.
January, 2008 to April, 2008
For Yale University, developed and automated databases to help users analyze a critical $3 Billion dollar
multi-year fund raising campaign for this Ivy League bastion. Large database developed using Aggregate
Storage Option (ASO) including complex calculations in Oracle/Hyperion System 9.3.1. Designed and
developed Analytic Integration Services (AIS/EIS) schema for drill-through analysis and hybrid analysis
(OLAP/Relational) against Oracle RDBMS data store. Front end included Web Analysis and Workspace.
Additionally, developed analyses in Hyperion Visual Explorer (HVE)/Tableau.
June, 2003 to December, 2007.
For Express Scripts, Inc., a Fortune 500 Pharmacy Benefit Management company, Todd was responsible for
complete development of new applications from requirements to implementation. Todd designed and
developed a financial planning application to forecast gross margin and client profitability, using Hyperion
Essbase 7.1.6 and Microsoft Excel 2003 VBA. Other applications developed include Financial Expense
Forecasting (leveraging the previously built application), IS Financial Planning and Broker Commissions
Analysis. Todd implemented Hyperion Analyzer 7.2.5.4 including software installation and development and
deployment of Analyzer views and reports. Todd also improved and automated the update processes for
several existing applications to eliminate hours of periodic manual update time. Additionally Todd performs
all application maintenance and administrative functions such as software upgrades, system monitoring,
backup administration, user support, and problem resolution. Current Environment is Hyperion Essbase
7.1.6. Todd serves as technical lead in the company’s efforts to upgrade to Hyperion System 9 and implement
additional modules such as Hyperion Planning and Financial Reporting .
September, 2006 to Present
For Electrical Components International, Inc. a multinational manufacturer of wiring harnesses Todd helped
create a European consolidation database (including currency conversion), a sales analysis database, a sales
forecast and allocation functionality, as well as projects for database optimization and maintenance, among
other various periodic projects for this client.
November, 2005 to Present
For Insituform, Inc. an international pipeline repair technology company, Todd performs periodic
maintenance including upgrades and implementing production processes. Recently Todd upgraded
Insituform to Essbase 7.1.6.3.
August, 2005
For Christiansen Farms, Inc., one of the nations largest hog producers, Todd was called upon to resolve
problems that were identified to have been introduced via upgrade to Essbase 7.1.3. Todd identified the
software bug and created a workaround which added to usability and maintainability. Optimized other
applications and specified configuration for systems upgrade.
January, 2005 to February 2005
For Sara Lee Bakery Division, Todd was called in to augment a current consulting team to review, improve
and test calculation processes which are used to allocate forecast expenses to products and customers.
Environment was Hyperion Planning with Essbase 6.5.4.
March 2003 to May 2003
For Advance Auto Parts, a Fortune 500, national auto parts retailer, Todd designed and developed
modifications to existing Hyperion Essbase databases to enhance the analytical capabilities and significantly
improve performance of the application. The primary method utilized was the Essbase 6.x attribute
dimension feature. Advanced manipulation of dynamic calculations was required to achieve desired results.
Also designed and developed modifications to the companies forecasting application to include 3 year sales
trending by week and utilizing store attributes to vary forecast calculations. Environment was Hyperion
Essbase 6.5.3 on NT5.
ThinkFast Consulting, October, 1996 to J anua ry, 2003
Sr. Project Manager
March, 2002 to January, 2003
For Calpine Inc., North America's largest independent power generator, Todd led the development of the
company's Budgeting and Planning system as well as systems to support the analysis of actual financial
results, detailed analysis, and the integration between Budgeting, Forecasting and Actuals information. The
system utilized Hyperion Essbase as the core technology, while interfaces were developed to integrate with
the PeopleSoft source information for Actuals using Hyperion’s Essbase Integration Server tool.
Environment was Hyperion Essbase 6.2, EIS 6 running on Windows 2000.
July, 2002
For Advanced Micro Devices, a major manufacturer of computer chips and related products, Todd developed
a partitioning schema to enhance reporting capability by giving end users the ability to report plan and actual
data within the same report. The work was performed utilizing the Hyperion Essbase Partitioning feature.
Sales Consultant,
January, 2001 to March, 2002
Designed, developed and presented to customers various Hyperion Essbase and Hyperion Analyzer based
solutions to demonstrate company and software capability and provide proof of concept for understanding of
prospective client opportunities. All development performed in Hyperion Essbase 6.x and Analyzer 5.x on
Windows 2000 Pro.
Project Manager
July, 1999 to December, 2000
For a Sprint PCS, a major wireless telecommunications company, Todd led the design and development of
multiple Hyperion Essbase based applications. The Customer Care planning system extended the previous
budgeting and planning system to include the vital and resource intensive area of customer care. Applications
related to revenue and financial analysis were created to replace less functional versions existing in an Oracle
Express environment. Todd also led an effort to standardize definitions and
maintenance procedures throughout all reporting and planning applications. System interfaced data from
PeopleSoft ERP via Oracle Data Warehouse and Financial Data Mart. Environment was Hyperion Essbase
6.0 on Unix Server in production, NT 5 Server in Development.
March, 1998 to July, 1999
For Caterpillar Inc., a major manufacturer and distributor of construction equipment, Todd led the design and
development of an advanced and innovative application utilized for world-wide collection of consolidated
financial plan information as well as required explanation of variances. Todd also oversaw the integration of
the actual and plan data for comparative reporting. Application developed in VBA in Excel 97. Environment
was Hyperion Essbase 5.2 on NT 5 Server.
Senior Consultant
September 1997 to March, 1998
For Sprint PCS, a major wireless telecommunications company, Todd designed and led the development and
implementation of an enterprise standard excel-based user interface for budgeting and planning.
Multidimensional (Essbase) databases for driver based subscriber and revenue projection, financial expense
forecasting and human resource planning were developed as part of the system. Interface developed in VBA
in Excel 97. Environment was Hyperion Essbase 4.x on NT server.
July, 1997 to August, 1997
For a Life USA, a major life insurer and retirement benefit administrator, Todd developed a series of
allocation calculations required to calculate the desired profitability information for management reporting.
Envrionment was Hyperion Essbase 4.x on NT server
May, 1997 to July, 1997
For Western Resources, a major Kansas based energy utility, Todd redesigned and optimized various existing
databases, designed schema for consolidation and eliminations, and designed application to perform EVA
analysis. Environment was Hyperion Essbase 4.x on NT server.
February, 1997 to May, 1997
For Bosch Automotive USA, a major first-tier automotive parts manufacturer, Todd designed and developed
critical components of the consolidated business planning system, including modules to calculate and allocate
manufacturing expenses. Interface was VBA in Excel 95. Environment was Hyperion Essbase 4.x on NT
server.
March, 1996 to February, 1997
For Ralston Purina (Nestle Purina), a major manufacturer of pet products, Todd designed and developed a
financial consolidation and driver-based business planning and allocation system utilized to report and plan
brand profitability and SKU-level contribution margins. The application was created using Hyperion
Essbase. Application was developed in Hyperion Essbase 4.x on HP-UX v10 server. Templates and reports
developed in Excel 95.
Technium Consulting, Chicago, I L. J anua ry 1996 to October 1996
Sr. Consultant
January, 1996 to March, 1996
For Niemann Marcus, a major Up-Scale Department Store and Catalog operator, Todd designed, developed
and optimized various Hyperion Essbase databases in support of the company’s Catalog Planning project.
Todd’s work included designing, developing and testing advanced calculations to perform cost allocations to
individual catalog/product level. Environment was Hyperion Essbase 4.X.
May Depa rtment Stores, I nc., St. Louis, MO. July 1992 to December, 1995
Sr. Financial Database Analyst
Database Financial Analyst
For this Fortune 100, $13+ Billion National Department Store operator (now merged with Federated
Department Stores), Todd developed and administered various financial databases to assist 50 financial
analysts plan and report results. Lead selection team which selected Hyperion Essbase to replace Hyperion
MicroControl as standard software for Corporate Reporting, Planning & Analysis and Merchandise
Information Systems groups. Also Developed databases to support then subsidiary, Payless Shoe Source.
Environment was Essbase 3.2 & 4.1 on OS/2 3.x servers.
Certifications
Hyperion Certified Professional
Hyperion Certified Instructor
Todd has taught classes such as Essbase “Design & Optimization” and “Advanced Calculation
Techniques” as well as custom defined classes.
Education
B.S. Business Administration (Finance; Logistics & Operations Management)
B.S. Economics
Graduated Cum Laude from the University of Missouri - St. Louis
Community
2005-2006 President of the St. Louis Jaycees, a community service organization founded in 1915
2007 Chairman of the Board of Directors, St. Louis Jaycees
2007 to present, Director, St. Louis Jaycees Foundation
Contact this candidate