As an Oracle Developer involved in the full life cycle of projects from Requirement study to Handover of the project which includes analysis, user requirements, database modification, coding, Support and testing in various environments and Responsibilities include gathering functional and technical requirements, design, development and resolution of problem tickets raised by users.
Documentation which includes SRS, STS, TCM, UG
Developing new applications and reports (oracle report, Discoverer) to suite corporate new requirements.
Developed and modified many reports to support different modules in the Orion ERP.
Ongoing support to GL/AR/AP/Procurement/Inventory/Fixed Asset Modules
Production Support: Working on post production support phase which involves bug fixes, enhancement of existing and new features.
Integrating 9i Developed Applications and Reports with Orion ERP.
Enhancement to existing applications and customizations based on user requests.
Working on Performance Tuning to increase the performance of Concurrent programs.
Expertise in working with PL/SQL stored procedures, triggers, packages
Possess excellent communication skills and a smooth client handling and interaction experience. Strong proficiency in problem solving, Initiative taking, Time management.
A number of simple applications developed with oracle forms were migrated to Oracle Apex.
Testing, Debugging and code migration
Assisting with impact analysis of any changes made to the database objects
Troubleshooting with problems regarding the databases, applications and development tools
Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures
Scheduling database backup, monitoring and testing validity of backup
Enforcing and maintaining database constraints to ensure integrity of the database
Using expdp, impdp, exp, imp utilities to export and import database and database objects for different purposes
Achievements
Labor Timesheet Management
Developed Labor time sheet tracking system to track and analyze efficiency of employees that were done by many employees in many excel files. By doing this all work were brought to single point and this helped to provide many reports for top level.
Designed and Developed Project Master screen that keeps tracks of all running projects
Designed the screen that records Team Head and subordinates allotted for different projects
Designed the screen that records head's allotment of time to subordinates
Developed the screen that helps to manage subordinates leaves.
Developed the screen that helps to edit subordinate in an out time
Developed the report that shows Idle hours of subordinate grouping by head
Developed the report that shows monthly attendance of employees
Developed the report that shows number of worked hours on different levels
Developed the report that shows running of projects
Employee Cost to Company
Provided CTC form to accounts department to simplify the process of CTC calculation of employees. This was done by different departments manually causing discrepancies.
Designed the screen that facilitate to Enter user employee code and produce employee cost to company.
Designed the report that displays employees cost to company in a printable format.
Online Approval Outlook
Architecture Re-Design of existing Online Approval Outlook so as to resolve performance issues (3-5 minutes per load to 5-10 seconds)
Developed a screen that gives logged in users information of different kind of requests that are pending for action from his/her side. This is a complicated application which brings all requests to single screen. Request can be material request, asset request, purchase request.
Added Enhancement Modules of Online Approval of Request to Enquiry Stage
- Company industry:
- Purchasing & Procurement
- Job role:
-
Information Technology
