We provide IT Staff Augmentation Services!

Oracle Solution Architect Resume

OBJECTIVE:

A challenging and rewarding position as software professional with emphasis on Solution Architect or Senior Functional Lead.

PROFESSIONAL SUMMARY:

  • Having over 15 years of experience in Analysis, Design, Development, Enhancement and Implementation of Information Systems.
  • Extensive experience with Gap analysis, design of solutions, interfaces, data conversion, upgrade, enhancements and customizations of Oracle Supply Chain (Demantra, INV, BOM, Costing, WIP, Flow Mfg, Release Management RLM, EDI, MRP, WMS Warehouse Management, ASCP) and Oracle Order to Cash process /Financials (Order Management, Shipping, Advanced Pricing, Purchasing, General Ledger, Accounts Payable, Accounts Receivables) in Multi - org environment.
  • Worked closely with end users in gathering business requirements to determine technical, interfacing, operational/business processes and constraints.
  • Also worked on creation of program specs, business scenarios, CRP and translate into system setups, functional designs.
  • Also lead and mentored a team, involved in other activities like developments of standards, tools implementation, offshore development process, unit/integration/stress tests, Oracle SR’s / Patch analysis.

TECHNICAL SKILLS:

  • Oracle Applications (Manufacturing / Financials) R12(12.2.5), 11i (11.5.10.2), 11.03, 10.7 Order-to-Cash (OM, Shipping, Advanced Pricing, EDI, Release Mgmt RLM,ASCP), MSCA/WMS Oracle Warehouse Management, Manufacturing (INV, BOM, WIP, Costing, MRP, FLM, PO), Oracle MES (Mfg. Execution System), Demantra, Clear Orbit/BPA
  • Microsoft Share Point Server 2013, IBM Rational ClearQuest 7.1.0.1
  • TOAD (Tool for Oracle Applications Developers), SQL Navigator
  • DEVELOPER / 2.1K (Forms, Reports) SQL* PLUS, PL/SQL
  • KINTANA 4.6, Chain Link IS Integrity Software 2.0.2, Remedy Help Desk 5.0
  • PVCS 6.7.11, ClearCase Attache 3.2.1 and True Soft Version Control Software

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Solution Architect

Responsibilities:

  • Created current and future blueprint of the Specialty Steel division’s architecture
  • Assist PMO with SPS division’s transformation project planning, requirement gathering and documentation etc.
  • Planning and active participation of System Integration SIT testing, User acceptance UAT testing events
  • Worked with Corporate team for streamlining of “Customer first” digital data
  • Been part of the Change control board to review solution design, cost analysis etc.

Confidential

Oracle Solution Architect / Order to Cash and e-Commerce Gateway Lead

Responsibilities:

  • Designed and implemented entire Oracle Order to Cash processes including Available to Promise, Backward scheduling/ in-transit days calculation
  • Designed Interfaces for integration with 3rd party shipping solutions
  • Designed and implemented intra and inter-company transfers of finished goods within & across Operating units
  • Designed critical CEMLI/RICEW objects including Open Order report, delivery shortage report, shipping documents
  • Rolled out Oracle e-commerce EDI transactions like 850, 855, 856, 810, 820 (Purchase Order POI, PO Acknowledgement, Advanced Shipment Notice ASN, Invoice, Outbound remittance/payment transactions) for major US, Canada and UK food service and retail customers
  • Design, implementation and testing of custom EDI transactions (like 940, 945, 943, 944) for integration with 3rd party logistics companies (3PL) including Ryder logistics
  • Designed advanced pricing solutions including custom bracket pricing based on the order volume
  • Assisted in designing Oracle Channel Revenue Management (Trade Promotion Management) solutions including trade promotions, budgets, offers, claims & deductions, indirect sales management.

Confidential, Chicago

Oracle Order to Cash and Mfg Execution System Lead

Responsibilities:

  • Designed Oracle Manufacturing Execution System (MES) solutions and integrated with Workcenter / cell control systems
  • Designed custom solutions for Rework, deviation processes, traceability, in-process scrap tracking, and Pre-start/production/shut down quality plans.
  • Designed and rolled out custom menu, responsibilities and request groups for various levels of users across corporate and manufacturing facilities. This includes Inventory Org access feature.
  • Designed, developed and implemented entire Order to Cash process
  • Designed custom Shipping and Warehouse management solutions to conform to scan-to-verify customer standards and requirements
  • Developed custom drop ship solution including automated order creation from EDI files, receiving, invoice generation
  • Rolled out RLM/EDI transactions like 830, 862, 850, 856 (Planning, Shipping, Sales Orders, Advanced Shipment Notice ASN transactions) for major US, Canada and Mexico locations of customers

