PL/SQL DEVELOPER
Danthalasudheerbabu
Mobile No : +91-888******* Email:*******.********@*****.***
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
.