We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

0/5 (Submit Your Rating)

Culver City, CA

SUMMARY

  • Over 8 years of Information Technology experience including data analysis, data design, data support, data mining and migration of Oracle RDBMS systems on various platforms i.e., UNIX/LINUX and WINDOWS Server platforms.
  • Worked Over 6 years on different oracle database versions, which are Oracle 8i/9i/10g and 11g, SQL and PL/SQL, SQL Loader, Physical database design, Logical database design, Gap Analysis, Data Exports & Imports, Inbound/Outbound Interfaces, Application Support, Performance Tuning, Oracle Tuning & Optimization and Oracle Forms.
  • Solid 6 years of experience on 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.
  • Strong experience on various programming techniques, BULK COLLECT with FOR ALL, User defined exceptions, MERGE, Global temporary tables.
  • A sturdy hold on performance tuning using AUTOTRACE, EXPLAIN PLAN, SQLTRACE/TKPROF using external Hints.
  • Experience on working and designing Physical/Logical data models during initial phase of project blueprint.
  • Extensive experience in ETL processes and data migration with data warehousing, mergers and acquisitions and integration from external suppliers.
  • Hands on experience on various database utilities like SYS CONTEXT, LISTAGG, PIVOT, UNPIVOT, DBMS UTILITY, DBMS SCHEDULER.
  • Worked on Star Schema and Kimball Theory and changing dimensions.
  • Strong experience on full life cycles of software development including requirement gathering, blues print design, development, testing and support.
  • Worked in different non Oracle database applications, MS Access, Tera data,R3, BO reporting tools, Microsoft reporting tools and Oracle reports.
  • Proficiency on using various Oracle utility tools, Sql Plus, Sql PlusW, TOAD, PL/SQL Developer, Sql Navigator, Sql *Loader, Export/Import with data pump.
  • Strong experience on XML manipulations using XMLTYPE/CLOB with XMLTABLE, XMLELEMENT, XMLFOREST, DBMS XMLSAVE, DBMS XMLGEN.
  • Expertise in problem solving and diagnostic analytical skills and ability to communicate with different kind of individual at all stages.
  • Good in team leading skills including assigning and coordinating the work with offshore teams and on shore peers.

TECHNICAL SKILLS

Database systems: Oracle RDBMS 8i/ 9i/10g/11g, MS Access, Tera Data.

Programming Languages: SQL, PL/SQL, Unix Shell Script, HTML, Java Script, VB Script XML, Perl Scripting, Pro C.

Tools: & Utilities: TOAD 8x/9x/10x, SQL Plus, SQL Loader, ERWIN, Auto trace, Explain Plan, Microsoft reporting tools, AdHoc reporting tools, Execution Plan, SQL Developer, Autosys. PL/SQL Developer, MS Office, Putty, telnet, FTP.

Operating System: UNIX, LINUX, DOS, WINDOWS 7/XP/VISTA/2000/2003.

ERP: SAP R3 6.0.

Scripting: UNIX korn/bourne shell scripting, PERL Shell Scripting.

Version Control Tools: SVN, Adhoc versioning system

PROFESSIONAL EXPERIENCE

Oracle PL/SQL Developer

Confidential, Culver City, CA

Responsibilities:

  • Gathering the functional requirements from users and converting them into technical requirements.
  • Migrated Oracle 9i database on Windows NT platform to Oracle 11g and deployment of objects to production environment.
  • Migrated PL/SQL Code from Oracle 9i to 11g and implemented object types.
  • Decoupling of Oracle 9i schemas into separate 11g databases as per functional requirements.
  • Created database packages, procedures, functions, triggers, views, materialized views using Oracle PL/SQL in 11g.
  • Analyzing performance of database objects and suggesting DBA for Indexes, statistics gathering and partitioning. Analyzing explain plan, TK PROF and giving further solutions to solve performance issues.
  • Used SQL* Loader and export/import mechanism for data migration for bulk upload.
  • Implemented PL/SQL to perform application security and batch job scheduling
  • UNIX shell scripting for data files handling, FTP and executing the SQL*Loader.
  • Generation of dynamic web - reports using Java, HTML, DHTML & Javascript.
  • Created email & file I/O operations utilities using Java and used them as objects in Oracle as Java Stored Procedures.
  • Performed thorough unit testing, system testing, regression testing, baseline testing and UAT (bug fixing from user responses) in development environment for the result of error free and smooth migration process and provided quality work for functional users.
  • Used Oracle's Advanced Queuing mechanism to send messages to clients and interact with other systems (UNIX and App server).
  • Implement datamart and datawarehouse.
  • Generated various reports on PL/SQL with output format in Excel/Pdf/Html.
  • Worked on production support and future releases of software.

