Rajendra
PL/SQL DEVELOPER
Professional Summary
- Having 5.3 years of overall working experience in SQL, PL/SQL Database Development and Production Support .
- Strong conceptual knowledge of Oracle 11g, SQL and PL/SQL.
- Good Exposure in using SQL Functions, SET Operators and Constraints.
- Experience in Creation of Tables, Views, and Indexes using SQL.
- Good Experience in Developing Complex SQL Queries and Sub Queries.
- Good knowledge in creating Tables, Views, Joins.
- Good Knowledge in implementing Constraints, Joins.
- Good experience in using Cursors and Ref-cursors for processing of data.
- Good Knowledge in PL/SQL stored Procedures, Functions, Database triggers, Exception Handling.
- Ability and willingness to learn new technology and acclimatize to any work culture.
- Strong in data base management concepts, LINUX Skills.
- Experience in UNIX commands and knowledge on Shell Scripting.
- Due to the dynamic nature of the business, Self-motivation & the ability to learn quickly.
- Able to adapt quickly to the environment and willing to work in shifts.
Technical Skills
Languages : SQL, PL/SQL.
Databases : Oracle 19c
Tools : Toad, Oracle SQL Developer.
Operating systems : Windows , UNIX.
- Educational Qualification
- I have completed my B.tech from Intellectual Institute of Technology under JNTU University, Anantapuramu.
- Worked as Software Engineer in Adecco India Pvt Ltd from Bangalore Feb 2022 to Sep 2022.
- Worked as a Software Engineer at Aris Global India PVT LTD from Bangalore Aug,2017- Jan,2022.
Project Experience:
Project # 3:
Domain : Health Care
Environment : Linux
Tools : WinSCP, Putty
Database : Oracle 19c
Project Description:
Sanofi is a global life sciences company committed to improving access to healthcare and supporting the people we serve throughout the continuum of care. From prevention to treatment, Sanofi transforms scientific innovation into healthcare solutions, in human vaccines, rare diseases, multiple sclerosis, oncology, immunology, infectious diseases, diabetes and cardiovascular solutions, consumer healthcare, established prescription products and generics. Our solutions also help improve patient adherence by improving the flow of information among stakeholders. By integrating with third-party networks and provide solutions that ensure processes are efficient, accurate, and timely.
Roles & Responsibilities:
- Analyzed the user requirements.
- Written new procedures by using Pl/Sql Collections and Exceptions.
- Modified existing Packages, Functions, Procedures, complex views and Triggers as per business requirement.
- Wrote Complex SQL Queries using joins, Sub queries, analytical functions to retrieve data from the database.
- Interaction with Client and involved in release meeting and to discuss the post deployment issues.
Project # 2:
Title : Payment Gateway Solutions
Client : Axis Bank
Environment : Oracle 12c, Unix
Project Description:
Axis bank provides services including loans, deposits, online investment services for households and business banking customers. Axis Bank serves customer through its branches and other delivery systems, like In-Store Banking, Online Banking, and the National Financial Services Canter for telephone banking. The main goal of the project was to manage its credit card accounts, web banking, online statements, and bill pay services. As an oracle developer the responsibility was analysed, design and developed packages, procedures and functions using PL/SQL.
Responsibilities:
- Developing the business validation constraints for securing.
- Developing procedure for data collection, deletion and Updating with functional requirements.
- Developing user defined triggers to maintain the security and validity of
- Data Between users.
- Integrated and developed package modules to assist the development process.
- Involved in generating SQL Reports.
- Deploying the procedures, functions, packages.
- Resolving the issues for clients
Project # 1: