Computer Expertise

• Over 14 years of experience in the analysis, design, development, testing and implementation, Upgrade and enhancement of client/server applications with more than 12 years of techno functional development and support of Oracle Applications Release 12 11i.
• Excellent background of Oracle E-Business Suite in General Ledger GL , Accounts Receivable AR , Accounts Payables AP , Fixed Assets FA , Cash Management CM , Purchasing PO , Order Management OM , Supply Chain Management SCM , Bill of Material BOM , Inventory INV , Work In Process WIP , Shipping WSH , Warehouse Management System WMS , Project Accounting PA , Oracle Incentive Compensation OIC , Oracle Internet Expenses OIE , Advanced Supply Chain planning ASCP , Oracle Demantra Demand Management Demantra , iProcurement, iPayments Oracle Application Framework OAF , JDeveloper and Oracle BI Publisher XML
• Very good understanding of functional specifications, technical specifications and technical design deliverables.
• Excellent perspective of Oracle Applications technical development with five full life cycle implementations experience with exposure to implementation methodologies viz. AIM.
• Excellent Communications and Team skills.

ERP Expertise

• 12 years of experience in Oracle Applications in Operations Area on Versions 12 11i, specializing in Technical and Functional Knowledge of Oracle Modules.
• Experience in successful implementation, upgrade and enhancement of Oracle applications Release 12 11i.
• Expertise in RICE Reports, Interfaces, Conversions and Extensions Implementation and Customization of various modules including Financial Modules AP,AR,GL,FA,iPayments,CM , Oracle Purchasing PO , Order Management OM , Supply Chain Management SCM , Inventory INV , Bill Of Material BOM , Work In Process WIP , Shipping WSH , Warehouse Management System WMS , Project Accounting PA , Oracle Incentive Compensation OIC , Oracle Internet Expenses OIE , iProcurement, Advanced Supply Chain Planning ASCP and Oracle Demantra Demand Management Demantra Modules.
• Expertise in Order To Cash and Procure To Pay business streams.
• Experience in migration, Conversion, developing interfaces between Oracle Financials, Order management and CRM with legacy systems.
• In-depth knowledge of Oracle Applications interface tables and API's TCA, AR OM, OIC API's .
• Strong SQL and PL/SQL development experience creation of packages, procedures, functions, database objects, etc. .
• Worked in Forms, Reports, Shell Scripts, Oracle Workflow, BI Publisher XML, eText , XSL, OracleBI Discoverer 10g, JDeveloper, Oracle Essbase, Oracle Hyperion, NOETIX and Form OAF Personalization.
• Strong experience in manual and automation testing and test management using Mercury Test Director testing tool.
• Strong interpersonal skills, ability to interact with people at all levels
• Experience in dealing with clients, understanding their requirements and handling a team

Technical Skills

• Oracle Application: Oracle Release 10.7, 11i and 12.

• Oracle Database : 8.x, 9.x, 10g and 11g

• GUI: Developer 2000, Visual Basic 6.0.

• IDE / Tools / Utilities: Crystal Reports, Oracle Reports, Oracle Workflow 2.6, Oracle BI Publisher XML , OracleBI Discoverer 10g, NOETIX, JDeveloper.

• Other Tools : TOAD, PVCS Version Manager, SVN Version control, Mercury IT Governance Center 6.0, Mercury Test Director 8.0, PUTTY, Data Loader, Panaya, Serena Mashup

• Operating Systems: Windows 2000/XP/7, WinNT4.0, LINUX, HPUnix20, Solaris 5.8

Work Experience

Responsibilities:

• Oracle EBS R12 Implementation
• Procure to Pay Cycle.
• Requirement gathering, GAP Analysis and Project migration planning and Execution
• Leading the Team of payment process development
• Done the following functional setups and tested the business process,
• Business Stream:
• Customized the Check printing template to print in preprinted stationary.
• Reading the XML file from bank
• Customized ISO20022 format xml file for JPM Chase bank and tested
• Challenges:
• Prepared the Code migration lists as per client specification.
• Installation documents using Oracle AIM Methodology
• Test cases UTP document as per client specification
• Technical design document using Oracle AIM Methodology.
• Functional design document using Oracle AIM Methodology.
• Project migration planning and execution
• Requirement gathering and GAP Analysis
• Documentations
• Customized the customer account page to validate the account number and throw the custom exception when the external bank accounts already exists.
• OAF Customizations and Personalization
• Mapping Utility package for bank accounts
• BAI Process in Cash management
• Payment funding report to Treasury
• Payment Acknowledgment details Send email to distribution list
• Payment Inbound files from JPM CHASE to read the xml files
• Generate the Payment Global file Summary Report for Outbound files and send email to Treasury
• Designed and developed the following interfaces and business process,
• Pay on Receipt Payment Remittance
• Electronic Payment Remittance
• Positive Pay template for US Bank
• Check Print Template and Pre-printed format
• ACH payments using NACHA CCDP format
• Payment Outbound files to JPM CHASE ISO20022 in xml format using XSL
• Customized the following Payment process using XSL, eText, BI Publisher
• Pay on Receipt process
• Validate the transactions in Cash Management
• Create Accounting
• Reconciliation
• Import the bank statements and the bank statement cashflow creation
• Review the bank statements
• Bank Statement Loader.
• Process the file from bank and send the acknowledgement to treasury
• Generate the EFT file and send it to bank
• Payment Instruction Format Setup
• Mapping the bank accounts with template using custom framework
• Payment templates setup for Electronic, Check and SEPA payments
• Payment Process Profile Setup
• Implemented and tested Procure to Pay PTP cycle

Environment: Oracle Applications Rel. 12.1.3, Purchasing PO , Accounts payables AP , Payments IBY , Accounts Receivables AR , General ledger GL , Cash Management CM , Inventory INV , Shipping WSH , Forms 10g, Reports 10g, Oracle BI Publisher XML , SQL Loader, JDeveloper 10g, OA Framework, Data Loader, TortoiseSVN, TOAD.

Responsibilities:

• Oracle EBS 11i Enhancement R12 Upgrade.
• Requirement gathering and prepared the GAP Analysis.
• Done the following functional setups and tested the business process,
• Business Stream:
• Customized the Check printing template to print in preprinted stationary.
• Created the subscriptions and attached to the business event on concurrent program completed to change the ACH and positive pay file names as per business for Bank of America.
• Challenges:
• Prepared the Code migration lists as per client specification.
• Test cases UTP document as per client specification
• Technical design document using Oracle AIM Methodology.
• Functional design document using Oracle AIM Methodology.
• Requirement gathering and GAP Analysis
• Documentations
• Customized the iProcurement requisition self-service page to add new field location to display the location name for tax location code.
• Customized and Extended the Internet Expenses approver worklow notification email.
• Customized and Extended the Internet Expenses Submit page using JDeveloper and OA Framework.
• Customized and Extended the Internet Expenses General Information page using JDeveloper and OA Framework.
• Customized the webADI OAF page to display the default currency and organization and based on from date, to date will display automatically as per business.
• Customized the supplier address information address line1 to validate the information defined by business while adding new supplier as well updating the existing one using JDeveloper and personalize the OAF page to call the custom controller class file.
• Customized the customer address information address line1 to validate the information defined by business while adding new customer as well updating the existing one Using JDeveloper and personalize the page to call the custom controller class file.
• OAF Customizations and Personalization
• Implemented iExpense functionality to approve the expenses using AME.
• Inventory Item Category combination creation interface.
• Interface to Update Inventory Item template.
• Inventory item creation interface
• GL P L accounts and Balances Extract and load into Oracle Essbase and designed the cube as per business.
• GL budgets Extract and load into Oracle Essbase and designed the cube as per business.
• Designed and developed the following interface, conversions and business process,
• OM Dispatch Note report
• OM Split Feature bill report
• PO Approval document Email report
• Inventory Item Category Combination report
• Asset Zero net book value project report
• Asset annual depreciation projection report
• Asset additions retirements by costcenter report
• GL ledger subledger analysis report
• AP invoice onhold report
• AP Vendor Settlement letter
• Duplicate payments and similar and difference invoices report
• Capitalization Threashold report
• AP Invoice match to PO report.
• Designed and developed the following reports using BI Publisher and Oracle Essbase
• Designed and developed the database triggers in ap invoice distributions to achieve the results as per business.
• Personalized the collections form accounts tab customer standard button to call the standard Customer OAF screen in view only mode.
• Developed a custom interface to transmit the cost center level information to the third party system from iPayments.
• Developed a custom package using the iPayments API's to derive the Authcode for the implementation of Credit Card Verification and Authorization process.
• Validated and tested Creadit card / Purchase card payment in iPayments.
• Payment process request report sort by paygroup
• Selected payment schedules report sort by paygroup
• Positive Pay template
• Check Print template
• NACHA ACH CCDP template
• Customized and extended the following Payment process using eText, BI Publisher
• IPayments API's to derive the Authcode for the implementation of Credit Card Verification and Authorization Process
• Reconciliation
• Financial Tax Register
• AR Dunning Letter
• AR Auto lockbox
• Internet Expenses Templates and approvals
• Electronic and Check payment templates
• For payment process. Including Payment Instruction Format and Payment process profile.
• Implemented and tested Procure to Pay PTP cycle

Environment: Oracle Applications Rel. 12.1.3 11i, Purchasing PO , Accounts payables AP , Accounts Receivables AR , General ledger GL , Fixed Assets FA , Advance Collections IEX , Cash Management CM , Order Management OM , Inventory INV , Oracle Internet Expenses OIE , iProcurement, iPayments, Forms 10g, Reports 10g, Oracle BI Publisher XML , SQL Loader, JDeveloper 10g, OA Framework, Data Loader, Oracle Essbase, Oracle Hyperion, Panaya, Serena Mashup, TOAD.

Responsibilities:

• Done the Oracle EBS 11i Enhancement R12 Upgrade for ATLAS North America, Europe, South America.
• Done the Oracle EBS R12 Implementation for China, Australia and Korea.

• Designed and developed the following reports using BI Publisher, Oracle Discoverer and Noetix,
• Bank Interface program to send the payments details to Bank and receive the acknowledgement and Reconcilation file from bank and processed in cash management. Used PGP for encrypting and decrypting files.
• SCM Trax BOL ship zone locator interface program
• Bills of Materials Interface
• INV category combination conv program
• INV assign items to Org program
• OM Price List Extract program
• OM EPA Conversion program
• OM Chempax Order Tracking Number Extract program
• OM DRM customer update extract program
• Interface to Posting OIC to GL.
• Interface program to derive GL Code combinations in OIC Commission lines.
• Price List extract program.
• AP Trial Balance Extract Program.
• AR Collection Credit Comment Notes Conversion.
• Open AR Invoice conversion.
• AR Auto lockbox interface.
• SCM email notifications to smart link manager group using workflow.
• AP AR Refund process interface to automate the AR Refunds into AP invoices for payment. Process will allow the payables department to create payments to reimburse customers for refunds from the AR.
• GL Journal entry legal information database trigger to update the description of the JE line with the required information while inserting Journal Entry lines as a result of the execution of the standard oracle process to transfer payables information to General ledger.
• Colombian GL Transfer third party information to statutory book interface program for transferring third party key fields from Colombian corporate book with corporate COA to local book with local statutory COA. This process will run after the GL Standard Consolidation process complete.
• Special Character conversion interface program. This program called from Bank interface AP EFT program for replacing the special character to defined values.
• Designed and developed the following interface , conversion and business process,
• Supplier address lines to restrict the characters for particular responsibility
• IExpense Costcenter and manager maintenance extension
• Form to maintain OM Transfer and Adjust sales credit details
• AP Special Character extension for AP Bank interface program.
• Designed and developed the following extensions and personalization,
• WMS Packaging History
• WMS Dispatch Task History
• OM Dropship
• China Dunning letter, Dispatch Note, Purchase Order and Workorder Reports
• AP Statutory report using Noetix
• GL Statutory report using Noetix
• OIC Payrun Analysis
• GL Summary by OIC Plan
• OIC Charges against sample and advertising items
• OIC Delinquent payment and commission Chargebacks
• OIC Billing list detail and summary
• OIC Commissioned detail and summary
• SCM ship return BOL report
• SCM Return and Ship to Bill of lading
• Chile Dispatch Note to print in pre-printed stationary using dot-matrix printer
• Chile AR Invoice to print in pre-printed stationary using dot-matrix printer
• AR Dunning letter
• Revenue Recognition localization to brazil and Columbia
• French Remittance Advice
• Italian Journal Book localization
• Italian Purchase VAT Register localization
• Brazilian Check Printing to print in pre-printed stationary using dot-matrix printer
• Columbian Check Printing to print in pre-printed stationary
• Account analysis and subledger report
• Customized and Setup the credit card programs and loaded the credit card details from AMEX and VISA to AP credit card tables and enter the Expenses with credit card details.

OAF Customizations and Personalization

• Customized the Internet Expense pages Title and column names to local language using OAF personalization.
• Customized and Disabled the columns in Internet Expenses Home page using personalization.
• Customized and Extended the Ineternet Expenses General Information page to display company and location details using JDeveloper and OA Framework.
• Customized and Extended the Ineternet Expenses General Information page to display the approver automatically based on the company, location and costcenter automatically.
• Customized and Extended the Internet Expenses General Information page Access Authorizations functionality to display the approver while changing the name.
• Customized and Extended to display the Expense Template automatically based on the responsibility.
• Customized and Extened to validate the Expense location on Cash and Other Expenses: Details for Line1 page as mandatory column.
• Customized the Create Expense Report: Review page to display the custom message on the Header using personalization.
• Customized and Extened in Internet Expenses Confirmation and print page on General information and cash and other expenses region using JDeveloper and OA Framework Personalization.
• Customizated and Extened the Regions to display the additional columns on Action Required and Approval Notifications.
• Designed and developed the Purchase Overprice Freight page using JDeveloper and OA Framework.

Documentations

• Prepared the Technical design document using Oracle AIM Methodology.
• Prepared the Functional design documemnt using Oracle AIM Methodology.
• Prepared the Code migration lists as per company policy.

Challenges:

• Customizing Rx-only Financial Tax Reports.
• To Print Preprinted Check Invoice stationary using Dot-Matrix printer.
• IExpenses OA Framework Customization and Personalization.
• Communicate with the Bank technical team and implemented the Automated Bank Interface process.
• Created the SR and worked with Oracle to solve the issues on IExpense R12 Upgrade.
• While doing IExpense Auditing and expense detail page is not displayed on standard oracle functionality. And worked with the oracle support and applied the patch and resolved the issues.
• Wrote the scripts to send the AP Check payments to Bank Automatically.

Environment: Oracle Applications Rel. 11i 11.5.10 12.1.3, Accounts Receivable AR , Accounts payables AP , iPayment, General ledger GL , Cash Management CM , Purchasing PO , Oracle Incentive Compensation OIC , Oracle Internet Expenses OIE , Supply Chain Management SCM , Order Management OM , Bill of Material BOM , Work In Process WIP , Inventory INV , Shipping WSH , Warehouse Management System WMS , Forms 6i 10g, Reports 6i 10g, Oracle BI Publisher XML , Noetix, OracleBI Discoverer 10g, JDeveloper 9i 10g, OA Framework, SQL Loader, Data Loader, PL/SQL, TOAD, PVCS.