We provide IT Staff Augmentation Services!

Senior Oracle Developer Resume

5.00/5 (Submit Your Rating)

Harrisburg, PA

SUMMARY

  • 7 years of experience in analysis, designing, developing and implementing database applications and solutions as Oracle PL/SQL Developer.
  • Excellent skills in designing and development of applications using Oracle 11g/10g/9i/8i, SQL, PL/SQL, Oracle Forms 11g/10g/9i/6i, Oracle Reports 11g/10g/9i/6i, Oracle APEX3.0/4.0, BI Publisher.
  • Expert in Oracle tools like SQL * PLUS, SQL Developer.
  • Highly proficient with Oracle applications development tools within a client/server environment.
  • Excellent SQL skills, expertise in writing Complex SQL queries, PL/SQL Stored Procedures, Functions and Packages for business needs.
  • Expertise in creating Oracle objects like Tables, Synonyms, Triggers, Indexes, Views, Materialized Views and Table Partitions.
  • Proficient in advance features of Oracle for PL/SQL programming like using cursor variables, Ref. cursors, Varrays, nested tables and Dynamic SQL.
  • Expertise in Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk Collect feature, FORALL statements, and Troubleshooting Oracle database issues.
  • Expertise with Data Migration, Data Mapping or Table mapping, Data loading and exporting by using Import Export, SQL*Loader.
  • Good noledge of Data Modeling, Data Warehousing concepts, OLAP Concepts, Star Schema, Snowflake Schema, and Entity - Relationship Diagrams.
  • Excellent Database modeling/designing skills using Erwin, ER Studio, SQL Developer Data modeler.
  • Experience in designing and development of Oracle Forms and Reports.
  • Worked in various levels of SDLC (System Development Life Cycle) which involves Analysis, Design, Development, Testing, Implementation and support with extensive exposure in database.
  • Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
  • Ability to perform well as a Team Member to blend well in any situation and environment.

TECHNICAL SKILLS

Database Tools: SQL*Plus, SQL Developer, SQL Navigator, Toad, APEX, Erwin Data Modeler, EXCEED

Databases: Oracle 11g/10g/9i

Operating System: Windows 7/XP/VISTA/2000/98, Unix, Linux

Languages: SQL, PL/SQL, C, C++, Python, Unix Shell Scripting

GUI: Oracle Forms 6i/9i/10g/11g, Oracle Reports 6i/9i/10g/11g, BI Publisher

ETL Tools: SQL*Loader, Informatica Power Center

Applications: MS Office, Adobe Photoshop

PROFESSIONAL EXPERIENCE:

Confidential, Harrisburg, PA

Senior Oracle Developer

Responsibilities:

  • Developed new Forms and reports using Oracle Forms builder 11g and Reports Builder 11g.
  • Worked on numerous problem logs which where accumulated over teh years and fixed them
  • Converted Oracle reports into BI Publisher.
  • Create reports for batch processing.
  • Spoke to teh users directly to gather teh required information and specifications of how each and every form should be like.
  • Modified and created UNIX shell scripts.
  • Worked on different modules at teh same time.
  • Worked on Application level Performance tuning.
  • Solved teh issues on various modules dat were already in production.
  • Extensively Developed database triggers, packages, functions, and stored procedures using PL/SQL.
  • Used Validation Controls and Custom validation control to validate Web forms.
  • Created Indexes for faster retrieval of teh customer information and enhance teh database performance.

Environment: Oracle11g, Toad, Exceed 14, SQL*LOADER, Oracle Forms 11g, Oracle Reports 11g, BI Publisher 11g.

Confidential, Fort Worth, TX

Oracle Developer

