Roles & Responsibilities: At Oracle I worked with Inventory Management team which is an Integral part of the logistics family of application. Learning at Oracle comes in context with enterprise resource planning & technologies involved in it's development and implementation. I was responsible for the maintenance and enhancement of Inventory module and it required coordination with teams spread across the globe.
By working with Inventory team I got a good catch on following areas:
1. Inventory Management
2. Warehouse Management Systems.
3. Order management.
4. Work in Progress
5. Shipping
6. Purchasing
Technologies :
1. The product follows a three tier architecture which involves
- Client tier
- Applications tier
- Database tier
2. Oracle Forms for the UI Layer.
3. Oracle Reports for Building reports on top of views and tables.
4. Oracle RDBMS various versions.
5. OA Frameworks (For building pages on Java)
Programming languages :
1. PL/SQL is used majorly in developing business logic i.e. for data validation and performing DML operations.
2. Java is used widely for implementing logic for transaction managers.
Completed Trainings
1. SQL tuning workshop for fine tuning the SQL queries so as to step their performance. Also the training provided in-depth knowledge of Oracle Database
architecture and the role played by indexes and their impact on table perfromance.
2. AOL coding standards training.
3. Forms & Reports training.
4. Extensive training of SQL and PL/SQL.
5. Ebiz product implementation and architecture.