Objective

Oracle Applications Developer (Techno/Functional) with 5 years of experience in analysis, design, development, testing, and deployment of custom objects, reports, forms, and workflows.

SUMMARY OF QUALIFICATIONS

• Have 5 years of Oracle Application experience, which includes extensive experience in the functional and technical aspects of Oracle Applications R12/11i/11.0 (iPayment, OM, AR, PO, Receiving, AP, Oracle Assets, GL, Cash Management, System Administration, XML Publisher, Workflow, customizations using OA framework, JSP). Have implemented two full cycles for Order to Cash (O2C) and Procure to Pay (P2P).
• Involved in Requirements gathering, Brain-storming, High-level-Design, Technical design for Oracle Apps Implementation Projects. Expertise in Oracle Apps Implementation cycle from GAP analysis to Post Implementation Support
• Hands-on experience with Oracle Reports 6i/10g, Forms 6i/10g, XML Publisher, SQL*Loader, PL/SQL, Workflow Builder 2.6, Discoverer. Experienced in Interfaces, Conversions and Extensions. Strong PL/SQL programming skills including developing packages, functions, cursors, triggers and other database objects
• Hands-on experience with Shell Scripts and UNIX Administration. Strong in AIM documentation methodologies – Experienced in creation of BR100, CV40, CV60, MD050, MD070, MD120. Strong interpersonal skills, ability to interact with people at all levels, excellent communication and presentation skills. Experienced with code reviews, debugging, issue logs, Metalink and Service requests. Experienced in full implementation of Oracle Apps with both technical and functional knowledge. Involved in User Training for Oracle financial modules.
• Expertise in configuring iPayment module with payment systems like Cyber Source, Chase Paymentech and Paymentric.

TECHNICAL EXPERTISE

• Programming Language: Java, SQL, PL/SQL, HTML, CSS, JSP, XML, XSD, XSLT
• Oracle Application Modules: Order Management(OM), Account Receivables(AR), Oracle Purchasing(PO), Oracle

Assets (FA), Account Payables (AP), General Ledger (GL), Cash Management (CE),
iPayment, Oracle Payment, Inventory, iExpense, System Administration and
Application Object Library, XML Publisher, Web ADI

• Frameworks: MVC
• Database Systems: Oracle 9i, Oracle 10g, SQL Server 2005/2008, MS Access
• Scripting Languages: Unix shell scripting
• Application/Web servers: Apache Tomcat.
• Operating System: Windows 98/00/XP/Server 2000 and 2003, UNIX, Linux
• Concepts: Design Patterns, Agile Software development, Client Server Architecture, Software Testing

and Quality Assurance, Operating Systems

• Other Tools: Toad, SQL Developer, Workflow Builder 2.5/2.6, Developer 2000, Forms 6i/10g, Reports

6i/10g, Discoverer 9i, Oracle JDeveloper, PL/SQL, Edit plus, SQL* Plus, SQL* Loader,

• Certification: Oracle Certified Associate (1Z0-007)

PROFESSIONALEXPERIANCE

Confidential,CA (Intelligroup) December 2009 – Present
Sr. Oracle Application Financial Techno/ Functional Consultant

• As Techno/Functional consultant, work with users through all Software Development Lifecycle (SDLC) phases
• Provide end to end design for Order to Cash cycle and Procure to Pay cycle based on their business model (Online book’s rental business)
• Gathered initial requirements, analyze business model and prepared business requirement documents (BR30s)
• Configured Oracle Financial modules like Account Receivables, Account Payables, General Ledger, Cash Management and Oracle Assets for end to end solution for end to end business solution.
• Design conversions, interfaces and prepared data mappings between legacy and Oracle
• Design and develop integration between Oracle and third parties like Webmaster, UPS, and Galileo for reconciliation perspective.
• Define Banks and all the bank related setups.
• Configured Auto Invoice process, AR Receipt process, Receipt classes, and transaction types.
• Configured Fixed Assets depreciation methods, Asset books and categories
• Configured Payment terms, Payment types, and Payment process profiles.
• Configured Web ADI for Fixed Assets and General ledger JE upload
• Design and developed various reconciliation objects for Account Receivables, Account Payables, General Ledger and Cash Management.
• Design FSG reports
• Develop various Oracle Applications using PL/SQL, SQL*Plus, Forms, Reports, Workflow Builder, and Application Object Library.
• Use Oracle E-Business Suite applications for accounts payable/accounts receivable (AP/AR), general ledger, fixed assets, and cash management, supporting data extraction, filtering, and validation.
• Create extensions using Oracle recommended frameworks. Report against Applications data model.
• Write functional, technical design documents for conversions, extensions, interfaces, and reports (BR30, BR100, CV40, CV60, MD50, MD70)
• Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs). Conduct quality reviews of code developed by other development staff.

Confidential,CA (Intelligroup) July 2009 – November 2009
Sr. Oracle Application Developer

• As a Senior Oracle Application Developer, designed and provided the integrated solution as per business model
• As a Senior Oracle application developer, I am involved in configuring the Oracle Payments with Cyber Source (External Payment system) as per business requirements. Have developed customizations and supporting issues of iPayment. Involved in configuring Oracle Payments from Order Management and Oracle Receivables perspective. Supporting issues regarding Credit Card Processing. Deployed all source code of Cyber Source in Oracle Application server. Follows J-SOX Compliance Management.
• Configured Oracle Payments with the Cyber Source for various credit card payments.
• Develop customization for Re-authorization for various credit cards.
• Resolved configuration issues with the Cyber Source.
• Activate all credit card related processes like Credit Card Authorization, Settlement, Partial settlement, credit/refund activity.
• Configuring Sample Payment system to test various test scenarios from Oracle internal perspective
• Gathering business process and business requirements.
• Performed credit card authorization tasks in Order Management (OM) and settlement in Account Receivables (AR) modules. Resolved version mismatch issues with Cyber Source
• Performed extensive work in ‘Funds capture setup administrator’ and ‘Funds capture process manager’.
• Trained users in Oracle Payments, Order Management, Account Receivables, and General Ledger functionalities.
• Prepare all the necessary documents as per the J-SOX standards. (BR100, MD50, MD70, Training documents)
• Configuring Oracle Payments on various instances by testing various test scenarios approved by business users
• Resolved issues caused by Oracle Java and database layer’s file version mismatch
• Setups in Oracle Order Management and Oracle Receivables.
• Creating Credit Card receipt class and Credit card payment method to do authorization and settlement from Oracle Order Management and Oracle Receivables for AMEX, Visa, Master Card and Discover.
• Designed and developed customizations for Reconciliation process
• Various reports as per the business requirements
• Prepared and tested various test cases (TE40)
• Schedule Auto Receipt, Auto Remittance and Submit Offline Transaction process on a daily basis at night time. This will submit all the transactions to BEP on daily basis.

Confidential,CA (Intelligroup) October 2008 – July 2009
Sr. Oracle Application Techno/Functional Consultant

• Oracle Payments Functional Consultant
• Implementing Oracle iPayment with Paymentric as a back end payment system
• Configured Oracle iPayment servlet with Paymentric web services as per the Oracle standards.
• Deploy all the required classes to connect Oracle iPayment with Paymentric in the Glassfish Application Server.
• Configuring loop back client and test various test scenarios
• Worked closely with business users to understand the business requirement and business processes.
• Have done too many customizations due to business requirements
• Create various procedures, packages and triggers for various customizations
• Have done setups in Oracle Order Management and Oracle Receivables.
• Tested various test cases for whole order cycle starting from OM to AR settlement.
• Created procedure to activate the Refund activity.
• Created Reauthorization API which do reauthorization automatically on a daily basis
• Worked with Ecomm and CRM team to import the orders into Oracle Order Management with Authorization details.
• Have tested all the possible test scenarios
• Sign-off all he required documentations. Prepared Design Documents MD50, MD70 for Oracle iPayment
• Schedule all the four processes AutoInvocie, AutoReceipt, AutoRemittance and Reauthorization API
• Schedule Refund API to run every one hour.
• Trained users on the process
• Reconciliation process
• Various reports from Oracle iPayments and Paymentric
• Resolved major issues like ‘Timeout error’, ‘Transaction Packet lost’ at the time of Authorization and Settlement
• Implemented various APIs to do Authorization and Credit Refund from back end at the database level.
• Used TOAD to research Oracle Order Management, Oracle Receivables, Oracle iPayment tables and APIs.

4) MedVantx, CA Confidential, January 2008 to September 2008
Sr. Oracle Application Developer

• As a Oracle Application Developer, I was involved in configuring the iPayment with Paymentech, supporting issues of iPayment and iExpense, the conversion, work flow customization, reports development, up-gradation to R12, JSP customization for iStore using Oracle Application Framework.
• Configured iPayment system with the Paymentech for various credit card payments. Resolved configuration issues with the Paymentech.
• Performed credit card authorization tasks in OM and settlement in AR modules. Resolved IP Address issue with Paymentech
• Performed extensive work in ‘Funds capture setup administrator’ and ‘Funds capture process manager’.
• Implemented ‘Loopback’ payment system to test out various credit card transaction scenarios.
• Worked with the Implementation of Internet Expenses, Profile setups, Workflows customization and Amex card setup according to the specification provided by the company.
• Defined Expense Templates according to the different expense types for the
• Prepared Design Documents MD50, MD70 for iProcurement and iExpenses Modules.
• Created a new Field using Personalization in OA Framework and attach a List of Values to this new field, again using Personalization in OA Framework. Created region page to be opened as the LOV page.
• Developed PL/SQL program to validate imported data file for iExpenses Credit Card Transactions according to the specifications.
• Solved iStore related performance issues like displaying of searched data was taking longer than expected by creating materialized views
• Integrated advanced pricing with order management.
• Customized Workflow Processes to include customizations like adding notification activities and time out functions in Order Management.
• Customized activity in workflow to monitor custom interface table, which get populated through EDI from 3rd party financials institute and release sales order for pick release
• Extensively worked on e-Commerce Gateway and mapped DFF in PO while importing PO orders
• Customized Reports in Order Management using Reports 10g like Sales Order Acknowledgement, Pick Slip Report, Packing Slip Report, Order Summary Report
• Created PL/SQL functions, Procedures and Packages for Custom workflow process.
• Resolved Approval issues for Oracle Purchasing (Requisition approval and Purchase order approvals.)
• Imported Assets into FA from Legacy system by writing UNIX script and SQL Loader script, PL/SQL validation and loader scripts
• Worked extensively in production support Issues in Oracle Order Management, Oracle Receivables and Payables, Asset Accounting, iPayment and iExpense.

EDUCATION

• Master of Science (Software Engineering)