SDS Significant Software Development Projects.

Development and Implementation of 'Online Application' viz., 'SDS TASK MANAGER'.

Synopsis:

Business tasks are the activities generated either by the organization's underlying business processes or by the users themselves as reminders to themselves or in order to delegate work to colleagues. The sooner users complete the tasks, the quicker the processes run. The easier it is for users, departments and companies to generate and track the tasks, the higher the quality of the output from the processes and the higher the transparency of processes within an organization.
This 'web based' software has been developed for BSNL, Eastern Zone Billing Centre to facilitate the management mange their assignments in a well defined manner. SDS Task Manager's functionality ranges from collaboration tasks generated manually in response to exceptions to work items generated from automated business processes. SDS Task Manager is greatly simplified because the tasks generated by the automated processes (workflows) are all generated by the same Business Process Management (BPM) runtime software. This means that the administration, such as locating tasks without owners or archiving, can be done on a uniform basis, irrespective of the source of the tasks. This reduces the total cost of ownership and ensures that the business processes run as fast as possible.

Key Features:

The Business Task Management IT scenario allows you to coordinate, monitors, and execute tasks arising from automated process flows.
Business Task Management provides the following benefits:

Enables simple and centralized access to SDS Tasks Manager.
Provide business and technical users with event-driven tasks, alerts, business context and Guided Procedures to effectively react upon process exceptions and tasks.
Provides procedures for exception-handling and knowledge-worker integration set up by local experts.
Encourages individual control at the lowest level of granularity.
Provides one-step access to tracking task progress.

------------------------------------------------------------------------------------------------------------------------------

Development, Implementation and Maintenance of 'BAR CODE' enabled Electricity Billing Software for the Energy & Power Department, Government of Sikkim at Gangtok, East Sikkim as a Pilot Project.

Synopsis:

The software does facilitate the Energy & Power Department, Govt. of Sikkim manage and benefit the billing management process by conceiving the billing, collection and realization activities in a well defined manner. This software enables proper monitoring and better Information Management, therefore improving customer service, increase transparency and ensures the efficiency & enhanced service delivery in the workings of the department. This in turn does bring about cost effectiveness and ensure better management of data as well.

The software does automates the entire billing process commencing from insertion of the Meter Reading Data, generating the bill based on the defined parameters and storing the data in an 'encrypted format', printing of bills, accepting the payment for matching using state-of-the-art Point of Collection machines [Bar-Code Scanner] and porting of payment details (in an encrypted format) to the Billing server through synchronization between the Billing server of the department and payment collection server of State Bank of Sikkim to incorporation of business decisions as and when necessary by generating necessary MIS reports viz., records of realised amount, outstanding dues, monitoring of disconnection activities, extending credit control functions and other relevant reports.

The Application Software conforms to 3-tier architecture & the application is accessible by any client through a web-browser. The application software provides for a centralized system i.e. centralized processing and database with facility for decentralized input and output. This approach was planned keeping in view variety of factors like integrity of data, share access, security, and reduced data redundancy, reliability/availability of stored information, and consistency of data, maintenance, upgradeability and ease of audit.

------------------------------------------------------------------------------------------------------------------------------

Design, Development and Implementation of 'Purchase Management Software' in browser mode along with supporting applications in VB.

Synopsis:

This Windows based Application software has been developed to automate the entire Purchase process and enable the organization to bring in transparency in the entire Purchasing process commencing from indent generation to the issuance of the purchase order. The software automates the entire purchasing process viz., Indenting, Tendering, Comparative Study, PO Generations, generation of necessary MIS reports and letters. The software also keep track of the Tender Invitation letters, generates reminders against unexecuted orders, maintaining Purchase order register, vendor wise product list along with price history and a fixed asset register. The software is well secured and does ensure security to any mal practice in the purchase process of the department.

Key Features:

Efficient handling of order processing .
Dynamic control of the Purchasing process.
Synchronization of Order entry, quote processing, and reporting.
Keep track of Order status & Year-wise commitment details.
Generating Comparative Statement of the tenders.

------------------------------------------------------------------------------------------------------------------------------

Design, Development and Implementation of 'Integrated Administrative Software'.

Synopsis:

The Application is an integrated system that has been developed to automate and integrate the Purchase & Stores section, Personnel Section and the Accounts Section. The modules did include the development of 'Purchase & Store Automation System', 'Personnel Database Management System' and 'Financial Database Management System' with the 'Privilege Permission' for different category of user level viz. Administrator and User. The application software provides for a centralized system i.e. centralized processing and database with facility for decentralized input and output. This approach was taken keeping in view variety of factors like integrity of data, share access, security, and reduced data redundancy, reliability/availability of stored information, and consistency of data, maintenance, upgradeability and ease of audit.

Key Features

Management and analyses of operations within an interactive environment.
Synchronization of activity within Purchase & Stores, Personnel and Accounts sections.
Monitoring, sharing, and tracking information throughout the organization.
Maintenance of Stock Ledger & Stock status
Maintaining and Accessing the Personnel database like Employee personal details, service record details and leave details.
Facilitation of Automatic Fax and e-mail transmission of relevant documents.
Issuing Certified Stores Receipt Voucher.
Automization of the 'Book keeping' of financial records and the salary records.

------------------------------------------------------------------------------------------------------------------------------

Design, Development and Implementation of Software facilitating 'View' & 'Print' of CellOne Bills of BSNL Post-paid mobile connection with necessary MIS report generation functionalities.

Synopsis:

