We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

Fredrick, MD

SUMMARY:

  • Over 7+ years of experience as Oracle Developer in development and production environments.
  • Extensive working experience in Oracle Dbase (11g/10g/9i). SQL, PL/SQL, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes, Views, Materialized Views, SQL Loader.
  • Used range and list partition technique for larger table partitioning.
  • Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling.
  • Worked in debugging and Tuning the PL/SQL code, Explain plan, tuning queries and optimization for the Oracle database.
  • Exposure in using CASE tools like TOAD, PLSQL Developer and SQL Developer for writing PL/SQL programs.
  • Extensive experience in Database query and Performance tuning (Explain Plan and TKPROF utility) of Reports and troubleshooting Oracle Application issues on OLTP and DSS systems.
  • Expertise in design, development and deployment of end user screens and reports using Oracle tools, Oracle Forms 10g/9i/6i/4.5, Reports 10g/9i/6i/2.5, Oracle ADF, informatica ETL.
  • Experience of Data modeling (both transactional OLTP and dimensional OLAP).
  • Good knowledge in using data modeling tools like ER - WIN and ER diagrams with Modelmart exposure. Normalization Techniques for designing database with Relational technology on N-Tier Architecture.
  • Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
  • Experience in using several built in database packages as DBMS JOB, DBMS OUTPUT, UTL FILE and DBMS SQL are few to be named.
  • Loaded Data into Oracle Tables using SQL Loader.
  • Experience in creating master detail forms and adding Alerts.
  • Experience in Deploying Forms and Reports on the web.
  • Experience in query optimization, Performance Tuning (PL/SQL) using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
  • Making changes to the existing APEX applications in the production.
  • Good knowledge of Java, C, C++ and ASP.NET, DRM.
  • Good experience in UNIX Shell Scripting and Python.
  • Expertise with all ODI tools - Topology, Security Manager, Designer and Operator.
  • As a professional developer involved in code review of all the team members.
  • Superior communication, presentation, analytical and problem solving skill. Work well with all levels of business.
  • Used oracle Golden Gate to enable and administrate manipulation of data and transaction among different platforms of the enterprise
  • Highly analytical thinking with demonstrated talent for identifying, scrutinizing, improving, and streamlining complex work processes.

TECHNICAL SKILLS:

Databases: MySQL, Facets, ORACLE9i/10g/11g,Oracleforms10g/9i/6i, DBA, Oracle ADF, Oracle reports 10g/ SQL Server 2005, Microsoft Access, SAS, Informatica ETL, Golden Gate

Programming languages: C, C++, JAVA and UNIXshell, perl, JAVA J2EE.

Web Technologies: Java Script, CSS/CSS3, HTML/HTML5, PHP.

Operating systems: Win XP, Vista, Win 7, UNIX, Linux and Mac Os.

Development Tools: TOAD, SQL Developer, SQL*loader, SQL*plus, Oracle Enterprise Manager (OEM), Dream weaver, Eclipse, VM ware, SQL Navigator

PROFESSIONAL EXPERIENCE:

Confidential, Fredrick, MD

Oracle PL/SQL Developer

Responsibilities:

  • Developed various PL/SQL stored procedures and functions and worked with oracle ADF
  • Created scripts to create new tables, views, queries for new enhancement in the application using TOAD
  • Developed PL/SQL triggers on master tables for automatic creation of primary keys and foreign keys.
  • Coordinated with DBA in creating and managing Tables, Indexes, Table spaces, Triggers, DB Links and Privileges
  • Developed back end interfaces using PL/SQL Stored packages, Procedures, Functions, Collections, Object Types, Triggers.
  • Developed PL/SQL Procedures Confidential the database level that were used in the mappings through Stored Procedure Transformation.
  • Utilized SQL*Loader to load flat files database table and created features in oracle ADF applications.
  • Handled various exceptions to troubleshoot PL/SQL code.
  • Formulated procedures, functions and packages; ensured that the quality, programming and project management standards were met.
  • Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections.
  • Used Bulk Collect feature to improve performance.
  • Created indexes on tables for fast retrieval of data and developed framework in oracle ADF.
  • Developed Complex SQL queries using various Joins, Sub-Queries, Analytical and Group Functions and developed various dynamic SQL’s thorough out the project.
  • Used PL/SQL programming to develop Stored Procedures, Functions and Database Triggers including standard packages like DBMS SQL, DBMS XPLAN, DBMS JOB, and UTL FILE.
  • Created Oracle Forms based on the client requirements and involved in development and deployment of oracle ADF applications.
  • Developed few adhoc reports on demand basis. The output results were exported in different formats.
  • Designing and rebuilding indexes for faster overall data processing.
  • Gathering the requirements through meetings with the Business Users
  • Tuned Report performance by exploiting the Oracle’s built-in functions and rewriting SQL statements.
  • Worked closely with end-users and team members to understand business requirements that drive the analysis.
  • Test case/data preparation, execution and verification of the test results.
  • Responsible for documentation of all the project developments and modulations as per the standards defined and the system requirements.

Environment: Oracle 11g, SQL, PL/SQL, UNIX, Toad, Oracle Forms/reports 10g, informatica ETL

Confidential, St. Louis, MO

Oracle developer

