SUMMARY:

• Functional Consultant with 7+ years of IT Experience and expertise in the implementation of Oracle Financial system Administrator solutions for large organizations and complex business processes, background includes experience in implementation of projects for domestic and overseas clients.
• Expertise covers the requirements gathering and analysis, documentation of functional design, communication with key stakeholders including technical resources and users, the supervision of functional work, testing, change management, configuration, implementation and post implementation support 
• Extensively worked as an Oracle E - Business suite R12  Oracle  Financial Suite Expert. Extensive experience with the modules of AR, Advance collections, e-Business Tax, Project costing, Project Billing,  Oracle  Time and labor, Deductions settlement, AP, GL, sub Ledger Accounting, Fixed assets, Cash Management, i-expense modules.
• This has proven to be extremely advantageous in the work as  oracle  application Functional consultant by helping communicate with the Finance and accounting Stakeholders at the same wavelength.
• Extensively worked in Oracle application modules Procure to Pay, iExpenses, Payables and Web Center. 
• This experience has also been a good base to understand and integrations and relationships of the systems under implementation and relationships of the systems under implementation with the overall organizational Finance and accounting system. 
• Strong interpersonal, analytical, and communication skills, proven ability as an efficient team member in System Analysis, Design, Development, Migrating and documentation. Result oriented, organized with good Presentation skills, to learn and adapt new technologies. 
• Strong knowledge in  oracle  financial modules (AR, Deductions Settlement, e-Business tax, AP, GL, Sub Ledger Accounting, Fixed Assets, Project Costing, Project Billing,  Oracle  Time and labor, Cash Management, I-Expense) in R11i/R12 environment 
• Sound knowledge and experience on other modules like purchasing, Inventory, Order management and system administration 
• Extensively worked on various business flows such as Order to Cash (O2C), Procure to Pay(P2P) and FA to GL  Oracle  e business suite in R11i/R12 
• Participated in multiple  Oracle  apps 11i/R12 implementation in multi org/ multi-currency scenarios, order management and worked as areas involving pricing, purchasing, and Inventory. 
• Expertize in the AIM methodology, Documentation, Configuration of applications, Testing, End-user training and supporting for  oracle  financials R12/11i GL, e-Business tax, project costing, project billing, AP, AR, FA modules 
• Expert in preparing RD020, BP040, BR100, MD050, and TE020 document 
• Experience in data mapping the external source files with  oracle  columns in  Oracle  Accounts Receivables, Accounts payables and fixed assets modules 
• Experience in all phases of the systems development/implementation life cycle 
• Prepared the test scripts for all financial modules i.e. FA, AP, e-Business tax, AR, GL with all business scenarios to test in all phases i.e. CRP, SIT, UAT 
• Strong knowledge and working experience in end to end testing for all modules 
• Involved to conduct UAT session with business user and prepared user documents for all financial modules 
• Involved to provide USER training to end user with the entire business scenario 
• Responsible for fixed assets management like CAPEX and OPEX analysis, CAPEX viability on  oracle  fixed assets module 
• Ensure accuracy and discipline of accounting in O2C and P2P on a regular basis by running routine queries/checks 
• Responsible for Month end closing reporting, variance analysis, trend analysis, quarterly and monthly forecasting and forecast vs actual comparisons on  oracle  Hyperion management tool.
• Debtors Management, Creditor Management and providing  oracle  report for Debtors and Creditors Management on a regular basis. 
• Gained knowledge in Oracle tax engine eBTax setups and global eBTax integration with Vertex and Sabrix.
• Preparation of balance sheet, intercompany and Fixed Assets Reconciliation reports. 
• Various MIS reports as and when required for cost control and perform root cause analysis.
• Prepare Tax return of individual, partnership, sold traders and companies.
• Involved in handling direct and indirect taxation matters including filing of returns, assessments and compliance related to employee and vendors TDS, corporate tax, Service Tax, Input and Output VAT etc.

EMPLOYMENT HISTORY:

Confidential, Madison, WI

Oracle EBS Consultant

Responsibilities:

• As a functional consultant implemented the following modules AR, AP, Advance Oracle EBS & Fusion/Cloud finance functional Consultant with experience in design, development and implementation of Oracle ERP (11i, R12 & R11 versions) spread across Upgrades, Implementations and Testing collections, Deduction Settlements, e-Business Tax, GL, i-Expense modules.
• Oracle EBS & Cloud/Fusion finance functional Consultant with development and implementation of (11i, R12 & R11 versions) spread across Upgrades, Implementations and Testing 
• Worked on the Functional mapping of data conversion & Enhancements for AR, AP, Fixed Assets e-Business Tax I-Expense 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 
• E-business Tax - worked on the oracle e-Business Tax setups like settings up the rates, regimes, tax codes, rate of regime flows, setting up e-Business tax for sales and use as well as VAT Tax 
• E- Business Tax Worked on the integration of vertex Q series with Oracle e-Business Tax 
• E - Business Tax Defined tax rules foe exemptions and exceptions in Oracle e-Business Tax module.
• Worked in a SOX compliance environment
• Worked on AR Deductions Settlement module including the setups foe implementing claims like setting up system parameter defaults, setting up trade profiles, setting up Supplier trade profiles, 
• Worked on the setups of sub ledger accounting module defining the journal line sources, Events SLA Rules, Account Derivation rules etc. 
• Worked on the e-Business tax module setups defining the tax codes, tax rates, exemptions, exceptions, regimes, rate to regime flows etc. 
• Configured Oracle AR Including the setups of Revenue Recognition process, defining of Accounting and Invoicing Rules 
• Oracle apps Release 12.1.3/11.5.10 Family pack e-business suite (AR, AP, Deductions settlement, AP, I-Expense, Fixed Assets, e-Business Tax, sub ledger accounting, e-Business Tax, Oracle time and labor, GL, OM, INV, Shipping and advance pricing SQL Loader, Data Loader, Toad, Windows NT, UNIX 
• Provided with useful training to the users in General Ledger, Account Receivables, Account Payables and Order Management Modules.

Confidential, Houston, TX

Oracle EBS Consultant

Responsibilities:

• Customize and convert existing RDF and XML/BI Publisher reports that will run compatible as per the new multi-org structure and user requirement. 
• Assisted IMS to use PPR's for payments processing in R12. Created new Payment Process Profiles, Payment templates, Payment Formats and XML publisher formats as per the payment system. 
• Involved in resolving accounting and recon issues, map requirements to FSD, as well as to define design standards, best practices, and processes. 
• Analyzed issues related to TCA architecture after R12 upgradation by using  Oracle  Meta link experience in researching issues and raising SRs as well as continual follow-up until resolution. 
• Prepared the Technical, Installation and Testing Documents as per ABS Standards. 
• Performed all the required task to finish setting up Noetix platform environment: 
• Good understanding on ABS Noetix Customized tools. 
• Developed Noetix reports related to finance module, reports for month end reconciliation, SLA reports, GL reports and HRMS reports.
• Worked on Sabrix Tax integration with Oracle EBS R12.2 modules. Documented the setup procedures.
• Coordinates and Supports period close processes and assists the Finance team with month-end account reconciliation efforts.
• Worked on AR Module, Re-Engineered the AR AutoLock box, Receipt-Split process across Multiple OU's, incorporated new business changes/implementations AR  Reconciliations,
• Collaborate with internal auditors for performing SOX audits and conduct review sessions to provide resolutions to any identified risks
• Implemented Procure to Pay cycle.  
• Investigates, documents and understands new and existing technical Oracle EBS functionality in a proactive manner; trains end users as needed. 
• Collaborates with Subject Matter Experts (SMEs) or super users in their functional areas. 
• Acts as the liaison between the Finance and IT departments in regards to Oracle; troubleshoots issues and identifies modifications needed for Domestic and international operations; and oversees process implementation changes. 

Confidential, Kalamazoo, MI

Oracle  EBS Technical Consultant

Responsibilities:

• Performed all the setups for OM, Shipping and Advance Pricing, AR, INV modules. 
• Flow Testing for SCM Modules (AR, AP, OM, WSH, QP, BOM, INV, PO) to make sure flow is working without any issues. 
• Automation for O2C and integration with third party systems. 
• AME integration with iProcurement and iExpense. AME setup for iExpense and iProcurement applications. Approval process setup by defining / modifying Attributes, Conditions, Actions, Approval Groups, and Rules. 
• Worked extensively on understanding the proposed 100% customized business logic of the Business in building the customized solutions for Shipping on OA framework Technology based on the legacy of  Oracle  application E-business suite 11.5.10. All the above bases business logic was captured in OA Framework code. 
• Design & customization, RDF and XML Publisher Reports,  Oracle  Workflows, Form Personalization's and OAF. 
• Analyzed the custom code components in proc to pay process and retrofitted custom PL/SQL Packages, Reports, Forms, and Workflows to make them work in R12. Personalization and Extension of OAF pages in various modules. 
• Created multiple Complex OAF Pages for Purchasing, Order Management, and iExpense which included Partial page rendering functionality 
• Lead a team of OAF developers and workflow consultants to accomplish the custom module development in time 
• Baselined technical design and migration documents for OAF. 
• Created a custom application from scratch using  oracle  OAF (Query Bean, Create Page - Tables, Advanced Tables, Shuttles, Invoking DB procedures/API's and workflows etc.) 
• Worked on enhancement of seeded iExpense OAF pages like modification of LOVs for fetching the data from third party systems by calling the webservices, adding the custom regions and enabling partial page rendering at multiple levels, extending the VO, creation of validation view object, adding Entity expert to the standard EO. 
• Implemented changes to send pick tickets from the OE/OM module (based on the delivery shipping model; WSH) to a vendor's warehouse management system (WMS). Extensive architectural changes and enhanced error checking. Also enhanced the custom ship confirmation process which takes ship confirmations from the vendor's WMS, and loads them into the standard  Oracle  Applications interface tables (Open Shipping Interface) so the data can be populated (via the standard  Oracle  API) into the OE. 
• Understanding complex business requirements and processes and liaising between Business Analyst / External Partners and development team. 
• Spearheaded functional training on Order-to-Cash for technical team and technical trainings on OAF and Java for Stryker Global IT team. 
• Order Management O2C (Order to cash) end-to-end cycle using API as Shipping is being done from legacy systems. 
• Order Management and Purchasing enhancement for integrating it with Third Party Logistics
• The Returns feature in  Oracle  Receiving does not provide the flexibility to track the returns. The Business process requires Return to Vendor functionality to provide an efficient method of controlling the return and exchange of items bought from suppliers, ensuring visibility and tracking of the item until the transaction is concluded.
• Kit Cross Docking project to automate many parts of the processing of Affiliate packaged Kits containing multiple saleable SKU. A custom OAF page was developed in which unique Kit ID and detailed component data get housed. Users can view Kit ID data and Receive, Put Away, Pick and Ship Kits at a Kit ID Summary Level. By updating the form at the Kit ID level, an automation of all Kit component transactions take place.