Oracle PLSQL Developer Resume Samples

The core job duty of an Oracle PL/SQL Developer is to analyze and ensure an efficient transition of technical design documents and developing various SQL packages to render support for all application developers. A professional Oracle PL/SQL Developer Resume mentions the following duties and tasks – developing and providing support to all system interfaces; monitoring and recommending changes as needed to all PL/SQL packages; providing stores procedures and designs and developing various relational databases; evaluating all architecture for Oracle applications, and preparing layouts for all logical models.

Those seeking to work in this line should depict on the resume the following skills – experience with Oracle Version 10g, 11g and 12c; hands-on development using Oracle Pl/SQL; the ability to provide technical assistance and troubleshooting support; and the ability to stay current with evolving new and upcoming technologies. A Master’s degree in Computer Sciences, Information Technology, or a related discipline is the minimum requirement.

 

Oracle PLSQL Developer Resume example

Oracle Plsql Developer Resume

Summary : Over 7 years of experience analysis, design, development, testing business applications in OLTP, web based, Client/Server architectures. Proficient analyzing providing client-focused, high quality analysis, testing support of development implementations Oracle Data Warehouse which supports variety business requirements via numerous distributed database applications.

Skills : Testing support, Database applications.

Description :

    1. Involved developing, testing implementing  Endeavor project.
    2. Worked developed different forms reports for Global tracking, LDC reports  Ship audit purposes.
    3. Developed PL/SQL stored procedures, functions packages for freight transportation system  company.
    4. Developed PLSQL based applications for invoicing, maintenance, time store receipt, weekly trailer information and for different tracking purposes freight.
    5. Developed, worked various shell scripts automate loading vendor feed information into different systems.
    6. Worked on Putty server and Humming Bird Exceed Server for different program units while working on UNIX.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Bachelor's In Electronics And Communication Engineering


Sr. Oracle Plsql Developer Resume

Objective : Having over 7 years of total experience IT phases of SDLC including requirement gathering, analysis, application design, development, testing, implementation maintenance. Experience relational databases like 11g, 10g and 9i. Extensive SQL PL/SQL programming experience including packages, stored procedures, functions, triggers, indexes ,exception handling.

Skills : Stored procedures, Exception handling.

Description :

    1. Used Oracle JDeveloper to support JA Built complex queries usin modified a number of Forms and for various modules.
    2. Responsible for following up bugs reported various users  suggesting possible patches applied.
    3. Wrote Shell Scripts for Data loading and DDL Scripts.
    4. Worked  Production Support Environment QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
    5. Used Oracle JDeveloper to support JAVA, JSP  HTML codes used in modules.
    6. Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions packaged migrate data from SQL server databas Oracle database.
    7. Extensively used SQL PLUS, TOAD and SQL Loader for different programs as required.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors In Electrical And Electronics Engineering


Jr. Oracle Plsql Developer Resume

Objective : PL/SQL Developer with 7 years of professional experience Design, Development Implementation enterprise Oracle databases applications both OLTP , Decision Support systems. Highly experience working with OBI dashboards, BI publisher, OBI delivers. Experience with Oracle SQL ,PLSQL programming used various oracle utility tools like Toad, SQL Developer, SQLPlus, SQLLoader, Sql Navigator.

Skills : Oracle SQL ,PLSQL programming.

Description :

    1. Gathered the requirements and documented high level documentation for the project Exposure to the entire process of Software Development Life Cycle Involved in database design, tuning, triggers, functions, materialized views, Oracle Job Scheduler, Oracle Advanced Queuing Involved in Production Support.
    2. Resolved issues related enterprise data ware house, stored procedures in OLTP system, designed and developed ETL strategies.
    3. Performed query performance tuning, generated complex correlated sub-queries  improve queries generated by Explain Plan.
    4. Performed tuning of SQL queries , stored procedures  resolve and trouble shoot issues in OLTP environment.
    5. Created Indexes, analyzed  table statistics ,Table partitioning.
    6. Created stored procedures, functions, Packages, Data base triggers, constraints, indexes, grants, materialized views, sequences based on business requirements.
    7. Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.
