Why go for Centralized solution

1
8th National e-Governance Conference
Public Expenditure Management
Bhubaneswar, Orissa
3rd 5th February, 2005
2
Discussion Topics

• Issues Concerns
• Major Challenges
• Solution Option
• Proposed Functional Features
• Capacity Planning (Hardware, Network Sizing)
• Training
• TCS Offering

3
Issues Concerns

• Overdrawal of Funds
• Fraudulent Withdrawals
• Wrong Classification
• Non reconciliation of Accounts
• Delay in finalisation of Accounts
• Delay in settling the Claims

4
Our Aim..

• Effective Budget Control
• Comprehensive Receipts Expenditure
  Reports
• Compilation Classification of Accounts
• Elimination of Systemic Deficiencies

5
Major Challenges.

• Determination of the right technical Solution
• Capacity Planning
• Training
• Ensuring the required infrastructure
• Implementation till the lowest level

6
Solution Options

• Option I Decentralised Solution
• Option II Complete Centralised Solution
• Option III Hybrid Model

7
Decentralised Solution

• Time lag between passing of Govt. order and its
  implementation
• Inability of the Finance Dept. to reconcile the
  fiscal position in a given time-frame
• Payment details of treasuries not transparent to
  Departments/DDOs
• Time lag in getting a correct picture of funds
  flow
• Lack of computerization in sub-treasuries hamper
  consolidation in the parent treasuries
• Solution works without proper connectivity

8
Centralised Solution

• Requires proper network connectivity
• Facilitates timely implementation of Govt. orders
  and effective monitoring of the Budget Ceilings
  applicable to the concerned Departments
• Timely reconciliation of fiscal position
• Electronic reports showing payment transactions
  of treasuries available to Departments/DDOs
  immediately
• Reports will be available in both Push and Pull
  mechanisms
• Transparent view of funds flow with no time lag
  resulting in a proactive approach
• Better budget planning and administrative control

9
De-Centralised vs Centralised Solution

• De-Centralized
• Difficulty in maintaining the system in different
  locations
• Require more people resulting in high manpower
  cost in maintaining the system
• Difficulty in version control resulting in non
  standard approach across the treasuries

• Centralized
• Easy to maintain the system across all treasuries
  from the central location
• Require skeletal manpower resulting in
  substantially low manpower cost in maintaining
  the system
• Version Control will take place from the central
  location and hence standard practices can be
  implemented across the treasuries uniformly

10

• It is evident now that the Centralised, and not
  the De-Centralised, Solution is desirable to meet
  the objectives of Treasury Computerisation.
• But, What If, a proper network connectivity is
  not in place ?
• The Solution A Hybrid Model

11
Hybrid Model

• Partly using 2-tier architecture and partly using
  the proven 3-tier architecture
• 2-tier application would run in the treasury
  offices
• 3-tier application would be profile based and can
  be accessed through the Internet
• Instant MIS reports and status of any file / work
  would be available at DTA Head Office
• Finally, Smooth transition from 2 tier to 3 tier
  mode leading to complete centralised solution

12
Complete, Integrated Solution ?
A Consolidated Information Warehouse Database is
Required !
Treasury Management System
Budget Management System
Departmental System
Consolidation of Information Warehouse
But Integration ?
13
Complete, Integrated Solution ?
Budget Management System
14
Proposed Functional Features

• MODULES
• Budget
• Treasury
• Department
• DDO
• Consolidated Treasury Data Repository
• USER REQUIREMENTS
• Fund Monitoring
• Budget Monitoring
• MIS Reports
• Compiled Account Financial Reporting
• Salary and Pension Payments
• Bills and Challans Processing
• Interface with AG, Bank and Commercial Tax Dept.

15
Capacity Planning
16
Hardware Sizing

• Review Application and System Architecture, and
  Workload
• Establish a Reference Measure for Sizing
• Estimate Workload
• Build CPU Sizing Model for Online Processing
  (Application and DB servers)
• Estimate RAM and Hard Disk Size requirements
• Review Batch Processing Requirements

17
Network Sizing

• Create and validate network baseline model
• Capture network traffic
• Review Batch Processing Requirements
• Evaluate design alternatives
• Estimate Network Bandwidth Size
• - number of concurrent users
• - operational profile of users
• - transaction rates
• - the web interactions per transaction
• - the size per web page
• - response time requirement
• - kind of security imposed

18
Training

• Basic Computer Training for all end users
• Conduct Orientation Workshops
• Application training for the users of different
  operation profile
• System Administration training to a select group
  of officials
• User Manuals for ready reference

19
TCS Offerings - CTMIS

• CTMIS ensures Integrated Planning and Control
  over expenditure and revenue
• Internet enabled Complete Solution for
  formulating and executing the Government's
  treasury functions
• Enables a Long-term, Open Architecture,
  Flexible technology for transparently managing
  Govt. Finance
• Smooth transition from 2 tier to 3 tier mode
  without affecting user interface in case of
  adopting Hybrid Model

20
TCS Offerings - CTMIS

• Centralised architecture ensuring IT management
  at single location
• Fully Integrated Modular Design allowing
  deployment in phases
• Treasury module can be deployed across multiple
  treasuries
• Data transfer across Modules will be seamless
• Integrated workflow support
• Integrated Application offering a Uniform Browser
  Interface, Minimal requirement of user training
• Decision Support Tools (OLAP) supporting Adhoc
  Analysis
• Security and control With SSL
• Interface facilities with Banks / AG office
• Audit Trails on sensitive tables

21
For Further EnquiriesS K Bhattacharya,
TCSe-mail syamal.bhattacharya_at_tcs.com
22

• Thank You