We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

West Palm Beach, FL

SUMMARY:

  • Oracle Certified Associate.
  • Over Seven Plus years of Information Technology experience includes Business Analysis, Software Development and Implementation of Oracle 10g/9i/8i//7.x as Developer 2000 (Forms and Reports 6i), Designer 2000 for two and three tier Client/Server applications.
  • Experienced in development of Database server side programming using Oracle PL/SQL viz., Stored Procedures, Database Triggers, and Packages, Development of materialized views, Clustered tables, Indexes, and table creations.
  • Experience in Development and Implementation phases of complete Software Development Life Cycle.
  • Expertise in design and development of application in relational database, client server environment and web-enabled environment using Oracle 7.x/8.x/9i/10g.
  • Proficient in Logical and Physical Design of Databases using Erwin data modeler.
  • In-depth knowledge of Oracle Architecture.
  • Expertise in Oracle, Visual Basic, Developer/2000 and Oracle Discoverer.
  • Developed various complex reports using Crystal Reports and integrated with Crystal Enterprise.
  • In-depth knowledge of Cost Based and Rule based query optimization techniques.
  • Good communication skills, leadership qualities and excellent team player.

TECHNICAL SKILLS:

Language: PRO*C, SQL, PL/SQL, C, C++, HTML, XML, Visual Basic 6, Perl. DBMS: Oracle 10g/ 9i / 8i / 8 / 7.3, MS SQL Server 2000, MS Access. Tools: Oracle Enterprise Manager, Erwin/Visio Data Modeler, Toad, Export, Import, RMAN, SQL Loader, Log Miner, Change Manager, Oracle 9i/8i IAS, Arc Serve 7, and Crystal reports XI, 10, Operating System: Windows 2000/NT/XP/98/95, MS-DOS.

TRAININGS:

  • Diploma in Computer Application
  • Certificate Course in Orac8i, Visual Basic 6.0, C/C++ programming.
  • Oracle 9i OCA Certification (1Z0-001(SQL) Exam 100% scoreand Fundamentals-I Exam 93% score.)

PROFESSIONAL EXPERIENCE:

Confidential, West Palm Beach, FL Apr 09 - Till Date Oracle PL/SQL Developer

Project - Phoenix

Overview

Physical Power Migration Project. Phoenix- Physical Power Migration Project

Responsibilities:

  • Meeting with end user, collecting requirements and converting into technical specification.
  • Create detailed documentation for user approval.
  • Created and modified data migration scripts/Pull Scripts.
  • Loading data from Existing database schema to new schema using Oracle Packages.
  • Involved in writing PL/SQL Store Procedures, Functions, Cursors, Triggers and Packages
  • Wrote database triggers for automatic updating the tables and views.
  • Create User Schemas, tables, indexes, sequences, views, directories.
  • Verify, validate data using SQL queries
  • Modified existing Code according to the requirements.
  • Day to day production support.
  • Troubleshoot and debug system and/or data errors.
  • Tuned SQL queries using Tkprof utility to improve performance.
  • Involved in Testing, Integration System test, Implementation (test with users).
  • Created and modified several Discoverer reports.
  • Created and customized analytical reports for existing system using Reports 10g.
  • Converted data from legacy system to Oracle 10g using PL/SQL programs.
  • Responsible for creating complex views for EUL of Oracle Discoverer10g.
  • Responsible for developing new reports using Oracle Discoverer Desktop/Plus 10g and Oracle reports.
  • Responsible for modifying & creating Business Areas using Oracle Discoverer Admin for changed & new reports. Responsible for developing new reports in Oracle XML/BI publisher 5.6.2.
  • Modified existing oracle reports and Created new forms based on requirements.

Environment: Oracle 10g, PL/SQL, Toad 9.0, SQL*Plus, Oracle Discoverer Administrator 10g , Oracle Discoverer Desktop 10g , Oracle Forms 6i, Oracle Reports 6i, Windows XP.

