Online Carbon Neutral Donation interfaced with a new generic Payment Processing Engine

1
Online Carbon Neutral Donationinterfaced with a
new generic Payment Processing Engine

• As presented by
• Craig Murray-Hill
• BSD / IT / FIN
• District of Saanich

2
Table of Contents

• What How
• Concepts
• HL Architecture
• Carbon Neutral Donation Web App
• Payment Processing Engine
• Some Final Techy Stuff
• The Future
• Q A

Subjects
3
What is it?

• A web based application
• accepts Credit Card Payments
• used as donations
• funding community green projects
• by the District of Saanich

It is that to be for undertaken
4
Genesis

• Build an web application?
• Purchase Carbon Credits?
• Updates our Financial system?
• Provide Purchaser a donation receipt?
• Have it in a 2 months?
• Build a generic Credit Card Payment Engine?

Can we? and.. also
5
Concepts

• Donation Receipt to be generated.
• RAD (Rapid Application Development)
• Modular Architecture Black Boxes
• Phased Approach
• Team approach to Project
• 1 Tech Lead, 2 SW Developers
• Advice from Finance staff
• Champions verify requirements

Translates to
Leads to
6
Carbon Credits vs. Donations

• Had to consider
• Nominal Value
• Uniqueness of Tax Receipt
• CCRA Information
• Tax Bulletin IT-11OR3 Gifts and Official
  Donation Receipts
• Tax Policy CPS-014 Computer-Generated Official
  Donation Receipts

Issues became critical requirements
7
High Level Architecture
Donor
Moneris
Accounting
8
App 1 - Carbon Neutral Donation Web App

• Education ? of Carbon Neutrality
• Calculation ? of Carbon Footprint
• Donation ? captures Credit Info
• provides Receipt

Purpose
https//saanich.ca8443/webapp/cop/
9
Web Flow
10
Walkthrough - Start

• Starting Point
• Educational Content Definitions
• Quick Links, either
• Calculate!
• Donate!

Home Page
11
Walkthrough - Calculator

• Compromise between
• Ease of Use
• Accuracy
• Completeness

Carbon Calculator
12
Walkthrough - Donate

• Captures Credit Card Information
• Accepts values from Calculator or allows
  override
• Submits Purchase

Donate Page
13
E-Commerce Receipt

• Sent via Email only
• Email body contains required processing
  information

E-Commerce Email Receipt
14
Tax Receipt

• Official Tax Receipt
• Attached as PDF to E-Commerce Email Receipt
• Contains unique Tax Receipt ID
• Contains reference to E-Commerce Transaction

Tax Receipt
15
App 2 Payment Processing Engine
Purpose How? Connects to

• Supports any Purchasing Web App
• i.e. Carbon Neutral Donation
• Only accepts Credit Cards at this time
• HTML API
• Generic Database Design
• Error Correction/Reversal Algorithm
• Moneris e-Select Merchant Accounts

16
Design of Payment Processor
Moneris
17
A Transaction
Successful Purchase
18
Logging Capabilities
Files Database Info Logged

• Secure Text File for Carbon Neutral
• Secure Text File for PPEM
• Carbon Neutral Database Log Entries
• Processing Engine Database Log Entries
• At ever translation event
• Includes Timestamps
• Includes IPAddress
• End-to-End Tracing

19
System Requirements

• Java Application Server (JBoss)
• Must support secure sockets (ssh)
• Secure SSL Certificate
• Oracle Database
• Table conversion trivial to other types
• O/S Independent
• Was developed under Windows
• Moneris e-Select Merchant Account

20
The Team
C.Murray-Hill
N.Capron
R.Fuoco
P.Murray
W.Zhou
M.Boysen
R.Miller
T.Zeigler
21
The Future

• Packaging with JBoss for easy deploy
• PPEM Admin Interface
• Security Admin
• Review Transaction Info by non tech staff
• Online Receipt Re-Issue
• Transaction refunds
• POS interface

Phase 2 Phase 3 Phase 4
22
Q A
Questions?