We provide IT Staff Augmentation Services!

Oracle Planning Lead Analyst Resume

Pittsburg, PA

SUMMARY:

  • An Oracle Planning and SCM Techno Functional Lead Analyst with specialization in Planning, Supply Chain and Distribution Systems having around 10+ years of industry experience which revolves around Oracle ERP and CRM Applications - Implementation, Support and Upgrade and has also worked on successful Oracle Cloud Fusion R13/R12 Implementations and Oracle EBS On-Premise R12/11i Implementations, Upgrades and Production Support Projects.
  • Extensive experience with Discrete and Process Manufacturing process flows.
  • Conversant with Oracle Supply Chain modules and Distribution Modules - Quoting, WMS, Advance Pricing, OM, Global Order Promising (GOP), INV, Oracle Transportation Management (OTM), Procurement Contracts, Purchasing modules
  • Extensive experience in Planning modules of Advance Supply Chain Planning (ASCP), Collaborative Planning, Production Scheduling, Mobile Supply Chain Planning (MSCA) and Advanced Planning Command Center (APCC)
  • Understands both the “Quote to Cash” process as well as the “Procure to Pay” process. Conversant with Configuring Oracle Application modules as well as understands the underlying schema, which gives her a better insight into converting user requirements into functional and technical specifications.
  • Experience with e-Commerce Gateway and EDI Transaction 850, 855, 856, 810, 843, 820 formats

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburg, PA

Oracle Planning Lead Analyst

Responsibilities:

  • Lead the implementation of Oracle Production Scheduling (PS), Oracle Collaborative Planning (CP) applications.
  • Configure all the setups involved for Oracle Production Scheduling (PS), Oracle Collaborative Planning (CP) applications.
  • Drive business requirements gathering and map the requirements to the functionalities in Oracle which would require expertise in Oracle Production Scheduling, Oracle Collaborative Planning and thorough understanding of configurations and integrations with other modules mainly Oracle Process Manufacturing and Oracle Advanced Supply Chain Planning.
  • Configure dependent setups required for Production Scheduling and Collaborative Planning in other modules like Inventory, Oracle Process Manufacturing, Order Management, Purchasing.
  • Collaborate effectively with cross-functional partners include developers, analysts, architects, infrastructure administration, operations, and business partners to drive business value through intelligent design and use of different technologies.
  • Create automation SQL tests for unit, integration, regression, performance, and build verification.
  • Worked on Oracle ASCP to setup Constrained plan options, setup for multi node instance, configured the planning flex fields, worked on the ODS Load process, defined the plans and plan options, worked on the ASCP Collection process.
  • Worked on the configurations of the Advanced Planning Command Center (APCC) module - worked on scenario planning, defined scenario sets, defining activities, configuring planning parameters, service enablement, worked on the dimension model, Inventory analysis, sourcing efficiency, demand satisfaction, etc.
  • Understand and apply the advance principles of entity-relationship model design, good data typing practices, index management, data management, and data security.
  • Working with Network Protocols like File Transfer Protocol (FTP) used for the transfer of computer files between Linux server on a computer network and Isilon and other servers.
  • Identify functional gaps and provide alternative solutions to the functionalities that cannot be mapped to the existing features within the standard system.
  • Develop functional specification document for the custom objects and lead the development and delivery of the custom objects.
  • Use specialized skills in SQL to write queries, stored procedures, functions, triggers, views, cursors and materialized view of processing data against SQL server database.
  • Modify Production Scheduling XML plan files to accommodate for the gaps. Design new Java form layouts for custom development that are non-existent in Oracle.
  • Design complex Workflows using the Oracle Workflow Administrator for Oracle CP.
  • Analyze defects/incidents, perform Root Cause Analysis and deliver defect fixes and enhancements.
  • Improve the product feature set by collaborating with Oracle Product Development team and address/eliminate identified gaps in standard functionality of Oracle PS and CP.
  • Production configuration and hyper-care during and after production rollout.
  • Prepared Daily execution plan, daily status report and communicate across the flows and conduct status meetings.
  • Perform End to End system testing manually and work with developers, system engineers to nail down the technical problems.
  • Handled the tasks of testing full application visibility to speed performance of the application.
  • Working Closely with Developers and DBA regarding application defect causes and getting up for the solutions.
  • Build SQL queries to retrieve information and create reports.
  • Build queries to diagnose errors and rectify them.

Confidential

Oracle Planning Techno Functional Lead

Responsibilities:

  • As an Advance Planning and Supply Chain Techno Functional Analyst Supported the modules: Order Management (OM), Shipping (WSH), Purchasing (PO), Advanced Planning Command Center (APCC), Advance Supply Chain Planning (ASCP), Inventory (INV), Costing, Bills of Material (BOM) Release 12.1.3
  • Worked on setting up of Shipping Module defining shipping parameters, pick slip grouping rules, release rules and sequences, document sets for shipping, etc.
  • Worked on the setups of OM module - setting up processing constraints, defaulting rules, Back to Back Order process, Drop Ship process, IRISO, RMA process.
  • Worked on the AR setups of System Options, Auto Invoice, Lock Box, Revenue Recognition, etc.
  • Worked on the ASCP Setups - setting up the planning flex fields, defining the plan options, setting up constraints for the plan, worked on defining the demand and supply sources, worked on tweaking the plan attributes for tuning the plan, etc.
  • Worked on Oracle APCC module - setting up the plan parameters, scenario-based planning, configuring the supply chain analyst dashboard, sales and operations planning, worked on the SSP dashboard, worked on the operation data store, setup activities, service enablement planning, etc.
  • Preparing BR100, MD050, TE40, TE50, CRP execution, User and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
  • Configured Advance Supply Chain Planning (ASCP), Collaborative Planning, Production Scheduling, Advance Planning Command Center (APCC) modules from scratch and simultaneously created BR100 documentation for the setups.
  • Worked on setting up the BOM - defined models, options, option classes and rules in BOM.
  • Worked on the EDI 810, 823, 856 Inbound and Outbound interfaces - defined the data mapping and worked on the integration process.
  • Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
  • Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
  • Provided with useful to the users to OM, Shipping, INV, PO, ASCP, APCC, Bill of Materials, Costing modules

