Sr. Manager - It Analytics
Current Current Business Lead working with IT to gather requirements in developing standardized reports and KPIs for Ryerson utilizing ERP reporting tools such as SAP BW, Cognos, and Data Warehouse Manage data incorporation from acquisitions into Data Warehouse and Managerial reporting Oversee and coordinate activities of IT, Cognos TM1 Implementation partner and Financial Planning & Analysis group to create data feeders and load scheduling jobs to automate monthly financial reporting process Develop Customer Specific Reports to measure Inventory, Sales and Days of Supply Develop Model for Regional Forecast by Product CategoryAccomplishments* Gathered requirements and worked with Information Services to build out parts of data warehouse including Inventory, Purchase Orders, Receipts and Consumption data.* Partnered with IT to automate weekly and monthly inventory reports saving 24 hours a month * Provided Data analysis to assist Regions and Corporate Procurement reduce inventory dollars by 43% during 2009 and reduce slow-moving inventory an additional 37% in 2010* Identified $6.5 million of slow-moving, lower cost carbon plate at Joint Venture in Mexico that could be moved to the US for sale in a rising price market