SUMMARY:

• Over 10 Years of IT experience of which majority is in Oracle Financial Applications, Oracle Financial Functional consultant with expertise in Oracle EBS 11i/R12 and Oracle Fusion R9/R11.
• Comprehensive experience in Implementation, Upgrade, Production Support Projects specifically on Procure to Pay and Order to Cash process flows.
• Multiple project life cycles experience with Initiating, Planning, Business Analysis, Requirements Gathering including facilitate Workshops, Scope Verification & Validation, Alternatives Identification and Analysis, Use Case Creation, Functional Design Development, Process Improvement, Integration & User Acceptance Testing, Training, Go - live and Post-Implementation Support.
• Conducted requirements gathering workshops, prepared AS-IS (BP-040, RD-030), TO-BE (BP080, RD-011).
• Developed Functional Specification Documents (MD50, AN-100), Business Requirement Documents (BRDs), GAP Analysis, Solutions for the GAPs, and Conducted CRP, SIT, UAT sessions and user training sessions.
• Strong experience in financial suite including General Ledger (GL), Payables (AP), Receivables (AR), Cash Management (CM) and Fixed Assets (FA), E-Business Tax (eBTax), Purchasing (PO), Sub Ledger Accounting, Order Management(OM), Inventory, iExpense, iProcurement, and iSupplier.
• Concrete understanding and working knowledge on various core concepts of Oracle financials including and not limited to, Multi-Org architecture, Multiple Reporting Currencies, Trading Community Architecture, AP/AR Netting, Revenue Recognition, Consolidation revaluation and translation, Chart of Accounts, FSG, and Flex fields.
• Fetching data from Non-Oracle database via Financial Accounting Hub (FAH) to Oracle by defining Sub ledger Accounting setups using Accounting Method Builder: Event Model, JLT’s, JED’s, Sources, Application Accounting Definition, Mapping Sets, Sub ledger Lookups based on Business Requirements.
• Utilized AIM methodology for Business Flows in different phases of the project including Requirement Gathering, As-Is, To-Be, Solution Design, Conference Room Pilot (CRP), Build, Test, User Training, Data Migration, Production and Post-Production Support.
• Coordinated with Oracle Support, creating SRs, attending OWC sessions, providing 24X7 support for quick resolution of high prioritized issues.
• Strong Exposure in preparation of high-level functional design documents for Custom application development, Conversions, Interfaces & Reports.
• Experienced in identifying GAPS, providing Fit-Gap analysis and providing functional specifications to RICE components, and coordinate technical team for the timely deliverables.
• Worked as a Functional Tester and conducted CRP sessions to test complete end to end functionalities of several modules following the upgrade from Oracle 11i to R12.
• Worked in Onsite and Offshore model projects, coordinating and leading offshore team.
• Gained expertise in using the Oracle User Productivity Kit ( Confidential ) to record the test scripts and used these scripts to train the end users on R12 functionality.
• Helped the automation testing team to automate the test scripts in GL, AP, AR, CM, FA using Quick test Professional (QTP) & Unified Functional Testing (UFT) tools.
• Thoroughly involved in Defining Test Data requirements, Test Scripts, Test Strategy and Plan Documentation.
• Good understanding and experience using HP ALM for Defect Management (tracking, analyzing, and reporting).
• Understanding the Oracle Apps base Tables, Views & Workflows for the Troubleshooting and resolution of Production issues. Used SQL Developer and TOAD to extract the data from the backend database tables.
• Expertise in Conceptualizing & Implementation of various quality improvements by conducting audits for continual improvements in services.
• Excellent verbal and written communication skills, exhibited a consistent performance and ability to work as a team member or as an individual.
• A team player with exceptionally good organizational, analytical, training, troubleshooting, functional and interpersonal communication skill, a key team player.

TECHNICAL SKILLS:

ERP Systems: Oracle Applications (11i/R12), Fusion ERP Cloud (R9/R11) GL, AP, AR, PO, OM, Payments, iExpenses, iProcurement, iSupplier, Inventory, SLA/FAH, EB-Tax, AGIS,, CM, FA.

