Samer Mohamed Adel El-Noshokaty

Mob : *** - 010********

E-Mail: ac3g1a@r.postjobfree.com

My experience: 12 years in .Oracle Technical Development and E-Business Suite Techno-functional consultant.

Executive Summary

Ensuring that internal Business Departments are provided with high quality Application support, enabling the high utilization for systems with the highest efficiency,

-Developing and register custom forms (10G) integrated with standard APIs to EBS

-Developing Concurrent programs (In process & analytical reports) using Reports Builder & XML publisher (reports - bursting reports).

-Developing Concurrent programs using custom PL/SQL packages for running oracle standard APIs & Interface tables.

-EBS forms personalization.

-Designing the functional specification and technical design documents.

-Developing workflow approval processes integrated with standard APIs to EBS using oracle workflow builder.

-Responsible for Oracle E-Business Suite modules(Monitoring,troubleshooting & reporting):

Purchasing (PO Approvals, invoice matching level, AP Accrual,receiving ALERTS)

Inventory process Org -PMAC- Costing & discreet Org AVG-PWAC- Costing SLA setup & Invoicing and COGS accounts)

Order Management (pricelist setup,pick release,shipping confirm,& auto invoicing to AR).

GL analyze and drilldown to sub ledger for monthly closing (Trial balance, Balance Sheet,Cost Center Expenses, Income Statement).

AP analyzing & reporting (AP Accrual & Banks) balances.

AR analyzing & reporting (customer aging due dates& banks) balances.

ALERTS creating the necessary (action & schedule)alerts for hole the biasness cycles and developing a scheduled bursting reports.

OPM Financial

For process inventory organization, I'm responsible to monthly running the following

(COGS Processes, GMF closing period for PMAC Costing process organizations, actual cost process, cost update, OPM extraction pre-processor, Create accounting)

HR

Responsible of creating New organizations and cost center accounting, New Jobs, & Positions.

Developed a customized recruitment system(Forms 10G & Alerts) with custom approvals hierarchy and integrate it with EBS Employees and assignments using EBS standard API

Developed a very smart customized PL/SQL package (Concurrent program) transferring the payroll to GL using EBS standard API

Developed an attendance (attendance form (forms 10g) & customized PL/SQL package) system and integrate it to the people element entries using EBS standard API.

Serving all company Oracle working sites Supply Chain, Sales, Finance, &HR techno functionally.

Experience:

Oracle Applications Supervisor Dec-2011: Dec-2013

Oracle Applications Manager Jan-2014: Present

Modern Bakeries (Rich bake) – Egypt

Technical (Forms, Reports,& APIs development)

As we are retail business, we have a daily too much transactions, So I've developed APIs for :

**OM

Daily uploading a high number of Sales orders.

**INV

Daily uploading a high number of Inv Miscellaneous transactions

Daily uploading a high number of Inv Move orders

**PO

Daily uploading a high number of POs & Receiving

**AR

Daily uploading and apply a high number of receipts for height number of AR transactions

Built a custom Recruitment flow system using EBS template.fmb form

-Prepare business analysis document, functional specifications,& technical design.

-Deploy the custom system into the application

-Register the necessary custom tables to the application

-Preparing the attachment folder to the custom screens.

-Integrate the applicant system with EBS event alerts.

-Create custom concurrent request which is using API to upload the applicant to HR module as a new employee when final acceptance decision take place

Perform integration & Data handling between new developed applications & Oracle EBS, and this is by creating custom packages which is using the suitable interface tables and APIs.

Design, Develop, train & support new applications integrated with Oracle E-Business suite, consists of new forms (screens) to allow user to work faster using simple data entry forms to increase productivity & complete transactions of Sales accounting & Inventory users

Setup the necessary accounts & Develop an API to transfer payroll result to GL journals.

Develop new Oracle (analytical & in process) reports for users to help users in daily operational data review & monthly closing for all working modules (including Financial, Supply chain & Sales & Admin department reports ) .. (Report builder and BI publisher).

Responsible for support calls/Service Requests handling with Oracle Company. representatives - Contacting Oracle Company Support team in case of troubleshooting.

Implement and develop Custom self service using workflow builder from scratch.

Generating / Keeping records for Application support calls & troubleshooting History.

Grant and maintain user access rights across the applications as per approved authorization forms & per business needs.

Functional Tasks

Implement & setup Oracle concerned modules with its core parameters & personalization needed for business analyses & workflow.

Install & test needed sub-modules for each function of Oracle modules.

Perform support for modules users as of System functions to work properly & to fulfill business cycles.

Support GL, AP, AR, & FA functional processes.

Customize all necessary (in-process & analytical) reports (using 6i run time reports & 10g reports with bi publisher).

Monthly support in closing periods from procure to pay & order to cash cycles to trial balance, income statement, & balance sheet in GL.

Customize the necessary drill down reports from GL to sub ledgers.

Suggest & implement new features that will enhance business cycle on Oracle & plan / Implement / Test …until going life with these features.

