We provide IT Staff Augmentation Services!

Pl/sql Developer Resume

Providence, RI

SUMMARY:

  • Over 8 years of experience in 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, SQL, PL/SQL, Oracle Forms 10g/9i/6i, Reports 10g/9i/6i, UNIX Shell Scripting.
  • Good knowledge on Oracle tools like SQL, PL/SQL, SQL * PLUS and used TOAD in many development projects.
  • Highly proficient with Oracle applications development tools within a client/server environment.
  • Excellent SQL skills in designing and development of applications using Oracle 11g/10g/9i, SQL, PL/SQL, Shell Scripting.
  • Expertise in managing software implementation projects involving Client interactions, Requirements and Gap Analysis, Customization & Enhancements, Testing, Documentation and On - time Delivery.
  • 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.
  • Documentation included the preparation of High Level Design Documents, Low Level Design Documents during the Requirement Analysis phase. Post Development during the Testing phase included preparation of Unit Test Plans & Capturing the Unit Test results.
  • Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System Testing and Load Testing.
  • Experience in designing and development of Oracle Forms and Reports.
  • Experience in Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, SQL Trace, Explain Plan, Bulk Collect feature, FORALL statements, and Troubleshooting Oracle database issues.
  • Worked in various levels of SDLC (System Development Life Cycle) which involves Analysis, Design, Development, Testing, Implementation and support with extensive exposure in database.
  • Possess excellent interpersonal, communication and analytical skills with demonstrated abilities in customer relationship management.

TECHNICAL SKILLS:

Operating Systems: Windows 98 / NT / / XP /Vista/ 7

Databases: Oracle, SQL Server, MS Access

Languages: SQL, PL/SQL, C, C++, Pascal

Tools: PL/ SQL developer, SQL Developer, TOAD, C++ Builder

Reporting Tools: Crystal Reports, Oracle Reports

Testing: Manual, Automation

WORK EXPERIENCE:

Confidential, Providence, RI

PL/SQL Developer

Responsibilities:

  • Created many Generic Stored Procedures, Functions, Database Triggers, Packages, Tables, Indexes, Views, Synonyms, Sequences using SQL and PL/SQL.
  • Extensively used PL/SQL programming in back end and front end Functions, Procedures, and Packages to implement business logics/rules.
  • Extensively worked in Oracle SQL, PL/SQL, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms and Sequences.
  • Analyzed the system requirements and performed logical and physical design of the database.
  • Experience in performance Tuning using Explain plan and hints. Experience with Query Optimization procedures using SQL Advisors.
  • Used SQL*Loader for data uploading from flat files. PL/SQL Coding and SQL tuning throughout the development wherever needed.
  • Experience in developing Dynamic SQL and Ref cursors and Hands-on experience in writing Packages, Stored procedures, Functions, and Database.
  • Created application schema as tables, view and indexes and customized the stored procedures and database triggers in PL/SQL.
  • Exception handling and cursor management in PL/SQL.
  • Involved in developing packages to transfer data from different Oracle forms to Oracle database, every time whenever processor do the transactions.
  • Involved in form level coding for Approval, Data Entry, Data Query and Response Modules as per the requirements.
  • Designed Conversion and Interface Programs using PL/SQL procedures and packages.
  • Analysis, Development, Testing and Implementation using Oracle 11g/10g.
  • Used Oracle Forms and Reports as GUI for Oracle Applications and development of high performance technical solutions to meet the challenging business demands to the clients.

Environment: Oracle (11g/10g), PL/SQL, Oracle Performance Tuning, Forms & Reports 9i/6i, PL/SQL Developer, TOAD, Query Analyzer.

Confidential, Hartford, CT

Oracle PL/SQL Developer

Responsibilities:

  • Developed new PL/SQL Stored Procedures to load and pull the respective data for those Loans eligible to be processed based on various business criteria.
  • Developed new Packages to load eligible Vendor Order Request into the Target table based on various business criteria using the MERGE Statement.
  • Involved in writing DDL and DML operations.
  • Worked very closely with functional team to understand their Development related requirements.
  • Written complex SQL queries with complexity using Inner/Outer joins, Union All, Intersect & Minus set operators.
  • Extensively used DBMS Scheduler package in order to schedule the refreshment of the Materialized Views on a periodic fashion.
  • Designed and developed several views like Materialized View for data retrieval for the reports.
  • Created a package to generate the Trace file for the Materialized View Groups using DBMS SUPPORT Package.
  • Responsible for Tuning of application with the help of Other Team Members & Oracle Support.
  • Created Table structures along with Triggers, Indexes like Bitmap and Function based Indexes.
  • Tuned SQL queries to enhance performance, using the method Explain Plan both at backend and in Toad.
  • Created test scenarios for created code and distribute across to the QA along with Knowledge transfer.
  • Used Power Designer to read Data Models.
  • Extensively used TOAD tool to increase the productivity and application code quality.

Environment: Oracle 10g, SQL developer, PL/SQL, Windows 7

Confidential, Champaign, IL

Oracle PL/SQL Developer

