Oracle financial functional consultant with 8 years of experience

Charu Gupta

Ph: 678-***-****

**********@*****.***

Oracle Financials Functional Consultant with 8 years of experience in set ups, configurations, post implementation

enhancements and support in financial modules like General Ledger, Inventory Management, Order Management, Account

Receivables, Account Payables, Purchasing, Cash Management, Human Resource Management Service.

SUMMARY

• Excellent command over Oracle financial applications implementation, customization, testing, up gradation and support

in multi org/multi currency scenarios.

• Involved in working with users, identifying functional and technical gaps, estimating work to fulfill business requirements,

designing custom solutions, scheduling and reporting requirements.

• Working knowledge in Procure to Pay (P2P) and Order to Cash (O2C) Cycles.

• Expertise in the AIM methodology, RICE and documentation.

• Working knowledge in Order Fulfilment and Shipping execution tasks like order entry, booking, scheduling,

Picking, Releasing, move order, Packing, shipping, invoice generation etc.

• Involved in preparing the documentation setups and maintaining Business Requirement Documents, Setup Documents

(BR100) and other design documents as MD050.

• Adept at all stages of project lifecycle, from business requirements and technical definitions to development, integration,

testing, user acceptance testing (UAT), production support, and completion.

• Expertise in Oracle R12 E business implementation of Inventory, Purchasing, Order Management and Account

Receivables modules.

• Working knowledge of Drop shipment and back to back order work flow.

• Extensively worked on preparing test scenarios, test scripts on different applications to help the users in better

understanding of the applications.

• Trained the end users by giving demonstrations on various process flows in oracle applications

• Ability to meet deadlines and implementing new systems that contribute to the goals of the company

• Strong communication skills in engaging business stakeholders, technical team and users in gathering the intricate

workings of business processes.

• Experienced in managing geographically distributed and culturally diverse work groups.

EDUCATION & CERTIFICATIONS

• MBA in Finance & Marketing

University Business School Panjab University, Chandigarh, India

• B.Sc. In Computer Applications

MCM DAV Panjab University, Chandigarh, India

• Certified Associate of Indian Institute of Bankers Certification

Indian Institute of Banking & Finance, India

• Junior Associate of the Indian Institute of Bankers Certification

Indian Institute of Banking & Finance, India

TECHNICAL SKILLS

E Business Suite Oracle E Business Suite (EBS) R12, 11i

Domains Known GL, AP, AR, CM, HRMS, OM, Purchasing, i Procurement, Inventory, FA

GUI Forms 6i, Reports 6i, IR Reports

Tools Oracle 11/10g, SQL

Languages SQL, PL SQL, C, C++, HTML

Office Suite MS Word, MS Excel, MS Outlook, MS Visio, MS PowerPoint, Lotus Notes

Operating Systems Windows NT/2000/2003/XP/7/8

EXPERIENCE:

Client: SWM International Inc, Alpharetta, GA Oct 2011 Sep 2014

Oracle EBS Functional Consultant

Schweitzer Mauduit International, Inc. manufactures and sells paper and reconstituted tobacco products to the tobacco industry

worldwide. The company operates in three segments: Paper, Reconstituted Tobacco, and Filtration. SWM has become a global

leader of engineered solutions for the tobacco industry worldwide.

Responsibilities

• Involved in the implementation and testing of Oracle financial Applications ver. R12

• Prepared functional designs, test scenarios, BR100 documents.

• Studied current business processes, future business flows and identified gaps in order to provide the integrated

Procure to Pay and Order to cash business flows to meet the business needs of the company.

• Executed Conference Room Pilot (CRP1, CRP2 and CRP3) in accordance with Oracle’s AIM Methodology.

• Configured and implemented all the mandatory and optional set ups for Order Fulfillment. Implementation is pointed to

extract the maximum benefit available in the Order Management module functionality.

• Defined shipping parameters like Release sales order rules, picking rules, pick slip grouping rules, document

set, allocation rules, delivery grouping rules, Container Load sheet details etc

• Worked on setting up Banks, Dunning letter, Auto Lockbox, employee expense templates, grant and roles

definitions, freight carrier and distribution sets.

• Involved in complete set up Oracle Purchasing and Payables that included defining sequential set ups like financial

options, position hierarchy and purchasing options.

• Created Individual set ups like suppliers, buyers, Inventory items, sub inventories, Document types, approval groups,

approval assignments.

• Defined payable options, Payable system set up, Bank & bank Branches, Bank account, Opened and closed periods.

• Creating Item Templates in Oracle Inventory module by modifying the control level options

• Creating the setups for Drop Shipment, Back to Back order, Internal Sales Order and resolving those issues in

Order Management.

• Defined Defaulting rules for sales order header and lines.

• Created Processing constraints on sales orders as per the client’s requirements.

• Provided training and conducted practice and additional business requirements sessions.

• Customized Descriptive Flex fields to capture additional information required by the client.

• Assisted customer with re engineering and improvements in policy and procedures.

• Designed Training manuals and trained the end users.

Environment: Oracle Financials R12, GL, OM, AR, AP, PO, INV, SQL, PL/SQL, Oracle 8i, Windows NT.

Reliance Communications, India Jul 2009 – Sep2011

Oracle Financial Functional Analyst

Reliance Communications is a leading integrated telecommunication company. Its business encompasses a range of telecom

