marwa abdelsalam

Experienced Senior Oracle Techno Functional Consultant (EBS/FUSION) with over 16 years of a demonstrated history of working experience in the steel & ceramics manufacturing , information technology and services industries. with Excellent reputation for resolving problems, improving customer satisfaction, and driving overall operational improvements. Skilled in Java/C/C++, Oracle Workflow Builder 2.6, Oracle Form10g, Oracle Reports 10g, Oracle Discoverer 10g, 11g, Oracle Framework Personalization & Customization (OAF), Oracle developer 10g: Introduction To SQL Fundamentals 10g, Oracle developer 10g: Program With PL/SQL 10g, Python 2.7/3.6, Oracle BI 11g R1: Build Repositories, Create Analyses& Dashboards, Oracle Approvals Management (AME), Excellent problem-solving abilities, Fast Learner, Excellent diagnostic skills Self-motivated.Strong information technology professional with a Bachelor Degree Focused in Computer engineering in Top 5 % of Class from the Arab Academy From Science and Technology and Diploma focused in Mini MBA from The American University in Cairo.

• O2C implementation project at Savola
 My Role is to Lead the Implementation cycle, to include Requirements Gathering & Analysis, System Design & Development, Testing, and Implementation
• Segregation of duties (SOD) - RBAC security model implementation Projects at Tamer Group
 My Role is to Lead the Implementation cycle, to include Requirements Gathering & Analysis, System Design & Development, Testing, and Implementation
• Product information - POC implementation Project at Tamer Group - Health Care
 My Role is to Lead the Implementation cycle, to include Requirements Gathering & Analysis, System Design & Development, Testing, and Implementation.
• Supply chain operation enhancements Project at Tamer Group - Health Care
 My Role is to Develop Item Creation ADI Automation Process.
• Sales Enhancements B2B business flow at Novartis
 My Role is to Develop B2B integrated business flow reports.
• ASCP Enhancements Project at Tamer Group - Health Care
 My role is to Develop WebADI template form for user to upload Item forecast in ASCP application.
• Sales Enhancements Project at Tamer Group - Health Care
 My Role is to Develop BSA integrated business flow reports.

• Offered pricing and feature recommendations to management and cross-functional teams
• Provided observations, took measurements and performed tests at various stages according to quality control plan
• Assisted with proactive client outreach initiatives through gathering requirements and documented client correspondence in Oracle Supply chain application system
• Maintained regular contact with clients and identified opportunities to deliver added value to client relationships
• Collaborated with team to define business requirements for organizational processes, achieve productivity standards and adhere to accuracy standards

• Facilitate and actively participate in all phases of the Implementation cycle, to include Requirements Gathering & Analysis, System Design & Development, Testing, and Implementation
• Assist Business Users in mapping and streamlining / re engineering business practices to implement various Oracle modules, using standardized implementation methodology including reports specification development and deployment.
- Assist, coach, and mentor other engagement team members on issues that may encounter in the design and implementation of solutions
• Consults offshore and/or onsite with internal/external clients on business requirements in order to provide support.
- Acts as senior analyst Oracle ERP and related corporate SCM systems architecture data
• Supports multiple projects/tasks within assigned area of Oracle ERP / MRP portfolio and related business applications
• Provides integrated systems planning and recommends new or different solutions which will enhance current systems and support overall corporate and business goals
• Drives business process re engineering and related lean concepts through Oracle ERP / MRP and related information systems best practice deployment
• Provides in-depth technical consultation to Business Unit and project supervision to ensure development of efficient application systems utilizing established standards, procedures, and methodologies
• As a Senior Oracle Apps Functional Consultant was involved in R12 Financial, Accounts Payable, Accounts Receivables, Credit Management, Cash Management, Oracle i Receivable, E-Business Tax EBT and Vertex Integration gap analysis, configurations, translating business requirements into functional/technical design and preparing test plans and test scripts:
• Solution design and preparing As Is and To Be process flows for client's business in Oracle environment and interacted with the users for AS-IS business and TO-BE process and documented the same for validation and approval from the client
• Gathered business requirements for various modules of the system, the Business requirement mapping with the Oracle Applications and preparing the Business Process BP80 and Business Requirements BRD documents
• Worked in Day-to-day activities of the Project and providing quality and quick support to the client
• Excellent knowledge in Oracle Business Flows Procure to Pay, Back to Back and Procure to Reporting, Order To Cash .., and integration with General Ledger
• Preparing the functional specifications for oracle customization and conducting the CRP to demonstrate solution proof in oracle applications modules
• Test all the RICE components, prepared the TE40 documents and Migrations process to CRP, TEST UAT and Production
• Complete the corresponding setups in oracle applications and prepared the AIM documents like, CV40, MD50 and BR100 Documents
• Test customized functions, programs under simulated environment and created user manual for the entire customized environment provided support to users during Go-Live by way of problem solving and instructions
• Worked with design, testing and maintenance of oracle Purchasing, Sales and Logistics processes
• Test Standard Solution as well as custom objects and conversion of legacy data into oracle and coordination with offshore and onsite team for post-production support
• Conducted training sessions for user group, Was responsible for sending out weekly status report to management
Environment: Oracle R12 12.1.3, AP, OM, PO, INV, CM, AR, i Expenses and RICE Objects.

KEY PROFESSIONAL SKILLS, PARTICIPATIONS AND ACHIEVEMENTS:
• Participated in the R12.1.3 Oracle OPM Manufacturing & Advance supply chain
planning (ASCP) implementation Project:
 Tested, Analyzed and repaired the setups for the Release 12 Oracle E-Business
