We provide IT Staff Augmentation Services!

Oracle Apps Functional Analyst Resume

SUMMARY

  • 8 years of experience in Oracle ERP and Finance Functional consultant and Worked at clients of numerous sizes primarily around Financials solutions.
  • Accomplished 4 Full life cycle implementation of Oracle Applications Releases 11i & R12.
  • Possess strong Functional Expertise with the blend of effective communication, excellent interpersonal and negotiation skills.
  • Experience in Oracle E Business Modules - AR, AP, GL, Sub Ledger Accounting, e-Business Tax, Project Accounting (Costing, Billing), Project Resource Management, O2C, Cash Management, Fixed Assets, I-Expense modules and HCM Cloud.
  • Expertise in Order Management, Accounts Receivables, Cash Management, Accounts Payable, General Ledger, I-Expense, Shipping, Inventory, Purchasing modules.
  • Extensive experience in the Functional aspects of Oracle Applications 11i, release 12.0.3 and 12.1.1,12.2.2.6.
  • Hands on Experience in supporting Oracle RMB applications.
  • Having knowledge on PLSQL and java for handling the development activities.
  • Very well conversant with all the aspects of Application Object Library (AOL), and Data Model of Oracle Applications.
  • Expert in creation of Concurrent programs, creation of Executable, Registration of Forms and reports, creation of Users, Responsibilities, functions, value sets, request sets, request groups and lookups in Oracle Applications.
  • Worked across different modules of the Supply Chain Management suite including Oracle Purchasing, Oracle Inventory, Oracle Receivables, WMS, Oracle Order Management, and Oracle Shipping.
  • Strong understanding of different methodologies (Agile, Waterfall and Iterative), finance and risk models, operation (six sigma, supply chain services), marketing and engineering.
  • Developed SQL Program to load data from Excel files, flat files into temporary table using UTL FILE utilities and SQL loader.
  • Experience in implementing Procure to Pay (P2P cycle).
  • Common data model setup involving Oracle P2P/ Order to cash/ GL.
  • Creating various auditing procedures for Procure to Pay.
  • Hands-on experience with PO, EDI and Supplier scheduling.
  • Good working knowledge on modules OM/INV/WMS
  • Carried out module configuration, solution design, process analysis and implementation of Oracle financials general ledger, I Expense and P2P.
  • Extensive experience with Order to Cash and Procure to Pay Business flows.
  • Good working knowledge in Oracle AIM Methodology. Handled Service Requests (TARs) with Oracle.
  • Knowledge on Oracle Accelerator and Oracle R12.
  • Expertise in Implementation where am involved in Module selection, Requirement gathering, Gap Analysis, Solution Design, Building, Testing, User Training and Production.
  • Proficient in Creating User Requirement Specification, Functional Requirement Specification and Business Process Flows.
  • Extensive experience with EDI Standards and e-Commerce Gateway.
  • Good knowledge in developing and writing Test Plans, Test Cases and Test Scripts using manual testing tool HP Quality Center to perform User Acceptance Testing (UAT)In Upgrade projects, handled Discovery, Mapping, Testing and Transition.
  • Enhancement and Support, which involved giving Production support by interacting with user for, trouble tickets and establishing the process to be followed.
  • Extensive experience in conducting training sessions for users to give them knowledge about how the system is going to work.
  • Experience working on SQL*Loader, SQL* Plus, Oracle Import/Export utilities and SQL* Navigator.
  • Good documentation skills and Proficiency in MS Visio
  • Good organization skills & Ability to interact at all levels in an IT organization to assess, evaluate, recommend different and robust solution and lead through the development.
  • Well-proven track in achieving the timeline for deliverables.
  • Highly motivated with excellent interpersonal and communication skills.

TECHNICAL SKILLS

Oracle E-Business Suite: Financials and Supply Chain Management (SCM) Applications - 11i, Release 12.0 And Release 12.1,12.2.6, Oracle Fusion Financials.

Database: Oracle 8i/9i/10g

Operating Systems: Windows (95, 98, NT, 2000, ME, XP), UNIX

Tools: SQL plus, TOAD

Programming Languages: C, VHDL, My SQL

Scripting Languages: Perl, UNIX Shell script.

Tools: QXDM, RSD Lite, Xilinx, Model SIM, Source Insight, Clear case, Cadence, AutoCAD.

Defect Tracking: Bugzilla.

Web Technology: HTML, XML.

Platform: Windows XP, NT, 2000, Vista, Unix, Red Hat, Fedora Core, Ubuntu, MAC, Cygwin.

PROFESSIONAL EXPERIENCE

Confidential

Oracle Apps Functional Analyst

