1 / 22

WELCOME TO

WELCOME TO. EXPORT COMMODITY DATABASE (ECDB ) Presentation by DIRECTORATE GENERAL OF VALUATION. OBJECTIVES. ·  A comprehensive Database on Exports focusing on Valuation. ·  Capture of export data in a standardized format on a daily basis from all customs stations.

lyre
Download Presentation

WELCOME TO

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. WELCOME TO EXPORT COMMODITY DATABASE (ECDB ) Presentation by DIRECTORATE GENERAL OF VALUATION

  2. OBJECTIVES · A comprehensive Database on Exports focusing on Valuation. · Capture of export data in a standardized format on a daily basis from all customs stations. · Consolidation and analysis electronically by DOV to identify potential cases of valuation fraud · Export Valuation Tool and Decision Support System. ·  Check abuse of export incentive schemes based on export value. · Check unscrupulous exporters going to smaller stations to overvalue goods. Compilation of statistical reports and returns concerning export valuation

  3. PHASE I ·        Essential data fields identified and standardised. ·         Software designed in consultation with NIC to extract export data from EDI stations. ·         Software installed at EDI stations for data extraction as EOD. ·         Export data transmitted to DOV from EDI stations via ICENET. ·         Data is merged at DOV into a single data source and unit values determined. ·         Display format in Access and designed query Module for easy access of data. Internet version was prepared and made available on DOV website in Nov 2004.

  4. www.dov.gov.in

  5. ECDB DISPLAY (Phase I)

  6. DATA ANAYSIS SOFTWARE ·         CDAC was assigned contract as per Ministry’s approval. ·         Technical requirement document was prepared by DOV. ·         Consultation with custom stations and feedback taken. ·         DOV interactions with technical teams set up in CDAC for software development. ·         Trials and evaluations by DOV. ·         Demonstrations to field officers at Mumbai Customs Zone. ·         Modifications based on feedback. ·         Final version is ready for launching. ·         Data analysis performed by clustering the raw data under selected set of fields for desired period. ·         Work out weighted average for each cluster and the standard deviation for each record within the cluster.   ·         Sum of Weighted Average and Standard Deviation for that cluster gives the value limit for determining outliers. ·         Outliers are marked for records whose Unit assessed value is outside the limit.

  7. SOFTWARE FEATURES ·        Consolidation of raw data. ·         Selection of raw data for analysis (period) ·         Selection of desired features such as description, HS Code, UQC, COD, Export Incentive Scheme Codes. ·         Description by keywords prepared by software based on data mining. ·         Clustering mechanism used for data analysis. Flexibility to choose various parameters for data analysis and DOV studies.

  8. FEEDING FILTERING MECH

  9. SENSITIVE COMMODITIES ·  Data analysis to be done for sensitive goods ·  Data filtering mechanism applied to prepare sensitive list ·   Selection of sensitive commodities based on: ·         DEPB Schedule numbers, ·         Drawback Serial numbers, ·         DFRC Serial numbers Entries having value cap and specific rates excluded ·  Selected commodities are grouped under HS Codes ·  Sensitive data selected as above is about 12% of export records.

  10. FEEDING CLUST MECH

  11. PERFORMING ANALYSIS ·         Data analysis performed by clustering the raw data under selected set of fields for desired period. ·         Works out weighted average for each cluster and standard deviation for each record within cluster.   ·         Sum of Weighted Average and Standard Deviation for that cluster prescribed as the value limit for determining outliers. Outliers are marked for records whose Unit assessed value is above the limit.

  12. OUT PUT ·Weekly schedule proposed for data analysis. ·         Analysed data displayed in MS Access and Oracle. ·         Query Module designed for and easy retrieval of data. ·         Analyzed data to be dispatched to EDI stations via ICENET ·         CDs with previous data of 3 months to all stations ·         Local databases to be set up by Customs Stations ·         ECDB also to be available on DOV website (password protected) ·         Display format provides all essential information arranged for case of reference.

  13. RESULTS OF ANALYSIS

  14. ECDB QUERY

  15. ECDB DISPLAY - I

  16. ECDB DISPLAY - II

  17. REPORTS

  18. DATA QUALITY ·         Incomplete description and using classification. ·         In many cases description of DBK / DEPB entries are reproduced. ·         Drastic steps needed to improve data quality for better results in data analysis. ·         Description and specifications in SB to be verified during admission. ·         Scrutiny and capture of missing information by Appraising Officers. ·         Verification at the time of examination to ensure all essential details. ·         Model/grade/specification. ·         Check HS (ITC) classification

  19. EQUIPMENT AND MANPOWER ·        Additional resources needed at DOV to maintain to ECBDB. ·        Manpower (1Group A, 2 Group B & 4 Group C). •     Server for data analysis and storage. •     Intranet Server for ICENET •     Webspace (8GB) for internet hosting PCs for staff.

  20. EXPECTED BENEFITS ·         Online access of analysed expert data to all departmental officers. ·         Improved quality of export valuation of live exports. •      Quicker identification of potential cases of valuation fraud. •      Better monitoring of working of valuation based export promotion schemes. •      Facilitates risk analysis, targeting and investigations of export related offences. •      Discourages exporters moving to smaller ports to over value goods. Provides reports and returns for economic analysis .

  21. ISSUES FOR DECISION •     Scheme for ECDB data analysis : clustering and marketing outliers. •      Principle for identification of sensitive commodities : goods entered for export under claim of DBK, DEPB or DFRC ·         Excluding cases having value caps and specific rates. •      Schedule for implementation of ECDB (Phase II and Phase III) •      Additional staffing and equipment required for ECDB.

  22. DOV • THANK YOU

More Related