Oracle PL/SQL Developer with over 3 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, and maintenance with timely delivery against aggressive deadlines.
Overview
4
4
years of professional experience
1
1
Language
Work History
Oracle PL/SQL Developer
Primus Global Technologies PVT LTD
12.2022 - Current
Project :- Oriflame Sweden
Domain:•Consumer Industry / Distribution,
Client: Oriflame.
Involving in the full development cycle of Planning, analysis, design, development, testing, and implementation.
Created and modified SQL, PL/SQL scripts for data conversions and well experience on performance tuning.
Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
Wrote SQL, PL/SQL programs required to retrieve data using cursors and exception handling.
Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
Coordinating with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
Involved in the continuous enhancements and fixing of production problems.
Generated server-side PL/SQL scripts for data manipulation and validation and materialized Views for remote instances.
Developed PL/SQL triggers and master tables for automatic creation of primary keys.
Completed application coding assignments that meet provided technical specifications and end-user requirements.
Participated in the design process that generates application functional and technical specifications.
Documented the application design specifications and implementation procedures to improve Application quality and reuse of code.
Assisted in the creation of unit, integration, function, and performance test scripts to improve application quality and ensure fulfillment of requirements.
System Associate
WNS Global Services
05.2022 - 09.2022
Project :-Syneos Process
sql dabase management.
updating, inserting correct details of patients in database and also their medications.
writing complex queries to extracting data from various tables using joins, subqueries, group functions, analytical functions, "with as" clause.
Applied advanced Excel skills to create user-friendly templates for efficient data entry and manipulation across projects.
Trainee Engineer
M.G.Nair Pvt Ltd
04.2021 - 04.2022
Traveled to job sites with senior personnel to aid in inspections and ongoing project observations.
Assisted in the design of engineering projects, resulting in higher quality outputs and better client satisfaction.
Assisted with preparation of client presentations using AutoCAD and Microsoft Office.
Senior Android Tv Launcher App Developer at Primus Global Technologies Pvt LtdSenior Android Tv Launcher App Developer at Primus Global Technologies Pvt Ltd