SUMMARY

• Having 9 years of IT & Functional Experience as an Oracle Applications Financial Consultant including Implementation & Production Support of Oracle Financials & SCM with Versions R12 & 11i Applications.
• Functional Experience in Configuration and regulatory testing with products like Accounts Payables, Payments, Accounts Receivables, Fixed Assets, General Ledger, Cash Management, SLAM, Purchasing, E - BusinessTax, Inventory, Workflow, General Ledger, iExpenses, Web ADI, iReceivables, iPayments, Order Management & System Administrator.
• Experienced on Implementations, Supporting & Maintaince Projects.
• Worked on Documentation, As-is BP-040, To-Be BP080, Setups BR-100, Gap Analysis MD050.
• Experienced on Preparing User documentation For Financials modules.
• Defined MIS and Ad-hoc reports using the FSG Functionality in General Ledger.
• Excellent knowledge on configuring applications by gathering business requirements from client and providing solutions at runtime thereby enhancing my Client facing skills.
• Process full range of accounting and administration skills including AP, AR, GL Analysis and Fixed assets accounting and Reconciliation, Book close Reconciliation.
• Experience on Procure to Pay, Order to Cash, and Assets to GL Cycle’s Using Multi-Org Business model.
• Experienced on SQL PLUS, Toad, Conversions, interfaces, Data migration, customization.
• Experienced on preparing test cases TE020, 030, 040.
• Knowledge on Accounting Concepts GAAP, IRFS,SOX well versed with Sections 302,404 Etc.
• Mentored Accounting professionals by providing End User Trainings, and motivation.
• In addition to Functional experience, expertise spans functional analysis and support for operations executives.
• Experienced on Localizations for Spain, Europe Countries.
• Knowledge on SYSADMIN in Oracle applications with mapping application user setup’s,defining responsibilitities,valuesets,Flexfeilds,Registeringmenus,forms,concurrent programs, Request Groups, Providing support to end-users for any functional issues.
• Created and maintained documentation as part of production handbook using AIM.
• Conducted in CRP & UAT testing.
• Worked extensively with development team members in resolving issues by Creating TAR(s) and obtaining one-off solutions using METALINK.

TECHNICAL SKILLS

Oracle Apps: GL,AP,AR,FA,CM,PO,PA,INV, Hyperion, OM,SLAM,EBusinessTax,OBIEE,DBI

ERP: Oracle Apps, JD Edwards & PeopleSoft.

Self-Service: iExpenses, iAssets, iReceivables, Oracle reports & Forms (D2k), Workflow, ADI

Tools: Toad, SQLdeveloper, Discoverer, XML,SQL*Loader, EDI

Languages: Oracle 8i/9i/10g, SQL, PLSQL, Interfaces, OAF, XML, Java, UNIX shell scripting.

PROFESSIONAL EXPERIENCE

Confidential

Senior Business System Analyst

Responsibilities:

• Currently working on FA Period Close Automation for all regions.
• Worked on Customizing Global Web ADI and Global Post Mass Additions for fixed Assets module.
• Worked on Global Post Mass Additions customization for Fixed Assets.
• Customized MAC Auto Journal creation process for incorrectly categorized Assets in Fixed Assets.
• Designed Solution for Confidential CIP Assets Capitalization using OA Framework.
• Working on FA Reconciliation Process with General Ledger with respective of Asset and General Ledger Reconciliation Reports.
• Working as a liaison between developers and clients to enable product development with a close fit to client’s requirements.
• Working on Mass additions, Mass transactions, depreciation methods and Mass copy and Periodic Mass copy functionalities.
• Map Client business requirements to oracle functionality and identify gaps and setup application in the Test, Development and Production environment.
• Conducting in orientation training, CRP, UAT and Rollouts strategies for implementations

Environment: (Oracle Apps 11.5.10.2): AP, AR, GL, CE, PO, INV, OM, FA, Alerts, HFM and Markview170

Confidential, Santa Clara California

Oracle Business system Analyst

Responsibilities:

• Full cycle implementation involving meet with senior management to develop and agree project methodology and plan for project implementation approach.
• Evaluation of organization structure, reporting needs, business need to plan the chart of accounts as well as defining them.
• Analyzed and mapped the business requirements analysis into Oracle FA module.
• Mapped the future process requirements into Oracle fixed assets module and identified the Gaps and analyzed the gaps and offered solutions.
• Define the COA, Ledgers (Sob’s) and Journal Types like Mass allocation & Recurring Journals.
• Grouped assets associated with specific project, department, and location to track the CIP assets in the Organization.
• Defined Oracle assets for Mass additions.
• Experienced on ADI, Report Manager, Web ADI, Hyperion,Markview-170, SQL PLUS, Work Flow, OAF & Toad.
• Experienced on Functional setups, Support Trouble shootings & configured the Workflow.
• Involved in knowledge transition from the project to the production support team.
• Involved in pointing out the probable issues coming out of the proposed solutions in the project.
• Interacting with the users in training the new solutions & applications some new functions.
• Maintained Issue Log and tracked all the issues to resolutions.
• Handled Period Close, Accounting Issues arising in the Support.
• Responsible for Smooth Reconciliation between AP, AR, & CM
• Prepared test scripts and carried out system and integration testing including conversion of legacy data.
• Carried out the end user training and provided the post production support.

