Oracle Ebs System Analyst Resume
Tampa, FL
SUMMARY:
- Over 9 years of experience in IT consulting as an ERP Oracle E - business Suite/Oracle Cloud/Fusion business/functional analyst in multiple business domains in analyzing, implementing and of Oracle applications which includes GL, AP, AR, CM, Purchasing, E-Business Tax, iExpense, Order-to-Cash and Procure to Pay
- Strong experience in various versions of Oracle Applications such as R12, 11i.
- Strong Knowledge of ADFI, FBDI.
- Extensive experience in implementing and testing Oracle Financial Modules including and Procure to Pay process (P2P).
- Hands on experience in variety of Oracle application such as HR, PO, PA, GL, AR, AP, iprocurement, Sourcing and isupplier.
- Completed End-to-End Implementations Testing in Oracle applications R12i/R12i from requirement gathering to post production.
- Work on Endeca, Customize catalog descriptor, Punch-out, Amazon Catalog.
- Actively involved in business development activities to help identify and research opportunities on new/existing clients.
- Support of production and test instances for upgrade/regression/integration/User acceptance testing. Trained users and developed material.
- Functional understanding of the workflows, configurations.
- Help support 3rd Party integration system
- Document Creation BRD, FRD, MD50, BR100, and testing TE040, TE060.
- Creating financial statements and ad hoc reports using FSG (financial Statement Generator).
- Support of production and test instances for upgrade/regression/integration/User acceptance testing.
- Expertise in reconciliation of Sub-ledger modules with module.
- Good exposure and understanding of integration of iprocurement Module with Purchasing.
- Expertise in Client Interaction, Requirement Gathering, Process walkthrough and Functional Design documentation.
- System administration skills include defining request groups, responsibilities, users, assigning responsibilities to user setup of profile options and maintaining concurrent programs.
- Experienced in Sub-ledger Accounting (SLA), Accounting Setup Manager, Multi Org Access Control (MOAC).
- Proficient in the concepts of Multi-Org, Global Consolidation System, Multiple Reporting Currencies and Flex field setups.
- Ability to lead activities such as requirements analysis, business process design/re-engineering, gap/fit analysis, reporting analysis, application configuration, user and production support.
- Business process automation platform with robotic process automation. Kofax Invoice
- Preparing specification documentation; Designing process workflow; Identifying and resolving Gaps; providing functional inputs for specifications, Good understanding of business process, and Post implementation Support.
- Excellent communication, team building and project management skills.
- Endeca Graph Load weekly.
- Creation of Supplier oracle access in isupplier
- Updating the Verbiage of iprocurement approval notification.
- Loading Item through XML schema in iprocurement.
- Good Knowledge of Cut-over Strategies
TECHNICAL SKILLS:
Tools: HP ALM/Quality Center, JIRA.SQL,PL SQL Plus, Oracle Forms, Reports, API, OTBI and BI Reporting, FRS Financials Reporting Studio and Smart View.
Applications: Administration, Human Resources (Release 11.5.10), Oracle General Ledger (Release 11i/ 11.0/ 10.7), Oracle Accounts Payable (Release 11i/ 11.0/ 10.7), Oracle IProcurement/Purchase Order (Release 12.1.3), Project Accounting (Release 12.1.3). Oracle iprocurement, Oracle Sourcing, Oracle isupplier. SAP Material Management, Warehouse Management, Service Now.
Methodologies: Agile, Water Fall, Oracle AIM 3.0, SDLC
PROFESSIONAL EXPERIENCE:
Confidential, Tampa, FL
Oracle EBS System Analyst
Responsibilities:
- Gathering business requirements, Analysis and documenting them into Business Requirement Documents (BRD) and Functional specification documents (FSD)
- Oracle Supplier integration with 3rd party system “Zycus”.
- Worked on Oracle and Zycus payment process integration.
- Worked with Development team to integrate the payment process within both systems.
- Helped business user to implement Procurement process and custom work flow approvals.
- Focus on data conversion planning from EBSR12 to Oracle Cloud Financials which includes setting data conversion
Confidential, Tampa, FL
Senior Oracle Cloud Functional Consultant
Responsibilities:
- Arrow using Oracle EBS with 17 ledgers and 23 operating units and initiated a cloud migration project for non-USA ledgers and I was part of end to end cloud migration project including assessment of cloud migration, requirement gathering, data migration from legacy ERP to Oracle Cloud Fusion Financials
- Focus on data conversion planning from EBSR12 to Oracle Cloud Financials which includes setting data conversion setups in the cloud, coordination with Oracle for instance setup, setting FBDI templates, coordination with JD Edwards team to extract the master and transactional data, configuration setups for all ledgers, coordination with users, running CRP, UAT and SIT.
- Use Rapid Methodologies to Manage Enterprise Structure, Chart of Account (COA), Business Units, Data Access Set and Cross Validation Rule.
- Involved in setups for Ledgers, Job Roles and setup financial options, Payable Options, Suppliers, Tolerances, Bank, Oracle Fusion Expense.
- ADFI- Helped user trained for Invoice Spreadsheet creation and import.
- FBDI- File Base Data Import for Supplier Address, Site, Bank Accounts.
- Expenditure Item Date Accounting with Common Accounting Period
- Project Organization Classification
- Created Project Costing Concepts Expenditure Item Date Accounting With Common Accounting Period, Project Template and Project Type.
- Worked on Budgetary Control Purchase Order, Project accounting.
- Customize Purchase Order Creation based on Direct Manager Approval and Financial Approval.
- Define Purchase Order Approval Group and Security Rule.
- Work on P2P, OSN, IProcurement, Purchase Order, Blanket Agreement, RFQ, and ASN.
- Closely worked on a project called Account Standardization at Citi for different countries (implemented around 23 countries) where all the GL accounts were aligned to UNSPSC mapping based on commodity.
- Led a team of analysts (on procurement side) for end to end implementation of Fusion cloud offerings as a part of CITI 2018 Fusion Road map. Major Player in decisions revolving around co-existence of EBS and Fusion modules.
- Worked on OTBI Reports and BIP Reports
- Well versed with Rapid Implementations and configuration packages in Fusion Cloud using FSM (Functional Setup Manager), creating Implementation users, role assignments and LDAP (Lightweight Directory Access Protocol).
- Provide solutions to functional issues and involve in testing of the application releases
- Leading an initiative where PRENAX (Subscription Management Company) was on-boarded and integrated with P2P.
- Closely worked with business users to understand the business processes and prepare the business requirements definition documents
- Involved in advisory team for GST implementation for client roll out for CITI India legal entity.
- Gathered requirement data, mapped data elements to Oracle functionalities, reviewed gaps, defined work-around solutions to proactively reflect company’s business future outlook. Used descriptive flex fields to cover additional data and to historical data during transaction processing.
- Successfully merged multiple sub-ledgers in FAS to one consolidated sub-ledger, responsible for conversion and migration of fixed assets from the Legacy system into oracle,
- Ability to impart Functional in Oracle General Ledger, Account Payables and Purchasing
- Participating in CRP phases.
- Train the team members in Sub Ledger Accounting (SLA), Multi Org Access Control (MOAC).
- Setup Revaluation, Translation and consolidation
- Supported Oracle R12 Applications - Human Resources, Payables, iProcurement, General Ledger, Web ADI and timesheets.
- Implemented ISupplier, worked with vendor and provided .
- Create/Maintain/Administration of Hyperion Financial Reporting, applications in HFM & FDM
- Installation of Hyperion Planning, Essbase, HBR, Reports, Analyzer, HAL & license server for new production environment.
- Created SR’s with Oracle for supporting Oracle R12 support tickets and for patch analysis and its implications.
- Creating iprocurement Category hierarchy, punch-out catalog setups, setting up content zone and stores.
- Patch analysis and Pre-requisites for one-off and rollup patches for oracle projects and iexpense
- Created reports using Financial Reporting Studio FRS. Mass allocation.
- Document existing functionality for iprocurement and HR for process improvements.
- Cutover Planning and Management
- Built and maintained detailed (450+ steps) MS Project technical/functional cutover plan used for production cutover and rehearsals
- Worked on AME Approval Process.
Confidential, Eatontown, NJ
Oracle Functional Consultant
Responsibilities:
- Involved in setups for Ledgers, Responsibilities Multi org, financial options, Payable Options, Suppliers, Tolerances, and Banks.
- Work with Onsite and Offshore development teams for application development and delivery.
- Provide solutions to functional issues and involve in testing of the application releases
- Worked closely with business users to understand the business processes and prepare the business requirements definition documents
- Ability to impart Functional in Oracle General Ledger, Account Payables and Purchasing
- Trouble shooting and Testing punch out catalog.
- General Ledger, Web ADI and timesheets.
- Created SR’s with Oracle for supporting Oracle R12 support tickets and for patch analysis and its implications.
- Creating iprocurement Category hierarchy.
- Patch analysis and Pre-requisites for one-off and rollup patches for oracle projects and iexpense
- Resolved support issues for iprocurement approval testing and payable accounting process.
- Document existing functionality for iprocurement and HR for process improvements.
- Cutover Planning and Management
- Managed cross-team integration (including independent data warehouse/reporting group) throughout cutover process
Environment: Oracle Apps EBS GL, AP, AR, PO..
Confidential, Wilmington, Delaware
Oracle EBS Functional
Responsibilities:
- Involved in implementation and testing of Oracle Applications Financial R12 GL, AP,FA and CM modules
- 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.
- Configured GL, AP modules in R12 Environment.
- Principal lead for General Ledger Multi-org on an R12 implementation through initial
- Worked on requirements gathering, gap mappings, and various functionalities in General Ledger.
- Working on Payables and Cash Management setups and issues.
- Determined business requirements for Asset summary by category report, Asset register report Customized Asset addition by cost summary report, Asset category report, Asset retirement report, Asset additions report, Annual additions report.
- Worked on Setting Instances for new acquisitions.
- Working on post upgrade support and interacting with Business users on Issue resolutions.
- Fixed assets setting up of Asset Categories, Asset Keys, Locations, Fiscal Years, Book Controls, Calendars, Prorate Conventions, Depreciation Methods, Bonus rules, Ceilings and Security.
- Prepared Module design (MD050) Documents for Customizations.
- Worked on Setting up and customizing dunning letter, statement cycle in Accounts Receivable module.
- Developed FSG Reports in GL like (Income statement, Dept Expenses, Inter Company Summary).
- Created custom responsibilities to which were attached specific menus, forms and reports for restricted user access.
- Created and maintained User Menu objects.
- Created responsibilities assigned to users and set profile option
Confidential
Financial Functional Consultant
Responsibilities:
- Interacted with the Business users for understanding the Requirements and subsequently developed the functional design to meet the client requirement.
- Responsible for gathering Business Requirements Identifying Gaps & Fit Gap analysis (BR 010).
- Designed & implemented a Customization on “Refund process” (with the help of Technical team) to refund the amount to the Customer by cutting a check in AP.
- Implemented a major Enhancement “Journal entry creation for Cash management Entries” to perform reconciliation of Treasury entries which saves significant cost & Benefits the Customer to avoid manual intervention.
- Evaluating the Reports and testing them for the desired outputs after development as Per the Business requirements.
- Responsible for Baseline configurations for Accounts Payables, Accounts Receivables & Cash Management.
- Providing solution for Revenue Recognition for Pacific Bio Sciences orders in AR.
- Helping technical team develop a customized Revenue Recognition program in AR.
- Developed and executed test scripts and drove resolution of fixes to the system prior To User Acceptance Test.
- Responsible for end to end testing on Accounts Payables.
- Testing the entire process of Payables transfer to GL, AP Assets creation and mass Additions create through Payables.
- Set up of Desktop ADI and test the creation of Journals along with WEB ADI.
- Evaluating and adding account combinations so Account Generator runs smoothly for Depreciation run.
- Played significant role in system Integration testing.
Confidential, Walnut Creek, CA
Oracle Financial Consultant
Responsibilities:
- Worked with a team to implement the Oracle 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, PO, CM, ADI, version R11i.
- Enhancements to Internet Expenses functionality.
- Implemented Oracle Cash Management for bank reconciliation
- Set up new account combinations and cost centers in the Oracle application.
- Developed the new chart of accounts.
- Performed hands on configuration setups for GL and AP, including budgets, multi-org & multi reporting currency.
- Participated in setting up of Multi-Org 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.
