ACTIVITY D.1: Support in the development of a master plan for an integrated system of internet support to important processes in the training and certification (such as competence exams, registration process, distant learning and testing, information sharing, etc.) and knowledge sharing via an interactive web portal for the profession and the practitioners.

 

Experts:

  • Fernando Paunero Alonso
  • Jesús Ródriguez Ortega

TWINNING

ENHANCING THE ACCOUNTANCY AND AUDITING PROFESSION IN EGYPT

Activity D: Information and Communications Technology

Day 1.- Master Plan first version revision

  • Deliver a final revised version

Mission D1.4 AGENDA

Day 2.- Terms of Reference document

  • introduction
  • index
  • scope, lots, bidding price

Day 3.- Terms of Reference document

  • bidding prices scenarios simulation

Day 4.- Terms of Reference document

  • funtionality. Keep working on description of the A&A registry app and portal.
  • high level definition of web forms to be included in the application. 

Day 5.- Conclusions

  • presentation of a first draft of the Terms of Reference document.
  • to obtain both the data centre infrastructure definition and the application functionality definition

Day 1.-Master Plan first version revision

  • Deliver a final revised version

Day 2.- Terms of Reference document:

  • introduction,
  • index,
  • scope,
  • lots,
  • bidding price.

Call for tenders

...
brief description of the procurement
specific administrative clauses document
terms of reference
...

Strictly bound to Egyptian regulation

...by example in Spain:

Terms of Reference structure

introduction
background
project functionality
duration of the project
budget
technical specifications evaluation criteria
technology transfer
confidentiality agreement
...
scope? 
how many lots?
detail?, duration?
budget: bidding price?

Terms of reference scope

Terms of reference lots

Lot 1: Infrastructure hw & sw & services

Lot 2: A&A registry application and portal development

Terms of reference bidding price

Lot 1: Infrastructure hw & sw & service

A

B

  • alternative
  • alternative (less expensive)

Terms of reference logical architecture

1

2

3

4

5

Terms of reference physical architecture

1

2

3

4

virtual servers farm

SAN

physical servers

Terms of reference physical architecture

1

2

3

virtual servers farm

SAN

physical servers

Day 3.- Terms of Reference document:

  • bidding price calculation exercise.

A&A architecture blocks

Rack 42U

1

Switches ethernet

2

VMWare farm servers

3

FC SAN switches 

4

SAN

5

Physical servers

6

A&A architecture blocks

Rack 42U

1

1 x Rack 42 U (PDU, KVM, 3KW UPS)

8.345 €

One rack unit is 1.75 inches (44.45 mm) high

A&A architecture blocks

Ethernet switches

2

2 x Switch LAN HP 5120 48G

14.668 €

A&A architecture blocks

Servers farm

3

5 x HP Proliant DL360 Gen9 8SFF Server (2 CPU, 256GB RAM, 2HDx300GB, 2x800w PS; 2 HBA ports)

62.750 €

A&A architecture blocks

Fabric SAN switches

4

2 x HP SN6000 16Gb 48/48 Fiber Channel Switch

96.940 €

A&A architecture blocks

SAN

5

1 x HP 3PAR StoreServ 8200 (24TB SAS, 3.84TB SSD)

78.570 €

A&A architecture blocks

Physical servers

6

3 x HP Proliant DL360 Gen9 Server (1 CPU, 16GB RAM, 2HD x 600GB, 2 500w PS; 2 HBA ports)

12.705 €

Day 4.- Terms of Reference document:

  • bidding price calculation exercise ( part 2).

A&A architecture blocks

VMWare licenses

7

MS Windows Server 2012 licences

8

MS Windows SQL Server 2014

9

MS Sharepoint Server 2016

10

Antivirus

11

others ??

12

A&A architecture blocks

VMWare licenses

7

  • vCenter Console (1 lic mandatory)
  • vSphere  ESX STD or Ent plus (1 lic per CPU)
  • NSX (1 lic per CPU)

69.715 €

A&A architecture blocks

Windows Server 2012

8

  • Datacenter or Standard (same functionality but virtualization rights)
    • Datacenter: 1 lic per 2 CPU no restrictions in VM
    • Standard: 1 lic per 2 CPU (VM only in physical server: no VM movements)

54.290 €

A&A architecture blocks

SQL Server 2014

9

  • Enterprise or Standard (main difference AA vs AP clusters)
    • Enterprise: 1 lic per core , AA cluster
    • Standard: 1 lic per core, AP cluster

60.400 €

A&A architecture blocks

Sharepoint 2016

10

  • Enterprise or Standard by server 
    • cal's std & ent

16.000 €

A&A architecture blocks

Antivirus

11

  • Kaspersky Endpoint Security for Business Core: Anti-malware, Firewall, App control, File servers, web control : 1 lic per device

13.750 €

A&A architecture blocks

Others ??

12

  • dev tools
  • digital content tools
  • payments services
  • mail services
  • sms services
  • ...

A&A architecture blocks

HW support

13

SW support

14

Install & config services

15

A&A architecture blocks

hw support

13

  • 3 years warranty
  • NBD: next bussiness day
  • 24x7
  • parts & labour

40.821 €

A&A architecture blocks

sw support

14

  • 1 year warranty
  • mail & phone support
  • patches & updates download

16.618 €

A&A architecture blocks

install & config

15

  • hw installation
  • firmware configuration
  • os installation and configuration
  • infrastructure services design
  • service installation and configuration
  • service integration
  • security services

86.916 €

A&A architecture bidding price:  A summary

A

A&A architecture bidding price:  B scenario

B ?

Terms of reference physical architecture

1

2

3

virtual servers farm

SAN

physical servers

reduce the final price but maintaining the design

Terms of reference physical architecture

     rack, eth switches, srv model

    one DNS server

cheaper SAN model

     cheaper SAN FC switches

just three vm servers

WS 2012 Standard lic

SQL 2014 Standard lic

        less int. connected users

  vSphere STD lic

less vm 

A&A architecture bidding price:  B scenario

B

Day 5.- Final review & conclusions:

  • Review A&B&C components outcomes by RTA.
  • Explaining documents to be delivered in this mission
  • Examples of EU ToR
  • Conclusions

deck

By YBK

deck

  • 1,412