John Schmudde Email & Phone Number

Knoxville, TN, US

Maryville, Tennessee, United States

• Built integrations between Oracle ERP and other enterprise systems using Oracle Integration Cloud (OIC) that allow for ERP data to be used by other systems and for other systems to push data to ERP.
• Engineered automated Python pipelines for data extraction, transformation, validation, and loading, migrating data from several legacy systems to Oracle Fusion Cloud, saving more than a thousand hours per rollout while.
• Developed programs & scripts to interface with Oracle Fusion via REST and SOAP APIs, significantly reducing manual effort and saving numerous hours for the team each week.
• Implemented team wide version control using Git and Bitbucket, enabling effective collaboration and code management.
• Authored and maintained comprehensive documentation for all scripts and programs created by the team, ensuring code maintainability and facilitating knowledge sharing.
• Performed configurations on Oracle Fusion ERP and promoted them through Production.

Maryville, Tennessee, United States

• Leveraged technical skills to support configuration and implementation of Oracle Fusion Cloud SCM modules for 60+ facilities.
• Utilized Python to develop an advanced Business Intelligence solution, integrating dynamic querying and dashboard analytics. This robust tool operates on a web server, facilitating seamless API communication with.
• Developed programs & scripts to interface with Oracle Fusion via REST and SOAP APIs, significantly reducing manual effort and saving numerous hours for the team each week.
• Automated the transformation of large, unstructured datasets into streamlined ERP import files with a custom Python script, eliminating the need for over 40 hours of manual processing.
• Developed method to extract data from Oracle Fusion ERP for reviewing data from multiple ERP environments allowing for better integration and automation.
• Authored PowerShell scripts that optimized workflow efficiency, streamlining routine tasks and enhancing productivity.

Maryville, Tennessee, United States

• Leveraged technical skills to support configuration and implementation of Oracle Fusion Cloud SCM modules for 60+ facilities.
• Automated Oracle environment comparison and synchronization using Python, drastically improving efficiency and ensuring data consistency.
• Engineered several mobile applications via Power Apps to enhance data governance and operational efficiency, successfully streamlining processes and yielding over 25 hours of weekly time savings.
• Devised a Python script for Oracle Fusion SCM, enabling daily, facility-specific forecasting—previously infeasible due to the size of the data (1 million+ records).
• Formulated a Power BI report to scrutinize and refine forecasting models, aligning them more closely with actual sales data.

Knoxville, Tennessee, United States

• Solely developed and implemented a Power Apps based Inventory Management System with barcodefunctionality for 100’s of surplus items and a Power Automate approval workflow saving 50+ hours/yr.
• Built and automated many multi-page dynamic reports with Power BI and Power Query which saved 15+hours a week and resulted in better data driven decisions.
• Designed and managed a comprehensive Power BI dashboard for the Supply Chain department.
• Developed an Excel and Power Automate automation analyzing and updating 6000+ items’ reorderpoints and quantities saving 100+ hours.
• Coded SQL scripts to efficiently extract and integrate data into Power BI Dataflows, enhancing data management and analysis capabilities.
• Automated the workflow for adding new items into ERP with RPA improving efficiency by 500%.

Knoxville, Tennessee, United States

• Utilized Zebra scanners to put away hundreds of items
• Assisted customers with technical difficulties
• Utilized POS systems to complete transactions