Home » Other » Marketplace » Sr. Oracle Developer, 10ys,PL/SQL,SQL,PROC*C,OCI,Oracle Developer 2000,C++,Perl
| Sr. Oracle Developer, 10ys,PL/SQL,SQL,PROC*C,OCI,Oracle Developer 2000,C++,Perl [message #105775] |
Wed, 26 June 2002 16:53  |
Yuriy
Messages: 2
Registered: October 2001
|
Junior Member |
|
|
YURIY DEGTYAREV (240) 221-0346
5526 Besley Ct. #107, Rockville, MD 20851 yudegtyarev@yahoo.com
OBJECTIVE
Senior Oracle Developer & Administrator position
SUMMARY
* Senior Oracle Developer & Administrator with over 10 years of the development Oracle Applications and solid background with ORACLE RDBMS, PL/SQL, SQL, PRO*C, OCI, ETL and C/C++ in the multi-platform UNIX and Windows environment.
* Proficient in tuning and administration of Oracle database during installation, development and support.
* Skilful in Application and Oracle Database troubleshooting.
* Experienced in all phases of the Software Development Life Cycle.
* Ability to produce content quickly and accurately under strict deadlines.
* Have strong analytical and problem solving skills.
* Can work as a team player or independently.
* Proven ability to multi-task.
* Work well under pressure.
TECHNICAL SKILLS
* Languages: C/C++, SQL, PL/SQL, SQL*Plus, PRO*C, OCI, Java, Perl (DBI), Shell scripting (ksh, bash)
* RDBMS: Oracle 5.x-8.x (TKPROF, stored procedures, triggers and packages)
* Tools: Oracle Developer 2000 (Oracle Forms & Reports 6i), Oracle JDeveloper, SQL*Loader, Import & Export Utility, SQL*DBA, Oracle Enterprise Manager (OEM), SVRMGR, Oracle DBA Studio, SQL*Forms 3.0, Report*Writer 1.0, TOAD, Oracle Designer 2000, Rational ClearCase
* Operating Systems: Solaris, IRIX, HP-UX, Linux, FreeBSD, SCO, Xenix, X/OS UNIX, Windows 2000/NT
* Hardware: Sun SPARC, SGI, HP 9000, Intel x86-based system, Olivetti LSX 3000
* Internet Technology: HTML/DHTML, CGI, HTTP, FTP, JavaScript, Servlets, Applets
* Other: XML, XSL, XSLT, CORBA (TAO, OmniORB)
PROFESSIONAL EXPERIENCE
2001-2002 System Analyst, InforMax Inc., Bethesda, MD
Projects:
* Tools for removing obsolete data of complex biomolecular structure.
* Library for support of the macromolecule processing.
* Module for genome analysis.
* Embedding the filter tool into protein processing.
* CORBA - Server for the keeping of database repository.
Responsibility:
* Tuned the Database and Application to speed up the process.
* Developed PL/SQL stored procedures, functions and triggers.
* Formulated key and indexing approaches. Created tables, indexes, views and synonyms.
* Defined the consistency constraints for Oracle Database.
* Implemented application on C++ and Oracle, using Oracle Call Interface (OCI).
* Provided support of existing Applications and Systems.
* Installed several patch upgrades to Linux Oracle 8i when sent by Oracle Support.
* Realized troubleshooting of developed and existing applications and modules.
Environment:
Sun SPARC, SGI, INTEL x86-based system; Solaris 8, IRIX, Linux SuSE, Windows 2000/NT; Oracle 7-8i; C++, GNU C++, Java, PRO*C, OCI; CGI, XML/XSL/XSLT, CORBA (TAO, OmniORB), IDL; TOAD
1995-2001 Senior Software Engineer, Commercial bank "Chelindbank", Russia
Projects:
* Processing Center for Bank-to-Bank Money transfer (principal responsibility).
* Server-side Module for Client-bank system (principal responsibility).
* Automated Bank System.
* Data convert system from Visa transaction server to in-house Automated Bank System.
* Reports for several department and Central Bank.
Responsibility:
* Analyzed, designed, developed, debugged and maintained Oracle data model, schemas, and database.
* Implemented stored functions, packages and procedures in Oracle 7-8i.
* Designed, formed, customized and supported reports with Oracle Reports in UNIX and Windows.
* Developed tools for converting and loading data, using OCI, PRO*C, C++, Perl and SQL*Load.
* Implemented User Interface for the document entering and processing with Oracle Forms.
* Met daily price-sensitive deadlines in fast paced financial environment.
* Administrated UNIX (HP-UX, Linux) and Oracle RDBMS.
* Installed, supported systems and developed Backup & Recovery plans.
* Tuned performance of Oracle RDBMS and applications.
* Designed and implemented programs for control background processes with C++, Perl and Shell scripts.
* Provided post implementation problem solving and support.
* Involved in user support, enhancement and bug fixing.
* Tech support & training for End users.
Environment:
HP 9000, Intel x86-based system; HP-UX, Linux, FreeBSD, SCO, Windows 2000/NT; Oracle 7-8i; C++, GNU C++, Perl, PRO*C, OCI; Oracle Developer 2000, SQL*Forms, Report*Writer, SQL*Plus, SQL*Load, Import & Export utility.
1992-1995 Senior Software Engineer, Metallurgy Plant "MECHEL", Russia
Projects:
* System for the production inventory and accounting records.
* System for planning, controlling and recording of productions.
* System for control shipping of integrated products.
* Payment tracking system.
* Voting system for entering and process information after voting.
Responsibility:
* Developed, modified, debugged and maintained User Application with SQL*Forms
* Designed database structure. Created tables and indexes. Developed User Exits with embedded SQL.
* Administrated UNIX (HP-UX, SCO) and Oracle RDBMS. Installed and supported system and database.
* Designed reports for a plant subdivision with SQL*Plus and Report*Writer.
* Migrated data from Oracle V5 to V6 and then from Oracle V6 to V7.
Environment:
HP 9000, Olivetti LSX 3000, Intel x86-based system; HP-UX, SCO, Xenix; Oracle 5-7; C++, PRO*C, OCI; SQL*Forms, Report*Writer, SQL*Plus, SQL*Load, Import & Export utility.
EDUCATION
1992 Master's Degree in Electrical Engineering
Chelyabinsk State Technical University, Russia
|
|
|
|
| Re: Sr. Oracle Developer, 10ys,PL/SQL,SQL,PROC*C,OCI,Oracle Developer 2000,C++,Perl [message #105776 is a reply to message #105775] |
Wed, 26 June 2002 22:24  |
Yashashree Puranik
Messages: 1
Registered: June 2002
|
Junior Member |
|
|
Sir,
I am Yashashree Puranik , working in CMS Computers ltd. as Corporate Trainer for last 2yrs. I have knowledge of all software (Java,C,C++, VB, Internet App.) and NOS(Unix,Linux,Novell(CNE)).
Kindly Please update me for OCP certification ,and it's future.i'll very thankful to You.
Regards,
Yashashree
|
|
|
|
| Re: Sr. Oracle Developer, 10ys,PL/SQL,SQL,PROC*C,OCI,Oracle Developer 2000,C++,Perl [message #105781 is a reply to message #105776] |
Fri, 28 June 2002 06:19 |
sanjit
Messages: 65
Registered: November 2001
|
Member |
|
|
Dear sir,
I am submitting my detailed resume for your kind consideration. Regards,
sanjit
SANJIT KUMAR DASHSenior Design Engineer (IT)MECON Ltd
Mailing Address : G-61, SHYAMALY COLONY
DORONDA, RANCHI- 834002
JHARKHAND, INDIA
( : + 91-651-504931
dash_sanjit@yahoo.com
Professional Summary:
Over 5 years of rich experience in analysis , design and development in different areas like Relational Databases, Client server application, Developer 2000, C,C++ right from Design & Development to Testing, implements programs and support. Assists in preparation of systems documentation, user manuals and maintenance manuals, ISO test documents etc. Good exposure in Standard Libraries, Procedures, Functons, Packages, and Database Triggers. Also, assist in historical back-ups, security and recovery of oracle data in Unix platform. Self-motivating and highly productive individual with excellent analytical and communication skills.
Education:
Bachelor of Engineering ( Applied Electronics & Instrumentation Engineering), Year of Passing : 1993, % of Marks: 73.13, Regional Engineering College, Rourkela. Orissa, India
Technical Skills Summary:
Operating System : Windows NT, Windows 95/98, Unix
Programming Language : C, HTML, C++, SQL
RDBMS : Oracle 7.3x/8.0.5x/8.1.6
TOOLS : Designer 2000, Developer 2000, Visual Basic 6.0, Oracle Java Developer, Oracle Forms 4.5 /
5.0 /6.0, Oracle Reports 2.5, 3.0, 6.0, Designer 6i, Oracle Enterprise Manager
Training Undergone :
Two weeks training on C & C++ (in house training)
Three weeks training on Oracle Developer 2000 & Designer 2000 (in house training)
1 months training on E-commerce concepts, HTML, XML, Java programming using, Oracle J developer, Oracle Application Server, Oracle Developer Server, Web DB from NIIT, Delhi, a premier computer institute of India.
Professional History
August, 1993 till date :- MECON Ltd., Ranchi, India a leading ISO 9001 company consultancy of India, which is engaged in consultation, turnkey execution of various projects in steel , aluminum, power, oil, petroleum and IT projects in India and abroad .
Experience Profile (Last 5 and Half years)
Sl No Project S/W Worked as
1 Voucher Level ComputerisationFor the Offices of the Accountant General, Kerala, India Oracle 8.1.6, HP Unix server, Designer/ Developer-2000 and Win-95 Team Leader
2 Voucher Level ComputerisationFor the Offices of the Principal Accountant General, Karnataka, India Oracle 8.1.6, HP Unix server , Designer/ Developer-2000 and Win-95 Team Leader
3 Inspection Management System for Mathura Refinery of Indian Oil Corporation Limited.(IOCL)Note : IOCL is the leading oil processing and marketing company of India.(Fortune 500) Oracle 7.3, HP Unix server, Designer/ Developer-2000 and Win-95 Team member
4 Enhancement of Inspection Management System for Barauni, Haldia, Panipath, Digboi,Gauhati Refineries of Indian Oil Corporation Limited Oracle 8.0.5, HP Unix server, Designer/ Developer-2000 and Win-95 Team Leader
5 Inspection Management System for Madras Refinery Limited (MRL) Oracle 8.0.5, HP Unix server , Designer/ Developer-2000 and Win-95 Team Leader
6 Contract Management System for Mathura Refinery of Indian Oil Corporation Limited Oracle 8.0.5, HP Unix server , Designer/ Developer-2000 and Win-95 Team Member
Detailed Work Experience:
April 2001 till date
Client : Offices of the Principal Accountant General, Kerala, India
Project: Voucher Level Computerisation
Voucher Level Computerisation is financial accounting package and is for the use of Indian Audit & Accounts Department (AG office). VLC will capture raw data from voucher, challans from State Treasuries and process it to generate Financial Status of State Government. The System would store the Revenue and Expenditure of different heads of State Government collected from different Treasuries, Compile the data and would produce Finance Accounts of one Financial year.
Scope : The functional modules implemented by me is having the following details:-
Account Current Section (AC) section adjusts all the transactions made between the State Government and Central Government ( PAO – Ministry including those of Railways, Department of Ports, Department of Telecommunication and Defence) or between the State Government.This department deals with the Settlement of claims incurred within state or outside state but to be adjusted with outside agencies. Here two types of transactions are taken care of :
Inward Settlement : Transaction has occurred outside state but relates to the state.
Outward Settlement : Transaction has occurred within state but refers to other agencies outside the state.
Book section prepares the monthly civil accounts and submit the same to the Karnataka State Government on basis of output generated by treasury section, treasury accounting, loan and works departments. In addition it maintains detailed accounts of all loans received by State from Central Ministry, Market & Financial Institutions.
Platform : Oracle 8.1.6, Oracle designer 2000 (6i), Forms 6.0, Reports 6.0, PL/SQL, SQL, Windows 95, HP-UX 11
Responsibility: As a Team leader
System study of existing system, preparation of requirement specification ,Worked in development of Account Current and Book modules as Domain expert. Design the system starting with ER diagram using Designer 2000, Report Layout design, Menu Hierarchy design, Guiding the team members in coding of PL/SQL scripts as per business rules ,Written library, stored & form procedures, functions, triggers to increase the performance and maintability of the system . Exporting & importing of data.Back-up, Recovery and Security of data. Preparation of user manual, maintance manual and ISO test documents.Testing of major modules
Total team member – 14
Presently, System design is going on.
August 2000 till date
Client : Offices of the Principal Accountant General, Karnataka, India
Project: Voucher Level Computerisation
Voucher Level Computerisation is financial accounting package and is for the use of Indian Audit & Accounts Department (AG office). VLC will capture raw data from voucher, challans from State Treasuries and process it to generate Financial Status of State Government. The System would store the Revenue and Expenditure of different heads of State Government collected from different Treasuries, Compile the data and would produce Finance Accounts of one Financial year.
Scope : The functional modules implemented by me are Account Current and Book
Platform : Oracle 8.1.6, Oracle designer 2000 (6i), Forms 6.0, Reports 6.0, PL/SQL,
SQL, Windows 95, HP-UX 11
Responsibility: As a Team leader
System study of existing system, preparation of requirement specification ,Worked in development of Account Current and Book modules as Domain expert. Design the system starting with ER diagram using Designer 2000, Report Layout design, Menu Hierarchy design, Guiding the team members in coding of PL/SQL scripts as per business rules ,Written library, stored & form procedures, functions, triggers to increase the performance and maintability of the system . Exporting & importing of data.Back-up, Recovery and Security of data. Preparation of user manual, maintance manual and ISO test documents.Testing of major modules
Total team member – 14
Presently, development is going on.
April 2000 – August 2000
Client : Indian Oil Corporation Limited (IOCL), Mathura, India (IOCL is the leading oil processing and marketing company of India , Fortune 500 Company)
Project: Contract Management System ( CMS)
This system is used to assist various process of contracts awarding like, Estimating, Notice Invited for Tender, Technical and commercial opening, Preparation of comparative statements, Price negotiation and Awarding contract.This module also include Quarter allottment and township maintenance.
Scope : I have involved in development of Quarter allottment, employee leave and township maintenance modules
Platform : Oracle 8.0.5, Oracle designer 2000 (2.1), Forms 6.0, Reports 6.0, PL/SQL,
SQL, Windows 95, HP-UX 10
Responsibility: As a Team Member
Solely responsible for design and development of Quarter allottment, employee leave record and township maintenance modules. Design the system starting with ER diagram using Designer 2000. Designed all data entry screens. Various related reports generated. Various checks, primary key and foreign key constraints were succesfully implemented. Written SQL scripts to handle various DML, DDL and DCL operation and several PL/SQL procedures, functions, Triggers to impose complex business rules. Exporting & importing of data. Back-up, Recovery and Security of data. Preparation of user manual, maintance manual and ISO test documents.Testing of major modules
Total team member – 6
Successfully completed and implemented at site on Nov. 2000.
Oct. 1999 – May 2000
Client : Madras Refinery Limited (MRL), Chennai, India
Project: Inspection Management System ( IMS 2000)
Inspection department is responsible for the inspection and monitoring of the health of the equipments in a refinery. Normally there are about 1000 major static equipments in a refinery. The “IMS-2000” system maintains this valuable database built over many years by the Inspection Department. This valuable information helps in analysis and decision making for the department. The inspection (both scheduled and unscheduled) of these equipments are carried out from time to time and the observations (i.e. the faults etc.) are recorded and then recommendations are given for proper maintenance. Also IMS-2000 system helps in pinpointing the major faults that are observed at some particular location of the equipment as well as the to find out the locations where a particular fault occurs.The package takes care of proper maintenance and speedy retrieval of these information whenever required.
Scope : I have involved in development of Inspection, Schedule, Painting and Welding modules and guide the team member to develop other modules.
Platform : Oracle 8.0.5, Oracle designer 2000 (2.1), Forms 5.0, Reports 5.0, Graphics 3.0, PL/SQL, SQL, Windows 95, HP-UX 10
Responsibility: As a Team Leader
Worked in design and development of Inspection, Schedule, Painting and Welding modules.
Design the system starting with ER diagram using Designer 2000. Report Layout design, Menu Hierarchy design. Guiding the team members in coding of PL/SQL scripts as per business rules
Written library, stored & form procedures, functions, triggers to increase the performance and maintability of the system . Exporting & importing of data.Back-up, Recovery and Security of data. Preparation of user manual, maintance manual and ISO test documents.Testing of major modules
The software was successfully implemented at MRL, Chennai.
Jan. 1998 – Feb. 1999
Client : Indian Oil Corporation Limited(IOCL), Mathura, India
Project: Inspection Management System ( IMS 2000)
Inspection department is responsible for the inspection and monitoring of the health of the equipments in a refinery. Normally there are about 1000 major static equipments in a refinery. The “IMS-2000” system maintains this valuable database built over many years by the Inspection Department. This valuable information helps in analysis and decision making for the department. The inspection (both scheduled and unscheduled) of these equipments are carried out from time to time and the observations (i.e. the faults etc.) are recorded and then recommendations are given for proper maintenance. Also IMS-2000 system helps in pinpointing the major faults that are observed at some particular location of the equipment as well as the to find out the locations where a particular fault occurs.The package takes care of proper maintenance and speedy retrieval of these information whenever required.
Scope : I have involved in development of Master, Datacard, Inspection,Table, Miscellaneous, Schedule, Painting and Welding modules
Platform : Oracle 7.3, Oracle designer 2000 , Forms 4.5, Reports 2.5, Graph 2.5, PL/SQL, SQL, Windows 95, HP-UX 11
Responsibility: As a Team Member
Worked in design and development of Master, Datacard, Inspection,Table, Miscellaneous, Schedule, Painting and Welding modules.Design the system starting with ER diagram using Designer 2000.Report Layout design, Menu Hierarchy design.Written library, stored & form procedures, functions, triggers to increase the performance and maintability of the system . Exporting & importing of data.Back-up, Recovery and Security of data. Preparation of user manual, maintance manual and ISO test documents.Testing of major modules
The software was successfully implemented in Febuary’1999.
Feb. 1999 – Oct. 1999
Client : Indian Oil Corporation Limited(IOCL), headquater, New Delhi, India. Implementation at Barauni, Haldia, Panipath, Digboi and Gauhati Refinery of IOCL
Project: Enhancement of Inspection Management System ( IMS 2000)
This is the enhancement version of earlier one with some additional modules to cater the requirments of all other IOCL refinery.
Scope : I have single handlely completed this project starting from design to implementation.
Platform : Oracle 8.0.5, Oracle designer 2000 , Forms 5, Reports 3, Graph 3, PL/SQL, SQL, Windows 95, HP-UX 11
Responsibility: As a Team Leader
I have design and developed all the modules. Design the complete system starting with ER diagram using Designer 2000. Report Layout design, Menu Hierarchy design. Written library, stored & form procedures, functions, triggers to increase the performance and maintability of the system . Exporting & importing of data. Exporting & importing of data.Back-up, Recovery and Security of data. Preparation of user manual, maintance manual and ISO test documents.Testing of major modules Implementation & Commissioning at Client’s Site .Documentation and User Training
The software was successfully implemented in October’ 1999 at Haldia, Barauni & Panipath Refinery.
OTHER DETAILS :
Date of Birth : 20.10.1970
Mailing Address : S. K. Dash, G-61, Shyamali Colony, Ranchi - 834 002, Jharkhand, India
Contact Phone No : +91-651- 504931 ®
E-mail Address : dash_sanjit@yahoo.com
Maritial Status : Married
Professional Membership : Computer Society of India – Ranchi Chapter
Passport No : A-6661965 with validity upto 2008
Sex : Male
Reference :
Mr. B. Ghosh, Deputy General Manager,IT Section, MECON Limited, Ranchi, IndiaPh. No. - +91 - 651 - 507042® E-mail : rch_bghosh4@sancharnet.in) 1) Ranjit Kumar Dash Ph. No. – 00965-3712681E-mail : ranjit_dash@yahoo.com
(Sanjit Kumar Dash) Dtd. 19 - 05- 2002
|
|
|
|
|
|
| Re: Sr. Oracle Developer, 10ys,PL/SQL,SQL,PROC*C,OCI,Oracle Developer 2000,C+,Perl [message #106708 is a reply to message #105775] |
Sat, 27 March 2004 00:10 |
Prakash C
Messages: 1
Registered: March 2004
|
Junior Member |
|
|
Hi friends,
I want clarification in Oracle forms and Pro*C.
How and where we can interface Oracle Forms data and Pro*C code
|
|
|
|
Goto Forum:
Current Time: Fri Nov 29 22:09:36 CST 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