Responsibilities:

  • Responsible for transforming the Business requirements into Functional specs and technical design documents.
  • Creating and maintaining database objects like Tables, Views, Indexes, Constraints, Sequences, Indexes, Triggers, grants and Synonyms.
  • Creating packages, stored procedures, and functions to meet the requirements. Maintaining and supporting all the database changes throughout the lifecycle.
  • Involved in various data conversions that are necessary for the application using PL/SQL advanced topics like Bulk Collect, For All.
  • Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN and DBMS PROFILER
  • Involved in writing appropriate Cursors, Ref cursors, Collections, Records for accessing complex data resulted from joining of large number of tables.
  • Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Worked with SQL loader, Created control file scripts to dump the data in to the mapping tables and process the data accordingly.
  • Worked with UTL FILE to write the files. Involved in generating new files, modifying or updating the existing files as needed and monitoring them if they are successful during.
  • Thoroughly involved in unit testing, creating unit test documents and involve in peer reviews, code reviews, follow ups and status updates to closely monitor the development throughout its life cycle.
  • Validating all the database changes with validation scripts when the changes are moved to different environments and supporting them.
  • Adapt to multiple roles by assisting business teams in Oracle, Java, power builder and mentoring team members.

Environment: Oracle 10g/11g, TOAD, PLSQL Developer, UNIX, Forms 10g, Reports 10g, Windows XP and SQL Plus.

Confidential, Fairfax, VA

Oracle PL/SQL Developer

Responsibilities:

  • Design Technical Specifications from Functional Specification (Detail Design) documents.
  • Use SQL*Loader/Perl Script to load data from various sources into an Oracle database.
  • Wrote PLSQL programs required to retrieve data from the Data repository using Cursors, UTL File I/O and Exception handling.
  • Wrote PL/SQL Packages, Functions and Procedures to implement the Business Logic.
  • Involved in Integration testing, System testing and Implementation.
  • Proficiently developed test cases in Quality Center.
  • Extensively developed complex PL/SQL packages for Pricing.
  • Written complex SQL using joins, sub-queries and correlated sub-queries.
  • Developed UNIX shell scripts to process file feeds.
  • Used debugger to test the mapping and fixed the bugs.
  • Applied Performance Tuning logic to optimize session performance.
  • Attended business user sessions to make changes in warehouse loads.
  • Involved in production support during deployment.
  • Developed shell scripts for batch processing and database transactions.
  • Tuning SQL Statements, PL/SQL Packages, Triggers, Functions and Procedures.
  • Application Testing and Documentation in the upgrade of Oracle 9i to 10g.
  • Involved in Database performance tuning using Explain plan.

Environment: Oracle 9i/10g, Oracle Application Server 10g, PL/SQL Developer, TOAD, MS-Windows Vista

Confidential, Fairfax, VA

Oracle PL/SQL Developer

Responsibilities:

  • Written stored procedures and packages on ORACLE Database Server.
  • Involved in the production support and solved critical issues.
  • Loading the flat files using SQL loader into ORACLE tables.
  • Written SQL (DDL, DML, DCL) and database triggers.
  • Developed and maintained scalable data warehouse and business intelligence platforms/infrastructure.
  • Created indexes on tables for optimization.
  • Extensively used back-end procedure, SQL Queries, standard modules, and Database Triggers.
  • Extensively worked on cursors for manipulating row-by-row for oracle database.
  • Created the Materialized views for the base tables of other databases in order to avoid redundancy of data.
  • Entered the bugs into Quality Center and resolved based on priority.

Environment: SQL Server, Oracle 10g PL/SQL, SQL, Windows, Toad.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Involved in Creation of tables, Join conditions, nested queries, views, sequences, synonyms for the business application development.
  • Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
  • Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance.
  • Created dynamic SQL to support dynamic nature of front to end applications.
  • Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
  • Used DBMS Supplied packages like DBMS PROFILER, DBMS JOB, etc.
  • Used the Crontab in UNIX for Automatic Tasks like loading data into Tables, Importing and Exporting data.
  • Wrote complex queries to generate reports as per client request as a part of production support.

Environment: Oracle 9i, Windows XP, PL/SQL, SQL*PLUS, SQL Developer, UNIX

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Designing, developing and distributing a vast amount of reports for many banks.
  • Developing Oracle 9i/10g PL/SQL codes (packages, stored procedures, functions and database triggers) for data extraction, transformation and loading processes.
  • Writing PL/SQL codes using collections, bulking techniques and partition to increase performance and efficiency of already existing reports and various programs.
  • Developing databases for a vast number of client records, which required self-initiation and excellent time-management.
  • Using various Built-In PL/SQL packages based on requirements.
  • Set up export and import schema and wrote data conversion scripts using Oracle.
  • Involved in design, coding, test and document processes of LSBank5, LSBank6 and LSFinance projects under C++ Builder6 and Oracle backend development.
  • Received technical assignments and developed the entire Deming Cycle for the appropriate departments of these Financial Establishments.

Environment: Oracle 9i, 10G, PL/SQL, C++ Builder6, Windows XP.

Hire Now