Oracle PL/SQL Developer Resume

Title
Oracle PL/SQL Developer

Primary Skills
Oracle Form and Reports, PL/SQL, Java

Location
India-Kolkata (will consider relocating)

Posted
Jan-06-09

MOUSUMI DAS




1 year+ of Industrial experience in Euphoria Infotech (I) Pvt. Ltd.
Current designation Junior Software Engineer


Educational Background


MCA (Master Degree) 2007 with 8.2(DGPA)
University : West Bengal University of Technology
Registration No : 121051012008 of 2004-2005
Institution : Bengal Institute Of Technology
Address : Kolkata, West Bengal, India

BSc (Mathematics Honours) 2004 with 53.75%
University : Calcutta University
Registration No : 059300 of 2000-2001
Institution : Seth Anandram Jaipuria College
Address : Kolkata, West Bengal, India

Higher Secondary Examination (12th standard), 2000 with 66.5%
Board : West Bengal Council of Higher Secondary Education
Registration No : 01085-0086 of 1998-1999
Institution : Baghbazar Multipurpose Girls' School (Govt. Sponsored)
Address : Kolkata, West Bengal, India

Madhyamik Pariksha (10th standard), 1998 with 78.88%
Board : West Bengal Board of Secondary Education
Registration No : 1132-03811of 96-97
Institution : Sree Ramkrishna Sarada Sangha Balika Vidyalaya
Address : Kolkata, West Bengal, India



Technical Skills

Web Technologies : JAVA, JSP, JDBC, J2EE technologies
Software Languages : SQL, PL/SQL, HTML
Operating Systems : Windows NT, Windows 2000, Windows XP, MS-DOS.
Databases : Oracle 9i, 8i
Web Server : Apache Tomcat 6



Professional Project


Title: Online Exam Application
Platform: ApacheTomcat6, JDK1.6, HTML, JSP, Oracle 8i.
Team Size: 3



Abstract


This development effort is a web-based system to give online examination & subsequent procurement of certificates. The entire procedure of examination starting from registration, enrollment for a particular exam, procurement of certificates. It has an admin panel that does administrative works like cheque validity, enrollment of a candidate, certification. Also it has another area i.e. user area where registration, login, examination (free/payable) and certification process is done.

.
Role and Responsibilities


1 Team Member
2 Environment setup, Database design, Project structure design
3 Using Java Beans for retrieving results from Database
4 Checking Data-Flow in JSP pages
5 Some research works



Industrial Project


1) Title: BSNL Sampark Project
Organisation: Euphoria Infotech (I) Pvt. Ltd.

Project Description:

Project Title BSNL Sampark Project
Client Name Sampark (BSNL)
Role Developing TRICON offer package, Coding & Implementation ,Support, Designing
Team Size 3
Environment Skills: Java, JSP (Front End)
Oracle (Back End)
Web Server: Apache Tomcat6
OS: Linux
Duration 2 months

BSNL is one of the most renowned telecommunications company in India. TRICON package developing was the part of this project. It was a offer for postpaid customers. Customers who apply for this package through mail, SMS or by calling firstly saved in the primary database server in the head office. Then a copy of those customers mapped with local database server using JAVA. Local database administrator can see those particular data at a regular timestamp trough JSP and also update accordingly as per customer who are interested to take this tariff plan. Following major activities are carried out in this project:

? Developing a page per customer with update facility.
? Connect those JSP with server.
? Support the application from Front End as well as Back End.
Responsibilities & Key Areas of working:

• Coordinating with the whole team and with the business.
• Developing JSP page as per client requirements.
• Designing and developing the package using Java technology.
• Documenting new information in regular basis after testing.
• Good understanding of business application.



2) Title: Creating Module of Hastings Jute Mill, Rishra
Organisation: Euphoria Infotech (I) Pvt. Ltd.

Project Description:

Project Title Hastings Jute Mills ERP Project
Client Name Hastings Jute Mills
Role Client Interaction, Coding & Implementation ,Support, Designing
Module Working in Stores Management, HR Management
Team Size 7
Environment Skills:
Front End: Oracle PL/SQL, Oracle Forms and Reports
Back End: Oracle 10G
OS: Windows XP

Duration Till Date
The Stores Department of Hastings Jute Mill maintains stock of all the items (except raw jute) related to production and daily needs to run the mill properly. This department runs only in the day shift. In case of any emergency requirement store supplies the required material to concerned department in the night.
The HR Department of Hastings Jute Mill maintains employee details of all departments. It operates from the Head Office.
The system context highlights important characteristics of the system: users, external systems, batch inputs and outputs, and external devices.
? Events that the system generates that affect external entities.
? Data that the system receives from the outside world and that must be processed in some way.
? Data produced by the system and sent to the outside world.
The Main functionality of Stores department are as follows -
• General Stores Maintenance
• Repairing Maintenance
• Job work Maintenance

General Stores Maintenance
The Processes of stores department can be categorized in the following manner --

1. Requisition by user department to stores.
2. verification of stock
3. Indent generation.
4. P.O. (purchase order) generation.
5. Challan entry at Mill Gate (At the time of delivery)
6. Challan register entry (After receiving items at Stores)
7. Short/Excess maintenance.
8. Intimation to user department for verification.
9. Inspection by user department.
10. Rejection.
11. Store receipt generation.
12. Issue pass generation.
13. Amendment of P.O. (if required)
14. Amendment of S.R. (if required)
15. Bill Maintenance
Repair Maintenance
Store also manages items which are sent outside for repairing purpose. The Process flow in this case is as follows --

1. Repair Purchase Order
2. Repair challan by mill (sent to party)
3. Receive party challan (sent by party after repairing)
4. Intimation to user department for verification.
5. Inspection by user department.
6. Rejection.
7. Store receipt generation.
8. Issue passes generation.
9. Amendment of S.R. (if required)
Job-Work Maintenance
Any Mechanical or civil jobs inside Factory are maintained thorough Stores. The processes involved are,
1. Job Order
2. Job Card Maintenance


The Main functionality of HR department are as follows -
1. Recruitment/Regularization/Promotion
2. ESI
3. Standby Labour Attendance
4. Job allocation against departmental requisition
5. Leave
6. Absenteeism/ Disciplinary actions
7. Termination of employment
8. Transfer

The following major activities are carried out in the project.

? Developing above procedures using Oracle Forms as per requirements.
? Creating various Store Reports as per requested by Head Office.
? Support the application from Front End as well as Back End.
Responsibilities & Key Areas of working:

• Coordinating with the whole team, application owners, Business Area Managers and directly with clients in most of the situations.
• Developing FORMS and REPORTS as per client requirements.
• Coding in Oracle 10g for the purpose to support of Stores Module & HR Module.
• Documenting new information in regular basis after testing.
• Good understanding of HR application.
• If any job is about to fail, finding the reason of its failure or delay.
• Creating Different documents such as test cases, reference documents etc.



Other Relevant Information


Current CTC: 68,208 p.a.
Expected CTC: 2, 50,000 p.a.
Notice Period: 1 month




Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Kolkata, India | Resumes in India

View other Oracle PL/SQL Developer resumes, Programmer / Developer resumes