Oracle PLSQL Developer Resume Samples

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.

Experience

10+ Years

Level

Senior

Education

Bachelor's In Electronics

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.

Experience

2-5 Years

Level

Junior

Education

Bachelors In Electrical

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.

Experience

0-2 Years

Level

Junior

Education

Bachelor Of Science

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.

Experience

5-7 Years

Level

Executive

Education

Bachelors

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.

Experience

5-7 Years

Level

Executive

Education

Masters Of Computer

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.

Experience

2-5 Years

Level

Junior

Education

Bachelor In Electronics

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.

Experience

2-5 Years

Level

Junior

Education

Bachelors

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.

Experience

5-7 Years

Level

Executive

Education

Bachelors

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.

Experience

2-5 Years

Level

Junior

Education

Bachelors

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.

Experience

2-5 Years

Level

Junior

Education

Bachelors