ERP Integrations: Kofax/170 Markview (Invoice Imaging Services), EDI Interfaces, XML Gateway, Oracle Supplier Network (OSN), Bank Integrations, EB-Tax Integrations with Vertex/Sabrix

Tools: FSG (Financial Statement Generator), Reports Manager, TOAD, Discoverer, Power BI.

Documentation and Methodologies: Oracle AIM and OUM, Confidential ; Proficient on Waterfall, Agile and Scrum Master

Testing: Conducted SIT, CRP, Performance and UAT Testing Routines; HP Quality Center/ALM

AREAS OF WORK:

• End to End Configuration of GL Setups of Legal Entity, Primary Ledger, Secondary Ledger, Operating Unit and Reporting Currency
• Created Custom ADI Templates and Integrators to load data into GL through FAH module
• Detailed understanding of Allocations and Configured cost pools and Mass allocations
• Extensively worked on the data security features by configuring Profile Options, CV Rules, Security rules, Data Access Sets, Definition Access Sets and Responsibilities.
• Supported End Users with Monthly reconciliations, periodic reversal configuration, Period end procedures and Journal reclassifications.
• Performed end to End Configurations of Oracle Payables and Payments modules from OU setup, defining Payables and Financial options, configuring approval hierarchies, Discount terms, Payment Methods, Profiles and others as per the business requirements.
• Configured iExpenses and its integration with Oracle Payables
• Have extensively worked on Support engagements resolving month end and Year end issues, analyzing and applying Data Fixes.
• Have performed advanced configurations related to 1099s, Withholding Taxes, Custom Use Tax, iSupplier Integrations, Third party payments and AP/AR netting.
• Configured Imaging services using Kofax.
• Define Customer Profiles, System Options, Transaction Types, Sources, Accounting Rules
• Involved in setup for Auto Accounting Rules, Receipt Sources, Receipt Classes, Banks, Bank Charges, Lock Boxes, Transmission Formats, and Aging Buckets. Defined Parameters for Item Validation Organization &
• Customer Relationship in OM, System Options, Location Flex field, Auto Accounting, Transaction Sources, Transaction Types, Receivable Activities, Remittance Banks, Receipt Class, Receipt Sources, Customer & Sites, Remit to Address, System profiles
• Extensively worked on Revenue recognition and third party integrations.
• Performed end-to-end implementation of Fixed Assets for various corporate and Tax books including and not limited to defining category, location, and asset key flex fields
• Supported users in analyzing the cost differences between General Ledger and Fixed assets system
• Assisted client super user in capturing business requirements for iProcrument, iSupplier and Purchasing modules and completed setups for the same
• Created training documentation and provided user training for buyers and suppliers users of iSupplier planning modules
• Configured custom Approval Groups and configured AME for both requisition/PO approval workflows. Designed custom extensions around account generator workflow to in corporate business needs.
• Implemented oracle EBTax for US Sales and Use Tax calculation, configuring the Regime-to-Rate flows, Geography hierarchy and custom tax rules.
• Created new Tax rules and modified the existing Tax rules and Tax formulas
• Have extensively worked on implementations of EB-Tax with Vertex/Sabrix Integrations.
• Integrated third party applications into Oracle using FAH by building AAD using both Pass-Through and complete event model.
• Designed Custom Web ADI templates for Journal Import through FAH.
• Configured Inter/Intra Company Transactions as per client requirement.
• Created legal entities and operating unit and defined relationships for intercompany transactions.
• Party Merge
• Account Merge

PROFESSIONAL EXPERIENCE:

Confidential, Eden Prairie, MN

Oracle Functional Business Analyst

Responsibilities:

