IDEAS

by Wellpoint Systems Inc.

BEST PRACTICE SOLUTIONS FOR OIL & GAS OPERATIONS
     

Post Implementation Review Services

The Post Implementation Review Is Designed To Optimize The Effectiveness And Ensure User Satisfaction Of IDEAS As Implemented   The Scope Of This Review Will Vary But May Include Reviews And Training As Outlined Below  The Project Scope Is Determined And Agreed Upon In The First Step, Prior To Commencing The Work
1.  System Assessment And Scope Determination
1.1. Conduct User Interviews And Review System Through Dial-Up Communications
1.2. Determine And Document Scope Of The Review
1.3. Prepare Project Plan
1.4. Plan Review And Agreement To Proceed
2.  System Optimization
2.1. System Security Review
Review Security Related To MS/SQL And IDEAS
Review IDEAS Security Options Related to User Access and Segregation of Duties
2.2. Review Of Chartmaster Elements
Review Chartmaster Tables For Inactive and Un-used Elements
Verify That The Current System Configuration Allows For Sufficient Growth
2.3. Review Of Structures 
Verify Current Structures Are Properly Setup
Review For Un-Used Structures
Create Additional Structures as Required for Current And Future Reporting Needs
2.4. Review Of Data Segments  
Review the Current Segment Definitions For Outdated Or Unused Segments
Create New Segments To Meet Current And Future Reporting Needs
2.5. Financial Report Writer Technical Review
Review and Optimize Existing Report Specifications
Remove Un-Used Or Outdated Reports
Re-Organize Report and Cycle Naming Conventions for Clarity
Create Additional Report Cycles for Weekly, Monthly, Quarterly And Annual Report Groups
Standardize The “Look And Feel” Of Your Reports By The Use Of Standard Headings And Footings
2.6. Data Review
Review MS/SQL Database Tables, Stored Procedures, Triggers and Views
Remove Outdated Or Invalid Data Created By Views and Un-used Temporary Tables
2.7. Year End Processing
Verify That The Transaction Roll Is Setup Properly
Create And Verify Segments Are Properly Setup
Review Requirements for Reporting Of Prior Year Information
Update/Create FRW Reports To Show Prior Year Data
2.8. Budget Processes
Establish Data and Process for Budget Development
Prepare Spreadsheet and Pivot Tables With Next Year’s Budget information
Upload Directly Into IDEAS With Link
2.9.Review Networking Strategy as Applies To IDEAS
Review Terminal Server/Citrix Server Setup
Verify IDEAS Version
Review Client Workstation Settings
3 User Effectiveness and Productivity Opportunities
3.1. Leveraging ODBC Based Tools
Microsoft Access – Using Access To Download and Report  Financial Data
Crystal Reports – Understanding Seagate’s Crystal Reports and IDEAS Data Structures
Excel – Leveraging Excel for IDEAS Reporting and Analysis
SQL Views – Use MS/SQL Views To Facilitate Reporting
3.2. Understanding The Interface Between T4M And IDEAS
Using The FQA, Source, And Processed Folders
Copying Processed Journal Entries Back To Source
Interface Error Recovery
3.3. Using IDEAS Financial Report Writer
Using Reports To Create Journal Entries
Downloading Data To Excel
Advanced FRW Training For Specific Needs
3.4. Forecasting With IDEAS 
Implement A Forecasting System Using the IDEAS Financial Data Warehouse
3.5. Process Improvements from Further IDEAS-based Automation
iIDEAS -  Web Based Financial Management Solution
Fixed Assets Module Review
Allocation Module Review
4 Project Summary
4.1. Management Briefing -  Actions, Results And Benefits
4.2. Future Action To Be Taken By Client And IDEAS International
4.3. User Round Table Discussions – Potential Further Process Improvements