Priyanka Patra

(Oracle Application Developer)

Email:adi6j1@r.postjobfree.com Phone:+91-943*******[India]

Professional Summary:

Having 4.6 years of experience in the study of user requirements, analysis, design, Application Software Development and Maintenance with Oracle Forms and Reports.

Comprehensive experience in testing and implementation of business systems involving Oracle Applications 10g.

Exposure to PL/SQL API’s Customization of code in Oracle Applications.

Proficient in writing stored procedures, Packages and functions using SQL& PL/SQL.

Translate business needs into technical deliverable solutions.

Exceptionally good and experienced in handling the problem and troubleshooting.

Done junior level DBA activities like Table space creation, Schema creation, assigning roles, privileges and grants to users.

Good knowledge in Performance Tuning of PLSQL using Bulk collect, Nested Table and Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Good knowledge on Oracle tools like SQL*PLUS, SQL Developer.

Worked with Pipelined function and Ref cursor to improve performance using

PLSQL tables.

Used PLSQL table to improve the performance of Oracle Forms.

Versatile team player with good communication, interpersonal skills.

Creating test cases and defects for the project in Application Life Cycle Management(ALM).

Having experience on tool Serena-Dimension for objects check-in and check-out.

Skills Summary:

Tools: SQL Developer, Forms Developer, Report Developer, Serena-Dimension, CAST.

Languages: SQL, PL/SQL.

RDBMS: Oracle 10g, 11g.

Operating Systems: Windows.

Work Experience:

Infosys Limited June 2016 to till Date

Role : Oracle Developer.

Back-end : Oracle Database 11g, Oracle forms & reports 10g

Project Brief & Purpose:

Our client is one of the largest shipping company in the world. I am into Booking and invoicing module. In these modules we have several types of booking based on types of cargo, BL generation, container tracking, and container creation etc. Booking module follows a life cycle from confirming a booking to delivering it to consignee. Invoicing module covers billing of different types of charges and generation of invoices for customers. For this we work on Form level procedures and functions along with Database packages and libraries.

Modules:

Booking and Documentation, Invoicing

Roles and Responsibilities:

Developing and maintaining the ERP system using Oracle Forms 10g, Oracle Reports 10g, SQL and PL/SQL

Writing SQL & PL/SQL code (procedures / function / packages / triggers / collection / views/Constraints).

Business functions and collecting customer requirements, classifying the requirements and assigning it to developing new requirements such as reports and user interface enhancements by preparing FSD and getting it signed off.

Education Summary:

Degree

University/Board

Year

Percentage/CGPA

B.Tech

Biju Patnaik University of Technology

2012-2016

8.73

12th

C.H.S.E

2010-2012

73%

10th

C.H.S.E

1998-2010

90.6%

Personal Information:

Name :Priyanka Patra

Date of Birth :12-Nov-1994.

Sex :Female.

Nationality :Indian.

Marital Status :Unmarried.

Languages :English, Hindi, Odiya.

Declaration:

I do hereby declare that the above-mentioned details are true to the best of my knowledge and belief.

Priyanka Patra

Contact this candidate