Talent's Information
-
Location
Anandapur, India
-
Rate
$10.0 per Hour
-
Experience
3 Year
-
Languages Known
English,Hindi
Available for
Background Verification
40 Hr/Week
About Rajata S
Having 3.3+ Years of working experience as an ORACLE PL/SQL Developer which Includes good knowledge of Database, and worked extensively in Oracle 11g/12c, SQL, and PL/SQL good knowledge on Unix and Banking domain.
Tech Stack Expertise
-
Oracle
Oracle 11G
3 Years
Work Experience
SQL Developer
- January 2020 - July 2023 - 3 Year
- India
Projects
LLMS (Loan Life Cycle Management System)
- November 2019 - January 2023 - 39 Months
Technologies
Role & Responsibility
This Project is about loan management for the users of SBI. It had three phases Sanction, Pre-Sanction, Post Sanction. It is a huge repository of client data where all the information of the client’s background & current status is maintained and the loan is sanctioned.
The information is generated & maintained by the risk rater & various Committee then the analysis of the risk involved in this loan is calculated by the committee & finding out if any possibility of new business from there is also analyzed & on the basis of various control reports & Proposal reports, Credit reports are generated.
DEVELOPMENT RESPONSIBILITIES:
Database Designed and Developed as per client requirements.
Developed complex functions, procedures, and packages.
Tuning SQL code and PL/SQL procedures/functions.
Creating the tables, and checking the constraints.
Involved in coding Database Triggers.
Involved in developing, designing, analyzing, and discussing business requirements.
Involved in analyzing the impact of the new development on the existing system, Creation of Design documents, Development and Testing.
Involvement in end-to-end development and bug fixing.
Involvement in critical logic Analysis.
Generation of Reports for the business analysts and end-users as per client’s requirements.
Master Data Migration from source server to target server through DB_LINK.
In shell Scripting worked on directory changes for .log,.err ,.txt type file add $\LOG_DIR to free the $\bin directory.
Soft Skills
Industry Expertise
Education
in B. Tech
Odisha University- June 2015 - June 2018
