SUMMARY:

• 6+ years of IT experience as an Oracle Apps Finance Functional Consultant in Implementing Oracle Applications11i/R12 and related technologies Including Implementations, Upgrades, Data Conversions, Interfaces, and Customizations.
• Excellent functional expertise in Oracle Applications with Implementation, Testing and Post Production Support of General Ledger(GL)including Advanced Global Intercompany System (AGIS), Accounts Payables(AP), Receivables(AR), Cash Management(CM), Fixed Assets (FA), E Business Tax(Ebiz Tax), Advanced Collections, Project Costing and iExpenses Modules
• Career oriented self - motivated individual, adept in computerized accounting systems and Superuser Oracle R12/11i implementer and configurations subject matter expert
• Experienced in Supply chain, supporting Order Management, Purchasing, Inventory, Service Contracts (OKS), iStore, iProcurement and iReceivables Modules.
• Multiple project life cycles experience with Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering including facilitate Workshops, Scope Verification & Validation, Alternatives Identification and Analysis, Functional Design Development, Integration & User Acceptance Testing, Training, Cut off, Go-live and Post-Implementation Support.
• Detailed expertise in Enterprise Asset Management, Oracle Manufacturing, Order Management, Shipping Execution, Purchasing, Inventory, Engineering, Bills of Material, Work in Process, Cost Management, Fixed Assets and System Administration.
• Excellent configuration experience on Procure to Pay, Order to Cash, and Assets to GL Cycle’s Using Multi-Org.
• Worked in Onsite and Offshore model projects, coordinating and leading offshore team.
• Having Good Knowledge on Oracle Hyperion Management (HFM).
• Strong Knowledge on Vertex, Sabrix and Integrated with Ebiz Tax.
• Worked Extensively on Application Implementation Methodology(AIM), business requirement gathering, understanding As-Is Process, designing solutions (To-Be Process), performing gap analysis, building RICE (Report, Interface, Conversion, Extension),components & setup of modules for CRP testing, end-user Training, UAT, documentation and production support
• Delivered Conference Room Pilot (CRP’s) sessions and helped in troubleshooting user concerns, issues during CRP and UAT
• Worked on Sub-Ledger Accounting(SLA) rules for replacing traditional transaction codes needed for generating multiple accounting representations for a business transaction
• Integrated Approval Management Engine (AME) in Expense Reports.
• Strong Experience in System Administration and Application Object Library (AOL).
• Experienced with extensive hands on with creation and maintain of BP80, MD50,BR30, RD20, TE40, BR100, documents including Functional Impact Analysis
• Experienced in developing and implementing test strategy for functional testing environments (Unit, Integration & UAT) includes providing functional impact analysis as part of Change Management Process
• Excellent communication skills and leadership qualities with analytical problem solving abilities including playing vital role in coordinating multiple business meetings and following up on open item.
• Experience in developing Interface/Conversion Programs for integrating third party applications with Oracle Applications. Very Good Understanding of hierarchical structure of Multi Org and TCA (Trading Community Architecture) concepts.
• Extensive experience in writing PL/SQL Packages, Stored procedures, Triggers and Functions.
• Extensively worked on i-Expense for Integrating Master Cards and loading credit card transactions into Oracle system, which will later be converted as expense reports.
• Designed & developed training material, User Manuals and conduct training to all levels of users

TECHNICAL SKILLS:

ERP APPLICATIONS: Oracle Applications R12 (12.1.3/12.1.1 ) and 11i (11.5.10/11.0.3 ), AR, AP, GL, CE, FA, OM, HRMS, PO, INV, WIP, BOM, ASCP, AOL

RDBMS: Oracle 11g, 10g, 9i/ 8i / 7.x, SQL Server

LANGUAGES/ FRAMEWORKS: C, C++, PL/SQL, Java, HTML, XML, XSLT,UNIX Shell Script, BPEL Bourne Shell Script, OAF, SOA

BUSINESS INTELLIGENCE: XML/BI Publisher, Discoverer Reports, Developer 10g, 6i Reports

TOOLS:: TOAD, SQL Navigator, SQL Developer, SQL* Plus, Visual Source Safe 6.0, SQL*Loader, JDeveloper, Forms Builder, Reports Developer, Workflow Builder 2.6.3, Discoverer.

HARDWARE: AIX, Sun Solaris (SPARC 32-bit), Pentium M

OPERATING SYSTEM : UNIX, LINUX, Windows 95/98/2000/ XP/ NT/Windows 10,Windows 7 and SunOS

