PROFESSIONAL SUMMARY:

• A Senior Oracle applications Techno - functional Consultant having around 14 years of professional IT experience with an earned reputation for meeting strict deadlines and delivering mission critical solutions on time and within budget.
• Having 12 years of experience in Implementation, Rollouts, Customization, Production Support, and Up-gradation of Oracle Applications from Release 11.5.10.2 to 12.1.3 and experience in implementing Tax automation solutions along with managing post production support for clients with multiple tax integrations and large transaction volumes for both US Sales & Use Tax and VAT.
• In-depth Technical & Functional knowledge of Oracle Applications in Release 12/11i.
• Technically proficient in AIM Methodology, Designing and Developing RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows).
• Study and analyze existing technology architecture and create estimates from requirements and design documents
• Experience in 3 Full Life-cycle implementations of Oracle E-Business Suite.
• Strong Techno-Functional experience in Order-to-Cash (OTC), Procure-to-Pay (PTP), Regime to rate (R2R) and Record to Report (RTR) cycles.
• Worked on various projects include Financials (GL, CM, FA, AP and AR), Supply Chain (INV, OM, WIP, BOM), Shipping Execution, WMS, TCA, Oracle Alert Management and Web ADI.
• Having good knowledge of Sabrix (OneSource Indirect Tax) and Tax ware Engines.
• Experience in Performance tuning of SQL queries using Hints, Indexing and Partitioning of tables.
• Expertise in Design and 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 etc.
• Strong Knowledge of Application Implementation Methodology (AIM), Application object Library (AOL) implementation standards, Trading Community Architecture (TCA) and software Development Life Cycle (SDLC).
• Proficient in Programming Using PL/SQL, Reports 6i, Oracle 9i/10g and Experience in Importing Information into Oracle Applications through SQL* Loader.
• Worked on all the aspects of Technical design & development of various critical business processes Oracle Applications
• Extensive experience in developing Interface/Conversion Programs to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader, UTL file etc.
• Participated in business process reviews. Provided solutions and recommendations to process issues related to Oracle Applications.
• Experience onTAR's(Service Requests) with Oracle on Demand Team and End users.
• Experience in working with Oracle Support to investigate and resolve critical problems identified during system Implementation and Post-Production Support.

SKILLS:

Environment: DOS, Windows 98/NT/2000/XP, Linux

Languages: C, COBOL, SQL, PL/SQL and Shell Script

Databases: Oracle8i/9i/10g MS-Access

ERP & Tax Engines: Account Receivables (AR), Account Payables (AP), Fixed Assets (FA), Cash Management (CM), General Ledger (GL), Order Management (OM),Shipping Execution, Advanced pricing, Advanced Collections, Purchase Order (PO), Inventory Management(INV), iProcurement, iExpense, TCA, Oracle Alert Management, AOL, System admin and WEB ADI E-Business tax, Sabrix (OneSource Indirect Tax) and Taxware.

Tools: & Utilities: Forms 6i/9i/10g,Reports 6i/10g, XML Publisher 5.6, Discoverer 10g, APEX 4.0Mark view, SQL*Plus, SQL*Loader, UTL, PVCS, Workflow builder and Data loader

PROJECT PROFILE:

Consultant

Confidential

Responsibilities:

• Senior Oracle EBS Techno Functional Analyst with implementation and support experience with oracle EBS suite R12
• Actively involved in developing Finance Module components and Integration with Sabrix 5.5.1 (OneSource Indirect Tax)
• Responsible for analyzing the business requirements defining the scope and planning the deliverables.
• Worked on future business process flow. Experience with Solution implementation: requirements definition, solution design, user training, performance optimization, system test, and go-live support.
• Involved in developing technical design document (MD070, MD200, and CV060) and (BR100, MD060) for functional solutions using oracle AIM standards.
• Worked with the cross functional teams to ensure the end-to-end solution works.
• Participated in a cross-functional projects activities, coordinated the tasks to maintain the seamless integration of the application with other systems·
• Documenting the business processes as finalized with client.
• Prepared Setups for Order to Cash Modules.
• Closely worked with Business / Tax Managers / Functional consultants for gathering the current business process and understanding their business model and provided the flexible solutions to the business.
• Closely worked with the DBA team, during Installation and Integration of Sabrix with Orcle E-Biz Suite (O2C)
• Actively involved Unit Testing, System Integration Testing (SIT), Customer Acceptance Testing (CAT) & Post Implementation Support.
• Replicate the issue on Test / Development instances to trouble shoot the issue and review the Logs / Trace Files / Sabrix Logs and Xmls for analyzing the root cause of the issue and providing an action plan to the business users.
• Coordination with Oracle support / Sabrix Support for resolving critical issues as part of SR’s.
• Responsible to attend the Daily Stand up calls with business / Tax Managers and users to discuss open issues and gather additional information to resolve the issue efficiently.
• Cutomization of AR Aging Report, Invoice Print programs for EU & MENAT countries as per CCL business requirement
• Developed various Custom Interfaces / Conversions
• Customer conversion
• IBS / DXL AR Invoice Load (Inbound)
• Receivable Invoice details (Outbound)
• Developed various Alerts and will send notifications when
• Stuck transactions in Auto Invoice interface tables
• Credit limit expired customer list to branch managers.
• Developed custom workflow will send notifications when
• New Tax Code creation to the tax managers.
• Personalized Sales order / AR Transaction workbench forms.
• Mandatory - Sabrix Tax category code
• Enable Special menu to launch Sabrix Log/Xml reports
• Worked on Oracle Apps personalization and customization and Extension using Oracle Application Framework (OAF)

