We provide IT Staff Augmentation Services!

Oracle Financials Ebs R12 Functional Consultant Resume

SUMMARY:

  • 15 years’ experience with Oracle E - Business Suite / Applications - Performing functional and technical work.
  • Responsible for Oracle 11i Project Accounting (PA) implementation.
  • Serve as the Oracle Federal Financials and core Oracle Financials Project Accounting (PA) support
  • Configure AP/PO/Project Accounting Applications
  • Conducted integration and unit testing and analyzed test scripts for the Oracle Project Accounting (PA) module.
  • Recommended utilizing available functionalities of the Oracle Project Accounting product to maximize application potential.
  • Validated Oracle Project Accounting (PA), Payables and Fixed Assets setups following upgrade from 10.7 to 11i.
  • Created test scripts to test scenarios supporting the Oracle Project Accounting/Costing module setups and configuration
  • Created setup documents for Oracle Project Accounting (PA).
  • Demonstrated the Oracle Project Accounting (PA) application for potential implementation.
  • Analyzed setups through validation of data flows to and from Oracle Project Accounting (PA), Oracle General Ledger (GL), and Oracle Accounts Receivable through integration and unit testing.
  • Ensured successful interface of the Oracle Project Accounting (PA) application within the Oracle Financials Suite of products comprised of General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), and Order Entry (OE).
  • Implemented Oracle Project Accounting (PA) and General Ledger (GL) for client’s internal project to track consultant time and expenses.
  • Production support to Project Accounting Costing, Oracle receivables and General Ledger book closing activities Coordinating the Project accounting Book closing activities for the month end Clearing exceptions in Project accounting Interface tables
  • Functional issue resolution in Project accounting costing module usages
  • Customized Intercompany Billing process in project accounting billing Integration with AR.
  • Customer Relationship Management (CRM), Oracle Applications / Oracle Financials for Enterprise Resource Planning (ERP), Oracle CRM On Demand, Contract Management Systems (CMS) and Sales Force integration.
  • Install Base, Service Contracts, Sales Force Integration, Shipment Process, Inventory Process, Pending Automation Process, Bill of Materials (BOM), Trading Community Architecture (TCA/HZ), Quoting Tools, and other additional module Order management, Accounts Receivable (AR), Accounts Payable (AP),Business Objects, OBIEE, Business Intelligence, data Integration, data modeling
  • CRM support (Service Agreement and Installed Base) involved interfacing with users, identifying functional and technical gaps, estimating work, architecting system interfaces, designing custom solutions, programming, scheduling, producing documentation, and providing production enhancement and support, Developed reports using Business Intelligence tools (OBIEE).
  • Sales Force integration includes report and dashboard design and administering the Sales force.
  • Requirement gathering, functional gap analysis, application design, configuration module setup, writing scripts, end users and providing production support.
  • The Supplier Management solution is buttressed by an optional in corporation of Oracle
  • Advanced Data Quality. Oracle Advanced Data Quality offers advanced capabilities for profiling data.
  • Business Analyst/ Oracle Applications implementation and upgrades / Functional lead / Techno-Functional Consultant/ Business Analyst / Architect / Technical lead (Oracle / Oracle Applications: CRM, ERP, including Oracle R12 and 11i / Implementations, Upgrades, Customizations, Extensions, Interfaces), Oracle CRM On Demand
  • Have 3 Oracle R12 implementation experience with following financials modules AR, AP, GL, FA and CM, Project Costing and Project Billing
  • EBS Tax SME, Sub ledger Accounting SME, AGIS SME. European countries, Brazil, Argentina localization SME, Asia pacific counties localization SME.
  • Setup the components of MOAC - Multi-Org Access Control Setup of Legal Entities Setup Bank Accounts Setup the elements of the eBusiness Tax Engine Setup components of AGIS - Advanced Global Intercompany System Setup the elements of Subledger Accounting Setup key changes to General Ledger, Purchasing, Payables, Receivables and Assets
  • Implements Oracle EBS for Confidential global locations GL, AR, AP, BRM, OBIEE, PO, Project Accounting, JVA, FA, OM, CM, INV, MRC, EAM, P2 in Multiple Currency, Multiple Organization environment, Conduct Unit Testing, CRP, UAT and user . Communicate with client to scope projects; perform gap analysis and solution design.
  • Proven results in Lifecycle Development methodology - responsible for taking projects from the inception and specification stage, through the design, development, and deployment processes, and supporting and maintaining systems after deployment is complete.
  • Contribute to the high-level strategic direction, vision and scope of multiple projects.
  • Work closely with Team Lead programmers, content developers and graphic designers to communicate and implement requirements.
  • Coordinate communication between end-users and IT team, schedule meetings and work sessions, including QA and post-mortem project review.
  • Teamed with content developers to edit system documentation achieving accurate and current information for uses. Provide inputs to customize and improve overall customer satisfaction
  • Oracle Install Base centralized repository of information for item instance and its tracking details including location, status, ownership, party, account and contact relationships, configuration data linked to Contracts service requests repairs.