Confidential, Orlando, FL May 08 - Dec 08 Oracle PL/SQL Developer/DBA Project - GoMaster Overview Responsibilities

  • Create detailed documentation for Data conversion and migration.
  • Installed Oracle client software on client machines and established connectivity with the database server.
  • Created all the types of Oracle database security using system privileges, object privileges roles and database triggers for database auditing.
  • Loading large data into the Oracle database objects. Importing/Exporting data from/to different databases using utilities like SQL*Loader and Import/Export.
  • Wrote fine tuned SQL queries to Migrate and Convert the data.
  • Verify, validate data before and after migration/Conversion according to the requirements.
  • Modified existing Code according to the requirements.
  • Wrote Oracle database triggers, stored procedures, stored functions, and stored packages to perform various automated tasks to performed for better performance Used different joins, sub-query, nested query in SQL query, for reporting purpose.
  • Wrote database triggers for automatic updating the tables and views.
  • Troubleshoot and debug system and/or data errors.
  • Tuned SQL queries using Tkprof utility to improve performance.
  • Involved in Testing, Integration System test, Implementation (test with users).

Environment: Oracle 10g, PL/SQL, SQL*Loader, Toad 9.0.1, SQL*Plus, Windows XP.

Confidential, Lake Mary, FL Nov 07 - Apr 08 Oracle PL/SQL Developer Project - TOURBOOK Responsibilities

  • Loading data from XML files into Oracle database.
  • Verify, validate data using SQL queries and create text according to the requirements.
  • Modified existing Code according to the requirements.
  • Load the created text in to the normalized tables using PL/SQL Store Procedures, Functions and Packages.
  • Created XML sheets to send the data to the AAA Tour book publishing department to print the AAA Tour Books.
  • Involved in writing PL/SQL Store Procedures, Functions, Cursors, Ref Cursors Triggers and Packages.
  • Troubleshoot and debug system and/or data errors.
  • Tuned SQL queries using Tkprof utility to improve performance.
  • Involved in Testing, Integration System test, Implementation.

Environment: Oracle 10g, PL/SQL, SQL*Loader, Toad 9.0.1, SQL*Plus, Windows XP.

Confidential, Orlando, FL Apr 07 - Oct2007 Oracle PL/SQL Developer Project - TRIMS (Toll Revenue Integrated Management System) Responsibilities:

  • Loading data from flat files into Oracle 10g database using SQL*loader and Unix script
  • Verify, validate data using SQL queries
  • Involved in writing PL/SQL Store Procedures, Functions, Cursors, Ref Cursors Triggers and Packages.
  • Troubleshoot and debug system and/or data errors.
  • Create User Schemas, tables, indexes, sequences, views, directories.
  • Create detailed documentation for user approval.
  • Modified existing Code according to the requirements.
  • Tuned SQL queries using Tkprof utility to improve performance.
  • Done the requirement study and tool selection for replacing the existing 400 reports from oracle reports 2.5 to crystal reports XI.
  • Designed and installed the crystal report server XI for the OOCEA to publish the new crystal reports.
  • Created users and groups for implementing security and implemented the folder security.
  • Done requirement study and developed reports from oracle 2.5 to crystal reports XI.
  • Involved in Testing, Integration System test, Implementation (test with users).

Environment: Oracle 10g, PL/SQL, SQL*Loader, Toad 9.0.1, SQL*Plus, Windows XP, Crystal Reports .

Confidential, Chicago, IL Oct 06 - Mar2007 Oracle PL/SQL Developer Project - Basix Data Migration Responsibilities:

  • Created and modified data migration scripts/Pull Scripts.
  • Loading data from flat files into Oracle 9i database using SQL*loader and Unix script
  • Verify, validate data using SQL queries
  • Involved in writing PL/SQL Store Procedures, Functions, Cursors, Triggers and Packages
  • Troubleshoot and debug system and/or data errors
  • Write Unix scripts to upload data from text files (and control files) to the database using sqlloader
  • Create User Schemas, tables, indexes, sequences, views, directories.
  • Create detailed documentation for user approval.
  • Modified existing Code according to the requirements.
  • Add new functionality for fetching multiple records (for different dates) based on business logic.
  • Involved in Testing, Integration System test, Implementation.

Environment: Oracle 9i, PL/SQL, SQL*Loader, Toad 8.2, SQL*Plus, Windows XP.