Programmer Analyst

Confidential

Responsibilities:

• Senior Member of the Product Development Team.
• Responsible for the timely delivery of all technical components related to Projects as well as support and maintenance.
• Ensure quality of deliverables by performing unit and integration tests; resolve problems.
• Involved in developing technical design document (MD070, CV060) for technical solutions using oracle AIM standards.
• Actively involved in developing Finance Module components and Integration with Sabrix 5.5.1 (OneSource Indirect Tax)
• Closely worked with Business / Tax Managers / Functional consultants for gathering the current business tax process and understanding their business model and provided the flexible transaction tax solutions to the business.
• Closely worked with the DBA team, during Installation and Integration of Sabrix with Orcle E-Biz Suite (O2C/P2P)
• Involved Unit Testing, System Integration Testing (SIT), User Acceptance Testing (UAT) & Post Implementation Support.
• Actively resolving the technical and non-technical One Source Determination, TCM and Reporting issues.
• Tracking all the business-wise issues and making sure that where there are recurring issues logged by the business users to make the necessary enhancements.
• Replicate the issue on Test / Development instances to trouble shoot the issue and review the Logs / Trace Files / Sabrix Logs and Xmls for analyzing the root cause of the issue and providing an action plan to the business users.
• Responsible to attend the Daily/Weekly/Bi-weekly/Monthly status meetings for discussing all opened tickets / Issues and communicate with business / Tax Managers / functional consultants and users to gather additional information to resolve the issue efficiently
• Developed various Alerts and will send notifications when
• Stuck transactions in Auto Invoice interface tables
• Sabrix Holds on Payable Invoices
• Developed Tax reconciliation detailed report for North America and Canada.
• Lock Box interface Development with PNC Bank USA.
• Developed Check printing & Positive Pay for JPMC and HSBC banks in Confidential US operating unit.
• Developed AR Auto Adjustment concurrent program is to write-off of certain partially paid invoices for North America.
• Developed Sales Commission report
• Developed Asset Clearing Account Balance Detailed Audit Report
• Cutomization of AR Aging Report

Programmer Analyst

Confidential

Responsibilities:

