Make your own free website on Tripod.com

Chirag Jha

e-mail - chiragjha@hotmail.com

 

 

Professional Summary

*

Four years experience in Telecommunications Industry.

*

Good knowledge of Business flow and Production Activity of electronic Industry.

*

One year of experience as Oracle DBA.

*

Strong Oracle development, Database Administration (DBA) and performance tuning experience.

*

Very strong programming skills in PL/SQL, store 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 SQL*Forms 3.0 to Forms 4.5.

*

Expertise in SED, AWK,and Shell programming and LAN administration.

Education

Honours Diploma in Systems Management from - NIIT, India

Bachelor of Science from Gujarat University, India

 

 

OPERATING SYSTEM

SUN Solaris 2.3, Windows 95 / NT 4.0, Ms-DOS, UNIX, Novell 3.12

HARDWARE

SUN Sparc server - 10 Model - 41, Wipor FUSION, Pentium Server

RDBMS

ORACLE 7.0, 7.3

SQL*Forms 3.0, PL/SQL 2.0, SQL*Plus 3.1, SQL*Report 1.1, SQL*Reportwriter 1.1, PRO*C 1.5, SQL*Loader

GUI

Developer/2000

WWW

HTML, Java Script

Project Details

Company

26'th March 1998 to Present Sapphire Software Inc. Fremont CA

Project

Internet Customer Management and Billing system

Role

System Analyst

Description

For Internet business process, customer management and billing system Portal Software, Inc

Developed Infranet software. Infranet provides registering, tracking,managing and billing Customer. It is advance four-tier client-server architecture. Client tier / Business Tier /Business object tier / External tier. Here the external tier contains interface to an Oracle. My role is to create and configure database, creation of users, Views, Snapshots, providing database access by giving necessary privileges.Providing SQL*Net connectivity. Creation of database triggers to store online event process. PL/SQL procedure for batch process and billing generation.

Environment

Oracle 7.3, Windows NT/Solaris, SQL*Plus, SQL*Net, PL/SQL, HTML, Portal's Infranet 5.4.2

 

 

September 1993 to 25th March 1998 Tata Telecom Ltd., India

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

Company

08/97 to 25th March 1998 Tata Telecom Ltd.

Project

Executive Information System

Role

System Analyst

Description

Working as a System Analyst. 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. Designing of user friendly GUI based Query, Graph, Report Forms. This System provides critical information like Required Material, Consumption, Production, Sales, Finance and Inventory to the top management for business purpose. System provides information like sales Vs. Targets, Stock status, Production Status, Manpower Calculation, Debtors Analysis, Vendor Rating, Product wise Sales Information.

Environment

Oracle 7.0 on Solaris 2.3, SQL*Net, Windows 95, Developer/2000

 

 

Company

08/96 to 08/97 Tata Telecom Ltd.

Project

Production Information System

Role

System Analyst / Programmer

Description

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.

Environment

Oracle 7.0 on Solaris 2.3, PL/SQL, SQL*Forms, SQL*Plus, SQL*Reportwriter, Pro*c

 

 

Company

10/95 to 08/96 Tata Telecom Ltd.

Project

Marketing Management System

Role

System Analyst / Programmer

Description

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 generates 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.

Environment

Oracle 7.0 on Solaris 2.3, PL/SQL, SQL*Forms, SQL*Plus, SQL*Report, Pro*C, SQL*Loader

 

 

Company

07/94 to 09/95 Tata Telecom Ltd.

Project

Material Requirement Planning

Role

System Analyst / Programmer

Description

The planning department makes production plans for the fabrication of various products. Based on these plans, the gross and the net equirement 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.

Environment

Oracle 7.0 on Solaris 2.3 , PL/SQL, SQL*Forms, SQL*Plus, Pro*C, SQL*Report

 

 

 

 

Company

09/93 to 06/94 Tata Telecom Ltd.

Project

Receipts Module

Role

System Analyst / Programmer

Description

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 and 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.

Environment

Oracle 7.0 on Solaris 2.3, PL/SQL, SQL*Forms, SQL*Plus, Pro*C, SQL*Reportwriter

 

 

[Visit My Office]