Oracle Analyst Programmer
Centegy Technologies Pvt Ltd.
Total years of experience :11 years, 4 Months
Issues Rectification and Technical Resolution using Oracle Forms and reports for the Insurance ERP System. The System comprises the following Major Modules.
- New Business
- Agency
- Alteration
- Accounting
- Claim / Settlement
- Reassurance
- Processes.
- Premium Services
Technical Support of module - Term Deposits premature encashment.
Worked on the Admin Inventory System.
Worked technical on the Chequebook Module.
Technical support to the Locker Module to all DIB branches in Pakistan.
Working in Automated charges deduction system of different products.
Worked on Business Objects Reporting Tool.
Database manually and scheduled Backups by DMP Files.
Troubleshooting databases issues.
Usage of RMAN for full Database backups.
Database upgraded from 10.2.1.0 to 10.2.3.0.
Implemented and maintaining DATAGUARD (STANDBY MACHINE).
Maintaining tables, schemas with segment advisor, statistics gathers.
Maintenance of deadlocks and blocking sessions.
Creating ERP users, grant/revoke access at ERP to end users.
Desktop support to end users in factory.
- Learned to use the oracle 11g
- Observed the Data guard (DR) environment Oracle 11g
- Oracle 11g OEM Grid Control Installation.
- Monitoring the testing and live Database.
- Optimization of large data tables with the help of Table Partinioning.
Created Scripts to optimize the Database performance.
Created Scripts to optimize reports server .
Created general scripts to add, drop, modify user and schemas in database.
Co-ordinated with users to resolve their Database performance issues.
Dealt with users for their requirments to modify their front end of forms or reports.
Testing of scripts at Testing Server and than requests to execute it at Production Server.
Monitoring LAN Network.
Branch support for online branches in Karachi.
Provide LAN support to Head Office LAN users and troubleshoot the issue, rectify the issues and also coordinate with local venders for LAN faults.
Worked as a part of team in setting up Cisco switches on VLAN.
Performing daily office task in network Integration and operations.
Monitor Network nodes on NMS for monitoring.
Configuring of outlook emails and troubleshooting at client end.
Rectify and resolve internet issues at client end.
Provide pc system support to the head office.