Suite for Inventory and OPM Manufacturing integration setup.
 Participated in Advising on the best use of Oracle for OPM Manufacturing
processes.
 Analyzed data issues and resolved problems.
 Developed & Performed Data conversion and Upload through Interfaces/API.
Conversions like Items, Item Categories, Formula, Operation, Routing, Receipe
…etc. Error resolution.
 Hands-on involvement in business requirement, GAP analysis, process
mapping, solution design, configuration, setups, work around, interfaces, user
training.
• The Performed Performance Anlaysis solutions gave A 90%+ Performance and
40 + efficiency increase for Concurrent Program:
 Analysed and addressed top Five duration Periodically Submitted
Concurrent Programs.
 Investigated and Addressed the Root Cause issue.
 Provided Standard Solution Root cause Fix Solution .

KEY PROFESSIONAL SKILLS, PARTICIPATIONS AND ACHIEVEMENTS:
• Implementation of Discrete EAM Periodic Average Cost and Setup Alone in one month
of DRI Plant EAM Organization.
• Designed and Developed Solutions using Cost Management Client Extension Solutions
to automatically distribute and calculates Periodic Acquisition Adjustment.
• Designed Developed Solutions using Cost Management Client Extension Solutions to
automatically Remap PAC Distribution Account No. for EAM inventory Transactions
Based on Material Category to meet business Requirements.
• Implementation of R12 Oracle Application of Discrete Periodic Average Cost
Management Module Project.
• Migration from R11i to R12 Oracle Application of Oracle Process Manufacturing
Financial Cost Management Module For Rebar and Rolling Mills Companies •
Migration from R11i to R12 Oracle Application of Oracle Purchasing Module.
• The Developed solutions under Inventory, Purchasing, Account Payable,
Enterprise Asset Management, Sub ledger Accounting and Cost Management
integration phases that gave A 50%+ efficiency increase for cost accounting
operations:
 Designed and Developed of Workaround solution for Inventory Transaction
Driving Account using Transaction Reason, Account Alias and Item GL
Categories to Overcoming Identified serious account and item cost setup issues,
such as sharing system accounts caused from no support for SLA for Periodic
Average Costing Challenge.
 Designed and Developed of Workaround solution for automated
Distributing/proportioned of Recorded Purchase Order FOB charges on Match
Material Receipts that exist in same invoice.
 Designed and Developed of Workaround solution for automated
Distributing/proportioned of Recorded Purchase Order FOB charges on Match
Material Receipts that exist in same invoice to overcome system Automation
Shortage.
 Elimination of manual G/L journal allocations with incorporating these
Distributing/proportioned of Acquisitions Invoice charges on Match Material
Receipts based on Amount Basis costs by Design and Development of
Workaround solution for automated.
 Designed, Participated on Testing and Development of Workaround solution
for automated Distributing/proportioned of Acquisitions Invoice charges taken
Place in current Period on Match Material Receipts that occurred in previous
Closed Periods which Eliminate of manual G/L journal allocations with
incorporating these.
 Designed and Developed of Workaround solution for automated Inventory
valuation Account Validation of generated Journal entry using Sub inventory
and Item Category.
 Control Cost Variances by Participating in addressing, Instructed, elicited and
lead of development of solution that Control Buyer from Changing for Purchase
order Line which had been received.
 Designed and Developed of Workaround solution for Consolidated Accrual
Reconciliation for Discrete Periodic Average Accrual entries and OPM Cost
Management to Overcome System challenges.
 Designed and Development of Workaround solution for Controlling User
Defined Miscellaneous Inventory Transaction Types using Material Status and
Transaction Mode Plan overcoming Inaccurate Financial information due being
misusage Purpose.
 Designed and Development of Workaround solution for Charge User Defined
Miscellaneous Inventory Transaction with associated unit Cost using
Developed custom Request which Eliminate of manual G/L journal allocations
with incorporating these costs.
 Developed of A series of Reports for efficient discovery and resolution for all
major transactional month-end interfaces, for supply chain, costing and finance.
 Lead and Designed the Development of Recommended improvements for the
Payables invoice processes, changes which should reduce 50% or more of the
A/P Accrual process issues.

MTL_SYSTEM_ITEMS_INTERFACE and then populating the base tables by running
the ITEM IMPORT Interface.
• Designed and developed custom EAM Material Requisition APPROVAL WORKFLOW
to meet the application’s user creation and maintenance according to business
requirement.
• Submitted Service Request with Oracle Support in different Scenarios, for providing
Solutions to the Bugs identified during Production support resolved various bugs,
working in collaboration with Oracle Support.
• Experience in customizing oracle workflows such as the Work Request approval process,
to send user notifications based on the business requirement.
• Interacted with users, fixed the bugs, developed test plans and provides daily production
support.
• Performed User and Administration responsibilities in Discoverer. Experienced in
Customizing Oracle Forms with Forms Personalization using Custom.pll Functionality.
• Good Knowledge in customizing existing OAF Screens, forms and reports as per
business needs using OAF Substitutions.
• Expertise on designing and implementing Oracle Alerts and Lookups.
• Developed new Concurrent Programs, Custom Forms, Reports and Flex Field
Customizations.
• Experience in Procure to Pay (P2P) life cycles business flows.
• Developed various Custom reports, Customized existing reports (PO Purchase Order and
Releases Detail Report, Purchase Requisition Status Report) according to the functional
specifications using Reports 10g
• Created Workbooks based on the custom Folders with parameters, cascading parameters,
conditions, calculations using Discoverer Plus and Discoverer Desktop.
• Involved Developing fully Customized workaround that enable users to related material
invoices with overhead invoices with different in currency.