Confidential, South Carolina Feb 06 -Sep 2006 Oracle PL/SQL Developer Responsibilities:

  • Loading data from flat files into Oracle 9i database using SQL*loader and Perl
  • Verify, validate data using SQL queries
  • Involved in writing PL/SQL Store Procedures, Functions, Triggers and Packages
  • Tuned SQL queries using Tkprof utility to improve performance.
  • Troubleshoot and debug system and/or data errors
  • Setup, check and deliver Ad hoc/special requests
  • Write Perl scripts to upload data from text files (and control files) to the database using sqlloader
  • Create User Schemas, tables, indexes, sequences, views, directories.
  • Create and maintain detailed documentation and adhere to standard operating procedures.

Environment: Oracle 9i, PL/SQL, SQL*Loader, Toad 8.2, SQL*Plus, SQL Navigator, Crystal reports10, Perl, Windows XP.

Confidential, Tulsa, Oklahoma Sep 2005 - Feb 2006 Oracle Developer Project- FAS133 Responsibilities:

  • Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming and Query Level Performance tuning.
  • Importing/Exporting data from/to different databases using utilities like SQL*Loader, Import/Export.
  • Written many database triggers for automatic updating the tables and views.
  • Tuning the application
  • On-going maintenance of FSA133 system user interface.
  • Maintenance of existing programs written Pl/sql.
  • Created indexes on tables and Optimizing Stored procedure queries.
  • Used extensively PL/SQL, to develop packages, stored procedure, functions and database triggers.
  • Tuned SQL queries using Tkprof utility to improve performance.
  • Used Designer 6i for Dataflow and Entity relationship diagram.
  • Developed procedures, functions for different reports.
  • Used different joins, sub-query, and nested query in SQL query, for reports.
  • Extensively used PL/SQL in reports to perform calculation and to get desired output.
  • Interacted with end user for problems faced and providing necessary technical support
  • Testing, Integration System test, Implementation (test with users) and documented the entire project.

Environment: Visual Basic 6.0, Oracle8i, PL/SQL, SQLPlus, Oracle reports 6i, Crystal reports 8,SQL Navigator.

Confidential, NY Jun 2004 - Sept 2005 Oracle Developer Envirnment: Oracle 9i, PL/SQL, SQL*PLUS, HTML, Win 2000/2003.

Confidential, NJ May 2003 - Jun 2004 Oracle Developer Environment: Oracle 9i, Oracle Enterprise Manager, SQL*PLUS, SQL* LOADER, PL/SQL, Windows 2000.

Confidential, NJ Oracle Developer Jun 2002 - May 2003 Project: Stock Option System Environment: Oracle 8i/9i, SQL*PLUS, SQL* LOADER, PL/SQL, Reports 6i, Win NT/2000.

Confidential Oracle Developer Jan 2001 - Jun 2002 Project: e-Track Environment: Oracle 9i/10g, Forms 6i, PL/SQL, HP-Unix, Win NT.

Confidential, Mumbai, India Feb 2000 - Dec 2000 Developer/Programmer Responsibilities:

  • Application developed using Visual Basic as front end and Oracle database at back end.
  • Created database backup procedures, which in turn used for Oracle 7.x Database recovery, Using cold backup and logical backups with Export and restoring the data with Import.
  • Created and tested database recovery procedures to best use for disaster recovery. Running the database in Archive log mode and backing up archived redo logs, which are used to restore the database up to the point of restoration.
  • Created and reorganized all types of Oracle database objects including tables, views, indexes, sequences, synonyms and setting proper parameters and values for all the objects using Oracle 8.0
  • Created all the types of Oracle database security using system privileges, object privileges roles and database triggers for database auditing.
  • Wrote Oracle database triggers, stored procedures, stored functions, and stored packages to perform various automated tasks to performed for better performance Used different joins, sub-query, nested query in SQL query, for reporting purpose.
  • Installed Oracle Software on Windows NT.
  • Installed Oracle client software on client machines and established connectivity with the database server.
  • Created reports from different Oracle 8.0 Databases.

Environment: Visual Basic 6.0, ORACLE 7.x/8.0, PL/SQL, Windows NT.

Hire Now