SUMMARY

• History of orchestrating successful business process improvements using data analytics and Oracle EBS configuration.
• Strong background in Supply Chain Planning, Information Technology, Oracle E - Business Suite, SQL, Excel, Excel VBA, Business Analysis and Business Intelligence.

CORE COMPETENCIES

• Data and statistical analysis
• Report generation
• Data visualization
• Microsoft Excel and Excel VBA proficiency
• SQL Queries
• Interpersonal communication
• Oracle Cloud Applications

TECHNICAL SKILLS

Office Suite: Microsoft Office Products, Visio, Skype, Excel, Excel VBA

Technologies: Oracle EBS 11i, Oracle R12, Oracle Cloud Applications, SQL, eTRM, Cisco

Oracle Modules: AR, AP, GL, INV, OM, ASCP, APCC, BOM, WIP, PO, Demand Planning, SysAdmin

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

Principal Consultant

Responsibilities:

• Achieved sourcing and shipping alignment across hundreds of locations by analyzing qualification parameters and modeling routes using SQL queries, Excel, VBA, Oracle VCP and the Google Maps API.
• Created integrated visualization of customer map, manufacturing sites, and distribution sites and used this data to update sourcing rules, assignment sets, and configure an optimized shipping network in ASCP.
• Pulled data from multiple systems (SAP, JDE, Oracle VCP) using SQL; cleansed, integrated and optimized data from multiple companies/acquisitions with Excel; loaded completed data sets into production system.
• Configured and analyzed 30+ ASCP test plans, and reviewed results with stakeholders to create a global plan that reduced exception noise by 70%, fulfilled demand much closer to the shipment date, and potentially reduces inventory by 10%-15%.
• Reviewed all VCP profile options, maintained logs of all profile option changes during each ASCP test cycle, and created reporting showing the effects of each option change for stakeholder review.
• Researched, motivated, and helped develop internal corporate strategy to launch Oracle Cloud implementations practice; created internal training strategy/documentation for Oracle Cloud Specializations.

Confidential, Seattle, WA

ERP Manager

Responsibilities:

• Managed Oracle ASCP global plan implementation project; facilitated UAT and training. This plan reduced international shipping costs between Europe and North America by 30%.
• Achieved 25% higher on-time delivery by tweaking Order Management configurations, and implementing business intelligence solution for shipping stations.
• Created tools to evaluate forecast accuracy and ASCP plan adherence. Used these tools to further refine forecasts to provide more accurate inputs to ASCP planning.
• Configured Oracle EBS profile options to enhance auto-create usage in Purchasing.
• Planned upgrade from 11i to 12.2.4 as part of the 12.2 early adopter program. Created project plan, testing plans, set functional design parameters, and maintained defects and issues logs. Worked closely with internal stakeholders in business analyst role to educate and train users on new features and functionality.
• Maintained all Oracle EBS 11i sysadmin functions including scheduling jobs, reports, job managers, workflow administration, user creation and security.
• Enhanced company EBS usage through configuration changes in Financials, Manufacturing, WIP, Demand Planning, BOM, ASCP, Inventory and Engineering.
• Introduced Executive level KPIs focused on financial aspects of previously developed tools in manufacturing, supply chain, sales and operations.

Confidential

Data Analyst/Business Analyst

Responsibilities:

• Improved forecast accuracy 30% using SQL and Excel to data mine sales history and use statistical analysis to create a seasonality index and forecast.
• Enhanced ASCP plans by training users on different types of safety stock and implementing MRP planned Percent safety stock to allow ASCP to more smoothly calculate safety stock levels.
• Developed basic S&OP procedures, including creation of KPIs, extra database tables to store S&OP related information, visualizations and data sets.
• Analyzed forecast consumption using Excel to compare combined sales data sets with forecast data; showed a 35% improvement in accuracy at the week to week level.
• Supported users in the US, China and the UK. Created an atmosphere of great customer service and support with the internal user base. Formalized issue reporting and maintained quick response times for all users.
• Formalized procedures for dealing with open transactions during Financials month end in WIP, Inventory, Purchasing and Order Management.

Confidential

Business Intelligence Reporting Analyst

Responsibilities:

• Increased report usage by identifying business process improvements through data analysis, engaging stakeholders and facilitating report adoption workshops.
• Created Capacity Planning Dashboard tool in Excel to track production schedule on shop floor and allocate resources to the correct work centers for demand planners using WIP.
• Data mined purchasing/supply chain data to create dashboard in Excel to net purchase orders with work orders so purchasing analysts could understand where their product was being used.
• Improved data quality for finance department by creating automated comparison tools in Excel to catch data entry errors related to customers, payments and item costs.
• Supported creation and upload of new Price Lists in Advanced Pricing. Created analysis tools to assist pricing analyst in flagging out of date prices and prices infringing on margins.