Foxpro Developer, SQL Server

Projects:

Project 1:

Tools : Visual FoxPro Version 9, Word
Role : System Analyst
Responsibilities : Analyzing project & Documentation
Duration : May 2015 - July 2015.

Description:
I worked here as System Analyst in Migrate to .Net Team. In this project I document the logic
applied in the VFP application.

Project 4: (Facility Management System for Builders-FMS)

Tools : Visual Foxpro version 9, SQL Server, XML, Excel, Word
Role : Developer
Responsibilities : Coding, Analyzing, Developing & Maintenance
Duration : September 2012 -December 2014.

Description:
FMS is comprehensive Real Estate Facility Management System especially designed for Real Estate
Industry. The System will maintain unit wise database of occupants, who occupies the flats/shops
(customers). It keeps the records of meter readings, generates the bills towards maintenance
charges, electricity, water, gas, internet and others. It also keep the records of receipts against
the bills, calculate surcharge on overdue bills, and generate outstanding statements. System will
also include offline voucher posting in financial accounting, from which financial accounting
statements can be generated.

Maintenance of Other Visual Foxpro Projects:
* Gym Management Software
* Wines Management Software
* Attendance Management Software ( Import Attendance From Bio-Matric Machine)
* Inventory Management

Projects:

Project 1: (Elite Real Estate Management System)

Tools : Visual FoxPro Version 9, SQL Server, XML, Excel, Word
Role : Developer
Responsibilities : Coding, Analyzing, Designing, Developing
Duration : August 2010 - December 2014.

Description:
This package is for Real Estate Companies for managing Allotment of Flats /Plots/ Shops etc. & their
Payments plans. Package covers the following areas:
* Defining Unit Size, Unit Numbers, Payment Plans, Broker commission slabs, PLC, ADC,EDC.
* Booking Details Entry, Installment Payments, Transfer of Unit, Co-Applicants Details, Receipt
Entry & printing.
* Generates various letters like Allotment letter, Demand Letter, No objection certificate,
Request for NOC, Permission for mortgage, Triplet Agreement, Buyer Agreement in Microsoft
Word.
* Reports like due payments, Broker wise commission, Sizewise/ratewise/brokerwise Bookings and
many more.

Project 2: (Human Resource Management System - HRMS)

Tools : Visual Foxpro Version 9, SQL Server, XML, Excel, Word
Role : Developer
Responsibilities : Coding, Analyzing, Designing, Developing
Duration : August 2010 - December 2014.

Description:
The HRMS covers varied aspects of HR department of an organization in a streamlined and efficient
manner. This includes
* Recruitment, Employee Master, Training and Evaluation, Payroll generation.
* P.F/ E.S.I.C Statutory Reports, Income Tax Calculation Processing, Full & Final Settlement.
* Annual Benefits processing, Letters generation & MIS Reports, Online Bio-Data Submission.
* Employee's Performance Appraisal.
* Setup for Salary, PF, ESI, Bonus, Leave and Professional Tax Structure.
* Can Create Multiple Companies, branches, departments, locations, ESI & PF numbers.

Project 3: (Visual Payroll - VisPay)

Tools : Visual Foxpro Version 6
Role : Developer
Responsibilities : Coding, Analyzing, Designing, Developing
Duration : August 2010 - December 2014.

Description:
The Vispay software covers the following aspects.
* Payroll Generation
* Setup for Salary, PF, ESI, Bonus.
* Handles Salary of Contract & Permanent & Daily Wages Employees.
* P.F/ E.S.I.C Statutory Reports, Pay register.

Projects:

Project 1: (Financial Accounting Software for Courier Business)

Tools : Visual Foxpro 9, SQL Server
Role : Developer
Responsibilities : Coding, Analyzing, Designing, Developing
Duration : May 2007 - July 2010.

Description:
This Software take cares for all financial needs from daily Expense vouchers to Balance Sheet.

Project 2: (Business Associate Accounting Software for Courier Business)

Tools : Visual Foxpro 9, SQL Server
Role : Developer
Responsibilities : Coding, Designing, Developing
Duration : May 2007 - July 2010.

Description:
This Software will take care of accounting part of Business Associates (Booking & delivery Agents)
of the Company & includes Entry of their Booking & Delivery Commission & various MIS reports.

Project 1: (Subscription Management System For Publishers)

Tools : Visual Foxpro 8, SQL Server
Role : Developer
Responsibilities : Coding, Analyzing, Designing, Developing
Duration : September 2004 -July 2006.


