SUMMARY:

• Overall 9+ years of extensive professional experience as an Oracle Ebiz Business analyst, ETL tester and Quality Assurance SME
• Well Experience in Networking and Telecommunication ERP solution and having the expertise in other Functional testing domains like quality management System and Decision guiding Systems.
• Implementation and Support of various financial modules including General Ledger, Payables, Receivables, Purchasing, Cash Management, Fixed Assets, E - Business Tax,Inventory, Projects, Cost Accounting Grants, TCA, i-Supplier and i-Expense.
• Involved in all standards ERP SDLC activities like Functional Testing, System Integration Testing, User Acceptance Testing, Preparation of Training material, and conducting actual User testing
• Expertise in Testing the Order to Cash life cycle(O2C), Procure to Pay (P2P) and also have the Knowledge on Supply chain Management
• Expertise in manual and automation testing on Web base applications and oracle application using the tools like QTP,Oracle application testing suite(OATS)
• Expertise in Jenkins and GIT,Selinum IDE,GRID
• Multiple project life cycles experience with Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering including facilitate Workshops, Scope Verification & Validation, Alternatives Identification and Analysis, Functional Design Development, Integration & User Acceptance Testing, Training, Cut off, Go-live and Post-Implementation Support.
• Good Knowledge on ETL testing and Business rules validations using SQL
• Involved in reviewing the Functional specifications Document with Functional team members in Oracle ERP
• Experience in using various tools like TOAD, SQL*PLUS for writing queries and running bug fixing script which is given Oracle support center
• Special expertise in implementation of self-service modules including, Internet Expenses, i-Supplier, i-Receivables and i-Procurement.
• Implemented Financial Analysis Reporting by defining FSG Reports and Oracle Discoverer Business Areas and Workbooks.
• Expertise in test management using various tools like Quality Center, Rally, Jira and Testlog
• Having Expertise in Various SDLC models like waterfall, Spiral and incremental
• Worked as PMO using agile methodology and waterfall Model.
• Well versed in preparing test scenarios and test cases from user stories and functional specification Documents
• Having good experience in effort estimation tool and on various quality metrics tools
• Having 5+ years of experience as functional SME and Green Field trainer in Accenture services PVT limted
• Excellent talent to quickly adapt to different project needs and showed successful results
• Ability to learn quickly, high motivation, good communication and strong Team Player.
• Extensive Knowledge on Version Control, Migration and Ticketing Software.
• Proficient is documenting Specifications following AIM Methodology. Authored MD50, MD120, BR100, CV40 documents.
• Excellent communication skills and leadership qualities with analytical problem solving abilities including playing vital role in coordinating multiple business meetings and following up on open item.
• Experience interacting and driving internal product teams, the user community, IT Operations and Executives; Experience with Functional Teams with a Strong focus on Group dynamics
• Experience with round-trip business methods using Function-point and Use Case estimation methods using well-defined workflow (Project and Initiatives proposal presentation techniques)

TECHNICAL SKILLS:

ERP Applications: Oracle Applications R12 (12.1.3/12.0.6 ), 11i (11.5.10.2/11.5.8/11.0.3 ) GL, AP, AR, CM, FA, PO, i-Procurement, i-Supplier, EB Tax, OM, INV, Advanced Pricing, projects, Cost Accounting, Shipping, i-Expenses, AOL PMO, Green field trainer, Mobile apps testing, embedded system testing.

Operating System: Windows XP, Vista, 7, 10, Android

Database: Oracle 10g, 11g, R12

Programming: SQL

Others: OBIEE Testing, Toad, Rally, Informatica 9, quality center,Test log,OATS,Selinium,QTP

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Oracle Applications Financial Functional Analyst

Responsibilities:

