We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

Jersey City, NJ

PROFESSIONAL SUMMARY:

  • Over Seven years of IT experience in analysis, design, development, implementation and testing of applications in data warehousing and client/server environment.
  • Experience with Oracle SQL and PL/SQL programming and used Database utility tools like SQL Navigator, SQL Plus, TOAD, SQL Developer.
  • Hands on experience working with SQL*Loader to load data from external source like flat files into Oracle database tables.
  • Experience in Oracle SQL and PL/SQL including all database objects: Stored procedures, functions, Packages, TYPE Objects, Triggers, cursors, REF cursors, Parameterized cursors, Views, Materialized Views, PL/SQL collections.
  • Proficient at working as a team player with an aim of contributing towards the team’s success.
  • Involved in unit testing, systems integration testing and documented the same.
  • Experience in Tuning the application using Explain plan and SQL Trace to optimize the cost and for higher efficiency.
  • Extensive Knowledge and Experience in ETL tools like SQL Loader, Informatica to transfer the data between different databases.
  • Good Understanding of various transformations in Informatica like Union, Filter, Router, Sequence Generator, Look Ups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
  • Experience in Data Analysis and managing data warehouse and data marts.
  • Strong knowledge in implementing table partitions using Range, Hash, Composite techniques
  • Proficient in using Erwin tool for data modeling and MS Visio to create the flow chart and to show the process flow.
  • Experience in Logical Data Modeling, Physical Data Modeling and creating ER Diagrams using Erwin tool.
  • Good understanding of Oracle data dictionary, RDBMS and normalization techniques.
  • Experienced in Oracle 11g/10g/9i systems. Created new databases and users: set up backups, export and other monitoring scripts.
  • Expertise in working with built - in packages like DBMS LOB, DBMS SQL, DBMS SCHEDULER, DBMS DDL, UTL FILE, UTL MAIL.
  • Excellent problem solving skills with a strong technical background. Creative, adaptive and result-oriented professional with avidness to learn.
  • Possess good communication and inter-personal skills, able to adapt quickly to new technologies and environments.

BUSINESS/TECHNICAL SKILL :

Oracle 11g/10g/9i/8i, MS Access, MySQL, SQL, PL/SQL, UNIX Shell Scripting, SQL*Loader, SQL*Plus, SQL Developer, HTML, ETL, Informatica, OLAP, OLTP, TOAD 8x/9x/10x, Auto trace, Explain Plan, Tkprof, SQL Trace, Microsoft reporting tools, Autosys, ERWIN, Star Schema/Snowflake Schema Modeling, MS Visio, UNIX, Windows 95/98/2000, Windows NT 4.0, Red Hat Linux, Oracle PL/SQL, VBA, Possess knowledge in Computer Networking Concepts.

PROJECTS SUMMARY:

Confidential, Jersey City, NJ

Oracle PL/SQL developer

Responsibilities:

  • Analyzed the business requirements for the enhancements needed in the contract Administration application and related policy modules.
  • Performed several DDL, DML and TCL operations.
  • Created huge database packages with related functions and procedures.
  • Developed views by joining multiple cash flow tables to show output as a report to the user.
  • Extensive PL/SQL programming including Development of new backend packages, procedures and functions to in corporate advanced modules.
  • Worked on BULK COLLECT for bulk loading the data into various transaction tables.
  • Implemented various UNIX scripts to generate the data in CSV format.
  • Used UTL FILE to load the data into oracle tables from FLAT, CSV and Text files.
  • Added database triggers to some history tables of the database for keeping track of updates to values in a history table.
  • Used file handling in Oracle to read and write into files associated with the modules.
  • Refreshed the development and test databases using export/import utilities.
  • Tuned several Oracle SQL statements using tkpr of, Explain Plan, Auto Trace utilities.
  • Worked on external hints during the SQL optimization to fast up the SQL process.
  • Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, Stored procedures, functions and packages.
  • Associated with physical and Logical Data Modeling using Erwin. Created models based on the dimensions, levels and measures requires for analysis.
  • Assisted in working with Informatica Design of ETL mappings
  • Worked on inline and correlated Sub queries based on business context.
  • Implemented various customized Oracle reports using different techniques in Oracle SQL/PLSQL like SQL*Plus reports.
  • Extensive and in depth analysis of the problem tickets to dig out the root cause for the problems.
  • Provided 24*7 on call support to production environment.
  • Involved in Impact analysis of the defects to the associated functionalities and modules in the Production environment.
  • Database security by authenticating users, using logon triggers. Created materialized view on remote database and automated scheduler of refreshing of materialized view.

Tools: Oracle 11g/10g, PL*SQL, SQL Developer, SQL*Plus, Export & Import Data, UNIX, Toad 9.6/9.7, Erwin 8, Informatica 9.1

Confidential, Albany, NY

Oracle PL/SQL Developer

Responsibilities:

  • Provided support for multiple business groups and managed SDLC for multiple projects to satisfy business needs.
  • Created stored procedures, functions, packages, collections, triggers, object types to implement complex business functionality. Data optimization, scrubbing and manipulation of staged data using PL/SQL packages.
  • Encapsulated error handling and use of autonomous transaction for logging. Used UTL FILE for exporting data and UTL MAIL to generate E-mails. Extensively used PL/SQL features like collections, nested table, Varray and bulk collection for high performance of stored procedures.
  • 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, etc.
  • Extensively worked on writing complex SQL queries (cursors, ref cursors, sub queries, correlated sub queries).
  • Modified XSD to validate incoming XMLs which improved efficiency and overall system Performance. Suggested and implemented improvements to legacy systems.
  • Developed multiple reports for IT needs to identify and improve performance.
  • Responsible for SQL tuning using explain plan, tkpr of utility, optimizer hints. Involved in RDBMS design and developed ER-diagrams using Erwin.
  • Involved in creation of various indexes on relational tables, which are BTREE, BITMAP, FUNCTION BASED.
  • Created various user defined EXCEPTIONS to control the process based on the business requirement.
  • Involved in generating numbers for PRIMARY KEY VALUES using Oracle SEQUENCE objects.
  • Used several Oracle predefined functions NVL, NVL2, DECODE, CASE STATMENT.
  • Performed supported DBA activities involving User management and table space management.
  • 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.

Tools: Oracle 11g/10g, UNIX, SQL, PL/SQL, SQL*PLUS, SQL*Loader, TOAD 9x, XML, Erwin7.2, Subversion

Confidential, Newark, NJ

Oracle PL/SQL Developer

Responsibilities:

  • Involved in SDLC gathering requirements from end users. Developed views to facilitate easy interface implementation and enforce security on critical customer information.
  • Developed stored procedures and triggers to facilitate consistent data entry into the database. Written Stored Procedures using PL/SQL functions and procedures for common utilities.
  • Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
  • Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
  • Developed Database Triggers for audit and validation purpose. Used pipelined functions for faster data accessibility. Writing validation packages using PL/SQL package.
  • Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
  • Involved in performance tuning on SQL using AUTO TRACE, EXPLAIN PLAN, and TKPROF and hints utilities.
  • Created and manipulated stored procedures, functions, packages and triggers using TOAD.
  • Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
  • Involved in working with INLINE CURSORS, EXPLICIT CURSORS, REF CURSORS.
  • Created materialized views using different clauses like FAST, COMPLETE, FORCE, ON COMMIT.
  • Used various oracle pl/sql collections VARRAYS, NESTED TABLE, ASSOCIATIVE ARRAYS with INDEX BY VARCHAR2
  • Involved in creating various utility scripts to generate log files in UNIX using shell scripts.
  • Designed and created new customized reports using Crystal Reports 8.5. Interacted with the client IT team and the business team to resolve issues and dependencies.
  • Involved in upgrade database from Oracle 9i to 10g database.

Tools: Oracle 10g/9i, SQL, PL/SQL, SQL*Loader, SQL Navigator, TOAD, UNIX, Crystal Report 8.5

Confidential, Hartford, CT

PL/SQL developer & Support DBA

Responsibilities:

  • Analyzed business, functional and technical requirements to make sure project met expectations.
  • Designed and developed GUI modules with VB 6.0 as front end.
  • Used PL/SQL programming to develop Stored Procedures/Functions and Database triggers including standard packages like DBMS SQL, DBMS PIPE, DBMS JOBS, UTIL FILE, and DBMS OUTPUT.
  • Participated in performance tuning of existing SQL statements and PL*SQL code.
  • Experience in understanding conventional and traditional data structures.
  • Used DBMS UTILITY, DBMS SMTP, and DBMS MAIL to perform various tasks in project.
  • Developed Oracle packages involving cursors and composite data types for backend functionalities.
  • Created SQL*Loader script generator application using UNIX shell scripting and PL/SQL.
  • Worked on parameterized cursors and dynamic cursor to perform dynamic operations.
  • Added extensive exception handling to the primitive packages to enhance error handling.
  • Experience in working a variety of analytical functions, RANK, DENSE RANK, LAG, LEAD, and PARTITION OVER.
  • Designed the structure of new database tables incorporated for module enhancement.
  • Performed support DBA tasks for taking hot and cold backups.
  • Loaded data in new tables using SQL*LOADER.
  • Provided 24*7 supports to Production environment.

Tools: Oracle 9i/10g, PL/SQL, SQL Loader, Export & Import Data, Oracle Enterprise Manager, Toad, UNIX.

Confidential

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.
  • Responsible for query optimization and performance tuning using Explain Plan, Auto Trace utilities. Created the integrity constraints and Database Triggers for the data validations.
  • Generated relevant staging tables to load the CSV files, identified the business validation rules.
  • Created 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.
  • Designed competent pl/sql programs using pl/sql collections, Records types, Object types.
  • Involved in working on Oracle Psuedo columns like ROWID, ROWNUM, SYSDATE, SYSTEMTIMESTAMP, USER etc.
  • Implemented various UNIX scripts to generate the data in CSV format.
  • 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.
  • Performed intensive testing for verification of the defects existing in the Production.

Tools: Oracle 9i, SQL Plus, PL/SQL and Windows XP, UNIX, Oracle SQL Developer, TOAD 7.6, MS Access 2000/2002.

Confidential

Oracle PL/SQL developer

Responsibilities:

  • Performed in-depth and step by step analysis of complex payment modules.
  • Added and modified some complex queries in the backend using joins and sub queries.
  • Performed daily tasks of User Management and backups using RMAN.
  • Examined trace files and alert log for error messages.
  • Involved in the development of new modules adding indexes, sequences and views to the database.
  • Worked on Oracle defined exceptions like NO DATA FOUND,TOO MANY ROWS, and WHEN OTHERS.
  • Added file handling in Oracle procedures along with coding for sending automatic emails to the support team when the limit of errors was exceeded.
  • Used mail utility in UNIX to send mails to users.
  • Experience in unit and integration testing
  • Refreshed development/test database from production using Export/Import. This was done so that the latest data is available in the development/test database.

Tools: Oracle 9i, PL*SQL, RMAN, Export & Import Data, Oracle Enterprise Manager, Toad 7.6, UNIX

Hire Now