COMPUTER SKILLS:

Software: Oracle 11g,10g, 9i, 8i, 8, 7.x, SQL, PL/SQL

Oracle Service/Customer Relationship Management (CRM): Service/Service Requests/Case Management Installed Base (CSI) Service Contracts/Contracts Core (OKC), CRM Foundation (JTF), Trading Community Architecture (TCA/HZ), CSCC ( Service contract center) and quoting tools like (SMS3,IQT).Supplementary experience in Distribution, Manufacturing, SCM, Financials Order Management (OM), Shipping Execution (WSH), Inventory (INV), Bill of Materials (BOM), Pending Automation process to convert the order into contract, Accounts Receivable (AR), Accounts Payable (AP), General Ledger (GL), Purchasing (PO).

Other Components: Workflow/Workflow Builder, Alerts (ALR), Application Object Library (AOL/FND), Concurrent Manager (CM), Flexfields; New System Implementations, New Module Installations, Upgrades, Customizations and Extensions; Interfaces and Data Conversion.

Oracle Tools/Components: Oracle Discoverer, SQL*Plus, SQL*Loader, Browser/Query Builder, Oracle Developer, Oracle Forms 6i and Oracle Reports 6i, Designer/2000, Toad, SQL Navigator, BMC, PVCS, DDTS, Lotus, MS Access, Remedy for Business case tracker.

Languages: SQL & PL/SQL, C/C++, UNIX shell scripts, JavaScript.

Skill: Oracle Functional /Global Implementation EBS/ R12, Suite 11i. Financial, GL, OBIEE, AR, AP, OM CM, PO, PA, FA, Fusion Apps, SOA, Oracle Workflow Builder, Oracle Enterprise Manager. Oracle Fusion Middleware, BPEL Process Manager, XML Publisher. PowerPlan, PowerTax, Mercury Quality Center, Rational Clear Quest.

Database: Oracle 8i, 9i, 10g, 11g. SQL, PLSQL, Shell scripting Oracle Developer 2000, Discoverer, Oracle Reports 6i, Oracle Forms 6i., VB 6.0, C++ 6.0, JAVA J2EE, XML, JBuilder, PowerBuilder 7.0, PowerBuilder 9.0, UML, use cases, Rational Rose, Oracle architecture. Hyperion 8.5, Hyperion system 9, PeopleSoft Enterprise 8.5

EXPERIENCE:

Confidential

Oracle Financials EBS R12 Functional Consultant

Responsibilities:

  • Gathered business requirements, participated in setups & implementation and test scenarios for Oracle Financial modules.
  • Performed the setups for GL,AR,OM, IVN, AP, PO, IPROCUREMENT, FA, SLA, FAH, XTR, CE, Credit Management
  • Worked on fit gap analysis
  • Gathered requirements through various meeting/discussions/workshops for implementation.
  • Performed testing along with other users in various instances and resolved issues
  • Setting up EBTax, setting up of Chart of Account, setting up of Fixed Asset Categories, Intercompany accounts
  • Prepared Test Scripts, using HP ALM
  • Prepared BR100 documents
  • Prepared the Rollback Plan
  • Raised SR for several issues and resolved them
  • Involved in Post Production Support for Oracle Financials Modules
  • Oracle/Hyperion Planning FCM 11.1.2.4 and Essbase Principal, responsible for implementing forecasting, budgeting and operational reporting solutions utilizing a variety of current Hyperion/Oracle products for both new and existing environments and changing requirements.

