Todd J. Binenstock

** ******* ***** ****

St. Louis, Missouri 63131

314-***-****

acoy7b@r.postjobfree.com

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