John Adrian Email and Phone Number

- Managed Supply Chain and Operations Data Initiatives which provided $5.2 million in net benefit to the organization- Created Retail Foot Traffic machine learning model with net benefit of 1.2 million- Created Supply Chain machine learning model to predict when product would be available for customers (net benefit $2.2 million)- Translated complex engineering and data science plans into presentations for high-level stakeholders (VP of Operations, President of Organization)- Met with stakeholders to identify business data needs, and create implementation plans- Managed and maintained IBM DB2 data warehouse- Built SQL based stored procedures for manipulating and preparing warehouse data- Implemented Style Guides for Python, SQL- Maintenance of data warehouse utilizing real time replication- IBMi and RPG certified- Created powerful storytelling visualizations for stakeholders (COGNOS, Google Sheets, Power BI)- Implemented Object Oriented Python design for ETL processes.- Created and maintained node.js ETL layers for transferring data into Google Sheets and automating delivery of created reports- Responsible for researching problems that can be solved with Machine Learning solutions