Confidential, Dallas, TX

Oracle PL/SQL Developer

Responsibilities:

  • Involved in designing the business and technical specification in development phase of the project.
  • Participated in designing logical/physical database during designing of database model.
  • Involved in all stages of system development life cycles, which includes requirement gathering, blue print design, development, testing and maintenance of application.
  • Responsible to generate sql/plsql programs based on specification requested by users/business users.
  • Experience in writing Oracle stored procedures/Functions/Packages/Triggers/DBLINKS and performed testing on them.
  • Involved in performance tuning on sql using AUTO TRACE, EXPLAIN PLAN, TKPROF utilities.
  • Used several 11g new oracle sql/plsql features like LISTAGG, PIVOT, UNPIVOT, CONTINUE, SIMPLE INTEGER.
  • Created several utility packages to handle specific functionality for the business context.
  • Experience in using various utilities like PRAGMA AUTONOUMOUS, BULK COLLECT FOR ALL, DYNAMIC SQL, and NO COPY.
  • Created different XML transformations to send/receive the data back and froth from JAVA and Oracle relational tables using XMLTYPE, XMLTABLE, DBMS XMLGEN.
  • Designed a variety of ETL transformations/transformation programs using Oracle sql/plsql.
  • Experience in using various oracle pl/sql collections VARRAYS, NESTED TABLE, ASSOCIATIVE ARRAYS with INDEX BY VARCHAR2
  • Worked with large database data types CLOB inside XMLTYPE while generating XML inside oracle stored program objects.
  • Used Autosys for monitoring and scheduling the Autosys jobs in several environments.
  • Provided constant support on the existing program and newly developed programs.
  • Involved in working with INLINE CURSORS, EXPLICIT CURSORS, REF CURSORS.
  • Created materialized views using different clauses like FAST, COMPLETE, FORCE, ON COMMIT.

Confidential, Princeton, NJ

Oracle pl/sql Developer

Responsibilities:

  • Experience in acknowledging key attributes in entities define on domain level.
  • Involved in attending daily scrums and different team meetings based on the issues.
  • Created master and transaction tables using the functional requirements.
  • Experience in designing the various key database schemas in project, i.e., STAGING, USER CREDENTIAL, APPLICATION PROCESS etc.
  • Worked on Oracle application express and Oracle ADF while this project.
  • Developed various Oracle Anonymous blocks, PROCEDURES/FUNCTIONS/TRIGGERS.
  • Created several complex Oracle pl/sql packages for business activities using Oracle collection objects.
  • Used dbms jobs, dbms scheduler to schedule the oracle jobs in a sequential order to process several programs in a single go.
  • Involved in creation of various indexes on relational tables, which are, BTREE, BITMAP, FUNCTION BASED.
  • Used several Oracle predefined functions NVL, NVL2, DECODE, TO CLOB, CASE STATMENT.
  • Worked in several UNIX scripts in implementing of Oracle automated program calls.
  • Involved in various data loading techniques using SQL LOADER, UTL FILE, and EXTERNAL TABLES.
  • Created various alphanumeric RANDOM VALUES using DBMS RANDOM package.
  • Used SYS CONTEXT to generate user id, session id and various column inside various Oracle objects.
  • Implemented various OLTP transactions using sql/plsql.
  • Worked on ASCII Sql based on specific requirements.
  • Used AUTHID & DEFINER in procedures/function/packages with NO COPY option.
  • Good knowledge on rule based and cost based optimizers in different Oracle flavors.
  • Used various clauses in Sql statement like IN, EXISTS, GROUP BY, ORDER BY ASC, DESC.

Confidential, Rochester, NY

Oracle Developer