PROFESSIONAL EXPERIENCE:

Confidential, Oklahoma

Oracle Financials Analyst

Responsibilities:

• Gathering the Client Requirements and preparing the documents using AIM Methodology.
• Created custom interface to integrate Confidential corporate card ( Confidential ) with iExpenses.
• Involved in integration between the Mark view system and Oracle AP for Non-PO invoices.
• Implemented a Custom AME rules to approve the Non-PO invoice based on RC or Supplier or Supplier site.
• Performed Unit testing, UAT and End-User training for Go-live.
• Streamlining the Advance collections process to support the planning and management of collection strategies and related work items.
• Responsible for setting costing for software royalty as it relates to standard cost updates and review. Special projects as need and Oracle Super-user for Cost manager, General ledger, Purchasing, AP, AR, Order Management and Inventory. Supporting Purchasing, Production, Order Management and the IT with all changes that impact all system financially. Training for personal in finance policies and systems updates. Ongoing Oracle training and review of systems configuration.
• Specialized in Oracle Channel Revenue Management/ Advance pricing (Oracle Trade management, Rebate process (POS) configuration, Buying group setup, Market Territory setup, Approval Rule, Claim Process setup, Volume/Accrual rebates, Retro Volume rebates, Offers (implemented almost all offer types), budget & Deduction Management configuration), Receipt/PO based offers (Inbound), Sales order based offers (Outbound), Third Party Accruals, Supplier Shipand Debit, PriceProtection, Vendor Rebates, Tracing Batch processing, OracleAdvance pricing, Complex Advance pricing setup tuning, and Oracle Order Management.
• Working with OBIEE to perform detailed data analysis to identify appropriate data sources, key facts, and dimensions that support the business requirements. Performed needed tasks to support the standardization of facts and dimensions.
• OM (Oracle Order Management/Pricing, Shipping): Setups for Document Categories, Document Sequences, Parameters, Transaction Types, Quick Codes, Credit Check Rules, Credit Profiles, Payment Terms, Price Lists, Pricing Agreements, Modifiers, Shipping Parameters, Freight Carriers, Shipment Transit Times, Pick Slip Grouping Rules, Release sequence rules, and Successfully created Orders, Attached pricelists, Pick released, Ship confirmed and transferred Order Information into Account Receivables (AR).
• Involved in setting up of Tax Configurator in EB Tax. Defined Tax defaults and Tax rules.
• Part of Suppliers conversion from Smart stream system to Oracle Account Payables.
• Created intercompany Transaction, Consolidation, Elimination entries setups and configuration for use .The use of ADI wizards like Budget wizard, Journal wizard, report wizard simplified work with general ledger.
• Designed and executed several Customizations and Setups in ERP as a part of Revenue Recognitions solution.
• Provided solution for Revenue Recognition requirements by developing extensions.
• Customized revenue Recognition rules by using API’s in Project Accounting.
• Oracle Order Management/Pricing, Shipping (OM) Setups for Document Categories, Document Sequences, Parameters, Transaction Types, Quick Codes, Credit Check Rules, Credit Profiles, Payment Terms, Price Lists, Pricing Agreements, Modifiers, Shipping Parameters, Freight Carriers, Shipment Transit Times, Pick Slip Grouping Rules, Release sequence rules and created Orders, Attached pricelists, Pick released, Ship confirmed and transferred Order Information into Account Receivables (AR).
• Worked on the Revenue Recognition Process in Oracle AR module
• Worked on the Configuration of the AR module including setting up of the Customer Profiles, System Options, Auto cash rule set, Auto Accounting and Revenue -Recognition.
• Conducted workshops for new R12 functionality to enable users to understand the new features in R12 specially related to collections.
• Implement Oracle Inventory, Fixed assests, Cost Management module as well as working hand and hand training key users to become application super users.
• Designing and configuring various custom tax rules in Sabrix solution to meet the tax requirements and other business requirement for accurate tax results.
• Developed Custom reports, Standard Interfaces, Custom Interfaces linked to different modules of Oracle Applications from third party.
• Upgrade and modify the current Revenue Recognition schedule in AR to reflect R12 changes and Future Business needs
• Rel 12 implementation Map and Gap assessment for AR and Trade Management.
• Involved in requirements gathering, Process Re-design, implementation and training of Receivables, Advance Collections, iReceivables and Trade management 11.5.10.3.
• Mapping the Client Requirements with Oracle standard functionality and finding the gaps and delivering the solutions in terms of Customizations, workarounds, and reengineering and form personalization.
• Prepared RD020, BP040, BP080, BR100, MD050 documents for each financial module.
• Configuring the Oracle Accelerators, which can do the setups automatically in client’s targeted instance.
• Preparing TE40 Documents, which can helpful to test the application functions.
• Interacting with Oracle development team regarding issues resolutions.
• Participate in Analysis, Design and Testing of the code and documentation.