Confidential, Louisville

Oracle Reporting and MSCA Lead

Responsibilities:

  • Designed solutions for foreign trade zone (FTZ) reporting to US Dept of Homeland security
  • Designed solutions and reporting of operational areas including material variance, scrap etc
  • Implemented Mobile solutions for receiving, movement of material inside the plants/warehouse

Confidential, Minneapolis

Oracle RLM Lead

Responsibilities:

  • Actively involved in the rollout of some of the biggest customers in Auto/Industrial/Defense sector
  • Designed, trained and implemented customer specific process including Vendor Managed Inventory, Kanban processes with high volume Oracle Release Management / EDI transactions
  • Rolled out RLM/EDI transactions like 830, 862, 850, 856 (Planning, Shipping, Sales Orders, Advanced Shipment Notice ASN transactions) for major North America/South America/European customers
  • Designed various custom reporting needs to assist Customer operations team

Confidential, New York

Oracle SCM Process Lead

Responsibilities:

  • Requirement gathering, Design and standardization of Receive and store goods, and Fulfillment of order Business processes
  • Requirement gathering, Design and standardization of Inventory and materials management Business processes
  • Work with other process leads to integrate various business processes across Supply chain, Finance and projects
  • Analysis, document and sign-off of various Key design decisions
  • Complete cycle of processing user requisitions through fulfillment of sales orders
  • Converting existing legacy inventory/stores structure into Oracle Inventory structure
  • Implementation of Consignment inventory
  • Review various functional designs being developed by the team for Supply chain RICEW objects

Confidential, Michigan

Oracle Principal Consultant

Responsibilities:

  • Setup and implemented Standard Confidential EDI/Release Management Shipping/Planning Schedules across multiple Operating Units/Organizations and Countries
  • Currently implementing OM/Shipping solutions for Germany subsidiaries of Confidential
  • Implemented Warehouse Management solutions including customized Picking, Consolidation and Shipping processes
  • Implemented Internal Order fulfillment between US and Germany through IR/ISO process
  • Design and implementation of various Inventory processes including ABC Classes, Cycle Counting
  • Time sensitive customer demand processing through Release Management
  • Worked along with their EDI provider to map European specific trading partner communications
  • Full scale warehouse management system with customer specific labels using VDA standards
  • Unique Picking process with VDA conforming sequential LPN generation
  • Automated packing into Containers / Skid items
  • Export and Import interface for statutory compliance (customs)
  • Multi-language features and capabilities
  • Operating in multiple time zones
  • Actively involved in Project planning, issue resolution, ROI analysis and approval of projects with PMO/Steering committee

Confidential, IL

Senior Functional Lead / Architect

Responsibilities:

  • Implemented Demantra 7.1 Demand Management solution with Sales Channel
  • Support of Advanced Supply Chain Planning applications
  • Setup, support and user training of Costing for various countries
  • Setup and implemented Standard Costs with BOM and Outside Processing across multiple organizations
  • Currently implementing OM/Shipping solutions and Mexico business development
  • Implemented both Standard and Non-standard WIP Discrete job
  • Designed and implemented WIP Jobs that have Outside Processing (OSP). This process is automated to create WIP Job as well as Import/auto create Purchase Order for OSP vendor
  • Implemented work-order less completions/returns of Kits that are built based on the demand
  • Design and implementation of various Inventory processes including ABC Classes, Cycle Counting
  • Design and implementation of inventory interfaces between Oracle and Legacy System
  • Familiar with Oracle Support Request (SR/TAR) and resolved many issues/bugs with Patches, data fixes related to License Plate Numbers (LPN) etc.
  • Designed management level reports like Gross Margin report, Inventory Turns report, Sales by Channel report etc
  • Actively involved in discussion, ROI analysis and approval of projects with PMO/Steering committee
  • Represent IS at weekly discussions with Supply Chain, Finance business groups

Confidential, Chicago, IL

Functional Lead

Responsibilities:

  • Also involved in the Pilot plant rollouts and subsequent plant rollout teams.
  • Been part of PMO (Project Management Office) group and designed Enterprise-wide Roles and Responsibilities.
  • Actively involved with design structure conforming to Sox and Internal Audit compliance.
  • Also actively involved in various other processes like Conference Room Pilot CRP, Integrated Test Cases, Stand-alone Test Cases, process walkthrough to super users and end users, user training, postproduction support etc.

Hire Now