Responsibilities:

  • Involved in the continuous enhancements and fixing of production problems and working with API.
  • Resolved different kinds of tickets issued to us which involved in UNIX shell scripting, modifying database tables, hands on UI changes using HTML5.
  • Designed webpage for the team to access all the links from one place. Used HTML and CSS for design.
  • Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Developed PL/SQL triggers on master tables for automatic creation of primary key values.
  • Created scripts for new tables, views, queries for new enhancements in the application using TOAD/SQL developer.
  • Created indexes on the tables for faster retrieval of the data to enhanced Confidential a base performance.
  • Upgraded Oracle 10g to 11g software in different environments for latest features and also tested databases.
  • 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.
  • Performance tuned the interfaces, queries through use of indexes, ranks, Oracle hints, exchange partitions etc.
  • Created sizing and designing using Oracle ADF applications
  • Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
  • Provide technical support for database maintenance and disaster recovery.
  • Created tickets to other development teams for supporting applications.
  • Involved with users to understand the problem they have and train them with work around for similar issues.

Environment: Oracle 10g/11g, K-Shell, PL/SQL, SQL, SQL developer, SQL*Loader, TOAD, SoapUI, BMS Remedy.

Confidential, ST. LOUIS, MO

Oracle Developer

Responsibilities:

  • Requirements gathering from end users.
  • Responsible for developing database objects - Functions, Procedures, Packages, Cursors and Triggers etc.
  • Worked on tickets to fix the issues reported by the end users.
  • Optimizing the performance using PL/SQL table types and record types.
  • Worked on table partitioning and index creation for the performance improvement.
  • Extensively worked on complex SQL queries using joins, sub queries, correlated sub queries and analytical functions.
  • Extensively used advanced PLSQL features like BULK COLLECT, FORALL, REF CURSORS, COLLECTIONS data types in the procedures, functions.
  • Designing the data model (logical/physical) by creating new objects and by using existing objects of the data mart as per the business requirements.
  • Generating software upgrade scripts for cross functional teams.
  • Highly involved in writing Test Cases and Unit Analysis and Testing (UAT) to test each and every logical branch of the stored Procedure.
  • Wrote SQL queries to developed test data for use during test execution.
  • Worked on various levels of SDLC (Software Development Life Cycle) including system analysis, high level design, detailed design, coding and testing.
  • Involved in the preparation of Technical Specification Documentation.
  • Analyzing the performance of the SQL queries and created the scripts for indexes

Environment: Oracle 11g, WINDOWS 7, SQL, PL/SQL, Toad, Visio, SQL Developer.

Confidential, Memphis, TN

Oracle Developer

Responsibilities:

  • Involved in the maintenance and enhancement of the application.
  • Maintained good rapport with Business Analyst & Business Users to identify information needs as per business requirements.
  • Document the business process flows.
  • Schedule meetings and present technical issues to business users and developers.
  • Migrated data from Sybase to Oracle using SQL developer.
  • Performed discussions with data modeler to update the data model for new requirements.
  • Extensively developed complex PL/SQL packages for Invoice Processing.
  • Designed/developed tables, views, various SQL queries, stored procedures, functions.
  • Involved in PL/SQL code review and modification for the development of new requirements.
  • Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.
  • Used PL/SQL tables, array structures as a part of oracle collections.
  • Involved in partitioning of very large tables. Used list and range partitioning.
  • Associated with DBA in monitoring the performance related issues using Explain plan, SQL Trace and TKPROFutility.
  • Create & maintained batch jobs using Shell Scripts.
  • Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.
  • Communicate issues and progress to project manager.
  • Solving day-to-day problems, giving support to the users.
  • Worked with Dynamic SQL, Global Temporary Tables.
  • Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process.
  • Import/Export utility is used for transforming data from one place to another from testing to Production.
  • Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan, SQL Trace and TKPROF Tools.
  • Prepared the procedures to update the internal structures to reflect the newly loaded data. Created the materialized views.
  • Involved in Production Support and troubleshooting data quality and integrity issues

Environment: Oracle 10g/11g, Oracle Applications 12/11i, SQL, PL/SQL, Toad for Oracle, SQL *Plus.

Confidential

Oracle developer

Responsibilities:

  • Custom tables and new custom objects were designed as per business requirements.
  • Created database Triggers to validate complex integrity.
  • PL/SQL Procedures, Functions, Cursors, Triggers and Packages were created using TOAD.
  • Developed and maintained Oracle Forms and Reports for various applications using SQL*Plus and PL/SQL.
  • Developed PL/SQL procedures to support Forms and perform standalone functions.
  • Developed complex SQL Coding and used in creating Reports and Forms.
  • UNIX shell scripting was used for scheduling batch jobs. The system was used to run batch processes and reports that utilized PL/SQL and Oracle Reports.
  • Responsible for SQL Tuning using Explain Plan and SQL trace facilities.
  • Performed unit testing and Integration testing for the scenarios mentioned in the test scripts.

Environment: Oracle 10g,SQL developer, Solaris, Reports 6i, Forms 6i, TOAD, SQL*Loader, PL/SQL, SQL*Plus.

Confidential

SQL Server Developer

Responsibilities:

  • Involved in Physical and Logical design of the databases.
  • Developed DTS Packages to transfer the data between SQL Server database and files.
  • Created and maintained Data Transformation Service (DTS) packages for migrating data.
  • Scheduled job for DTS packages.
  • Used BCP / Bulk Insert to publish table output to text files.
  • Created advanced T-SQL/PL-SQL queries using DDL, DML and Indexes, Views, Cursors, Triggers, User Defined Functions (UDF) and Stored Procedures.
  • Used all Declarative Constraints for maintaining Data Integrity.
  • Created Views to restrict access to data in a table for security.
  • Involved in performance tuning of T-SQL queries and Stored Procedures.
  • Implemented Auditing using triggers.
  • Used SQL Profiler to debug T-SQL and slow running queries.
  • Monitored the Database Performance using execution plans and Index tuning.
  • Optimized the query performance with modifications in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins.

Environment: MS SQL Server 2000, T-SQL, Windows 2000 Server, Windows NT 4.0

Hire Now