Oracle Financials Analyst

Responsibilities:

• Carrying out requirement gathering, requirement analysis, high level and granular level mapping, gap analysis, setups, functional and technical extensions and modifications, unit testing and integration testing
• Designed Key Accounting Flex field structure (COA) for Ledger and configured with Multi Org and Multi Reporting Currency setup.
• Defined the Accounting Rules and Invoicing Rules in oracle AR module to drive deferred revenue as well as upfront revenue
• Provided enterprise asset management process expertise in addition to Oracle R12 functional expertise.
• Prepared Project Plan for iExpenses and AP (p2p Project).
• Prepared GAP analysis and Functional Design documents for iExpenses and Accounts Payables and developed.
• Country specific implementations for iExpenses and Accounts payables
• Conducted Several sessions/demos with different business users like Corporate travel, Services and Finance Group for iExpenses Custom Discoverer Reports Requirements
• Conduct multiple meetings with Business and Technical team at different intervals for various purposes.
• Designed 3rd Party interfaces for GECARS, IBS, DR4 and AGFA Process
• Involved in requirement gathering and authored MD50 documents for the various reports and Interfaces which includes AR Invoice and AP invoice Interface.
• Development and Fixing issues on AGIS, Advanced Collections, Deductions Settlement, Channel Revenue Mgmt.
• Developing OAF Pages.
• Worked on AP/AR Netting, ERS Transactions Setups and related Issues.
• Involved in the analysis and design phases of various iProcurement initiatives.
• Involved in Data Conversions, Developing, customizing reports and interfaces in GL Module i.e. Journals importing from legacy system using SQL Loader.
• Setup iExpenses templates for meals, transportation, hotel, audit rules and project expenditure types.
• Preparation of Unit Test Scripts in GL, AR, AP, FA,PO and iProcurement Module
• Set up AME rules for routing and approval of Expense reports.
• Set up the new GL Accounts and updated the Hyperion Mapping Values in DFF's
• Configured the Sub ledger Accounting (SLA) setups.
• Defined suppliers and supplier sites. Setup bank, bank branches and bank accounts.
• Configured profile options for invoice batches, setup manual holds and reasons.
• Defined various currencies for multi-currency operations and currency translation, conversion, revaluation has been done to meet the requirement. Cross validation rules have been setup for various GL codes. Configured Sub-ledger accounting process to GL.
• Forms personalization on price list, pricing formula and quick sales order screens.
• Payable System options. Participated in setting up of tax users and profile option values in EB Tax
• Configured Purchasing Setups Purchasing Category Flex field, Purchasing Options, Receiving Options.
• Preparation of Set up Document (BR100) in various modules GL,AR, AP, iProcurement and Sub Ledger Accounting.
• Configured the setup for withholding tax on suppliers invoice towards tax deduction at source in AP.
• Reviewed the current reconciliation process in Cash Management and designed business process and system has been configured and tested to meet the Business requirements.
• Supported Procure to pay and FA issues during month end performing additional configurations.
• Provided support on purchasing issues like PO’s stuck in workflows & maintenance of purchasing hierarchies.
• Integrated Cash Management with Payables, Receivable modules for reconciliation. Auto import and reconciliation of bank statement Bank file integration/mapping
• Tested various AP inbound and outbound interfaces during CRP 2 defects remediation. .
• Coordinate with Technical team for timely deliverables of RICE components. Conduct OWC sessions with Oracle Technical Support for all opened and high prioritized issues for its speedy resolution.
• Developed Custom reports, Standard Interfaces, Custom Interfaces linked to different modules of Oracle Applications from third party. cquaintance and exposure to core Oracle Financial modules including General Ledger(GL), Oracle Service contracts, Field service, depot repair, Advance pricing, Trade management, Accounts Receivables(AR), Accounts Payables(AP), Cash Management(CE), Fixed Assets(FA), Purchasing (PO), E-Business Tax(E-B.Tax), i-Expenses(i-Exp), System Administrator(Sys Admin), Sub ledger Accounting (SLA), and end to end cycles including Procure to Pay (P2P), Order to Cash (O2C), Acquire to Retire (A2R) and Record to Report (R2R)
• Prepared Cut- over Plan, Listing down all Pre & Post Go- live tasks. Involved in Post-Production support.
• Mapped asset categories to project tasks and ensured project set up is in line with asset capitalization requirements and fixed accounting, cost collection errors, interface issues.
• Defined all the fixed asset categories and uploaded all the assets by using web ADI
• Defined Aging Reports and setup the statement cycles setup in AR Module
• Identification of master data like Items / Suppliers and setting up the master data in Oracle 11i
• Customized the Invoice Aging and Customer Balance Report in AR
• Involved in post-production troubleshooting exercises, bug fixes, raising TAR's and working with oracle support for escalating issues and finding resolutions

