We provide IT Staff Augmentation Services!

Sr Oracle Ebs Technical Consultant Resume

5.00/5 (Submit Your Rating)

Sunnyvale, CA

SUMMARY

  • Over 11+ years of experience in Oracle E - Business Suite versions R12/11i. Oracle Application project(s) experience in Order Management (OM), Warehouse Management(WMS), Shipping(WSH), Inventory (INV), Procure to Pay (P2P), Work in Process (WIP), Bill of Material(BOM), Trading Community Architecture (TCA), Account Receivables(AR), Service Contracts(OKS), Install Base(IB), Oracle Trade Management.
  • Techno-functional in Order to Cash (OTC) and Procure to Pay (P2P) life cycles. Extensive technical experience in Trading Community Architecture (TCA).
  • Experienced in developing advanced PL/SQL, Oracle Forms, XML publisher reports, Oracle Workflow, OAF, Java, Alerts, Reports, Forms personalization, Performance Tuning and Materialized views.
  • Techno-Functional onsite lead for deliverables, resources, schedules, and risks for multiple projects using AIM methodologies.
  • Led the development of Interfaces, Inbound and Outbound Conversions using standard API’s.
  • Fluent in working with the business to gather requirements for functionality extensions to seeded Oracle Functionality.
  • Technical Lead for the maintenance of the development plan, tasks allocation & monitoring of the issue logs as well as processes and preparation of issue logs.
  • Experience in System Administration with hands on experience in creating Users, Responsibilities, Request Groups, Menus, registering concurrent programs, defining Value sets and Descriptive Flex fields.
  • Experienced with multiple version control tools including PVCS, SVN, TFS and Harvest.
  • Extensive experience in writing complex Procedures, Packages, Functions, Triggers, using SQL and PL/SQL.
  • Extensive experience in using Oracle Forms & Reports builder and build Oracle Forms and Reports for the custom business process.
  • Extensive experience in developing XML publisher reports and E-mail, FTP the reports using XML Bursting for the custom business process.
  • Developed EDI (EDI309), Bapelie format E-text XML publisher reports for Customs and Border protection(CBP).
  • Extensive experience in using Workflow builder and build Oracle workflow for the custom business process
  • Extensive experience in performance tuning, table partitions and working on Materialized views.
  • Extensive experience in working on Oracle EBS AOL objects.
  • Extensive experience in data analysis and Engineering for new development.
  • Developed monitoring scripts, Created Cron job Alerts, Performed application enhancements & customizations as well as Performance tuning.
  • Proactively monitored Application Processes (Workflow, Concurrent requests, API’s), identified enhancements, and led Root cause analysis for a bug and development requirements.
  • Have basic functional knowledge and strong technical details in all Oracle Financial modules

TECHNICAL SKILLS

ERP: Oracle E-business Suite (11.5.10 and R12)

Work Areas: Oracle Forms, XML publisher reports, XML Bursting, OAF, Workflow, Oracle Alert, Form Personalization, and Interfaces

Database: Oracle 9i/10g

Languages: SQL, PL/SQL, UNIX, Shell Scripting

Reporting Tools: BI Publisher, Developer suite 10g

Tools: and Utilities: Oracle Forms and Reports builder, PL/SQL Developer, TOAD, SQL Developer, JDeveloper, SQL*Loader, Putty, CoreFTP, Remedy V7, Appworx, Lotus Notes7, Harvest Workbench, PVCS, HP PPM, Kintana, Quality Centre, JIRA, Cherwell, Minitab and Microsoft SharePoint

Operating Platforms: Windows 7 and 10

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, CA

Sr Oracle EBS Technical Consultant

Responsibilities:

  • Designed, developed and Integrated Inbound and Outbound inventory interface between Oracle and NetSuite.
  • Designed and developed Oracle 606 Data Collection program for Sales Order, Project Accounting, Service Contracts and Invoices.
  • Designed and developed Sales order update process for Service Contract Partial termination, Credit and Rebill Invoice or Credit Memo modifications, Contract Suppress credit(no CM).
  • Developed reverse logistics procedure to process credit memo and RMA’s.
  • Developed Cost of Goods Sold account and Cost amount update program for Sales order- CTO items and RMA’s
  • Designed and developed Service contract update process for renewal contracts - renewal contract termination and contract modifications
  • Designed and developed excel utility to extract, update and upload into Oracle 606 Data Collection tables.
  • Worked on Retrofitting PL/SQL codes from 605 to 606.
  • Customized Credit and Re-Bill Oracle form to store original Sales Order/invoice data for Re-bill credit memo and invoice.
  • Developed a process to update attributes for Hardware, License and Subscription Sales order by linking the serial number from Install base.
  • Developed OAF page to search,add,delete,update lookup values for Data collection program table maintenance.
  • Developed OAF page to display the Unit test results based on a test case. Page displays list of dynamic columns required for a test case with status pass or fail for a Sales order/Invoice.
  • Developed OAF page to submit concurrent program to re-process Sales order/Invoice data into Revpro system.
  • Worked extensively in Advanced PL/SQL development and performance tuning
  • Worked with DBA’s to migrate the objects between instances.

