Oracle Financials Consultant Resume
0/5 (Submit Your Rating)
Spicewood, TX
SUMMARY
- Overall 5 years of total work experience in Functional Consulting experience in experience in Oracle E business suite i.e. Extensive Upgrade Experience in Finance Modules (AP, GL, FA and CE).
- Setting up and supporting various business processes in Oracle Like Physical Inventory, Cycle Counting, Kanban, Min - Max Planning, Reorder Point Planning
- Oracle Business Flows - Procure to Pay (P2P), Order to Cash (O2C)
- Order types setup, defaulting rules, Processing constraints, fulfillment sets functionality, ship / arrival sets, end customer, pricing modifier/ qualifier, pick release, ship confirm, Customer acceptance.
- Handling Month-end close activities and reconciliation for GL, AP, PO and FA modules.
- Understanding of Business processes and suggesting best business practice in Oracle.
- Run the CIP and Standard FA Reports for the different Books. Interacted with the end users and demonstrated the functionality in detail.
- Resolved Problem Tickets (PT) and Service Requests (SR) issued by Business Users for various Finance issues using Remedy System.
- Strong Oracle Applications Functional experience in multiple implementations, Upgradation and Post Production Support of Financials Modules in both R12&11i versions of Oracle E-Business Suite.
- Procurement Setups, Types of PO, Buyer Work center, Approved Suppliers List, Sourcing Rules.
- Solutioning is one of the major strength as suggested many simplification processes.
- Working experience of Oracle Applications modules, General Ledger, Payables, and Receivables, Cash Management, Fixed Asset, I Expenses, Advanced Collections, Purchasing and E-Business Tax experience in configuring the same to the needs of the business requirements.
- Good exposure of Production Support, Implementation, Upgrade and Rollout
- Participated in business process analysis, requirement analysis, gap analysis, and system design, Setup, Implementation and Upgrade.
- Exposure in Multi-Org and MRC implementations of Oracle Applications.
- Good exposure in automation tools like Config Snap Shot and Data Loaders
- Well conversant with concepts like Multi-Org, Flex fields and Workflows
- Inventory Setups, Items, Item templates, Move Orders, Transaction UOM, Org setup, Sub inventories, Locators, Physical Inventory,Cycle counting, Cost controls, Pick rules, Catalogues, Categories, KFF/DFF, Calendars etc.
- Procurement Setups, Types of PO,Buyer Work center, Approved Suppliers List, Sourcing Rules.
- Responsible for Requirement Gathering; Documentation of Environment Setups Functional Design using AIM Methodology/Client specific documentation standards (Develop As-Is Process Flow Diagrams, Presentation Slides, Functional Specifications documents BR100, MD50, Prepare TE20, End User Training Manuals, Unit Test Scripts); provide Business Training and Support; Gap Analysis and Testing Bug Fixes; Analyze and build enhancement requests; escalations, logging and managing Oracle SR(s); overtime support of client's Sev1 SR(s).
TECHNICAL SKILLS
Oracle Applications: R12 (12.0.3, 12.0.5, 12.0.6, 12.1.1 and 12.1.3) GL, AP, AR, FA, CE, EB-Tax, i Expenses 11i (11.5.8, 11.5.9, 11.5.10 and …
Languages and Tools: PL/SQL, Discoverer Viewer, Web ADI, SQL Loader, Data Loader
PROFESSIONAL EXPERIENCE
Oracle Financials Consultant
Confidential, Spicewood, TX
Responsibilities:
- Worked as Oracle EBS Finance Functional Lead implementation in for Hong Kong, Taiwan, Japan and Philippines Lighting, implementation of Greece, Angola and Nigeria GE Corporate entities in Central Corporate Ledger program
- Designed and implemented business process in Oracle for Project budgetting and disallowing requisiton if project budget is not available.
- Prepared functional documents for custom reports and forms for the following
- Custom Project Status Inquiry form
- Offered industry best practices and assisted the client with the road map definition
- Coordinated the effort for the Monthly Releases (Release Management) with EADP- Fusion - ERP
- Coordinated with the team for the Monthly Release Regression testing.
- Worked Closely with business for Conducting UAT for Expansion of Cash Card Providers (ePay, Incomm, Blackhawk) to different European Countries.
- Worked closely with the Vendors in Re -designing the Remittance file format.
- Involved in gathering requirements for New Payment methods where Electronic Gaming Expanded.
- Single POC from the Project team to Release Management.
- Resolving issues, Cutover Activities, Go-Live and support.
- Worked closely with data conversion team and gathered requirement before configuring in system for their data conversion objects.
- Identified delta setups, Documenting BR100's, MD050 for RICE components and getting sign off before configuring.
- Created 35 new Operating Units as part of disintegration for Zebra Tech. (Including subledger modules).
- Worked on mapping the new Zebra entity's with MSI existing locations.
- Created intercompany solution for new entity's products.
- Coordinated between on- offshore team for completing the configuration for Fixed Assets, AGIS, and Ebiz Tax modules.
- Worked with Data conversion team on conversions and clean-up activities.
- Excellent functional experience in Implementation, Upgrade, Enhancement, Testing, Production Support, user training, analyzing business requirements and writing functional design specifications along with Discrete Manufacturing domain experience.
- Worked on exclusively on AR new entities configuration of System options, Auto accounting, Remit to address, Transaction types, sources, Receipts methods, Activities, customers creation, Approval limits, Collectors creation, Lock box, Messages and statement cycle for the newly created entities.
- Exclusively worked on service contact testing for the new entities - right from order creation, interface, auto invoice, create accounting and transfer to GL.
- Full lifecycle Implementations R12 with GL, Accounts Payable, Account Receivable, Fixed Assets.
- Full understanding of the NEW Oracle 12 ledger/sub-ledger data model.
- Extensive Upgrade Experience in Finance Modules (AP, GL, FA and CE).
- As a Functional Consultant has been involved in interacting with various clients, and development groups in understanding client business processes
- Also has basic knowledge of Financial Modules (GL/AP/AR) especially where they touch upon supply chain modules.
- Working with Oracle Support Group on various Service Requests(SR) as per the severity and urgency.
- Thorough Understanding of Software Development Life Cycle(SDLC), involved in various phases like Requirements, Analysis/Design, Development, Testing and Post Production support to Global users i.e. North & South America,Europe,Middle East, Africa and Asia with high level of Customer Satisfaction
- Good Exposure on AIM Methodology
- Can work very well within a team to deliver the anticipated business value.
- Extensive Experience in
- Oracle Business Flows - Procure to Pay (P2P), Order to Cash (O2C)
- Order types setup, defaulting rules, Processing constraints, fulfillment sets functionality, ship / arrival sets, end customer, pricing modifier/ qualifier, pick release, ship confirm, Customer acceptance.
- Configured the delta setups in system (end-to-end) for all the Modules.
- Worked exclusively on Vertex for configuring 2 new entities with Ebiz Tax for Ebiz Vertex Related Profile Options, P2P Enablement, Configuration Owner Tax Options, Tax Rules, Vertex-Org, Vertex Rules and testing.
- SQL scripts. Held sole access to production for audit related queries. Developed and implemented the Funds Control custom application module and the interface with Oracle Projects.
- Co-ordinate between Onsite and Offshore teams for Effective Delivery
- Completely responsible for all development OM, Service Contracts, Install Base, AR, OM, AP, i-Expense and INV modules.
- Performed the expense report data conversion into i-Expense from a legacy system.
- Worked on i-Expense customizing the functionality for expense approval
- Customization of Reports of various modules like Receivables (AR), Inventory (INV), and Order Management (OM) modules.
- Designed and developed the Auto Lockbox interface program to import receipts from 3 banks. Developed the import program and used SQL Loader to load data into the AR PAYMENTS INTERFACE ALL table.
- Escalate and derive the logical conclusion, of all technical issues, that may impact the project schedule.
- Post Production support after GO-live.
- Create TARS and follow-ups with Oracle for product related issues
- Worked on Development using custom PL/SQL Package for Suppliers Data Extract File.
- Customized Inactive Items Report to add a field transaction quantity to the report.(INV)
- Customized a report Distribution Set Listing (AP) to display the Distribution Set Lists as 'like' the given Distribution set Name.
- Customized Backordered Detail Report to give the information of backorder group by customer name and customer number.(OM-shipping)
- Customized Customer Items Report to add one field for Customer Status.(INV)
- Worked as the Oracle Financials Module Expert.
- Provided analytical solutions for various business scenarios, requirements & issues based on client interactions.
- Preparation of application setups, documentation & few solution design documents like setup doc, MD docs& test docs.
- Leading the closing activities of the client on a monthly, quarterly and yearly basis including yearly roll-over process.
- Worked on the escalation management and priority handling of the critical issues as the SPOC from Off-shore.
- Knowledge sharing sessions and creation of technical and functional training documents and white papers.
- Leading the various RCA defect management.
- Developed custom interface (RICE Component) to generate value-addition to the business after the thorough contemplation of the recurring issues and obtaining the business sign-off.
- Project Management activities like SLA-Service Level Agreements, Metrics, and Team coaching & building team competencies.