|
New Data Preparation (NDP)
project is based on serving a big enterprise Client of
Anurakti Solutions in the Logistics & Transportation domain. The Client as a large
Enterprise maintains/has access to large number of warehouses across the geography and
maintains their related profiles to provide best of services to its Customers. As part of its
Service offering the Client has shipment data details coming from its numerous Customers
along with the goods to be delivered to designated locations. These shipment data details
form quite a voluminous amount of data coming from disparate locations and in disparate
formats. This requires quick & efficient handling of the information as part of the complete
business process, in order to deliver High Quality services to its Customer’s.
NDP is a project aimed at merging these disparate Customer data files related to
shipment details coming from various Customers, in different formats, & from different
locations, into a standard format for processing in the NDP application’s Core module.
This Core module is powered by the Informatica ETL tool which communicates with Oracle
Database at the backend, as well as its internal SAP CRM interface and other 3rd Party
interfaces in XML.
Serving the Core module, is a GUI front-end that is used by Client’s Administrators,
its Customer’s or Customer Service Representatives (CSR) for activities like New Customer
planning, Account / Profile management activities, Value added services configurations,
Reporting / Notifications configurations, and other general configuration settings.
This GUI is developed in Sun ® Java technology.
The Core module performs the tasks of pre-Processing, Extracting, Cleansing, Transforming
& Loading the Customer’s data into the main database before any further processing can
be performed on the data. As part of the Core module’s pre-processing process, it needs to
Extract data files from each Customer’s site, retrieve its processing instructions as
configured by the Customer, preprocess the data in the Customer data file and determine &
perform value added-services related to the data preparation. Thereon the processed data
is feed into the Core modules main workflow that Transforms it into a Standardized format
and then Loads it into the main Database for further processing.
The GUI primarily provides a user-friendly front end to Customer metadata information required
to process the input files to the main ETL workflow. The metadata information includes things
like Setting up FTP file pickup locations & Connection details, Receipt confirmation settings,
any Encryption / Decryption or Compression / Decompression settings if required, the File Type
settings, Carriage Return / Line Feed settings, Checksum settings and other profile information &
settings. These settings are updated to the backend database through the Web GUI and there on
accessed by the ETL workflows to perform the necessary operations as part of the complete business process.
Based on the expertise of our Techarts in Sun's Java technology & Informatica Powercenter ETL tool,
we can offer you a whole range or a subset of such development expertise at Anurakti Solutions.
|