Environment: Oracle Applications R12.2.3 Modules (IPROCUREMENT, PO, AP & ISUPPLIER PORTAL)

Confidential

Oracle Functional R12 Consultant

Environment: Oracle E-Business Suite R11 i; Trading Community Architecture (TCA), Service Contracts/Contracts Core (OKC), Installed Base (CSI), Order Management/Entry (OM), Accounts Receivable (AR), Service Requests (CS), iSupport Self-Service (IBU), Customer Care (CSC), CRM Foundation (JTF), Application Object Library (AOL/FND), Concurrent Manager, Flexfields, Oracle 11g, PL/SQL, SQL. Toad.

Responsibilities:

  • Requirement gathering, functional gap analysis, application design, configuration module setup, writing scripts, end users and providing production support.
  • Installed Oracle Tutor and User Productivity Kit (UPK) Developed/Delivered 5 courses using UPK and PowerPoint tailored to client needs (Manufacturing Overview, Inventory, CRM, Project Accounting and Cost Management). (Release 12)
  • Business Requirements Analysis, Application Design, Data Modeling, Development, and Testing of Data Warehousing and Database and Implementations.
  • Siebel Analytics and OBIEE in Siebel eConsumer Goods, ePharma, eFinance verticals in Sales and Marketing Analytics.
  • Oracle Database server 10g & RDBMS and Programming concepts. Strong skills in SQL, PL/SQL.
  • Extensive Data Modeling experience in Star Schema/Snowflake schema design, Fact and Dimensions tables, Physical and logical data modeling.
  • Gathered Business requirements by interacting with the business users.
  • Performed gap analysis and feasibility study for the given requirement.
  • Created mock up reports and dashboards for review by the business users.
  • Performed Data Validation of data in the reports and dashboards.
  • Extensively used SQL Tuning to improve performance.
  • Design, Development and Documentation of the ETL strategy to populate the Data Warehouse from the various source systems.
  • In depth knowledge on Data Mapping, Data Conversion, and Data Cleansing.
  • Experience in performance tuning of Informatica mappings and sessions, Siebel Analytics Reports and SQL query.
  • Extensive experience in Siebel Analytics/OBIEE repository (Physical, Business Model and Mapping and Presentation layers) for both Stand - Alone and Integrated Siebel Analytics implementations.
  • Extensively worked in creating hierarchies and aggregates in the BMML.
  • Excellent proficiency in data and object level Security in Siebel Analytics/OBIEE.
  • Extensive experience in customizing Siebel Analytics/OBIEE dashboards and reports.
  • Extensive experience in Repository and Reports performance tuning.
  • Extensively worked on Siebel EIM to import/export data between legacy and Siebel Databases.
  • Performed unit, integration and system testing for all components in Siebel Analytics.
  • Created design, development, and testing documentation.

Confidential

Oracle Functional R12 Consultant