Environment: Oracle Applications E-Business -Oracle R12, JDeveloper, Oracle Forms, PL/SQL, Java, TOAD, UNIX, SVN.

Confidential, Sunnyvale, CA

Sr Oracle Technical Consultant

Responsibilities:

  • Designed, developed and Integrated Inbound and Outbound inventory interface between Oracle and NetSuite.
  • Worked for TCA analysis, reports and reconciliation- Customer data, Customer-Item-Pricing, Customer credit limit and identifying the customer data to be corrected before integrating with NetSuite.
  • Worked for Open sales order extract for different regions (US, AU, CA, EMEA and APAC) to migrate to NetSuite.
  • Customized Order import program and requisition import program for dropship sales order.
  • Customized retail order import program to create Inter-company sales order.
  • Customized PO ASN(EDI 856) re-process process.
  • Personalized Oracle sales order form to make the customer PO and Customer PO line number mandatory for specific set of Order source and Item.
  • Worked as part of R12 upgrade (11i to 12.2.5) team to upgrade all the objects involved in SCCS Consumer products team.
  • Single point of contact for R12 related code changes and retro-fitting in SCCS Consumer products team.
  • Worked extensively in Advanced PL/SQL development and performance tuning.
  • Worked with DBA’s to migrate the objects between instances.

Environment: Oracle Applications E-Business, Oracle 11i, Oracle R12, Oracle Forms, PL/SQL, TOAD, UNIX, Confidential custom applications for version control and migration.

Confidential, Charlotte, NC

Senior Oracle Applications Technical Consultant

Responsibilities:

  • Worked directly with Business users and Functional lead for requirements and analyzing the existing process.
  • Developed custom Oracle XML publisher reports for Order Management, Inventory and Oracle Trade Management modules based on the custom business requirements.
  • Developed custom Oracle forms for Order Management and Oracle Trade based on the business requirements.
  • Developed API to process customer and product related data from Oracle to Trade.
  • Developed custom concurrent program in Oracle Trade for Promotion, Base Promotion, Sales and Budgets.
  • Developed complex Materialized views for Promotion, Base promotion, Sales and Budgets.
  • Good experience in working on Million records (Huge volume) of data, table partitions, complex PLSQL packages and Performance tuning.
  • Worked with DBA’s to migrate the objects between instances.
  • Developed complex XML publisher report using SQL analytical functions to present the Trade promotion and base promotion details with alternate color coding decided based on the runtime data in the Excel sheet output.

Environment: Oracle Applications E-Business, Oracle R12, Oracle Forms, PL/SQL, TOAD, UNIX, Shell scripting, BI (XML) Publisher.

Confidential, Ft Lauderdale, FL

Senior Oracle Applications Techno Functional Consultant

Responsibilities:

  • Worked directly with Business users and Functional lead for requirements and analyzing the existing process. Wrote Technical Design Documents (MD70s) based on the Business Requirement document.
  • Developed custom Oracle XML publisher reports for Order Management, Oracle Shipping and Inventory modules based on the business requirements.
  • Developed custom Oracle forms for shipping modules based on the business requirements.
  • Developed custom concurrent program for Order management and Shipping modules process.
  • Developed AR interface to create invoice for Inbound Bill of lading in shipping module.
  • Developed EDI309 reports and Bapelie format reports for CBP.
  • Developed Oracle XML publisher reports and used XML Bursting to FTP the EDI files in specific format and integrated with Customs and Border protection (CBP) and Flagship interface.
  • Developed Materialized view for the external users Oracle reports.
  • Worked with DBA’s for the Code migration activities.

Environment: Oracle Applications E-Business, Oracle R12, (OM, WSH & INV), Oracle Forms, PL/SQL, TOAD, UNIX, Shell scripting, BI (XML) Publisher and XML Bursting.

Confidential, Bloomington, MN

Senior Oracle Applications Techno Functional Consultant

Responsibilities:

  • Worked directly with Business users for requirements and analyzing the existing process. Wrote Functional Design Document (MD50s) and Technical Design Documents (MD70s) based on the Business Requirement document.
  • Developed complex Item quality UNIX shell script reports inclusive of; List of items with ATO flag turned off, Unit cost NULL or Zero etc.
  • Modified concurrent program to enable/disable Item category and Category sets parameter based on the type of Item quality script selected from the parent concurrent program.
  • Modified Order interface program and the respective Order import program to populate ship to contact information from legacy systems to Confidential Oracle database.
  • Modified Service order Roll and print program to bypass print for specific type of Order types and order status Entered.
  • Developed script to cancel WIP jobs that were cancelled and not marked as cancelled in WIP base tables.
  • Developed script to check for inactive sales rep, skip processing and report error in the Commission load program.
  • Developed Sales orders using XML Publisher to report the list of sales order based on requested, scheduled ship date and service types.
  • Led code review to ensure the work delivered by the team meets or exceeds high quality standards. Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT).
  • Helped QA analysts and technical team with troubleshooting and fault resolution. Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met.

Environment: Oracle Applications E-Business, Oracle R12, (OM, INV & WIP), PL/SQL, TOAD, UNIX, Shell scripting, BI (XML) Publisher, PL/SQL.

