PL SQL Developer Resume

SUMMARY

9+ years of programming experience, working as PL/SQL developer involving i Requirement Analysis, Design and Implementation of Business Application using the Oracle 12c/11g/10g/9i/8i
Developed Complex DB objects Packages, Triggers using PL/SQL, responsible in integrating with the Front - end applications
Experience with Data flow diagrams, Data dictionary, Database normalization techniques, Entity relation modeling and design techniques.
Developed materialized views for data replication in distributed environments.
Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
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 suppled packages such as DBMS SQL, DBMS JOB and UTL FILE
Proficient in Dynamic SQL, Collections and Exception handling, performance tuning and Cost based Optimization
Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

PROFESSIONAL EXPERIENCE

PL SQL Developer

Confidential

Responsibilities:

Responsible interfacing with the front-end design team to provide them with the necessary Oracle Packages and explain the business rule functionality of that procedure
Involved in the continuous enhancements and fixing of production problems.
Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
Developed PL/SQL triggers and tables for automatic creation of primary keys.
Created PL/SQL Packages and Package body for moving the data from staging area to data mart.
Created scripts to create new tables, views, queries for new enhancement in the application
Created indexes on the tables for faster retrieval of the data to enhance database performance.
Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

Environment: Oracle 11g,Oracle Collaboration Suite,PL/SQL Web Tool Kit, JavaScript, DHTML, Apache Server, Windows NT, HPUnix, Shell scripts

Oracle PL/SQL Developer

Confidential

Responsibilities:

Played Full stack developer role, responsible in developing the website using JavaScript and DHTML
As a back-end developer, responsible in developing the Oracle Package/Package bodies for the business rules to extract the data from Oracle Database
Supporting the Oracle Financial development team for developing the required Oracle SQL functionality
Responsible in supporting the Oracle Financial based Order Entry portal, bug fixing and enhancements
Responsible for Query optimization, Performance tuning and DBA solutions in a complete SDLC of the project

Environment: Oracle 9i,oracle Collaboration Suite,PL/SQL Web Tool Kit, JavaScript, DHTML, Apache Server, Windows NT, HPUnix.

Software Engineer

Confidential, CA

Responsibilities:

Developed Enterprise Java Beans (EJBs) to ease the implementation and deployment of application components.
Developed servlets and provide excellent application management capabilities.
Developed both Session and Entity beans representing different types of Business logic abstractions.
Written PL/SQL stored procedures, functions and triggers.
Developed Servlets to handle HTTP requests from multiple clients. Acting as a client, which sends requests through the Gateway Server to the Servlets residing in the Application Server.
Involved in testing and documentation.

Environment: Oracle 8i, PL/SQL, JavaScript, EJB, BEA Web Logic, HTML, DHTML, Windows NT.