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

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship