SUMMARY:

• More than ten of experience in implementing, testing and supporting Oracle ERP system; Extensive understanding of Oracle Manufacturing (WIP, BOM, OPM, QA), Supply Chain Execution (OM, PO, SE), Oracle Planning (ASCP, MRP, Demantra) and Oracle Financials (Receivables, Payables, and GL)
• Oracle ERP Supply Chain System Analyst with extensive experience that utilizes analytical and technical skills in supporting Oracle order to cash (OTC) and procure to pay (PTP)
• Work involvement consists of application implementation, client interaction, requirement gathering and analysis, resource management, Software Specifications, Technical and Functional Level Design, Testing and Documentation.
• Good understanding of Oracle EBS database/table structures and SQL/PLSQL

SPECIALTIES:

ERP system implementation, integration and testing, data extraction and Reporting via SQL/Oracle BI

WORK EXPERIENCE:

Confidential

Oracle ERP Business & System Analyst

Responsibilities:

• Gathered and analyzed business requirement to map Oracle solution
• Closely worked with business users and developers for design and development of technical solution
• Tested technical solution and then presented to business users
• Gathered client needs and analyze application requirement to plan, design and execute test cases for unit testing, integration testing, system testing and user acceptance testing
• Organized and documented the entire application process, managed bug reporting and requirement traceability matrix
• Responsible for change management, including continuous improvement
• Documented Oracle business flows, requirements and mapping documents, custom technical solution, and test scenarios
• Supported OTC (Order to Cash) and PTP (Procure to pay) cycles (Order Management, Shipping, Purchasing, Receivable, Payable, and GL, etc)
• Performed tasks related to Requirements Analysis, Design, Data Mapping, Data Conversions, Testing and Test Script creation, Configuration, and Deployment, etc.
• Troubleshoot various issues in Receivable and OTC (Order to Cash) cycle, which includes order entry, order booking, pick release, ship confirm, invoice import, lockbox import, and posting to GL
• Troubleshoot various issues in Payables and P2P (Procure to Pay) Cycle, which includes requisition creation, PO creation, receipt of material, supplier invoice creation and interfacing, payment, and posting to GL, etc.
• Provided support to multiple data interfaces like trip stop (ITS), invoice import interfaces, and GL interfaces, etc.
• Create & run ad - hoc queries to pinpoint application issue or help business reconcile accounts
• Use Oracle BI or write SQL to generate report
• Supported Oracle Process Manufacturing (OPM)
• Worked with internal business owners throughout the supply chain to resolve business system issues and provide recommendations. The ongoing support covers the areas like OPM Formulas, Routings, and Recipes, Batch Process Execution, and inventory management, etc.
• Collaborated with technical team, document MD-50 technical requirements, and test custom solutions
• Worked closely with users to conduct UAT and training sessions
• Supported multiple Demantra modules like Demand Management, Predictive Trade Planning (PTP) and
• Set up Demantra analystical engine to generate both baseline forecast and uplift forecast (PE module and DM module)
• Wrote script to collect sales history from in-house system into Demantra
• Build integration profiles and workflows to upload forecast overrides and budget into Demantra
• Create rolling profiles to archive forecast
• Create series, worksheets and reports based on business requirement

Confidential

Oracle ERP System Consultant

Responsibilities:

• Gathered and analyze business requirement to map Oracle solutions
• Created test case based on the understanding of business process and Oracle modules to facilitate the implementation of EBS solutions.
• Provided support to OTC (Order to Cash) cycle - responsible for data process, data analysis, data clean-up, and validation in various areas like order entry, order booking, pick release order, ship order, interface trip stop, receivable invoice and GL posting, etc.
• Provided Support to P2P (Procure to Pay) cycle -worked closely with accounts payable, accounting and procurement staff to resolve and document system changes and issues in different areas of procure-to-pay process like requisition creation, PO creation, receipt of material, AP invoice creation, payment and GL transfer, etc.
• Managed and supported ERP Customizations and Integration with other applications in the areas of Forecasting (Demantra), Planning (ASCP and Min-Max Planning, etc), Inventory, WMS, Order Management, and procurement
• Actively participated in multiple item/transaction conversion projects that converted the data and transactions from legacy system into Oracle both in Demantra and Inventory
• Develop and perform detailed unit and integration testing
• Gather business requirements and translate those into functional requirements.
• Deliver specific implementation/support expertise required on Inventory, Forecasting, Planning, Order Management and Purchasing
• Responsible for data load, data process, data analysis, data clean-up, deployment, conversion and validation

Confidential

Senior Oracle ERP System/Business Analyst

Responsibilities:

• Worked with business, and cross-functional IT Teams to support company's supply chain processes (specifically order management, purchasing, and planning)
• Assess, and analyze business requirements, and write functional documentation about custom interface for invoice and receipt import
• Define and execute test cases, analyze and review software components, integrations, and interfaces across modules proactively looking for potential quality issues.
• Performed analysis to identify different planning strategies (e.g. Kanban Planning, part of JIT flow manufacturing process techniques, MRP Planning and Min-Max Planning) based on demand pattern and item cost
• Performed analysis to decide optimal minimum and maximum order quantities for min-max planned items
• Simulated Kanban Planning in Oracle to calculate Kanban card number or size
• Performed analysis on inventory safety stock levels and turns
• Work closely with CSR, production and sales account manager to decide MDS and MPS to drive MRP Planning
• Configured MRP and ASCP in Oracle.
• Run planning simulation and analyze various planning scenarios: demand and supply, pegging, and exceptions, etc
• Worked closely with production team to enhance manufacturing scheduling by calculating cumulative manufacturing lead time and defining jobs and production schedules in Oracle
• Developed KPI for supplier performance and service level
• Created customized reports via SQL extraction and Oracle reporting tools to suit different business needs
• Developed and provided ongoing training for end users

Confidential

Business System Analyst for Oracle ERP Supply Chain

Responsibilities:

• Conducted Demantra implementation visioning and planning analysis
• Determined project objectives, scope and approach, and verify the feasibility of the project
• Developed conceptual demand planning and sales and operation processes design that bring together all the plans for the business (sales, marketing, demand, supply, inventory, financial) into one integrated set of plans.
• Documented business requirements and system architecture requirements.
• Defined gaps in Oracle application, and create design for customization and module configuration
• Participated in conducting workshop to gather users’ inputs and update project progress

Confidential

Supply Chain Planning Consultant

Responsibilities:

• Work closely within Supply Operations teams to provide information for demand and planning information
• Use SQL to extract data from Oracle ERP database to analyze data, and insure demand and planning accuracy
• Provide analytical support and project management for supply chain projects
• Write test script and conduct functional testing