This Windows based Application is a 'Print Management Software' named 'PCL Viewer' has been developed particularly for the BSNL Mobile (GSM & CDMA) Billing section that enables 'Printing' and 'Viewing' of the PH files as generated by BSNL in Binary PCL (Printer Command Language) format. PCL Viewer also has many high-level PCL analysis and management tools that can make the overall printing process much more efficient. The software facilitates 'Bar-Code' facility in code 128C format in existing GSM & CDMA Billing system of BSNL along with the required fields, like account no., invoice no., invoice date & bill amount. The software also facilitates sorting and printing of 'Pin - Code wise' GSM & CDMA bill, Sorting of 'CUG (Corporate)' print files of Cell One bill, Suppression of printing the 'Zero Usages Bills', 'Auto ECS Mark Up' in GSM & CDMA bill.

PCL Viewer displays monochrome and colour LaserJet print files (PCL PS) with improved PCL rendering accuracy and optional 600 dpi resolution. PCL Viewer's enhanced rendering quality and PCL colour support is also available which enables automated batch conversion to PDF and high-performance rendering for final printing. PCL Viewer's enhanced rendering quality and PCL colour support is also available which enables automated batch conversion to PDF and high-performance rendering for final printing. This software allows efficient management of documents as PCL, repurposing them on demand in other formats.

------------------------------------------------------------------------------------------------------------------------------

Development and Implementation of TAP RECONCILIATION Software.

Synopsis:

This is a customized software developed for the Monthly reconciliation of TAP (Transfer Access Protocol) files both for the in roaming (TAP-IN) and out roaming (TAP-OUT) received from RBS server and invoiced TAP files by M/s Spice and M/s MACH in case of piggybacking roaming and direct roaming respectively. The details of data are provided in soft form.

------------------------------------------------------------------------------------------------------------------------------

Development and Implementation of TAX Data Capture Software.

Synopsis:

This application software has been developed for the Telecom Sector. This high end software enables online data capture from the different Telephone Exchange under the West Bengal Telecom Circle to measure the call performance ratio with various MIS generated at the CellOne Technical Centre of Eastern Zone Billing Centre. The broader objective of the software is to reduce data redundancy, reliability/availability of stored information, and consistency of data, maintenance, upgradeability and ease of audit.

------------------------------------------------------------------------------------------------------------------------------

Development and Implementation Sub-ledger Review report for International Roaming Revenue of BSNL under East Zone Billing Centre.

Synopsis:

This Windows based Application generates Monthly Invoice, Issue of Credit Note & Debit Note, Issue of Journal, monthly Sub ledger review, party-wise ledger, Service Tax payable amount, outstanding list etc for both piggybacking roaming provider and direct roaming provider.

Key Features:

The software facilitates the following functionalities:

Preparing invoice for the services of BSNL network accessed by the Foreign Operators and corresponding payments detail and vice versa.
Generation of service tax report and allied tax report.
Keeping track of the payment in accordance to daily foreign currency rate with respect to INR.
Generating report of the foreign operator's party ledger.
Monthly collection report along with the outstanding status.
Revenue earning details both in terms of Month wise/Party wise.
Invoice Generation & status report.

------------------------------------------------------------------------------------------------------------------------------

Technology	:
Client	:	BSNL West Bengal Telecom Circle

Development and Implementation of 'Online Application' for integration of user services with the Ericsson AIR Server using User Communication Integration Protocol [UCIP].

Synopsis:

UCIP (User Communication Interface Protocol) is a library that translate into a component of SMSC gateway. The function of this library is to implement UCIP a proprietary protocol supported by Ericsson's AIR/Billing server. Library forms an XML-RPC request using the parameters that are passed by calling application, connect to the remote AIR server via HTTP and POST the request. After receiving a response from the server, the library parses the response and returns the values to the SMS gateway/calling application. Though the library is itself single threaded, it is designed to be thread-safe. The library is portable on Solaris (Sun OS) and Linux and will be ported on Windows. It makes use of libXML (1.4.0) �?? an open source library for parsing the XML response from the server.

------------------------------------------------------------------------------------------------------------------------------

Development of SMS based Application for Postpaid Customers of both GSM & CDMA for BSNL under Eastern Zone Billing Centre.

Synopsis:

Customer seeking information regarding BSNL Mobile services (including CDMA )can access this by sending SMS in a predefined number and following information should be offered to them

PLAN CHANGE - Change existing Plan.
TARIFF DETAILS - Know about the existing tariff details.
DATA USAGE - To know about the Data Usage.
KNOW YOUR PLAN - To know about his / her existing plan.
USG - To get unbilled usage.
BILL - To get current Bill.
OS - To get outstanding amount.
MMS - to get MMS facility.
HELP - Details of a particular plan.
Post paid connection.
Post paid 3G connections.
Plan change / facility change intimation to customers.
SMS relating to BILL broadcast.
Bill related intimation to customer [Bill generation intimation, bill payment request to customer, alarm for O/G bared, I/C bared, P.D., Payment receipt intimation etc]

------------------------------------------------------------------------------------------------------------------------------

Development and Implementation of 'Data Migration Software' for Migration and Standardization of 'Billing Data' from 'dBase', 'FoxPro' and 'MS SQL' to single MS SQL.

Synopsis:

To achieve an effective data migration procedure, data on the old system has been mapped to the new system providing a design for data extraction and data loading. The design relates old data formats to the new system's formats and requirements. Programmatic data migration does involve many phases but it minimally includes data extraction where data is read from the old system and data loading where data is written to the new system.
After loading into the new system, results are subjected to data verification to determine whether data was accurately translated and formatted, is complete, and supports processes in the new system. During verification, a parallel run of both systems will be performed to identify areas of disparity and forestall erroneous data loss if any.
Automated and manual data cleaning shall be performed in migration to improve data quality, eliminate redundant or obsolete information, and match the requirements of the new system.
Data migration phases (design, extraction, cleansing, load, verification) for applications of moderate to high complexity shall be commonly repeated several times before the new system is deployed.