Oracle Developer/ ERP System In-charge
AL MUFTAH GROUP
Total years of experience :24 years, 6 Months
Since May 2005 to till date
Designation Oracle Developer/ ERP System In-charge
Systems Oracle 8i, 9i, 10g under HP-Unix 11i (Operating System), IBM-Aix Server.
Responsibility Programming, Designing, ERP Operations, Dept Staff Supervission
• Working on Oracle Finance System (ERP) Under Oracle 10g (Back end) Developer 6i and report 6i (Front end)
• New Development, Modification, ERP Application Maintanance for Modules General Ledger, Accounts Receivable, Accounts Payable, Sales Order Processing, Purchase Order Processing, Point of Sale, Inventory Control System, Job costing, Fixed Asset, HR Management (Payroll Personnel) and Security Module and Time Attendance System, IT Help Desk, Air Lines Travel Accounting (Invoicing, Reciepts, Accounts Recievable, Accounts Payable, General Ledger) related to Travel operations (Al Muftah Tours and Travels)
• Project Development Customer Service Module for Al Muftah Sharp Work shop daily activities like service request, job cards, quotation to customer, material issues to the jobs to repairs, item delivery and invoicing to customer, customer's item repair history
• Project Development Foreign Purchase Module which related to LC Cost Control, Bank Approval, Purchase Request, Purchase Order, Bill of Laanding, SRV Costing and final SRV, Stock Updation and General Ledger Posting.
Mar '97-Apr '2005 Sr.Analyst Programmer
Systems: Powerkey (Power House) Cognos, RPGL, Version 7.3, 8.13, UNIX Operating System Ver 9.0 & Ver 10.1,
Windows 95 & 98, Oracle 8i, Ms-Access under windows
Key Reuslt Areas
• Efficaciously migrating to Oracle 8.0
• Working on HP 9000/L Class Server, With Multi -User (150), Multi Processing for 30 Division of Al Muftah Group
o Financial Accounting System, Accounts Receivable System, Accounts Payable System
o Inventory Accounting System, Personal Accounting System, Purchase Order System
o Point of Sale System, Common Data Base System
• Handling Programming, Designing, ERP Operations and Supervision of Dept. Staff
Highlights
• Worked from Oct '98-Jun '99 as a Team Leader and made Y2K Conversion for the whole conversion of all Group Companies Data & Programs
• Efficiently made all existing Data & Applications and ensured Y2K Compliance
Mar '93-Feb '97: Analyst Progammer / EDP & System In-Charge
Key Reuslt Areas
• Designed In -House Programs in every aspect of Accounting Systems including: o Schedules for P&L and Balance Sheet
o Outstanding / Balances - Ageing, Vendor wise Profitability Report
o Online Customer /Vendor Balances
o Stock Trail Balance and Stock Status Report for Every Month, Brand Wise Stock Report, Category Wise Stock Report, Category Wise Sales report
• Efficiently developed a Point of Sale on line system enco Version encompassing on line invoicing, on line stock relavent reporting programs in Payroll accounting System, essential in day to day requirements of various divisions of rhe company
• Developed a Loan Accounting System for Al Muftah Group, including Employees Loan Details, Loan Ledger, Employees Contribution Ledger, Employees Loan Balance Reports in 4 GL Power Key RPGL on HP 9000/ F30 Series 800, with Unix Operating System Ver 10.1, which has connected from head office with Remote locations of Al Muftah Group
• Headed System Administration, System Problems & Hardware Problems of various division of Al Muftah Group like: o (SAM) System Administration
o Creating, maintaining Users Login, Passwords, Root Passwords, Data Base Administration
o Data Base Creation
• Designed systems on On-line Updation Environment
• Monitored both Hardware & Software of Al Muftah Group
• Administered PC Installations & Maintenance of Al Muftah Group
Aug '90-Feb '93: Computer Operator / Programmer
Environment: Power Key (Power House), Version 5.1, MPE V Operating System
Key Reuslt Areas
• Efficiently worked on HP 3000 with MPE V Operating System with Multi -User & Multi-Processing and Power Key (Power House) RPGL with Al Muftah Group On HP 3000 System
• Successfully developed programs in every aspect of Accounting System encompassing including schedules for:
o Profit & Loss, Balance Sheet, Outstanding Balances, Age/Vendor Wise Online Enquiry Programs
o Accounts Receivable & Payable, Stock Accounting, Personal Accounting System with MPE V Operating System on Power Key (Power House) RPGL Version 5.1.
Commended Career in Mar '87- May '90 with Sree Rayalaseem Alkalies and Allied Chemicals Paper Mills Ltd, Kurnool (Dist.),
Andhra Pradesh, India
Joined as Assistant Programmer & rose to the position of Programmer
Diploma in Oracle 10 Application Developer With SQL PL/SQL, Forms 6i, and Reports 6i
• Bachelor of Commerce and Costing, Advanced Accountancy