"With fuel oil representing up to 80% of our cost of doing business, we needed a state-of-the-art, transparent trading and risk management system to help reduce fuel costs, lock in margins and keep track of our physical and financial positions.”

PowerSeraya

System Administration Learning Path PDF Print E-mail

These courses are designed to provide the Allegro System Administrator the skills required to extend the capabilities of Allegro through data model, visual model, messaging and connect extensions as well as manage users and security access.

SA308 Business Process Validation

Participants will learn about Allegro’s Business Process Validation tool.  After completing this course, participants will be able to:

  • Configure and run process validations
  • Review and analyze process validations for errors
  • Identify options for validating the results of the process validations

Duration: 30 minutes

SA202 Grid Configuration

In this course, participants will learn how to use the Server Manager to configure an Allegro grid. Topics will include:

  • Defining the Allegro “grid”
  • Define the term “background process”
  • Configuring one or more application servers as the “grid”
  • Monitoring grid server activity
  • Performing grid server updates (deploying new Allegro release)
  • Reviewing and evaluating the grid log
  • Using Grid scheduler to automate process execution
Duration: 45 minutes
SA203 Security and Permissions

The Allegro architecture provides powerful features to allow the system administrator to secure the Allegro application. After completing this course, participants will be able to:

  • Apply an Allegro license key
  • Add new users
  • Create security groups and assign users
  • Define security at various levels including
    • View/function level
    • Table level
    • Column level
  • Apply criteria to restrict data access capabilities
  • Configure an approval process
Duration: 25 minutes
SA204 Process Manager and Real Time Valuations

After completing this course, participants will be able to use the Process Manager to:

  • Manually invoke position valuations
  • Schedule portfolio valuations using the Grid Scheduler
  • Define the difference between Summation and Incremental valuations
  • Configure the grid for real-time valuations
Duration: 35 minutes
SA211 Price Connect

In this course, participants will learn how to configure Price Connect to download market data from data aggregators including LIM and Global View, data reporting services such as Platts. After completing this course, participants will be able to:

  • Identify the data providers and aggregators supported by Price Connect (LIM, GlobalView, Bloomberg
  • Define the supported types of market data
  • Cross reference the data type supported by the various data providers/aggregators
  • Configure required parameters per vendor
  • Process data import per vendor
Version: 8.0
Duration: 90 minutes
SA211.1 Price Connect

In this course, participants will learn how to configure Price Connect in the Allegro 8.1 platform. After completing this course, participants will be able to:

  • Identify the data providers and aggregators supported by Price Connect (LIM, GlobalView, Bloomberg)
  • Define the supported types of market data
  • Cross reference the data type supported by the various data providers/aggregators
  • Configure required parameters per vendor
  • Process data import per vendor

Version: 8.1
Duration: 90 minutes

SA212 Exchange Connect

In this course, participants will learn how to configure Exchange Connect to view, execute and download transactions from ICE and exchanges utilizing Trading Technologies. (Currently only covers ICE.) After completing this course, participants will be able to:

  • Identify required information to configure ICE
  • Configure Allegro to interface with ICE
  • View downloaded ICE deals
  • Correct and re-process downloaded ICE deals
  • Configure automatic parameter downloads from ICE using the Grid Scheduler
Duration: 30 minutes
SA220.1 Credit Connect

In this course, participants will learn how to use CreditConnect to import credit rating and fundamental details from the Securities Information Retrieval Service (SIRS™) from vendor Interactive Data.  RM401 Credit and SA202 Grid Configuration are prerequisite courses.  After completing this course, participants will be able to:

  • Describe the connectivity between Allegro and (SIRS™)
  • Configure CreditConnect to import credit rating and fundamental data
  • Post a request to SIRS™ for downloads
  • Import requested data from SIRS™
  • Configure automatic imports using the Grid Scheduler.

 

Version: 8.1
Duration: 30 minutes

SA301 Extensions: Data Model

Participants will learn how to leverage the power of the Allegro architecture by extending the data model to capture customer specific information. After completing this course, participants will be able to:

  • Add a new table
  • Add columns to a table
  • Add foreign keys / data constraints
  • Create secondary, non-unique database indexes
  • Apply data model changes via the DB Sync process
  • Utilize database objects (i.e. database views/joins)
Duration: 25 minutes
SA302 Extensions: Visual Mode

Participants will learn how to leverage the power of the Allegro architecture by extending the visual model. After completing this course, participants will be able to:

  • Create new data views
  • Add new data panes to views
  • Add columns to panes
  • Default the visual model
  • Import and export the visual model
  • Configuring parent/child view relationship
  • Configuring user and System views
  • Configuring view templates
Duration: 100 minutes
SA303 Extensions: Messaging

Participants will learn how to create Allegro extensions using Messaging. After completing this course, participants will be able to:

  • Create message event classes
  • Generate event-based messages
  • Schedule messages via the Grid Scheduler
  • Configure “post event” procedures
  • Identify message recipients
  • Review and evaluate the message log
Duration: 45 minutes
SA304 Extensions: Connect

Participants will learn how to create Allegro extensions using Connect. After completing this course, participants will be able to:

  • Configure a connection dataset
  • Configure a data source (for import or export)
  • Build Connect procedures to
    • Import data into Allegro
    • Export data from Allegro
    • Invoke Allegro web services
Duration: 45 minutes
SA307 Extensions: Class Events

Participants will learn how to create Allegro extensions using Class Events.  After completing this course, participants will be able to:

  • Distinguish the various types of “events” in Allegro
  • Define how and when class events can be used.
  • Configure class events (3 exercises with the required code provided)

Duration: 30 minutes

SA401 Data Model: Natural Gas

Participants will learn the underlying  data structure and table relationships for business process involving natural gas which include:

  • Natural gas marketing
  • Natural gas retail
  • Liquefied Natural Gas (LNG)
Duration: 15 minutes
SA402 Data Model: Physical Logistics

Participants will learn the underlying data structure and table relationships for physical (petroleum) and bulk commodity (grains, metals, etc.) logistics.

Duration: 20 minutes

SA403 Data Model: Valuation

Participants will learn the underlying data structure and table relationships for valuation. Also covered:

  • Valuation views
  • Extending the data model for new valuation data attributes
  • How valuation data is referenced downstream of the valuation process
Duration: 35 minutes
SA404 Data Model: Power & Generation

Participants will learn the underlying data structure and table relationships for:

  • Power
  • Power Generation
Duration: 15 minutes
SA405 Data Model: Settlement & Fees

Participants will learn the underlying data structure and table relationships for settlement and accounting processes. Course content includes an overview of how settlement data flows through to accounting as well as defining the data structures for:

  • Fees
  • Financial tables
Duration: 35 minutes
SA406 Data Model: Workflow

Participants will learn the underlying data structure and table relationships for Connect and Messaging. Course content includes covers:

  • Connect
  • Messaging
  • Grid related processing
Duration: 20 minutes
SA411 Performance and Tuning

Participants will learn key steps involved in dealing with tuning the performance of Allegro. Course content includes:

  • Recognizing key areas of tuning
  • Understanding the Allegro architecture
  • Understanding the Allegro user interface (UI)
  • Performing SQL tuning (structure)
  • Performing database tuning  (query profiling)
Duration: 45 minutes