SUMMARY:

• Having overall 7+ Years of extensive experience in Oracle E Business Suite (EBS), Finance and Accounting. As an Oracle Functional Financial Consultant expertise knowledge in in full life cycle implementation of Oracle R12 applications, Up gradation and support experience in 11i
• Successfully handled 6 implementation projects. Sound knowledge in Implementation, Migration, Customization and Production support of various EBS modules including Trading Community Architecture (TCA), Account Receivables (AR), Order Management (OM), Shipping (WSH), Advanced Pricing (QP), Inventory (INV), General Ledger (GL), Fixed Assets (FA), Oracle Project Accounting (PA), Purchasing (PO), Account Payables (AP), Service Contracts (OKS), Install Base (IB), WMS (Warehouse Management System), Bill of Materials (BOM), XLA (Sub Ledger Accounting) and Application Object Library (AOL).
• Experience in Oracle EBS RICEW (Reports, Interfaces, Conversions, Extensions and Workflows), OAF pages customizations and development of Interfaces using SOA/BPEL.
• Experience in System Administration activities like creation/ maintenance of users, creating responsibilities, creation of menus, profiles, value sets, flex fields etc. Prepared Test cases TE - 020,030,040 for various financial modules.
• Experience with development team members in resolving issues by creating SR(s) and resolving issues while using METALINK (Oracle Support). Worked in Offshore model projects, coordinating with the team.
• Working level knowledge of various Oracle developer tools including Oracle Forms, Reports, Workflow, Conversions, SQL, PL/SQL, etc. Extensive experience in Auditing, accounting and taxation works.
• Extensive knowledge in preparation of Monthly MIS reports, Financial Statements and Consolidated Financial Statements.
• Ability to interact with multiple levels of the business and stakeholders. Customer-focused professional, a strong team builder and an efficient multi-tasker. Ability to build lasting professional relationships across the teams, customers, users.
• Good at usage of Microsoft Excel for data manipulation/reporting using Vlookups and Pivot tables and other excel formulas.
• 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.
• Consistently recognized by senior management, colleagues for assuming responsibility and completing projects with high quality on time with focused and innovated work style. Authorized to work in United States for any employer.
• Sound functional knowledge of Order to Cash (O2C), Plan to Manufacture (PTM) and Procure to Pay (P2P) life cycles.
• Proficient in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader. Good experience in Production support projects. Has good Knowledge on DB, File and JMS adapters and with XML, XPath and WSDL.
• Experience in Inbound and Outbound interfaces using SQL*Loader, UTL FILE, PL/SQL Packages and SOA/BPEL. Sound knowledge of Oracle Application tables, Schema, Interfaces, Application Program Interface (APIs) and MOAC. Documentation experience, keeping in line with the AIM Methodology (MD70, MD50, CV040, CV060 MD120).
• Ability to work on Oracle ADF and Oracle SOA 11g Mediator, DB Adapter, BPEL and OSB. Well versed in the Code Migration process, efficiently utilizing Version Control software like Rational Clear Case, Tortoise SVN, HPQC and Kintana and creating Promotion/Migration documents.
• Well experienced in writing custom classes using core Java API, including JDBC, input/output streams and Servlets classes. Experienced in various test cycles like Unit Testing (UT), System Integration Testing (SIT), User Acceptance Testing (UAT) and Testing Strategy like entry/exit criteria, test plan, test scenarios and test cases.
• Proficient in forms customization using Custom.pll and Forms Personalization. Experience in Workflow Business Events and XML publisher bursting. Experienced in Tuning of SQL queries and PL/SQL code. Developed Interfaces using APIs and Interface tables. Proficient in writing UNIX shell scripting.

WORK EXPERIENCE:

Oracle EBS Functional Consultant lead

Confidential, Louisville, KY

Responsibilities:

• Initiate business meetings for gathering requirements and identify the gaps. Prepared functional specification documents (MD50) and other documents like BR100, BR3080, TE 40, CM10, MD120 for the desired customizations and gaps.
• Involved in designing of custom solution for order import process to EBS from legacy systems.
• Implemented various sales order cycles like Standard Orders, Internal Orders, RMA Orders, Bill Only Orders, EDI Orders and Drop Shipment Orders with custom workflows. Defined OM defaulting rules and Process Constraints to meet the business rules.
• Defined Promotions with custom Pricing attributes and subscription items as a promotional Get Items. Designed custom pricing process to default the Order line level Payment terms from price List and Modifiers. Designed custom pricing attributes for Delivery, Service, Restocking and Refusal charges.
• Developed Custom process to generate the daily pricing extract with list prices for all models and customers and integrate with legacy pricing systems (MML, DDT, Web Commerce, Sales Force).
• Involved in Pricing integration with legacy Purchasing systems for Home delivery models. Configured custom pricing attributes used in formulas to support TCA, Retailer, Distributor Pricing. Designed Custom Web ADI integrator to maintain Price lists and modifiers. Enabled Pricing Security for specific price lists, modifiers and responsibilities
• Created item relationships, Custom attributes, Item Categories in Oracle Inventory/PIM and maintained using Web ADI process.
• Designed custom pricing and qualifier attributes to support Modifiers for discounts and promotions. Worked on CHAIN SYS Apploader for data load, migration activities with Inventory/PIM, Sales Agreements and Advanced Pricing data.
• Integrated Oracle WebCenter with Oracle Advanced Pricing for uploading and publishing the Pricing documents to communicate with Customers and vendors.
• Designed Custom Attribute Mapping, Pricing APIs, Price Books, and other Advanced Pricing Setups and Configurations like Price Lists, Modifiers and Qualifiers, Custom Pricing Attributes.
• Prepared Functional specifications for custom reporting objects for XML and OBIEE (Adhoc, Dash boards and Analysis) reports in OM, INV/PIM and Pricing modules. Developed new SQL reports, customized and optimized existing ones in Accounts payables
• Working effectively with business, vendor/partners' resources and various IT teams such as Infrastructure, Sysadmin, SOA and DBAs. Designed custom pricing process to track the Order and Pricing changes and data quality reports.
• Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs). Conduct quality reviews of code developed by other development staff. Set up suppliers, supplier sites and payable options in E-Business Suite.
• Defined calendars, Distribution sets, Tolerances, bank accounts payable documents, payment terms, approval groups and approval assignments. Setup Receipt Classes, Receipts Sources and Payment Methods.
• System Administrator skills - user creation, defining responsibilities, profile options and securities.
• Used Accounting Rules to determine total revenue to be recognized (Revenue Recognition) in each accounting period.
• Performed functional analysis which implemented gathering user requirements accounts receivable system. Implementation included defining the System and Profile Options, define payment terms, defining transaction types and sources, define receipt classes and payment methods, and define Customer.

Environment: Oracle OM, Advanced Pricing, Inventory, PIM, WebCenter

Sr. Oracle EBS Financial Lead

Confidential, Alpharetta, GA

Responsibilities:

• Involved in period closing for General Ledger, Accounts Payable, and Accounts Receivable. Provided with to the users in making them understand Subledger Accounting, General Ledger, Accounts Receivable, accounts payable.
• Populated data into interface tables AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE by using standard and custom validations using PL/SQL procedures. Involved in creating setups for Purchasing and Inventory module.
• Raising SR'S and working on them to solve the issue and see that it does not block the user testing.
• Populating the AP INVOICES from external systems and testing the Mass addition create program is running as required and Mass Additions are posting in Mass addition window.
• Worked on Customized Dunning Letter Generation program in Property Manager Module and see that the Dunning Letters are generated properly. Performed System Integration testing, Performance bench mark testing.
• Created Bank, Bank account, Bank Branch and Created Payment Process profile option and assigning the format to check stock.
• Worked on Financial statement Generator report, setups given for FSG, to get reports generated in 12.1.3 after upgrade from 11.5.10.2. Created setups for sweep program, MOAC. Worked on performance issue for create accounting, invoice validation.
• Worked on Application Diagnostics program, to identify and resolve the issues.
• Worked on Mass Addition Program and test whether the Mass additions are being generated in Fixed Asset module using Seeded as well as custom reports, and resolved the issues related to Mass Addition Create program, for asset flag enabled invoices which are not flowing to FA. Working with the end users, to troubleshoot the issues they are facing during the testing process.
• Worked with technical people to design the custom report as per the organization requirements, also worked on unposted item report period close exception reports and worked extensively with Technical and DBA's in resolving the issues.
• Worked on Approval hierarchy. Given user s on AP invoice processing, Interfaces, Payment Processing, check Printing.
• Prepared the MD50 and worked with technical team regarding Rice components. Developed Aim documentation BR-100 for Application Setup. Analyzed and mapped historical data of existing customers.
• Created customer profile classes, attached payment terms, collectors, matching receipts, statement cycle to profile classes.
• Defined system options, transaction types, remittance banks, bank accounts, receipt classes, distribution sets.
• Involved with migration of historical data for Accounts Payables and Accounts Receivables.
• Performed System Integration testing on Fixed Assets, General Ledger, Cash Management and other financial modules.

Oracle EBS Financial Consultant

Confidential, South Plainfield, NJ

Responsibilities:

• Point of contact for the Business System Analysts and End users for gathering all requirements for implementation and support of Oracle EBS (Account Receivables, Cash Management, Account Payables, Fixed Assets and General Ledger).
• Strong in Oracle R12 Financial implementation in the areas of GL, AP, AR, FA with Full Life Cycle implementation experience.
• Defined Cross Validation rules and uploaded using spreadsheets.
• Analyzed Fixed Assets system to find cost differences between General Ledger and Fixed assets system.
• Populated data into interface tables AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE by using standard and custom validations using PL/SQL procedures. Corrected cost differences to get General Ledger in-line with Fixed Assets system. Designed, created and tested various reports for Monthly reconciliations of financial Sub Ledgers to General Ledger.
• Configured common options for Payables and configured Invoice Options/Payment Options as per the design.
• Involved in configuring MOAC, Financial and Payable options, supplier and payment terms in Account Payables.
• Involved in setup for Payables, General Ledger, Assets based on deep understanding of the functional processes
• End to End Configuration of GL Setups of Legal Entity, Primary Ledger, Secondary Ledger, Operating Unit and Reporting Currency. Defined profile options where ever required during implementation.
• Prepared Oracle AIM documents RD050, BR100 and MD050 documents for the financial modules.
• Involved in design and documenting requirements for EB-TAX Vertex integration for the Procure to Pay (P2P) stream as per client needs. Involved in testing various setups and resolving product specific bugs.
• Involved in preparation of test cases, test scripts and testing of standard features in Fixed Assets, General Ledger and Cash Management modules. Defined the prorate calendars, depreciation rate and calendars, fiscal calendars.
• Performed System Integration testing on Fixed Assets, General Ledger, Cash Management and other financial modules.
• Involved in User Interface functional testing for all the financial modules implemented. Worked with business partners to ensure full system testing is complete. Participated in multiple business meetings for Fit-Gap Analysis and Solution.
• Provided with useful to the users in General Ledger, Account Receivables, Account Payables and Order Management Modules. Developed Expense Report Templates.
• Defined system options, transaction types, remittance banks, bank accounts, receipt classes, distribution sets.
• Working level knowledge of various Oracle developer tools including Oracle Forms, Reports, Workflow, Conversions, SQL, PLSQL, etc. Created/supported end-to-end processes for: Order to Cash (O2C) reporting improvements.
• 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 items.
• Expertise in Conceptualizing & Implementation of various quality improvements by conducting audits for continual improvements in services. Responsible for reconciliation of month-end/Quarter end reports.
• Supported Procure to pay and FA issues during month end performing additional configurations. Prepared TE040 Documents, which are used to test various aspects of application functionality.

Environment: Oracle EBS R12 (GL, AP, AR, FA, CM, FAH, iExpenses, Procurement, iSupplier), Oracle Database 11g, MS Projects, MS Visio, Sharepoint, UPK, Config Snapshot, SQL, TOAD.

Oracle EBS Financial Functional Consultant

Confidential, Alpharetta, GA

Responsibilities:

• End to end Implementation of Oracle Payables, Payments, Receivables, Order Management. Created accounting flex field segment values, creating Cross Validation rules and security 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.
• Conducted client interviews to complete the business process analysis and to prepare the business requirements documents.
• Assisted in Month End Period Closing for Oracle Payables by completing transactions, reconciling AP to GL and Close AP current Period. Developed new SQL reports, customized and optimized existing ones in Accounts payables
• Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs). Conduct quality reviews of code developed by other development staff. Set up suppliers, supplier sites and payable options in E-Business Suite.
• Defined calendars, Distribution sets, Tolerances, bank accounts payable documents, payment terms, approval groups and approval assignments. Setup Receipt Classes, Receipts Sources and Payment Methods.
• System Administrator skills - user creation, defining responsibilities, profile options and securities.
• Used Accounting Rules to determine total revenue to be recognized (Revenue Recognition) in each accounting period.
• Performed functional analysis which implemented gathering user requirements accounts receivable system. Implementation included defining the System and Profile Options, define payment terms, defining transaction types and sources, define receipt classes and payment methods, and define Customer.
• Co-ordination between Business Leads and IT Leads and Technical Team on Project Deliverables on GL related MD50 and MD70 documents. Extensively worked on development and customization of Oracle Reports.
• Responsible for legacy system data load to GL like Globe Currency details and Account Code Combination and Asset Details. Provided extensive production support of Oracle financials, including following up SR's with Oracle Meta link.
• Involved in requirement gathering and authored MD 50 documents for the various reports and Interfaces which includes AR Invoice and AP invoice Interface. Responsible for Monthly/Quarterly and Yearly closures for AP, AR & GL.
• Designed, documented and implemented Interface programs to import ITEMS from a legacy system into Oracle Inventory.
• Create custom approval workflow, data mapping, setups, data migrations, and support for Chrome River Expense Reporting tool with interface from American Express T & E Card.
• Developed Change Management Plans and Communications, BRD's, Custom Reporting, and KPI's.
• Business Partner with cross Functional teams, IT, and Development to implement and transform from local servers to MS Azure Cloud for Services, Applications, Data Storage, and ERP Database.
• Create Business Cases consistent to corporate vision: determine business objectives, market need/opportunity/solution, pain-points, resources, cost structures, development, revenue recognition, sales for goods/services, forecasting, budgeting, potential increase in customer base recommendations, and key successes.
• Design and deliver automated custom Financial and Operational Report structure to enhance growth.