• Involved on Upgrade Project which is Upgrading from Oracle Application E-business suite from 11. .1.3
• Involved the process of stream lining all the existing Custom Reports / Packages / Views and Custom Interface between ERP and third party applications like Creditform System (Crefo Bonitätsindex 2.0.) / Carl software (European leader in maintenance management software) and Taxware (Tax calculation engine)
• Actively involved in implementation of E-business suit including gathering the requirements from the user and understanding their business model.
• Training to the end users on the developed application.
• Involved In all testing cycles and User Trainings.
• Support client for Month end and year end process issues
• Support for critical production issues from financial modules while performing period close activities, reconciliation issues as well as reporting needs.
• Involved in analyzing day-to-day production issues and quickly respond to the problem to minimize the business impact
• Worked with Oracle support to raise SR’s to get the solutions for the various bugs and get Patches applied to the applications and do complete testing.
• Closely worked with Business / functional consultants / DBA’s to Integrating Oracle receivable with Taxware for US/Canada.
• Involved Tax ware Functional setups like Profile Options / Lookup codes (ARTAXVDR: Location Qualifier) / Vendor specific Tax Codes / System Options etc.,
• Performed various Test scenarios to verify that tax vendor was implemented successfully or not like
• Created various Sales Order with different Transaction Types (Sale / Hire/ Fixed Price)
• Imported Sales Orders using Auto Invoice using various Batch Sources.
• Created recurrence Invoices whether Tax will be calculated using the vendor tax extensions on recurred invoices
• Created invoices with Update / Delete lines AND in the Receivables Transaction Workbench.
• Created exemption orders.
• Act as a single point of contact for all Tax related issues - Sabrix /Tax ware 3rd Party Tax calculation engine tools.
• Worked with ADP support Team to raise support call to get the solution for the various tax issues and involved up-gradation of Tax ware Engine from 3.5.7 to 3.5.10.
• Successfully Rollouts for Romania / Poland and France, worked on various conversions, Interface and reports for OM/AR/AP and INV modules
• Developed various interfaces, both inbound and outbound, which are run on periodic basis. The modules worked on include PO, AR, INV and OM.
• Developed various custom Interface/conversions
• CARL Outbound Interface
• PL/SQL SALES and USE Tax System for TAX ONLY Transactions Outbound Interface
• CREFO Inbound Interface
• Receivable Invoice Interface
• Supplier Interface
• Payable Invoice Interface
• Item Interface.
• Sales Order Migration
• On hand Quantity.
• Developed various Custom XMLP reports as per the business requirement
• Sale / Hire Invoice Print report
• Rental return ticket history report
• Sale / Hire Corrective report
• OM SITE history report
• Open Job Analysis report
• Payable Invoice Holds report
• Developed Various Audit History reports as per the business requirement.
• Supplier Audit Report, which shows changes on supplier bank accounts (Supplier Name, Bank Account details and last updated by, Last updated date) details for the selected dates as per the Payable’s Audit Team and Payables department.
• Sales Order Audit History report, when a change made to the payment terms, price list, Item QTY and Warehouse of an order that is booked with a reason as to why it was changed.
• Developed various Business Analysis metrics reports (SOB/DIVISION/MONTH-WISE) using SQL Reports to generate in CSV Format
• List of Customer Accounts / Customer SITE’s Created / Value of Customer’s credit limit / Number of Sales Orders Created / Number of RMA’s / Total DELIVERIES / Total RETURNS / Total value of invoices/credits raised and Total Revenue
• List of Vendors / Vendor SITE’s Created / Number of PO’s Created / Total Value of Payable Invoices / and Value of Vendor Payments done.
• Developed various APEX reports / Web application.
• CRM Lead management Summary report
• BID Register Summary report.
• GL HFM Balance Sheet Reconciliation Portal. The objective of this system is to provide a centralized tracking and storage system for monitoring the completion of the GL Balance Sheet Reconciliations which are required to be completed for every entity in every month.
• Developed various WMS (Distribution center) Dashboard reports
• Customized various reports like Delivery Note/ Picking Note/Bill of Lading/Checkers Card / Dunning Letter/ Sales Order confirmation and PO Print reports as per the business requirements.
• Enabled the Eye glass in Account Receivable Transaction form to able to print the SALE/HIRE/CM/DM reports.
• Developed various Event / Periodic based Alerts will send notifications when
• Material interface stuck transactions / Receiving stuck transactions.
• Unapproved Purchase order details to the respective purchasing agent.
• Dispute invoices list to branch and Sales persons.
• Credit limit expired customer list to branch managers.
• Invoice on Receipts holds to requestors.
• Invoices on Quantity Received / Ordered holds to buyers.
• Personalized Quick Sales Order form to make Salesman and Bill to / Launch Pick Release, Ship confirms and Hire Order confirmation report.

Senior Support Consultant

Confidential

Responsibilities:

• Act as single point of Contact to Sabrix FAST Support (Offshore team) for all Tax related issues.
• Provided Sabrix Production support through Service Requests (SR) logged by various teams using Confidential Support Central Community or HP Service Desk Tools and resolved Service requests within the given Service Level Agreement (SLA).
• Co-ordination with Business, Tax Managers, Sabrix Inc, Clients, End-users, and other Teams via Phone / E-mail / Chat / WebEx etc. for resolving the issues on daily basis.
• Communicate with clients / Other Teams to gather additional information to resolve the issue efficiently.
• Replicate the issue on Test / Development instances to trouble shoot the issue.
• Review the Logs / Trace Files / Sabrix Xml files / Invoice Image on 170 Mark view System for AP Invoice and analyzing the root cause of the issue and providing an action plan to the concern team / End users.
• Provided help to various teams to make them understand the resolution of the issue.
• Tracking all issues business-wise and making sure that where there are recurring Issues logged by the teams / end-users to make the necessary enhancements.
• Responsible to open tickets with Sabrix Inc., for production issues and gathering requirements for the tickets logged on Sabrix Inc., and following it up through until the resolution of the issues.
• Communicate with on-site facilitator / Co-facilitator to hand off at the end of the day
• Report the status of tickets on a regular basis to higher management
• Responsible to submit weekly progress report to Facilitator / Co-Facilitator and Project Manager.
• Responsible to attend the Weekly status meeting for discussing all opened tickets / Service requests with Project Manager.

