Home » Other » Marketplace » B.E. Comp, 6+ Yrs Oracle & D2K Exp, 3+ Yrs DBA, OCP DBA 9i
B.E. Comp, 6+ Yrs Oracle & D2K Exp, 3+ Yrs DBA, OCP DBA 9i [message #106722] Mon, 29 March 2004 08:12 Go to next message
Nayan Pandya
Messages: 2
Registered: March 2004
Junior Member
-

<IMG height=37 src="http://www.orafaq.com/msgboard/marketplace/Image1.gif" width=225>Name

-
-

Nayan Pandya

-

-

Email

-
-

pandya_nayan@sancharnet.in
-

-

Phone Nos.

-
-

[[R]] (91)-02971-225104 [[1.15PM-2.30PM & 6.00 PM Onwards]]

-

-

----------------------------------------------------------------------

-

-
  • skill summary
-

-   -

-   -
-

More than Six years of experience in developing client-server-based commercial & technical applications using Oracle & Developer 2000/6.0, out of which, Three year of experience as a Project leader.
-

-   -
-

More than Three year experience of Database Base Administration with Oracle 8i
-

-   -
-

OCP
[[Oracle Certified Professional]] certification in Oracle 9i DBA track with an average of 90% passing score, from Oracle Corporation.
-

-   -
-

Strong Analysis, design, development & troubleshooting skills
-

-   -
-

Very good Functional knowledge in the areas of Material Management System, Personnel Management system & Plant preventive & maintenance system.
-

-   -

-
  • areas of EXPERTISE
-

-   -

-   -
-

Database Administration [[Oracle 9i / 8i]]

-

-   -

-   -
-   -
-

Oracle Installation & configuration on Windows NT / HP Unix 11.0
-

-   -
-   -
-

Creation & maintenance of Database on Oracle.
-

-   -
-   -
-

Creation of tablespaces & others database objects & maintenance of the same using Oracle Enterprise Manager.
-

-   -
-   -
-

Backup & restoration
-

-   -
-   -
-

Maintenance of system security by creation of users, rolls & privileges management
-

-   -
-   -
-

Backend application management by creating Triggers, procedures & packages, Indexes, clusters etc.
-

-   -
-   -
-

Performance tuning of the database by regularly monitoring & tuning different areas.
-

-   -

-   -
-

Application development [[Developer 2000/6.0]]

-

-   -

-   -
-   -
-

Analysis of the system by understanding business process for the system.
-

-   -
-   -
-

Designing of the system as per requirements gathered at the time of system analysis
-

-   -
-   -
-

Preparing documents for the design e.g. database structures, Business rules, flow charts etc.
-

-   -
-   -
-

Defining & testing for Visual & Coding standards of applications
-

-   -
-   -
-

Preparing generalize codes (Libraries) for faster development of applications
-

-   -
-   -
-

Defining & maintaining security strategy (at database, Row & menu level) for applications
-

-   -
-   -
-

Defining & maintaining auditing strategy for applications
-

-   -
-   -
-

Creating triggers, Packages, Procedures, views & functions at backend / front-end
-

-   -
-   -
-

Troubleshooting of Forms, reports & other database problems
-

-   -
-   -
-

Implementation & user training
-

-   -
-   -
-

Data porting from FoxPro/ text file to Oracle using SQL*Loader
-

-   -
-   -
-

Interfacing of Oracle to FoxPro/Excel data Using ODBC
-

-   -

-
  • Skill Set
-

-   -

-   -
-

RDBMS / Tools
-
-

Oracle 9i/8i/7.3, Oracle Enterprise Manager 2.x, SQL*PLUS, PL/SQL, SQL*Loader
-

-   -
-

GUI / Front End
-
-

Developer 2000 / 6.0
-

-   -
-

N/W OS
-
-

WINDOWS NT 4.0, HP Unix 11.0
-

-   -
-

Desktop OS
-
-

WIN XP/98/95, MS DOS
-

-   -
-

Languages
-
-

C
-

-   -

-
  • Academic Qualifications
-

-   -
-

Qualification

-
-

College / University

-
-

Month & Year Of Passing

-
-

% Of Marks

-

-   -
-

B.E. Computers
-
-

BVM Engg. College, SP University, Gujarat
-
-

Oct, 1996
-
-

61%
-

-   -
-

Diploma in Computer Technology
-
-

B & B Polytechnic College, Technical Education Board, Gujarat
-
-

March, 1993
-
-

74%
-

-   -
-

Higher Secondary (10+2)
-
-

Gujarat Secondary Education Board
-
-

March, 1989
-
-

60%
-

-   -
-

SSC
-
-

Gujarat Secondary Education Board
-
-

March, 1987
-
-

72%
-

-   -

-
  • Professional certifications / TRAINING
-

-   -

-   -
-

15 Days Full time training on Oracle 9i DBA From SQL STAR International, Mumbai.
-

-   -
-

OCP
[[Oracle Certified Professional]] certification in Oracle 9i DBA track with an average of 90%, from Oracle Corporation.
-

-   -
-

15 Days Full time training on Oracle 8i,Developer 6.0 & Oracle DBA from NIIT, Ahmedabad.
-

-   -

-
  • Career Path
-

-   -

-   -
-

Organization

-
-

Binani Cement Ltd., Rajasthan

-

-   -
-

Job Duration
-
-

60 Months (March, 1999 to till date)
-

-   -
-

Designation
-
-

Sr. Programmer / System Analyst
-

-   -

-   -
-

Organization

-
-

Gujarat Ambuja Cement Ltd., Gujarat

-

-   -
-

Job Duration
-
-

10 Months
-

-   -
-

Designation
-
-

Programmer
-

-   -

-   -
-

Organization

-
-

Binary Systems., Gujarat

-

-   -
-

Job Duration
-
-

12 Months
-

-   -
-

Designation
-
-

Programmer
-

-   -

-
  • Major Projects
-

-   -

-   -
-

1.

-
-

Purchase & Inventory Management System

-

-   -

-   -
-

Client

-
-

Binani Cement Ltd.
-

-   -
-

Platform

-
-

Window-98 / NT, HP Unix 10.0
-

-   -
-

Back-end

-
-

Oracle 8i
-

-   -
-

Front-end

-
-

Developer 6.0
-

-   -
-

Team Size

-
-

Seven
-

-   -

-

-
-

Role

-
-

Project Leader
and responsible for system analysis, Design and troubleshooting. My responsibilities include designing of the whole Documentation, defining form module specifications (rules & validation), designing reports, testing of forms & reports, defining Security strategies, Audit strategies & database Backup.
-

-   -

-   -
-

Brief

-
-

Inventory Management System has been developed towards computerization of day to day activities of stores & purchase departments. System facilitates user for purchase indent preparation, enquiry generation, comparative statement or purchase proposal generation based on quotation received from vendors against enquiry, purchase order generation, enquiry reminder, purchase order reminder, material receipt Entry, material rejection note generation, material issue ad return entry. Various reports are generated like indent register, pending indent register, enquiry statements, purchase order register, pending purchase order listing, daily material receipt information. This system is integrated with Supplier Bill passing, Personnel management system & Finance Accounting System.
-

-   -

-   -
-

2.

-
-

Plant Preventive Maintenance System

-

-   -

-   -
-

Client

-
-

Binani Cement Ltd.
-

-   -
-

Platform

-
-

Window-98 / NT
-

-   -
-

Back-end

-
-

Oracle 8i
-

-   -
-

Front-end

-
-

Developer 6.0
-

-   -
-

Team Size

-
-

Five
-

-   -

-   -
-

Role

-
-

Team member
and responsible for database design, development, troubleshooting and implementation. My responsibilities include to co-ordinate Project leader to define form module specifications (rules & validation), testing of forms & reports, designing reports, creation of schema objects, tablespaces & table level triggers.
-

-   -

-   -
-

Brief

-
-

Plant Preventive Maintenance system is developed to reduce breakdowns and increase utilization time of machines installed in the plant & achieving production target and in reducing maintenance cost. System is helpful in planning of day to day maintenance activities for the machines and to generate daily work order, which contains maintenance activities of the machines with required spares, manpower, tools and other miscellaneous requirements. It has facility to enter feedback against job orders, planned plant shutdown, unscheduled jobs and generate reports like pending job-orders, equipment’s history, register, cost, analysis, spares /manpower/cost forecasting, shop floor inventory, equipment swapping history, time duration wise maintenance activities, breakdown analysis and other MIS reports.
-

-   -

-   -
-

3.

-
-

Personnel Management & Information System

-

-   -

-   -
-

Client

-
-

Binani Cement Ltd.
-

-   -
-

Platform

-
-

Window-98 / NT, HP Unix 10.0
-

-   -
-

Back-end

-
-

Oracle 8i
-

-   -
-

Front-end

-
-

Developer 6.0
-

-   -
-

Team Size

-
-

Three
-

-   -

-   -
-

Role

-
-

Project Leader
and responsible for system analysis, Design and troubleshooting. My responsibilities include designing of the whole Documentation, defining form module specifications (rules & validation), designing reports, testing of forms & reports, defining Security strategies, Audit strategies & database Backup.
-

-   -

-   -
-

Brief

-
-

This software is used to computerize employee's personal information & salary related information like payroll, PF & TDS. System includes employee personal information, salary information (L.I.C., Loan, PF etc.), income tax information. Package also provides various reports (monthly pay-slip generation, pay-register, bank statement, monthly/yearly provident fund reports, salary summary statements, L.I.C. statement, loan recovery statement, monthly/yearly over time statements, employee leave information, various manpower statements, income tax statements i.e. Form 16, Form 24 etc.
-

-   -

-   -
-

4.

-
-

Application software security System

-

-   -

-   -
-

Client

-
-

Binani Cement Ltd.
-

-   -
-

Platform

-
-

Window-98 / NT, HP Unix 10.0
-

-   -
-

Back-end

-
-

Oracle 8i
-

-   -
-

Front-end

-
-

Developer 6.0
-

-   -
-

Team Size

-
-

Two
-

-   -

-   -
-

Role

-
-

Project Leader
and responsible for system analysis, Design, development, troubleshooting and implementation.
-

-   -

-   -
-

Brief

-
-

This system is used to provide security of data & application softwares. It helps to authenticate user through password & then depending on security features like menu rights & terminal rights it allows users to work on certain application & terminals.

It also keeps track of User activities for each application such as login & logout time, options viewed by users etc.
-

-   -

 

-   -
-

5.

-
-

Interfacing of Oracle based Personnel Management & Information system with FoxPro Based Attendance Recording system

-

-   -

-   -
-

Client

-
-

Binani Cement Ltd.
-

-   -
-

Platform

-
-

Window-98 / NT, HP Unix 10.0
-

-   -
-

Back-end

-
-

Oracle 8i
-

-   -
-

Front-end

-
-

Developer 6.0
-

-   -
-

Team Size

-
-

Two
-

-   -

-   -
-

Role

-
-

Project Leader
and responsible for system analysis, Design, development, troubleshooting and implementation. My responsibilities include defining form module specifications, testing of forms & reports, designing reports, creation of schema objects, tablespaces & table level triggers, defining Securities & database Backup.
-

-   -

-   -
-

Brief

-
-

This software is developed towards the integration of Oracle based personnel Management system with FoxPro based attendance recording system in which daily attendance recorded through punch card reader. This system facilitates to load data from FoxPro into Oracle through ODBC & generates detailed attendance information. A daily report of attendance is forwarded to each department head with personnel department comments & department heads provides feedback. The same attendance data is used for the salary processing & generating various reports.
-

-   -

-
  • ACHIEVEMENTS
-

-   -

-   -
-

Developed an object library & a template form for the standardization & it helps developer to develop a form, which considerably reduces development time.
-

-   -
-

All the Projects undertaken are implemented & running successfully.
-

-   -

[Updated on: Fri, 18 February 2005 23:32]

Report message to a moderator

Re: B.E. Comp, 6+ Yrs Oracle & D2K Exp, 3+ Yrs DBA, OCP DBA 9i [message #108183 is a reply to message #106722] Sat, 25 December 2004 00:19 Go to previous message
C A Devarajan
Messages: 1
Registered: December 2004
Junior Member
We are a US Based software services company with 500 employees in US and India. We are looking for experienced D2K, Oracle (exceptions skills PL/SQL) programming and Oracle interals (various features) for our Banking Project.

The placement will be in Bangalore and if this interesting please do get in touch with us immeidately.

Also, please send your updated profile.

Regards,

Devarajan
Previous Topic: Graphical interface tool for RMAN backups
Next Topic: HRMS functional consultant
Goto Forum:
  


Current Time: Sun Nov 28 00:32:36 CST 2021