Oracle Database Developer Resume

PROFICIENCIES:

Web Backend Development: Python, Jinja, Google App Engine

Web Frontend Development: HTML5, CSS, JavaScript, Bootstrap

Oracle: PL/SQL - stored procedures and functions and packages, database triggers

Oracle: Replication, Advanced Queuing, SQL Loader, Performance tuning using Explain Plan and Trace utility

Oracle: Developer 2000, Crystal Reports

Data Mining: Completed a course on data mining using Hadoop, MapReduce, Pig, Hive, Impala from UC Irvine extension.

EXPERIENCE:

Oracle Database Developer

Confidential

Responsibilities:

Developed the Membership module for this non-profit organization.
I designed and implemented the Membership module to allow for adding new Members to the Organization.
I advised the company on the best way of approach to in corporate Memberships with minimal changes to existing Donations in the form of Grants and Individual Donations.

Confidential, Irvine, CA

Programmer Analyst

Responsibilities:

Creating and maintaining backend objects in Oracle.
Creating and maintaining Unix shell scripts for the automated jobs that run every night.
Interacting with the main Financial Services branch in Seattle to do complete analysis and design of their requirements.
Actively supporting the night jobs.
Setting up coding standards.
I was the technical lead for database issues.
I was awarded “Employee of the Month” for my performance and dedication.

Confidential, Santa Monica, CA

Applications Engineer

Responsibilities:

Order object creation by extracting relevant information pertaining to an order from the database using SQL queries and tuning the queries for optimal performance.
Working with business analysts and warehouse representatives to format and parse the order object according to business logic rules developed for the process.
Sending and receiving formatted data and status reports to the appropriate warehouse using CLOB or Oracle Advanced Queuing.
Backorder module - checking the inventory status and taking appropriate action, for example canceling the order based on delivery constraints or notifying the customer of order status.
Maintaining these modules in the Production environment, trouble-shooting and system monitoring. I was also given the responsibility of taking over some existing modules from external consultants, understanding and sometimes modifying them according to updated business logic and maintaining them in production.
Responsible for about 40% of the entire Order Processing modules.
Some of the Oracle features I used while on this project are: varrays, object types and LOBs. Also worked on Advanced Queuing of Oracle. This system uses Oracle plus Java.

Confidential, San Rafael, CA

Programmer Analyst

Responsibilities:

Helped develop and implement an Oracle replication utility which allows marketing and sales representatives of a client to enter information on a laptop, upload the data to a server and download updated data from the server.
Hence after this ‘replication’, all sales representatives would be in sync.
Tuned SQL statements to improve performance, using Explain Plan and Trace utilities.
Been to a major client site to successfully install and fine tune the replication utility.

Confidential, Cupertino, CA

Programmer Analyst

Responsibilities:

Developed stored procedures, functions, packages and database triggers for the Mail Services System of Confidential using Oracle, Mac OS 8.5 and AIX Unix ver
Responsible for successfully integrating this system with an already existing system called ‘Directory Services’.
Helped design an interface between the two systems to successfully accomplish the integration.
Actively involved in client interaction with the Mail Services department.

Confidential, Palo Alto, CA

Programmer

Responsibilities:

Research and Development Financial Management System for Confidential
Developed stored procedures using PL/SQL for Oracle and Oracle web server and Javascript.
Used Javascript to code front end validations so as to have a thin client.

Confidential

Senior Systems Engineer

Responsibilities:

Imation Photographic Research and Development Support System
Imation -, a recent spin-off from 3M, has core business in ‘Data Storage’ and ‘Imaging’ products.
It has its manufacturing and R&D facilities in Ferrania, Italy for its imaging products.
Developed modules for the Impress system in Developer 2000 and Oracle.
Involved in QA review and Unit level testing.

Confidential,

Senior Software Engineer

Responsibilities:

Helps the bank to maintain information about money lent to different companies for various purposes and generate different reports that helps in important decisions.
Developed these systems in Oracle and Developer 2000.
Also responsible for successful implementation and training at the client site of Dena Bank.