RESUME

Vikas Shetty

148/2 Rasta Peth

Pune 411 011, Maharashtra, India.

 

Telephone:

+91-020-469352 (C/o Mr. Dayanand Shetty) +91-020-364 527 (off.)

+91-020-260 221 (off.)

E-mail:

[email protected]

 

Date of Birth : June 1, 1971

Passport number : A4849559 (India)

Valid Till : January 28, 2008

Marital Status : Single

Educational Profile : Bachelor of Commerce

from University of Pune, India in the year 1992

Total IT Experience : 5 years in Software Development

Professional : 1) Cleared Microsoft Certified Professional for Visual Basic 5.0

Qualification 2) Completed the HDSE

(Higher Diploma in Software Engineering)

from Aptech Computer Education Center , Pune in 1994

 

Computer Proficiency

Operating Systems : Windows 95, Windows NT 3.51, DOS 6.22, UNIX SCO

GUI : Visual Basic 4.0/5.0, Power Builder 4.0/5.0

RDBMS : SQL Server 6.5, MS-Access 97, Oracle v 6.0/7.2 (SQL Plus, Forms

3.0,Pro C, SQL* Report Writer)

Packages : DBase IV, Foxpro 2.6, MS Office 97

Languages : COBOL 74, C

 

 

Project Profiles :

1. Project Poona Club Management System

Duration Jan 99 – Till Date

Platform Visual Basic 5.0 with Ms-Access 97 on Windows 95

Role Project Leader.

Description This project is currently in Coding phase.This system takes care of all Club related activities.Main phases are Reception,Food and Beverages,Lodging ,Banquet, Accounts,Health Club and Special Events(Miss India Contest etc.).The system starts off with member checking in at the reception.At reception the identity of the member is verified with the scanned photo and signature of the member.Poona Club has itsown restaurant but allows other private caterers on contract basis to serve food in the restaurant.Other things which are taken care of are Health club activities,Swimming pool,permit room and stores.Online updation of each transaction taking place is made into the respective ledgers of Accounts.

2. Project : Pune Telecom

Duration : Nov 98 – Till Date

Platform : Visual Basic 5.0 with ActiveX Controls, Ms-Access 97 on Windows 95

Role : Programmer.

Description :

It’s a search engine for Yellow Pages & Individual’s residing in Pune.Main aim of this application is to help people find a company or persons dependent on various parameters. In Individual search user can search people on Name, Phone no and Area.In Yellow pages the user can search on a particular category or industry name, area and Phone no. The application also gives provision for advertisements of the sponsorer and individual companies. The final output of the search gives the Name, Address, Phone No, Fax No. and Email Id etc.

 

3. Project : Tailoring Software

Duration : Oct 98 - Nov 98

Platform : Visual Basic 5.0 with ActiveX Controls, Ms-Access 97 on Windows 95

Role : Programmer.

Description :

This system is primarily developed for Textile cum Fashion Boutique.It’s a WEB Application. As per the customers selection of a type of costume he is interested in, the system gives various designs and patterns for selection.On selection of the patterns and type of material required the lookup of the final product is shown to the user on a mannequin, this way the user can check out for the various combinations rather than going in for custom design and patterns. Advantage of this system to the client is that previously they used to produce lumps of dresses on some fixed patterns thus wasting much of material. If the Client finds that a particular type or style is more in demand then they can go in huge production of such patterns.

 

4. Project : Club Polaris

Client : Hotel Blue Diamond, Pune

Duration : May 98 - Sept 98

Team Size : 3

Platform : Visual Basic 5.0, Ms-Access 97 on Windows 95

Role : Project Leader.

Description :