Years of Experience
Experience
0-2 Years
Experience Level
Level
Junior
Education
Education
Bachelor Of Science In Electronics And Communication Engineering

Asst. Oracle Plsql Developer Resume

Headline : Around 8+ years programming experience as an Oracle Developer Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using Oracle Relational Database Management System (RDBMS). Experience Data Extraction, Transformation Loading (ETL) processes.

Skills : SQL Developer, SQLPlus, SQLLoader, Sql Navigator.

Description :

    1. Involved in writing PLSQL procedures Packages as part  implementation production support.
    2. Coded interface specific SQL Loader control files, PL/SQL package and SQLPlus Script (For building interface table related synonyms, indexes, granting privileges, defining value sets, concurrent programs, parameters, request group, adding concurrent programs to request groups).
    3. Participated in system analysis data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors packages.
    4. Customized various reports as per customer requirements.
    5. Customized forms to capture info like Customer Deposit.
    6. Worked on rebuilding  interfaces and customizations using Oracle PLSQL.
    7. Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, Stored PROEDURES/FUNCTIONS/PACKAGES using SQL PLUS session in silent mode.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelors

Associate. Oracle Plsql Developer Resume

Headline : With 11+ years, in information technology industry wide range experience Oracle SQL / PLSQL Development, Performance Tuning, Shell Scripting Database Administration. Having experience Analysis, Design, Development, Support. Having experience working Client interaction offshore co-ordination.

Skills : Oracle SQL Performance Tuning, Oracle Database Administration, Shell Scripting.

Description :

    1. Incorporated all the build rules, writing the code using SQLPLUS, PL/SQL.
    2. Improved performance  existing report views using hints.
    3. Managed knowledge transfer sessions to support resources.
    4. Wrote high-level specifications and detailed specifications.
    5. Atomized entire business flow into different modules like Equipment, Spare Parts and  Vendors.
    6. Upgraded financial reports according  specifications of different Service Managers Customer Advisors.
    7. Customized forms to capture info like Customer Deposit.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Masters Of Computer Applications In Computer Applications

Oracle Plsql Developer III Resume

Objective : Over 8 years of Oracle experience Oracle SQL, PL/SQL Oracle developer/PL/SQL developer Analysis, Design, Data Modeling, Implementation of Business Applications using Oracle Relational Database Management System Extensive experience in SQL, PL/SQL, SQLLoader Utilities, Oracle Reports 6i/10g, UNIX Shell Scripts, XML, BI Publisher.

Skills : Oracle SQL, PL/SQL Oracle.

Description :

    1. Developed complex PLSQL packages to implement  business logic adhering standards of Oracle HRMS APIs coding standards.
    2. Modified various code flows in SALADMIN component in the process of solving Service Requests implementing Enhancements.
    3. Enhanced SQL queries involved APIs  Compensation module for Performance  Optimization.
    4. Extended and modified various OA Framework components in the process of resolving the customer bugs.
    5. Actively supported the time critical and high severity issues by resolving them with great quality.
    6. Used Bulk Collect and For All for processing huge volumes of data.
    7. Wrote PL/SQL Database triggers to implement business rules.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelor In Electronics And Telematics Engineering

Oracle Plsql Developer II Resume

Objective : Over 8+ years of experience analysis, handling databases in Oracle. Expertise in Full Life Cycle Development including Planning, Analysis, Design, Implementation , Maintenance. Good Understanding Data Warehousing Concepts likes Star schemas ,Snowflake Schemas.

Skills : Design, Development, Support.

Description :

    1. Proposed changes to the existing Database Architecture  requirements  Involved in redesign of database.
    2. Modified existing ETL processes new requirements.
    3. Upgraded financial reports according  specifications of different Service Managers Customer Advisors.
    4. Created new Tables, Indexes, Views, Materialized Views, Table Partitions  requirement.
    5. Involved in writing data Migration scripts/create table scripts to load database successfully from old schema to new structured schema using SQLLDR, Export/Import.
    6. Modified existing and created new SQL, PL/SQL Packages, Procedures, Functions and views requirement.
    7. Extensively used PL/SQL Collections, Table Types and Record Types.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors

Oracle Plsql Developer I Resume

