Transcript Anni DASHO MOF Treasury Presentation

ALBANIA MINISTRY OF FINANCE
TREASURY SYSTEM
Maech 2009
Albania Ministry of Finance Treasury
System, Anni DASHO IT Department
Director
1
Public Financial Management Cycle
Budget
Preparation
7
6
Audit and
Evaluation
0
Budget Review &
Fiscal Reporting
5
Mgmt of Budget
Authorizations
1
Commitment of
Funds
Debt and Aid
Management
Payments and
Receipts Mgmt
2
3
Cash
Management
4
Maech 2009
Albania Ministry of Finance Treasury
System, Anni DASHO IT Department
Director
2
AMoFTS Business Flows
The AMoFTS functional processes are classified as:

Budgeting
•
•

Procurement and Payment Management
•
•

•
•
Off-line FA management, FA journaling
On-line FA management, Asset Additions, Asset Transactions and
Depreciation
Accounting and Financial Reporting
•
•
Maech 2009
Revenue Accruals, Revenue Reconciliation and Distribution
Bank Statement Reconciliation, Cash Forecasting
Fixed Asset Management
•

Commitments and Purchase Orders, Expenditure Requests
Payment Execution
Revenue and Cash Management
•

Preparation of Estimates, Consolidation and Approval
Appropriation, Budget Breakdown and Budget Releases
General Ledger Accounting and Reconciliation, Period Closing
Fiscal Reporting
Albania Ministry of Finance Treasury
System, Anni DASHO IT Department
Director
3
System Functionality
Functionality
1- Macroeconomic forecasting
2- Budget Preparation
3- Core Treasury System
+ General Ledger
+ Accounts Payable
+ Purchasing / Commitment
+ Accounts Receivable
+ Cash / Fund Management
+ Financial reports
+ Org. Structure / Workflow Mgmt.
+ Asset / Inventory Management
4- Operational support for SUs
5- Internal debt management
6- External debt and aid mgmt.
7- Personnel database (HR mgmt)
8- Payroll calculations
9- Support for Auditing
10- Management Information System
Maech 2009
Common Implementation Options
LDS
LDS / COTS
COTS
Interface
Interface
Interface
Interface
with banking system (TSA)
with procurement agency
with revenue collection
with banking system (TSA)
Interface for spending units (LDS)
LDS
Interface with DMFAS
LDS / COTS
LDS
Locally developed reports
COTS
Albania Ministry of Finance Treasury
System, Anni DASHO IT Department
Director
LDS : Locally Developed Software
COTS: Commercial Off-The-Shelf Software
4
Oracle Financials Aapplications modules

Budgeting

General Ledger


Purchasing
Payables
Fixed Asset Management
Receivables
Cash Management

Financial Statement Generator

Spreadsheet tools
(PSB Spreadhseet Integration, ADI Spreadsheet Integrator)



Maech 2009
Albania Ministry of Finance Treasury
System, Anni DASHO IT Department
Director
5
AMoFTS SYSTEM ARCHITECTURE
Commitments
PURCHASING
EXTERNAL SYS
Bank Statements
Tax and Custom Revenues,
PO – Invoice matching
Expenditures,
Payments
Bank Reconciliation
Fixed Asset Journals
Inventory Journals,
PIU Reports
Health and Social Institute reports
Financial
Reports
PAYABLES
Asset Addition
GENERAL LEDGER
CASH MANAGEMENT
Reviews
Capitalization,
Transfers,
Depreciation,
FIXED ASSETS Retirements
Appropriation
Journal
Inquiries
Balance
Inquiries
Bank Reconciliation
(Non-Tax)
Receivables,
Receipts
RECEIVABLES
Maech 2009
Albania Ministry of Finance Treasury
System, Anni DASHO IT Department
Director
BUDGETING
6
Design and Implementation of Information Systems
 Secure countrywide Network infrastructure
 Development of Application Software
 Central Servers and field Hardware
 System and network management
 Technical support systems
 System safety / security and business continuity solutions
 Web publishing (web portal)
Maech 2009
Albania Ministry of Finance Treasury
System, Anni DASHO IT Department
Director
7
Design and Implementation
Treasury System Project Lifecycle 2000-2006
1. Design phase
(2000-2002 Sema Shlumberger Consulting Comany)
 High Level Functional Design: Legal and institutional framework
 Detailed Functional Design: Coverage, functionality, scope, budget
execution, budget classification, chart of accounts, reporting
 Technical System Design: Technical architecture, software,
hardware and networking requirements, implementation plan
 Component sizing and preparation of procurement specifications
