محمد عارف

18 Years of experience in software designing development and implementation. As an Apps Technical Consultant (Oracle E-Business Suite R12) my technical activities can be summarized as under:  Configurations & implementations (Technical Side) P2P Cycle of Oracle Application (Purchase, Inventory, iProcurement, iSupplier, Sourcing, Order Management, Enterprise Asset Management (Techno Functional)), Financial, HRMS etc.  Development of new forms and reports (XML / BI Publisher), Integration with other systems by using Web Service (REST & SOAP) technology.  Well experience in AME, Oracle Alerts as well as Oracle workflow builder.  Customization / Personalization & Extension of Oracle Apps modules using OAF & Oracle Developer (TEMPLATE.fmb, CUSTOM.pll) according to client requirements.  Strong grip over SQL, PL SQL and optimization of queries to increase performance.  Implementation of Oracle Standards / Customized packages to meet functional / business requirements.  Historical /daily business data uploading through open interfaces, APIs, WebADI (creation of new WebADI as per client templates), Data Loader, SQL Loader etc.  Active involvement in data gathering and processes study with functional team.  Designed and Implemented e Delivery of Customer Statement of Account, Customer Invoices and Purchase Orders using XML Bursting Concept.  Registration of customized tables, forms and reports with oracle e-Business Suite.  Writing Cursors, Procedures, Functions and Database Triggers.  Well experience to design code pack in shell scripts and move from Test instance to Prod instance.  Good command over Oracle General Ledger, Oracle Inventory, Oracle Purchasing, Oracle EAM, Oracle HRMS and Oracle Payables, iprocurement, Source and iSupplier.  Well experience in E-Business Tax VAT implementation technical sides.  Well experience to design documentation like MD-070, MD-050, MD120.

Designation
ERP - Sr. Technical Consultant
Product
Oracle E-Business Suite R12 (12.2.10)
• Integration of Mawared System (SAP HRMS, Payroll) with Oracle GL & HRMS on behalf of web service data.
• Auto creation of Organization, Sections, Jobs, Grades, Positions, employee creation and termination process through approval workflow.
• Integration of 3rd party invoices with Oracle AP invoices with complex accounting validation and approval through AME process.
• Development of reports for all modules.

Product
Oracle E-Business Suite R12 (12.2.8)
Project: Oracle EAM - Global Timesheet Business Process Automation
Tools: WEBADI, Integrations, Custom Developments
This was a Maintenance Process Automation Project for all the Dubai Petroleum Fields to enhance the outsourced Contractors (Contingent Workers) Time Management through Custom Bulk Uploads,
Complex Validations & Approval Workflows, OAF custom pages, Extension in existing OAF pages, Integrations with HR, Maintenance, Purchase Contract Payments and Finance Applications. Event based Application and Email Alerts were developed.
Developed and Delivered all the project documentations and presentations at all stages of the projects from inception to closure including management approvals and EU trainings. One month daily basis user support to resolve tickets.

Designation
ERP - EAM Techno Functional Consultant
Product
Oracle E-Business Suite R12 (12.2.6)
• Configuration and Daily basis support after implementation in Oracle EAM Module Technical as well as Functional.
• Prepare Configurational data, Master Data like Master Assets, Item Master, Asset Group, Master Activity, OSP Items, Asset Routes, Maintenance Routes, Preventive Maintenance, Departments, Resources with billable Items, Work Permit, Safety Management, Quality (Check Lists integration with Custom Application), Item Category, Sub Inventory, Locator, Parameters, WIP Accounting Classes etc. for New Implementation from R11 to R12.2.6
• Daily basis support in SCM(PO, Inventory, EAM, Sourcing, OM), Financial( GL, AR, AP ).
• Develop a custom form in OAF to view Requisitions detail till payment
• Develop custom/new many reports to fulfill user daily requirements like Work order, Work Request, Daily stock, Resources details, Forecast etc.
• Design WebADI to upload Suppliers, Assets etc.

Product
Oracle E-Business Suite R12 (12.2.4)
•Update/Upload Suppliers/Customers, Locations.
•VAT registration of Suppliers and Customers through API
•Design custom solution for Electricity Tariff Costing and integrate it with Oracle receivables.
•Integration of AP Invoices with Maximo including tax and break up of accounting distributions
•Development of new/existing reports regarding VAT like Input / Output Tax, P2P and O2C cycle
•Technical daily basis support in P2P, O2C especially in VAT implementation.

Product
Oracle E-Business Suite R12 (12.1.3) / 11i (11.5.10.2)
•Configuration of EAM, PO and Inventory setups and provided support of post implementation
•Implement daily payables intelligence and receivables intelligence dashboards
•Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications using the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
•Study of Existing System already implemented.
•Data Loading using API, SQL Loader and Data Loader
•Forms Personalization, Customization and Reports Developments Using Oracle Developer 10g.
•Pl/SQL Cursors, Packages, Procedures and Functions development.
•Development of Supply Chain (Purchase, Inventory, EAM) reports and Forms according to requirements
•Design many reports like asset maintenance, Human resources cost, Machine equipments Cost, Maintenance tracking, Inventory register, daily/monthly issuance, receipts, stock, dead inventory, ABC analysis, Work requests, monthly/annual purchasing, Monthly maintenance far cost etc
•Configure Requisition based Purchase Orders report using developer suite that queries all Open PO's at header, line and shipment levels and shows the quantity of goods received and balance quantity of goods to be received against the shipment line.
Auto Requisition &PO Approval process using position hierarchy and define processes based on the purchasing amount and ship to location.
•Configure setups to implement of P2P Cycle and providing support of post implementation
•Configure Requisition based Purchase Orders report using developer suite that queries all Open PO's at header, line and shipment levels and shows the quantity of goods received and balance quantity of goods to be received against the shipment line.

Product
Oracle E-Business Suite R12

•Manage and translate functional requirements into detailed technical specifications used for developing data conversions, interfaces, and extensions for client applications in an Oracle
E-Business suite R12 environment
•Responsible for the overall design and implementation of Oracle ERP modules like General Ledger, Inventory, AP, AR, FA and Purchasing at technical end
•Active involvement in data gathering and processes study with functional team
•Involved in Financial (GL, AP, AR, CM & FA) Purchasing and Inventory Setups.
•Reports Development using Oracle Reports Developer 10g and developer 6i
•Forms personalization of E-Business Suite R12
•Development of customized forms using Oracle developer suites
•Data Loading using APIs and Interfaces
•Pl/SQL Cursors, Packages, Procedures and Functions development
•Involved in As-is study and TDR preparation

oracle developer in this unit & ithe job responsibility was;
•Design & deploy in-house ERP Inventory ( Requisition, Approval, Comparative statement (Quotation), Purchase Order, Inspection, GRN, Invoices, Issuance, Item Ledger, Costing, Stock Register with average rates) & integrated this module to financial module.
•Financial Module likes(Vouchers, Ledgers, Sales Tax Invoices, Bank & Cash Receipts)
• Sales (Sale Contract, Sale Contract Scheduling, Ship line, Production Order, Production Plan, Delivery / Dispatch against sale contract, Return From Party, Rejection From Party, Party Claim, Auto voucher generated and, PO status, Invoices, Stock Reconciliation and all other Reports) and Purchases against sales contract.
• Payroll System ( Barcode reader attendance, Overtime & Loans calculations, Salary Sheet & Slip, EOBI, Social Security, Bonus, Gratuity, payment on hand punch machine & user Security etc.)