Oracle Apps Functional Consultant Resume
Tampa, FL
SUMMARY
- Over 7 years of IT experience in oracle applications E - Business Suite(EBS) 11i and R12 as an Oracle Applications Functional Consultant.
- Implementation and technical expertise in Oracle Applications R12/11x, across Modules such as Purchasing(PO), Accounts Payable(AP), Accounts Receivables(AR), General Ledger(GL), iProcurement, Oracle Projects(PA) (Costing & Billing), Procure to Pay cycle(P2P), Oracle Alerts and XML Publisher.
- Worked in R12 Implementation, Migration, Interfaces and Post production support projects.
- Thorough knowledge on Multi-Org and Intercompany (MOAC) and (AGIS).
- Complete knowledge of Software Development Life Cycle (SDLC)
- Extensive experience in PL/SQL Oracle database and RDBMS Concepts Procedures, Functions, Packages and Database Trigger.
- Used Oracle Application Object Library (AOL) features like value sets, Flex fields, Concurrent Programs, Profile Options, parameters and standard request submissions in the process of development.
- Extensive experience in Order to Cash (O2C) and Procure to Pay (P2P) cycles.
- Extensive experience in working with SQL Queries and in creating database objects like Tables, Triggers and Views.
- Experienced in Oracle Application System Administration, AOL System Admin Activities such as Creating KFFs, DFFs, Profile Options, Value Sets, Users, Responsibilities, Managing Concurrent Programs and Requests.
- Experienced in Customizing standard Oracle Reports using Reports 10g/6i in GL, AP, AR and PO modules as per business user requirements.
- Experience with Oracle SLA (Sub Ledger Accounting), MOAC and TCA.
- Experienced in implementation and upgrade from Oracle 11i to R12.
- Good expertise in developing Reports, Interfaces, Conversions and Extensions (RICE) Components and Configuration, Extension, Modification, Localization, Integration (CEMLI).
- Hands on experience in design and development in Extraction, Transformation & Loading (ETL) of data from multiple sources (oracle, flat file and ftp) using oracle pl/sql, sql loader, sql plus, UTL File package.
- Strong experience in Data Analysis by writing SQL Queries and analysis using MS Excel.
- Worked Extensively on Application Implementation Methodology (AIM), business requirement gathering, understanding As-Is Process, designing solutions (To-Be Process), performing gap analysis.
- A good understanding of all the phases AIM Methodology.
- Worked in R12 Implementation, Migration, Interfaces and Post production support projects.
- Deep Understanding on Indexes, Partitions, TkProf, DB Profiler and hints used for PL/SQL tuning.
- Worked on creation of Purchase Order through API.
- Expert in System Administration in defining users, menus, responsibilities, and maintaining concurrent programs. Defined Custom Applications, which includes new Menus, Request Groups and Responsibilities using Application Developer and System Administrator responsibilities.
- Ability to learn and adapt to new technologies, good team player in dynamic work group environments and also self-motivated to work independently with excellent communication skills
- Oracle 12c, 11g, 10g, 9i, 8i, 8.0.x and 7.x on UNIX and LINUX platforms.
- Installation/Upgrade.
- RAC on Linux servers installation and administration. Implemented ASM.
- Configured, administered RMAN. Backup and recovery, export/import.
- Database performance tuning.
- Monitoring, troubleshooting, database reorganization. PL/SQL programming.
- Implemented Data guard and standby databases. Oracle Data Pump.
- Oracle Enterprise Manager, Stats pack, AWR. Experience with raw devices.
- Worked with Streams and Advanced Queueing.
- Knowledge of SQL Server 7.0 and experience with UNIX shells and perl.
- Developed scripts and reports using SQL*Plus.
- Worked with Oracle Forms and Reports.
TECHNICAL SKILLS
ERP: Oracle Applications R12.X, Oracle Applications 11i and 11.5.x
RDBMS: Oracle 12c, 11g, 10g, 9i, 8i, 8.x, 7.x
Middleware: SOA11g, Webcenter11g/12c, OBIEE 12c/11g, Weblogic 10.3 and 12c.
Oracle Tools: Oracle Discoverer 11/g10g/4i, Oracle Workflow, Oracle Grid Control, TOAD, SQL Loader, Server Manager.
ERP Modules: OM (Order Management), INV (Inventory), GL (General Ledger) AP (Account Payables), AR (Account Receivables), PO (Purchasing), BOM (Bill of Materials), WIP (Work in Progress), Iprocurement (iProc), AOL (Application Object Library), System Administration.
Backup Tools: RMAN, RSYNH.
Operating System: SunOS SPARC 5.8, 5.9, Red Hat Linux 4/5/6/7, Windows
Disk Management: RAID, Veritas Volume Manager
Programming: UNIX Shell programming, SQL/ PLSQL, Java, Perl, C, C++
PROFESSIONAL EXPERIENCE
Oracle Apps Functional Consultant
Confidential, Tampa, FL
RESPONSIBILITIES:
- Senior Functional Analyst Consultant of the project.
- Define set ups required for Oracle Order management(OM), Inventory(INV) and help finance team to identify set ups in Account Receivables(AR) and General Ledger(GL) for the implementation of Order To Cash Cycle(O2C).
- Identify Set up Order Transactions types, Document Sequence, Item attribute setups, Customer setups and pricing set ups like Advance Pricing and Costing required Order Management from Biz users and implement the same and document in BR100 document.
- Identify set ups required in Purchasing(PO), Inventory(INV) and help finance team to identify set ups required for Account Payables(AP) and General Ledger(GL) to implement Procure to Pay Cycle(P2P), document the same in BR100 document and implement the same.
- Implement Configure To Order (CTO) and Build To Stock (BTS) Order Flow in Manufacturing.
- Implement JIT (Just in Time) Manufacturing concept in Oracle R12 system.
- Integrate newly acquired organization (Currently working in SAP) to R12 environment.
- Learn current data send in Advance Shipment Notice (ASN) and Enablement data from SAP system and implement the same from R12.
- Functional and technical design for the above mentioned ASN and enablement data.
- Implement ASN propagation as EDI 856 messages.
- Technical design for capturing enablement data (like MAC address, IMEI) for each serial number from Auto test data base using multiple concurrent programs and web service call.
- Co Ordinate Onsite Offshore activities and release cycles.
- Author Functional (MD.50) and Technical Design document (MD.70).
- Transition Lead for all activities during project cycle.
- Data Extraction from current 11i system, required conversion and loading into R12 system
Environment: Oracle Applications 11g, GL, AP, AR, OM, R12, SQL *Loader, BI/XML Publisher 10g, SQL, UNIX, PL/SQL, Java, Toad.
Oracle Functional Consultant
Confidential, Kansas City, Missouri
RESPONSIBILITIES:
- Worked on business requirement gathering with documentation of BR100 and BR150.
- AS IS and gap analysis.
- Detail business process analysis and research to enhance the business process
- Provide resolution of the issues related to AR, AP, and GL worked in collaboration with business users, technical team and other concerned stakeholders
- Member of the core team responsible for implementing GL, AP and AR
- Interacted with the client team to understand the existing business practices and prepared the business requirement definition document
- Participated in designing the chart of accounts to meet the client's business requirements
- Configured the MOAC, Ledger Setup, and Legal Entities
- Used Accounting Setup Manager for Inter-company Transactions
- Provided solutions for all custom components, RICE
- Created Customized responsibilities, customized menus, customized request groups
- Created BR100 documentation for GL, AP, AR, SLA
- Created Test Scripts (TE040's) for UAT sessions
- Provided various custom solutions for client's specific needs.
- Provided various custom solutions for client's specific needs
- Provided with Post production support for various issues after go live
- Resolved the application issues interacting with oracle support through SR
- Drafted extensive set of requirements, questionnaire and gap analysis
- Involved in the design and configuration of chart of accounts, accounting periods and accounting calendar for each legal entity
- Designed the primary ledger, secondary ledger, functional currencies and reporting currencies using the accounting setup manager
- Involved in the design and setup of legal entities and the related inventory organizations using the legal entity Configurator
- Involved with the integration of sub ledger for meeting multi GAAP corporate and physical accounting requirements
- Worked on CV40 conversion documentation.
- Involved in the setup of tax configuration using the Regime to Rate flow and setup of tax rules
- Configure new prorate conventions based on the fiscal calendars.
- Create new corp. books and tax books that are associated with new calendars and prorate conventions.
- Assign asset categories to corresponding new corp. and tax books and convert assets from old books to new books.
- Reviewed business processes initiated setups, developed and executed test scripts
- Setting up of PO matching options, invoice tolerance, term holds, expense report templates
- Setting up of banks, bank branches and bank accounts, and configured the financials and payables options
- Involved in the setup of auto invoice workflow
- Involved in end user training and user acceptance testing, preparation on test scripts (TE 040) and integration testing
- Worked on Hyperion Shared Services and created numerous users, groups and provided them with different privileges.
- Worked on Financial reports (Income statements, Balance sheet, and Cash flow) using Hyperion Financial Reporting Tool.
Environment: Oracle Apps 12.0.6, Oracle 11G, Oracle Reports 11i, Oracle Forms 11i, PL/SQL, Toad 11.0.0.116 , Jdeveloper, SQLPlus, BI Publisher, PO, AP, AR, GL, PA, OIE and AOL.
Oracle Functional Consultant
Confidential, Maryland Heights, MO
RESPONSIBILITIES:
- Worked on implementation of GL, P2P, AR and Sub Ledger Accounting.
- Participated in end-user meetings to review current business processes and requirement gathering.
- Defining accounting options, methods of accounting, realized gain/loss account, unallocated revenue account, auto cash rule set, and auto invoice tuning
- Set up suppliers, locations, and purchasing quick codes.
- Setup Purchasing Categories, Sourcing Rules, Approved Supplier Lists, Suppliers, Purchasing and Receiving Options in Purchasing module
- Setup payment terms, invoice distribution, matching of invoices against PO
- Defined location, control rule and group, buyers and document controls
- Designed and tested FSG report
- Defined profile options to specify certain implementation parameters, Processing Options and System Options
- Set-ups and maintenance, converted the headers, lines and line locations from the legacy system to Oracle purchases
- Set up Oracle purchasing by defining locations, buyers, approval groups, lookup codes, and approval procedures for RFQ's, purchase orders and long term contracts
- Involved with migration of historical data for Accounts Payables.
- Set up Financial and Payable option AP
- Defined payment terms, invoice approval hierarchy and payables look-ups in AP
- Configured SLA AAD, custom source, mapping sets for Account Payable
- Configured SLAAAD, mapping sets, condition for Receivable Adjustment, invoice, Credit memo, Debit memo
- Conducted end user training
- Involved in Month end closing
- Provided support on AR, Adv collection, GL, FA modules.
- Resolved complex issue through metalink.
Environment: Oracle Applications R12 12.1.3 (AP, AR, GL, PO, INV, OM, iExpense, iProcurement, FAH/SLA), Reports Builder 10g, Forms Builder 10g, SQL, PL/SQL, TOAD, BI Publisher, EIS Reporting, Workflow Builder and Administrator, SVN.
Oracle Functional Consultant
Confidential
RESPONSIBILITIES:
- Responsible for Design, Development and support of Rebate processing project and support.
- Designed and developed custom forms to enter the customer operations and Medicaid rebates as the client’s requirements.
- Designed and developed custom forms to enter product, location, contacts ad partner master data as per the end user requirement.
- Developed workflows to send notifications to users and workflows for account generation in AP, PO and AR modules.
- Involved in implementation of OM module and developed brand new order interface as part of the data conversion from legacy system.
- Worked on Order Import in Order Management (OM), Purchase Order conversions for PO.
- Developed stored procedures to populate the interface tables in the process of importing customer’s information into AR and Purchase Order information into PO.
- Registered Concurrent program executable, defined concurrent programs attached to request groups and attaching request groups to responsibilities.
- Developed shell scripts to load data from staging tables into the interface tables and call the concurrent programs to populate the base tables as part of the conversion.
- Enabled descriptive flex fields to store additional custom information to develop the complex reports based upon several different custom applications as well as oracle applications.
- Prepared Technical Design Documents (MD70) for all the objects developed.
Environment: Oracle E-Business Suite 11(AP, AR, GL, OM, PO), Oracle Forms/Reports 6i, XML Publisher, Oracle Workflow Builder, TOAD.
Oracle Financials Functional Consultant
Confidential
RESPONSIBILITIES:
- Primarily worked in the Procure to Pay cycle and provide production support.
- Monitoring Oracle Applications systems and work on creating scripts for data fix and break fix changes.
- Created monitoring scripts using Linux shell scripting and PLSQL to monitor business critical processes.
- Manage full life cycle of design, development and testing phases and develop solution design and lead client throughout implementation and support phases.
- Created various data extraction scripts to extract data for reporting and auditing purposes.
- Analyze and solve complex customer issues related to data and processes.
- Perform functional setups, create design documents, user requirement specification, analyze the AS-IS process and provide gap analysis.
- Worked on resolving issues with workflow approval for POs and Internet Expenses.
- Working with Oracle support through Service Requests in resolving issues with standard processes.
- Co-ordinate across teams during integration testing, troubleshooting issues and tracking support tickets. Resolve Production Support tickets with a quick turnover time.
- Worked with DBAs for analyzing and testing patches.
- Organized daily calls with users to report the status of current issues and understand the issues.
- Provide Knowledge Transfer and groom personnel in the team to support the system.
Environment: Oracle Apps 11.5.10, Oracle 10G, PL/SQL, Forms 6i, Reports 6i, JDeveloper.
Oracle Financials Functional Consultant
Confidential
RESPONSIBILITIES:
- Understand the client requirement.
- Implement Custom Trade Agreement Act rules in the Order Flow
- Guide the offshore team in development.
- Develop and modify PL/SQL Packages.
- Implement Demand Planning using Oracle Advanced Supply Chain Planning (ASCP).
- Unit and Integration Testing
- Co Ordinate Go Live activates
- Coordinate Offshore activities
- Implement Custom Costing Rules in Oracle 11i instance.
- Develop OAF pages
- Set up Financial option & Payable option in AP.
- Defined payment terms, invoice approval hierarchy and payables look-ups.
- Set-up of invoices, debit and credit memos, guarantees, transaction types.
- Setup Receipt Class, Receipt Methods, Receivable Activities and Document Sequences.
- Created customer profile classes, attached payment terms, collectors, matching receipts, statement cycle to profile classes.
Environment: Oracle Forms and Reports, Toad, SQL, PL/SQL, UNIX, Oracle AOL, UNIX, Java Webservices, Advance Supply Chain Management (ASCP), Supply Chain Management (SCM)