Plsql Developer Core Java

SIDHANTA KUMAR JENA PLSQL DEVELOPER

Bangalore, India

+91-706*******

**************@*****.***

www.linkedin.com/in/sidhanta-jena

PLSQL developer with 4.1 years of experience in developing and maintaining database application using oracle PLSQL and experienced in various aspects of database development, performance tuning, and application integration. Passionate about creating maintainable and reliable software, committed to staying current with industry trends and technologies.

●SQL

●Linux

●CORE JAVA

●T-SQL

●Zira

● PL/SQL

●Git

●SQL*Loader

●HTML

●SDLC PROCESS

V2Soft

PL SQL Developer 2021 – Present

•Optimize complex SQL queries and Stored procedure, reducing execution time by 20% through indexing strategies, query refactoring, and execution plan analysis.

•Hands on Experience in programming Language CORE JAVA.

•Implemented full SDLC lifecycle in 2 Agile projects.

•Hands on Experienced in Database programming using Oracle PL/SQL.

•Involved in writing PL/SQL Stored Procedures, Functions, Cursors, Triggers and Package.

•Written complex SQL (Sub queries and Join conditions).

•Troubleshoot and debug system and/or data errors.

•Proficient in creation, modification and effective use of database objects like Tables, Constraints, Indexes, Group Functions, and Views.

•Ability to understand the business requirements and Data models & Performance Tuning.

•Vast Experience in Oracle advance SQL Programming Using Analytical functions, Sub Queries,

indexes and Set Operators.

•Proficient knowledge in performance tuning and knowledge to work according to the Work Request and Change Request.

•Experience and Excellent Exposure in Query tuning using Materialized Views & Indexes.

•Excellent written, presentation and verbal communication skills.

•Proficiently utilized Git & Git Hub for version control, ensuring effective collaboration and code management within development teams.

OTM Sales Crediting 2021- Present Technology: SQL, PLSQL, DYNAMIC SQL, MYSQL

Tools: JENKIN, MAVEN, GIT HUB, ETL TOOL, SQL*LOADER

Type: Agile Scrum Process

Description: The project deals with assigning credits for orders booked in ERP system (Upstream).

The main sales crediting engine is a group of PL/SQL packages and procedures performing multiple validation and enrichment of order details using data from various reference systems and calculate sales crediting.

Assignment of sales credits is done via OTM (Oracle Territory Manager).

•Designed PL/SQL logic, functions, triggers, and packages for data operations and complex queries.

•Optimized SQL and PL/SQL, reducing query time by 20%, and maintained existing codebase.

•Enhanced system with new features, adhering to business needs and ETL processes.

•Integrated external data using SQL*Loader, automated imports, and optimized database performance.

•Documented specs, schemas, and procedures and collaborated across teams for integrated solutions.

•Responsible for doing analysis and code changes required for bug fixing and troubleshooting the system.

•Involved in daily incident resolution and handling change requests.

•Responsible for doing manual testing, unit testing after code changes / bug fixes

•Interacted with Clients and Architect to provide the analysis/solution and communicate the instructions.

•Agile methodology to prioritize iterative development, frequent feedback, and continuous improvement, ensuring timely delivery of features and meeting customer expectations.

●B. Sc in Computer Science 7 CGPA Utkal University, Odisha 2019

● Oracle 19c SQL & PL/SQL Certification Durga Software Solutions Hyderabad 2021

●Cloud Computing NPTEL (IIT Madras & MHRD-approved, Govt. of India) 2021

RELEVENT PROJECT

EDUCATIONAL QUALIFICATION

CERTIFICATIONS

Contact this candidate