CIS Application Overview

Bryan Enochs AT&T - Principal System Engineer
04/12/2018©2018 Appeon Limited and its subsidiaries. All rights reserved.

Presenter

Key Skills
Sybase, Oracle, PowerBuilder,Java J2EE, C#Bryan Enochs
Linkedin.com/in/bryan-enochs1725584
Twitter.com/Bryan_Enochs

Agile Scrum Master and LeadArchitect

Recent Projects
2018 – Currently building a large scale solution for a multi year
Federal Government Contract valued at $13B over 10 years.

2018 – State of California CIS Expansion to expand contract
services for the states 88,000 agencies.

Page 2elevate.appeon.comAgenda•CIS Summary•Why PB and Appeon•Key Volume Metrics•Key Functionality•Architecture•Technology Profileelevate.appeon.com

page3

Client InvoiceServices (CIS)• Client Invoice Services (CIS) is a mobile enabled, global application with servers in the USand England.
• Manages clients’ expenses through validation against thresholds, contracts and inventory
and applies payments of vendor invoices in country in currency for consolidated billing.
• Stores granular invoice detail and dynamic client specific information, and exports
appropriate data to accounts payable and/or billing systems.
• Uses a Business Objects reporting server and a flexible report writer for ad hoc extracts.
• Is front ended by our EDI gateway that enables automated importing and exporting ofvendor electronic data files, including EDI, CABS, XML and other delimited files.

• Processes approximately 300K invoices per month with 94% automation in support of AT&Tlarge business customers.

elevate.appeon.com

page4

Why PowerBuilderand Appeon?
AT&T has invested millions of dollars into this large scale application. It has been kept
current with versions, infrastructure and needed a mobile facelift.
It would have been too costly to rewrite our client/server app and we needed a ipad, iphonemobile enabled.
With support from Appeon and their partners, we made some minor changes across the app
and delivered a mobile enabled version within a few months.
Since this time, another large scale app called the Integrated Billing System has decided tomove forward with the same approach for their PB app.

elevate.appeon.com

page5

CIS Key VolumeMetrics
Average Annual Revenue Supported$X.XB% Automation

94%

Active Clients

350+

Active Vendors4,000+

Active Accounts

450,000+

Average Number of
Invoices Per Month

300,000+(Some invoices have 30000+ circuits)

Invoice Detail Lines Per Month

10,000,000+

Call Detail Records Per Month

25,000,000+

CIS manages large volumes of granular invoice detail data to meet custom
requirements for large mega deals.
elevate.appeon.com

page6

CIS Key
Functionality
External SuppliersInternal Billers

Vodafone, Telus, Optus, Allstream, Verizon, Frontier, Qwest,
Granite, Telco Malaysia, Singtel, BT, COLT, CZTel, EIRCOM, EMC,GTS, SWISCOM…

INVOICE

Onenet, CRIS, VTNS, DCS, Execubill, UB, GBP, ABOM, CABS, COBRA,OPUS, DPSS, UCC, Ccard..

CLIENT INVOICE SERVICES

VALIDATIONEDI Engine

Language Support

CDR LEVEL

Currency EngineRerating Engine

Validation Engine

Language Translator

VALIDATIONAuto Mapping Engine

Dynamic Setting Engine

PAY IN
COUNTRY
CURRENCY

Client Attributes

EU Privacy Compliant*

CUSTOM DATAAGGREGATIONDATASTANDARDIZERVALIDATION *INVENTORY

EXPENSEMANAGER
RECONCILE
EXPENSE TOREVENUE

Target Architecture Global Invoice Payment, Validation & Consolidation system delivering asingle, custom, consolidated global bill to the customer for all their Worldwide Telco Services!
elevate.appeon.com

page7

Page 8
11/7/2018

CIS System
Architecture

Scalable Cloud Based Servers
Production-Alpharetta / DR-Hayward Data Centers

Numerous Vendor EDI /CABS/EFILES (over 1000 filesper month)Payment Authorization
Payment Information

VERIFY RECEIPT

CFAS / Accts Payable

EDI Gateway Servers

Electronic Files using
Import Modules

Consolidated Billing details
with customized customer
specific information

US / Domestic Production
Billing Systems –ACUS/IBS/UB

Data Entry

Reporting Server

Data Archival &Warehouse Server
Backup Detail and Custom
ReportingProvisioning /Inventory Interfaces
for Validation
elevate.appeon.com

EMEA Server
Highfield House, Redditch England

page8

TechnologyProfileSystem Technology

Required Personnel Skill sets••••••••••High End Cloud Based Solution
HP DL580 G3 Windows Servers
HP-UX 11i OS and Windows Server 2012servers
Oracle 12GAppeon Mobile Enablement
PowerBuilder Enterprise 12.5 IDE
Microsoft ASP.NET Integration
EDI Server – EC Gateway, EC Real Time
Processor & EC Mapping Development
software (comparable to Sterling Gentran)
SVN Source Code management

elevate.appeon.com••••••Senior PowerBuilder / .NET Developers /AppeonLinux Cron / Shell scripter experts
EDI Mapping Specialists / Connect Direct
specialists
SQL Programmers – extensive T-SQLStored procedure/trigger developers
Data Modeling / Design Experts using
PowerDesigner
Oracle 12G DBAs with knowledge of PL –SQL and Administration
System Architects dealing with extensive
knowledge of large scale systems

page9