Responsibilities:

  • Upgrade 11.5.8 to 12.1.2 with GL, AR, AP, BRM, iProcurement, Mobile iexpense, HRMS, Compensation and Benefits Management, OBIEE, OM CM, PO, PA, FA, EB TAX, Oracle Applications System Implementation Portal 11g, Specializing In Manufacturing Modules. Experience in a wide variety of areas such as Gap Analysis, Module Setup, Business Analysis, Upgrade, Application Design, Conversion and Interface Design, Handling TARs, System Administration, Documentation using AIM3.0, Full life cycle implementation going through Development (DEV), Conference Room Pilot (CRP), User Acceptance Test (UAT) and Production, User, go-live and post go-live Support in complex Multi-Org Environment.
  • EBS Tax SME. Set up a tax configuration using the Regime to Rate flow, Manage party tax profiles, configuration owners, and service providers, Set up party, product, and transaction fiscal classifications and explain how these classifications impact tax processing, Set up and use tax rules, Manage taxes on transactions and identify E-Business Tax reports, Manage migrated tax data for DMV upgrading from Release 11.5.8.
  • Familiar Oracle/Hyperion Planning and Essbase Principal, responsible for implementing forecasting, budgeting and operational reporting solutions utilizing a variety of current Hyperion/Oracle products for both new and existing environments and changing requirements.
  • Have strong verbal and written communication skills with structured project management and software package implementation process. Overall technical design of the Planning / Essbase solution Prepare final design document for Planning / Essbase solution. R12 EBTax upgrade, with creating new tax regimes EBTax for US and Canada. Design EBTax solution for US and Canada.
  • Create BR030 and BR100 for EBTax. integrating Oracle Applications (Order-to-Cash & Procure-to-Pay) with Vertex O Series.
  • Implement Oracle Transportation Management delivers transportation planning and execution capabilities to shipping department and logistics. Integrates and streamlines transportation planning, execution, freight payment, and business process automation, from full complex air, ocean shipments. lowers transportation costs, improves global fulfillment options.
  • Setup Oracle Project Costing as one of the core applications in Oracle Projects suite. also setup projects, project work-breakdown structures (WBS) and project budgets, collect project-related expenditures (including timecards, expense reports, supplier invoices, inventory costs, and other miscellaneous transactions), and account for them in General Ledger. Depending on a project type, setup either billable to be billed to clients, or capital (CIP) to become fixed assets, or can be other indirect (overhead) costs associated with running DMV business. Experiences setup Oracle Projects to process all three types.
  • Configured OTL for client with 10,000 employees. Coordinated with Payroll Lead on Element Setup and Calculations for blended overtime.
  • Wrote Functional Specifications for, and tested, a number of incoming and outgoing Payroll Interfaces. Customized OTL “explosion packages” to accommodate Alternate 9/80 Schedules.
  • Customized extensions for Transfer from OTL to Project Accounting to accommodate method of costing. Wrote a number of OTL Fast Formulas. Customized Timecard Layouts.
  • Oracle Project costing for the project setup. Project work-breakdown structures (WBS) and project budgets, collect project-related expenditures including timecards, expense reports, supplier invoices, inventory costs and other miscellaneous transactions and account for them in General Ledger. Billed to clients or capital CIP to become fixed assets, other indirect overhead costs associated with running business.

Confidential, Los Angeles CA

Oracle EBS Functional R12 Consultant

Responsibilities:

  • Responsibilities included lead consultant for Order Management and Accounts Receivables. Oracle Release 12 HRMS, OTL, PA, FA and Revenue Recognition, Demantra. Duties included base lining current business practices, setup of modules to customer specifications in a Multi Org environment. Performed functions in several instances which included testing,, conference room piloting, documentation, and go live support. OBIEE, EBS Tax localization setup.
  • Order Management, BRM EAM, PO, iProcurement, Mobile iexpense, Inventory, PIM (Product Information Management), working in a 24x7 production environment on typical issues remediation tools Remedy. Oracle functional design process (AIM Methodology), opening and managing Oracle Support TARs (Service Requests). Familiar with Oracle error handling procedures, enterprise monitoring including Oracle Alerts.
  • Implement Oracle Utilities Work and Asset Management for utility searching to balance complex maintenance tasks, and enterprise weighing equipment repair against replacement options, finding the best way to manage assets.
  • Responsibilities include developing custom report specifications. Work with end business users to ensure current reports from legacy system are either part of Oracle out of the box, or in need of a custom solution. Write the custom report spec, and work with off-shore development team to have the reports developed, tested, and deployed to the business community for acceptance. Performed Applications Support as needed in the Order To Cash role, as well as iPayment processing.
  • Setup Oracle R12
  • Setup the components of MOAC - Multi-Org Access Control Setup of Legal Entities Setup Bank Accounts Setup the elements of the eBusiness Tax Engine, regime to rate flow, and the mandatory steps required to set up taxes in R12. All of the setups are done in the Tax Manager responsibility, in the Tax Configuration tab. Setup components of AGIS - Advanced Global Intercompany System Setup the elements of Subledger Accounting Setup key changes to General Ledger, Purchasing, Payables, Receivables and Assets
  • Implementing Oracle HR, Payroll, Advanced Benefits (OAB), and HR Intelligence. Knowledge of iRecruitment, Learning Management, Self Service HR, and Time and Labor (OTL) and understanding of underlying Oracle HRMS table structures and integration points. Implementation experience include requirement determination, gap analysis, business process and solution design, application setup, application testing and support.
  • Project Accounting, Project Costing, Project Billing: Integration of Project Modules with Inventory, Purchasing, Accounts Payables, Account Receivables etc. Supply Chain -
  • Implemented all seeded Features of Oracle Inventory, Re-order point planning, Cycle Counting, Min-Max Planning etc, Intercompany Invoicing, Shipping Network, Sub ledger Accounting, Transfer to GL, Reconciling Pending Transactions during Period End etc
  • Basic Cycle, Back to Back Orders, Drop Ship Orders, Pricing, OM to AR Interface, Credit Checking, all kinds of Header and Line workflow
  • Advanced Pricing for Order Management and Purchasing
  • Implemented Processes involving Standard PO, Blanket PO, Contract PO, ASL, Releases, Planned PO, Integration with Fixed Assets. R12 EBTax upgrade, with creating new tax regimes EBTax for US and Canada. Design EBTax solution for US and Canada. Create BR030 and BR100 for EBTax. integrating Oracle Applications (Order-to-Cash & Procure-to-Pay) with Vertex O Series. R12 EBtax for European countries, Brazil, Argentina localization, Asia pacific counties EBtax localization.
  • Developing Collection Plans, Integrating with Purchasing etc
  • Enterprise Asset Management: Implemented Preventive Maintenance Process, Integration with Purchasing, Inventory
  • Daily Business Intelligence: Implemented DBI Modules for all the above Func. Areas, iProcurement, iSupplier.

