SUMMARY:

• Overall Nine years of development experience on Business Applications, Client/Server Architecture and GUI and Web - based systems.
• Extensive experience in Oracle Apps R12, Oracle11i.
• Worked in Oracle technologies SQL, PL/SQL, Reports 10g both development and support.
• Experience in working with Oracle Utilities like SQL*Loader, Package and Interfaces.
• Having experience in Implementation, Migration, Customization, Production and Support of Oracle Receivables (AR), Oracle Payables (AP), Oracle General Ledger(GL), Order Management/Order Entry (OM/OE), Oracle Inventory (INV), Oracle Purchasing (PO), Application Object Library (AOL), System Administration modules of Oracle Applications.
• Development and Customization of Reports, Interfaces, Conversions as per client requirements
• Knowledge in Procure to Pay & Order to Cash life cycles.
• Worked on Oracle tools like XML Publisher Report.
• Experience in customization and development of generating reports and registering them as concurrent program in oracle applications using AOL.
• Experience in Application System Administration activities like managing concurrent managers, application user setup, defining responsibilities, value sets, flex fields, registering menus, forms, reports and concurrent programs
• Presently working in a leading Real estate company.

TECHNICAL SKILLS:

Operating system: Windows 98/2000/XP/7

Languages: SQL, PL/SQL

ERP: Oracle Applications R12, Oracle9i, PL/SQL, Reports6i and Reports 10g.

Tools: Toad10.5,sql tool, SQL*Plus, SQL* Loader

Theoretical Concept: Net Working, Information technology, LAN, WAN, UNIXOperation Research.

PROFESSIONAL EXPERIENCE:

Oracle Apps Support

Confidential

Environment: ERP

Responsibilities:

• Responsible for the application support and development
• Modules AP, AR, GL,CM, FA,PO,PROPERTY MANAGER
• Develop XML template through xml publisher and registering on Apps.
• FSG Reports
• Developing reports in 10g and registering on Apps as per user requirement.
• Customization of Reports
• Data uploading through SQL Loader and web ADI.
• Giving functional support to User
• Reports migration server to server through Fndload scripts
• Make document functional and technical(MD50,MD60,MD70)
• Develop Reports and troubleshoot in customize module Property Manager.this module Provide complete solution for Real Estate Company.
• Form personalization.

Oracle Apps Support

Confidential

Environment: ERP

Responsibilities:

• Responsible for the application support
• Modules AP, AR, GL,CM, FA,PO,OM
• Develop XML template through xml publisher and registering on Apps.
• FSG Reports
• Open/close period.
• GL Journal entry and posting journals.
• Developing reports in 10g and registering on Apps as per user requirement.
• Customization of Reports
• Data uploading through SQL Loader and web ADI.
• Giving functional support to User
• Asset Category define in FA

Technical Associate

Confidential

Environment: ERP

Responsibilities:

• Responsible for the application support
• Modules AP, AR, GL,CM, PO,INV,OM
• FSG Report and open/close period in GL Journal entry and posting journals.
• Developing reports in 10g and registering on Apps as per user requirement.
• Develop XML template trough xml publisher and registering on Apps.
• Item Creations.
• PO creations.
• Interfaces.

Confidential

Environment: ERP

Responsibilities:

• Responsible for the application support, functionality and data integrity of the Oracle Financial Application. Accountable for functional decisions. Serve as the primary connection between functional area and IT Technical.it relates to application support, processing and data integrity.
• Coordinate functional decisions to ensure that the Financial Application meets the business needs and is consistent with business processes.
• Coordinate testing of new and revised processes, reports, modifications and enhancements prior to implementation into the production database.
• Managed projects as AP, AR, GL, CM and FA conducted meetings with all levels of management to provide status reports.
• FSG Report and open/close period in GL. Journal entry and posting journals.
• Experience in testing of AP, AR, GL and CM setup projects and also setup of new bank account. Assign locations and user responsibility etc in Oracle Application.
• Developing reports in 10g and registering on Apps as per user requirement.
• Develop XML template trough xml publisher and registering on Apps.
• Setups of AP, AR, GL, CM and FA module.
• Defining Invoice Attributes - Payment Terms, Distribution Sets, Pay Groups.
• Defining Payable Options.
• Defining Suppliers & Site Information.
• Defining Payment Attributes - Bank Accounts, Payment Formats & Payable Documents Creation of Payment Batch Templates to default the payment process.
• Special Calendar for Recurring Invoices, Withholding Taxes and Payment Terms
• Setting up Banks and Defining Bank Account (Internal & Supplier)
• Creation of Invoice, Payment and Payment Batch.
• Defining Recurring Invoices and Expense Report Templates, Tax Groups and Withholding Tax Groups.
• Defining Currency rates for facilitation of Foreign Currency Transactions.
• Creation of Receipt Method, Receipt Classes and receivable activities.
• Creation of Transaction types like Debit memo, Credit memo and Bill Invoice.
• Closing periods in AR.
• Customer Entry.
• Service Tax Processing and Reports
• Customizing the delivered reports as per user requirement
• Preparation of materials and write-ups for end users.
• Define Accounting Flex field Structure, Define Security Rules, Assign Security Rules Setup, Define Cross-Validation Rules.
• Define Set of Books: Define Accounting Calendar, Define Currencies, Setting up Chart of accounts.
• Defining Multi Reporting Currency, Consolidation, Mass Allocation, Translation, and Revaluation, Cross organizational reporting.
• Preparation of Documentation relating to modules.
• Setting Up Oracle Payables For Oracle cash Mgmt Integration
• Setting Up Oracle Receivables For Oracle cash Mgmt Integration
• Creation of Banks and Bank accounts.
• Transferring of bank accounts as per instructions given.
• Fund Transfers as per instructions.
• Developing of reports and registering in Apps as per user requirement.
• Customizing the delivered reports as per user requirement.
• Preparation of materials and write-ups for end users.
• Bank Statement Upload & Reconciliation
• Define Calendars( Fiscal & Prorate)
• Define Book Controls & System Controls
• Define Flex Fields
• Assets Additions
• Define Reclassification & Revaluation
• Mass Transactions
• Define Depreciation Rules (Book)
• Define Depreciation Method