Scott Lebeau Email & Phone Number

Indianapolis, Indiana, United States

Currently overseeing the implementation of Oracles' Enterprise Performance Management (EPM) Cloud Services platform for The Heritage Group which is an innovative, values-driven organization with significant holdings in Transportation Infrastructure & Materials, Environmental Services, and Specialty Chemicals & Fuel Products.This highly complex engagement.

Greater Chicago Area

• Primary responsibilities involves the management of the Essbase Applications as well as the Hyperion Financial Reporting function. This includes providing solutions to complex business issues and stop-gaps.
• Enhanced the Mid-Day Data Refresh ODI Package. Original time performed at approximately 45 minutes. The new package developed (with technical assistance) improved performance dramatically resulting in data refresh.
• Created a new Budgeting Application to accommodate the new Argus Budget Project which was conducted in 2018. This application was greatly improved in areas of architecture, size with enhance ODI packages.
• Reduced System “Outages” from an activity level of approximately two to three occurrences per month to only 1 instance within the last nine months of the applications operations.
• Developed two new ODI packages for both the Metadata and Financial Data interfaces, which incorporated more transparency, ease of use and greatly increased overall “robustness” of the daily runs.

Chicago, Illinois

• Clarity Partners provides management and technology consulting services to a diverse mix of businesses in both the public and private sectors.Senior Hyperion Consultant
• Chicago Public Schools(CPS)Financial Data Management Enterprise Edition(FDMEE)/Essbase Administrator/DeveloperManaged and administrated all FDMEE and Oracle Data Interface workflows for four Hyperion Applications
• Developed Hyperion Planning Unit Reports utilizing SQL view statements which accessed the Hyperion Planning Data Source directly.
• Performed significant performance tuning and maintenance for the EPM Essbase servers which included trouble shooting, cache saturation and server cleanup.
• Cook County GovernmentPrimary Developer for the customization for Hyperion HCP, primary Report Writer (Financial Studio) for Hyperion HCP Reports and Hyperion Report Mapping.
• Developed, designed and implanted a custom concept involving creating a metric called “Financial Full-Time Equivalent” for the Hyperion HCP Module.

Naperville, IL

Solution Architect in an engagement for a Major Defense Contractor which included Hyperion EPM. Primary responsibilities focused on Hyperion Shared Services, Reporting, support for Planning and Infrastructure.Security: As Lead for Hyperion Shared Services, conceptualized, designed and developed the security function for Hyperion Planning Users..

Jacksonville, Florida Area

• Primary Reporting Developer for the Financial Performance, Reporting and Analysis team. Concentrated on the Operational Budget, DOL 5500 Reporting and Health Business Summary.
• Primary Administrator for the Operational Budgeting Database (Hyperion Planning). SME for Essbase/Smartview Excel add-on. Conducted Training Seminars for Hyperion Planning and Smartview.
• Developed and constructed a variety of Financial, Operational and Data Interface Models (Excel and Access), which source data for Internal Financial Reporting. The development of these ETL’s resulted in robust and.
• Worked on a variety of conversion projects which include: Hyperion Planning 9.3 to 11.1, two releases for the Hyperion Budget Application and Data Informatica Management (DIM) to Oracle Data Integration (ODI).
• Utilizing the Software Development Lifecycle, managed a wide range of ETL projects which processed data from multiple data source. These platforms covered such areas as Contribution Margin data, Forecast, Budgeting and.

Kansas City, Missouri Area

Integration Project at Sprint involving upgrade of PeopleSoft HMRS, Query and nVision.PeopleSoft 8.9 Upgrade Reporting and Query upgrade. Assessed and wrote functional requirements for nVision library. Assessed and migrated public queries.

Melbourne, Florida Area

Training Coordinator for PeoplSoft 8.8Harris CorporationAccounts Payable upgrade PeopleSoft 7.53 to 8.8. Wrote AP and Query manuals, assisted with testing, provided training coordination and conducted training seminars to a variety of security roles.

Jacksonville, Florida Area

Long-term Project engagement with Citi Cards Technology:Operational Reporting: designed, implemented and administrated reporting model, which tracked consolidation of Service Provider from multiple providers to single source provider.Constructed Headcount/Full Time Equivalent Access database model. This model provided the Executive and Management.

Blue Island, IL

Contract covered assignments in areas of statistical modeling, budgeting, salary & revenue analysis, payer mix and discharged not final billed analysis, month-end close, bank and account reconciliations.Process re-engineered Departmental Statistical Reporting Model (Excel Platform) utilizing EDI as well as advanced Excel functionality improving process.

St. Petersburg, FL

Wrote specific sections for SEC 10(K) Reports.Developed Excel Workbook with Essbase addin for Budget Forecasting and Actuals. The workbook was enhanced with Visual Basic functionality which utilized Essbase functions.

Palm Harbor, FL

Directed the Florida Regional Accounting Center. Established the Palm Harbor Regional Accounting Center, which required transitioning the Accounting, Billing, Accounts Payable and Payroll function for fifteen Profit & Loss Centers including three National Monitoring Centers. This activity encompassed over 2000 employees in a “high volume” environment as.

Ba, Business/Accounting

Board Of Governers, Accounting

Music And Business

Activities and Societies: Phi Mu Alpha