Spreadsheet: robin_rodrigue__33257__Activities
Sheet: t_04_Activity

ActivityCode | ActivityDescription | Definition | Hours for October | Employee Category | Cost Attributable to: | Driver
CF001 | Confirmations | *  Generating confirms *  [NAME] confirming with counterparty *  Following up on unexecuted confirms *  Reviewing and executing the confirm *  Selecting the correct confirmation template *  Evaluating the credit rating of the counterparty
[NAME] | Nymex Checkout | *  Verify Nymex positions and checkout daily
CF003 | Broker Checkout | *  Confirm broker deals verbally *  Verify broker statements against our systems
DS001 | Deal/Data Setup | *  Notification of new facilities, contracts, or counterparties *  Notify users of additions/deletions *  Entering deals including NYMEX, OTC, EFP, EOL, and Triggers *  Handing out or collection of deal tickets *  Gathering information *  Setup in global facilities, contracts, or counterparties databases *  Entering settled prices both manually and through automated downloads *  Adding economic terms of a deal to a system/slate
ES001 | Administrative Support and Ad Hoc Requests | *  Projects related to administrative work, ie data cleanup *  Preparing/generating reports *  Planning and budgeting *  Employee training, coaching, evaluation *  HR related tasks; recruiting, PRC, new hires, mentoring, etc.
ES002 | Non Routine Commercial Support and Ad Hoc Requests | *  Issue, resolution to traders' questions outside of daily operational issues *  Special projects related to commercial teams *  Preparing/generating reports | 15 | Analyst | Spread Equally among all Gas Regions. | Complexity of desk position, number of deals, number of traders.
ES003 | Customer Service | *  Tasks related to the EOL call center *  Communicating issues/resolutions with external customers outside of daily operational activities
ES004 | Data Control/Maintenance | *  Verify changes for facilities, contracts, or counterparties *  Maintain all official documents, both contracts and confirmations *  Process the change in the appropriate database *  Update/verify publications used to populate our database systems
ES005 | [NAME] to Actual (OA) | *  Reviewing liquidation report and resolving imbalances *  Reviewing liquidation report and resolving imbalances *  Phase I and II, identifying discrepancies between data captured at flash and at settlements both during the month and at the end of the month *  Verify customer data is correct from the OA variance report *  Verify internal information is accurate, ie systems are consistent *  Consolidating accounting data at an entity level for interface with Gas Accounting *  Analyze price and volumes (for PMA's, transport expense, imbalances, storage and synthetic storage by region by pipeline) *  Reviewing historical variances and making adjustments as needed
ES006 | Technology Maintenance and  Process Improvements | * System design, development, testing, implementation, and training * Set up and testing of pipes to EDI, using GISB standards * Identifying, coordinating, and implementing opportunities for improvements in our commodity processes * Production or user support (ie Unify, Sitara, Enpower, TAGG, etc) | 2 | Analyst
LG001 | Send Nominations | *  Prepare nominations; EBB noms, intraday noms, and renoms *  Sending the nom to the appropriate party (via fax or EDI) *  Receive the scheduled/confirmed volume *  Monitoring for any rejects *  Establishing, communicating, and confirming delivery instructions with buyers and sellers *  Receive invoices relating to product transportation to review economic terms (P&P)
LG002 | Receive Nominations | *  Receiving a verbal, fax, or EDI nomination *  Entering the numbers into the pipeline system, *  Confirming next day noms at meter/interconnect.
[NAME] | Balancing | *  Enter/update necessary deal tickets to reflect purchase, sales, and service activity (fuel,transport, imbalance,etc) *  Balancing pipelines, positions, etc. *  Ensure the facilities are balanced in UNIFY *  Ensure all transactions have transferred from SITARA to UNIFY *  Monitoring bridge activity to ensure Best Available Volume (BAV) information is properly fedback from Unify to [NAME] *  Resolve imbalance issues
LG004 | Standards Board Interface | *  GISB regulation, attending GISB meetings, lobbying for standards, etc.
RM001 | Calculating Books | *  Curve validation (perform rotation schedule for curves) *  Curve setup *  Calculating the books (both manual and automated) *  [NAME] sheets (price updates to deals) *  Issue, resolution to traders' questions *  Preparing/generating reports *  Dealing with all variances and issues that arise
RM002 | Routine Trading Monitoring and Reporting | *  Daily intelligence gathering, including pipeline information, position worksheets, storage levels, and any other data deemed critical or useful to traders/originators *  Monitoring day forward trades to ensure books are flat *  Monitoring trading activities (internal and external) *  Resolving issues that stem from trading (bridge monitoring) *  Reporting for daily, monthly, year to date, etc. trading activities | 600 | Analyst | Gas Regions | Number of traders on a desk
ST001 | [NAME] | *  Preparing and mailing invoices and payments; 3rd party and innercompany *  Process bank deposits *  Verbal verification *  Applying net outs *  Cash applications/Applying amount to Accounts Receivable (A/R)  *  Reconciling invoices and payments to our systems; reconciling any receivables *  Approving payments before submitting to A/P
ST002 | Cash Forecasting | *  Estimating current and future cash flows based upon current month activity, collection, and application
ST003 | Month End Closing | *  Preparing vouchers *  [NAME] journal entries resulting from volumetric adjustments *  Reconciliation of transport expense accounts, transport A/P, imbalance, unaccounted for, intercompany, fuel, usage, etc. *  Preparing mass drafts *  Accrual *  Interface with Gas Accounting *  Posting entries to SAP *  Interface UNIFY with SAP *  Reconciliation of data *  Daily downloads (purchases and cash feeds from the bank)
ST004 | Brokerage fees | *  Settlement of broker fees for all commodities *  Performing both verbal and written confirmations *  Comparison of broker statements with our records *  Margin calls for Nymex
VM001 | Allocate Quantities | *  Processing of quantity information for each contract for billing and payments *  Synchronizing of pipeline information with producer/market information *  Monitor for allocations to be contractually compliant *  Obtain allocations of meters not done by ENA or [NAME] and entering the quantities into POPS
VM002 | Reconcile Volume Discrepancies | *  Communicating volume discrepancies with counterparties, pipeline, scheduler, trader, or anyone else necessary to resolve discrepancy *  Reconcile differences in actual volumes and notify Settlements for correct billing/payments *  Reconcile unaccounted for report for HPL or any other on system pipes (ie Bridgeline, Denver, etc.)
VM003 | Monitor Physical Storage | *  Monitoring 3rd party deposits in our storage facilities *  Determining accurate charges (facility, buy/sell, demand, etc.) *  Sending schedules to appropriate parties and receiving statements of actuals *  Record actuals and resolve imbalances