“We believe that Allegro ETRM, which can scale with the future growth of our business, offers a comprehensive natural gas solution which will enable a streamlined implementation and solid return on our investment. As PNG grows its asset base and our volumes increase, we need a fully integrated platform and tools that enable optimal decision making,”

Plains All American Pipeline, L.P.

System Administration Certification (ACP-SA) PDF Print E-mail

Allegro-University-LogoThe Allegro System Administration certification will assess your capabilities in key skills required by an Allegro System Administrator.

Exam Number: SA999 - Systems Administration Certification - Level I
Exam Price: $375 USD
Exam Registration: contact training@allegrodev.com
Duration: 4 hours
Format: Hands on using personalized testing database
Number of Questions: 11
Passing Score: 80%

Recommended Training and Preparation

This certification assumes you have experience, performing the duties of an Allegro 8 System Administrator.  This includes analyzing and resolving end-user support requests. The certification is provided as a series of Extension Specifications, providing requirements to be configured in your testing database.

(all course version 8.0 unless otherwise noted)

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

 

Exam topics

Extensions – Visual Model

  • Creating custom view groups
  • Creating custom views and panes
  • Adding panes to ‘system’ views
  • Configuring parent/child relationship of panes on a view
  • Configuring view templates with defaults and formatting overrides
  • Distinguish ‘sys admin’ views from the Allegro visual model metadata views
  • Advanced view configuration including dynamic columns, drilling, sorting, subtotaling, using Formula Builder and Linkview, pane visibility
  • Data validation via drop down lists
  • Configuring View Index for data filtering

Extensions – Data Model

  • Adding a custom table
  • Adding data columns to tables
  • Configuring primary keys
  • Configuring data constraints
  • Configuring constraints for parent/child display
  • Running database synchronization
  • Resolving synchronization errors

Extensions – Connect

  • Configuring an export out of Allegro
  • Mapping source and target data
  • Utilizing and verifying dataset XSDs
  • Configuring a data source
  • Exporting to flat files
  • Utilizing database views

Extensions – Messaging

  • Configuring “event-based” messages
  • Configuring “timer-based” messages
  • Identifying message recipients
  • Customizing data returned to recipient
  • Using bind variables
  • Using DB Expression to filter data

Grid Management

  • Configure grid servers
  • Configuring schedule procedures
  • Specifying frequency of procedure execution
  • Identifying appropriate worker type
  • Passing parameters to web service method

Security and Permissions

  • Adding new users
  • Creating security groups
  • Configuring group security – method level, table level, column level and criteria
  • Configuring approval process (including dynamic level assignment based on data condition)