Amjad Ali

Sr. Oracle APPS Developer at Descon Chemicals Limited

• Pakistan - Lahore
• January 2009 to August 2014

Descon Chemicals Limited, Descon Oxychem Limited
Descon Power Solution Limited, Nimir Resins Limited
Descon Corporation (Pvt.) Limited, Gray Mackenzie Engineering Services
Inspectest (Pvt) Limited, Gray Mackenzie Engineering Services W.L.L
Inspectest Industrial Solutions Descon Technical Institute
Sr. Oracle Developer (Jan 2009 - To date)
Responsibilities:
Campus Management System
o Design and develop Campus Management System for Descon's Technical Institute. System was designed to store student profiles, course, fee and re-funds, class scheduling, Hostel Management, Store items issuance to students.

Document Attachment System for EBS and Customized modules
o Design and develop Document Attachment System for Oracle EBS modules (AP, AR and GL) and Customized modules.User may attach all type of documents with invoices and vouchers. System may be accessed through ERP or via link as customized system.

Data Warehouse and Business Intelligence
o Design and develop Data Warehouse for Oracle Accounts Payable, using Oracle Warehouse builder.
o Create and manage Oracle BIEE repository using Oracle BI Repository Administration
o Create OBIEE requests and dashboards in OBIEE Answers and Dashboard

EBS Reports (GL, AP, AR, OPM, PO, OM)
o Development of Customized Reports through Oracle Report Builder comprising Transactional, Management and Decision Support Reports for Oracle EBS modules
o Rewrite SQL queries for existing reports in EBS to boost performance.
o Adopt professional techniques to improve response time.
o Create Layout templates for XML reports.

Budget Forecast System
o Analyze, design and develop Annual budget forecast system
o Design and Implement security matrix
o Integration with Oracle GL to load budget data from Budget Forecast System.

Payroll & Provident Fund
o Analyze, design and develop Payroll and Provident Fund Management System for Descon Chemicals Business Area (DCBA) and integrate salary voucher with EBS GL module.
o Implement VPD technology to enhance security for salary values. Only authorized employees can view salary values.
o Design and Implement security matrix
o Integration with Oracle GL to upload Payroll vouchers into GL interface table

Material Requirement Planning and Production Scheduling
o Analyze, design and develop interfaces to enter Sales forecast.
o Generate production plan
o Calculate material requirement on basis of sale forecast.
o Integration with Oracle PO to generate purchase orders on basis of material requirement.
o Design and Implement security matrix

Attendance and Leaves Management system
o Analyze, design and develop Online Leave Application System, in which user can apply leaves, approvers can view and approve leaves online. Email alert are forwarded on each step completed.
o Manage Bio Metric Attendance machines and their connectivity with oracle database.
o Mapping of attendance and leave management system with Payroll System
o Design and Implement security matrix

Human Resource Management System
o Analyze and design HR Management System
o Mapping of employee's data with payroll & provident, attendance & leave system.
o Design and Implement security matrix

Gate pass Management System
o Perform performance tuning tasks, develop new reports and update existing reports.

Freight Management System
o Analyze and design Freight Management System,
o Provide guide line to juniors to develop software according to standard
o Design and Implement security matrix