Confidential, Houston, TX

Oracle EBS Functional Lead Consultant

Responsibilities:

  • Implements Oracle EBS for Confidential global locations GL, PIM,AR, OBIEE, AP,PO, Project Accounting, JVA, FA, OM, CM, INV, MRC, P2 and EBS Tax localization setup in Multiple Organization environment, Conduct Unit Testing, CRP, UAT and user . Setup The Multiple Reporting Currencies (MRC) feature allows to report on and maintain accounting records at the transaction level in more than one functional currency. Functional specification preparation for data conversion and customization, business process reengineering, systems design, configuration and implementation of Oracle Applications analyze ‘As-Is’ and ‘To-be’ business process, complete complex business design for gap / interfaces and configure system to user requirements.
  • Oracle Order-to-Cash delivery of Oracle Financials and Manufacturing technology/process including implementation, upgrade, and extension Items & Inventory, Pricing, Customers, Logistics, Receivables. OM Streamlines the Order Entry Process, Order Creation, Defaulting information during manual entry, Order Import Process/EDI, Order Booking, Consolidates scheduling product shipment and reserving inventory, Credit Checking, Managing Orders. Improving operational metrics, business case development & performance measurement.
  • Oracle Modules for Release 12, Project Accounting especially in Project Costing, Project Billing, Project Collaboration, Project Management, Project Contracts, Cost Management, define revenue and invoicing rules for projects, generate revenue, create invoices, and integrate with other Oracle Applications. Enter project customers and contacts with whom negotiated and contracted project work, define customer agreements (purchase orders, service agreements, contracts, etc.). Generate revenue using various methods including time and materials, percent complete and cost plus, and create draft invoices from detail transactions and milestones for online approval by project or accounting managers. Automatically generate accounting entries for revenue and invoices, and interface revenue to Oracle General Ledger and invoices to Oracle Receivables.
  • Knowledge of Oracle Project Manufacturing for the project setup. Project work-breakdown structures (WBS) and project budgets, collect project-related expenditures (including timecards, expense reports, supplier invoices, inventory costs and other miscellaneous transactions) and account for them in General Ledger. Billed to clients or capital CIP to become fixed assets, other indirect (overhead) costs associated with running business.
  • Multiple cost centers per DOI Unique JVA and AFE DOIs Enhanced security for DOI maintenance Partnership and manage Cash Calls.
  • Setup Oracle Approvals Management (AME) self-service Web application and enables users to define business rules governing the process for approving transactions in Oracle Applications PO and Mobile iexpense. Setup 170 MarkView for Accounts Payable application optimizes the accounts payable (AP) process by scanning invoices and capturing original transaction information, automating the entry process, applying best practice workflows.

Confidential, Houston, TX

Oracle EBS Functional Consultant