Responsibilities:

  • Requirements gathering from end users, Requirement analysis.
  • Worked on the entire Financials business process.
  • Functioned as an Oracle EBS business analyst for application support of finance.
  • Developed dashboard pages like AR balance, Oracle reports, payment Due, invoice details and all AR transactions in receivable transactions.
  • Developed inbound and outbound interfaces to Oracle financials.
  • Participated in production support and resolved problems that occurred during this phase.
  • As part of the production support team - worked on handling the helpdesk tickets.
  • Having knowledge to able to analyze and resolve tickets related to ORMB module.
  • Coordinated with offshore team and provided regular status updates to project manager.
  • Monitoring critical issue progress to avoid SLA violations and customer escalations.
  • Worked in finance modules (AP, FAH, RMB Modules).
  • Have experience on Oracle cloud financials and conversions, validating configurations and support.
  • Provided support in closing AP, AR, FA, GL periods during month end.
  • Month end and year end reconciliation for closure of subsidiary module.
  • Implemented Oracle Functional modules in public sector. analyzed and resolved tickets related to Oracle Finance Module (GL, AP, AR, FA, AGIS)
  • Having knowledge on SQL and PL/SQL.
  • Have worked and have experience on Oracle Application forms.
  • Supported development and PROD Support activities for basic queries on transactions
  • Coordinated with offshore colleagues and provide regular status updated to project manager.
  • Analyzing and resolving daily tickets related to Oracle Revenue Management & billing (ORMB) module
  • Experience in supporting Oracle Application Financial modules.
  • Good Oral & written communication skills
  • Prioritizing and managing multiple issues within the project while maintaining deliverable timelines.
  • Defined payment terms and implemented a solution to apply holds on multiple entities.
  • Coordinating between various teams involved in the total support cycle.

Confidential

Oracle Apps Functional Consultant

Responsibilities:

  • Requirements gathering from end users, Requirement analysis.
  • Worked on the entire Financials business process.
  • Having experience in Oracle Fusion Cloud Implementation, HCM Data Loader, Spreadsheet Loader, HCM Extract.
  • Performed all the setups required Project Costing, Project Billing, Project Foundation, Project Resource Management, AP, AR, GL modules.
  • Worked on the HCM master data conversions - Jobs, Departments, Grades, and locations.
  • Convert persons, assignments and salary using HDL in multiple iterations to ensure the right data is converted into fusion HCM.
  • Functioned as an Oracle EBS business analyst for application support of finance & HCM modules.
  • As part of the production support team - worked on handling the helpdesk tickets.
  • Completed 2 full life cycles Oracle EBS financials implementation and with financials upgrades with Oracle Revenue management & billing (ORMB).
  • Have worked on Oracle Application forms
  • Created forms that enable users to update just a single row in a table or multiple rows at once
  • Having Knowledge in Cloud Fusion.
  • Having experience in Oracle cloud financials and conversions, validating configurations and support.
  • Having knowledge to able to analyze and resolve tickets related to ORMB module.
  • Coordinated with offshore team and provided regular status updates to project manager.
  • Monitoring critical issue progress to avoid SLA violations and customer escalations.
  • Tracking recurring issues and provide permanent fixes.
  • Worked in finance modules (AP, FA, PA and iProcurement)
  • Implemented Oracle Functional modules in public sector.
  • Responsible for understanding the Functional Specifications and prepared the Technical Documents (MD070), Installation (MD120) and Test Case (TE20) as per Oracle AIM.
  • Streamlined PO & invoice migration processes.
  • Developed several enhancements to the Business Processes on the Financials side.
  • Sub Ledger Accounting: Define the events, sources, and account derivation rules in Sub Ledger Accounting.
  • Hand-on experience in configuration of modules in P2P.
  • Involved in solution designing and development of the Oracle e business suite application (General ledger, P2P)
  • Worked on the setups of Project Foundation module - including the setting up of resource definitions, role definitions, project and organization security, project and task definition, organization forecasting, utilization, etc.
  • Worked on Project Contracts, Project Costing, Project Billing and Project Resource Management setups
  • Worked on the data conversion of Project Costing, Project Billing and Project Management data
  • Worked on the Auto Invoice setups for Accounts Receivables
  • Worked in the Auto Lock Box setups in AR for Wachovia Bank and Bank of America
  • Developed the Revenue Recognition process in AR for Deferred Revenue and Regular Revenue for Product and service.
  • Worked on I-Expense configuration - setting up the expense report templates, expense reporting rules for approvals, defining the per diem policies, policies for various expense categories. Etc.
  • Designed the Cash Management Bank Reconciliation Process.
  • Designed the Bank Statement Upload for Cash Management Process.
  • Supervised and helped business users in UAT (User Acceptance Test) testing.
  • Support Production issues on a day to day basis including month end closure p1 issues
  • Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex Field Segments / Values, Security Rules, Cross Validation Rules, Categories, Document Sequence Assignment, Profile Options.
  • Preparing the BR030, BR100, To-Be Document.
  • Prepared MD050 functional design document.
  • Performed Framework Personalization setups.

Confidential

Oracle Financials and Project Functional Consultant

