SEARCH

Oracle pl/sql Developer Resume Example

Resume Score: 60%

Love this resume? Build Your Own Now
ORACLE PL/SQL DEVELOPER
Profile

6 + years of Information Technology experience including data analysis, data design, data support, data mining and migration of Oracle RDBMS systems on various platforms . 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. 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. Hands on experience on various database utilities like SYS_CONTEXT, LISTAGG, PIVOT, UNPIVOT, DBMS_UTILITY, DBMS_SCHEDULER. Strong experience on full life cycles of software development including requirement gathering, blue print design, development, testing and support. Worked in different non Oracle database applications, MS Access, Tera data , SAP R3, J2EE, Microsoft reporting tools. 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. Experienced in working different environments and having capability of directly coordinate with business and other technical teams. 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.  

Skills
  • Query MS SQL Certification
  • User experience (UX) design
Accomplishments

Spearheaded a company-wide innovation initiative resulting in [] new product offerings in under [] months. 

Professional Experience
Tools & Technologies
  • Oracle Database 10g & 11g, OLTP through SQL and PL/SQL, SQL Loader, Erwin 7, Toad 9.5, PL/SQL Developer, HP-UX 11, Apache Tomcat, IIS, MS Office 2007, JAVA, JAVA/VB Script, XML, Windows server 2007.
Tools & Technologies
  • Oracle Database 11g, OLTP and OLAP through SQL and PL/SQL, Autosys 11.0, UNIX AIX V6.1, UNIX shell scripting, XML, Erwin, SQL Loader, SQL Plus, Toad 10, PL/SQL Developer 8, JAVA, J2EE, Apache Tomcat, SAP R3, SAP XI/PI.
Tools & Technologies
  • Oracle Database 9.2 , Oracle SQL PL/SQL, SQL NAVIGATOR, , UNIX/UNIX Shell scripting, windows XP/2000, Redhat LINUX 2.0, TOAD 8.3, Perl Scripting.
Tools & Technologies
  • Oracle Database Oracle 8i/9i, Toad 8.0, UNIX/UNIX Shell scripting, Windows XP, TELNET, FTP.
Tools & Technologies
  • Oracle Database 10g, ETL using SQL, and PL/SQL, SQL Developer, TOAD 9, Sql Loader, Oracle Scheduler, MS Office - 2007 UNIX/UNIX Shell scripting, SQL*Loader and Win XP.
Oracle pl/sql Developer
September 2011 to January 2013 Hunt Oil － Dallas, TX
  • Hunt oil is an Billion dollar autonomous family-owned private oil and Gas Company, it has its main oil production activities all over the globe.
  • As an Oracle PL/SQL developer I have been involved in developing and maintaining supply chain project called HOScP's, it stands for Hunt Oil Supply Chain Processing System.
  • 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.
Oracle pl/sql Developer
June 2010 to August 2011 Novo Nordisk － Princeton, NJ
  • It is a Dutch based pharmaceutical company, US headquarters located in Princeton, NJ.
  • It manufactures and markets pharmaceutical products and services and pioneers in manufacturing diabetic related medicines and products.
  • I was involved in developing and supporting the product based management system.
  • 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.
  • 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.
  • Developed several auto.
Oracle Developer
January 2010 to May 2010 Kodak － Rochester, NY
  • It is the worlds first company to invent digital camera.
  • Kodak is also know as Eastman Kodak Company , pioneers in manufacturing photo/imaging related products and.
  • As an Oracle PL/SQL developer, I was involved in developing of Kodak in house application called CFP - Customer feedback process.
  • 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, DATA INTEGRITY using Oracle programs in staging area.
  • Invloved 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 techni.
Oracle Developer
September 2008 to December 2009 Aurora Bank － Littleton, CO
  • It is a mid-size bank that offers full-scale banking services.
  • Aurora Bank has offices in different states all over US and offers service like retail banking, residential mortgages, third-party commercial service.
  • I was involved in developing of Mortgage application validating system.
  • 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.
  • Experie.
Oracle Database Analyst
October 2007 to August 2008 Commerce National Insurance － Cherry Hill, NJ
  • Commerce national insurance is the insurance subsidiary of Commerce Bancorp and maintains its headquarters in Cherry Hill, New Jersey.
  • Commerce National is one of the 25 largest insurance agencies in the United States.
  • I was worked in a project called Commerce Analytical System.
  • 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 s.
Oracle Data Mining Analyst
June 2006 to August 2007 CDFD － Hyderabad
  • The Centre for DNA Fingerprinting and Diagnostics (CDFD) is an autonomous organization funded by the Ministry of Science and Technology, Government of India.
  • The project I dealt here was APS - Automatic Pattern search.
  • 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, WHEN_OTHERS.
  • Used Oracle BLAST related functions to find and analyze the DNA patterns.
  • Involved in sequencing similarity.
Build Your Own Now

Resume Overview

Companies Worked For:

  • Tools & Technologies
  • Hunt Oil
  • Novo Nordisk
  • Kodak
  • Aurora Bank
  • Commerce National Insurance
  • CDFD

Job Titles Held:

  • Oracle pl/sql Developer
  • Oracle Developer
  • Oracle Database Analyst
  • Oracle Data Mining Analyst

Advertisement

Similar Resumes

View All

Sr. SQL Developer

Kewill Inc

Plainsboro, New Jersey

Posted 1339 days ago