Peter Lenz Email & Phone Number

Stamford CT

Milford, CT

Supervising team of three – Systems Analyst, Senior Programmer and Senior Developer – and reporting to Senior Director, Business IntelligenceProviding day-to-day production support for wholesale and retail reporting solutions along with requirements gathering and translation into technical specifications for development. Support 400-member user.

Milford, CT

Developed, administered and maintained Hyperion Essbase systems consisting of ASO & BSO technologies for North America and worldwide corporate entities for balance sheet, income statement and statistical data.Supervised team of three along with coordinating with regional teams to ensure Essbase applications were meeting expectations.Liaison between global.

Milford, CT

Developed and managed several Block Storage (BSO) cubes for Brand, Customer, P&L and Expense Analysis. Lead administrator for implementing new business requirements, overseeing routine maintenance and resolving common Essbase issues across the multi cube platform.Developed and maintained reports using Hyperion Reports, Web Analyzer, and Excel add-in.

Stamford, CT

Led conversion of North America’s Hyperion OLAP Financial Planning and Reporting System to Essbase; streamlined reporting and reduced market roll-ups from 35 to 2 and brand roll-ups from 50 to 4.Identified need for and implemented new communication process to reduce resubmissions from 75% to 10% and load times from 5 days to 1, significantly improving.

Shelton, CT

Automated monthly G/L extract process between SAP and Hyperion Enterprise utilizing system tools which reduced processing from 75 to 30 minutes.Converted historical data from local currency to Euro’s for EU countries for comparative reporting.Identified need and developed Hyperion Enterprise training session that educated 40 finance members with an 80%.

Shelton, CT

Created automated P&L’s using PILOT reporting system, reducing monthly processing time by 50%.Teamed with senior management during budget process developing budget book information which resulted in timely publication of annual budget book and loading of SAP for data comparison.Furnished senior management with timely and accurate analysis for monthly.

Stamford, CT

Developed Adaytum Planning System for North America; including creation, distribution and training of end users in customer marketing and finance models. Efforts reduced manual intervention by 60%.Created automated monthly internal reports and formats for senior management, end users, IMC’s and S&S that reduced report generation to less than 1.

Master Of Business Administration (Mba), International Business

Bachelor Of Science (Bs), Accounting