Oracle Management

Ajmalur Rahman

*****.**@*****.***, *****@*************.***

+91-971*******, +91-844*******

Summary Skill :

5+ years of experience in the ERP Implementations & Consulting in Oracle SCM (Distribution) & Manufacturing with Finance.

As an Oracle Techno-Functional Consultant Having 5.8 years of experience (including Global Experience) in the Implementation of 2 full life cycles, 2 rollouts, 2 Support projects of Oracle 11i & R12.

Expertise in Implementations, Roll-Outs and Supporting of Oracle ‘Procure to Pay’ and ‘Order to Cash’ in including Inventory, Purchasing, Account Payable, Account Receivable, General Ledger, Order Management, BOM, WIP, QC, MRP, Cash Management, FA, Costing with India Localization.

Technically proficient in RICE Components (Reports, Interfaces, Conversions, Extensions) and PL/SQL, XML Publisher, RDF Report and PL/SQL, SQL, Report6i, Procedures, Functions, Packages and Triggers etc.

This background allows a wide understanding of Oracle Applications from both perspectives : Functional and Technical.

Professional Experience :

Working as a RST Global Technologies Pvt.Ltd, as a Oracle Apps Functional

Consultant – SCM Module & Manufacturing from January 2016 to till date.

Worked as a JINDUS SPECIALITY CHEMICALS Pvt.Ltd, as a Oracle Apps

Techno - Functional Consultant from August 2013 to December 2015.

Worked as a Oracle Apps Techno Functional Consultant in Assign Infotech

Pvt.Ltd, New Delhi from August 2010 to July 2013.

Technical Skill :

Operating Systems : Window XP2006/NT/95/98/2000, UNIX, MS-DOS

ERP : Oracle Apps 11i, Oracle Apps R12.

SCM Module : Inventory, Purchasing, Order Management.

Manufacturing : BOM & WIP, Advanced Pricing, Quoting and TCA.

Finance Module : AP, AR, PO & GL.

Database : Oracle 10g, 9i, 8i. (SQL, PL/SQL).

GUI : Oracle Forms, Reports, XML Publisher Report

Tools : SQL * Plus, SQL * Loader, TOAD, SQL Developer,

Employment Summary:

Project : Support Project (International Project - DHAKA)

Company : RST Global Technologies

Client : Eastcompeace Smart Card (Bangladesh) Limited.

Module : SCM & Manufacturing– PO, INV, OM, BOM, WIP, AP,AR & GL.

Duration : January 2016 – till date

Designation : Oracle Apps Functional Consultant.

Description : I involved in assessment of Supply Chain Management & Manufacturing Module (Purchasing, Inventory, Account Payable, Order Management, Account Receivable, BOM and WIP).

Roles and responsibilities:

Period Open and Close Processing.

Business process analysis includes understanding the existing business processes and designing the future processes with the standard Oracle functionality

Configuration of Inv, OM, PO, WIP and BOM in Oracle Apps 11i

Involved in Business Requirements Gathering, Process Design, System Operating Procedures, Testing, Training, Implementation, Rollouts and Support

Providing post go live support to organization for the above modules on various critical/non critical issues

Handled various issues with Oracle on a number of Service Requests with all types of priorities

Provided trainings to users on various stages of the projects and wherever a configurationally changes occurs

Involved in various reporting & analysis requirements.

Handle user queries and ensure timely responses

Environment: Oracle Apps R12, INV, PO, OM, AP, AR, BOM & WIP.

Project : New Business Implementation & Support

Company : Jindus Speciality Chemicals Pvt.Ltd.

Module : SCM – GL, INV, PO, AP, AR and OM.

Duration : August 2013 – December 2015.

Designation : Oracle Functional Consultant.

Description : As a Functional Consultant involved in assessment of Supply Chain Management Module (Purchasing, Inventory, Account Payable, Order Management, Account Receivable, BOM and WIP) of Oracle Application R12.

Roles and responsibilities:

Gathering business requirements, Study the As-Is-System and Propose To-Be-

System.

Involved in the Functional design, development and deployment of custom point

solutions to improve existing business processes.

Setup of Inventory, Purchasing, Account Payable, Order Management, Account

Receivable, BOM, WIP, Advanced Pricing, Quoting as per the Client

Requirements and Suggested Business Process Changes.

Involved in resolution of functional issues related to Oracle SCM during

implementation of modules.

Coordinate with Oracle support, Technical Consultant and other Functional

consultants for implementing bug fixes.

Provide Periodic Status Report to Management (weekly, monthly).

Implementation of some inventory management tools like Cycle Counting,

Physical Inventory ABC Analysis, Max-Min Planning.

Defined Value Sets, Descriptive FlexFields, and Custom Profile Options.

Define User and Responsibilities, Set up Custom Menus and Request Sets based on User Responsibilities.

Environment: Oracle Apps R12, Inventory, Purchasing, Account Payable, Order Management, Account Receivable, BOM, WIP, Advanced Pricing, Quoting

Project : Implementation & Support.

Company : Assign Infotech Pvt. Ltd.

