EDUCATION
May-1996: B. E., Computer Science Engg., Bombay University, Mumbai, India
SOFTWARE SKILLS
RDBMS Oracle 7.1/7.3, INFORMIX SE 6.0
Oracle Tools Developer/2000 (Forms 4.5, Report Writer 2.5), SQL 3.1, PL/SQL 2.1, Export, Import, SQL Loader, Backup
Operating Systems Windows NT 3.51, 4.0, Windows 95, Unix
Languages PL/SQL, C, Pascal, Cobol, Basic, Fortran77
Networking Software TCP/IP
Programming Languages PL/SQL, C, Pascal, Cobol, Basic, Fortran
CAD/CAM Packages AutoCAD 14, Microstation 95, FRAMME
ADDITIONAL TRAINING
Unix & Windows NT O/S Conducted by Rolta India Limited, Mumbai, India. Developer/2000 Conducted By Rolta India Limited, Mumbai, India.
EXPERIENCE SUMMARY
2 + years of experience in Application Development on Developer/2000 and Oracle 7.X.
EXPERIENCE HIGHLIGHTS
Mar. '98 to Dec'98 CPS, Inc. Atlanta, GA 30092
Position Software Consultant
Job Description REPORT GENERATION There are many features (Feeder switch, Busbar, Tap, Cable, Cable Box, Consumer, isolator) used during separate icons. The final goal was to produce data generated details of Cable, Consumer, etc. and maintaining the database for execution of the project, so the system necessitated developing a front end application which could keep track of the database for the whole network and generated various types of reports as per the client requirements. Reports generated included Customer Invoice, Employee Salary, Employee Details, Extra Overtime, Complaint, Total Sales, Regionwise Sales, Each substation, Each transformer, Customer Ledger, and many others. This system was developed using Intergraph Pentium based TD - 30 workstation, and Windows NT 3.51.
GAS NETWORK SYSTEM Project involves Application Development in linking AM/FM Packages (FRAMME) to RDBMS. Here Oracle 7.3 is used as back end & Developer 2000 has been used as front-end for data manipulation after data has been generated by AM/FM package (FRAMME). There are many features (Gas Pipe, Leakage, Gas Station, Consumer, Valve) used during separate icons according to their states (Formulation, Sanction, Construction, Commission). When user is trying to place any feature, the forms appear on the screen before the placement of that particular feature. As the final goal was to generate data, such as, details of Gas Station, Consumer, etc. and maintaining the database for execution of the project, the system necessitated developing a front end application which could keep track of the database for the whole network and generated reports as per the client requirements. This project was developed using Intergraph Pentium based TD - 30 workstation, Windows NT 3.51, Oracle 7.3, Developer 2000 (Forms 4.5, Report Writer 2.5), and FRAMME.
Oct. '96 to Feb. '98 Rolta India Ltd., Mumbai, India
Position Programmer/Analyst
Job Description Involved in development on Developer/2000, Pre and post installation support, Trouble shooting on O/S related problems.
AMC MAINTENANCE SYSTEM Involved in GUI Standard Specification & Development, and Development of forms and reports. Customer database AMC maintenance system keeps track of the database of the existing customer of ROLTA all over India with respect to H/W as well as Software supplied by Rolta which helps in keeping day to day maintenance such as product complaints, Warranty Services, Maintenance Problems, new product releases, updates etc. to the existing customer. Also, it has provision based on the products purchased. Charts were generated to give inputs to management for the services support activities, H/W as well As S/W distribution regionwise, market growth regionwise, etc. This system was developed using Intergraph Pentium based TD – 30 workstation, Windows NT 3.51, Oracle 7.3, and Developer 2000 (Forms 4.5, Report Writer 2.5).
MIGRATION of INFORMIX to ORACLE I have done migration of Informix database to Oracle DB.
ELECTRIC NETWORK SYSTEM Involved in Application Development in linking AM/FM Packages (FRAMME) to RDBMS. Oracle 7.1 is used as back end and Developer/2000 has been used front end for data manipulation after data has been generated by AM/FM package (FRAMME For each feature, there are separate icons according to their STATES (Formulation, Sanction, Construction, Commission). When user is trying to place any feature, the Forms appear on the screen before the placement of that particular feature. It goes for procuring data generated such as, details of Cable, details of Consumer, etc. and maintaining proper database for execution of project. So the system necessitated developing a front application which can keep track of database of whole network and generating reports.
Also involved in Database Installation and Configuring Oracle Tools and AM/FM Packages For Client/Server Architecture, Detailed Engineering For AM/FM Components, Development On Forms and Report, and Report Generation.
SALES ORDER AUTOMATION A company is engaged in the manufacture and marketing of a wide range of computer peripherals to diverse industries. The work order entries are made when a customer places an order for goods manufactured by the company. It is quite possible that the quantity demanded by the customer is only partially met; i.e., partial delivery of items ordered. The invoices are printed based on the material delivered on the receipt. The modules involved were Master Maintenance of Customers and Product; Transaction of Order Preparation, and Sales Invoice Entry, Reports; such as, Sales Invoice, Productwise Sales, and Customer Ledger. These projects were developed using Intergraph's Pentium based TD - 30 Workstation, Windows NT 4.0 and 3.51, Oracle 7.1, Developer/2000 (Forms 4.5, Report Writer 2.5).
June '96 to Sept. '96 Fintech Systems
Position Software Engineer
Job Description HUMAN RESOURCE DEVELOPMENT This system is designed to manage the scheduling of employees in any organization having Shift Systems, such as, Hospitals, Restaurants, Factories, etc. Given the entire shift timings, roll, and employee preference, etc., the system schedules the employees in a most optimum manner. The system also registers possible requests (Add, Delete, Modify, Update etc.) from employees. It provides easy to use interface for designing shift and organization. The system also keeps track of overtime and wages.
The modules involved were Master Maintenance of Department, Designation, Relation, Employee Shifts; Transaction of Department-Designation Relation; Reports for Department, Designation, Relations, Employee: Detail and Qualification, Standard Shifts. This project was developed using Pentium, Windows NT 3.51, Oracle 7.1, Developer/ 2000 (Forms 4.5, Report Writer 2.5).