Technical Consultant

Confidential

Responsibilities:

• Worked with various functional experts to implement their functional knowledge into working Procedures
• Defined Tax Groups and various Tax Codes in Payables module.
• Defined Various DFF’s, Value Sets, Profile Options and Lookups in Payables module.
• Created Custom Procedure for uploading the value sets and values.
• Developed a variety of Data loader Scripts to upload the data into oracle applications tables.
• Experience in Application System Administration activities like managing concurrent managers, application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs etc.,
• Created custom views ap sabrix invoice v and ap sabrix item v to secure the data from end user selection.
• Created sabrix adapter user precalc ap custom procedure and this procedure gives Sabrix flexibility to manipulate all the input data elements that are coming from Tax records of Oracle. &
• Sabrix adapter user postcalc ap custom procedure and this procedure give output data elements regarding sabrix tax calculation.
• Customized of Sabrix standard package arp tax sabrix ap to pick the company related information into profile values.
• Designed and developed a financial tax information outbound interface process. The interface collected the Tax Information for Oracle Receivables and Oracle Payable Modules that are using SABRIX Tax calculation and transmit (ftp) to business & Tax Managers for tax re-consolation purpose.
• Developed custom group above report to show SABRIX Holds Invoices list with an excel output.
• Developed Supplier Invoice Tax Details Letter report to send suppliers their Invoices with Tax Details via e-mail / Fax with a PDF attachment for Tax confirmation by vendors in using XML Publisher.

Technical Consultant

Confidential

Responsibilities:

• Provided technical and functional expertise to help client’s enhance their business functionality of the Oracle Applications implementation and integration with Sabrix Tax Engine.
• Created various responsibilities and assigned it to users.
• Registered various Concurrent programs and Reports to AOL.
• Defined Tax Groups and various Tax Codes in Oracle Receivable module.
• Defined Various DFF’s, Value Sets, Profile Options and Lookups in Receivable module.
• Created Custom Procedure for uploading the value sets and values.
• Developed a variety of Data loader Scripts to upload the data into oracle applications tables.
• Involved Preparation of AIM Documents like Sabrix Installation document (MD120), Define Applications Setup (BR100) and Technical design (MD070) Documents etc.,
• Involved Unit Testing, System Integration Testing, User Acceptance Testing & Post Implementation Support.

Technical Consultant

Confidential

Responsibilities:

• Prepared AIM documents for Concurrent Programs.
• Done performance tuning on SQL statements and PL/SQL programs.
• Customization of reports and Development of new reports.
• Development of Purchase Order report.
• Created customized folders to display desired columns on Quick Sales Order / Shipping Transaction forms as requested by business user.
• Created users, responsibilities and assigned the users to the respective responsibilities.
• Developed various custom views, as per the business requirement.
• Developed lookups as per the customer requirement.
• Developed various PL/SQL Packages, procedures and functions.
• Developed of XML Publisher & Discover Reports in Inventory, Purchasing, Shipments, AR,AP and Order management
• Forms personalization’s on different forms like Quick Sales order and Payable Invoice workbench etc.,
• Defined various Concurrent Executable, Programs and attached to the respective request groups.
• Registered AOL Objects across instances using FNDLOAD scripts.
• Personalized various forms in different modules using form personalization.
• Responsible for preparing the technical specification document from the functional requirements Document, designing, Programming, unit testing
• Developed Outbound Interfaces for Payment Format and Sales Order Module.
• As per the client requirement personalized various forms in different modules like OM,AR and INV using form personalization.
• Developed a program for timely Purging of staging table’s data.
• Performed some administrative work such as, creating users, menus, adding forms and functions to menus, assigning responsibilities etc.
• Customized standard Oracle reports like Account Status Report, Bank Account Listing, and Employee Listing Reports as per the business requirements.
• Developed various alerts to monitoring the credit check holds in Order Management and matching holds in Payables.
• Used PL/SQL extensively in writing Procedures, functions, packages to maintain referential integrity and to do complex updates and validations.
• Communicate with clients / Other Teams to gather additional information to resolve the issue efficiently.
• Replicate the issue on Test / Development instances to trouble shoot the issue.
• Review the Logs / Trace Files to analyzing the root cause of the issue and providing an action plan to the concern team / End users.