James Bartley Lisk, Cppm Email & Phone Number

Minneapolis, Mn, Us

Leading the Deployment of SAP Data Warehouse Cloud and SAP Analytics Cloud as the future reporting and analytics platform for Flagstone Foods.• Work with cross functional departments to understand their current use of SAP ECC, SAP BW and a Custom MS SQL Server reporting environment and the gaps in their reporting needs.• Work with the Flagstone Analytics Steering committee and Senior Leadership Team to prioritize reporting needs for development on the SAP Cloud Platform.• Defined Architecture and Best practices for development in DWC and SAC.• Lead team on technical build of DWC data models and SAC "Story" Dashboards in Agile approach.

Cincinnati, Oh, Us

Wayzata, Minnesota, Us

Working with Cargill Strategic Sourcing and Procurement (CSSP) BI team with a focus on migrating from MS SQL Server environment to the Cargill Hadoop Data Platform (CDP) for reporting and analytics.• Support Alteryx workflows that ETL Purchase related data from SAP HANA to MS SQL server where Power BI reports/dashboards are modeled. Analyze and correct issues with the logic in the workflows and/or stored procedures in MS SQL server that calculate the key performance metrics.• Developed Strategy to convert the Alteryx workflows to Impala SQL views on SAP data in Hadoop to migrate away from MS SQL Server as the main source for reporting. This eliminates the need for Alteryx workflows and allowing the team to build out a global reporting environment in PowerBI where all source system data is ingested and modeled in the CDP data lake.• Data Lead for Spend Visibility Project to consolidate Spend data from all source systems globally to manage indirect addressable spend. Oversaw ingestion processes across SAP and JDE instances and act as the SAP data SME for curating the spend data into the global spend template in Hadoop.• Led Utility Bill Management project working with UBM vendors to ingest data from their Vendor platforms back into Cargills CDP for consolidated Utility Bill Analytics.• Led initiatives to replace custom SAP ABAP reports as SQL views on the CDP Hadoop environment integrated directly into PowerBI Dashboards. The cost of creating SQL views versus maintain custom SAP ABAP reports in 6 different SAP instances produced substantial savings in development costs while saving users many hours downloading and manipulating data from SAP application.

Wayzata, Minnesota, Us

Transitioned from a Continuous Improvement Role to Service Ops Lead role for Global IT D&BI team. • Lead for SAP SLT real-time replication server used for procuring data to SAP HANA from 6 SAP source and non-SAP source systems replicating 500+ tables for real-time reporting and analytics.• Manage SLT lifecycle of Support Pack updates and data center migrations of source/target DBs.• Managed support of Cargill’s custom Data warehouse, Oneview, for Global Sales, Spend and Diversity reporting and the OneviewMDM application for non-SAP customer/vendor MDM starting in 2016.• Made improvements to annual SAP DART process so extract views could be run using jobs and variants mass updated by WinShuttle tool. This saved 80-120 hours per SAP instance over the manual process.• Lead BI Analyst on currency conversion project for SAP ECC. Provided impact plan of data changes for all SAP BW reports/universes and developed testing and validation process for the conversion.• Provide enhanced support to finance for internal and external audits requiring DART or BI data.

Wayzata, Minnesota, Us

Transferred from CFS BU to Global IT bringing 10 years of SAP ECC and BW experience to D&BI Service Delivery team supporting Cargill’s new Global SAP implementation. • Used my SAP experience to coach other team members working incidents and work intake requests.• Led a monthly Community of Practice (CoP) call for BU users to share knowledge of the BI solutions. • Worked Extensively in the OTSC, COPA, PLTP, MGMS, PRTP, and RTR areas for SAP BW/BI.• Assisted BUs navigate the Change Request process requiring understanding of the end to end solution.• Troubleshot complex data and design issues affecting reporting for various BUs to identify the root causes in the solution. Made the recommended back end and/or front-end changes needed to resolve problems and improve solutions like GL Write Off reporting and Government bid reporting.• Led the ITIL Problem Management area on the Service Delivery BI team driving incident reduction.• Oversaw the SAP Data Archive Retention Tool (DART) extracts for Tax and Audit.• Led a process improvement team defining the End to End roles & responsibilities across the various D&BI project development teams.

Wayzata, Minnesota, Us