Confidential, Boston, MA

Planning and SCM Techno Functional Analyst

Responsibilities:

  • Worked on the entire Quote to Cash process including the modules of Quoting, OM, i-Expense, WMS, ASCP, Collaborative Planning
  • Worked on the Quoting, OM, i-Expense, WMS, ASCP, Collaborative Planning process in order to streamline the business process and improve performance and efficiency.
  • Analyze business processes, work with users to determine/clarify requirements, and prepare Functional Specifications to address technology solutions for meeting business requirements. Work with the users to review, in corporate feedback and obtain approvals for the Functional Specification.
  • Worked on the ASCP Setups - setting up the planning flex fields, defining the plan options, setting up constraints for the plan, worked on defining the demand and supply sources, worked on tweaking the plan attributes for tuning the plan, etc.
  • Develop Use Cases and System Flow diagrams detailing the system impacts.
  • Review and provide input to Detailed Design documents and Test Plans.
  • Comply with the specified Delivery Methodology and documentation requirements
  • Interacted with the database administrator, developers, system administrator and end users to interpret business requirements and develop concise solutions.
  • Performed requirements analysis, participating in end-user meetings and review sessions to gather functional design specifications.
  • Analysis done for selecting software/ data mgt solutions
  • Conducted Business Process Improvement - As-Is / To-Be Business Process Analysis & Modeling, Problems, Impacts, Solutions and Benefits Identification, Gap Analysis, Best Practice Research.

Confidential, Chicago, IL

SCM Business Analyst

Responsibilities:

  • Worked on the entire Supply Chain Process Flow- OM, BOM, WIP, INV, PO, AP, i-Procurement and i-Supplier modules
  • As a Functional Consultant implemented the Business flows including Warehouse Management (WMS), INV, PO, i-Procurement, i-Supplier modules.
  • Worked in the configuration of the Advance Pricing modules.
  • Performed Requirement and Gap analysis.
  • Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Manufacturing modules.
  • Preparing BR100, MD050, TE40, TE50, CRP execution, User and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
  • Worked on setting up the Modifiers, Qualifiers and Formulas in Advance Pricing Module.
  • Pre upgrade testing and Post upgrade production live support.
  • Support Production issues on a day to day basis including month end closure p1 issues
  • Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
  • Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.

Confidential

SCM Business Analyst

Responsibilities:

  • Worked on the entire SCM Functional Flows OM, INV, PO, BOM and WIP
  • As a SCM Functional Consultant implemented the following modules: PO, Warehouse Management (WMS), i-Procurement, AP, INV and GL
  • Worked on the Functional mapping of data Conversions & Enhancements for PO, i-Procurement, AP, INV and GL modules
  • Preparing BR100, MD050, TE40, TE50, CRP execution, User and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
  • Setup the Approval Hierarchies in Oracle Purchasing module.
  • Involved in troubleshooting issues on Auto Invoice Import Program.
  • Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
  • Completed Multi-Org configuration by creating a new Organization Structure for ACG by creating new Business Group, Legal Entity, Set of Books and Operating Unit.
  • Conducted Regression testing to examine the effects of a new Org on the previous Org.
  • Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
  • Provided with useful to the users in OM, Shipping, Advance Pricing, BOM and WIP Modules.

Confidential

SCM Business Analyst

Responsibilities:

  • SPOC for the Business in resolving their day-to-day issues in OM, PO, INV.
  • Providing functional Support assistance to OM and AR Internal Customers.
  • Actively handling Order Management & Shipping Production issues in areas like stuck SO lines, RMAs, Pick Release, Pick slip & Shipping documents, Adjustments & maintaining setups.
  • Worked on Inventory setup changes, real time defect resolution in areas like Inventory Move Order, pending Inventory transactions, material on hand & transaction quantity mismatch, Item control, Sub inventory Transfer & Month end closure.
  • Advanced Pricing setups, designing Pricing Formulas, Price rounding, Modifiers, Pricing Events, Partial Pricing, Qualifiers, DFFs to track Price changes, assessment for tiered Pricing for expedited orders & maintaining Intercompany Transfer Pricing.
  • Ensured appropriate seeded workflows in OM are used in the transactions. Resolved issues in application setup and configuration with the Financial Consultant to ensure proper interfacing of AR with OM and AP with Purchasing, and Inventory with GL.
  • Extensively worked on Receivables and configured setups for organization structure, Auto invoice, auto accounting, Receivables Activities, distribution sets, Application of Receipts to transactions and invoice printing with remit address
  • Creating Service Requests & coordinating with Oracle Metalink Support for issue resolution, bug tracking, requesting back ported patches, testing patches towards defect fixes in OM, Shipping, Inventory, Pricing & Purchasing areas.
  • Update the BRD’s manuals/cheat sheets on a regular basis for all the business processes.

Hire Now