Responsibilities:

  • Developed control files for SQL*Loader and PL/SQL programs for loading and validating teh data into teh Database.
  • Designed and developed database tables, triggers, cursors, procedures, functions and packages to meet business requirements.
  • Generated Reports as per teh business requirements.
  • Developed forms using Oracle Form Builder 10g, created item/form/block level triggers used in Oracle Forms.
  • Used forward engineering in Data modeler to create a Physical Data Model with DDL dat best suits teh requirements from teh Logical Data Model.
  • Used Reverse Engineering in Erwin Data modeler and identified teh Data Elements (in teh source systems), Dimensions, Facts and Measures required for reports.
  • Used Informatica Power center 8.6 for loading flat files into teh database.
  • Expert in creating UML diagrams including Use Case Diagrams, Class Diagrams, Sequence Diagrams and Activity Diagrams.
  • Responsible for teh detail design documentation, development, unit testing and maintenance of internally developed applications.
  • Worked with built in Oracle Packages (DBMS SQL, DBMS OUTPUT, DBMS XML and others).
  • Created and maintained different constraints on database and developed triggers to maintain database integrity.
  • Used Exception Handling extensively for teh ease of debugging and displaying teh error messages in teh application.
  • Experienced in tracking Project Status, Publishing Status Reports, Managing Scope, Time and Cost.
  • Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.
  • Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming.
  • Used DBMS SCHEDULER for jobs scheduling.

Environment: Oracle11g, Informatica Power Center 8.6, Erwin Data Modeler 8, PL-SQL, SQL*Loader, SQL Navigator, Oracle Forms, Oracle Reports, TOAD.

Confidential, Houston, TX

Oracle Developer

Responsibilities:

  • Creating and managing schema objects such as tables, views, synonyms, packages.
  • Maintaining Referential Integrity.
  • Modified existing codes and developed PL/SQL packages to perform Certain Specialized functions / enhancement on Oracle Application.
  • Developed SQL scripts to Insert/Update and Delete data in Oracle database tables.
  • Analyzing teh existing reports and modifying teh reports specific to new requirements.
  • Interacting with teh business users and application owners on their requirements on Merchant data.
  • Modified several existing reports and also developed new Merchant reports using BI publisher.
  • Developed and modified forms using oracle Forms 10g.
  • Wrote complex SQL queries using Joins, Sub queries and Group functions.
  • Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
  • Created shell scripts in UNIX for job scheduling and batch processing.
  • Created number of database Triggers according to business rules using PL/SQL.
  • Preparation of Stored Procedures and User Defined functions.
  • Created Indexes to speed up teh queries.
  • Improved teh performance of teh system by tuning queries using using Explain Plan, Tkprof, Hints and indexes
  • Migration of data from different data sources using SQL* LOADER.

Environment: Oracle forms 10g, Oracle Reports 10g, BI Publisher, SQL*LOADER, PL/SQL, SQL*PLUS, Unix Shell Scripting, TOAD.

Confidential, Edison, NJ

Oracle Developer

Responsibilities:

  • Involved in teh design of Database Schemas.
  • Developed SQL loader scripts.
  • Involved in Migration of data from MS SQL into Oracle.
  • Created PL/SQL code to upload data as XML files.
  • Responsible for creating teh database triggers to enforce several business roles.
  • Mentored teh team on tuning.
  • Mentored for best PL/SQL practices.
  • Developed several PL/SQL packages.
  • Performed SQL Tuning using SQL Trace Explain Plan for better performance.
  • Involved in migrating data testing.
  • Used external tables.
  • Used UTL FILE packages.

Environment: PL SQL, Oracle 10g, MS Word, MS Excel, Oracle Reports, Oracle Forms.

Confidential

Oracle PL/SQL consultant

Responsibilities:

  • Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts.
  • Worked with users and application developers to identify business needs and provide solutions.
  • Created Database Objects, such as Tables, Indexes, Views, and Constraints.
  • Enforced database integrity using primary keys and foreign keys.
  • Tuned pre-existing PL/ SQL programs for better performance.
  • Created many complex SQL queries and used them in Oracle Reports to generate reports.
  • Implemented data validations using Database Triggers.
  • Used import export utilities such as UTL FILE for data transfer between tables and flat files
  • Performed SQL tuning using Explain Plan.
  • Provided support in teh implementation of teh project.
  • Worked with built-in Oracle standard Packages like DBMS SQL, DBMS JOBS and DBMS OUTPUT.
  • Created and implement report modules into database from client system using Oracle Reports as per teh business requirements.
  • Used PL/SQL Dynamic procedures during Package creation.

Environment: Oracle 9i, Oracle Reports, SQL, PL/SQL, SQL*Plus, SQL*Loader, Windows XP.

We'd love your feedback!