ORACLE SKILLS

In GL Modules:
Creation of Chart of Accounts
Define Segments
Mapping of Segments with Flex field Qualifier
Enabling the Currency
Define Period & Period Types
Define Calendar
Define Set of Books
Attach Set of Book to the Responsibility trough Profile Option
Creation of Batch
Creation of Journal
Posting Of Journal

In AP Module:
Define Suppliers (including Location, Sites, Bank details, and payment terms)
Creation of Invoice Batches
Defining Invoice Types
Define Invoice Distribution Type
Define Payment Format
Define Payment Methods
Define and Post Journals

In Self Service Web Applications (I-Expense/ I-Procurement):
Creating the Punchout Architecture and the setup for Specific Suppliers
Monitoring the Expense Claim and Requisition Workflow Related Issues
Employee Setup required for accessing the SSWA and assigning the security attributes.
Monitoring/ Troubleshooting the major Interface related to the Expense conversion to Invoice (Expense Report Import)

________________________________________

WORKING EXPERIENCE

ASTROL INFO TECHNOLOGIES
As Oracle Application System Analyst (Financials)
(April 08 till date)

PROJECT DETAILS

Client : Marks & Spencer --Marks & Spencer (M&S) is a major British retailer, with over 885 stores in more than 40 territories around the world, over 600 domestic and 285 international. [1][2] It is the largest clothing retailer in the United Kingdom, as well as being a food retailer, and as of 2008, the 43rd largest retailer in the world. [3] Most of its domestic stores sell both clothing and food, and since the turn of the century it has started expanding into other ranges such as homewares, furniture and technology.

Implemented Oracle Applications 11. 5. 10. 2 (AP, I-Procurement, I-Expense & GL)
(May 09 till date)
Role Performed: Subject Matter Expert
Understanding and troubleshooting the problems involved with the customers design, providing the customer with the technical know-how and design support to the existing Application (Oracle Apps 11. 5. 10. 2) in their product.
Providing technical training to new hires on Application Processes.

Responsibilities
Defined New Expense Template
Provided Client/ End User with Audit Data
Ensure the resolution of queries, Incidents, and bugs within agreed time frame.
Analysis of new change requirements and effort estimation.
Ensure client satisfaction by giving support during odd hours & holidays.
Maintain all the quality parameters and documents, also involve in quality audits.
Client : Next Departmental Store, U. K.
implemented on Oracle Applications 11. 5. 10. 2 (AR, AP, GL)
(from May 08 to April 09)

Major Activities:
OUC Flex field 3-4 character change
Minifeed Program which involved designing Functional Document for custom Interfaces and Reports. Worked closely with the Technical resource to roll out the Inteface. (3rd Party Expense Entry)
Transfer Program using Expense report interface
Auto approval Process used in I-Exp and I-Proc
Payment Process
AR to GL and AP to GL interface
Journal Import and Posting
Accrual Processing (involves Workflow)
Investigation in CLIENTS ACCOOUNT and in GL and pass adjustment entries according to the reasons in Clients Acc and in GL through Service Plateform
ON DEMAND-To know which branch has processed it
Pass GL to GL reversal through People soft

Responsibilities
Solved critical Issues related to Expense Report Import. These issues were having high management visibility since they were critical was the Period Close.
Was instrumental in resolving the Mission Critical I-Procurement Punch-out Issue in which when trying to raise a Non-Standard Requisition through a Punch-out catalogue was Erroring out.

KEY PROJECTS UNDERTAKEN

Project Title: Procurement and Letter of Credit
Name of the Organization: IBN7 (Part of Network 18 Group).
Duration: 45 Days
Project Description: The main objective of this project was to study the functioning of the Accounts Department