• Five years experience in Industry.
• Strong Oracle development, Database Administration (DBA) and performance tuning experience.
• Very strong programming skills in PL/SQL, stored procedures, Triggers, Pro*C and Developer/2000 under Unix and Windows NT environment.
• Involved in System analysis and Design, Database Design, Development and Maintenance.
• Played lead role in migration of major business application from Oracle 7.0 to Oracle 7.3 and

• Expertise in SED, AWK, Perl, CGI Script, ASP, Java Servlets , Shell programming and LAN administration

HTML, Java Script, JAVA, JAVA Studio, Microsoft Front Page, Visual Intradev

Oracle application server 4.0, JBuilder, Active Server Page, XML

Sr. Software Engineer January 99 to Present - Sapphire Software, Inc. Fremont, CA

Duties: I am responsible for analysis and design of all the modules for the system. Prototyping on Perl

CGI, Microsoft Active Server Page and JAVA is also included to provide more applicable

E-commerce solution to the customer.

The best combination work out for this project is Java, Oracle and XML technology.

All Billing information is stored in the Oracle 8. Billing, Usage Information, Customer Account Maintenance interface developed by using Java and XML. Portal Infranet Software handled primary functionality for customer management. Limitation of Infranet Software covers with new interface, which developed in JAVA and XML.

System was design in such a way that customer can replace Infranet Software with any other new Billing system.

Also created Oracle database, tables, views, and triggers to store online event process. PL/SQL procedure for batch process and billing generation.

Tools: Oracle 8, Infranet 5.1.1, Netscape WEB server, JRun 2.2, Java 1.1, HTML, XML, CGI, and ASP

Sr. Software Engineer March 98 to January 99 - Sapphire Software, Inc. Fremont, CA

Developed web based software Infranet for Portal Software, Inc, Infranet provides registering, tracking, managing and billing Customer. My role is installation of Oracle on different OS like HP-UX, SUN Solaris and Windows NT, creation and configure database, creation of users, Views, Snapshots, providing database access by giving necessary privileges. Providing SQL *Net connectivity. Creation of database tables and triggers to store online event process. PL/SQL procedure for batch process and billing generation.

• Network Administration
• Network Management, E-mail Server, and WEB Server.
• Setting up of Network printing using Print servers across Windows NT / 95, Novell Operating Systems.
• Installation of TCP/IP.
• Installation of Server operating systems like Novell, NT and client operating systems like Win95, WinNT 3.51and 4.0
• Network Trouble-Shooting.
• Development and maintenance of web site.
• Server Backup and User management.

Tata telecom Ltd. is an ISO certified company involved in manufacturing of switching and transmission equipment. It has collaboration with AT&T, USA.

Responsible for analysis and design of client/server application modules described in detail below.

Used Oracle 7.3 on Solaris platform for database and used Developer 2000 on Windows 95

For GUI development. Performed various DBA duties.

Duties: I am responsible for analysis and design of all the modules for the system and establishing Client/server application. Creation of Users, Views, Snapshots, providing Database access by Giving necessary privileges.

System provided critical information like Required Material, Consumption, Production, Sales, Finance and Inventory to the top management for business analysis. System also provided information like sales Vs. Targets, Stock status, Production Status, Manpower Calculation, Debtors Analysis, Vendor Rating, Product wise Sales Information. Duties included Create and configure database, creation of Users, Views, and Snapshots, providing Database access by giving necessary privileges. Designing of user friendly GUI based Query, Graph, and Report Forms as needed.

Duties: System study, Design, Development, QA, Query optimization and system implementation

DBA activity.

The production department works as per the production plan. Each system consists of different packages. Before the finished package reaches the finish goods store, It passes through various manufacturing locations. This software module keeps track of all the packages passing through different Manufacturing locations. Thus it provides information about work in progress, first time right calculation, fault analysis up to part per millions levels (PPM) and turn around time.

Duties: System study, Design, Development, QA, Query optimization and system implementation.

DBA activity.

The marketing management system (MMS) consists of three major module sales Order processing, invoicing, MIS report. Sales order can be entered, modified, confirmed and amended. Invoicing module

Generate invoice based on customer orders. MIS reports gives the management sales performance of the company. The different features of MMS are copying of an existing order, different unit of measurements, automatic sales tax calculation, automatic adjustment of advances in invoices & generation of sales plan. This module is also integrated with inventory management system. System has a provision for SOC based ordering as per required schedule. It is also integrated with financial accounting system by passing all invoices to sundry debtor's module. This interface avoids duplication of work so that data capture in one of the system is automatically shared with all the other system.

Duties: System study, Design, Development, QA, Query optimization and system implementation

The planning department makes production plans for the fabrication of various products. Based on these plans, the gross and the net requirement of raw materials is calculated. The different processes involved are control table maintenance, Part master maintenance, bill off material maintenance, production plan maintenance, Gross requirement computation and net requirement computation. Gross requirement is calculated on the basis of, orders on hand-forecast. The net requirement is calculated on the basis of gross requirement - available stocks.

Duties: System Development and implementation.

This module is a part of inventory management system. It basically deals with all procurement related receipts into the stores. When goods are received goods received note (GRN) is raised. GRN are classified into five types. Local, mass, dummy, sales return and RF - note. PO raised forms the basis of all GRN transactions. On approval of GRN, related stocks and corresponding purchase order is updated.

Through valuation process receipt rate is calculated for each part. This forms the basis of monthly ledger process. Based on feedback from QA department material is accepted or rejected. Ownership of the rejected material is with purchase department. They can either re-work or re-forward the same (RF-Note) or send it back to the vendor (MDA-Rejected). This module warns the user of any excess/shortage in supply as against the delivery schedule of the PO. This helps in inventory control.

B.S from Gujarat University , India 1991

Name : Chirag Jha

Address: 39143 Donner Way

Fremont CA - 94538

Phone : 510-413-4970 ex - 36 (Day Time)

510-745-0160 (Evening Time)