Coordinate with Business end users to perform monthly closing for both company Sites including Closing tasks & results review.

Perform Functional closing tasks with coordination with end users such as Create accounting requests & running cost of goods accounting (COGS) with finance.

Perform Diagnostics with users in case of Closing results mismatch until solved.

Manage Open & Close periods for modules (PO, INV, OM….etc).

Perform functional Training for Oracle users on system functions & new features.

Grant and maintain user access rights across the applications as per approved authorization forms & per business needs.

E-Business Suite Techno-Function consultant– Feb-2011: Dec -2011 Rumouz –Cairo-Egypt

Rumouz – Egypt

Modern Bakeries (Rich bake & Faisal) project Feb-2011: Aug-2011

Techno-Function Consultant

Responsibilities:

Implement and setup the purchasing and inventory modules

Setup the OPM financial and SLA accounting method for the process manufacturing organization

Setup costing management SLA accounting for the discrete organizations

Did the necessary migration using oracle EBS standard APIs for

-Inventory module (items, categories, Opening balances, sub inventories .. etc)

-Order management (Sales Orders)

Built the necessary reports for All the above mentioned modules using report builder & XML publisher

In Order management Module, I built a package for creating automatic sales order & pick releases for daily huge number of sales orders.

I did the necessary personalization for All the above mentioned modules

Create procedures and functions required for personalization & migration.

Senior Application Implementer –Apr-2008: Feb-2011 Giza Systems –Cairo-Egypt

Giza Systems – Egypt

Egypt Water Holding Company (HCWW) - billing system Mar- 2009: Feb-2011

Senior application implementer on billing system customized on ERP (Baises2)

Responsibilities:

reporting, customization, personalization,& translation

oWrite the functional specification and technical design documents

Giza Systems – Egypt

Qatar CPGA project Apr- 2008: Feb- 2009

Techno-Function Consultant

Responsibilities:

Implement and setup INV & PUR

Support GL,AP,& AR functional processes

Building Reports 6i Using report builder & XML publisher (INV, PUR, SSHR, OTA, AP, GL)

Analyze the budget rules, and do the suitable setup in GL

Implement and setup Learning management and self service.

Configure approval processes using work flow builder & AME

Create packages to migrate the old system data to the application using the suitable API’s and Interface tables.

Oracle Developer- Mar-2005: Mar-2008 Zamil Steel Buildings –Cairo-Egypt

Zamil Steel Buildings – Egypt

13-Mar-2005: 30-Mar-2008

Oracle developer

Responsibilities:

In-house (tailored systems) - Oracle 2000

Oracle Developer (SQL/PLSQL, forms, reports, XML publisher)

Migrated the Applications (HR, order management & manufacturing) from 2000 (client, server) to 10g (three tiers).

Oracle applications E-Business suite

System Administrator (E-business suite Key User, Multi-Org inv.)

Inventory

-Analyze the business processes & prepare the requirements documentation.

-Setup the basic configuration data (operating units, inventory organizations, Stock locators key flex field, unit of measures,System Items key flex field, Item categories, .. etc .)

-Do the necessary customizations & personalization for business process solution

-Create packages to migrate the old system data to the application using the suitable API’s and Interface tables (for uploading Items, opening balances transactions ... etc.).

-Develop the necessary( in-process & analytical) reports using the report builder & XML publisher

-Monitor, support, &trouble shooting the functional processes

Purchasing

-Analyze procure to pay cycle & prepare the requirements documentation.

-Setup of the Approval Hierarchy For both (PO & PR) Documents

-Do the necessary configurations for the Receiving Options, Purchasing Options & Financial Options

-Do the necessary customizations & personalization for business process solution

-Monitor, support, &trouble shooting the functional processes

Financial (GL,AP,AR,AR,FA) (setup, configure,&Support functional process )

Skills Area:

Computer Functional Skills:

Oracle E-Business suite Inventory,& Purchasing

Oracle E-Business suite Financial.

Oracle E-Business suite HRMS (Self service, & Learning management) Modules.

Oracle E-Business suite Order Management techno-function.

Oracle E-Business suite OPM financial module.

Computer Technical Skills:

Oracle forms / Reports.

Oracle SQL/ PLSQL.

Discoverer, XML Publisher.

Oracle Business intelligence Beginning)

Language Skills:

• Arabic: Mother Tongue

• English: Fluent

Education:

2002 –B.Sc. in Computer Engineering

Faculty of Engineering – Suez Canal University

Personal Information

-Nationality : Egyptian

-Marital status: Married

-Date of Birth : 21/05/1980

-Religion : Muslim

Training Courses and Professional Certification:

- Oracle developer in AUC

- SQL/PLSQL

- Oracle Forms builder

- Oracle Reports builder

- Oracle Financials course in EMAK academy

- General Ledger

- Payables

- Receivables

- Fixed Assets

- Cash Management

- Knowledge Academy

- PMP - Project Management Professional - PMI (Attended)

- CSCP - Certified Supply Chain Professional - APICS (Attended)

Contact this candidate