peoplesoft financial gateway duke energy s story n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
PeopleSoft Financial Gateway: Duke Energy’s Story PowerPoint Presentation
Download Presentation
PeopleSoft Financial Gateway: Duke Energy’s Story

Loading in 2 Seconds...

play fullscreen
1 / 33

PeopleSoft Financial Gateway: Duke Energy’s Story - PowerPoint PPT Presentation


  • 597 Views
  • Uploaded on

PeopleSoft Financial Gateway: Duke Energy’s Story. Presented by: Wes Huffman, IT Architecture and Project Management Brian Buzzard, PeopleSoft Application Support. Agenda. Company Profile PeopleSoft at Duke Energy Payment Processing Past and Present Implementing Financial Gateway

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'PeopleSoft Financial Gateway: Duke Energy’s Story' - creda


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
peoplesoft financial gateway duke energy s story
PeopleSoft Financial Gateway: Duke Energy’s Story
  • Presented by:
    • Wes Huffman, IT Architecture and Project Management
    • Brian Buzzard, PeopleSoft Application Support
agenda
Agenda
  • Company Profile
  • PeopleSoft at Duke Energy
  • Payment Processing Past and Present
  • Implementing Financial Gateway
  • Future Integration Plans
  • Questions
agenda1
Agenda
  • Company Profile
  • PeopleSoft at Duke Energy
  • Payment Processing Past and Present
  • Implementing Financial Gateway
  • Future Integration Plans
  • Questions
company profile
Company Profile
  • Over 150 years of service
  • Approximately 4 million customers
  • Fortune 500
  • $59 billion in assets
  • (as of 12.31.2010)
  • Stock dividends for over 80 years
  • Traded on NYSE as DUK
  • Dow Jones Sustainability Index
company profile cont
Company Profile (Cont.)
  • Total U.S. Generating Capacity:
    • Approximately 35,400 megawatts (owned capacity)
  • Size of Service Territory:
    • Approximately 50,000 square miles
  • Utility Customers (as of 12.31.10):
    • Total Electric – Approximately 4M
    • 500,000 retail gas customers
  • Generation facilities in North, Central and South America
company profile cont1
Company Profile (Cont.)

North American Generation Facilities

slide7

Company Profile (Cont.)

Duke Energy International Facilities

agenda2
Agenda
  • Company Profile
  • PeopleSoft at Duke Energy
  • Payment Processing Past and Present
  • Implementing Financial Gateway
  • Future Integration Plans
  • Questions
peoplesoft at duke energy cont
PeopleSoft at Duke Energy (Cont.)
  • Current State:
    • Release: Version 8.9 (Through Bundle 36)
    • PeopleTools 8.50
    • Database Platform: Oracle 11g on AIX 6.1
    • Web, Application, Process Scheduler (nVision/Crystals)
      • Windows 2008
    • Process Scheduler for Batch (SQR, COBOL, AE)
      • AIX 6.1
      • Cybermation ESP Scheduling Agent
agenda3
Agenda
  • Company Profile
  • PeopleSoft at Duke Energy
  • Payment Processing Past and Present
  • Implementing Financial Gateway
  • Future Integration Plans
  • Questions
payment processing past and present
Payment Processing Past and Present
  • Duke Energy’s payment process has evolved from a very customized, manual and deeply integrated process to one that exclusively uses Financial Gateway for electronic payments.
slide14

Payment Processing Past and Present (Cont.)

  • When PeopleSoft 8.9 was implemented, Duke Energy used a highly customized set of processes to integrate with the existing Mainframe architecture:
    • EFT payments produced by a customized version of the FIN2025 SQR to meet bank requirements
    • Check payment data extracted via custom process and sent to the Mainframe
    • Wire payment information produced using a custom Cobol process
payment processing past and present cont1
Payment Processing Past and Present (Cont.)
  • Following the merger with Cinergy, Duke Energy implemented Financial Gateway in conjunction with the previous process to:
    • Deliver a mechanism for sending ACH payment, Wire payment, and Positive Pay information to PNC Bank
    • Use delivered functionality for processing payment acknowledgement files
    • Provide a cost-effective solution for integration understanding the long-term goal of deactivating the Mainframe and PeopleSoft 8.0 applications