Environment: (Oracle Apps 11.5.10): INV, OM, PO, AP, AR, FA, GL, Lease Management, iExpenses,iReceivables & Mark view-170,Web ADI.

Confidential

Oracle Applications Solutions Specialist

Responsibilities:

• Studied the Existing business process of client.
• Performed on-site requirement analysis and developed functional specifications for the modules.
• Prepared the various documents required under the AIM methodology.
• Done documentation RD-050, BR-100 & MD-050 Using Spain localization.
• Conducted business process review and gap analysis to determine business requirements.
• Configured the AR System Options, Profile classes, Dunning and Statement letters, Remit to address and Defining the Customer Bill and ship sites.
• Defined the Transactions & Receivables types, Source for Imported and Manual Transactions types.
• Worked on the Transactions Imported Process from Other Sources Of Applications.
• Defined the Invoicing & Accounting rules for revenue recognition.
• Scheduled the Revenue Recognition & Document sequencing.
• Transferred transactions from sub ledgers to General Ledger.
• Tested Customized programs under simulated environment.
• Worked on the API’s and Stored procedures & Test cases TE020, 030, 040.
• Tested the functionality of financial flows.
• Worked on the Customer Profile classes, Customers & Journal Import Process for Sub ledger Transactions.
• Experienced on Web ADI, Hyperion, SQL PLUS, Work Flow & Toad.
• Experienced on Functional setups, Support Trouble shootings & configured the Workflow.
• Participated in user acceptance testing.
• Created user-manuals for programs and user procedures Using UPK.
• Customized the XML templates according to the report requirements.
• Data migrations from legacy to Applications (Interfacing) like Suppliers, Items & Customers data Using Data Loaders & Sql* Loaders.

Environment: (R12.0.5):GL,PO,AP,CE,AR,INV,OM,HRMS,E-BusinessTax,SLAM,Hyperion,Costing,iExpenses,BOM, WIP, iReceivables,Work flow, Web ADI.

Confidential

Oracle Financial Consultant

Responsibilities:

• Full cycle implementation involving meet with senior management to develop and agree project methodology and plan for project implementation approach.
• Evaluation of organization structure, reporting needs, business need to plan the chart of accounts as well as defining them.
• Analyzed and mapped the business requirements analysis into Oracle FA module.
• Mapped the future process requirements into Oracle fixed assets module and identified the Gaps and analyzed the gaps and offered solutions.
• Define the COA, Ledgers (Sob’s) and Journal Types like Mass allocation & Recurring Journals.
• Grouped assets associated with specific project, department, and location to track the CIP assets in the Organization.
• Defined Oracle assets for Mass additions.
• Experienced on ADI, Hyperion, SQL PLUS, Work Flow, OAF & Toad.
• Experienced on Functional setups, Support Trouble shootings & configured the Workflow.
• Involved in knowledge transition from the project to the production support team.
• Involved in pointing out the probable issues coming out of the proposed solutions in the project.
• Interacting with the users in training the new solutions & applications some new functions.
• Maintained Issue Log and tracked all the issues to resolutions.
• Handled Period Close, Accounting Issues arising in the Support.
• Responsible for Smooth Reconciliation between AP, AR, & CM
• Prepared test scripts and carried out system and integration testing including conversion of legacy data.
• Carried out the end user training and provided the post production support.

Environment: (Oracle Apps R12.0.l): INV, OM, PO, AP, AR, FA, GL, Lease Management, iExpenses,iReceivables & Web ADI.

Confidential

Accounts Analyst

Responsibilities:

• Preparing the Business Documents.
• Issuing the Credit notes to the Customers.
• Preparing the Daily outstanding Reports for Increasing the Collections Effectiveness.
• Sending the Dunning Letters, Statements to customers
• Responsible for Banking activities.
• Preparation of Monthly Commission statement.
• Sending the Daily Business Reports to Head-Office.
• Worked on the financial statements.
• Reconciliation of System Stock with Physical Stock.

Environment: BSAP Birla Sales Accounting Package .