Robert Gideon Email & Phone Number

Fort Worth, Tx, Us

Plano, Texas, Us

Major sports broadcasting network:Developed Data Exchange integrations to load actual financial data from Oracle Fusion ERP into their Planning application, along with file-based integrations. Integrated employee data for their Workforce Planning solution and assisted in data validation. Assisted with user training on Smart View, ensuring efficient usage and understanding of the system.Leading Jewelry Manufacturer:Implemented an Enterprise Data Management (EDM) application to manage and govern metadata across multiple Oracle systems, including Oracle Fusion ERP General Ledger, Oracle FCC, and Oracle Planning. Streamlined the client’s metadata processes by setting up approval policies for governance and using Data Integration Pipelines to automate the flow of metadata into downstream systems, improving data accuracy and efficiency.

Plano, Texas, Us

Restaurant and Entertainment business: Using Data Exchange in Oracle EPM, integrated data from three ERP systems: Great Plains, PeopleSoft, and WorkDayBiotech Company:In Data Integration, created a Jython event script to integrate data from WorkDay for Workforce planning. Created metadata loads in EPM Data Integration based on WorkDay files to build three different dimensionsCommunity-based Regional Bank: Optimized EDM application to manage three dimensions across five EPM applications (Planning and Enterprise Profitability and Cost Management). Created integrations to pass data between Planning and EPCM applications. Set up ARC data integrations for daily reconciliations. Built direct drill through from Planning and Smart View into GL transaction data stored in an on-premises database.Industrial tools and household hardware company: Migrated older Oracle Analytics Cloud Essbase applications to a newly installed Oracle Cloud Infrastructure Marketplace Essbase 21C instance. Documented Shadow Cube implementation using REST API calls and assisted client’s IT department in incorporating the technology to reduce downtime for users.

Plano, Texas, Us

Plano, Texas, Us

Plano, Tx, Us

Plano, Tx, Us

Plano, Tx, Us

Worldwide Health Services Organization:Integrated file-based data sources into an on-premises Planning application using FDMEE 11.1.2.4. Worked with the customer to define complex data mappings to transform from one chart of accounts to another. Created Windows batch scripting to automate the data load and file archiving process.Pharmacy Benefit Management Organization:Created integrations between on-prem HFM and Oracle EPBCS using FDMEE on-premises in a hybrid cloud deployment. Flat file integrations were also created using Data Management in EPBCS to load statistical data. Created integrations between Teradata and Oracle Analytics Cloud Essbase using the Essbase Command Line Interface with custom scripting. Assisted in converting hundreds of legacy on-prem MaxL scripts to work with OAC Essbase.Plastics Manufacturing Company:Implemented FDMEE 11.1.2.4 for over 70 integrations between MS SQL Server and Essbase/Planning applications. Created custom batch scripting to streamline FDMEE integrations. Implemented currency exchange with four constant currencies on BSO and ASO applications. Created custom email scripts to notify administrators of failures during FDMEE integrations.Property-Casualty Insurance Company:Installed FDMEE 11.1.2.4 in a hybrid cloud environment. Created FDMEE integrations between PeopleSoft and EPBCS Financials and Workforce modules. Created a fixed width, flat file export from FDMEE to aid downstream integrations from EPBCS. Large Healthcare Service Company:Implemented a custom project Planning application. Assisted in conversion from SQL server to Oracle database. Assisted in conversion from Windows server batch scripts to shell scripts on Exalytics. Created views in Oracle to support metadata and data loads through the Outline Load Utility and SQL load rules in Essbase.

Plano, Tx, Us

Dental Health Maintenance Organization:Installed Essbase and Financial Reporting version 11.1.2.3.500 and OBIEE 11.1.1.7.140527 in two new environments including the BI Mobile Application Designer. Sports Performance Equipment Company:Configured OBIEE 11.1.1.7 to authenticate with MSAD and integrated OBIEE into an existing version 11.1.2.2 EPM Workspace.Natural Gas Services Company:Installed Essbase, Planning, HFM, and FDM/ERPI version 11.1.2.3 and ODI 11.1.1.7 in three new environments. Configured FDMEE to integrate with Oracle E-Business Suite ERP.Capital Management Firm:Installed Essbase version 11.1.2.3 in high availability mode with clustered Weblogic deployments and OPMN failover for Essbase.Retail Health and Beauty Company:Wrote 250+ MDX formulas in an ASO reporting application. Verified the values tied to a Planning application. Optimized ASO application for retrieval.Global Building Technology Company:Programmed a Java Custom Defined Function for Essbase which performed data extracts by month and year based on user input from Planning Business Rule runtime prompt variables. Built custom interfaces in ODI to handle parallel file processing and integrating Planning data with SAP and back into an Essbase ASO reporting application. Major Software and Technology Services Company:Optimized Hyperion Planning implementation. Implemented best practices in BSO application design through Planning. Decreased storage requirements 77%, decreased calculation times 60%.

San Francisco, California, Us

Designed and implemented an Essbase solution that reduced calculation times from six hours to 30 minutes per day during the month end close process.Automated manual processes using the Essbase VB API and VBA toolkit to save financial analysts over 40 hours per month of manual manipulation of Excel reports.Developed custom applications to maintain Essbase hierarchies. Automated dimension building processes using Java saving eight hours per month in maintaining hierarchies. Created a separate application using the Essbase Java API to produce formatted metadata extracts to support downstream applications.

Ba, Information Technology

Ab, Computer Programming