payment processing past and present cont3
Payment Processing Past and Present (Cont.)
  • When transaction activity moved from legacy applications in 2010, a project was chartered in conjunction to:
    • Setup new integrations using Financial Gateway functionality with new and existing banks not yet integrated for ACH payment, Wire payment, Positive Pay file, and Payment Acknowledgement file processing
    • Create a new process for capturing check information in an EDI formatted file and transmitting to the third-party check vendor
agenda4
Agenda
  • Company Profile
  • PeopleSoft at Duke Energy
  • Payment Processing Past & Present
  • Implementing Financial Gateway
  • Future Integration Plans
  • Questions
implementing financial gateway
Implementing Financial Gateway
  • Expected Benefits with Financial Gateway:
    • Reduction in maintenance and support costs by removing customized processes
    • Improvements in process efficiency by eliminating the need for manual intervention
    • Decrease in cost to implement by using standard file layouts and configuration
    • Lowered administration costs with user-friendly interfaces for managing payment information
implementing financial gateway cont
Implementing Financial Gateway (Cont.)
  • Duke’s implementations included:
    • An approach to use delivered file layouts for payment and acknowledgement files
    • Adding new and updating existing bank accounts for Financial Gateway settlement
    • Security for the Financial Gateway components for managing payment and acknowledgement information
    • An approach for file transmission that included Secured VPN connections and/or Secure File Transfer Protocol (SFTP)
implementing financial gateway cont1
Implementing Financial Gateway (Cont.)
  • The following challenges were encountered:
    • Bank layout requirements differed from the delivered layouts, but met NACHA standards
    • Bank requirements for processing electronic payments are different between institutions
    • Lack of delivered layout and functionality to support Positive Payment file processing
    • Third-party batch scheduling tool required custom processes to invoke delivered ones
    • Internal and bank requirements for file transfer were not supported by Integration Broker
implementing financial gateway cont2
Implementing Financial Gateway (Cont.)
  • Benefits realized include:
    • All regular payment processing is executed in the batch schedule without manual intervention
    • Payment administration boasts new simplified business processes for resolving payment errors and creating payment reissues
    • The ability to make payments through intermediary banks
    • Reduction in batch timings of over 17 percent
    • No post-implementation issues or defects relating to Financial Gateway
implementing financial gateway cont3
Implementing Financial Gateway (Cont.)
  • Lessons learned from implementation:
    • Initial account setup is critical for configuring the bank account integration
    • Integrated testing requires the majority of the time from the total project lifecycle
    • Bank layouts need to be reviewed early in the project to verify alignment with delivered layouts
    • The Payment Administration business process will change, but should be more efficient
implementing financial gateway cont4
Implementing Financial Gateway (Cont.)
  • Lessons learned from implementation:
    • Each of the banking institutions where Duke Energy has checking accounts requested Positive Pay information be delivered with the ACH and Wire payment files in the NACHA 828 format
    • Some banking institutions EDI file processors are setup and configured to produce different acknowledgement data
    • Creating new file layouts does not negatively impact delivered functionality and is easy to implement
agenda5
Agenda
  • Company Profile
  • PeopleSoft at Duke Energy
  • Payment Processing Past and Present
  • Implementing Financial Gateway
  • Future Integration Plans
  • Questions
future integration plans
Future Integration Plans
  • Even though there are no immediate plans for integrating with new banking institutions, Financial Gateway gives Duke Energy the ability to do so quickly and cost-effectively.
agenda6
Agenda
  • Company Profile
  • PeopleSoft at Duke Energy
  • Payment Processing Past and Present
  • Implementing Financial Gateway
  • Future Integration Plans
  • Questions
contact information
Contact Information
  • Wes Huffman
  • Wes.Huffman@duke-energy.com
  • Brian Buzzard
  • Brian.Buzzard@duke-energy.com
did you register through quest you are now a member continue the education all year
Did you register through Quest? You are now a member!Continue the education ALL YEAR:
  • Regional Education Conferences:
  • Northeast: July 20-21
  • West: Aug. 16-17
  • Midwest: Nov. 7-8
  • Online Learning Series:
  • Business Intelligence: May11-27
  • HCM: Aug. 9-25
  • Financials: Sept. 8-27
  • Upgrades: Oct. 13-27
  • Year-End: Nov. 3-15

Plus 200+ OnDemand Online Sessions

Save by using the member rate!

www.questdirect.org