Assistant Manager
Treet Group of Corporation Lahore
Total years of experience :15 years, 0 Months
WORKING RESPONSIBILITIES
•Developed New Reports and Form in Oracle Application R12
•Design complicated forms and reports in oracle developer suite (oracle 6i, 10g)
•Write complex pl/sql blocks.
•Writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers
•Created Oracle Tables, Views, Synonyms
•Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data
•Develop XML Reports
•Worked In All Modules (GL, AP, AR, Purchasing, Inventory, Order Management, Global HRMS, Fixed Assets, Cash Management
Developed New Reports and Form in Oracle Application R12
Develop and Manage the Vehicle management Software (oracle 10g)
Develop and Manage the Machine management Software (oracle 10g)
Support the existing in house developed applications
(Aims, APMS, Iqra Management software etc. developed in old tools as vb.net, Fox pro and SQL Server etc.)
Design complicated forms and reports in oracle developer suite (oracle 6i, 10g)
Write complex pl/sql blocks.
Writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers
Technical and functional support to payroll and HR and handle over all Pay roll of 4 units.
Design cheque printing software in oracle 6i.
Created Oracle Tables, Views, Constrains, Synonyms, Sequences.
Develop XML Reports
Develop and maintain custom applications using PL/SQL packages, procedures and functions. Responsible for creating or customizing Oracle reports, forms and workflows
Troubleshooting problems with the existing Oracle client/server system using the Oracle Development tools including Oracle Reports Developer version 6i and Oracle Forms Developer version 6i.
Payroll Management System Denim, Dyeing & Spinning Unit.
Legacy ERP (In House Developed) Denim and Dyeing Unit.
Develop New Reports and Maintenance of existing reports in Oracle Financial ERP.
Creating User, integrating customized reports, assigning the responsibilities to users, value set,
Manage the Time management system.
Manage WIP operations related to Denim and Dyeing.
Personalization
Customization
Patching at Application level and database level
DFF &Value sets creation
User Training
System Administration
Worked In All Modules (GL, AP, AR, Purchasing, Inventory, Order Management, Gate Pass)
Oracle Alerts
Work Flow approval Hierarchy
Manage the S.R system,
Developed XML Reports
Data Uploading through Interface Tables and APIs and Data Loader
Have a functional knowledge of some oracle modules
.
.