Responsibilities:

  • Oracle Functional /Global Implementation EBS/ R12 GL Functional. Oracle R12 General Ledger functional consultant with experience in global implementations. understanding of new GL functions in R12. Knowledge of sub-ledger accounting.
  • Creation of and modification of Work flows in Finance, Order management areas. Process & data flow in Oracle Receivables, Oracle Payables, Oracle Inventory, Oracle Order management. Intercompany Invoicing & accounting in Multi-Org, Multiple set of Books environment. Functional specifications, design solution and delivery technical specification document.
  • Order to Cash - Strong Order management and shipping. Design order cycle, order type workflow approve rules. Drop ship model, order extraction and fulfillment partner integration for order sourcing rules setup functional designs. Invoice rules, accounting rules, drop shipment, inter company transactions. Implemented Multi-Org setup and Profile options. In functional role, requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing of guides, end users. Configured complete order to cash cycle. It involves configuring of order type, order cycles, Pricing, Shipping and Receivables. Design and Setup of Order Entry Module to cater for in its Operating Unit and Set of Books. Configured Tax Localization module for Order Entry and Account Receivables.
  • Oracle EBS 11i / R12 Receivables, Cash Management, Treasury, iReceivables, & OM Experienced Resource with the underlying processes. Oracle AR Module and Applications, AR Process, and Accounting Purchasing /Order/Supply Chain along with Iprocurement.
  • Oracle Install Base centralized repository of information for item instance and its tracking details including location, status, ownership, party, account and contact relationships, configuration data linked to Contracts service requests repairs.
  • Oracle HR/Payroll/Benefits functional Consultant with expertise in Oracle HRMS, Payroll, Advanced Benefits (OAB) customization. Exposure to Release 12 Oracle HR Payroll functional involved in all phases of Oracle E-business Release 12 implementation/upgrade project - Requirements Definition, Fit - Gap Analysis, Interface Data Mapping, Report Mapping, Application Setup Configuration, System Testing, and End User . Oracle HR Payroll Benefits OTL functional consultant
  • Develop functional test cases, documentation, and test execution of Oracle HRMS . Develop BR 100, BR30 and TE 40 for Oracle HRMS.
  • Advise clients on how to maximize the efficiency and effectiveness of HR service delivery model and operation of the HR function, ranging from process design to self-service applications and enabling technologies, and considering in sourcing, outsourcing, and offshore solutions. Involved in the design and implementation of custom, technology enabled business solutions. Bringing together process and technology solutions to solve business issues. Defining business and systems strategy, developing system requirements, designing and prototyping, testing,, defining support procedures and implementation. Perform accurate analysis and effective diagnosis of client issues. Core HR, Payroll, Standard Benefits, Advanced Benefits.

Confidential, Houston, TX

Oracle 11i Functional Consultant