• Work with business users, stakeholders and gather business requirements and provide solution for Customer/Account merge so that external customers and internal stakeholders find it easy to do business with Confidential Technologies.
• Work with the Business team to baseline the 'As Is' Process and derive 'To Be' flow. Identified gaps & put collaborative effort with the Technical team to address the same through Technical Specification.
• Create Use Cases for Customer/Account merge initiative.
• Design solution for customer merge and document the requirements (AN-100) using AIM methodology.
• Solution should work flawlessly for business continuation which includes Ordering, Pricing, shipping, Invoicing, RMAs, Repair, Credit Management, and collections.
• Active participant in designing solution for third party applications integrating with oracle.
• Develop and deliver PowerPoint presentations along with Proof-of-Concepts to re-engineer the business processes impacted by customer account merge.
• Designed custom Customer Maintenance form, Order entry form and documented the design (DS.140).
• Worked with technical team in developing Custom Customer Registration and Order Entry forms.
• Developed training material for end user’s New customer maintenance form and trained super/end users.
• Pricing Business Requirement Study and designed / documented Functional Specification.
• Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
• Lead System integrated testing (SIT) and User acceptance testing (UAT).
• Assisted Business for Business Acceptance Testing and obtain Sign off.

Confidential, Germantown, MD

Fusion Functional Consultant

Responsibilities:

• Created functional requirements as an input to application design for migrating applications from Oracle EBS to Oracle Fusion Applications R11.
• Configured the Cloud financials Application based on client requirements.
• Configured fusion Payables - Supplier Model, Data Role, Create Payment Term, manage invoice options and payment options.
• Configured fusion payments - payables - Payments Activities, Payment System, Payments and submitting a payment process request.
• Assigned Business Unit (BU) for multiple entities in fusion R11 instance.
• Modified and analyzed various Process flow diagrams to in corporate business logic for the newly implemented Oracle Fusion financials.
• Responsible for data conversion in fusion application.
• Enabled Configured and Defined Offerings, Options and Features for Oracle Fusion Financials and involved in Fusion Functional Setup Manager (FSM).
• Configured common options for Payables & iProcurement and configured Invoice Options and Payment Options as per the design.
• Performed data mapping for various conversions and prepared spreadsheets for uploading data.
• Involved in user and project creation and assigned roles and projects to the users.
• Involved in making the detailed Oracle Financials Test Plan regarding the scope and focus of the testing.
• Deployed Chart of Accounts (COA) structure and assigned segment labels to the segments.
• Conducted Workshops for the new fusion instance training users and Solution demos for new features and Prepared Functional Design documents for several Extensions and Reports.
• Conducted testing for all business components and business processes. Supported End User Testing and Training activities.
• Developed test scripts for testing various modules and their integration including AP, AR, GL, FA, iProcurement.
• Designed and Documented requirements for various reports like Account Analysis, Fusion Accounting and Invoice Register in R12 and worked through testing and deploying them into Production.
• Designed and deployed solutions for import and reconciliation of bank statement, and Bank file integration/mapping.
• Worked on document repository tools like e-Room, Web Center, Clear Quest, Clear Case.
• Worked on FR Studio and Smart view.
• Closely interacted and assisted with users during UAT sessions in executing process documents.
• Effectively worked with Oracle support team to resolve product related issues and bugs.
• Configuration and modification of Approval processes in Business Process Management.
• Coordinating with other team members for quick issue resolutions.
• Solving daily and month end issues in Procure-to-Pay cycle, GL
• Experience in month end closures, revenue recognition, inventory & COGS accounting.
• Proactively involved in identifying and troubleshooting the data and configuration related issues. Coordinated with various Business Stake Holders and conducted and participated in status meetings.

Environment : Fusion Financials R11 (GL, AP, PO, AR, FA, iProcurement, iSupplier), Smart View, Financial Reporting Studio.

Confidential, Marlborough, MA

Sr. Oracle Financials Functional Analyst

Responsibilities :

