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 will centralize Financial Reporting, Budgeting, Forecasting, Strategic Modeling, etc. for a mutli-billion $$ conglomerate which is comprised of at least 30 companies.Internal Project Manager for a variety of EPMCS Application builds which include: Financial Reporting (FR & MR), Budgeting, Forecasting, Data Management, Identity Access Management (OCI & IAM), etc.

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 times averaging approximately 4 minutes.• 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.• Fine tuned Hyperion Report Mapping for the Planning to ASO cube maps and developing reconciliation tools for validation.• Primary Report Writer for Hyperion Financial Studio. Very high volume and worked with team to produce the Budget Books for Cook County Government.

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. Requirements for Hyperion EPM required the platform to meet Department of Defense (DOD) and Department of Energy (DOE) requirements for classified data.Infrastructure Support: Acted as primary liaison for Oracle Service Requests. Supported the Infrastructure lead in addressing Hyperion EPM technical issues and coordinated information from our weekly sessions to appropriate leads.Reporting: Support the Reporting lead as the primary Hyperion Financial Reporting Developer (HFR). Also conducted a presentation on HFR Advance Concepts At Kaleidoscope 2014

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 dependable platforms which improved performance, internal controls, business rule updates and validations.• 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 Health Business Summary.

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 Organization with a variety of statistical information for the management of human resources.

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 efficiency by approximately 300% as well as increased confidence in statistical reporting and budgeting.Compiled Hospital Budget for Year 2004.

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 well as revenues approximating 30% of entire business.Designed and developed an Excel payroll EDI model for the Service and Installation Departments that revamped internal control processes, streamlined payroll and job costing. This model reduced manual input and was adopted company-wide.

Ba, Business/Accounting

Board Of Governers, Accounting

Music And Business

Activities and Societies: Phi Mu Alpha