We provide IT Staff Augmentation Services!

Senior Oracle Pl/sql Developer Resume

SUMMARY:

  • Oracle Certified Senior Oracle Developer wif 13 years experience in Oracle Database and PL/SQL
  • Experience in all phases of SDLC including Requirement Analysis, Application Design, Development of Multi - tier Applications, Testing, Implementation and Maintenance
  • Data model designing expertise
  • Proficient in SQL, PL/SQL stored procedures, packages and triggers
  • Performance Tuning experience using HINTs, INDEX, Explain Plan and trace files generated by TKPROF
  • Worked wif partitioned tables in very large database environment (10 terabyte) in replicated databases
  • Experience in UNIX Shell scripting
  • Basic Oracle DBA skills and maintainence experience of Oracle Application Server 10g on Red Hat Linux
  • Experience in JSP, ASP and noledge of Oracle Portal

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, C++, Visual C++, Visual Basic, UNIX Shell scripting

Database: Oracle 11g/10g, Microsoft Access

Operating Systems: Unix, Linux, Windows

OLAP Tools: Business Objects, Oracle Discoverer 9i, Spotfire Reports

Web Development: JSP, Servlets, ASP, JDBC, HTML

Other Tools/Utilities: SQL*Loader, Power Designer, Toad, SQL Navigator, PVCS, Accurev, Autosys

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle PL/SQL Developer

Responsibilities:

  • Analyze user requirement and prepare design document
  • Develop and modify Oracle PL/SQL procedures, functions, packages and triggers used by application
  • Rewrite SQLs using HINTs, BULK Collect, create index to improve performance
  • Create and modify reports sent from Unix shell scripts, Report server and Spotfire Reports
  • Modify and create Unix scripts
  • Analyze questions from users and give feedback
  • Debug production issues and fix code

Environment: Oracle 10g, SQL, PL/SQL, TOAD

Confidential

Senior Oracle PL/SQL Developer

Responsibilities:

  • Requirement analysis, design, development, testing and documentation
  • Develop new Oracle PL/SQL procedures, functions, packages and reports
  • Used SQL*Loader extensively to load legacy data into tables
  • Tune SQLs to improve performance
  • Modify existing Unix scripts and create new scripts
  • Debug production issues and fix code

Environment: Oracle 11g/10g, SQL, PL/SQL, TOAD

Confidential

Lead Oracle PL/SQL Developer

Responsibilities:

  • Worked wif partitioned tables in very large database environment (10 terabyte) in replicated databases.
  • Worked as lead Oracle developer in teh IVR team of 40 people in a very demanding environment and closely worked wif Business Analysts, Peri pro developers, JAVA developers, QA team, Infrastructure and support team, DBAs to solve various issues.
  • Analyze teh requirements and design solutions for various projects in Oracle including after call survey of IVR application, reporting applications, JAVA applications and give assistance to peri pro developers and Business Analysts wif adhoc queries. Familiar wif analytic functions
  • Design, Development and maintenance of packages, stored procedures, functions, triggers in Oracle PL/SQL for various IVR, Java applications.
  • Performance tuning of SQLs: rewrite SQLs, create index, HINT etc.
  • Analyze production issues related to Oracle backend processes and implement solutions. Strong data analysis skills.
  • Data model designing including tables, constraints, primary keys, foreign keys, indices, views
  • Worked wif partitioned tables in very large database environment (10 terabyte) in replicated databases.

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL Navigator

Confidential

Senior Oracle Developer (Full Time)

Responsibilities:

  • Design, Development and maintenance of PUCM / IEPO batch processes developed in Oracle PL/SQL. IEPO data is extracted to flat files and sent to teh main accounting system daily three times.
  • Prepared Business Requirement Documents and technical documents
  • Analysed issues reported by users, gave feedback and solutions.
  • Developed packages, stored procedures, functions and database triggers using PL/SQL
  • Experience in data loading using SQL*Loader and exporting data to flat files using UTL FILE package
  • Tuning experience using HINTs, Explain Plan and trace files generated by TKPROF
  • Developed UNIX Shell scripts
  • Created unit test cases and documents.

Environment: Oracle 10g/9i, SQL, PL/SQL, UNIX, Toad, Oracle Developer 6i, Oracle Developer Suite 10g

Confidential

Senior Developer

Responsibilities:

  • Development and maintenance experience of new as well as existing applications related to agriculture, animal and fish resources and licenses in Oracle and Oracle 9iDS.
  • Experience in Data Modeling, E-R diagrams and Logical, Physical Database Design
  • Experience in developing packages, stored procedures, functions and database triggers in Oracle PL/SQL
  • Assisted DBA during installation and migration of database from Oracle 9i to Oracle 9i RAC and ran backup scripts / RMAN backups and sort statistics during his absence.
  • Experience in SQL Loader, Export / Import schemas between production and development server
  • Expertise in Business Objects Universe Design and creating reports in BO Full client and Web Intelligence (6.1a and 6.5). Experience in Supervisor module.
  • Developed statistical reports in Oracle Disoverer 9i
  • Installation and maintenance experience of Oracle Application Server 10g on Redhat Linux Advanced Server3
  • Developed many systems for portal such as telephone directory, news update in JSP
  • Assisted IT Consultant to prepare requirement studies, generate request for proposals and evaluation of proposals in selection of potential suppliers for teh implementation of infrastructure elements

Environment: Oracle 9i/9iRAC, UNIX, PL/SQL, Toad, Oracle Developer 6i,Oracle 9iDS,Oracle Discoverer 9i, Windows 200 Server, Windows XP, Business Objects 5.1/6.1/6.5

Confidential

Software Engineer

Responsibilities:

  • Designed, developed and implemented Student Advising System used to give guidance to students and generate statistical reports for teh colege in Student Affairs Department in Oracle/Oracle Forms and Reports
  • Designed and created tables, stored procedures, triggers in Oracle PL/SQL
  • Developed and migrated Faculty database originaly developed in Microsoft Access to Oracle / Developer
  • Developed JSP pages for faculty member’s homepages (backend Oracle Database)
  • Developed ASP pages to update and serach GCC Engineering Coleges Database in Microsoft Access
  • Developed and maintained Colege static Web page in HTML
  • Developed Visual Basic program for teh translitration of Arabic characters to English. Assisted in other research projects by testing and modifying teh algorithms in C++.

Environment: Oracle 8, Oracle Developer 5, JSP,ASP,Microsoft Access, Frontpage, HTML, Visual Basic, Solaris