IT ARCHITECTURE AND IT SYSTEMS – PRESENT AND FUTURE

1. IT ARCHITECTURE AND IT SYSTEMS – PRESENT AND FUTURE MACEDONIAN CUSTOMS ADMINISTRATION – MCA MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

2. MCA PRIORITIES • Improve the collection of fees and the trade policy during import and export; prevent smuggling and offer uniform application of the Customs Code, faster release of goods during import/export and other procedures during which companies may be identified as trustworthy and representing a smaller risk in the course of performance of their duties to customs • Reflect both the government and the public opinion on effective control over prohibited goods, intellectual property rights etc • Ensure integrity and effectiveness in controlling the movement of goods and passengers, and offer a more effective data analysis for internal and external statistical use MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

3. IT STRATEGY AND DEVELOPMENT PLAN • The IT strategy and development plan are based, above all on the MCA’s strategy aims and on the complementary aims of the IT and other strategies of the Government of Republic of Macedonia. The same should enable definition of all entities, parties and participants in the Customs operations as well as enabling definition and automatic realisation of the functions between them. ICT is necessary and powerful tool used for automation and improvement of the Customs operations, acceleration and simplification of the Customs procedures in general MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

4. INTEROPERABILITY AND INTERCONNECTIVITY WITH EU CUSTOMS SYSTEMS • In the moment of accession in the EU, the ICT must meet all prerequisites related to the interoperability and interconnectivity with the EU IT systems and at the same time must ensure collection of all national and EU duties while not impeding the functionality in the flow of persons and goods. • The need of functioning of the ICT system within the frame and in direct correlation with the IT systems operating within the DG TAXUD frame is especially emphasised. MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

5. ORGANIZATION • HQ IN SKOPJE • 5 REGIONAL DIRECTORATES • 40 CUSTOMS OFFICES & BRANCHES, 40 CONNECTED IN MAKCIS • MAKCIS – MACEDONIAN CUSTOMS INFORMATION SYSTEM MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

6. MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

7. ICT DIVISION • DEVELOPMENT DEPARTMENT • PROJECT MANAGEMENT • PROGRAMMING • APPLICATION SUPPORT DEPARTMENT • APPLICATION SUPPORT • STATISTICS AND ANALYSES • HELP DESK • TECHNICAL SUPPORT DEPARTMENT • SYSTEM SUPPORT • USER SUPPORT • SECURITY MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

8. APPLICATIONS IN USE • CUSTOMS DECLARATION PROCESSING SOFTWARE (CDPS) • CUSTOMS SOFTWARE NOT DIRECTLY CONNECTED WITH CDPS • COMMON SOFTWARE MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

9. CDPS - ASYCUDA • ASYCUDA 1.17D - UNCTAD • CUSTOMS PROCEDURES: IMPORT, EXPORT, TRANSIT, TEMPORARY PROCEDURES, WAREHOUSING • RISK MANAGEMENT FOR SAD • HISTORICAL DATA MANAGEMENT • PARTIAL GUARANTEES MANAGEMENT MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

10. CDPS - ASYCUDA • NO POSIBILITIES FOR INTERCONNECTIVITY AND INTEROPERABILITY • CLIENT-SERVER APPLICATION – DEMANDS RESOURCES FOR MAINTENANCE • INSUFFICIENT SUPPORT FROM UNCTAD MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

11. CDPS • PREPARING/CHANGING MCA IT SYSTEM: • NATIONAL DOMAIN • INTERCONNECTIVITY AND INTEROPERABILITY WITH EU CUSTOMS SYSTEMS • DIFFERENT PROJECTS INITIATED MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

12. CURRENT PROJECTS • TRACKER APPLICATION – CONTROL AND LICENSING OF DUAL USE GOODS – • SW PROJECT – LICENCE, QUOTAS, INTEGRATED BORDER MANAGEMENT • NATIONAL TRANSIT SOLUTION • CUSTOMS RAILWAY SOLUTION – TTFSE II • INWARD PROCESSING SOLUTION MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

13. PLANNED PROJECTS • DECISION, PROCUREMENT AND IMPLEMENTATION OF NEW CDPS • FREE ECONOMIC ZONES • GUARANTEES MANAGEMENT MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

14. CUSTOMS SOFTWARE NOT DIRECTLY CONNECTED TO CDPS • IMPROVED RISK MANAGEMENT • NEEDS MORE DEVELOPMENT AND AUTOMATION WITH CDPS • DIRECTLY RELATED WITH CDPS IMPLEMENTATION • CURRENT DEVELOPMENT: CENTRALIZED APPLICATION FOR DAILY ACTIVITIES, SEIZURES AND VIOLATIONS MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