Description:
* This package is used to manage Subscription of Journals / Books to Customers & their payments.
This package is developed in VFP-8. This covers the following areas
* Master Entry of Journals / Books / Customers etc.
* Generation of Proforma Invoice for Subscription.
* Receipts Entry, Dispatch Entry, Un-supplied entry.
* Generation of Renewal Notices.
* Letters to customers.

Project 2: (Book fare Software)

Tools : Visual Foxpro 6, SQL Server
Role : Developer
Responsibilities : Coding, Designing, Developing
Duration : September 2004 -July 2006.


Description:
This package used to for entering sales made in Book fair. Afterwards which will be merged in data
of Subscription Management Software

Project 3: (Online Book Catalogue)

Tools : Visual Foxpro 8, SQL Server, Power Point, Word
Role : Developer
Responsibilities : Coding, Designing, Developing
Duration : September 2004 -July 2006.

Description:
This package is created for publisher. All the information regarding books will be stored in a SQL
database. User will have a interface for selecting Books to be included in Catalogue & Catalogue of
selected books will be generated in PowerPoint (One Book / slide) or Word (One book / Page).
Catalogue information include Author name, Subject, Sub subject, Brief description about book in
text / in gif file, no. of pages, price, remarks etc.

Projects:

Project 1: (Transport Management System)

Tools : Foxpro For Unix
Role : Developer
Responsibilities : Coding, Analyzing, Designing, Developing
Duration : February 1998 - July 2004.

Description:
* This package stores Documents details like Consignment, Challan, Short Excess Damage report,
Delivery Acknowledgement Forwarding Memo, Bills, Money receipt, Lorry Hire Payment.
* Generates various types of over 100 reports, e.g. Outstanding Bills, Costing of Consignment,
Customer/Staff Ledger, Consignment in Stock, Short Excess payment.
* Entry of Daily Cash Statement, Payment Received, Payment to Lorry hired
* Payroll generation integrated with cash statement.
* Daily data backup send to and received from different branches

Project 2: (Student Management System)

Tools : Dbase
Role : Developer
Responsibilities : Coding, Designing, Developing
Duration : February 1998 - April 2003.

Description:
* This system was developed for Aptech Center, Noida and Aptech Center, Madras Branch
* Maintains Student and Staff Master Details.
* Maintains Database of Courses Details, Payment plan.
* Data Entry of Payment advice, Payment receipts daily cash statement.
* Maintains Library Details ( Issue and receipt of books , Late penalty)
* Reports like Outstanding students, Staff Payroll Register, Student attendance Sheet, CashBook,
Trial balance.

Job Profile:
* Making Connectivity of UNIX with Novell NetWare Server using TCP/IP, SPX/IPX
* Design, development and maintenance of TMS (Transport Management System) system on Unix
platform.
* Planning, Installation, Configuration & Maintenance Of Unix Server 3.2 Mounting, Dismounting
File Systems.
* Planning And Designing of various MIS reports with Sr. Executives.
* Creating shell scripts to store backup on External hard disk.
* Creating shell scripts for automated shutdown.
* Creating Users, Setting Space, Authorization, Login Restrictions.
* Making TMS software Y2K compliant.
* Managing 10 computerized branches, Impart training to Branch Employees.
* Giving Novell user access on Unix.

Projects:

Project 1: (Pharmulation System For Medicine Manufacturing Companies)

Tools : Foxpro For DOS
Role : Developer
Responsibilities : Coding, Analyzing, Designing, Developing
Duration : September 1995 - January 1998.

Description:
* This package is for Pharmaceutical-manufacturing Unit, which consists of 5 sub packages as
follows: -
* Accounts (Cash/Bank Transactions, Trial Balance, Profit and Loss A/c, Balance Sheet)
* Inventory (Stock of raw material, Purchase of raw material)
* Production ( Requisition details, Advice to quality control dept. Formula Entry )
* Quality Control (Passing Quality test of Drugs/Excipients/packing/finished material.
* Utilities (Indexing of files, Data backup, Password assignment to users)

Project 2: (Pharmacy Management System For Chemists)

Tools : Foxpro For DOS
Role : Developer
Responsibilities : Coding, Designing, Developing
Duration : September 1995 - January 1998.

Description:
* This package was designed and developed specifically for Chemists shops and Hospitals for
maintaining details of their patients.
* Storing contamedication of patients with medicines, allergy with medicines.
* Maintains database of medicines and their ingredients, contraindication between medicines.
* Generates reports like Stock of medicines, Outstanding dues of patients/ Suppliers.
* Invoice generation.
* Maintains Accounts (Cash/Bank Transactions, Trial Balance, Profit and Loss A/c, Balance Sheet)