Responsibilities:

  • Federal Accounting Procure to Pay - Setup Supplies, Matching and tolerances, Pay on receipts, Budgetary control, Receipt accrual, Bank reconciliation. Setup financial options, purchasing options, receiving options, payables options.
  • Implementing Procurement cards & customizations using OA Framework.
  • Customizations of Requisition Approval, PO approval & Auto create Workflows. Procure to Pay process (INV, PO, IPROC, AP), OA Framework, Oracle Forms and Reports, Microsoft Visio, PL/SQL.
  • Oracle Apps HR Functional with knowledge to R12. Core HR, Advanced Benefits and iRecruitment. EBS HR SME Solution formulates and defines technology solution scope and objectives based on both business user needs and a solid understanding of applicable business requirements. Includes analysis of business and user needs, documentation of requirements, and translation into proper IT solution requirement specifications via the creation of deliverables such as functional requirements documents (MD50s & BR100s), use cases, detailed process models and test scripts. Competent to work at varying technical levels across phases of solution analysis while considering the business implications of the application of technology to the current and future business environment.
  • Responsible for maintaining effective internal controls and maintaining full supporting documentation (transactional, SOX and policy & procedure) for external, internal and compliance reviews/audits.
  • Test Lead to upgrade Oracle ERP Package, leading the testing effort as the company Transitions its ERP system from 11.5.8 to v. 12. Modules: (Financials/Procurement/Project costing, etc.) work with test schedules manage performance testing, leading a core team as well as interact with offshore development efforts. As the project flows through its respective test cycles, perform both automated and manual testing. Run daily meetings in reviewing test scripts, using the Mercury Suite (Test Director) as well as Excel. Implement and report the testing efforts, generate periodic reports on the project’s progress to the Functional Project Manager. Review exit and entrance status, working with transactional processing, navigating test scripts.
  • Supply Chain Planning and Operations ASCP focusing on providing independent advice across all aspects of supply chain (Procurement, Sales & Distribution, Manufacturing, Warehousing & Inventory Management and Plant Maintenance). From Conception to completion.
  • Develop and execute quality assurance test plans for unit, system, and regression testing. Assembling set of discrete services into an end-to-end process flow using BPEL process manager to creating, deploying and managing BPEL business processes.
  • Use Oracle Workflow Builder to define the sequence of functions as a workflow process, specify job dependencies between the mappings to ensure that jobs run in the proper order, schedule the process to run using Oracle Enterprise Manager. Software development using PL/SQL, SQL* Plus, Oracle Forms 6i, Oracle Reports 6i, Discoverer Oracle Database 9i.
  • Oracle Financials Business Analyst for the Oracle Financials 11.5.10 GL, AR, AP, OM, PO application. Responsible for the creation and evaluation of Oracle Financial solutions to support business requirements. Working with the Finance Business team to leverage existing Oracle functionality to drive standardization and simplification. Insures that customization is minimized to reduce project costs and shorten project timelines.
  • Oracle E-Business Application develop experience with Financials, Purchasing, Iprocurement, Accounts Payable, Projects, Human Resources and Supply Chain Management, proficiency in Oracle Workflow, SQL, PL/SQL, and Discoverer and HTML, JAVA, XML, Oracle Forms, and Oracle Reports. Technical experience with administrating Oracle and SQL server databases.
  • Familiarity with software integration, systems design, application design and development methods, business requirements analysis, operational readiness, service level agreements and system support of a continuous operating environment. Setup concurrent programs for customized reports and forms. Identifies and analyzes new tools and Oracle ERP application functionality. Serves as the IT subject matter expert on Month End business process and the related data flow from other IT systems into the Oracle Financials GL, AR, AP, OM, and PO.

Confidential, FL

Oracle Consultant

Responsibilities:

  • Supply Chain Functional Consultant (ASCP, ODP, Purchasing, iSupplier, Inv, OM)
  • Implement ODP/ASCP and support existing Oracle applications
  • Conduct interviews with sales directors, customer service representatives and engineers from manufacturing, sales and purchasing departments regarding forecasting and planning process.
  • Assess and map business requirement on forecasting and supply chain planning
  • Work with IT department for data collection and validation
  • Set up ODP functionally (e.g. setting instances, collections, dimensions, hierarchies, levels, and profile options)
  • Use ODP as administrator
  • Define demand plan planning server
  • Build a new demand plan in demand planning engine
  • Set up user environment, including setting measures, scenarios, events, planner assignment
  • Implement ASCP and integrate ODP with ASCP for a two-machine implementation
  • Set up Advanced Supply Chain Plan Options: organizations, aggregation, optimization, and constraints.
  • Creating Sourcing Rules, assigning sourcing rules and ASL to items
  • Set up Lead-time attributes and planning fence for organizations
  • Simulate the whole supply chain based on any change in ERP system - change in inventory levels, changes to customer orders and methods of scheduling
  • Use Planner WorkBench to release planning recommendation. Autocreattion of order from release requisition.
  • Post-project support for modules of Inv, ASCP, ODP, Purchasing, iSupplier, OM etc. Some of the major troubleshooting cases are as follows:
  • Troubleshooting for inability to release a Purchase Order from workbench: check item status, sourcing rule, ASL, allocation rule and buyer mapping - modules involved: Inv, ASCP, Purchasing
  • Troubleshooting for collection failure: Purge staging tables, refresh collections snapshots, submit collections and plans - module involved: ASCP
  • Troubleshooting for Purchase Order stuck in workflow: identify why PO status is in process: verify whether a change is pending from iSupplier; run wfretry.sql if the reason is Document Approval Manager is timeout or not active - module involved: Purchasing, Oracle Workflow
  • Troubleshooting for inability of forecast interfacing to planning server: check item status, assignment set, forecast set, interface staging table - modules involved: Inv, ODP, ASCP
  • Import orders corrections; review backorders by running the unbooked orders report and open sales order report - module involved: OM
  • Generate customized report and query either in Oracle or by using Oracle discoverer
  • Write test script and conduct functional testing
  • Prepare user guide and material and conduct user

Hire Now