SUMMARY

• 13 years plus of experience working on Oracle EBS product development and implementation of all major releases - 11i and R12
• Working as EBTAX/OneSource SME
• Working as an Expert in integrating Oracle EBS with Sabrix/Determination/OneSource tax engine
• Expert in configuring Sabrix/Determination/OneSource tax engine.
• Worked on integration of Oracle EBS with Vertex tax engine.
• Expert in Development, Personalization and Extension of OA Framework.
• Thorough understanding of PL/SQL, SQL, Core Java,J2EE Framework, AOL, XML Publisher, BPEL 10g/11g, SOA, Oracle Forms, Oracle eBusiness Suite R12/11i and IBM MQSeries.
• Experience in developing reports using BI/XML Publisher and Oracle Reports.
• Experience in working on Oracle Approvals Management Engine (AME) and Oracle Workflow Builder.
• Have experience of working on integration of Oracle Applications with Sales force using BPEL.
• Very good experience working on Receivables, Payables, SLA, Oracle Quoting, Oracle CRM, Telesales, Oracle SCM, Oracle Financials module, Oracle iPayment/Payment, Oracle iProcurement, Order Management and Oracle Lease Management for both R12 and 11i releases.
• Subject Matter Expert (SME) in the area of automated credit card and direct debit payment processing using Oracle Payments.
• Extensive experience in AOL concepts like Concurrent Programs, Request Sets, Key Flex Fields and Descriptive Flex Fields. Creating users, Responsibilities, menus, Request Sets, Request Groups, Profile Options, form functions, and function security.
• Expert in UNIX and shell scripting.
• Expertise in developing enterprise and server-side web-based applications using JSP, Servlets, Java Beans, IBM MQSeries.
• Strong programming experience in creating Oracle objects like Procedures, Packages, Functions, Triggers and other database objects using SQL and PL/SQL.
• Experience working as Sales Force Administrator.
• Experienced in working on Agile methodology.
• Have worked on source control tools like Win CVS and Oracle Arcs.
• Received Employee Recognition Award for outstanding performance during SIT support in Confidential project.
• Received Employee Recognition Award for SLA (Sub Ledger Accounting) project in Oracle Corporation.
• Possess good analytical, inter personal and communication skills.

TECHNICAL SKILLS

Oracle Applications: Oracle EBTax, Oracle Quoting, Oracle Account Receivables, Oracle Project Accounting, Oracle TCA, Oracle CRM, Sales and Telesales, Order Management, Inventory, Oracle iPayment, Oracle Lease Management, Field Service, Tele Service, Fixed Assets, Account Payables, General Ledger, Service Contracts, Sales Contract, Install Base, Oracle Advance Pricing, Oracle iExpenses, Oracle iStore, Oracle Credit Management, Oracle Collections, Oracle iProcurement, Oracle iRecruitement, Shipping, BOM, Oracle Approvals Management Engine (AME), SLA/FAH, Fixed Assets

Frameworks: OAF-Oracle Applications Framework, JTF, J2EE, Weblogic 8.1 Page Flow Technology, IBM Websphere MQSeries

Programming: PL/SQL, Java, UNIX shell script, XML HTML, Oracle BPEL 10g/11g, SOA

Web Technologies: JSP, Servlets, Java Bean, Java Mail, JDBC

Oracle Tools: Oracle XML Publisher, Oracle Workflow Builder, SQL Navigator, Toad, SQL* plus, Oracle JDeveloper, Oracle Forms Builder, Oracle Reports BuilderOperating Systems AIX, Linux, Solaris, Windows

Database: Oracle 9i/10g

PROFESSIONAL EXPERIENCE

Confidential

Senior Tax Implementation Consultant

Environment: Oracle Applications 11i/R12, OneSource/Sabrix Tax Engine

Responsibilities:

• Integrate Oracle EBS both O2C and P2P cycles with Sabrix/Determination/OneSource tax engine for various clients of Confidential across the globe.
• Gather requirements and based on understanding Impact analysis in current business process due upgrade changes / enhancements.
• Implemented Oracle EBS with Sabrix/Determination/OneSource Tax engine for 44 different countries including US, Canada, Europe, Brazil and Argentina.
• Write precalc and postcalc logic to calculate taxes correctly based on business requirements
• Setup regime to rate flow within Oracle EBTAX module and performed other ebtax setups.
• Perform configurations in Sabrix/Determination/OneSource tax engine to calculate taxes based on business requirements
• Troubleshoot and resolve issues related to taxes both in Oracle EBS and Determination
• Perform EBTax setups and troubleshoot issues within EBTax for both O2C and P2P cycles globally.
• Performed all Localization setups for Brazil within Oracle EBS and implemented Brazil OU with Sabrix Tax engine.

Confidential

Senior Oracle Applications Techno-Functional Consultant (Lead)

Environment: Oracle Applications R12.1.3(Financials and SCM), PL/SQL, OA Framework, XML Publisher, BPEL 11g, SOA, Sales Force