Confidential, Bloomington, MN

Lead Oracle Applications Techno Functional Consultant

Responsibilities:

  • Conducted Functional and Technical requirement gathering meetings for Asia Pacific, Latin America and Europe
  • Led development team at onsite and offshore to successfully meet the technical milestones as per development plan ensuring quality and schedules. Established quality processes and ensured they were followed as per defined standards and guidelines.
  • Tracked daily development of RICE components with offshore development team and updated the status to onsite project manager. Developed multi-lingual reports (Hungarian, Spanish and English)
  • Developed complex global Order management booking and order backlog using XML publisher. This report matched all the three World areas requirements in one report. Each World area followed different business processes of the three World areas and consolidated in one report.
  • Developed additional Order management reports including; Sales report, Request date and Promise date service level report.
  • Developed Trade documents Order Acknowledgement, Oracle purchasing PO print report, Invoice print, Proforma invoice, Delivery note with respective Terms and conditions for different World areas.
  • Developed custom Oracle workflow for Inventory reservation in Oracle order line workflow using Oracle Workflow builder 2.6.3.5.
  • Developed Common Unit related data load program to load data into Sales order URD tables based on the Purchase order receipt.
  • Developed Common Unit related data load program to load Tag and Calibration notes into Sales order URD tables based on the Sales order line attachments with specific Notes types.
  • Tuned SQL and PL/SQL to improve the performance of custom programs. Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT).
  • Helped QA analysts and technical team with troubleshooting and fault resolution. Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met.
  • Validated technical designs created by Developers against functional specifications. Coordinated with Offshore team and guided them to develop the database objects
  • Prepared the Unit test plans and supported the users in CRP, SIT and UAT. Involved in the Release process and created the Kintana packages and managed the version of objects in PVCS for promoting the code and AOL objects.
  • Led the team members in resolving the CRP, SIT, UAT and Post Production issues.
  • Trained team members on how to develop XML publisher reports.

Environment: Oracle Applications E-Business, Oracle R12, (OM, PO, INV), PL/SQL, TOAD, UNIX, PL/SQL, BI (XML) Publisher and Workflow builder 2.6.3.5.

Confidential, Mansfield, Ohio

Oracle Applications Technical Consultant

Responsibilities:

  • Technical lead for Gap Analysis sessions. Analyzed the requirements and prepared the Technical documents. Led peer reviews of code and document development.
  • Used XML publisher (output in Excel/PDF) to develop the following reports: Oracle projects, Capital Summary, Product Summary, Project detail and Reason code
  • Developed complex Oracle Projects approval workflow using Oracle Workflow builder with different hierarchy approval that Sent reminders, group approval decisions, timeouts, and auto rejects.
  • Developed Oracle PO account and Invoice supplier account generation workflow using Oracle Workflow builder.
  • Developed Oracle event alert to check whether budget excess X% or not.
  • Developed Oracle event alert notifications to send notification e-mail to project approvers to indicate the project exceeds budget at three different levels 90%, 95% and 100%.
  • Developed Forms personalization to validate and pop up message to users when there is a mismatch between project task and expenditure type capital and vice versa.
  • Worked with change management team to migrate the objects from development to production environment.
  • Prepared the Unit test plans and supported the users in CRP, SIT and UAT. Post production Support

Environment: Oracle Applications 11.5.10, Project Accounting (PA), Oracle 10g, Oracle Developer Suite 10g, TOAD, UNIX, BI (XML) Publisher, Oracle Workflow builder 2.6.3.5, Oracle Alert, Forms personalization, PL/SQL

Confidential

Offshore Oracle Applications Technical Consultant

Responsibilities:

  • Worked as the offshore technical Team Lead for Confidential Technology 24x5 OM Production Support.
  • Held Monthly and Quarterly metrics meetings with the Clients to discuss the health of the application, frequently occurring issues and Process improvement for Order Management, Purchasing, Inventory, Shipping, Return Management system, Return Management system and Factory demand and e-commerce.
  • Held monthly development meeting and sent weekly status reports to clients.
  • Worked on minor enhancements of all RICE Components. Worked for database related issues in the live production environment
  • Proactively monitored Application Processes including Workflow, Concurrent requests, and API’s to identify enhancements. Root cause analysis for bug and development requirements.
  • Developed application monitoring scripts for Inventory, Shipping and Order management modules inclusive of; Oracle shipping transactions monitor, Inventory discrepancy, and product discrepancy report.
  • Created Cron job Unix Alerts for Application monitoring, long running concurrent programs.
  • Performed application enhancement & customization activities to Accomplish Performance tuning tasks.
  • Mentored new team members on the Confidential business process and customizations of Order Management, Shipping and Inventory process.

Environment: Oracle Applications 11.5.10 (OM,PO, INV, Shipping,RMS), Oracle 10g, Oracle Developer Suite 10g, Reports 6i, TOAD, UNIX, BI (XML) Publisher, Oracle Workflow builder 2.6.3.5, PL/SQL, Appworx, Remedy, Lotus notes.

We'd love your feedback!