SUMMARY:

12+ years of experience in Oracle eBusiness Suite application development with significant exposure to techno - functional aspects of SCM, FIN, and CRM business processes.

SKILLS:

Applications: R12, 11i

Databases: Oracle 9i, 10g, 11g

Oracle Components: FRICEW, CEMLI

Technologies: SQL, Advanced PL/SQL, JAVA/J2EE/Web-Services, OAF Personalizations/Customizations, XML publisher (RTF/EXCEL/XSL-FO), APEX, Oracle Workflow, Oracle Forms Personalizations/Customizations, Oracle Reports, Shell Scripting, HTML/CSS/XML, B2B EDI, Web ADI, exposure to Oracle 12c SOA Suite, Perl and Python Programming

Tools: jDeveloper, Workflow Builder, XML Publisher, Form Builder, SQLLDR, FNDLOAD, XML Gateway, TOAD, SQL Developer and TKProf, SQLPLUS, Report Builder, IBM Rational Rose

IT Service Management: Remedy, RT, IBM Rational Clearquest, Rally, Service Now

Version Control: GIT, Subversion, IBM Rational Clearcase, PPM

Platforms: UNIX/LINUX, Windows NT/XP

EXPERIENCE:

Senior Oracle eBS Techno-Functional Consultant

Confidential

Responsibilities:

• Hungary real-time reporting interface in Java.
• Invoice print customizations.
• OM-AR, OKS-AR and BO support.
• Built customization to handle cross charged expenses on capital projects.
• Created alerts to notify users about various events in capital projects.
• Built a BI publisher excel report for project consulting expenses.
• Built a GL interface for revenue reconciliation.
• Built GL customizations to handle estimated and deferred revenue related to ticket sales.
• Bank of America interface for Receipt/Payment/Cheque processing.
• AP Hold Notifications workflow customizations.
• Check printing template changes.
• Created an AP invoice/payment interface integration between an external invoice processing vendor and oracle eBS.
• Asentinel Payment processing interface.
• Built a supplier, supplier site and payment interface for 53rd bank.
• Remittance advice RTF template changes.
• Worked on Vertex-EBS integration.
• Created custom BI publisher Excel templates for the Create Accounting program.
• Worked on enhancements related to fixed assets creation, use tax, item cost, variance, depreciation and retirement areas.
• Built a program to calculate inventory use tax for internal sales orders.
• Built code to update customer profile at account and site levels.
• Performed TCA contact conversions.
• Built code to update customer account sites and supplier sites.
• Fixed timeout issues in the iReceivables portal using OAF customizations.
• Quoting enhancements/support.
• PLM/PIM CO enhancements/support.
• Inventory enhancements/support.
• Costing/Transfer pricing customizations.
• Supported the Manhattan-Oracle WMS integration by providing queries, bug-fixes, form customizations and performance tuning where necessary.
• Automated certain OM order entry processes according to business requirements.
• Customized OM workflows to satisfy various business requirements.
• BI report dev support, OM customization for Canada implementation, Order Summary Report and Smart Margin.
• Built a custom Web ADI solution for uploading MRP planning data.
• Provided support to Oracle-Astea integration.
• PO PDF XSLFO report and PO Receipt Interface customizations.
• BI report dev support.
• Handled service contract line updates by terminating lines with old information, creating lines with new information, creating billing schedules for newly created lines, performing QA check on the contract, changing status of the contract and resetting counters according to business logic.
• Enhancements/support related to usage counters.
• Changes to the contract creation process.
• Resolved issues related to contract billing, pricing, contract creation and OM to OKS flows.
• Implemented enhancements to the service contracts accruals process such as changing the accrual criteria, performance tuning, fixes to down-days counter calculation and daily average rate calculation.
• Built code to create/update/delete JTF territories, territory resources and queries to extract territory/technician related data.

Senior Oracle eBS Techno-Functional Consultant

Confidential

Responsibilities:

• Built interfaces between salesforce.com and oracle EBS which create/update business entities and in corporate validations based on business rules.
• Used PL/SQL XMLDOM APIs to process XML data.
• Implemented a data sync mechanism from salesforce.com to oracle EBS using SQLLDR for reporting purposes.
• Created a mechanism to allow an automobile dealer to choose alerts and deliver chosen alerts to the dealer in a timely manner.
• Implemented architecture that secures the way applications access web-services.

Oracle eBS Technical Consultant

Confidential

Responsibilities:

• Developed OAF POCs in the Financials area.
• Developed SQL queries to extract data from various modules such as Pricing, OM, Service Requests, Installed Base and TCA for data migration.
• Responsible for SQL-PL/SQL performance tuning of various objects.

Oracle eBS Techno-Functional Consultant

Confidential

Responsibilities:

• Developed OM Header/Line Workflows, Defaulting rules, B2B EDI Integration, Form Customizations/Personalizations, Shipping Interfaces/Reports, SKU Loader (item/ cross s), Customer Credit Exposure, OM-Install Base-Service Contract flows and Order/ Contract Alert notifications.
• Contributed in Pre-assessment, Design, Development, Cutover, Deployment and Post-production support phases of the implementation.
• Enhancements and support of above items in Oracle 11i prior to R12 implementation.
• Supportable Re-architecture (SCM/CRM)
• Re-designed PLSQL cartridge based application from scratch to improve existing functionality, added new functionality and made the application compatible with R12 oracle applications.
• Performed a technology evaluation by prototyping application in OAF and APEX.
• Developed APEX components such as pages, reports, interactive reports, application items, tab layouts, page level processes, conditional processes & display and collections.
• Integrated of the APEX application with oracle applications.
• Global Credit Card Transaction Processing (SCM)
• Built a JAVA interface between oracle EBS and external credit card authentication vendor leveraging the OM, iPayment and AR modules.
• B2B Implementation (SCM)
• Involved in setting up trading partners, devising a map to process and load XML data into custom DB tables and OM Interface tables leveraging the XML gateway tool.
• Developed data validation logic before calling the order import program to create orders.
• CRM
• Performed enhancements/support to the service request workflow.
• Built code to abort SR workflows, close SR, create SR notes, update SR status and send notifications.
• Performed UI enhancements and branding changes to iSupport, Customer Support Specialist.
• Built code to migrate SRs between resources.
• Implemented enhancements in email center such as a program to delete residual data in order to disassociate agents from queue, delete a queue and customized email center JSP pages according to business requirements.
• Involved in support activities such as adding resources using CRM Administrator, setting up new agents, assigning agents to queue, email center processing rules, troubleshooting missing inbound emails and emails stuck in outbox.

Oracle eBS Technical Consultant

Confidential

Responsibilities:

• Enhancements/Personalizations/Support in the Oracle Teleservices (CS, IEM, IBU) area.
• UI and functionality changes in iSupport, Tele-services and Email Center modules.

Oracle eBS Technical Consultant

Confidential

Responsibilities:

• Bill of Materials conversions.
• Enhancements/support of Oracle Quoting and OM workflows.
• Designed and developed of a JAVA/J2EE web portal that displays customer and item data.
• Enhancements/support of OM-Installed Base-Service Contract flows.
• Enhancements/Personalizations/Support in the Oracle Teleservices (CS, IBU) area.
• Project Events conversions.
• Support of OM - AR (Auto-Invoice Interface) flow.
• Responsible for development of enhancements for the Oracle Goal Setting and Sales Appraisals Module.