Client : JASCOM Pvt Ltd.

Module : SCM - GL, AP, AR, PO.

Duration : Aug 2011 – July 2013.

Designation : Oracle Apps Techno Functional Consultant.

Description : As a Techno Functional Consultant responsible for the Requirement Gathering, Discussion of Solutions with Distribution Managers. Providing Functional Design to the Technical Team for the GAPs Identified in Oracle Application for the Customization of Specific Requirement of Clients.

Roles and responsibilities:

Study of current business processes, future business flows and identification of gaps and

workarounds in order to provide an integrated Procure to Pay business flow to meet the

business needs of the company.

Review functional setups & configuration and take corrective action.

Coordinate with Oracle support, Technical Consultant and other Functional Consultants

for implementing bug fixes.

Create API to import the data from legacy systems into oracle application base tables.

Used Custom PL/SQL API’S for converting open AP Invoices, Suppliers, Supplier Sites, Supplier Contacts, Customers using TCA, Open AR Invoices, Open Purchase Orders from legacy system (Mainframe) to Oracle Applications.

Worked on SQL*Loader Scripts to migrate the invoice data from the flat files and populate the staging tables before implementing auto invoice interface.

Developed PL/SQL procedures, functions and packages for validating the invoice data before importing it into Account Receivables interface tables.

Developed Report like:

Register Report, Re-Insurance Accepted Report, Claim Payment Report, Employee Expense Report, Vendor report, Invoice Voucher Report, Journal Voucher Report which fetch the data on the basis of document number, Purchasing Report, PO Detail Date wise, Sales order report.

Interfaces:

Worked on Invoice Interface to upload the Invoices from flat file to Oracle Apps Base Table.

GL Interface to upload the journal into Oracle apps Base Table.

Worked on Supplier Interface to upload the supplier information from flat file to Oracle Apps Base Table.

Environment: Oracle Applications 11i & R12 - Oracle 9i,10g, Forms6i,10g Reports 6i,10g

PL/SQL, SQL*Loader & Toad.

Company : Assign Infotech Pvt. Ltd.

Client : JASCOM Pvt Ltd.

Project : Implementation & Support.

Module : SCM, GL, AP, AR, PO.

Duration : Aug 2010 – July 2011

Designation : Oracle Apps Techno Functional Consultant.

Description : This project was based on implementation of ERP SCM with Financial modules. During this project, my contribution was gathering user requirements to prepare development, testing and deployment of different applications.

Role & Responsibilities:

Interacted with business owners, functional consultants and subject matter experts effectively to understand business requirements, functional designs, process flow and data flow.

Worked on Purchase Orders conversion. Responsibilities involved configurations, data mapping using SQL*Loader to import legacy Suppliers into Oracle.

Developed Item Interface process to Create and Bulk update Items, Customized various reports such as Inventory Quantity, Summary Report for classification of the material.

Developed custom Interface Program to load on-hand inventory transactions from external flat files into Interface tables.

Created Vendor Audit Report to display vendor information, with incomplete

addresses and contact Information.

Customized Standard Suppliers Form, forced e-mail field to uppercase, made description field required.

Developed PL/SQL Packages, Procedures and Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated the base tables.

Used Auto Invoice Interface to import Standard Invoices into Oracle Receivables using a control file, PL/SQL Packages/Procedures and Auto Invoice Import program.

Customized the AR Invoice, Sales Tax Reports in Receivables using Reports 6i and XML Publisher.

Developed Reports Like:

Work Order Stage Wise Raw Material Stock Status, Date, Stage Work Order Wise Raw Material, Receipt Shortage /Rejection Settlement Status, Comparison Share of Business Vs Actual Order, Re-warehousing Register (Sale), Stock Coverage for DRP with Physical Stock & Open PO, PO Acknowledgement Set Status, Policy Detail, Bond Register (Sale), Item Master Detail, Supplier Detail, Customer Detail, AP Cash Transactions, AR Cash Transactions.

Interfaces:

Worked on Invoice Interface in AP module to upload the data from legacy system to Oracle Applications production table.

Worked on GL Interface to upload Data into GL base table.

Environment: Oracle Apps 11i (INV, PO, AP, AR, GL) PL/SQL, SQL*Loader, Report6i etc.

Educational Qualifications:

MCA (Master of Computer Applications) from IGNOU, New Delhi in ’2007.

ADCA (Advance Diploma in Computer Application) from IGNOU, New Delhi, in 2006.

BCA (Bachelor in Computer Applications) from IGNOU, New Delhi in 2003.

Personnel Details:

Father’s Name : Md. Tafizur Rahman

Marital Status : Married.

Nationality : Indian.

Address : D-8, 2nd Floor, Okhla Vihar,

Jamia Nagar, Okhla

New Delhi -110025.

Passport Details:

Passport Number : M 5213790

Date of Issue : 21.01.2015

Place of Issue : Delhi. (INDIA)

Date of Expiry : 20.01.2025.

Date: 12.06.2016

Place: New Delhi. (Ajmalur Rahman)

Contact this candidate