1 / 27

Information Technology Oil Sands Application Integration

Information Technology Oil Sands Application Integration. February 7-8-9, 2001. Application Integration. Applications List Corporate Supported : Remedy - Change / Problem Management & IT Billing System TAMS - Telecommunications Admin Mgmt System Oil Sands Supported:

ted
Download Presentation

Information Technology Oil Sands Application Integration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Information TechnologyOil SandsApplication Integration February 7-8-9, 2001

  2. Application Integration Applications List Corporate Supported: • Remedy - Change / Problem Management & IT Billing System • TAMS - Telecommunications Admin Mgmt System Oil Sands Supported: • IT Co-op Students - Information Technology Co-op program • AirTas - Accident Incident Report Trend Analysis System • MedGate - Occupational Health Centre Treatment System

  3. Application Integration Applications List Oil Sands Supported: • Traqs - Training Requirements & Qualifications System • Employee Directory - Phone Number / Picture / e-mail • WebHire - Resume Tracking System • MSDS (WERCS) - Materials Safety Data Sheets • Quikworks - Security Datacard system • Interplant - Process History Database (PHD) • OASR - Operating Area Shift Reporting • DOR - Daily Operations reports

  4. Application Integration Applications List Oil Sands Supported: • DPS - Daily Production Summary • LIMS - Laboratory Information Management System • SpRS - Suncor Performance Reporting System • OSSUNNET - Oil Sands Intranet • P3 - Project / Turnaround • Grand Master - Office / Building keys • Gas Key - Access keys for Gas pumps • Omnirim - Records Management System • ACD - Automated Call Distribution

  5. Application Integration Applications List Oil Sands Supported: • Applications Interfaces (See Diagram) • IT Application Training • loads of small Access Database’s

  6. Application Integration Remedy - Action Request System • Owner: Corporate Information Technology Department • Technology: Software package from Remedy Corporation using C with an Oracle Database. • Purpose: To manage problem call, service request tracking, change management and IT Billing both Company wide and locally . • Projects: Change Management fixes and standardization. Problem Management fixes and standardization

  7. Application Integration TAMS - Telecommunications Admin Mgmt System • Owner: Corporate Information Technology Department • Technology: Software package from Telus Corporation using MS Access front end with an Oracle Database. • Purpose: Tracks all telecommunications usage (phone, fax, cell) at Oil Sands/Sherwood Park. • Projects: Interface with Telus Interface with Employee Directory Interface with Action Request System

  8. Application Integration Information Technology Co-op Program • Purpose: “Cooperative Education" is a program that combines a student's classroom studies with paid work experience related to their major field of study. Most universities and colleges offer cooperative education degrees where a student is given the opportunity to apply their learned skills in the workforce. Term lengths vary from 8 months to 16 months. • Projects: Projects which students are currently involved in here at IT include new World Wide Web Technologies, NovaManage, Interplant, Oracle Financials, Maximo and various other exciting projects.

  9. Application Integration AirTas - Accident Incident Report Trend Analysis • Owner: Health, Safety and Environment • Technology: Developed for Suncor with an Oracle Database using Visual Basic, Java, DHTML, HTML, HSP, DCOM with a presentation through IE.4. • Purpose: Plantwide application for recording, reporting and analysis of ALL incidents and accidents. This includes things like unexpected power outages to the main computer room. • Projects: On going report development. Upgrading of Interfaces to Medgate and jeTECH.

  10. Application Integration Medgate - Occupational Health Centre Treatment • Owner: Health, Safety and Environment • Technology: Software package from MEDGATE using MS- Access on an Oracle Database. • Purpose: Records all on-site medical information for employees and contractors. • Projects: Replacement of current system

  11. Application Integration Traqs - Training Requirements & Qualifications • Owner: HRS&CA • Technology: Software Package from ATR using an Oracle Database. • Purpose: Maintains and updates training records of employees and contractors on-site. Assigns training to employees and some contractors, provides access to online training that has been assigned. • Projects: Upgrade to new version to overcome current data volume issues. Interface with jeTECH for employee information

  12. Application Integration Employee Directory • Owner: Human Resources Department • Technology: Internally development with MS-access and ASP for Web inquires using and an Oracle Database. • Purpose: Provides contact information on all Suncor Energy employees and Oil Sands contractors. • Projects: Company wide employee access with an Interface with Cyborg and jeTECH.

  13. Application Integration WebHire - New Hire tracking System • Owner: HRS&CA • Technology: Software package using an Oracle Database. • Purpose: Tracks career postings and applicants through the hiring process. • Projects: Development of Interfaces to Employee Information.

  14. Application Integration MSDS - Materials Safety Data Sheets • Owner: Health, Safety and Environment Department • Technology: Software packaged from WERCS using MS Access on an Oracle Database with web ASP pages. • Purpose: Provides material safety data sheet information in a web format • Projects:

  15. Application Integration Quikworks - Security DataCard System • Owner: HRS&CA • Technology: Software package from DataCard Canada Inc. using an Oracle Database. • Purpose: Provides identification cards to all employees and contractors at Oil Sands. • Projects: Upgrade from Oracle 16-bit application to 32- bit application.

  16. Application Integration Omnirim - Records Management System • Owner: Support Services • Technology: Software package from Omnirim Systems Auditing Corporation using an Oracle Database • Purpose: Tracks archived files that are stored in an off- site vault • Projects:

  17. Application Integration Interplant - Process History Database (PHD) • Owner: Suncor Energy Marketing Inc. (SEMI) • Technology: Software package from Honeywell • Purpose: Plant-wide customized off-the-shelf program that collects, monitors, manages, and delivers information and reports based on lab, process and manually entered data. • Projects: Upgrade from version 1.30 to 1.50. Upgrade operating system from OpenVMS to Windows NT

  18. Application Integration OASR - Operating Area Shift Reporting • Owner: Suncor Energy Marketing Inc. (SEMI) • Technology: In-house developed with an MS Access Database creating ASP web pages for OSSUNNET • Purpose: Provides shift end, daily and monthly area shift reporting information. • Projects:

  19. Application Integration DOR - Daily Operations Reports • Owner: Suncor Energy Marketing Inc. (SEMI) • Technology: In-house developed using MS Access database’s (8) to create ASP web pages. • Purpose: Provides information on the status of the Trucks/Shovels and the amount of work each is doing. Provides status of information from Extraction, Upgrading and Energy Services. • Projects:

  20. Application Integration DPS - Daily Production Summary • Owner: Suncor Energy Marketing Inc. (SEMI) • Technology: In-house developed using MS Access Database which creates HTML web pages. • Purpose: Provides information on Daily production volumes for Mining, Extraction and Upgrading of Tar sands. It also display Inventory level’s. • Projects:

  21. Application Integration LIMS - Laboratory Information Mgmt System • Owner: Laboratory Services • Technology: Software package from Honeywell using an Oracle Database • Purpose: Provides a repository of laboratory sampling data from around Oil Sands. Information is using to determine quality of products, air, on-site water, etc.. • Projects: Upgrade to newer release Upgrade from OpenVMS to Windows NT

  22. Application Integration OSSUNNET • Owner: Communications • Technology: Web Server using HTML, front page, Javascript and Vpscript-IIS. Contained on NT servers. • Purpose: Plantwide interactive communications tool that delivers company information and applications on a web platform. • Projects: * Upgrade platform to NT2000 with IE 5. * Transportation Web Site. * Electronic Bulletin Boards. * Standards of Business Compliance Web Routing * ‘In the News’ Web Site. * ‘Update’ Web Site (Oil Sands News Letter

  23. Application Integration SpRS - Suncor Performance Reporting System • Owner: Mining / Extraction • Technology: Internally Development using Oracle Database • Purpose: Provides a dynamic and soft-configurable reporting tool that can access any Suncor Oracle Database. The ‘reports’ can be created in MS-Excel and MS-PowerPoint format • Projects: Update project to re-design user interface for more intuitive navigation, ability to generate PowerPoint Presentations and upgrades to the KPI repository.

  24. Application Integration P3 - Primavera Project Planning and Scheduling • Owner: Site Wide Application guided by P3 Committee from business Units. • Technology: Software package from Primavera Corporation. Currently using a Btrieve database. • Purpose: Project Management software to manage resources, tasks and priorities. Features Project modeling, scheduling, resource and cost management, reports and graphics. • Projects: Upgrade to P3E (P3 Enterprise) with an Oracle Data Base.

  25. Application Integration Grandmaster - Office / Building keys • Owner: Supply and Services • Technology: Software Package from Omnicorp using Foxpro/Clipper • Purpose: Maintains a record of all keys for Offices, padlocks, buildings, etc. on plant site. • Projects:

  26. Application Integration Gas Key - Access Keys for Gas pumps System • Owner: Supply and Services • Technology: In-house developed using an MS Access database. • Purpose: Obtains gas pump usage for vehicle’s authorized for on-site fuel usage. • Projects:

  27. Application Integration ACD - Automated Call Distribution • Owner: Information Technology Department • Technology: In-house developed VB application using an MS Access database • Purpose: Application collects call information on all on- site phone usage. Monitors the activities at the Client Support Centre for abandoned calls, length of time people are on hold, etc. • Projects:

More Related