Responsibilities:

  • Responsible for conducting and gathering user requirements and develop the Oracle programs based on them.
  • Designed and followed Oracle predefined coding standards.
  • Implemented DATA CLEANSING, DATA VALIDATIONG, DATA QUALITY, and DATA INTEGRITY using Oracle programs in staging area.
  • Involved in creating of Adhoc scripts for specific business needs and used advanced sql techniques like Analytical functions, Aggregate, Mathematical functions.
  • Involved in working on Oracle PSUEDO columns like ROWID, ROWNUM, SYSDATE, SYSTEMTIMESTAMP, USER etc.
  • Tuned several Oracle sql statements using EXPLAIN PLAN, AUTOTRACE 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 is working a variety of analytical functions, RANK, DENSE RANK, LAG, LEAD and PARTITION OVER.
  • Good knowledge on joins, which are, inner join, Left outer join and Hash join, Semi join.
  • Implemented various UNIX scripts to generate the data in CSV format.
  • Used ASCII functions in Oracle scripts to generate the TAB, NEW LINE and other ASCII values.
  • Used Toad EXPORT/IMPORT utility to load the tables and excel, csv files back and forth.
  • Experience in using putty, telnet, ftp to communicate with the remote UNIX servers.
  • Good knowledge of using various editor tools like TEXT PAD, ULTRAEDIT and NOTEPAD++.
  • Experience on using various Oracle front tools like TOAD, PL/SQL DEVELOPER, SQL PLUSW etc.
  • Used Toad file compare utility to generate the differences between two files.
  • Worked in removing the duplicate values automatically by itself.

Confidential, Littleton, CO

Oracle Developer

Responsibilities:

  • Involved in creating of new parent and child tables for the database in various schemas.
  • Experience in working directly with top level management, user and other team members to investigate and evaluate the user specifications.
  • Used DPIMP/DPEXP utilities to take the database backup.
  • Involved in performing data analysis and data cleansing on huge tables with 100 to 200 million rows.
  • Experience in understanding conventional and traditional data structures.
  • Used DBMS UTILITY, DBMS SMTP, DBMS MAIL to perform various tasks in project.
  • Worked on Global temporary tables to hold the data on session levels.
  • Implemented different Event based triggers on database events like on LOGIN, SHUTDOWN etc.
  • Experience in debugging various tools and using DBMS DEBUG package.
  • Worked on parameterized cursors and dynamic cursor to perform dynamic operations.
  • Good experience in working on UNIX CronTab for process automation.
  • Involved in developing various Oracle objects like STORED PROEDURE/FUNCTIONS/PACKAGES.
  • Worked with Merge statement to speed up the INSERT and UPDATE process.
  • Good experience in writing UNIX wrapper script to schedule and automate the process.
  • Performed optimization in sql and pl/sql using various techniques.

Confidential, Cherry Hil, NJ

Oracle Database Analyst

Responsibilities:

  • Involved in attending various functional/technical team meetings and business workshops.
  • Worked in various stages/releases of project.
  • Good working knowledge on working change management process.
  • Experience in good working knowledge on insurance domain.
  • Used various oracle packages like DBMS OUTPUT, DBMS STATS, DBMS UTILITY etc.
  • Used analyze table command to gather the statistics on relational tables.
  • Worked on BULK COLLECT for bulk loading the data into various transaction tables.
  • Used UTL FILE to load the data into oracle tables from FLAT, CSV and Text files.
  • Applied several Oracle program patches to existing process or programs.
  • Performed several DDL, DML and TCL operations.
  • Involved in writing several data loading scripts for incremental and initial/one-time data loads.
  • Involved in extracting data from different data resources.
  • Implemented various automated UNIX shell scripts to invoke pl/sql anonymous blocks, Stored PROEDURES/FUNCTIONS/PACKAGES using SQL PLUS session in silent mode.
  • Worked on inline and correlated sub queries based on business context.
  • Implemented various customized Oracle reports using different techniques in Oracle sql/pl-sql.
  • Responsible for debugging Oracle pl/sql blocks and optimization of various Oracle stored objects.

Confidential

Oracle Data Mining Analyst

Responsibilities:

  • Involved in data mining and data analysis based on the data patterns received.
  • Involved and implemented full SDLC for the application.
  • Generated various company standards of processing the data based on information gathered from key business users.
  • Implemented several PERL/UNIX scripts to load the data into database from various resources like non oracle databases, CSV files, text/FLAT files etc using SQL * LOADER.
  • Constantly involved in attending and conducting the team meetings.
  • Implemented several Oracle anonymous blocks, procedure and functions based on the requirements.
  • Worked on Oracle defined exceptions like NO DATA FOUND, TOO MANY ROWS and WHEN OTHERS.
  • Used Oracle BLAST related functions to find and analyze the DNA patterns.
  • Involved in sequencing similarity search and Alignment process while matching the patterns.
  • Involved in testing Y and MITO process in DNA Pattern search.
  • Experience in unit and integration testing.
  • Used export/import utilities to save the database/database object.
  • Involved in writing Oracle views, inline views sql statement in SELECT, FROM and WHERE clauses.
  • Involved in suggesting of different oracle techniques to business users to generate the optimized codes.
  • Used mail utility in UNIX to send mails to users.

We'd love your feedback!