Responsibilities:

• Impact analysis in current business process due upgrade changes / enhancements.
• Business process Mapping with all standard and customized modules.
• Design test scripts of all sub-process related to Order to Cash and Procure to Pay cycles.
• Unit testing execution for each business process in Receivables like creating Subsidy Invoices, Invoice Print Format programs and EFT transactions.
• Analyze and test integration with 3rd Parties and legacy systems.
• Involved in unit testing, functional testing, system integration testing and user acceptance testing for several SCM, CRM and Finance modules.
• Provided user training and conducted practice and additional business requirements sessions.
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems.
• Prepare Functional assessment reports, Status Rollup reports and project health reports to provide regular status to PMO.
• Integrated Oracle Payments with Sterling PayTrace Gateway to support credit card and purchase card sales transactions by providing real time authorization, capture/settlement, and refund capabilities through the Oracle R12 Payments.
• Designed single sign on application from Sales Force to Oracle EBS.
• Designed and Developed Receivables detailed custom invoice formats for invoices from different sources like Order Management, Service Contracts, Oracle Projects having different formats for each source.
• Wrote MD50 and BR100 documents for Invoice Format, AR Statements, AR Invoice Conversion, Sales Order Conversion, Service Contract conversion, Install Base conversion and Product Family Summary Interfaces.
• Developed various interface and extension objects using PL/SQL in Receivables, Project Accounting and SCM and TCA modules.
• Developed custom forms in OA Framework related to SCM and Financials modules to enhance functionality.
• Extended and Personalized various standard OA Framework pages in SCM, Financials and TCA modules.
• Designed custom application using OAF integrated with Oracle Quoting to enhance functionality.
• Developed Custom Parallel Approval Process in Oracle Quoting by extending Oracle Entity Object and Oracle Application module in OAF and writing custom ASO packages and changing ASO Approval workflow.
• Customized Oracle Pick Slip and Packing Slip reports.
• Developed program to copy BOM components from one inventory org to another.
• Developed interface to generate Bank of America and JP Morgan payment files in custom format.
• Worked on integration and troubleshooting tax issues related to Vertex Tax engine Integration for US order to cash and procure to pay cycles.
• Developed multiple BI Publisher custom reports related to Service contracts, install base, receivables, payables and order management modules.
• Defined accounting rules for SLA and FAH modules.
• Screening candidates for Oracle Applications.

Confidential

Supply Chain Management Techno Functional Lead

Environment: Oracle Applications R12, Oracle Apps Framework, PL/SQL, Oracle Forms, Oracle Reports, XML/BI Publisher, BPEL 10g, SOA

Responsibilities:

• Integrated Oracle Payments for Credit Card transactions with Trust Commerce Gateway.
• Developed new OA Framework forms and customized Oracle standard Customer pages and iPayment pages.
• Responsible for fixing defects on Oracle Forms and PL/SQL.
• Responsible for improving code performance, performing code review and mentoring newer colleagues.
• Worked as Sprint (Agle) Lead and handled a team of 6 developers for 5 Agile projects.
• Customized iProcurement OA Framework pages and Account Generation Workflow.
• Implemented new functionality and supported existing functionality using PL/SQL and OA Framework.
• Designed and wrote packages for conversion of prescriptions, orders, patients, and receivable invoices data.
• Improved the performance of OM Line Workflow and other Supply Chain Modules.
• Re-designed and re-coded existing Create Order web service and other Web/IVR web services by fine tuning PL/SQL, SQL and Java code and redesigning BPEL to improve overall performance.
• Developed several BPEL processes to interface with WEB/IVR services to send and receive data from Oracle EBS to WEB portal and IVR applications.
• Designed and developed conversion programs to convert Customer data, AR Invoices, Items Master Data and Sales Orders.
• Implemented Oracle Scripting.
• Responsible for providing Technical solutions to all business requirements varying from simpler to complex mainly in Oracle Purchasing(Buyer Work Center) and iProcurement.

Confidential

Senior OA Framework and PL/SQL Developer

Environment: Oracle Applications 11i, Oracle Apps Framework, IBM MQSeries, AIX, Oracle 10g

Responsibilities:

