Oracle Developer Resume Samples

Description :

1. Gathered the requirements from business users and passed on the requirements to the team.
2. Created custom PL/SQL procedures to read data from flat files to dump to oracle database using SQL Loader.
3. Developed PL/SQL procedures and database triggers for the validation of input data and to implement business rules.
4. Created database objects like packages, procedures, and functions according to the client requirement.
5. Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
6. Used bulk processing for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
7. Extracting the data from simple flat text files in the operational database.
8. Creation of database objects like tables, views, materialized views, procedures, packages using Oracle tools like SQL Loader.
9. Extracted data from existing data stores and perform ad-hoc queries.

Experience

5-7 Years

Level

Executive

Education

BS

Description :

1. Working with the Business Analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
2. Involved in designing an ER diagram using Visio, to set the logical and physical relationships of the database.
3. Developed stored procedures, functions, packages and SQL scripts using PL/SQL.
4. Loading the data into database tables using SQL Loader from the text and excel files.
5. Developed data model, SQL coding, SQL query tuning process, and schemas.
6. Developed SQL scripts, packages, and procedures for business rules check to implement business rules.
7. Using bulk collections, indexes, and materialized views to improve the query executions.
8. Using Ref cursors and collections for accessing complex data resulted from the joining of a large number of tables in PL/SQL blocks and even have experience with exception handling.

Experience

7-10 Years

Level

Senior

Education

Bachelors Of Engineering

Description :

1. Interacting with business analysts and participated in user requirement sessions to analyze and gather business requirements.
2. Coordinating with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
3. Created/developed/modified procedures, functions, triggers, materialized views, packages, simple, ref & traditional cursors, dynamic SQL, table functions as part of project/application requirements.
4. Optimized a lot of SQL statements and PL/SQL blocks by analyzing the execute the plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
5. Developed various backend application programs, such as views, functions, triggers, procedures, and packages using SQL and PL/SQL language for the top management for decision making.
6. Worked on SQL Loader to load data from flat files obtained from various facilities every day.
7. Created and modified several Unix shell scripts according to the changing needs of the project and client requirements.
8. Wrote Unix shell scripts to process the files on a daily basis like renaming the file, extracting the date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.

Experience

2-5 Years

Level

Junior

Education

Bachelors Of Engineering

Description :

1. Documenting business rules, functional and technical designs, test cases, and user guides in the system requirement specifications.
2. Performing the database design at the object level using array and object types.
3. Written PL/SQL scripts for partitioning and indexing database objects like tables, and functions for Oracle databases.
4. Extensively involved in writing PL/SQL stored procedures, functions and database triggers.
5. Extensively written Shell Scripts, Perl Scripts, PL/SQL packages, procedures, and functions.
6. Importing data from different varieties of sources like a flat file, excel file or Oracle dump file into oracle database source schema tables using SQL Loader.
7. Populating the database, exporting and importing data, and creation of packages, triggers, functions and stored procedures for implementing the business logic and database intensive logic.
8. Involving in the creation of dimensional modeling techniques to create dimensions, cubes, and fact tables.

Experience

7-10 Years

Level

Senior

Education

Bachelor Of Technology

Description :

1. Analyzing business requirements of the project by studying the business requirement specification document.
2. Responsible for designing, developing, reviewing, implementing, testing of different modules.
3. Creating database objects queries, tables, indexes, views, materialized views, sequences, primary & foreign keys, constraints, triggers, PL/SQL procedures.
4. Creating constraints on the tables for data validations and for maintaining the clear data without any issues.
5. Creating database objects like tables, views, procedures, packages using Oracle tools like SQL developer, and toad.
6. Extracting data from flat files and transformed it in accordance with the business logic mentioned by the client using SQL Loader.
7. Involved the invalidating the data while data migration by creating PL/SQL packages, procedures, functions, triggers.
8. Modified existing codes and developed PL/SQL packages to perform certain specialized functions.

Experience

10+ Years

Level

Management

Education

BS

Description :

