PROFESSIONAL SUMMARY:

• Oracle financial functional consultant with over 6 years of experience in Consulting, Implementation, supporting roles on Oracle Applications Domain. Certified as General Ledger 2020 Implementation Specialist in Oracle Cloud Financials.
• Adept at all stages of project life cycle, from gathering and analyzing Business Requirements and Technical Definitions to Development, Testing and Production Support
• Proficient on Oracle EBS and Fusion (Cloud) application in implementation, upgrade, rollouts and supporting in financial modules General Ledger, Account Receivables, Account Payables, Fixed Assets and Cash Management
• Experience in Full Life Cycle of Oracle Financials implementations for multiple regions (North America, EMEA) involving Order to Cash(O2C), Procure to Pay(P2P) and E - Business Tax
• Experience in developing Functional specification Documents (FSDs), Business Requirement Documents (BRDs), FIT-GAP Analysis, Solutions for the GAPs, Dealing with Business Users on Training and Testing of the application
• Providing the complete setup of Multi-Org for the Financial Modules (GL, AP & AR)
• Prepared test scripts TE-40 & TE-50 for testing purpose and participated in SIT (system Integration Testing) and UAT (User Acceptance Testing)
• Look after day-to-day operations and coordinate with the both offshore and onshore teams for various technical deadline and deliverables.
• Comfortably interact with people across all hierarchical levels to ensure effective implementation of application
• Involved in creation of test plan, test scripts and test scenarios for each module
• Extensively worked on Reporting using OTBI, Oracle BI Publisher, and knowledge in OBIEE
• Co-coordinated and guided offshore team in generating financial analysis reports using Hyperion SmartView reporting tool
• Developed processes and systems to streamline different ERP sources by weekly and monthly financial analysis
• Supported strategic business decisions and demands through reoccurring and ad hoc financial analyses to senior management
• Managed KPI and reporting of financial and operational performance metrics
• Enhanced and automated analytical frameworks for more efficient, relevant and timely reporting, which drive continuous improvement in reporting and information sharing processes
• Functionally proficient in Implementation, Customization, Maintenance, Interfacing/ Reporting, Data Conversion, Upgrade, Production Support and Testing.
• Experience, in Functional Design, Fit-Gap Analysis, Implementation, Upgrade, Enhancement
• Formulated solution design and implementation strategy based on client requirements
• Possessexcellentanalytical,problemsolving, presentation, interpersonal and communication skills, and an ability to work independently
• Demonstrated ability to deal with ambiguity and thrive in a changing environment
• Workload Prioritization and managed tight deadlines for effective results in a fast-paced, client environment. Ability to multi-task between systems and applications
• Strong verbal, written communication, and data presentation skills, including an ability to effectively communicate with both business and technical teams. Advanced experience demonstrating problem solving and root cause analysis.

TECHNICAL SKILLS

EBS: OracleFormsandReports,Discoverer,XML Publisher, Database objects using SQL

Cloud: FBDI, OTBI, Hyperion and Integrations using OICModulesGeneral Ledger (GL), Accounts Payable (AP), Accounts Receivables (AR), Fixed Assets (FA), Cash Management (CM)

Project Management Methodologies: AIM methodology, SDLC, Agile

Domain: Manufacturing, Distribution Center, Real Estate, Financial and Banking

Other Software Packages: MS Word, MS Excel, MS Access & MS Power Point

PROFESSIONAL EXPERIENCE

Confidential, NY

Oracle Cloud Functional Consultant

Responsibilities:

• Configured Oracle GL, AP, AR and Ebiz Tax and simultaneously created BR100 documentation for the setups. Prepared BR100, MD050, TE40, TE50, CRP execution. Prepared required documents under the AIM methodology
• User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications
• Defined Request Set and Interfaced the data to oracle via FAH by scheduling Interface Jobs from Legacy Systems
• Configured COA structure, Currency, Calendar, Ledger and attached Standard Accrual method developed in SLA
• Defined Descriptive Flex Fields as per Business requirements and configured Consolidation setups
• Involved in Create and assigning respective responsibilities to Users. Managing the dashboard. Participated in order to cash and procure to pay cycles
• Configured GL, AP, AR Monthly Cycle setups. Also involved in setup of Vendors, Invoices, Banks, Recurring Invoice
• Defined Financial system options, Financial options and Payable options, Payment Terms, supplier, Banks, Pay run, Document sequencing
• Configured INV ORG, Financial Options, Purchasing Options, JOBs, Employee, Buyers, Approval Groups and Categories. Configured Three-way Matching process
• Provided the Production Support of AR, FA, Cash Management, AP, GL modules
• Coordinated with the client by providing them onshore Functional support of their daily reported production issues
• Performed System integration testing and User Acceptance testing.
• Created test plan, test scripts and test scenarios for each module, which will be used by QA team and Users. Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules
• Attended Sprint planning and Sprint Retrospective meetings
• Reported the status for the current Sprint daily during Scrum meetings
• Resolved defects using reporting tool JIRA
• Documentation of Oracle Process Flows, Requirements and Mapping Documents, Custom Functional Solutions, Test Scenarios
• Supported the month end and quarter end activities to help the business with the close process
• Worked with Oracle support to open service requests - analyze the read me file, work with the DBA team to apply the patch to the patch instance, and work on a schedule of applying it to production