• Developed and designed Java program to enqueue, dequeue messages for EDI Transactions from local, remote, dead letter queues using IBM MQSeries APIs. This program was used to enqueue and dequeue both single byte and double byte messages(for Japan customers) and used to send an error email in case of any error scenario.
• Integrated Oracle iPayment with AR and Order Management. Developed Servlet and JSP to integrate Oracle iPayment to work with IBM EPayment System for authorization, capture and refund for Credit Cards, ACH and Direct Debit. Extended Oracle iPayment to pass additional parameters to the third party system apart from standard request parameters using TrxnCustomizer class. Created a new SOA container and installed secured certificates into the java keystore file i.e. cacerts file present in the SOA server container. Called HTTPS web service by sending SOAP message using soap protocol to the IBM EPayment System. In addition to this implemented credit card tokenization functionality by utilizing credit card number passed by EPayment System.
• Automated Order To Cash and Procure To Pay flows using Oracle iPayment.
• Played techno - functional Lead role for Oracle iPayment project, and was responsible for preparing FDD doing required set ups and writing TDD and was responsible for end to end process starting from requirement analysis to coding and user testing.
• Developed an OA Framework application which was used by various interfaces, conversions and extension modules to upload and download files from local system to unix server. This application also had a feature which converts an excel file to csv file while uploading the file and everything is configurable and extensible.
• Responsible for the OAF implementation and development for Oracle Configurator and Advance Supply Chain Planning modules.
• Developed new OA Framework pages for Advance Supply Chain Planning module and Oracle Configurator module.
• Extended and personalized various existing seeded OA Framework pages in Cost Management, Cash Management and iExpenses.
• Customized many standard Oracle iStore pages.
• Performing technical feasibility analysis of various proposed solutions and evaluating the best as necessary.
• Developed various XML Publisher Reports and wrote pl/sql packages to get data for those reports. The reports were related to various Oracle modules such as AR, AP, GL Inventory, Install Base and Oracle Service Contracts.
• Developed interface to generate Citibank payment files in custom SEPA format.
• Developed PL/SQL Packages, Procedures and Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated the base tables.
• Developed conversion programs to convert resources, territories and service contracts.
• Developed interface to assign territories for field service and Oracle Sales and TeleSales.
• Responsible for code review, writing MD70 and MD120 documents and deploying code bundles.

Confidential

Project Lead

Environment: Oracle Applications R12/11i, Oracle Lease Management, Oracle General Ledger, Oracle Receivables, Oracle Payables, Fixed Assets, SLA, Linux, Oracle 10g, Oracle Apps Framework, PL/SQL, XML Publisher, Unix Shell Scripting

Responsibilities:

• Worked on fixing Customer bugs on 11i in modules related to Accounting, Billing, Disbursement, and Setup Screens built using OA Framework and JTF.
• Worked on development of enhancements for 11.5.10 releases and support of prior releases.
• Worked on development of multiple R12 uptake projects.
• Worked on integration of Oracle Lease Management with EBTax engine.
• Worked on Standard Payment Format Bugs in AP team.
• Worked on issues related to SLA/FAH modules.
• Worked on integration of Oracle Lease management with Cash Management/Fixed Assets modules for release 11i and R12.
• Was involved in high level design, impact analysis, making changes and testing of individual modules in Oracle Lease Management.
• Designed and developed Accounting Sources, Extract Objects, Reference Views.
• Designed the Migration Path for the existing customers and legacy data.
• Contributed towards implementing of Drilldown APIs, API Hooks with SLA Accounting Engine and few reports (Create Accounting, GL Transfer) has been built in this project.
• Design and Development of the De-normalized Transaction Sources schema
• Design and Implementation of the OLM Transaction Objects.
• Design and Implementation of the Reference objects to fetch OLM sources in various applications like AR, AP, FA.
• Design and Implementation of various Transaction Setup screens in OA Framework.
• Involved in the Design and Development of the OLM Accounting Setup Screens in OA Framework.
• Was responsible for studying impact analysis of the accounting engine and writing new PL/SQL apis to improve accounting engine performance.
• Coded Upgrade scripts to migrate accounting transaction data from transaction tables of Lease to that of SLA. Performance is a major concern for the upgrade script as it involves huge amount of data for the customers.
• Thorough analysis and design was undertaken to improve the performance and reduce the downtime.
• Documentation of the Detailed Level Design DLD, Technical Design Document TDD.
• Involved in preparation of the Unit Test Plan.
• Was part of the team doing impact analysis,uptaking changes to unit testing and system testing of all impacted areas in Oracle Lease Management.
• Involved in changing existing JTT pages and OA framework pages to display/update/select Legal Entity as per requirement.
• Coded Upgrade scripts to stamp accounting transaction data and other relevant documents with appropriate legal entity.
• Documentation of the Detailed Level Design DLD, Technical Design Document TDD.
• Involved in preparation of the Unit Test Plan.
• Independently handled the entire project starting from impact analysis,uptaking changes to unit testing and system testing of all impacted areas in Oracle Lease Management.
• Documentation of the Detailed Level Design DLD, Technical Design Document TDD.
• Involved in changing existing JTT pages and OA framework pages to display/update/select Ledger as per requirement.
• Involved in preparation of the Unit Test Plan.
• Was part of the team that implemented MOAC uptake in Lease.
• Was responsible for studying impact analysis.
• Involved in changing existing JTT pages and OA framework pages to display/update/select Operating Unit as per requirement.
• Coded Upgrade scripts to stamp appropriate operating unit.
• Documentation of the Detailed Level Design DLD, Technical Design Document TDD.
• Involved in preparation of the Unit Test Plan.