Oracle Functional Consultant Resume
High Point, NC
SUMMARY:
- Around 20 years overall experience, 10 plus years of experience in ERP, and 6 years experience in oracle Implementation, Testing and support of Oracle EBS Financial Modules version 11.5.10, R12.1.3 which include General Ledger(GL), Accounts Payable(AP), Accounts Receivables(AR), IExpenses, Fixed Assets(FA), Project Accounting (PA), Cash Management (CM), Oracle Financial Accounting Hub (FAH),Sub Ledger Accounting, Advanced Collections, I - Procurement, Inventory, Supply chain, Cloud Financials, EPBCS, Financial close Process, Hyperion. Worked on other ERP like SAP, JD Edwards, and Peoplesoft & Ramco. Worked on JDEdwards One Enterprise and SAP ECC6.0 Financials.
- Responsible for managing IT project teams including end users and third party providers regarding design, development, testing, documentation, support and implementation of Oracle 11i / R12 financials.
- Experienced with implementation, testing and support in Oracle EBS financial modules, End to End, Full Project life cycle experience from gathering requirements through delivery.
- Track Project milestones and adjust project plans and resources to meet customer needs and requirements.
- Responsible for creation and evaluation of Oracle 11i / R12 financials based solutions to support business requirements.
- Overall management of team and assigned projects including coordination, status reports, stability of the project work effort, manage financial, scope and critical path for assigned projects.
- Coordinate, Communication with all enterprise areas that impact the scope, budget, risk and resources of the project.
- Assist program managers in partnering with senior management in the business community to identify and prioritize opportunities to utilize IT to achieve enterprise goals.
- Works directly with partners, clients and offshore teams to determine project scope and specifications.
- Review progress, manage resources and ensure overall quality of assigned projects. Serve as a liason between customers and team members.
- Perform other duties as assigned and worked on CRP, SIT, UAT and Go Live stages of a project.
- Deep understanding of core functionalities in Oracle Financial Modules ranging from GL, AP, AR, FA, CM, IEXP and their relationship while laying accounting structure of an Organization
- Work experience on the full life cycle of Procure to Pay cycle (P2P), and Order to Cash cycle (O2C). Working knowledge of Vertex and Taxware integration with Oracle EBS.
- Performed requirement gathering analysis, documentation with the usage of Application Implementation Methodology (AIM) & Oracle Unified Method (OUM).
- Capable in Conversion of Business process into Oracle Functionalities based on understanding of Business flows.Good understanding of OBIEE/ Repository / Oracle BI analysis and Dashboards
- Analyzed underlying objects of Program and ability to drill down to table level the various data structures, joint strategies etc., Accounting knowledge to demonstrate the client about Business solutions in sync with Oracle Functionalities.
- Excellent written and verbal communication skills, including the ability to develop presentations to senior management. Advanced Knowledge and understanding of business principles, practices and procedures.
- High level of participation in large engagements and rich experience in Requirement elicitation activities which involve Business user interactions, functional specifications, documentation and effective business knowledge on transitioning applications development.
- Sound experience on Oracle Applications Architecture in Sub Ledger Accounting Method (SLAM), Ledger setups, Multi Org changes and other changes in Financial Modules.
TECHNICAL SKILLS:
ORACLE TOOLS EXPERIENCE/EXPOSURE: Discoverer, Discoverer Plus, Workflow Builder/PL SQL, OBIEE 11.1.1.7, XML/BI Publisher, Oracle Forms /Reports developer, RICE components analysis.
ORACLE APPLICATIONS MODULES EXPERIENCE/EXPOSURE: Oracle EBS (11i and R12) Finance, Inventory, Supply Chain, Discrete/OPM MFG modules: GL, AR, AP, FA, FAH, Hyperion,Projects, INV, WIP, BOM, PO, OM, Advanced Pricing, WMS, Service Contracts, TOAD, SQL Developer, XML Publisher, Third party interfaces integration with EBS
PROFESSIONAL EXPERIENCE:
Confidential, High Point NC
Oracle Functional Consultant
Responsibilities:
- Involved in Finance Support ticket issues resolution & work on Oracle Sales Orders statuses extracts along with Advanced Pricing adjustments extract for cross functional departments requirements
- Oracle Inventory Material Account Distribution details seeded report customizations Label design, format and setup for EDI Customer specific requirements.
- RICE analysis.
- Reports, Interfaces, Conversions & Extensions.
- Design and development of Items categories report for displaying the explosion of Kit & configured items.
- Work with the manufacturing modules of Oracle EBS (OM, Advanced Pricing, BOM, WIP, Inventory) and moderately complex applications in accordance with established project schedules in an Oracle E-Business Suite R12 applications environment to provide some end-user applications support by assisting users with functional technical questions resolutions and enhancement requests completion.
- Oracle Cloud Integration with R12 Oracle EBS.
- Fixed Assets and working of depreciation as per Corp & tax books.
- Oracle Reports design and development using Oracle Report Builder, Dicoverer, Discoverer Plus, SQL, Toad.
Oracle Functional Consultant
Confidential
Responsibilities:
- I have worked on projects as freelancer with contracting agency at onshore as well offshore.
- Handling upgradation from 11i to R12; determining the data gathering requirements (BP.030) for Clients.
- Developing the following
- Current Process Model (As-is) for clients (BP.040).
- Future Process Model (To-be) for clients (BP.080).
- Preparing the following:
- Current financial and operating structure (RD.010) which deliverable is COA.
- Developed Future Process Model (To-be) for clients (BP.080).
- Developed Analysis of documents (RD 20, RD50), solution design document (BR30) and closed the processes with Gap analysis (BR 10) then converted it to setup documents (BR.100).
- (BR.100); establishing the set-up of the Oracle General Ledger, Oracle Payable,OracleFixed Asset and Cash Management with Localization.
- (MD.050) for Create Financials Applications Functional Design for Customization.
- Acts as second line support to the customer.
- Conducts to the end user on means of operating the implemented system.
- Uploading data sheets with Dataloader and ADI.
- Conducting end user sessions for system users.
- Assists in obtaining the approved/signed “Final Acceptance Sheet” from the client on his/her own module(s) within the project.
Environment: Oracle 12.1.3, Oracle 11.5.10, Oracle Cloud, Hyperion, SAP FICO, Team size - 10
Confidential, Denver
Responsibilities:
- Analyzing the business needs of the client and converting them into oracle workflow.
- Testing and support and usage of Toad, SQL, HP QC Lab. Worked on test cases.
- Coordination with offshore teams and client. Overall Project Management.
- Preparation and review of BR100/ MD50/ SMTD / Other documents and other test scripts.
- Configuration of setups according to localizations in oracle modules AP, AR, GL, FA, CM & I-EXP.
- for client staff
- Worked on oracle Production, Test and other environments.
- Worked on oracle R12 Subledger Accounting & exposure to oracle Financial Accounting Hub
- Oracle Modules Handled: AR,AP, GL,FA,CM,IEXP, PA, FAH Inventory, I-Procurement, Warehouse Management, Primary and secondary ledgers, Sub Ledger accounting.
- Worked on RICE assessment & components Reporting, Interfaces, Conversions, Extensions and Forms..
- Oracle User Access Management and Audit & End to End Testing.
- Worked on Presales for my team and also on managed services model with a mix of onsite-offshore resources.
- Web ADI / OBIEE/ Hyperion/ XML Publisher/Discoverer.
- Working knowledge on EB Tax and Vertex.
- Working Knowledge of Oracle BI, BI repository, BI Analysis and Dashboards, Hyperion, Essbase.
- Working Knowledge on Fusion Middleware like SOA, Weblogic and Webcentre.
- Project Management, Change management and application of Waterfall, Agile project management methodologies in various projects life cycles.
- Working Knowledge of PL/SQL and oracle forms/ reports.
- Level3 Telecom and communications (Century Link Telecom),Denver, Colorado,USA (Version 11.5.10) /R12.1.3 Implementation Project. Was onsite Lead at Denver and worked on all financial modules and worked on Vertex and EBTax. Also worked on Hyperion and Essbase and HFM .( 2012)
- Mcgraw Hill Group of Companies, Newyork, USA (Version R12.1.3).Was onsite lead in Newyork, USA and worked on testing projects on all oracle financial modules.( ) in coordination with Tata Consultancy services who were the implementation partners.
- Emerson Electric, Houston, USA (Version 11.5.10) - Worked as onsite lead based in Houston and supporting their project in Hungary on oracle financials. ( )
- Amonix Los Angeles, USA (Version R12.1.3) - Was involved in a R12 implementation project in Los Angeles USA and worked on modules like AR, AP, GL, FA, CM, IEXP. ( )
- Origin Energy, Australia (Version R12.1.3)- Support project on oracle functional modules.(2013)
- Electronic Arts, London, Geneva- Europe (Version R12.1.3)- Implementation project and worked on a cash management project. (2013)
- Offshore support to an Energy client Singapore on Oracle Fusion Financials.(2013)
Environment: Oracle Version 11.5.10/R 12.1.3/ Fusion Financials. Team size - 1-30 members.
Confidential
Manager - Finance & ERP
Responsibilities:
- Worked on implementing the financial modules for US and international operations.
- Worked with the functional department to design and implement new business processes around requirements.
- Participated in providing Procure-to-Pay (P2P) life cycle support.
- Setup and Configured GL, AR, AP, FA,
- Set up new account combinations and cost centers in the ERP application and project accounting.
- Performed hands on configuration setups for GL and AP, including budgets, multi-org & multi reporting currency.
- Participated in setting up of MOAC for managing multi-org setups.
- Participated in Setting up Asset Key Flex fields, Asset Categories, Asset Locations, and Asset Calendar.
- Defined Sub Ledger Accounting Methods.
- Responsible for full cycle accounts payable; review of internal travel and expense reports.
- Defined currency translation, conversion, revaluation and set the profile options for GL.
- Setting up of suppliers and supplier sites by defining payment terms, distribution sets and tolerances. Developed the customer invoice, statements and dunning letters.
- Maintained cash and bank records, bank deposits and reconciliation.
- Setup Multi Org Structure including new Ledger setups based on Legal Entities, and Operating units.
- Wide Confidential exposure.
Environment: Tally and ERP
Confidential
ERP Financial Functional Consultant
Responsibilities:
- Involved in implementation and testing of Oracle Applications Financial 11.5.10 GL, AP, AR and FA modules and Ramco ERP.
- Involved in requirement gathering and analysis and design of the application.
- Worked with the client team to understand the current Business Process.
- Developed test plans and scripts and conducted testing for quality assurance.
- Performed set up GL, AP, AR, project accounting modules for 11.5.10.
- Corrected wrong currency problem in AR Invoice, Dr Memo & Cr. Memo.
- Setting up and customizing dunning letter, statement cycle in Accounts Receivable module.
- Defined Payment Options, Payment terms, Distribution Set, Payment format, Internal Banks in AP
- Corrected customer Profile class setup & statement to avoid multilingual statement printing.
- Configured and scheduled Standard Request Submission for standard APIs wherever required.
- Configured the setups for prepayment to employees and defined employee expense report.
- Developed FSG Reports in GL like (Income statement, Dept Expenses, Inter Company Summary). .
- Created responsibilities assigned to users and set profile option
Environment: Oracle Application (Ref 11.5.10), GL, AP, AR, FA, Ramco ERP Implementation partners: CEM Business Solutions
Confidential
ERP Accountant
Responsibilities:
- Successfully handled the entire accounting and IT operations of Oman business of the company
- ERP Mfgpro / Solomon and later migrated to JD Edwards.
- Worked on JDE Enterprise One and JDE Version 9.0 financials.
- Prepared and submitted to the management the daily, weekly and monthly MIS.
- Prepared MIS reports from ERP like A/R, A/P, and Payroll, Pricing and costing modules
- Migration from Mfgpro to JD Edwards
- Implemention of Project Accounting, costing and Inventory module
- Reporting to Fosters H.Q in Melbourne, Australia and the Regional office in Dubai.
Environment: Mfgpro/ Solomon, JD Edwards One Enterprise.
Confidential
Senior Executive
Responsibilities:
- Successfully managed all the functions of Accounts and Costing Department of the company
- Handled factory accounts, corporate accounts and matters in Oracle ERP and Tally
- Used Oracle Financials and maintained A/R, A/P and project accounting in Oracle and submitted reports to Management.
- Implementation of Factory Accounts A/P in Oracle. Used oracle inventory module and order to pay cycles.
- Ageing analysis reports and outstanding reconciliations in oracle.
Environment: Oracle, Peoplesoft ERP, Tally.
Confidential
Finance & ERP Executive
Responsibilities:
- As in-charge of factory accounts department carried out all the accounting related responsibilities, including finalization of accounts and maintenance of accounting records of day to day work, purchase accounting, sales accounting, costing and, maintenance of all other records
- Maintained MIS reports in Tally and later migrated to SAP R3
Environment: SAP R3 & Team size: 4
Confidential
Accounts Executive - Corporate Accounts
Responsibilities:
- Reported to the General Manager
- Carried out overall responsibilities of corporate accounts and maintained all books and ledgers and other records. Handled payroll functions and IT.
- Part of team that was implementing SAP R3
Environment - SAP R3,Team Size: 10
Confidential
Accounts Executive
Responsibilities:
- Reported to the General Manager (Projects Accounts & IT)
- Worked on the Group’s new project for taking over an existing business.
Environment: Tally, Oracle and Microsoft, Team Size: 12
Confidential
IT Accountant
Responsibilities:
- Reported to the Accounts IT & Administration Manager, Handled audits & tax.
- Maintained all books and records of accounts in Ex (TCS) software package & Prepared MIS reports
- Environment: Tally and Microsoft.