• Studying the requirements, performing risk analysis and mapping the business processes.
• Analyze the gaps and conduct client interviews to complete the business process analysis.
• Prepare the business requirements documents, performed Gap analysis and recommend the necessary customizations.
• Configuring the modules, designing reports and add-ons and coordinating with the technical team to monitor development and implementation progress.
• Responsible for the documentation (BR.030 -Business Requirements Mapping, BR.100 -Application Setup)
• Responsible for solving technical and functional issues related to GL, AP, AR, FA, iExpense modules. Working as single point of contact for Finance module working directly with Application Leads and Super Users.
• Raise service request with Oracle technical support and coordinate in speedy resolution of high prioritize issues.
• Provide functional impact analysis based on the nature of the issue and coordinate with Business users for manual work around solutions wherever possible.
• Coordinate onsite and offshore technical support team on proposed new custom objects developments, testing, documentation, and migration to production instance.
• Update expense report templates, and distribution sets.
• Develop approval rules based on invoice amount for the following transaction type Payables Invoice Approval using Oracle Approval Management (AME) and configured action types, actions and set up the profile option to work for Payables only and the required setup through Payables Options form.
• Created organizations, inventory items, catalog RFQ, got approval from supplier in Procure to Pay (P2P) cycle and customized the Purchase requisition and auto creation of a standard purchase order based on a quote and generated receipt.
• Designed, tested and delivered custom reports in GL: Journal Batch Summary Report, Account Analysis Report and AP: Invoice on Hold Report, Supplier Paid Invoice History Report.
• Identify the patches that need to be applied to prepare the Release 12.1.3 environment for implementing Oracle mobile expenses.
• Prepare Visio Process diagrams for AS IS and To Be Scenarios.
• Involved in Functional, Regression and UAT Testing.
• Performed extensive defect fixing and support during the client pre-production testing phase, identifying issues and tracking them through HP quality center.
• Provided Period Close Support for all the financial modules.
• Conduct numerous business meetings to understand and analyze the issues.
• Designing of user-manuals for the modules and training the end users

Confidential, Raleigh, NC

Oracle Functional Consultant

Responsibilities:

• Providing post production support to the business users.
• Track and update production issues in the issue tracker with proposed solutions.
• As part of the Quarterly Release Team - Responsible for designing and implementing various AP/iExpense enhancements in each quarterly release covering all stages from Requirement gathering, Business Scenarios and Rules Document (BSR)
• Worked as liaison between technical staff and users. Was also responsible for interdepartmental coordination between the various teams involved.
• Participated in the Conference Room Pilot (CRP) sessions to interact with users to analyze the business process and identify the gaps.
• Gathered business requirements, identified gaps and worked with development team on solutions to bridge gaps.
• Worked with the Business team to baseline the 'AS- IS' Process and derive 'TO- BE' flow.
• Defined the Functional specifications for setups and reports and transformed the specifications to the Technical Team.
• Responsible for setup, design and testing the purchasing Position Hierarchy for routing PO Approvals as required for the business.
• Provided support on purchasing issues like PO's stuck in workflows & maintenance of purchasing hierarchies.
• PO matching options, invoice tolerances, distribution options, terms, holds, etc.
• PO setup and matching options with invoices.
• Actively involved in Mobile expense implementation; Requirement gathering, gap analysis, end to end testing before and after implementation.
• Involved in iExpense customization and custom report development efforts.
• Setup Currencies, Exchange Rates, Organization's Set of Books, Bank Accounts.
• Setup/Update all the banks, bank branches and bank account for all the countries.
• Involved in Supplier maintenance: Supplier creation, duplicate supplier clean-up and supplier bank setup/update.
• Helped the business in the month end closing process, closing and opening of new periods.
• Designed, tested and delivered various custom reports as per the Client specific requirement, including Invoice Register, Payment register Summary and Detail reports, Rejected Invoices register, etc.
• Developed functional documents for technical customizations in AP, iExpense, Mobile expense, PO, HRMS Modules.
• Worked as member of Support Team for modules iExpense, AP, GL, PO, AR and CM.
• Provided extensive production support of Oracle financials, including following up SR's with Oracle Meta link.
• Analysis and Resolution of issues tagged as Severity3/2/1. Creation and execution of test scripts for the issue ticket.
• Identified SR's as GAP's that needed customization and reviewed with management with GAP analysis document.
• Involved in applying Oracle Critical Patch Update (Oracle CPU) to minimize issues. Conducted patch analysis to estimate the possible impact of Oracle CPU.
• Implemented and delivered new Oracle functionalities with user interaction, performing systems and unit testing.
• Created test scenarios and developed test scripts for SIT, UAT.
• Performed end to end testing of all the above modules and documented the results in TE040.
• Assisted Business for Business Acceptance Testing and obtain Sign off.
• Developed material for the workshop sessions and other functional meetings.
• Created test scripts for new functionalities and provided User training on one to one basis and also in group mode.
• Trained finance staff on General Ledger using Confidential (User Productivity Kit).
• Conducted knowledge sharing sessions for the team members in the functional areas of known modules.