Responsibilities:

  • As a Functional Consultant implemented the following modules Oracle Receivables, Oracle Payables, Project Costing, Project Billing, Project Resource Management, General Ledger
  • Worked on the Functional mapping of data Conversions & Enhancements for AR, AP and GL Modules.
  • Develop outbound integration using HCM Extract, to send payroll data to third party vendors.
  • Project Costing and Billing - Worked on setting up expenditure types, transaction controls, cost types, calculating costs, distributing labor costs, burdening, funding contract projects, revenue-based cost accrual, quick agreements, function security.
  • Generate mapping file for HCM Business objects process to generate GUIDs
  • Create various employment reports in OBIEE and BI Publisher.
  • Oracle Project Conversions - Worked on the data mapping, deriving of the business rules, formulating theCV40, data validation pre and post data conversions, etc.
  • Worked on the Functional Mappings for data conversion from 11i to Release 12 for Project Costing, Project Billing, Project Resource Management modules.
  • Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
  • Configured Oracle Receivables, Project Costing, Project Billing, Oracle Payables, Fixed Assets, i-Expense, Cash Management, General Ledger modules from scratch and simultaneously created BR100 documentation for the setups.
  • Worked with business users in deciding and designing new Inventory Org. from new acquisitions.
  • Worked on the Revenue Recognition Process in AR Module, setting up Deferred Revenue Rules, Service Revenue Rules, Etc.
  • Worked on Invoice Conversion during new company acquisition.
  • Coordinated CRP and UAT testing with business users.
  • Conducted user training for acquired company's employees.

Confidential

Financials techno-Functional Consultant

Responsibilities:

  • Study AS-IS Business Process
  • Analyze the expansion Requirements and strategize the migration of customizations.
  • Identification of GAPs & proposal of Solution.
  • Preparing of all the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.
  • Understand Division-specific business processes from the end users and implement the same.
  • Worked on Project Accounting (Costing, Billing) module setups
  • Worked on the Mass Addition process in Oracle Fixed Assets.
  • Worked on the Depreciation process in Oracle Fixed Assets
  • Worked on all the configurations of Oracle Fixed Assets.
  • Worked on the setups and configurations for GL, Service Contracts, Install Base, AP, AR, i-Expense, Procurement Contracts, Cash Management, Fixed Assets, Sub Ledger accounting, e-Business Tax modules.
  • Worked on the AP Setups of the Payment Manager, Payment Process Profiles, ACH process, Payment Methods, Bank Interfaces, etc.
  • Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Hungary in the Payment Manager in AP module.
  • Worked on the Procurement Contracts module - defining the contracts workbench, contract repository, contract templates, standard clauses, importing clauses form external sources, approvers and approval workflows, etc.
  • Worked with business users on planning and executing data conversion activities like Item, AR Invoices, AR Cash Receipts, AP Payments, AP Invoices, GL Balances, GL Journals.
  • Resolved the Conference Room Pilot (CRP), System Integration Testing (SIT) and User Acceptance Testing(UAT) issues in distribution track.
  • Business Process analysis includes understanding the existing business process (AS-IS) and designing the future process (TO-BE) with the standard Oracle functionality for manufacturing track
  • Documented and analyzed businesses processes and develop detailed user requirements and functional specification documents. Provide inputs and part of the team for new solution. Test various business scenarios in the new system.
  • Interact directly with end users, infrastructure teams, and project teams. Functional design of the Conversion / Integration programs. Progress the track thro CRP1, CRP2, UAT & Go Alive.
  • Responsible for training the end users on the new processes and facilitated on-the-job training.
  • Environment: Oracle Applications Release 12.1.1 Upgrade from Release R 12.1.1/11.5.10.2

Confidential

Financials Functional Consultant

Responsibilities:

  • As a Financials Functional Consultant implemented financial modules: AR, AP, GL, FA and Cash Management Release 11.5.10.2
  • Performed all the Configurations and Setups for AR, AP, GL, FA and Cash Management Modules
  • Designed customer products summary report in install base using OBIA
  • As part of the installation team installed OBIA BI Apps.
  • Installation and configuration of OBIA/ODI 11G and 12C.
  • Preparing BR30, BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications from BAAN & D1.
  • Created New FSG Reports, using multi-currency features including foreign currencies for multi org structures.
  • Worked on a customization for Deferred Revenue is AR using Revenue Recognition process.
  • Implemented internal control features using Form Personalization's for modules GL, AP, and AR.
  • Configured Auto Invoice in AR to import data from the non-Oracle ERP instance in Japan.
  • Implemented TCA - for AR customer master conversions.
  • Implemented the Data Quality Management (DQM) in TCA.
  • Worked as a Financials Functional Consultant implemented modules - AP, GL, AR, Project Accounting (Costing, Billing), FA and I-Expense of Oracle e-Business Suite.
  • Implemented 2 SOB's (2 Operating Units) using multi org structure, multi-currency along with 1 Consolidation SOB.
  • Worked on a deferred revenue customization using the Revenue Recognition process in AR.
  • Functional Design for the Auto Invoice interface in AR to load invoices into AR from an external system.
  • Implemented TCA - for AR customer master conversions.
  • Implemented Outbound interfaces for AP for creating payment outbound file on (Positive Pay, Direct Deposit& Wire) for uploading into banks.
  • Establish the best practices and controls in Oracle like Security, Segregation of duties.
  • Unit & Integration testing across all modules.

Hire Now