1. Used PL/SQL to create packages, functions, and procedure for user/data validation, request and response.
2. Used PL/SQL and SQL Loader to load data from source file and triggers.
3. Worked on generation of scripts for creation of tables, indexes, views, synonyms, grants, roles and privileges.
4. Created indexes to improve performance and tuning of the SQL queries, which takes a long time to process the request using explain plan, hints to reduce the response time.
5. Perform technical analysis, design, coding, unit testing and problem resolution.
6. Involved in top customer derivation using Global Customer Hierarchy (GCH) golden gate tables.
7. Developed process to identify changes in GCH data and updated top customer according to changes made in GCH system.
8. Involved in developing a process to synch CMDB data based on esp golden gate tables using XML triggers. 

Experience

10+ Years

Level

Consultant

Education

Post Grad

Description :

1. Building complex queries using SQL and wrote stored procedures using PL/SQL.
2. Developed stored procedures, functions, packages and SQL scripts using PL/SQL.
3. Developed interface programs to import parts information to inventory base tables.
4. Establishing Obiee infrastructure and developing next-generation reporting capabilities for business users using Obiee/BI publisher tool.
5. Responsible for development of static reports using Oracle BI publisher and XML.
6. Converted open purchase orders from legacy system to Oracle purchasing using SQL Loader, PL/SQL, packages/procedures.
7. Created host programs using Unix shell scripting for remote database access and FTP of files to the supPLier site database.
8. Developed an interface for item data conversion to load items from flat file to oracle inventory using SQL Loader, PL/SQL, and import items program.
9. Designed apPLication framework and developed oracle apex application.

Experience

2-5 Years

Level

Junior

Education

Bachelor Of Technology

Description :

1. Writing logic to extract all the data and output them to flat files.
2. Working with the business analysts and the dba for requirements gathering, business analysis, testing, metrics and project coordination.
3. Involved in logical modeling and physical modeling of the application using the Erwin tool and created SQL scripts.
4. Developed stored procedures, functions, packages and SQL scripts using PL/SQL.
5. Involving in the creation of conceptual modeling covering all the business requirements.
6. Loaded the data into database tables using SQL Loader from external files.
7. Developed SQL scripts for referential integrity check, which checks the validity of incoming data with master tables in the database.
8. Created ETL design documents for interfaces and mappings, ETL source to target mapping documents, ETL implementation documents using Oracle data integrator ETL tool, unit test plans and deployment checklists documents.

Experience

2-5 Years

Level

Junior

Education

Associate

Description :

1. Extensively developed PL/SQL packages, stored procedures, triggers, and finely tuned them for performance.
2. Extensively used PLSQL tables and bulk loader programs for processing data and loading into oracle tables.
3. Performed extensive defect fixing and support during the client pre-production testing phase, identifying issues and tracking them through hp quality center.
4. Wrote generic PL/SQL code modules (PL/SQL libraries) for reports to handle data manipulations on client.
5. Designed and imPLemented client-server apPLication using oracle forms builder.
6. Involved in the generation of the user interface using oracle forms by extensively creating forms as per the client requirements.
7. Proactively tuned SQL queries leading to significant improvement in system response time and efficiency.
8. Developed Unix scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.
9. Involved in all phases of software development including gathering requirements, creating specifications, development of database objects, developing code and validating programs.

Experience

2-5 Years

Level

Junior

Education

Bachelor Of Technology

Description :

1. Involving in the continuous enhancements and fixing of production problems.
2. Designed, implemented and tuned interfaces and batch jobs using PL/SQL.
3. Involved in data replication and high availability design scenarios with Oracle Streams.
4. Developed Unix shell scripts to automate repetitive database processes.
5. Monitoring committed to keeping accurate records, ensuring on-time deposits, and maintaining tax compliance. Possesses a numerical accuracy and calculating balances.
6. Worked on multiple tasks and multiple database instances at the same time.
7. Worked with ETL team involved in data loading from different sources and data validation process from the staging area to the catalog database.
8. Created page processes in several instances and computations in the apex.
9. Designed application framework and developed Oracle apex application.

Experience

7-10 Years

Level

Senior

Education

Bachelor Of Technology