Confidential, CA

Oracle Financials Analyst

Responsibilities:

• Study of the current Business Process and GAP Analysis using AIM documents,
• Preparation of BR100, Common Set-ups doc, Sys Admin Set-ups documents.
• Involved in the iExpense implementation, designing and performing a major modification to the daily inbound interface to handle multiple files on the same day. Also generated scripts to encrypt and archive the inbound data file which consists of confidential information.
• Participate in Analysis, Plan, Design, Create and Testing of the code and documentation.
• Gathered application requirements and provided design recommendations.
• Assist in functional design with respect to custom data models that integrated with Oracle Applications.
• Involved in Sarbanes-Oxley (SOX) compliance testing process by including paper-based evidence, e.g., invoices, delivery receipts, purchase orders, bank statements and expense receipts
• Defined period types, calendars, Distribution sets, Tolerances, bank accounts payables documents, payment terms, approval groups and approval assignments.
• Configure complete GL including Org Structure, Rollup groups, parent child accounts, CVR’s &Value sets.
• Defined Ledgers and Ledger sets, Journal sources and categories.
• Defined Legal Entities and Operating Units for AP configuration. Configured Financial, Payable and Payable System options.
• EBTax: We performed system configuration for multiple tax regimes.
• Worked on rounding customizations of dollar amount in iExpense using OAF. This involves customizing and extending controller CO and entity object EO.
• Process Flow for Oracle Advanced Collections.
• Implementation of Vertex solutions for Oracle Receivables Sales Tax computation
• Running Sales tax Interface Program for Vertex Monthly tax Updates
• Tax Integration testing for Receivables and Cash Management with test scenarios.
• Rectified the errors in the log file and loaded the data into the interface tables using SQL*Loader.
• Worked on the setups of I-Supplier module setting up the Supplier responsibilities, supplier invitation lists, supplier registration process etc.
• Understand configured TCA Geography Hierarchy
• Preparing (BR 100) configuration document for EB TAX
• Setting Party Tax profile options
• Configured Regime to Rate flow for Sales Tax DEV1 instance
• Setting up Tax Jurisdictions and Tax Rates Integrated with Vertex
• Worked on Conversion data file preparation and mapping the same with legacy system.
• Created Payment terms and Payment Process Profiles.
• Participated in setting up of tax users and profile option values in EB Tax.
• Involved in setting up of Tax Configuration in EB Tax. Defined Tax defaults and Tax rules.
• System Administrator skills - user creation, defining responsibilities, profile options and securities.
• Defined roll up groups to provide the customize reports to the top management with drill down features.
• Involved in regression testing and UAT.
• Used sub ledger accounting to override the depreciation and expense accounts generated from asset category as per the business requirements.
• Led data extraction, cleaning, formatting and mapping efforts for conversion of legacy projects and tasks.
• Prepared test cases for unit testing, integration testing and regression testing.
• Set up expense entry delegation list and authorizations.
• Enabled intercompany billing for engineering service provided by the central design office for various OU's
• Configured the setups for prepayments and adjustment to payment to suppliers
• Coordinated and monitored Month End Closing process.
• Generated various reports in GL, AP and SLA.
• Established control over data access with creation of Menus and Responsibilities and by setting up flex field security rules.
• Prepared Functional design documents for iExpenses Reports as per the business requirement.
• Customized the Accounts Payable (AP) Vendor Entry Form as per business requirements.

Financial Analyst/Fixed Asset/Cost Accountant Oracle Superuser

Responsibilities:

• Responsible for month-end closes intercompany US, Swiss and APAC accounts. Warranty analysis and Top Customers reports units and revenues. Travel analysis and account reconciliations. Research issues relating to AR, AP and Mfg. cost issues. Support Ask systems and running reports related to the GL, MFG, OMAR and AP department analysis. Working with AP and Credit department to resolve issue relating to general ledger issues. Month-end close journal entries and reclasses with supporting documentation directing intercompany activities. P & L analysis forecasting and budgeting.
• Ongoing financial analysis on revenues and expenses. Revenue and unit recon for intercompany recon. Training personnel in new process for intercompany, CRA and RMA procedure. Updating pricing table, standard cost and markup % analysis. Working with cost department to correct cost issues that affect intercompany accounts. Analyzing trade account to ensure aging is in balance. Bom creation, inventory ntrol, inventory management, shipping/receiving, warehouse management, customer relations regarding returns and shipments. Revenue and GOGS analysis for management reporting. Revenue recognition issue and reserves analysis. Scraping process, returns procedures, lost and damage analysis.
• Responsible for all intercompany, Colorado, Rocky Mountain, APAC and Switzerland. Special projects as needed. Oracle implementation team lead implementer/configurations for the General Ledger department. (completed Oracle GL, Chart of Account Lead & SME, AR, Credit Management, AP, Purchasing, Fixed Assets, Inventory/Manufacturing modules)

Oracle E-Business Suite Support (R12.1.3)

Oracle Financials Analyst

Responsibilities:

• Supported Post-Implementation phase for all Oracle Financials Modules
• Production support, interfaces maintenance, change management, month end closing
• Worked on Production Support, attending production calls, troubleshooting the application and resolving bugs.
• Resolved the issues related to credit card payment processing, payment authorization, payment capture
• Prepared and modified MD50’s for different reports like Product profitability report, PO received but not invoiced report, etc.
• Handling daily tickets related to various user problems in FA, AP, AR, GL, CE, AGIS, eBTax modules.
• Created the extensive test scripts TE 40 to verify the reports; tested, verified and deployed to production
• Resolved the issues related to automatic refund of credit card charges stuck in the receivable workbench
• Researched and resolved PO number in customer credit card statement for refund transactions
• Resolved the issues related to credit card refund, return, bills only, freight charge return, not invoicable items, credit card authorization, consolidated invoicing, in order management and receivables
• Coordinated with technical team to work on custom reports
• Resolved the issues related to automatic clearance of receipts, aging bucket report, credit snapshot report, customer statement report.
• Responsible for Journal Imports from all other modules like Accounts Payables (AP) and Account Receivables (AR) into General Ledger (GL).
• Involved in supporting Super Users and End users in period end closing
• Worked on development of new FSG reports and customized various standard FSG reports
• Worked with technical team regarding RICE components
• Supported Post-Implementation phase for all Oracle Financials Modules
• Worked with Oracle Support to resolve the critical issues through SR/TAR
• Involved in documentation of Frequent Mistakes and Error made by end-user in application based on issue log register
• Mapped asset categories to project tasks and ensured project set up is in line with asset capitalization requirements and fixed accounting, cost collection errors, interface issues.
• Troubleshot and fixed the invoicing issues and accounting issues and project tax related issues.
• Prepared a design document for development of XML report and XML bursting based on an existing Oracle report for sending the exception report to various bank account owners of the enterprise.
• Co-ordination with various third party vendors during business impacting changes and deployments.
• Attending calls with the Business and Offshore team on daily basis for Requirement clarifications and delivery Issues.
• Identifying risks proactively and proposing solutions to resolve them.
• Modified and updated existing custom forms to adapt to new database schema.
• Conducted training sessions for end users in Cash application, reconciling receipts and resolving reconciliation exceptions and month end closing.
• Worked on the issue where the drill-down from the GL to the FA Sub-Ledger was not available. (Found bug in the Oracle Standard system).
• Modified the BAI2 template for file processing from US bank.
• Documented current state, designed future state to automate treasury functions including cash position, daily investing, cash forecasting, cash general ledger entries and debt facility accruals. Configured the Cash management module for GL
• Accounts Mapping, setting up transaction codes, BAI2 file upload, Customization of out file as per Confidential requirements, automatic transmission and import of bank files.
• Configured banks, bank accounts and documents for different needs like AP processing, treasury accounts.
• Implemented foreign exchange functionality for currency trades and hedging. Interface with vendor project management and technical developers to ensure system capabilities are designed based on user specifications.
• Developed interface programs for import of open invoices, customer information from the legacy system.