I was involved in creating stored procedures to convert sql loader scripts to scripts based on external tables in a very tight deadline. Also involved in tuning the queries used by them by using parallel loading

I was working to convert Form based application to Java based application.

Involved in converting the logic in forms to PLSQL coding

I have to create stored procedures to match circuits from different provisioning system.

This project is for a shipping company, I have to create forms and stored procs during the course of the project

Performance Tuning, Oracle DBAActivities

Performance Tuning, Forms / Reports, Java

Performance Tuning

Query Tuning, Shell Scripting, Hyperion, SQL Loader

Query Tuning, Shell Scripting

Query Tuning, Shell Scripting

Calling / emailing customers on batch failure.

Maintenance of Accounts, EDI, CIS etc.,

This is a complete development project from the scratch. I am developing new plsql packages, Triggers etc., this project is for generation of Token for trucks that enter the port for loading / unloading of containers. In short this project is built for port operations. This is a very prestigious project for the port, even a small problem can cause lots of impacts. The project contains following four main parts. 1. Agent creates the request online to get empty containers from the port. And this process can be called MT OUT. 2. After getting the container, agent will load the container and send back to the port for export. And this cannot be done without a proper request. This is called EXP IN. 3. Customer imports data from other country ports and takes delivery of fully loaded container. And this can be called as FCL OUT. 4. Customer returns back the container to the port after getting import delivery. All 1, 3 and 4 requires an agent request, and a token has to be created to take delivery/deposit the containers. Haulier Nomination is another module before creating EToken. Once the request is created agent has to nominate haulier. This is sometimes automatically done by the system. Next process is EToken, without nomination token cannot be created. EToken includes the name of the truck, time of the entry into the port. A token can be created for a truck Which can contain a maximum of three containers. All the container numbers has to be specified in the EToken.

Creating Apex Applications, Apex Services, Database Design., Proof of Concepts for customers.