Sr. Oracle Pl/sql Developer Resume
Baskin Ridge, NJ
SUMMARY:
- 8 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
- Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery.
- Experience with Oracle SQL and PL/SQL programming and used Database utility programs like TOAD and SQL Navigator.
- Experience in Oracle SQL and PL/SQL including all database objects Stored procedures, Stored functions, Packages, TYPE Objects, Triggers, cursors, REF cursors, Parameterized cursors, Views, Materialized Views, PL/SQL collections.
- Experience in tuning the application using Explain Plan and SQL Trace to optimize the cost and for higher efficiency.
- Translated the T - SQL procedure, function and views into Oracle's PL/SQL Packages, Procedure, Function and Views.
- Extensive Knowledge and Experience in ETL tools like SQL Loader, Informatica and DTS packages to transfer the data between different databases.
- Used Erwin tool for data modeling and MS Visio to create the flow chart and to show the process flow.
- Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, and Analytical functions, and Materialized Views, Query Re-Write and Transportable table spaces.
- Experience in Logical Data Modeling, Physical Data Modeling and creating ER Diagrams.
- Good understanding of Oracle data dictionary and normalization techniques. Experienced in Oracle 11g/10g/9i/8i systems.
- Experience in the preparation of Technical Design documents and involved in unit testing, systems integration testing and documented the same.
- Knowledge in Core Java, HTML, XML.
- Excellent communication skills, technically competent with strong problem solving skills enabling effective interaction with project sponsors, testers and business users.
TECHNICAL SKILLS:
Languages: SQL, PL/SQL, Java, C++, UNIX Shell Scripting.
ETL Tools: Informatica (PoweCenter 5.1/6.2/7.1/8.6.1/9.1.0, PowerMart5.1, Power Connect/Power Exchange for SAP R/3, Mainframe and Oracle Change Data Capture (CDC), AB Initio 1.8 and SQL*Loader.
Database: Oracle 9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers), MS SQL SERVER 2000/2005/2008.
Data Modeling: Erwin 3.5.2, 4.0
ERP: Oracle Applications 11i/R12.
Oracle Tools: Reports 6i/9i, Forms 6i/9i, XML Publisher.
DB Utilities: SQL plus, SQL Loader, Toad.
Operating Systems: UNIX, Windows 98/NT/2000/XP.
PROFESSIONAL EXPERIENCE:
Confidential, Baskin Ridge, NJ
Sr. Oracle PL/SQL Developer
Responsibilities:
- Created stored procedures, functions, packages, collections, triggers, object types to implement complex business functionality.
- Designed the Oracle Partition strategies, Exchange Partitions, Performance tuning and data analysis, Data optimization, scrubbing and manipulation of staged data using PL/SQL packages.
- Used PL/SQL bulk collection and DML (insert/update/delete) methods.
- Expertise in writing Complex SQL queries, structure hierarchy by using analytical functions, data validation using Regular Expressions
- Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.
- Created scripts, reports by using SQL and PL/ SQL for the bug fixes and pre and post verification script for the data verification.
- Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
- Developed the shell scripts to automate the jobs by using UNIX.
- Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
- Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
- Involved in creation of various indexes on relational tables, which are BTREE, BITMAP, and FUNCTIONBASED Responsible for SQL tuning using explain Plan, tkprof utility, optimizer hints.
- Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
- Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams.
- Assisted with testing existing code and making necessary enhancements for Oracle 11G upgrade. Created database objects such as tables, indexes, views, materialized views, triggers, sequences, synonyms.
- Implemented the test Plans for the integration testing.
- Worked with multiple vendors to facilitate integration of systems during merger. Effectively documented and archived historical data for future auditing purposes. Responsible for production support and troubleshooting production issues. Experience working with huge database size of 5 TB.
Environment: Oracle 10g/11g, UNIX, PL/SQL, SQLPlus, SQL Loader, SQL developer, Toad, Erwin.
Confidential, Dallas, TX
Oracle PL/SQL Developer
Responsibilities:
- Developed user defined functions based on requirements. Developed back end interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections and Triggers. Created PL/SQL procedures and packages.
- Extensive query optimization and performance tuning. Created the integrity constraints and Database Triggers for the data validations. Used PL/SQL Tables and Records in payment generation process. Written Test Plans and Involved in unit testing.
- Created relevant staging tables to load the CSV files, identified thebusiness validation rules. Created SQL Loader script generator application using UNIX shell scripting and PL/SQL.
- Experience in creating the tables and sequences for the experimental data load capture. Loaded the data into the tables using TOAD and SQL*Plus. Created metadata validation lookup tables and pre populated them usingSQL Loader generator application.
- Designed competent PL/SQL programs using PL/SQL collections, Records types, and Object types.
- Developed and automated the interfaces by using the PL/SQL. Developed user defined stages and common templates.
- Tuned several Oracle SQL statements using Explain plan, Auto Trace utilities.
- Involved in implementing table partitions using Range, Hash, Composite techniques.
- Worked on external hints during the SQL optimization to fast up the SQL process.
- Experience in working a variety of analytical functions, RANK, DENSE RANK, LAG, LEAD, and PARTITION OVER.
- Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL. Enhanced it with creating exceptions for error handling. Created triggers for auditing purpose and created group, tabular and form reports.
- Database security by authenticating users, using logon triggers. Created materialized view on remote database and automated scheduler of refreshing of materialized view.
Environment: Oracle 10g/11g, PL/SQL, SQLPlus, Informatica ETL,SQL Loader, SQL developer, Toad.
Confidential, Boston, MA
Oracle PL/SQL Developer
Responsibilities:
- Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.
- Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
- Customize and convert existing RDF reports that will run compatible as per the new multi-org structure and user requirement.
- Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
- Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
- Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
- Involved in working with IMPLICIT CURSORS, EXPLICIT CURSORS, and REF CURSORS.
- 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.
- Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
- Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams.
- Involved in migrating database from Oracle 9i to 10g database and development of reports.
Environment: Oracle 10g/11g,Oracle Applications R12, Forms 10g, Reports 10g, XML publisher, PL/SQL, SQL Plus, SQL Loader, SQL developer, Toad.
Confidential, Austin, TX
Oracle PL/SQL Developer
Responsibilities:
- Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
- Developed user defined functions based on requirements. Developed back end interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections and Triggers. Created PL/SQL procedures and packages.
- Extensive query optimization and performance tuning. Created the integrity constraints and Database Triggers for the data validations. Used PL/SQL Tables and Records in payment generation process. Written Test Plans and Involved in unit testing.
- Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
- Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
- Experience in creating the tables and sequences for the experimental data load capture. Loaded the data into the tables using TOAD and SQL*Plus. Created metadata validation lookup tables and pre populated them using SQL Loader generator application.
- Created scripts to create new tables, views, queries for new enhancement in the application-using TOAD.
- Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
- Database security by authenticating users, using logon triggers. Created materialized view on remote database and automated scheduler of refreshing of materialized view.
Environment: Oracle 10g/11g, Forms6i, Reports 6i, PL/SQL, SQL*Loader, SQL developer Toad.