Environment: Oracle EBS R12.1.3 (AP, iExpense, Mobile Expense, FA, PO, GL, CM, OTL) AIM Documentation, Toad, SQL, Configuration and Testing in R12, Support & Testing.

Confidential, SFO, CA

Sr. EBS Financial Analyst

Responsibilities:

• Involved in business process study and creating business process maps using Visio for Oracle E-Business Suite GL, AP, PO and AR modules during implementation.
• Was part of team involved in the cut over planning and execution including finalizing the processes, scenarios and ways to handle exceptions while executing and monitoring of cut over activities.
• Created intercompany Transaction, Consolidation, Elimination entries setups and configurations.
• Created Master/Detail Budgets, Mass Allocations and Summary Templates. Designed FSG Report for Budget Balance, Actual Balance and Funds Available.
• Worked on AR setups - defining the Auto Invoice options, accounting and invoicing rules, revenue recognition, auto lock box process, receipt classes, receipt sources, bank setups, transaction types, etc.
• Utilized Supplier third party relationships to clear payments for Supplier Levy. Designed Custom reports based out of TCA hierarchy to obtain the relationship and third party payment report.
• Defined the Accounting Rules and Invoicing Rules in oracle AR module to drive deferred revenue as well as upfront revenue.
• Worked on the setups of e-Business Tax module - including the setups of Tax Rates, Tax Codes, Tax Regimes, and Regime to Rate flow - for EMEA and US.
• Oracle Solution Design for Ledgers and Multi-Org structure and have given a POC for Multi-LE to OU structure.
• Worked on the setups of AP Module - setting up financial options, payable Options, system options, pay groups, discount terms, AME rules, etc.,
• Configured payments module including Payment formats, custom payment methods, payment documents, Payment Instruction Formats, Payment Process Profiles, PPR Templates, etc.,
• Conducted Conference Room Pilots (CRP) sessions showcasing the proposed solutions and validating the business requirements.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules. Extensively worked on HP Quality Center for creating test scripts and tracking test results.
• Fixing small code changes as of when raised during UAT and during post production support.
• Performed effort estimation for design and development for data fixes, code fixes and change requests.
• Support Production issues on a day to day basis including month end closure priority issues.
• Performed both validation and technical IT General controls testing for SOX & GAP to make the test documentation meet Client’s compliance regulatory norms.

Environment: Oracle Apps Release 12.1.3 (AR, AP, GL, FA, PO, Cash Management, iExpense, e-Business Tax, Sub Ledger Accounting, Oracle Payments, AME, AOL), TOAD, Workflow Administration, Reports, Forms Personalization.

Confidential, Greenwich, CT

Sr. Oracle Specialist

Responsibilities:

• Implemented Oracle financial accounting hub (FAH) (R12.1.2) to integrate 36 legacy source systems into oracle EBS, including and not limited to People soft Treasury, HRMS, JD Edwards, Oracle Revenue Reconciliations Systems, etc.,
• Gathered and created business requirements from finance users for the mapping of legacy chart of accounts (COA) to the enterprise COA.
• As an Oracle EBS Functional Analyst, worked on modules like FA, GL, AP, AR, CM, E-Business Tax, P2P and O2C in R12 environment.
• Setup Tax Authority in E-Business Tax module while defining Withholding Tax structure.
• Testing the Document Management, Integration and Conversion of data from other (Siebel) legacy systems into Oracle EBS and vice-versa.
• Defined The Following: KFF- Accounting, Category, and Location Flex-fields, Fiscal Years, Asset Categories, Calendar Periods, System Controls, Asset Security by Books, Prorate convention, Corporate Book Controls, Salvage limits and locations, ADI (excel) template to create Mass Additions in FA.
• Setting up of customized Account derivation rules (ADR) for legacy source system requirements into Oracle Receivables.
• Helped in set up of customized programs to allow the loading and auto reconciliation of the bank statements in CM.
• Set up a Bank reconciliation process in Oracle Cash Management and Accounts Payable.
• Validated Customer Master Data Conversion, utilizing TCA APIs for Customer accounts, sites, site profiles, profile amounts and other entities of MDM.
• Collaborated with the technical team to translate requirements into technical design.
• Facilitated the development of custom Oracle XML publisher reports by creating Functional Specification, Testing and Deployment.
• Unit and functional testing the changes and working with business partners to ensure full system testing is complete
• Performed Regression testing of any changes made in Oracle Customizations. Prepared & maintained Traceability matrix to keep track of all the test scripts, test scenarios, test cases to make the auditors and business’ work easy.
• Performing the Quality Analysis of the newly developed RICE Objects by preparing the Test Cases and Scenarios for the Integration & Document Management between Oracle EBS and other Legacy Systems.

