Environment Visual Foxpro, Foxpro 2.6 for Windows, Windows 95

Description This System is communication reporting application which generates various types of reports. The system includes importing and exporting of the data from EIS Unix Box using FTP protocol. After importing data, it is processeed and appended in the foxpro database. It also generates various type of reports i.e. Report by Operator, Report by List, Sales Report, Client Report, Calculation of Hours, Department code etc. This is customized application, which is developed for our major clients. Some of our clients are AT&T, BellSouth, Providian, Columbia House, Met Life etc.

Role Developed the program for importing and exporting the data using FTP protocol.

Designed the database and developed the data entry screens using Form Designer in Visual Foxpro.

Environment Visual Foxpro, HTML, JavaScript, IIS 3.0, Windows 95, Windows NT 4.0

Description This System is an internet application which display the estate related details such as residential amenities, industrial, vacant land. This System helps user to search the property as per his/her requirments or budget. In this system we have used idc & htx files which work with IIS. Using ODBC drivers we connected backend database and formated same in html files(htx). All the details related to properties are developed in foxpro which generated the output in html format.

Role Developed the back end program using IIS script which includes IDC & HTX language. This idc script which has the SQL statements that connects to backend database using ODBC drivers and send data in htx file format which is in HTML . Also written Javascript for validation of HTML forms input data submitted from client side.

Designed the database and developed the data entry screens using Form Designer in Visual Foxpro.

Environment Visual Foxpro 3.0, HTML, JavaScript, IIS 3.0, Perl 5.03, Windows 95, Windows NT 4.0

Description This system is divided into two parts i.e. 1) Accounting System and 2) Marketing Management System.

In Accounting System, it includes all the monitory transactions i.e. cash and bank transactions, daily expenses and other accounting transactions in journal and ledger books. It includes major online reports including Trial Balance, Profit and Loss Statement, Balance Sheet etc.

In Marketing System, it includes all the marketing expenses, orders and receipts of payment. It includes all online MIS reports including monthly, quarterly and yearly executive performance reports & analysis. All the monitory transactions are integrated with the Accounting System.

Role Developed the backend programs in CGI Perl script which connects the database and convert the extracted data in the html format which sends to client end. Also done the validation of html forms in javascript.

Developed the modules i.e. Customer maintenance, creation of new accounts, Generation of Various Reports i.e. monthly, quartely and annually reports on the basis of marketing executive, product etc in Visual Foxpro, for LAN users. The integration of all the modules.

Environment Visual Foxpro 3.0, HTML, JavaScript, IIS 3.0, Windows 95, Windows NT 4.0

Description This System includes online query on the internet or on lease line. The system helps user to view the commercial or residential premises by sending the query with or without the criteria. The criteria can be the location of amenity, area of amenity, rate of amenity. The query is process on the server side which connect to the DBMS and filter the data as per the user requirements. Then the data is converted into HTML format and same is send to end user.

Developed the back end program using IIS script which includes IDC & HTX language. This idc script which has the SQL statements that connects to backend database using ODBC drivers and send data in htx file format which is in HTML . Also written javascript for validation of forms input data submitted from client side.

Developed the screen layouts, forms and modules in Visual Foxpro for the maintainence of Database.

Environment Visual Foxpro 3.0, HTML, Java Script, IIS 2.0, Perl 5.03, Windows 95, Windows NT 3.51

Description This System includes online query system on LAN, Intranet Internet. This system helps user to query on any product which is available on the database. The data or information is assigned a unique code. The system also handles the calculating the users accounts. The system has multiple database which can be stored on multiple servers. The system has search utility which helps user to search any product code or description.

Role Developed the screen layouts using Form Designer in Visual Foxpro i.e. login, connecting to backend & displaying data in grid made various modules for maintainence of database.

Developed the backend script using perl developed packages which check the data send from html form, errors, validation of date, connecting to database using ODBC drivers, converting and displaying the database data in html format to client end. Also done html forms validation in javascript.

Description This System includes a data communication package. The project involved to design and develop an e-mail system and also intra office communication package i.e. entire connectivity solution on LAN (i.e. communication system within the office) & WAN (i.e. communication between head office, branch office and any other locations).

Also contributed to the development of gateways i.e. Fax Gateway, Internet Gateway, Wan Gateway and GEMS 400 Gateway.

Role Devloped the screen forms in Visual Foxpro which includes Send Log, Receive Log, Archive Log. Developed modules for processing and displaying new mail to user screen. Integration of all the modules in the project. Finalizing the project with distribution kit.

Description This System includes all the Banking transactions. The transactions includes all the daily cash receipts and cash payments transactions. The system maintains Member details such as address, no of shares, purchase of shares, transfer of shares etc. Also it calculates the dividend of shares, interest on Savings, Deposits & Loans. The system has various types of reports which includes dividend warrants, overdue reports and interest pending reports.

Role Design the database, helped in developing the modules i.e. members data maintainence, calculation of proportion dividend, calculation of balances of all the a/c, transfer to new year database,label printing, generation of reports & integration of all the modules.

Description This System includes all the details of schools in India. It maintains the fees of all the standards and base on that fees and standards, it calculates the scholarship of the student. It has facility to pay the scholarship amount in sub parts. System has facility to maintain the amount donates from donors and maintain the account of same. It has various reports which includes the donors list, scholarship amount sanction by the management, students list, fees structure, minutes of management committee etc.

Role Design the database, helped in developing the modules, generation of reports in reportwriter, label printing, integration of all the modules.