This system is primarily developed for on-line entries of Evening Club from various terminals. The System consists of main menus like Masters, Transactions and Reports. Masters are like Item (food, liquor, cigarette), Tax, Members, Administration. Transactions are Check-In ,Addin Guest, Individual to Group Room Guest Updation, Split Bill, User Defined Letter Head , New Item Updation and Order Taken Entry. The Check-In keeps track of Entrance fees and number of guests, members, room guests, administrative persons. Also provision is made for Group Check-In. Depending upon entrance fees collection the multiple fee receipt s get printed. Depending upon mode of order given by the customers, OT entry generates their bills, keeping track of unpaid entrance fees on number of guests. Free slip for administrative persons is taken care of. Bill amount can be settled against Room bill, Membership fees, Credit card or by cash. Additional facility like Resettlement, Void bill and Order transfer to any one is been provided. Reports like Check In Information, Cashier and Sales Summary, Free Slip, Order Modification , H.B.D. Settlement, Tablewise Sales ,Departmentwise Sales , Expiry Alerts are generated on Screen, Disk and Printer. User rights are given on menu level, button level for every user depending upon his/her grade.

 

 

5. Project : SHE Statistics

Client : DuPont Inc., USA

Duration : February 98 - April 98

Team Size : 2

Platform : Visual Basic 5.0, SQL Server 6.5 on Windows 95

Role : Project Leader.

Description :

This system displays graphical information about the Injuries occurred to company employees within duty hours. Hierarchy of SBU, Business groups, businesses is depicted in Tree View control. When user clicks on particular business node he is given various options like Year selection, type of graph/ Tabular view depending on incident entry. In Incident entry user enters type of injury, date, time, description of incident and selects the Business in which the injury is happened.  

 

6. Project : Hotel Management System

Client : Hotel President, Pune

Duration : October 97 - January 98

Team Size : 3

Platform : Visual Basic 5.0, Ms-Access 97 on Windows 95

Role : Project Leader.

Description :

Hotel President is a 3 star hotel in Pune. This system handles Masters like Item (food, liquor,cigarette), Tax, Waiter, Tables, Unit, Group, Rooms, Locations. Hotel related transactions are like Room Reservations, Room Checking,Room Transfer, House Keeping, Room Service, Restaurant/Bar Entry, Check Out, Room Settlement, Room Release, Split bill. Reports are like reservation, check in register, room status, sales register,Bill Printing, Settlement report, Free Slip, Void Bill, Bill of Materials Raw material list etc. This system is attached to Accounting Package.

 

7. Project : Hallmark Inventory and Accounting System

Client : Vintage Cards and Creations, Pune

Duration : June 97 - September 97

Team Size : 4

Platform : Visual Basic 5.0, Ms-Access 97 on Windows 95

Role : Project Leader.

Description :

The system is developed for Vintage Cards and Creations subsidiary of Hallmark Inc., USA. This system handles information from Purchase of Raw materials to Distribution of Finished Cards such as Purchase order, MRN, Printer lot handling, Sales order, Invoicing, Distributor Target Handling. It also handles Financial Accounting such as Receipts, Payments, Debit/Credit Notes and Journal Entry. Stock Reports, Trial Balance, MIS reports, P&L accounts and Balance Sheets are some of the Main Reports of this System.

  

8. Project : Boat Club Management System

Client : Royal Cannught Boat Club, Pune

Duration : February 97 - May 97

Team Size : 3

Platform : Visual Basic 5.0, Ms-Access 97 on Windows 95

Role : Project Leader. Involved in System Designing, Coding, Testing and QA coordination. Business Knowledge Transfer to my subordinates is also a part of my responsibilities.

Description :

Boat Club, Pune is an Entertainment Club run by its members, which has a restaurant, Health club, Party arrangements and room service of its own. This system handles the accounting and sales transactions of Boat Club such as Caterer/Party/Coupon sales, Receipt/Payment/Purchase voucher entry, Demand slip and other sales related transaction. Datewise sales summary, Monthly consolidated members bill, Health club bill register, Daily Bar Sale and stock reports are some of the main reports generated by this system.

 

9. Project : Payroll System

Client : Kirloskar Electric Co. Limited, Pune

Duration : December 96 - January 97

Team Size : 2