Environment: Oracle EBS R12.1.3 (FAH/XLA, EBTAX, AP, GL, AR, CM, PO), Configuration, Support & Testing of Conversions & Integration of Business Objects from external legacy systems into Oracle EBS and vice-versa.

Confidential, Lake Forest, CA

Oracle EBS SME

Responsibilities:

• Worked as an Oracle Financial Functional Analyst and a Test lead for onsite, offshore team. Involved in configuration and testing of AR, AP, GL, CM, FA, E-Business Tax, SLA, PO, and P2P, O2C.
• Provided support for GL, AP, AR, FA and CM modules.
• Gained expertise in using the Oracle user training tool called User Productivity Kit ( Confidential ). Used this tool to record the end to end functionalities of the above mentioned modules.
• Experienced in writing and documenting the test scripts, test scenarios and test cases for all the core financial modules.
• Implemented Location based tax for Accounts Payables & Accounts Receivables through E-Business Tax.
• Sub-ledger accounting for journals by events to derive mapped accounts by rules defined.
• Demonstrated/Trained the users on R12 functionalities.
• Conducted CRP (Conference Room Pilot) sessions to test the complete functionalities of the above mentioned modules before going into the production.
• Worked closely with the client BA’s of respective functional areas to understand the client business process, setups, working process and their timelines.
• Tested, documented and recorded (using Confidential ) the customization of client’s Order Management Interface with several third party vendors.
• Tested, documented and recorded the Finance Bank Interfaces of several Operating Units across the globe, with their respective Banks.
• In AGIS, defined Intercompany Order Management system and performed intercompany shipping and billing. Tested and documented the client’s intercompany orders, shipping and invoicing.
• Tested FSG Reports, using multi-currency features including foreign currencies for multi org structures.
• Performed the testing of Sub ledger Accounting Reports like Sub ledger Period-Close Report, Journal Entries report, Third Party Balances Report etc.
• Used Agile Software Development Life Cycle Methodology tool to manage projects, document different processes, promote development, collaborate with the customer throughout the life-cycle of the project.

Environment: Oracle EBS 11i/R12(AP, GL, PO, AR, FA, Cash Management, iExpense, iProcurement, iSupplier, AOL). Configuration and Testing in R12

Confidential

Sr. Oracle BA

Responsibilities:

• Analyze design, customize, configure and test implement detailed Oracle applications and modules including GL, AP, AR, CM, FA, PO, P2P & O2C.
• Participated in the Conference Room Pilot sessions to interact with users to analyze the business process and identify the gaps.
• Participated and documented the requirement gathering sessions and analyzed the impact of the changes in the requirements.
• Defined the Functional specifications for setups and reports and transformed the specifications to the Technical Team.
• Account Receivables (AR): Setups for TCA Architecture, Customer Profiles, System Options, Transaction Types, Sources, Accounting Rules, Auto accounting Rules, Auto invoice Line Ordering Rules, Grouping Rules, Receipt Sources, Receipt Classes, Banks, Bank Charges, Lock Boxes, Transmission Formats, Aging Buckets. Defined Parameters for Item Validation Organization & Customer Relationship in OM, System Options, Location Flex field, Auto Accounting, Transaction Sources, Transaction Types, Receivable Activities, Remittance Banks, Receipt Class, Receipt Sources, Customer & Sites, Remit to Address, System profiles.
• Helped the technical team in the customer conversion, Open AR invoices and receipts conversion.
• Have setup the system to allow the business to create the Automatic Receipts and send the Confidential files to the bank.
• Have setup the system to create manual receipts which are not applied to the invoices and send the Confidential file for these receipts to the bank using a custom program.
• Defined the Funds Capture Setup to process the Confidential payments.
• Setup Taxes using E-Business Tax module.
• Helped the technical team in the supplier conversion, Open AP invoices and payments conversion.
• Used E-Business Tax module to setup taxes for Payables.
• Setup Currencies, Exchange Rates, Organization's, Set of Books, Bank Accounts.
• Setup all the banks, bank branches and bank account for all the countries.
• Set up bank transaction codes for the bank accounts for BAI and NSF files and assign GL Accounts to the bank accounts.
• Set up cash management for automatic loading and auto reconciliation of all the bank statements.
• Implementation of Fixed Assets, involved in requirements gathering sessions with the client.
• Led the Conference Room Pilots for the site implementation.
• Preparation of Functional Test Scenarios & Test cases for Fixed Assets.
• Assistance to SIT, UAT, Training and Production Support to End User.

