Oracle PL-SQL Developer Resume San Jose, CA - Hire IT People

SUMMARY:

Over 3+ years of IT experience in software development, documentation, designing and requirement gathering with major focus around Data Warehousing and Database Applications
Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
Expertise in Client - Server application development using Oracle 11g/10g, PL/SQL, SQL, PLUS.
Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
Good knowledge on logical and physical Data Modeling using normalizing Techniques.
Creation of database objects like Tables, Views, procedures and packages using oracle tools like TOAD,PL/SQL Developer
Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
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.
Experience in SQL performance tuning using Cost-Based Optimization (CBO).
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 ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Cognos.
Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
Excellent communication, interpersonal, analytical skills and strong ability to perform.

TECHNICAL SKILLS:

Operating Systems: Windows NT/95/98/2000/XP/7, MAC OS, UNIX/LINUX

Languages/Web: C, SQL, PL/SQL, SQL*Plus, HTML, Shell Scripting and MS-Excel, XML, XSLT, HTML, Unix Shell Scripting.

Internet: HTML, CSS

Databases: ORACLE, PLSQL, MY SQL, SQL Server 2000.

Testing Tools: Oracle e-Tester, QTP, Test Complete (Automated QA), Selenium IDE, Web-Drivers with Java.

Development Tools: Eclipse, Android SDK, Android Studio, X-Code. eb services Service-Oriented Architecture (SOA), XML, WSDL, MQs

Version Controller: Visual Source Safe, Mercurial, SVN, Source Tree

Tools: Office, TOAD, MS Project, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Oracle PL-SQL Developer

Responsibilities:

Create Stored Procedures, SQL Scripts for development and testing etc.
Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
Developed PL/SQL triggers and master tables for automatic creation of primary keys.
Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
Created indexes on the tables for faster retrieval of the data to enhance database performance.
Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
Partitioned the fact tables and materialized views to enhance the performance.
Extensively used bulk collection in PL/SQL objects for improving the performing.
Created and manipulated stored procedures,functions,packages and triggers using TOAD
Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: ORACLE 10G/11G, Oracle PLSQL, UNIX, TOAD, ECLIPSE, MS SQL SERVER 2005

Confidential

DBA Developer

Responsibilities:

Involved in analyzing Business Requirement Document and Technical Specification Document and developed test plan and test cases for testing the application.
Deployed Oracle forms and Oracle Reports on web
Converted some of Forms 5.0 to Forms 6i
Created visual attributes, property classes, object groups
Created object library to customize all forms uniformly.
Wrote complex triggers to build up the audit log tables for critical data
Developed shell scripts to automate
Assisting in the maintenance, review, and update of the User Guide
Assisting in User Acceptance Testing and Assisting in providing user training

Environment: Oracle 8i, UNIX, SQL, PL/SQL, Pro *C, TOAD, Windows NT.

We provide IT Staff Augmentation Services!

Oracle Pl-sql Developer Resume

San Jose, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship