We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

SUMMARY

  • Around 8+ years of experience in programming as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS) in Telecommunication sector as well in Real time projects.
  • Over 6 years and 8 month years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
  • Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
  • Expertise in Client - Server application development using Oracle 11g/10g/9i, PL/SQL, TOAD, SQL *PLUS, SQL*LOADER and SQL SERVER 2008
  • Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views.
  • Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
  • Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
  • Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
  • Loaded Data into Oracle Tables using SQL Loader.
  • Partitioned large Tables using range partition technique.
  • Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
  • Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
  • Worked extensively on Ref Cursor, External Tables and Collections.
  • Expertise in Dynamic SQL, Collections and Exception handling.
  • UNIX Shell scripting experience.
  • Good experience in core java
  • Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
  • Experience in Requirements Gathering, Business Analysis, Business Process Redesign and Mapping, Testing & User training, Documentation of activities, processes, test scripts and results and Client interaction.
  • Created Shell Scripts for invoking SQL scripts.
  • Use SED, grep for filtering and providing from huge amount of data.
  • Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
  • Interacting with clients to understand requirements
  • Good in Understanding of Business logic and ability to work well as a part of a team and as an individual.
  • Have a very good debugging and problem solving skills.
  • Experience to provide solution for various billing requirements and can create the test environment for testing.
  • Completed Engineering in Computer Science with first class and grade honors

TECHNICAL SKILLS

Operating System: Windows Families, UNIX

Languages: Core Java

Database: Oracle 11g/9i/10

Tools: winscp, putty, SQL Developer, Rational Clearcase, Tortoise CVS, Beyond Compare, Winmerge, Eclipse, Toad

PROFESSIONAL EXPERIENCE

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Develop GUI for DEALER portal
  • Handling Enhancements in web application
  • Preparing build and publishing
  • Bug fix in oracle plsql

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Development of CR s
  • Providing PR fixes and hot fixes
  • Data loading from PROD to local machine
  • Writing plsql packages, procedure etc.. as mentioned above. And involving in build activities

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Performing performance tuning of stored procedures
  • Performing production deployment and production support after development
  • Direct client interaction to understand requirement, fix the production issues
  • Monitoring the production system

Hire Now