Platform : Foxpro 2.5, Pentium Machine, LAN

Role : Project Leader. Involved in System Designing, Coding, Testing and QA coordination. Business Knowledge Transfer to my subordinates is also a part of my responsibilities.

Description :

Kirloskar Electric Co. Ltd. has a manpower of around 250 employees. This system handles Daily attendance, Advance Payment, Loan Payment/Repayment and Salary Calculation (Monthly/Quarterly/Annually) process. Payslips, Attendancesummary, Wage register, Pay sheet and leaves summary were some of the main reports generated by this system. Features like Backup, Access level security were also involved in this system. This system was later modified and installed in organizations like Aar-Em Electronics (Hadapsar), Ashish Plaza (Ferguson Rd), Damini(Laxmi Rd) and Prabhat Press (Laxmi Rd).

 

10. Project : Fixed Deposit System

Client : G.M.Finance, Pune

Duration : September 96 - November 96

Team Size : 2

Platform : Foxpro 2.5 ,Pentium Machine, LAN

Role : Project Leader . Involved in System Designing,

Coding, Testing and QA coordination. Business Knowledge

Transfer to my subordinates is also a part of my responsibilities.

Description :

G. M. Finance is a leading monitory leasing company in Pune. This system was designed and implemented in CyberSpace computers. Handling of Daily/Monthly collection, Loan payment, Fixed deposit, loan receipt and Interest payment were the main features of this system. Agentwise Daily/Monthly collection reports, Loan detail, Close account ,renewal, periodic depositorwise collection reports ,TDS calculation reports and Bank statements were the main reports generated by this system.

 

11. Project : Financial Accounting System

Client : Mahavir Trading, Pune

Duration : June 96 - August 96

Team Size : 4

Platform : Foxpro 2.5 ,Pentium Machine,LAN

Role : Project Leader. Involved in System Designing, Coding, Testing and QA coordination. Business Knowledge Transfer to my subordinates is also a part of my responsibilities.

Description :

Designed and Implemented in Cyberspace computers ,This system handles Cash/Credit sales/Purchase, Receipt/Payment/Journal vouchers, Debit/Credit Notes, Bank reconciliation and Petty cash.The main reports generated by this system were Sales/Tax/Detail register, Item Sales/Purchase register, Petty cash register, Stock register, Party/Account Trial Balance, Cash/Bank Book, General ledger, Party ledger, Reminder letter, Bank reconciliation statement , P&L Account, Balance sheet and Open/Closed bill reports.

 

12. Project : Manufacturers Excise System

Client : Aar-Em Electronics, Hadapsar,Pune

Duration : March 96 - May 96

Team Size : 2

Platform : Foxpro 2.5 ,Pentium Machine, LAN

Role : Project Leader . Involved in System Designing,

Coding, Testing and QA coordination. Business Knowledge

Transfer to my subordinates is also a part of my responsibilities.

Description :

Aar-Em Electronics is a leading UPS manufacturer. This system handles the Normal Invoice ,Excise Invoice, Maintenance Invoice, Excise Register and Abstract Register. Reports such as Salesmenwise sales, Sales Register, Customer/Modelwise reports, Excise Invoice Printing, Periodic Maintenance Summary, Dispatch Report, Excise Register reports in a predefined excise format, are some of the main reports generated by this System. This System was Designed and Implemented in CyberSpace Computers. It was attached to Tally for other accounting purpose. Graphical representation of sales reports was a unique feature of this System. User Level Security was also implemented in this system.

 

13. Project : Cadbury Distributors System

Client : Amruta Agencies, Sarasbaug,Pune

Duration : November 95 - February 96

Team Size : 4

Platform : Foxpro 2.5 ,Pentium Machine, LAN

Role : Project Leader. Involved in System Designing, Coding,Testing and QA coordination. Business Knowledge Transfer to my subordinates is also a part of my responsibilities.

Description :