Confidential, MO

Oracle Financial Functional Consultant

Responsibilities

• As a Functional Consultant implemented the business flows including AR,e-Business Tax, AP, GL and Cash Management modules.
• Performed Requirement and Gap analysis.
• Worked on the setups ofe-Business Tax andVertexmodule - including the setups of Tax Rates, Tax Codes, Tax Regimes, Regime to Rate flow - for EMEA and US.
• Worked on the credit card integration to accept PayPal Payments and Visa Credit Card payments.
• Worked on the integration of Oracle e-Business Tax with Vertex module.
• Configurations and Setupsfor AP, AR, GL andCash Management modules
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
• PreparingBR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Worked on setting up theApproval Hierarchies in Purchasing Module.
• Worked on setting up the Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up the Line and Header transaction flex field in AR for Auto Invoice to work.
• Worked on the Auto Lock Box process in AR.
• I procurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment
• Pre upgradetesting andPost upgrade production live support.
• Support Production issueson a day to day basis including month end closure p1 issues
• Provide support/enhancements for the existingOracle and Discoverer Reports(acrossAP, FA, CM, and AR) and create new ones based on business requirements.
• Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex Field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
• Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.

Confidential, Topeka, KS

Oracle Financial Functional Consultant

Responsibilities

• As a Functional Consultant implemented the following modules:AP, AR,AGIS,GL, FA, Cash Management modules.
• Worked on the Functional mapping of data Conversions & Enhancements for AR, AP,FA,AGIS,Cash Managementand GL modules.
• I-Procurement - Worked on the Configuration of i-Procurement module including the setups of the requisition templates, setting up the Item Catalogs and Categories, Account Generator, etc.
• PreparingBR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• ConfiguredOracle GL, Cash Management, AP, AR,AGIS,OM and POfrom scratch and simultaneously created BR100 documentation for the setups.
• Setup the Approval Hierarchies in Oracle Purchasing module.
• Involved in troubleshooting issues on Auto Invoice Import Program.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• CompletedMulti-Org configuration by creating a new Organization Structure by creating new Business Group, Legal Entity, Ledgers (primary and secondary) and Operating Unit.
• Conducted Regression testing to examine the effects of a new Org on the previous Org.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful training to the users inGL, AP,AGIS,FA, Cash Management,INV and PO Modules.
• Created FSG Financial Reports critical to company’s business process.
• Worked on creation of MRC Setup by defining primary Set of Books and Reporting Set of Books in Oracle GL.

Confidential, Arvin, CA

Oracle Fusion Implementation Consultant

Responsibilities:

• Involved in complete life cycle configuration of Oracle GL, AP, AR, CM and simultaneously created BR100 documentation for the setups. Prepared required documents such as BR, MD TE and CRP under the AIM methodology
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules
• Configured Rollup Groups, Summary Accounts, Recurring Journals, Auto Reversals, Mass Allocation, Mixed Journals
• Involved in Create and assigning respective responsibilities to Users
• Configured GL, AP, AR Monthly Cycle setups. Also involved in setup of Vendors, Invoices, Banks, Recurring Invoice
• Setup of Vendors, Invoices, Banks, Recurring Invoice
• User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications
• Defined Financial system options, Financial options and Payable options, Payment Terms, supplier, Banks, Pay run, Document sequencing
• Configured INV ORG, Financial Options, Purchasing Options, JOBs, Employee, Buyers, Approval Groups and Categories
• Coordinated with the client by providing them onshore Functional support of their daily reported production issues
• Supported the month end and quarter end activities to help the business with the close process
• Documentation of Oracle Process Flows, Requirements and Mapping Documents, Custom Functional Solutions, Test Scenarios

Confidential

Functional Consultant & QA

Responsibilities:

• Involved in all life cycle stages of implementation including requirement gathering, solution design, GAP analysis, Setup and test plan cycle
• Worked majorly on GL and AP localization modules. Managing the Dashboard
• Involved in all life cycle stages of implementation including requirement gathering, solution design, Setup and test plan cycle
• Prepared test scripts TE-40 & TE-50 for testing purpose and participated in SIT (system Integration Testing) and UAT (User Acceptance Testing)
• Analyzed current legacy system and understand the uniqueness of customer business processes
• Design and maintain functional and project documentation
• Requirement gathering from client sources on the as-is process and document the same for upgrade.
• Worked on set-up document and was responsible for making the required setups relevant to financial modules.
• Involved in UAT plan and implementing all financial modules
• Identify resource requirements and participate in the staffing process for the project.
• Communicate the project progress and status to management.
• Troubleshooting support in order to address user needs and problems, so that customers applications are as efficient and effective as possible.
• Analyzed requirements of the client configuration and refined business scenario into a System’s Requirement
• Involved in building testing strategies and successfully implemented for the ERP system support.