Performed lead role managing SAP systems and integrations after the Cargill acquisition of Degussa for multiple BUs covering 750 users globally across 30+ sites.• Managed project for fiscal year change for both CFS and CTS (Cargill Texturizing Systems) SAP ERP and BW systems from calendar year to Cargill year fiscal year within 1.5 months of the acquisition.• Oversaw the implementation of the Cargill Elizabeth juice facility migrating from Adage to the CFS SAP system within 2.5 months of the Degussa Acquisition. • Led the system migration project for CFS SAP and BW systems hosted by Degussa on IBM AIX in Frankfurt Germany to 3rd party EDS (HP) hosted sites in Canada on Sun Solaris. • Managed the ongoing SAP hosting and basis services provided by EDS (HP) for CFS SAP systems.• Directed the support of the Cargill Texturizing Systems (CTS) North America SAP ERP system. • Led a Project to implement the CTS Decatur, IL Lecithin business onto the CTS SAP ERP system. • Cargill Lead for Migration of the CTS NA SAP system to external hosting provider GFI in France.• As Application Owner for the CTS and CFS SAP systems, instituted the Cargill TGRC IP initiative and ITIL requirements for all SAP environments and participated in ongoing system audits.• Oversaw the development and testing of a shop floor data collection system to interface with the CFS SAP ERP system using RFC and IDOCS. The shop floor data collection used RF barcode readers and scales to capture inventory movements and replace the WM functionality used in SAP.• Participated in the RFP vendor selection team to Implement Cargill UK Duckworth flavors sites to the CFS SAP ERP and BW system and provided integration support for the project implementation.• Managed Project to organize SAP P&L data with COPA data by product category using the SAP BW data warehouse system to provide global management reporting for the CFS BU.

Wayzata, Minnesota, Us

Managed Cargill Flavor Systems (Formerly Degussa) SAP systems as well as other 3rd party and in-house developed applications.• Led a team of 4 internal employees and 1 contractor supporting 2 SAP ERP, 1 BW Data Warehouse/BI Systems for 2 different Global BUs, R&D systems, and systems for shop floor control/product labeling.• Managed the BU relationship with the internal Degussa shared service group for hosting and Basis services for the multiple SAP instances.• Managed the BU relationship with Intelligence, an external provider of SAP helpdesk/consulting services. Was able to reduce the number of monthly support hours used and redeploy hours to value added projects like implementing SAP Fixed assets to decommission 3 nonintegrated FA systems.• Technical Lead for a divestiture project to split a divested business line to a separate SAP ERP and BW instance. Managed support for the new SAP instances over 1 year after the divestiture.• Project Manager and Design Lead for project to re-design a custom developed R&D Project system to VB.NET leveraging an existing Oracle database and IT resources with minimal capital expenditure.

Wayzata, Minnesota, Us

Managed SAP BW system including security, data loads, query creation, end user training and support.• Led a team implementing BW during an SAP ERP implementation project. Developed processes to integrate sales data into SAP BW from 12 non-SAP sites with processes to support sales budgeting.• Prepared materials and trained over 30 super users globally on the proper use of SAP BW tools and data. • As a member of the SAP implementation SD team, I led the extraction, conversion and loading of master data from 3 legacy systems (Ross, Macola, and SAP 3.1i) into SAP ERP.

Wayzata, Minnesota, Us

Provided Project Management and lead role on Major ERP implementation of Ross RENCS system.• Led master data conversion projects implementing RENCS ERP system.• Modified RENCS ERP programs to streamline business processes and provide EHS and cost reporting.• Managed Design and development of applications to interface the RENCS ERP system to labeling and barcode systems used in Manufacturing, Shipping, and Inventory control.

Wayzata, Minnesota, Us

Responsible for the full lifecycle design and maintenance of all custom developed software • Re-designed a custom in-house ERP system to support multiple plant locations during a business expansion that helped enable a 4x growth in revenue for the business.• Developed a mission-critical Flavor R&D Project and Sample Tracking System (SampleTrac).

Wayzata, Minnesota, Us

Network Administrator for growing flavor manufacturing company responsible for all desktop applications and support. • Managed Novell Network Servers, security, server upgrades and upgrade of Local Area Network cabling from coax to Cat 5.• Converted desktop systems for Window 3.1 operating system..• Managed Installation of PBX telephone equipment and network/phone expansion to new admin and manufacturing facilities.• Transitioned from Novell Servers to Microsoft NT servers managing all performance issues with desktop applications during the transition tot he new server technology.

Master'S Degree, Business Analytics

Graduate Certificate, Business Analytics

Mini Mba Program

Executive Edication, Certified Professional Project Manager (Cppm) Program

High School Diploma

Bs, Accounting And Decision Sciences