• End to end Implementation of Oracle Payables, Receivables, Order Management, Purchasing, Cash Management.
• Involved in the Supplier list, sourcing rules and defining the supplier conversion functional document preparation in purchasing module.
• Carrying out requirement gathering, requirement analysis, high level and granular level mapping, gap analysis, setups, functional and technical extensions and modifications, unit testing, stress testing, integration testing, and CRP ’s related to the split scenario and post production data cleansing.
• Configured Security and Cross validation rules to restrict the usage of departments and companies belonging to one Company by the other in sub ledger transactions.
• Prepared BR100 Application setup for Payables, Receivables, Order Management, Payments and Ecommerce Gateway.
• Worked with customers to gather requirements and setup Customer workbenches, transaction types, Transaction Sources, Auto accounting, SLA, Revenue Recognition policy, bank setups, Payment methods, Approval limits, Receipt workbench, month end closing for AR and bank reconciliation.
• Testing the business process of the RTS(Return To Supplier) Process and Debit memo creation in the procurement to pay cycle.
• Created accounting flex field segment values, creating new / updating the existing cross validation rules and security rule
• Involved in requirement gathering and authored MD 50 documents for the various reports and Interfaces which includes AR Invoice and AP invoice Interface.
• Designed, documented and implemented Interface programs to import ITEMS from a legacy system into Oracle Inventory .
• Prepared CV040 for Suppliers and supplier banks conversion from Macola to Oracle Account Payables.
• Implemented the 810 inbound invoices and the 820 outbound payments for supplier payments and all employees including expense reimbursement. Extensive experience setting transactions and troubleshooting issues in Ecommerce gateway and end to end process of implementing 820 and 81 0 EDI transactions.
• Configured the Cash management module for GL Accounts Mapping, setting up transaction codes, BAI2 file upload, Customization of out file as per Confidential requirements, automatic transmission and import of bank files.
• Configured banks, bank accounts and documents for different needs like AP processing.
• Defined bank, Receipt source, payment method, and Auto lockbox.
• Coordinating with Offshore development and Functional Team to resolve Issues.
• Worked on AP/AR Netting, ERS Transactions Setups and related Issues.
• Designed and implemented Back to Back Sales Order Process, integrating with Purchasing and customizing various forms and interface process as per business requirement.
• Designed and configured Custom extension using Order Management processing constraints to restrict cancellation or updates of a Sales Order once the PO is created for a Back to Back process.
• Involved in configuration of CRP2, SIT1, SIT2 and test instance.
• Prepared TE040 Documents, which are used to test various aspects of application functionality.
• Involved in defect fixing of custom workflows like OM export compliance, Return Merchandise notification and credit management.
• Involved in the Bridge Calls during Cut-over/ Go-live phase.

Environment: Oracle EBS R12.1.1/R12.1.3 (Accounts Payables, Cash Management, Accounts Receivables, Order Management, Purchasing, i-Expenses, EB-TAX, SLA, Forms Personalization).

Confidential

Applications Financial Functional Consultant

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.
• Defined the Functional specifications for setups and reports and transformed the specifications to the Technical Team.
• Worked with the business architect and other planners to assess current capabilities and identify high-level requirements.
• 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 Ach files to the bank.
• Have setup the system to create manual receipts which are not applied to the invoices and send the ACH file for these receipts to the bank using a custom program.
• Defined the Funds Capture Setup to process the ACH payments.
• Helped the business in the month end closing process, closing and opening of new periods.
• Setup Taxes using E-Business Tax module.
• Helped the technical team in the supplier conversion, Open AP invoices and payments conversion.
• Helped the business in the month end closing process, close and open the new periods.
• 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.
• Convert the requirements in to AIM Documents: BR100, BR110 and BR30.
• 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: Oracle EBS R12.1.3 (AP, GL, PO, AR, FA, Cash Management, i-Expense, i-Procurement, i-Supplier, Sourcing, AOL ). Configuration and Testing in R12

Confidential

Oracle Applications Financial Functional Consultant.

Responsibilities:

• Preparing Business Requirement Documents (BRD) with the business rules associated to archive the daily transactional data across different Operating.
• Preparing business test scripts with the business rules associated with it to test the data integrity of archived data.
• Worked on the entire Order to Cash Flow.
• Performed all the setups for As a Functional Consultant implemented the Order to Cash Business flows including OM, AR, AP, GL, e-Business Tax, INV and Pricing
• Performed Requirement and Gap analysis.
• Configurations and Setups for AR, e-Business Tax, GL and AP modules
• Worked on the setup of Revenue Recognition in AR module.
• Setup of Accounting and Invoicing rules in AR module
• Defined the Auto Lock Box process in AR module
• Defined the Auto invoice process in AR module
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
• Preparing BR100, 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 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.
• Pre upgrade testing and Post upgrade production live support.
• Support Production issues on a day to day basis including month end closure p1 issues
• Implementation and support of Accounts Receivables and Account Payable Module
• Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.
• Worked on the Revenue Recognition Process in Oracle AR module.
• Worked with the Business team to baseline the ‘As Is’ Process and derive ‘To Be’ flow.
• Worked on the entire upgrade strategy to upgrade the application footprint from11.5.9/ R12.0.6
• Pricing Business Requirement Study and designed / documented Functional Specification.
• Identification of Gap & put collaborative effort with the Technical team to address the same through Technical Specification.
• Flow Testing for SCM Modules (AR, AP, GL, OM, Cash Management, INV, PO) to make sure flow is working without any issues.
• Conducting Pre Project Review & Post Project Review.
• Providing Post Implementation support
• Worked for the Category & Mapping data migration to meet the go alive deadline.
• Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
• Assisted Business for Business Acceptance Testing and obtain Sign off.

Environment: Oracle EBS 11.5.9/ R12.1.1 (Order to Cash Business flows including OM, AR, AP, GL, e-Business Tax, INV and Pricing), Oracle 10g, (SQL, PL/SQL), TOAD.

Oracle Applications Financial Functional Financial

Responsibilities:

• Played significant role in the Upgrade Patch set analysis in identifying the impacted components.
• Interacted with Oracle to get the issues addresses by logging SRs.
• Developed Training Material for OM and AR modules and prepared impact analysis for critical issues.
• Tested the revised Customer Interface that takes the new Customer Type into account by enabling to load customer data for both Organizations and Individuals.
• Responsible for preparation of test scripts and monitoring UAT.
• Extensively worked on Month end and Year end reconciliations for closure of sub ledger modules - AR and AP.
• Worked on HP Quality Center to create Test Scripts, Test Cases and testing various Functional activities.
• Responsible for Retrofitting and re-building custom components post execution of standard features testing.
• Involved in the Bridge Calls during Cut-over/ Go-live phase.

Environment: Oracle EBS 11.5.10.2 (GL, AP, OM, AR, CM, FA)

Confidential

Oracle Applications Financial Functional Consultant

Responsibilities:

• Worked as member of Support Team for modules GL, AP, AR and CM
• Reviewed daily support SR’s, co-coordinated with users and resolved issues
• Identified SR’s as GAP’s that needed customization and reviewed with management with GAP analysis document
• Developed functional documents for technical customizations in OM, INV, PO and AR modules.
• Implemented and delivered new Oracle functionalities with user interaction, performing systems and unit testing.
• Trained users and Created test scripts for new functionalities
• Provided User training on one to one basis and also in group mode
• Updated Value sets’ values for COA. Defined cross validation rules & security rules
• Designed Financial Reports using Financial Statement Generator (FSG) tool
• Set up of Parent & Child relations, Rollup Groups and summary templates
• Workflow Purchasing integrates with Oracle Workflow technology to create standard purchase orders or blanket releases automatically from Approved requisition lines .
• PO matching options, invoice tolerances, distribution options, terms, holds, etc.
• PO setup and matching options with invoices.
• Defined the Aliases, Set up of Recurring Journals, Stat Journals & Mass Allocation Journals .
• Helped in Inventory management module for costing problem . Inventory valuation report was not tying with General Ledger Inventory account. Cost group was the problem and physical inventory was not updating the quantity in the right

Environment: Oracle EBS R12.0.6 (Accounts Receivable, Accounts Payable, General Ledger, Purchase Order, OM), SQL, PLSQL, Reports, Forms, Discoverer.

Oracle Financial Business Analyst

Responsibilities:

• As a Business Analyst for the Oracle E-Business suite Implementation, worked on
• Order to Cash (O2C) processes and Implemented Oracle Order Management,
• Shipping and Inventory and also in the implementing Fixed Assets.
• Preparation of Project Plan and Sign off from Senior Management and Client
• Management
• Daily reporting on the deliverables for the Senior Management and Client
• Enabled Automated Defaulting of customer and item information on the sales orders, which helped the customer to reduce manual data entry problem and improving productivity during sales order and RMA creation.
• Implemented Firm/ Un-firm feature to prevent sales order delivery lines changes.
• Enabled manual and automatic Delivery creation to group multiple sales order lines onto a single delivery.
• Enabled partial order fulfillment through Split lines feature. This was done by splitting
• Provided a solution to Development and support shortage of items on a delivery and
• Provided a solution to fulfill the customer orders by shipping the items from the supplier directly to the customer, through the Drop Ship Process, eliminating the inventory management costs with no upfront inventory and ensuring positive cash flow.
• Implemented feature based Order Configurator process that enables order processing of CTO (Configure to Order) and ATO (Assemble to Order) type of products including the manufacturing of the configured products.
• Implemented Vendor Managed Inventory (VMI) where the suppliers are responsible for replenishing the stocks by monitoring the stock levels.
• Defined pick slip grouping rules based on varied grouping criteria to allow smooth picking process.
• Defined release sequence rules to specify the release criteria based on order number, outstanding invoice value, scheduled date departure date and shipment priority.
• Enabled automatic or manual attachments of documents on sales orders and returns to capture important information.
• Increased the order fulfillment and revenue using product substitution process at the time of order entry.
• Defined Customer items and cross references to link the customer items with organization.
• Increased the inventory accuracy by implementing Physical Count which resulted in bridging the discrepancies between system and actual quantity periodically. This also helped in reporting and closing the financial statements at the month and year end.
• Provided lot and serial transaction controls for the items during all receiving, manufacturing and shipping transactions.

Confidential

Role: Oracle Applications Financial Functional Financial

Responsibilities:

• Played significant role in the Upgrade Patch set analysis in identifying the impacted components.
• Interacted with Oracle to get the issues addresses by logging SRs.
• Developed Training Material for OM and AR modules and prepared impact analysis for critical issues.
• Tested the revised Customer Interface that takes the new Customer Type into account by enabling to load customer data for both Organizations and Individuals.
• Responsible for preparation of test scripts and monitoring UAT.
• Extensively worked on Month end and Year end reconciliations for closure of sub ledger modules - AR and AP.
• Worked on HP Quality Center to create Test Scripts, Test Cases and testing various Functional activities.
• Responsible for Retrofitting and re-building custom components post execution of standard features testing.
• Involved in the Bridge Calls during Cut-over/ Go-live phase.

Environment: Oracle EBS 11.5.10.2 (GL, AP, OM, AR, CM, FA)