Oracle Apps Technical Specialist
Saudi Railway Company
مجموع سنوات الخبرة :17 years, 9 أشهر
• Provided technical support for SCM, Finance, and HCM.
• Created event alerts and periodic alerts on Purchase Order and Requisitions.
• Form personalization.
• SIT and EIT creation.
• Element entry creation and updating by using API.
• Creating EIT by using API
• Employee data migration (Assignment, Position, Job, Organization) by using API.
• Develop new reports in XML-publisher for SCM, Finance and HCM.
• Integration of time machine with Oracle HCM module.
• Created value sets. Scheduling of concurrent programs.
• Collected info and analyzed, designed and tested different Standard report.
• Created New XML Reports in OM, INV, AR, PO modules
• Performed the testing of the custom developments.
• Created functional specifications for a number of customizations (Reports & form Personalization’s) required by the business.
• Provided support for Oracle Purchasing, Inventory
• Developed & tested along with technical team custom reports like PO printing.
• Implemented the asset tracking process using Oracle Purchasing & Inventory Modules.
• Provided support for Inventory & OM modules. Supported various functions like creation of new order types, Sales Person Credit setup, New Inventory Organization setups etc.
• My responsibilities include taking ownership of the projects.
• Involved in presales of Oracle life Sciences.
• Created event alerts and periodic alerts on Purchase Order and Requisitions
• Created New XML Reports in OM, INV, AR, OPM modules
• Customized standard reports into XML Reports.
• Clearing records which was struck in the interfaces by back end coding
• Defining Request group, Functions, Menus
• Defining Request sets and scheduling the request set from both front-end and backend coding
• Personalization of Standard forms
• Defining DFF
• Defining Value sets
• Defining new user and adding responsibilities to that user
• Defining transaction types
• Creating new items, sales man, customers.
• Defining new price list and adding this price list to respective customers
• Training End user in complete order to Cash cycles
Integration of van sales application with Oracle ERP
Client : Al-MUHAIDIB FOODS, Dammam, Saudi Arabia
Modules: AR, OM, INV
Role : Technical Consultant
Language : PL/SQL
Database : Oracle 9i.
Tools : Developer 2000 6I, Oracle Applications 11i.
OS : Unix
Description:
This project consists of handling day to day van sales information. In this project I am down loading the entire master data say item, customers, salesman, pricing, salesman load, and pending invoices from oracle ERP and providing it to SQL server data base on daily bases. From SQL server data will be move to hand handle computers (HHC). All the transactions which are made by sales man on field with HHC that transaction will be uploaded to ERP back at the day end. Transactions which are uploading daily are order information, invoice information, inventory information, collections. This information is uploaded by using interface and API’s.
MTS (Mirnah Technology Systems) is a leading provider of Technology Services in the Mobile Computing Industry. Since its establishment in 1992 in Riyadh, Saudi Arabia, the company has quickly become a leader in implementing Sales Force Automation systems (Route Accounting or Van Sales) in the Kingdom of Saudi Arabia and the Gulf area. Over 14 years experience in sales force automation largest team of software developers in mobile Computing over 5, 000 users (van salesman) in the middle-east
Responsibilities:
• Demonstration on integration, gap analysis and making design document MD50.
• Created the concurrent executables and concurrent programs for interfaces.
• Scheduling concurrent program from back end coding.
• Created DFF column, LOV, Value sets.
• Developing Reports, Customization of Reports and Developing Interfaces.
• Preparing the MD70 Documents after completion of the component
Interfaces:
• Developed Interface to upload inventory Transactions, invoice and receipts and order info
Customization & Support for Implementation partner.
Organization: Royal Group of Companies, Abu Dhabi, UAE
Modules: AR, PO
Role : Technical Consultant
Language : PL/SQL
Database : Oracle 9i.
Tools : Developer 2000 6I, Oracle Applications 11i.
OS : Unix
Description:
In this project I was involved in customization of standard forms and report.
And giving support for implementation partner.
Royal Group is a conglomerate of 30 medium to large companies and currently they are on the way of implementing Oracle E−Business suite. Infosys is the implementation partner.
Responsibilities:
• Developed purchase order report with logos of company on that report
• Data uploading by writing interface
• Developed customer master form for end users.
Financial Management System Implementation for Andrew son.
Client : Andrew son’s U.S.A
Modules: AP, PO, INV
Role : Technical Consultant
Language : PL/SQL
Database : Oracle 8i.
Tools : Developer 2000 6I, Oracle Applications 11i.
OS : Unix
Responsibilities:
• Developing Reports, Customization of Reports and Developing Interfaces.
• Preparing the MD70 Documents after completion of the component.
Reports:
• Developed RFQ Supplier Report.
• Developed Blanket Purchase Order - Release Report.
• Developed PO and AP Analysis Report.
• Customization of cancelled Purchase Order Report.
Interfaces:
• Developed Outbound Interface to upload Material Transactions information to Legacy system by using the UTL_FILE Package.
• Payables Open Interface: Facilitates integration of legacy system with the Oracle payable to upload invoice information into oracle application system.
Project : ERP Implementation
Client : Sanghi Industries Private limited, India
Modules: AR, PO, INV
Role : Technical consultant
Language : pl/sql.
Database : Oracle 8i, .
Tools : Developer2000 6i, Oracle Applications 11i.
Operating System : Windows 2000, UNIX.
Responsibilities:
• Created the concurrent executables and concurrent programs for interfaces and custom reports.
• Developing Reports, Customization of Reports and Developing Interfaces.
Reports:
• Developed Requisition Report.
• Customization of Purchase Order Report.
• Customization of Cancelled Requisition Report.
• Developed Inventory Volume Report.
• Developed Invoice - Payment detail Report.
Interfaces:
• Developed Purchase order Interface to upload the STANDARD Purchase order transactions into the Oracle apps Base tables.
• Payables Open Interface: Oracle payable to upload invoice information into oracle application system.