Oracle Ebs Systems Analyst Resume
SUMMARY
- Progressive work experience in Oracle EBS and Manufacturing / Supply Chain domain which includes 10 years working as Oracle EBS Consultant in Oracle EBS MFG/SCM/Planning area modules, and 11 years of work experience in manufacturing industries in Production, Quality, and Supply Chain / Materials Planning functions.
- Has worked on various delivery modes such as Oracle EBS Implementations (R12.1.3, & 11.5.10.2), R12 Version Upgrades (R12.2.4 and R12.1.3), and has extensive experience in leading Oracle EBS Support project
- Has directly / indirectly lead solution delivery in Oracle MFG / SCM / Planning / Order Management, Pricing, Purchasing, EDI, & Trade Management areas. Has cross - functional experience in collaborating with various teams / players while working on development, Implementations, & upgrade projects
- Has expertise as Senior Application Specialist to resolve critical issues in Production Environment, performed Lead roles on Oracle R12 upgrades Projects (R12.1.3,& R12.2.4) on modules such as Order Management (OM), e-Commerce (EDI), Supply Chain Planning (ASCP, MRP, DRP), & Manufacturing track modules such as INV, BOM, WIP, ENG, and CST; has performed Pre-upgrade, Post-upgrade validations, has lead Upgrade Planning and Coordination.
- Has experience of working under Global Solution Delivery Matrix with multi-shore support model projects; has lead team of Functional & Technical consultants with clients & teams based across different geographic locations such as USA, China, Europe, & Mexico, visited Mexico at client site during current project
- Has excellent communication skills, in initiating and leading technical, functional and business discussions across all partners, at various levels spanning from Shop Floor / Warehouse users, IT Consultants, Managers, Leaders / Directors, Finance Controllers, & Material and Operations Leaders at client site.
- Has proficiency in understanding existing /‘As-Is’ business processes, in gathering business requirements, Mapping with Standard Oracle EBS functionalities, performing Gap Analysis, preparing Documents (BR30, BR100), Functional Design (FDD) & Solution Design (SDD), working on designing Customization, preparing Module Design (MD50, MD70) documents, Test Cases, & User Manuals.
- Has expertise in generating Functional Specifications, performing System Setups/Configurations, preparing project plan as per SDLC, creating Project Tasks, performing Unit and Integration Testing, demonstrating PoC (Proof of Concepts), executing Conference Room Pilots (CRPs), & User Acceptance Testing (UATs), Go-Live and Post Go-Live support activities
- Along with functional expertise in product modules, I has sufficient Technical Expertise to work on Oracle SQL Developer, Toad to write Sql queries, Reading Pl/Sql codes, Oracle Workflow, underlying Apps Tables, Oracle Apps Schemas/Architecture, has worked on development activities of custom objects such as Forms, Reports, worked on Data Conversion, Application Hoisting, working with My Oracle Support (MOS) on various Service Requests (SR)
- Has prior 10+ (from 1993 till 2004) years of domain work experience in Manufacturing Operations, Planning, & Quality Control departments while working in India; has performed roles like Assistant Works Manager, Shift In-Charge, Senior Production Engineer, Senior Quality Assurance Engineer; has handled Shop Floor Operations Management, Production and Materials Planning & Scheduling, also worked on New Product Development, involved in Systems and Standards implementation (like ISO, TS, 6 Sigma, 5S, Lean initiatives, etc); performed Confidential as Production Manager, Shift In-charge, Senior Quality Engineer, process lead during ERP implementations.
- Has well conversant with Demand/Supply Management, has solid noledge of end to end business flows, Material Planning, Production/Operations Management including managing Inventory, Customer Demand, and Supply/Sourcing Management, and Order Fulfilment in Manufacturing Industries.
TECHNICAL SKILLS
Functional Area: Modules / Packages / Versions
Oracle EBS Versions: Oracle R 12.2.4, R12.1.3, R11i (11.5.10.2, 11.5.9), R10.7
Oracle EBS Modules: Manufacturing - INV, BOM, ENG, WIP, OSFM, CST, QLT, & WMS, MSCA Supply Chain Management - OM, QP, RLM, WSH, EDI, PO, SS Value Chain Planning - ASCP, SCP, DRP, MRP Along with SCM, MFG modules, I has working noledge of Oracle Financials modules (AR, GL, AP, SLA, Channel Revenue Management/Trade Management)
Application Methodology: Oracle AIM, ITPM, ITSPM, PMI methodologies
Softwares / Packages: Oracle Technology Packages, Windows, Microsoft Office Software Products
Oracle Tools: Has working noledge of writing Pl/SQL, writing small queries, reading Code, Packages, Has good understanding Toad / SQL Developer, Data loader, App Worx Jobs SchedulerOracle EBS Supply Chain Management- Projects Summary Since
PROFESSIONAL EXPERIENCE
Confidential
Oracle EBS Systems Analyst
Responsibilities:
- Has worked as Oracle Supply Chain Functional Lead with Google BizAps Engineering Team for developing, testing various standard & custom solutions within Oracle Supply Chain Planning & Logistics department. Creating systematic solutions mainly within Order Management (OM), Purchasing (PO), Inventory (INV), Advanced Pricing (QP), & Accounts Receivables (AR) modules.
- Performed Confidential as integrator for development & testing of various User Interfaces & Portals such as Backlog Management, Supply Chain Portal for functional needs of handling Firm and Planned Orders (ASCP Planning), Backlog & Forecast data, & Shipments, has worked with Java, B2B and SOA developers
- Reviewed and participated in time to time discussion on existing and proposed business flows, has document scenarios, has performed wat-if, fit-gap analysis, prepared solution designs
- Analysed, involved in design phase, Test phase, and Implementation/Roll-out of various objects
- Created systematic solutions for using Oracle EBS Oracle Supply Chain and Distribution Modules
- Configured / performed functional setups in Order Management, Inventory, E-Commerce Gateway modules, coordinated integration and User Acceptance Testing
- Performed functional setups in OM, AR, INV and PO modules for various businesses and operating units within Google, for Drop Ship with 3PLs, and Standard Shipments out of Google warehouses
- Involved in Regression, Unit, Integration, and User Acceptance testing, developing Training Materials for business and System Users, develop Training Materials for business and System Users
Confidential
Oracle EBS SCM / MFG Consultant
Responsibilities:
- Has mostly lead Plan-To-Make business area for R12.1.3 upgrade efforts, has reviewed / studied existing Oracle 11i SCM & MFG flows, coordinated post upgrade flow testing for Oracle EBS modules such as BOM, WIP, MRP/DRP, SCP/ ASCP modules
- Has tested extended Oracle flows ‘From/To’ Supply Chain Planning (MRP/DRP/SCP, and ASCP) to Manufacturing, Order Management, and Purchasing/Sourcing modules of Oracle EBS R12.1.3
- Has setup Planning module, Plans (MRP/DRP/SCP), Options and also ASCP Plans in test environments for R12.1.3 Upgrade project, has launched Plans, Collections, reviewed Planners workbench, resolved various Oracle EBS Planning issues, has worked with Oracle Support teams on various Service Requests
- Has participated in daily reviews, meetings with Project / Program Management office and IT Directors for Upgrade Project Progress and regulated directions
- Has closely worked with PMO office, Module Owners, and DBA/Hoisting Teams for deciding Instance Strategy and Readiness on Cloning / Copying, and Creating various instances including Tests, Development, CRPs, UATs, and Production Instances in a progressive manner
- Has closely worked with DBAs testing of various patches, provided input to Oracle Support in response to various TARs (Service Requests), has worked with Oracle Support on Service Requests (SRs) raised during R12.1.3 upgrade activities, includes Solution/Patch Testing.
- Has prepared documentation as Oracle’s AIM Methodology, taken business Sign-Offs on various test results and has provided approvals for further progression of upgrade activities
- Has worked on Demand Solutions, and Port2Port Enhancement Projects with Gates IT / Technical developers to develop Interface between Oracle and Legacy WMS and MES Systems
- Has worked on INV/PO area setup to configure Internal Sourcing based on Categories for passing Planned Order Demands from MRP/DRP to suppliers and internal Orgs based on Item Sourcing
- Has worked on OM (Order Management), PO (Purchasing), and INV (Inventory) to setup IR-ISO Flow to source/supply semi-finish good components across Gates Plants /Distribution Centres.
- Has setup Inter-Location Transit time between various Inventory Locations within and across Operating Units to configure IR-ISO Flow with Transit Day, to Offset Sales Order Schedule Ship Date over PO Request Dates, has tested various scenarios and conducted UAT with IT/ User community
- Has monitored EDI/Manual Forecasts, MRP/DRP Plans & Workbenches, has modified DRP/MRPs & Item Attributes setups to resolve issues & eliminate bubbles to streamline Supply Chain.
- Has visited Gates Corporations Manufacturing Plants and Distribution Centers during system deployment to Production Environment to assist during Go-Live, Issue resolution, and subsequent system/process modifications
Confidential
Oracle OM Functional Lead Consultant
Responsibilities:
- Performed Order Management Functional Lead Confidential of Oracle R12.1.3 Implementation project, has lead for Order Management, Advanced Pricing, Release Management, and e-Commerce Gateway Modules.
- Has worked with clients CSR & Shipping Teams to understand Sales Order Management Systems (SOMS) and prepared new flows covering their Inbound Orders, Pricing and Shipping processes, has created ‘As-Is’ and To-Be lows, conducted requirement gathering sessions, document (RD020) and had sign-off from client.
- Has demonstrated EDI-RLM-OM-WSH-AR transactional flows in Oracle R12 to business teams as part of PoC, got sign-off on various processes from Business and IT Leads
- Has done BR Mapping, performed Fit-Gap analysis, and prepared mapping documents, created BR documents (BR30) for OM, QP, RLM, & EDI modules, also generated Functional specs.
- Has lead teh discussions with Confidential ’s & Translator Partner during implementation of EDI Transactions; has lead activity of configuring Oracle e-Commerce Gateway, application setups, seed data reconciliation, Code Conversions, Trading Partners setups for Transaction Flows / Maps testing for 810, 850, 855, 860 856 etc.
- Has lead Oracle Release Management (RLM) Implementation activities, completed RLM Configuration, RLM Processing Rules setup at various levels such Customer, Address, and Item level for various EDI Transaction and EDI Maps, RLM Workbench Exception setups, has tested transaction like 830, 862 has coordinated with DBAs / Oracle Support for various patches, lead CRPs and coordinated UAT sessions.
- Has lead Order Management Implementation activities, lead business process owners team during system setup, configurations, & testing activities. Performed Oracle Order Management setups, including Order & Line Types, Documents & Sequences, Order Import Sources, Order Holds & Credit Checks, OM System Parameters, Defaulting Rules, & Processing Constraints.
- Performed / coordinated Oracle Receivables setups such as TCA Architectures setups for Customers, Sites, AR Transaction Types, Payment Terms, Payments Methods, Grouping Rules, etc; has performed EDI Trading Partners & association with Ship-To sites
- Has setup Price Lists, Pricing Agreements, Qualifiers and Modifiers, Pricing Transaction Entities
- Has setup System Profile Options for OM, QP, RLM, WSH, and e-Commerce Gateway modules
- Has setup Shipping Parameters, Defaults, Inter-Location Transit Time Defaults, Shipping Calendars, Picking, Release Sequence, & Pick Slip Grouping Rules, Ship Methods & Freight Carriers,
- Has prepared BR100 / Functional Setup documents for OM, RLM, QP, and EDI modules
- Has lead daily project progress meeting within OM Team including Business/IT users and Vendors
- Has participated in project review meeting with Project Leads / Program Managers, and IT Director, has updated progress of teh implementation activities, and sought help from them on various logistic issues, including escalating SRs with My Oracle Support
- Has executed multiple Conference Rooms Pilot CRPs), System Integration Testing, conducted UATs with Confidential ’s users from various plants, imparted training to Lead Users.
- Performed Go-Live activities successfully with minimal issues, provided Post Go-Live support
Confidential
Sr. Functional Consultant - Oracle MFG & SCM
Responsibilities:
- Has performed Senior Application Specialist Confidential to provide expert level Production Support for Oracle EBS Manufacturing, SCM, and Order Management business area modules, has coordinated with My Oracle Support on various SRs
- Prepared Solution Design Documents, Functional Designs, and Test cases for various functional and technical changes, has lead Development, Testing, and Change Management process
- Has co-ordinated support issues with other teams like DBA, UNIX, Windows, E-Commerce, Purchasing, Mainframe, Application Hoisting, and Core Finance.
- Conducted onsite solution reviews, UAT, and sign-offs for new RICEW Components development, solution delivery, and production cutover. Lead IT Team coordination for enhancement requests, system downtime & maintenance, also lead year end activities and Annual Physical Inventories.
- Has effectively communicated project expectations to off-shore teams and other stakeholders
- Maintained Project Tracker & Milestones, developed best practices for Global Support project
Confidential
Functional Project Lead - MFG & SCM
Responsibilities:
- Prepared plan for Knowledge Transitions of Oracle Application Support activity from Outgoing GPVs (Global Preferred Vendors) like Infosys, TCS for taking transition of support activity for Cummins FSBU, monitored transition, shadowing of support, coordinated playback sessions, ensured smooth transition and cutover to set steady state operations
- Successfully lead global team formation activity, participated in team selection, interviewing and selecting consultants.
- Has lead team of 6 - 7 consultants, provided business overview, set project expectations, developed effective communication channels across team members and client (users) based across different geographies like USA, China, Mexico, and India.
- Track teh progress of Oracle Application development issues under change management process, conducted weekly review meetings to evaluate Progress of teh Project and set further directions, coordinated for seamless support
- Managed deliverables within agreed SLAs and as per SOW, reported to client’s IT Managers
- Conducted time to time interviews and training to new team members across support teams
- Has established best practices for Incident, Problem, and Change Management issues, worked with Senior Management to has started RCA (Root Cause Analysis), build Solution Database, and Knowledge Management Drives for 24/7 Multi Shore Global Support project
- Performed Confidential of Senior Application Specialist for expert level support to various critical Production issues; mainly in OM, Pricing, Release Management, Shipping, WIP, INV, & Costing areas.
- Has participated in various 6-Sigma Projects with Client’s IT Leader/Business Teams for Process, System Performance improvement activities, lead Annual Physical Inventory/Cycle Counting events
- Has Lead Year End activities for smooth transition to new year, including New CUMs, New Orders, Price Lists, Cost setups; assisted Finance Controllers during Period/Year end closure on resolution of various Inventory, WIP, Costing, Sub-Ledger (mainly AR), and General Ledger (GL) Transactions.
Confidential
Oracle EBS Functional Consultant - MFG, SCM
Responsibilities:
- Has worked with Oracle Implementation Team (Implementation Partner KPIT and client Cummins Inc.) teams for Cummins Fuel Systems Business Unit (XPI, FSP, and CSV) Oracle 11.5.10.2 Implementation
- Has analysed FSP, CSV, and XPI business processes, inbound flows, Order Management, Purchasing, Material Planning (MRP), Shipping/Receiving, and manufacturing (WIP, BOM) activities
- Has manly worked on Order Management & Purchasing modules, has worked on Functional Design for Shipping/Receiving processes, has worked on Custom Forms & Report Development, worked with technical team during solution development, has performed testing unit, integration testing, worked with team for regression testing, object migration, has performed Go-Live support.
- Has discussion to understand Multi-Org set ups, Part Code logic, Inbound, Outbound Flows.
- Primarily worked and resolved issues on Oracle Purchasing, Supplier Scheduling, EDI modules,
- Resolved issues related to Order Management, Release Management, Shipping, Pricing, OSP setup, Purchasing, Blanket Purchase Agreements, Discrete Jobs, BOM & Routings, WIP Transactions
Confidential
Oracle EBS Functional Consultant - MFG
Responsibilities:
- Worked on Product Data Management interface development project for Cummins GPO, primarily intended to interface Item and Structure information from legacy IMS System to Oracle 11.5.10.2 and run comparison between systems to ensure integrity
- Worked with Client's TEMPPrincipal Consultant in creating functional test cases, and executing those test cases
- Has tested end-to-end flow of Item mapping and import (INCOIN) flow, as well as mapping Product Structures to Bills of Materials (BOMCOIN), mapping Operations, Resources, Departments, Routings, and Op Sequences from Legacy (IMS) to Oracle 11i tables
- Worked with client’s Functional team for requirement gathering and documentation, worked with technical team for conversion and interface, forms and reports development and testing, and run comparison between systems to ensure integrity