1. Procurement phase (2003-2004)
International Competitive Bidding (ICB) for development of application
software (two-stage)
ICB for installation of hardware and network equipment
1. System integration and implementation (April 2005-2006)
Maech 2009
Albania Ministry of Finance Treasury
System, Anni DASHO IT Department
Director
8
Information and Communication Technology
Technology Architecture : 3-Tier Web-Based
Central
Hardware
1
MoF
Albania
Wide
Area
Network
2
2 DB Server
Internet
2 Application Servers
Web
Server
Collection
Point
(city center)
Dedicated
line
TDO Hardware
3
Treasury/MoF
District Offices
Dedicated
lines
Encryption
(3DES)
MoF Virtual Private
Network
Tunnelling
(IPsec)
District
Offices
PCs
Maech 2009
Firewall
Local
Server
Albania Ministry of Finance Treasury
System, Anni DASHO IT Department
Director
9
Treasury/MTBP Operations
Database Server
Application Servers
Web Server
System Center
User Terminals
Users
PFMS
COTS
Internal Access
Budget Preparation
DB
Core Treasury
System
•
•
•
•
•
General Ledger
Purch./Commit.
Accts Pay/Rec
Cash/Fund Mgmt
Fin. Reports
MoF, TDOs,
Line Ministries,
Central Gov Agencies
Asset/Invent Mgmt
Org/Workflow Mgm
External Access
LDS
HR Mgmt/Pers DB
Payroll Calcs.
Internal Audit
Maech 2009
Web Portal
Oper sup for locals
Interfaces
Int+Ext
Albania Ministry of Finance Treasury
System, Anni DASHO IT Department
Director
Local finance
directorates, local public
authorities, primarias,
public institutions
10
Albania : Treasury System > Public Financial Management System (PFMS)
Treasury > Integrated PFMS
External Users
GovNet
Reports
Line
Ministries &
Departments
P, R
Ministry of Finance
I
Council of
Ministers
Internet
&
Intranet
PFMS
Web Portal
Reports
Commercial
Banks
Reports
Bank of
Albania
TSA
I
Spending Units
Maech 2009
T,P,C,A
I
I
T, P
General Tax
Administration
General Customs
Service
Treasury / PFMS
System Center
FMIS + Business
Continuity Center
I
T, P
Treasury / PFMS
FMIS + BCC
I
T, P
Core Treasury
System
Macro Econ Forec
General Ledger
Purch./Commit.
Accts Pay/Rec
Cash/Fund Mgmt
Fin. Reports
SU interface
Budget Formul.
I
R
I
P, R
Statistics Institute
I
R
Other Related Gov
Agencies/Depts
•
•
•
•
•
•
ISSH & ISKSH
and Other
Revenue Org.
Public
Procurement
Agency
Debt Mgmt
Inventory Mgmt
Internal Audit
36 Treasury District
Offices
I
R
Local budget institutions,
public authorities,
municipalities, public
institutions
[ ~3,000 ]
MoF IT Dept
DoPA > HRMIS
HR Mgmt/Pers DB
Albania Ministry of Finance Treasury
Payroll Calcs.
System, Anni DASHO IT Department
Director
T
P
C
A
R
I
TSA
Transactions
Plans
Contracts
Accounts
Reports
Interface
Treasury Single Acct
11
Proposed Integrated PFMS Network Topology
FMIS + BCC
Treasury / PFMS
BCC
MoF/Treasury
Line Ministries
& Departments
Budget
Process
GovNet
F/O
conn.
Revenues
State Tax
Administration
State Customs
Service
Tirana
Other Revenue
Org.
Backup
F/O
conn.
Internet
access
Backup
ISDN
PoP
Bank of Albania
F/O
conn.
Audit
Treasury
Single
Account
DoPA - HRMIS
Public
Procurement
PoP
Albtelecom
IP Network
Internet
Countrywide VPN
PoP
Line Ministries and
Gov Agencies in Tirana
PoP
PoP
Other Related
Gov Agencies
Backup line
District #1
District # 1
TC
PSTN
District #2
District #2
TC
Maech 2009
All regional / local
offices
Regional
Treasury Office
Statistics Institute
F/O conn
PoP
Dedicated lines
(online connections)
Regional / District
Treasury Offices + Local
Governments
HRMIS
Data Exc
Internet
Procure-Payroll-IA
FMIS
+
Business
Continuity
Center
PFMS
System
Center
District #n
Albania Ministry of Finance Treasury
System, Anni DASHO IT Department
Director
TC
TC
District #n
On demand lines
(online/offline)
[e.g. Dial-Up or ADSL]
12
MOF and BCC Servers Description
Installation and Configuration
Maech 2009
Albania Ministry of Finance Treasury
System, Anni DASHO IT Department
Director
13

Database Servers Hardware Configuration
Servers Model : PW650
 CPU: 4 x SPARC64TM V CPU with 4 GB Memory
 I/O capability up to 3,2GB/sec.


Application Servers Hardware Configuration
Server Model : PW650
 CPU: 8 x SPARC64TM V CPU with 8 GB Memory


Software Installation
Operating System: Solaris 9
 Revision: Solaris9 09/04

Maech 2009
Albania Ministry of Finance Treasury
System, Anni DASHO IT Department
Director
14
IT Department Structure
Director
Anni Dasho
Sector for Help-desk
Integration of Financial Information
Sector for Maintenance and
Technical Support
Arta Kolnikaj
Daniel Maranga
Rajmonda Collaku
Sector for Processing, Retrieval and
IT Specialist (III-b)
Disara Muca
IT Specialist (III-b)
Krisela Kotonika
Adriola Faqolli (MSs 2009)
IT Specialist (III-b)
IT Specialist (III-b)
IT Specialist (III-b)
Odeta Kromici
Olger Thomaj
Ardit Sferdelli
IT Specialist (IV-a)
IT Specialist (IV-a)
IT Specialist (IV-a)
Astrit Sinani
Nikola Turlla
Isida Vasjari
Maech 2009
IT Specialist (III-b)
and Monitoring
Albania Ministry of Finance Treasury
System, Anni DASHO IT Department
Director
15