15. COMMON SOFTWARE • FOLLOWING NEW ICT TRENDS • LDAP, ACTIVE DIRECTORY • SIMPLIFIES USER MANAGEMENT • ICT SECURITY • STRENGHTENS NETWORK SECURITY AND ICT AUDIT FUNCTIONALITIES • PREPARING FOR PKI MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

16. NEXT ACTIVITIESnational domain • IMPLEMENTATION OF FULLY EU COMPATIBLE CDPS SOLUTION • WEB BASED, CENTRALIZED SOLUTION • FOLLOWING ITIL BEST PRACTICES MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

17. NEXT ACTIVITIESEU SYSTEMS • APPLICATION FOR NCTS • APPLICATION TO THE CONVENTION • DG TAXUD AWARENESS MISSION • TECHNICAL IMPLEMENTATION • CONFIRMITY MISSION • ACCESSION TO COMMON TRANSIT CONVENTION MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

18. ERP - solutionERP software - Enterprise Resource Planning software • Management tool for: • decision support • planning • optimization • controls MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

19. complex system of applications with more than 90 modules • designed using Microsoft technology • high level of customization • great platform for integrated business information systems • "turnkey" system of implementation: project, prototyping, installation, training, migration, activating, maintenanceandadditional development. MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

20. Outstanding capacity for decision support • real time balancing • on the fly AP/AR execution • capable warehouse and material management • drill down analytical tool • web based reporting • business planning • Process and document automation and easy collaboration with other systems • efficient business documentation processing • automation of complex calculations • bookkeeping automation • collaboration with other systems • Monitoring and work control • Workflow and Audit trail • User control • Traceability and quality control MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

21. Online, real time generation of main company reports • Compatibility to International Accounting Standards (IAS) • Balance sheet • Income statement • Trial balance • Cash flow • Financial indicators • Period comparison MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

22. Web based reporting • availability - anywhere, any time • powerful tool for mobile managers • following all necessary information for decision making - balances, business partners, plans, material documents • drill down movement on the links • analytical and control functions MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

23. Document management • comprises technological solutions that enable: • search • access • protection • management of documents MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

24. Output management (COLD - Computer Output to Laser Disk / ERM – Enterprise Report Management) • contains technological solutions for: • electronic capture • indexing • permanent storing of formatted output data (printed pages) in electronic format MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

25. MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

26. TRIPS™-Customs Managing Risk – Facilitating Trade MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

27. Government of Macedonia - Crown Agents Project • Project Inception Phase – October/November 2008 • “More that ten disparate “databases” (sub-systems) were identified during the site survey. The Customs Declaration Processing System ASYCUDA++ would seem to be the main Customs IT sub-system, but this uses an Informix database and the application is understood to be becoming potentially unsupportable.” • “It is essential that risk assessment techniques and selectivity are applied to ‘real-time’ declaration data, but as there appears to be a considerable technical challenge to using the TRIPS™ Risk module to interrogate real-time ASYCUDA data, it will be more feasible to continue to use ASYCUDA risk profiles to interrogate the real-time data, but to use the TRIPS™ Risk and Intelligence modules to allow the development and definition of those profiles.” • “MCA uses other locally developed applications written using MS‑Access, but this restricts the amount of data that can be processed and are considered to be bespoke applications written to achieve particular objectives.” • Such as:- • Intelligence database (MS-Access) • Seizure databases (various in MS-Access and Excel) • Management Information System (MIS) development stalled • ASYCUDA CDPS to be replaced MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

28. MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

29. TRIPS™-General Utilities/Features • Security – Oracle Internet Directory and SSO • Audit Trail (All modifications on all data Files) • Data Integrity • Search Facilities • Direct data entry on-line processing • Archiving • Reference Tables/Reports • On-line Help facilities MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

30. TRIPS™-Architecture & Technology Summary • N-tier / Service Orientated Architecture • Oracle Platform and ‘Fusion’ Middleware • Oracle Database Internet Application Server 10g • Browser Based Access (thin client) • Web Services • Oracle Portal and Single Sign On • Application Developer Framework (ADF) • Business Process Execution Language (BPEL) and Business Rules • XML Gateway & Publisher • Fully scaleable and Single Window capability MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

31. TRIPS™-Customs Operations/Intelligence • Suspicion Records Management: • People • Goods • Vehicles • Aircrafts • Containers • Vessels • Associations • Rummage • Attachments • Risk Information Reports (RIF) MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

32. TRIPS™-Customs Operations/Intelligence • Single Oracle Database • Integrated and associated records • Improved search facilities • Options to use TRIPS™ Intelligence module and Risk engine with any future CDPS • Ability to interface with other applications • BI Publisher tool for analysis and reports (RIF) • Compliance with industry standards including World Customs Organization (WCO) MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR

33. THANK YOU FOR YOUR ATTENTIONQUESTIONS? MACEDONIAN CUSTOMS ADMINISTRATION - ICT SECTOR