Headline : Strong hands-on experience of 10 years with large IT organization requirement, analysis, design, development, testing, implementation, maintenance review. Well versed developing various database objects like Packages, Stored Procedures, Functions, Triggers, Tables, Indexes, Constraints, Views others in Oracle 11g/10g /9i databases.

Skills : Oracle 10G, PLSQL, PLSQL, UNIX Scripting, UNIX Scripting, GIT, SQL Server, Control M, Control M.

Description :

    1. Involved in Analysis, Design, Development phases of the project Developed Requirement Specifications, Functional  Technical Design Documents.
    2. Transferred knowledge  paper using Architectural diagrams, process flows  documented whole system which includes data modeling of e-transfer Business flow.
    3. Created numerous PL/SQL stored procedures, packages, functions and UNIX shell scripts.
    4. Implemented  complex logic required for fee analysis and monthly paper statement generation for Amex e-transfer users Written SQL reports and scheduled these reports from UNIX scripts using CRONTAB.
    5. Generated scripts  tuned them for adhoc reports  per business team Specifications.
    6. Worked  performance tuning used EXPLAIN PLAN Toad/SQL Navigator for tuning the queries.
    7. Attended meeting with business analyst to get new requirements for application.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelors

Lead Oracle Plsql Developer Resume

Objective : Over 5 years of IT experience with extensive experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing Documentation. Extensive Data Warehouse experience using Informatica Power Center (Source Analyzer, Repository Manager, Mapping Designer, Mapplet Designer, Transformation Designer)Oracle Database.

Skills : .

Description :

    1. Project: Provident Fund & Pension Scheme Revamp (PFPS) Provident Fund & Pension Scheme Revamp (PFPS) - Provident Fund & Pension two elements which attaching to  person payroll and process pay check with normal payroll run.
    2. In UAE there two types  pension schemes with different eligibility criteria running for almost 10,000 DNATA employees both aviation IT sector.
    3. Responsibilities: Enhanced existing Pension & Provident Monthly Payroll Processes by reducing processing time from 6 hours to 10 minutes.
    4. Developed new Exceptions & Variance reports used  Monthly Payroll Processing related to PFPS.
    5. Created multiple common Web Services to be used for Internal projects across  DNATA Group for obtaining HRMS related data from Oracle ERP  Element Details, SIT Details, EIT Details, Element Entry, Batch Element Entry, Lookups, etc.
    6. Created various XML Publisher Reports  Oracle Alerts.
    7. Implemented complex Payroll calculations using Oracle Fast Formulas.
    8. Developed various interfaces  used for interfacing PFPS data between systems like LET, Candidate Portal, PUM, ETR, PTR, and Oracle ERP.
    9. Development of BR100's, master BR100 for various modules, and lines of businesses Development of test cases and executing test scripts of various extensions and interfaces.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors

Oracle Plsql Developer Resume

Objective : Around 8 years of experience Application Development using Oracle SQL, PL/SQL. Experienced interacting with Business Users, Business Analyst, IT Leads, Developers System Analysts gather analyze business requirements ad translating requirements functional technical design specifications.

Skills : .

Description :

    1. Description:  Computerized system aimed  meet below requirements  Maintenance Module and ensure accuracy, consistency and timeliness information.
    2. This project consists of Major modules like Equipment, Service Log, Scheduling, Preventive Maintenance, Spare Parts and reports module.
    3. Project Atomized entire business flow into different modules like Equipment, Spare Parts and  Vendors.
    4. Responsibilities: Designed the database for major modules like equipment, service log scheduling modules  Modules  developed  such way that they are based on business workflow.
    5. Revised Oracle Stored Procedures eliminate manual intervention from users.
    6. Developed Trouble call module which will automatically assigns  trouble tickets mails then using UTL_SMTP  concern department  severity levels trouble.
    7. Involved  Service Log module to develop records maintenance activity for all equipment.
    8. Shows failure code, down time, who worked and when, parts used and comments by using Triggers and Functions.
    9. Involved in dynamic reporting for developing online reporting system in which it includes reports like Safety, History card, Lubrication Pending/Completed, Breakdown Analysis, Spare Assembly Pending, PM Schedule Jobs Pending, Breakdowns, Expenditure Etc.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors