We provide IT Staff Augmentation Services!

Oracle Techno Functional Consultant Resume

5.00/5 (Submit Your Rating)

SUMMARY:

  • Leading Oracle E - Biz Techno Functional Consultant with 17 + years of experience in developing software programs for complete industry solution including Inventory, Order booking, Production planning, Materials, Stores & Purchase Management System including Analysis, System
  • Over 15 years of experience in Oracle ERP implementations with extensive experience in Functional and Technical areas of Oracle Applications.
  • Design, Coding, Quality Assurance, Testing, Implementation and Database Administration.

TECHNICAL SKILLS:

Oracle Applications: ERP Release 12(12.x.x), 11i, 11.0.3 N.C.A. (3 Tire Architecture), 10.7 S.C Architecture),GL, SLA, AGIS, EB Tax, P2P, O2C, Fixed Assets, Project Accounting, TCA/CDH, Discrete

Manufacturing: (BOM,WIP, MS/MRP, ASCP, Quality), Advanced Pricing, Shipping, Transportation and Logistics, Service contracts, Install Base, Depot Repair, AOL, Alerts and System Admin.

Design Tools: Erwin, BP win.

Office Tools: MS Office (Word, Excel, Power Point, Access, Visio and MS Project)

Front / Back End: Oracle 11g, 10g, 9.x, 8.x & 7.x XML Publisher and Developer 2000 (Forms - 4.5 & 6i & Reports - 2.5 & 6i), XML Publisher

Languages: C, C++, VB, Java (Core Java, J2EE),PL \ SQL, SQL +SQL Utilities: (Import, Export, SQL * Loader 7.1, 8i), Oracle Workflow

O/S: Windows 10, Windows 2000, 95 & 98, NT 4 & WIN2003, MS DOS, HP 9000 UNIX

PROFESSIONAL EXPERIENCE:

Cisco Systems Inc

Oracle Techno Functional Consultant

Responsibilities:

  • Gathered the business requirements from the key stake holders and end users and prepared Business Requirement Documents (BRD) with through understanding of Cisco Business Process.
  • Worked with Cross functional teams and off shore co-ordination.
  • Presented the Business Requirement Document to large business user group and cross functional teams with appropriate solution for approval.
  • Worked extensively on Service Contract and IB data Integration with Third party tools like Sales Force, Aria etc.,
  • Testing and validating IB / SC Changes for the RMA Product returns and Replacement Shipments for accurate IB Updates.
  • Performed SLA (Sub Ledger Accounting) Configuration for International shipments (Across operating units, to capture Intercompany accounting related JVs.
  • Worked extensively in trouble shooting AGIS (Advanced Global Intercompany System) for Intercompany Accounting.
  • Reviewed the Functional Specification Document (MD-50) and Technical Specification Document (MD-70)prepared by IT and technical team for development of reports and workflow customizations. Closely worked with technical team for development of custom programs, reports etc. and provided the solutions to development team instantly.
  • Worked extensively on OTM integration including interfacing Carrier’s Rate Cards and Data extraction from Pick Release program for OTM Planning.
  • Worked on WMS configuration, defining Put Away and Cross docking rules, Eliminating comingling issues.
  • Engaged in Solution design and contributed on Core EBS process improvements.
  • Coordinating with decision makers, systems owners, and end users to define the future system.
  • Understanding the Gap and developing the solution to custom approaches using R11 extensions.
  • Extensively worked on B2B messaging and Mulesoft Integration
  • Conducted the Conference Room Pilot (CRP’s) sessions in requirement gathering and solution design phases.
  • Oracle Shipping Execution with Virtual Trader integration for getting Commercial Invoice valuation.
  • Reviewed the Business Process definition and design document as the deliverable in the Business Study phase of the O2C Modules.
  • Worked on AR Interface trouble shooting and Invoice Import Customization.
  • Designed and finalized the test strategy and reviewed the test cases.
  • Finalized the data migration strategy for converting the Customers, Customer sites, Open Sales orders, Open RMAs from R11i to R12.
  • Interacted with business team to develop and test the reporting requirement in Discoverer.
  • Close interaction with the global process owners for implementing various new features, customization and importance of up take. Prepared User, business scenarios test, TE040 testing scripts to ensure user comfort for use of the application.
  • Tracking defects and issues during UAT (User Acceptance Testing) using Quality Center /Rally.
  • Worked on Deployment and Post Production Support plan including KT Sessions, User Experience and Lessons learned.

Environment: Intel Server with Linux OS, Oracle Applications R12 (12.2.5) /R11i, (OM, Advanced Pricing, INV, PO, BOM, AOL) Oracle 9.x, 10g, Oracle, Web Server, Oracle Developer 10g (Forms and Reports) and SQL Loader

We'd love your feedback!