Environment: Upgrade from 11.5.10.2 /R12.0.6 (AR, AP, GL, FA, Cash Management, i-Expense, e-Business Tax, Sub Ledger Accounting, Oracle Payments), AIM Documentation, Toad, SQL, Interfaces, XML Publisher, Reports.

Confidential

Oracle Applications Consultant

Responsibilities:

• Analyzed scope available features and Business requirements.
• Translated business user requirements into functional and technical design documents/specifications.
• Worked on the functional design for customizations, in Processes, Programs, and Reports.
• Worked on customizing as well as developing new Workflow processes.
• Designed customized solution for Oracle Fixed Assets to resolve depreciation issues.
• Implemented iExpense in the client TEST environment for user training and testing purposes.
• Resolved issues after implementing iExpense by customizing the process flow of Expense report generation, and rule tracking.
• Integrated iExpense with AP for automatic invoice generation and processing.
• Performed all necessary setups for Corporate Credit Card transactions download and generating Expense reports on timely basis, for fully automating the employee expense through credit cards.
• Involved in the iExpense implementation, designing and performing a major modification to the AMEX daily inbound interface to handle multiple files on the same day.
• Interacted with development team for developing Custom Expense application, which transfers third party employee expense reports that are exported as flat file and in approved status to Project accounting Interface tables. The Custom code also validates and finally loads the transactions as expenditures in PA.
• Defined the Funds Disbursement Setup to process the Confidential payments.
• Involved in the authoring and maintenance of documents like BR100, MD050, TE040 and BF45 as part of project deliverables & Preparing Business Process Flow diagrams with the use of MS-Visio.
• Configuration of Production, SIT, UAT, instance & Loading of Data with the use of Data Loader.
• Worked with end users to document the business processes & functional requirements also providing them with training materials
• Coordinated with client through Conference calls and WEBEX sessions to get the requirements and also coordinating with the technical team for fixing the issues for proper deliverables to the client.
• Provided KT sessions to the testing and the technical teams

Environment: Oracle EBS 11.5.10.2 (AR, AP, GL, FA, Cash Management, i-Expense, e-Business Tax, Sub Ledger Accounting, Oracle Payments)

Confidential

Oracle Business Analyst

Responsibilities:

• Prepared Central GL setup document applicable for more than 110 legal entities / sites and configured the same in new Oracle instance
• Prepared GL setup documents for assigned sites and did setups in the instance using Data loader & Oracle Web ADI tools.
• Validated Clearing Account balances, Sub ledger to GL balances and Closing the books in Oracle.
• Designed Set of Books, built Chart of Accounts, set up Cross-Validation Rules, Flex field Segments, Journal Sources & Categories, Translation of balances from subsidiary units for reporting purposes and Consolidation, System Controls, Profile Options.
• Created the FSG reports for the balance sheet and the income statement.
• Resolving the issues by SR’s raised during the Project implementation life cycle.
• Attended and conducted Oracle Apps knowledge sharing sessions in modules GL, AP, AR, FA & CM.

Environment: Oracle Application 11.5.10 (GL, AP, AR, CM & FA), Windows XP, Data loader, MS Office Tools