Amruta Agencies is a leading Distributor of Cadbury's India . This system was designed and Implemented in CyberSpace Computers .It Handles Bill Entry, Goods Return, Pasari, Inward, Receipt ,Credit Notes, Check Control Statement, M.S.H, Stock & Sales, Cheque Return and Payment Entry. Reports sush as Salesman/Item/Party/Area wise reports, Volume/Value wise reports, G.R. Summary, Category/Sub Group wise sales, Salesmanwise Cash Collection, Check deposit statement, Periodic stock and sales reports, Area/Partywise Outstanding statements and Purchase Reports.

 

14. Project : Osho Tao Publishing System

Client : Osho Ashram,Koregaon Park,Pune

Duration : July 95 - October 95

Team Size : 2

Platform : Foxpro 2.5, Pentium Machine,LAN

Role : Programmer . Involved in Coding and Testing

Description :

Osho is an spiritual organization in Pune. This system was developed for them in Infoworld, Pune. It handles their Weekly/Monthly transactions of Osho Magazines. It also involved Advertisement billing entry. Reports are such as Advertisement/Circulation Bill Printing, Periodic Sales Statements. This system was further attached to Tally package for other Accounting purposes.

 

15. Project : Softech to MF Cobol Conversion

Client : Mico Hybrid Seeds, Jalna

Duration : February 95 - June 95

Team Size : 1

Platform : Unix, Cobol, C

Role : Programmer .

Description :

Mico Hybrid Seeds is a renowned Industry in the field of Agriculture Involved in conversion of Softech Cobol Programs to MF cobol Programs. I had designed a Utility to do the conversion. The Utility was developed in C under Unix Environment.

16. Project : Billing System

Client : Bhushan Agencies, Bombay

Duration : September 94 - January 95

Team Size : 2

Platform : Cobol 74, 486 Machine

Role : Junior Programmer .

Description : Bhushan Agencies is a company dealing in raw Wood and Furnished Wood Products. This System Handled Bill Entry, Octroi Transactions,Receipts and Payments Transactions. The main reports that the system generated were like Transaction Bills, Octroi Bills, Receipt Vouchers and Partywise Sales/Ledger Reports. This Project was Designed and Implemented in D.S.Company For Bhushan Agencies.

 

17. Project : Inventory & Accounting System

Client : Shubham Agencies, Pune

Duration : March 94 - August 94

Team Size : 2

Platform : Cobol 74 ,486 Machine

Role : Junior Programmer .

Description : This system handles transactions like Bill’s, Purchase, Receipt’s, Payment’s, Debit/Credit Notes, Bank Reconciliation and Contra Entry’s. The main reports that were generated in this system were like Sales/Purchase Register Report, Partywise/Itemwise Sales Report, Bank Book, Stock Report, Ledger report, Creditors /Debitors Trial Balance, Productwise Stock Ledger, Bank Ledger etc. This Project was Designed and Implemented in D.S. Company for Shubham Agencies, Pune

 

18. Project : Octroi Naka System

Client : Pune Municipal Corporation,Pune

Duration : September 93 - January 94

Team Size : 2

Platform : Foxpro 2.5 ,Pentium Machine, LAN

Role : Junior Programmer .

Description : This system handles transactions Octroi related Transactions such as Octroi Receipt, Debit Memo, fress Pass,escort.Generation of reports like Octroi receipt, Escort receipt, Datewise Receipt register and Escort register were a highlight of this system.

 

Apart from the above Projects I was involved in Various other Projects that were into the development stage at Impact Systems, Inc. My Role in these projects spanned from system designing to imparting business knowledge to my colleagues who were involved in the system. I have developed Various Utilities for In house Purpose.

Work Experience :

 

Organization

Designation

From

To

Impact Systems, Inc.

(India Branch)

Project Leader

February 98

Till Date

CyberSpace Computers,Pune

Project Leader

February 96

January 98

Infoworld Consultancy,Pune

Senior Programmer

February 95

January 96

D.S.Company

Junior Programmer

September 93

January 95

 

 

References: Available on Request