services including broadband, national and international long distance services and data services.

Major Projects

• Involved in implementation and testing of Oracle Financial Applications

• Interacted with client to gather the requirements to design and estimate the project duration.

• Identified the structure of Flex fields, defined Value sets and values for several flex fields in GL and AR module.

• Created mandatory set ups of Order management module like Customer, Customer address, Item, Transaction type,

Order type, Pricing, Sales person and document Sequence

• Created Purchasing Hierarchies, Approval Limits, Approval Assignments for the various positions in Purchasing

application

• Extensively worked on Item Attribute Controls and created different inventory items in Oracle Inventory Applications.

• Tested the new functionality, identified and resolved the issues in Order Management (OM), Inventory (INV) and

Purchasing (PO) modules

• Extensively worked on Price Lists, Modifiers, Qualifiers, and Pricing Attributes in Order management.

• Prepared the setups for Item categories in Inventory, Purchasing, Order Management modules

• Extensively worked on different Inventory transactions and solved the period end issues

• Created various order types with the approval hierarchy in Order Management (OM) module

• Worked extensively on Return Material Authorization (RMA) transactions in Order Management.

• Created FSG reports using row set, column set, content set, and row order.

• Created training documents for creating receipts by defining bank, receipt class, receipt source, and Auto cash rule set.

• Created Automatic receipt using lockbox.

• Created training documents for standard invoice, recurring invoices, holds, credit memos, debit memos, and

expense reports in AP.

• Created responsibilities assigned to users and set profile options.

• Tested the functionality by using various tests scripts.

• Other responsibilities included supporting users, diagnosing and resolving problems, implementing solutions.

GL, AR, AP Upgrade

• Involved in functional support for upgrade from 11.5.9 to 11.5.10 in GL, AR, and AP modules.

• Held meetings with the client/users regarding the business requirements, limitations of existing system and proposed

solutions.

• Prepared BR – 100 for configuring the Oracle Applications according to the business requirements.

• Designed Key Accounting Flexfield structure, Chart of Accounts with Multi Org and Multi Currency setup.

• Defined rollup groups, security rules, journal sources, journal categories and budgets.

• Defined currency translation, conversion, revaluation and set the profile options for GL.

• Configured setups for Consolidation, Multi reporting currency and FSG reports.

• Defined Cross validation rules according to the requirement.

• Created and executed Profit & Loss, Balance sheet reports through FSG reports

• Carried out the Global consolidation.

• Defined currency conversions, currency translation and revaluations in GL.

• Configured the setup for multi currency invoices and payments in AP.

• Configured the setup for raising Batch invoices and Batch payments.

• Provided functional specification document MD 50 on custom programs and Test scripts for various scenarios in GL &

AP.

Environment: Oracle Applications 11.5.10, GL, AP, AR, OM, PO, INV, FA and CM, Forms 6i, Reports 6i, Oracle 9i & Sys Admin.

Client: Hughes Communications India Ltd, India May 2006 – Jun 2009

Oracle Financial Functional Analyst

HCIL is the world's largest provider of broadband satellite networks and services. HCIL is the largest satellite service operator in

India providing a comprehensive range of broadband networking technologies, solutions, and services for businesses and

governments, including Managed Services to meet every communications challenge.

Responsibilities

• Involved in the implementation of Order to Cash in Oracle Applications.

• Interacted with end users to identify and document business requirements.

• Prepared functional designs, test scenarios, BR100 documents.

• Implemented Order Management (OM) and Accounts Receivable (AR) and their integration with INV, CM and

GL modules.

• Wrote functional specification for reporting requirements in OM and AR.

• Performed fit/gap analysis.

• Created Shipping Parameters, Picking Rules, and Release Sequence rules.

• Generated the invoice against the sales order in Account Receivables module

• Generated different versions of sales order using processing constraints.

• Created the appropriate Price List in Order Management Application for various inventory items

• Set up modifiers for price adjustments, freight and special charges, discounts and surcharges

• Created transaction types, invoices, guarantees, deposit, and credit memos and debit memos

• Customized dunning letter, statement cycle in Accounts Receivable module

• Creating customer profile classes, attaching payment terms, collectors, matching receipts, statement cycle to

profile classes.

• Assigned receivable account, revenue account, unbilled account, freight account, clearing account, and unearned

account to transaction types

• Defined the Cash Discounts, which will calculate the discounts for the customers for early payments. Manually

adjusted the discounts for the customers previously and given discounts to all customers

• Developed an auto lock box interface for loading receipt data from various banks

• Transferred Receivable transactions and receipts to General Ledger

• Provided post production support, troubleshooting, resolved issues and stabilized the system

Environment: Oracle Financials 11.5.9, GL, AR, OM, INV, Forms 2.5, 6i, Reports 2.5, 6i, Oracle8.x, 9.x, PL/SQL, SQL, TOAD

AWARDS & RECOGNITION

• Gold medalist (1st Rank) in MBA in Finance & Marketing at the Panjab University, India.

• Awarded “Employee of the month” at Regional office Chandigarh by senior management for meeting and exceeding

the key result areas at Reliance Communications.

• Recognized and recommended by University professors and was offered to do live projects with renowned companies

like Reliance Communications, Pantaloon and IDFC.

REFERENCES: Available on request.

Contact this candidate