SUMMARY:

• Around 11 years of experience in oracle eBusiness suite application development with significant exposure to techno - functional aspects of O2C, OM-OKS, P2P and CRM business processes.
• Significant exposure to Order Management (OM), Pricing (QP), Inventory (MTL), Shipping (WSH), Installed Base (CSI), Service Contracts (OKS/OKC), Accounts Receivable (AR), Accounts Payable (AP), Purchase Orders (PO), iExpenses (OIE), General Ledger (GL), iPayments (IBY), Service Requests (CS), iSupport (IBU), Email Center (IEM), Oracle Alerts (ALR) and Trading Community Architecture (TCA) modules and APIs.
• Expertise in building FRICEW/CEMLI components.
• Significant experience in application development using SQL, Advanced PL/SQL, JAVA/J2EE, Workflow, Shell Scripting, and Performance tuning.
• Strong exposure to AOL, OAF, APEX, Forms, CUSTOM.pll, HTML, CSS, XML, PERL and Reports.
• Highly Skilled in using tools such as jDeveloper, Workflow Builder, Form Builder, SQLLDR, FNDLOAD, XML Gateway, TOAD, SQL Developer and TKProf.
• Significant exposure to end-to-end implementations and support activities in both 11i and R12 oracle e-Business suite.
• Significant experience in formulating MD050, MD060, CV040, MD070, CV060 and MD120 documents by interacting with the client/Business System Analyst (BSA) where required.
• Expert level skill in developing High Level Technical Design Documents (TDD), and supporting component design/UI documents.
• A self-starter and self-learner. Possess excellent communication skills and demonstrated them during interaction with business users while gathering requirements, presenting resolution details and discussing/ironing out various issues with business processes in a support environment.
• Excellent team player with a constructive problem-solving attitude. Have made many key contributions to various projects and received s from management and team-members.

TECHNICAL SKILLS:

Applications: R12, 11i

Databases: Oracle 9i, 10g, 11g

Oracle Components: FRICEW, CEMLI

Modules: Order Management (OM), Pricing (QP), Inventory (MTL), Shipping (WSH), Installed Base (CSI), Service Contracts (OKS/OKC), Accounts Receivable (AR), Accounts Payable (AP), Purchase Orders (PO), iExpenses (OIE), General Ledger (GL), iPayments (IBY), Service Requests (CS), iSupport (IBU), Email Center (IEM), Oracle Alerts (ALR) and Trading Community Architecture (TCA)

Technologies: SQL, Advanced PL/SQL, JAVA/J2EE, OAF, Oracle Workflow, Oracle Forms, CUSTOM.PLL, Shell Scripting, PERL, HTML, CSS, XML, Oracle Reports

Tools: jDeveloper, Workflow Builder, 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

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

Operating Systems: UNIX/LINUX, Windows NT/XP

Methodologies: Agile, AIM

PROFESSIONAL EXPERIENCE:

Confidential, Waukegan, IL

Senior Oracle eBS Technical Consultant

Responsibilities:

• R12 Service Contracts Invoice Stabilization:
• Created billing schedules by calculating weekly/monthly billing periods based on the billing start and end dates.
• Handled business processes such as installs, conversions and removals by terminating contract lines, creating new contract lines/sub-lines, creating billing schedules and resetting counters according to process requirements.
• R12 OM-OKS Enhancements/Customizations:
• 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.
• Resolved issues related to contract billing, pricing, contract creation, usage counters and OM to OKS flows.
• Implemented enhancements to extract contract, invoice and order data, based on contract type and other parameters.
• Performed form customizations to capture service contract details for manual invoicing.
• Developed code using SQL, Advanced PLSQL and Forms.
• UK Service Contracts Implementation
• Conversions
• Contributed to the service contracts conversion effort by providing code for the following actions:
• Create service and covered lines.
• Create billing schedules.
• Extensions
• Updated fields in AR Interface table for records related to UK contracts.
• Added validation rules (Ex: agreement number, percent share and invoicing checks) to the service contracts QA check process.
• Updated service contract lines by terminating lines with old information, creating lines with new information, creating billing schedules for newly created lines, performing QA check on the contract and changing status of the contract according to business logic.
• Implemented changes to the contract creation process.
• Implemented changes to queries used by BI reports.

Confidential, Carmel, IN

Senior Oracle eBS Technical Consultant

Responsibilities:

• UPA Implementation (R12 EBS Integration with SFDC/Java Web Portal):
• Implemented form customizations to integrate Oracle EBS form functionality with salesforce.com.
• Built interfaces between salesforce.com and oracle EBS which create/update business entities and in corporate validations based on business rules.
• 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.
• Developed code using SQL, Advanced PLSQL (including XMLDOM), Forms, Alerts and SOAP web service technologies.
• R12 Oracle Applications Enhancements:
• Responsible for support, customizations and enhancements related to Confidential ’s O2C, P2P and TCA business flows including OM Workflows and Auto-invoice/Auto lockbox interfaces.
• Contributed in support activities related to Nightly Extracts, Alert notifications and AP Invoice generation.
• Developed code using Forms, Workflow, Alerts, CUSTOM.pll and PLSQL/SQL.
• Web-Service Security Implementation:
• Implemented architecture that secures the way applications access web-services.
• Contributed in Design, Development, Testing, Deployment and Post-Production activities.
• Developed code in SQL, PLSQL and Java Technologies.

Confidential, Raleigh, NC

Senior Oracle eBS Technical Consultant

Responsibilities:

• R12 Re-Implementation:
• Implemented 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.
• Developed components using Oracle forms/workflow, SQL/Advanced PLSQL, Soap Web Services, Alerts, and OAF technologies.
• 11i/R12 Support and Enhancements:
• Developed Customizations and enhancements related to OM Header/Line Workflows, Shipping Interfaces, Defaulting rules, B2B EDI Integration, Form Customizations/Personalizations, OM-Install Base-Service Contract flow, Order-Contract alert notifications, AR Auto-Invoice/Auto-Lockbox Interfaces and SKU-Loader.
• Development of enhancements using Forms, Workflow, CUSTOM.pll, OAF and Advanced PLSQL/SQL.
• Supportable Re-architecture:
• Re-designed PLSQL cartridge based application from scratch to improve existing functionality, added new functionality and made the application compatible with R12 oracle e-business suite.
• 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 eBusiness suite.
• Developed code using SQL/Advanced PLSQL(including XMLDOM) and Soap web-services.
• Global Credit Card Transaction Processing:
• Built an interface between oracle EBS and external credit card authentication vendor leveraging the OM, iPayment and AR modules.
• Developed code using JAVA/Advanced PLSQL/SQL technologies.
• B2B Implementation:
• 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 in SQL/PLSQL before calling the order import program to create orders.
• Developed code using Advanced PLSQL/SQL (including XMLDOM) incorporating TCA APIs.
• Oracle CRM Enhancements:
• Performed enhancements/customizations to the service request workflow.
• Built code to abort SR workflows, close SRs, 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 queues and 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.
• Upgraded email center first from 11.5.10.2 to 11.5.10.3 and then to R12.
• Common Tasks:
• Building Technical Design Documents, Unit-testing, Performance optimization and code review.

Confidential

Oracle eBS Technical Consultant

Responsibilities:

• Developed customizations and enhancements related to OM Header/Line Workflows, OM-InstallBase-Service Contract flows and AR Auto-Invoice/Auto-Lockbox interfaces.
• Extracted data from various modules such as Pricing, OM, Service Requests, Installed Base, Service Contracts and TCA for data migrations.
• Implemented Enhancements/Personalizations/Customizations in the Oracle Teleservices (CS, IEM, IBU) area.
• UI and functionality changes in iSupport and Tele-services.
• Built packages and concurrent programs to abort/close, change ownership of service requests and change ownership of install base items.
• Built APIs to end-date users, responsibility assignments, responsibilities as a part of CRM maintenance activities.
• Developed code using Forms, Workflow, JAVA/J2EE, CUSTOM.pll, OAF and Advanced PLSQL/SQL technologies.
• Involved in Performance tuning, building technical design documents, unit testing and code review.

Confidential

Oracle eBS Technical Consultant

Responsibilities:

• Implemented Enhancements/Personalizations/Customizations in the Oracle Teleservices (CS, IEM, IBU) area.
• UI and functionality changes in iSupport, Tele-services and Email Center modules.
• Developed enhancements using Workflow, JAVA/J2EE, OAF and PLSQL/SQL.
• Involved in preparing technical design documents, unit testing, and performance tuning and code review.

Confidential

Oracle eBS Technical Consultant

Responsibilities:

• Implemented Bill of Materials and Project Events Data Conversions.
• Designed and developed of a JAVA/J2EE web portal that displays customer and item data.
• Developed enhancements/customizations related to Oracle Quoting, OM workflows, OM-Installed Base-Service Contract flows and AR Auto-Invoice Interface areas.
• Implemented Enhancements/Personalizations/Customizations in the Oracle Teleservices (CS, IBU) area.
• Responsible for development of enhancements and optimizations for the Oracle Goal Setting and Sales Appraisals Module.
• Developed code using Forms, Workflow, CUSTOM.pll, JAVA/J2EE, OAF and PLSQL/SQL technologies.