PL/SQL DEVELOPER

Danthalasudheerbabu

Mobile No : +91-888******* Email:ac72e9@r.postjobfree.com

RANGE OF EXPERIANCE:

I am Oracle Developer having 3.6 years of experience in related insurance Services domain with significant technological-functional exposure, gained from working with major Banking Company with focus on functional requirement gathering, planning, analysis and development.

Having 3.8years of experience in the areas of Oracle and PL/SQL based applications using Oracle PL/SQL and SQL under Windows and Linux Environments.

Good understanding in entire Software Development LifeCycle (SDLC).

Having database experience using Oracle SQL, PL/SQL, Cursor, Stored Procedures, Functions, Package, Exception Handling, Constraints, Triggers, Index, Views.

Involved in Development of the applications through Oracle using PL/SQL created Tables, cursors and SQL Queries.

Good Understanding of Business logic and ability to work well as a part of a team and as an individual.

Debugging and troubleshoot the functional and applications issues.

Knowledge in conducting unit test

Creating Views, Sequences by maintaining the standards to meet organization requirements and customer expectations.

Experience in loading data from Flat files to Database tables by using SQL * LODERand Migrating data from Database to Flat files by using UTL_FILEPackage.

Dedicated work ethics, self-motivated, self-initiative and good team communicator. Exceptional ability to learn.

Technical Skill Set:

Languages : SQL, PL/SQL.

Operating System : UNIX/LINUX, Windows 7, 8,10,

Tools : SQL*PLUS, SQL Developer.shell script

Database : Oracle 10g, 11g

Professional Experience:

Working as a Software Developer with VENGAI SOFTWARE SOLUTIONS PVT LTD, Hyderabad from November 2014 to Till Date.

Educational Details:

Completed B Tech in the streams of Electronics&Communication engineering from JNTU, Kakinada.

Project 1:

Title : Banking application

Client : CANADAIAN IMPERIAL BANK OF COMMERCE

Role : PL/SQL developer

.Duration : JULY-2015 to DEC-2017.

Technologies : Oracle 11g, SQL,PL/SQL.

Environment : windows7, SQL DEVELOPER.

Description:

The bank is providing lending services to customers in various categories such as personal loans, Housing loans, vehicle loans, Education loans, top up loans etc. It maintains the details of all the candidates who are shown interest to take loans from the bank. It also maintains applicant details, loan sanction details, loan disbursement details, EMI details etc. It generates various reports are per the requirement of bank and customers.

Responsibilities:

Creating several tables as per the project specifications.

Performing table maintenance operations

Creating integrity Constraintsto maintain valid data

Creating Indexes to improve performance

Creating Triggers for enhanced validation and business rules implementation

Inserting external data by using SQL*Loader

Writing Packages with the suitable procedures and functions for the business activities of the bank such as analyzing enquiries, applicants,

Writing necessary code for the business process such as sanctioning loan, fixing EMIs

Writing UNIX level scripts for performing server side database programming

Monitoring the SQL queries and tuning the queries

Debugging the code

Conducting unit tests

Project #2:

Title : Zenith Insurance Company

Client : USA

Duration : DEC-2018 to till date

Role : PLSQL Developer

Technologies : Oracle11g, SQL,PLSQL

Environment : windows7, SQL DEVELOPER

Description:

This Project is for Storing and Maintenance of the insurance data ofZenith Insurance Company. It is a top insurance brokerage company in U.S. It is global leader in Insurance and Risk management solutions. It works for Personal lines and Commercial lines insurance. For maintaining data related to insured’s, insurers, certificate holders and mortgages information. Storing and Maintenance of the client’s data using this application

Roles & Responsibilities:

Providing PL/SQL support to the team and working with developers on any SQL query related problems

Developing Stored Procedures, Functions, Packages, Views and triggers to process business logic

Coordinating with Java Team in Data base issues

Creating tables, Constraints, Indexes, sequences, joins and sub queries

Coding for the improvement of the performance

.

Contact this candidate