Siddharth Rastogi, Mba, Ph.D. Email and Phone Number

Digital is a visual analytics and BI consulting company founded to meet growing needs of organizations in having end-to-end supply chain visibility. Digital provides complete service from big data store selection, data selection, data preprocessing and transformation (Extract Transform Load, ETL), to real-time dashboard development. BIG DATA STORE SELECTION : Evaluating and selecting appropriate big data stores to store and manage big data.DATA SELECTION : Selecting appropriate data to store in big data stores.DATA PREPROCESSING & TRANSFORMATION (ETL): Preprocessing target data to prepare for transformation and transforming preprocessed data to prepare for data visualization/data mining.REAL-TIME DASHBOARD DEVELOPMENT: Our specialty is in developing big data driven, real-time, supply chain performance monitoring dashboards.1. Inventory Planning & Replenishment Dashboards: To assist our clients in real-time monitoring of inventory planning & replenishment decisions and in updating plans when required, ultimately in decreasing such costs as markdowns and in improving customer service.2. Real-Time Inventory Management Dashboards: To assist our clients in real-time monitoring of end-to-end supply chain inventory and to have same and accurate view of inventory levels across departments & enterprises.3. Demand, Production & Procurement Dashboards: To assist our clients in real-time monitoring of demand plans and production & procurement schedules.4. Global Sourcing Risk Management Dashboards: To assist our clients in continuously monitoring global sourcing risks and in identifying sourcing issues as soon as they appear. 5. Disruption Management Dashboards: To assist our clients in managing global sourcing uncertainty that have increased with extended supply chains.6. Customer Service Dashboards: To assist our clients in providing products to their customers in right time, in right place and in right quantity and ultimately improving customer service.

• Support operations and finance senior leadership in taking strategic and tactical decisions by leading machine learning / advanced analytics, reporting and digital transformation projects that focus on global supply chain cost saving opportunities and improving customer service.• Deliver timely and actionable results to senior leadership by executing ad-hoc queries and leveraging multi-source data through big data analytics for providing root-cause analysis and identifying trends and key drivers.• Provide data-driven decision making support in complex global supply chain and customer service projects including $27MM increase in sales through upsell analysis and reporting, $60MM transportation cost savings through order consolidation and pack factor improvement analyses, customer returns forecasting, inbound forecasting, and $700K annual cost savings through packaging costs reduction in FCs across United States.• Independently designs and develops data visualization/data mining/data analysis models and dashboards after integrating and transforming big data using SQL/big data management tools such as Google BQ, Microsoft Azure, Teradata, and IBM Netezza, Simulation tools, SAS and Tableau to solve complex global supply chain and customer service problems.• Work with analysis, reporting and IT teams to execute the implementation of business intelligence tools and data warehousing including data requirements, data profiling and UAT testing.• Collaborate with IT Business Partners and Business Stakeholders to identify opportunities to leverage company data, externally relevant data and data platforms and enable better business decision-making.

Worked with Fortune 500 companies on digital supply chain transformation project that involved requirements gathering, data/process modelling, design through testing, deployment and support to help mangers in taking fact-based day-to-day decisions. Following are some tools used during the project: • Big data Visualization and Report development tools such as Tableau, Pentaho, MicroStrategy, IBM Cognos, SAS Visual• Big data Analysis tools such as R Studio, STATA, SPSS, SAS Enterprise Minor, SAS JMP• Machine learning methods such as Time Series, Panel Regression, GLM Regression, Decision Tree• Big data integration and ETL/EDW development tools such as Pentaho Kettle (PDI)• Big data management tools such as Hadoop, SQL Server, MySQL, Oracle• MS Office including MS Word, MS Excel, MS PowerPoint, MS Access, MS Project, MS Visio • Project management / SDLC methodologies such as Waterfall and AGILE

• Responsible for end-to-end supply chain big data solutions delivery which included hands on report and visualization development, data analysis and delivery, and production environment management of delivered solutions.• Responsible for participating in the business requirements gathering process, in architecture data modeling, and overall design sessions.• Responsible for training users and developing culture for data-driven, fact based day-to-day decision making.• Reduced decision-making time and improved supply chain decision-making by developing supply chain decision-making dashboards in which integrated data from interrelated business functions such as Demand Planning, Production Planning, Supply Planning and Customer Service. • Improved business agility by developing "invoice forecast coverage dashboard" that helped in day-to-day monitoring of products which need attention and enabled quicker response to changes in sales.• Optimized flow of inventory by reducing logistics costs and extra inventory through real-time monitoring of finished goods distribution network flow. • Developed end consumer demand sensing capability through geographic visualization dashboards for real-time demand monitoring.

Worked with FedEx on a research project that involved using Lean Six Sigma tools such as control charts for visualizing and managing supplier risk.

• Global Supply Chain Planner responsible for ensuring uninterrupted supply of company home textile products to the global retail chains such as Wal-Mart.• Formulated business plan to start sourcing home textiles from China and implemented job-work execution strategies to ensure economical & on time deliveries of orders. • Responsibilities include ensuring shipments of products from 3rd party suppliers in China meet company market forecast requirements.• Manage global distribution of home textile products ($10 M) with zero stock outs while consistently maintaining safety stock target.

Teaching Activity:Assisted in the Teaching of the Following Classroom Courses:• MBA 504 (602) – Data Analysis & Forecasting Methods for Management : Spring, 2012• BUS 370 – Operations & Supply Chain Management, 1 section : Fall 2011• BUS 340 – Information Systems Management, 1 section: Spring 2011 • BUS 440 – Data Base Management, 1 section: Spring 2011 • BUS 442 – Information Systems Development, 1 section: Spring 2011 • MIE 201 – Introduction to Business Processes, 3 sections: Fall 2010 Research Activity:Worked as Editor, IEEE Engineering Management Review (EMR), (Jan. 2012 – May 2012)• Develop IEEE Engineering Management Review Blogs.• Develop literature review for special issues of EMR.• Other administrative responsibilities.

Foodbuy is a GPO for the foodservice industry. Their unique competitive advantage is the flexibility they provide to clients to use any manufacturer and distributor they desire. This unique flexibility doesn't come without it's challenges. This project conducted a strategic assessment to determine how Foodbuy could:1. increase the spend clients allocate to Foodbuy manufacturers2. capitalize on information that Foodbuy has on hand3. look into creating new value to clients to incentivize increased spend. Results of the project produced recommendations in three pivotal areas: 1. Pricing Strategy2. Contracting Practices3. Business Intelligence.Recommendations were supported through the use of Data Analysis and Information Technology.

• Worked on implementing PSI planning system (JDA) to decrease global inventory level, increase customer service and enhance global operations visibility.• Reduced extra inventory at US warehouses in order to save $ 10M annually by performing opportunity cost analysis for maintaining extra inventory of several SKU’s.• Reduced Pallet Position Storage Requirement at US warehouses in order to save $ 390,000 by analyzing actual sales data for 2010 and forecasted sales data for 2011 of each SKU. • Calculated required ship quantities of finished goods to transfer between distribution centers based on established reorder points for all major brands.• Supported Planners with Material Requirements Planning: issued purchase orders for raw materials and components, expediting orders as needed, and verified delivery dates by maintaining MRP system parameters.• Interacted daily with manufacturing, packaging, quality and finance departments. Hold monthly meetings to ensure that all open issues receive followed through. • Managed inventory and reorder point of key raw materials based on manufacturing schedules. Discussed projected production plan recommendations with Planners.

• Worked with Lenovo, a global PC company, on a research project that involved reducing energy cost impacts on its global PC supply chain. • Researched and created a jet fuel price forecasting model that is projected to save $13 million annually by helping Lenovo in negotiating fuel surcharges with its carriers.• Gathered historical jet fuel spot prices for the U.S. Gulf, the U.S. Pacific, the Rotterdam, and the Singapore regions and assembled data into a user-friendly dashboard display.• Discovered that jet fuel prices closely follow crude oil prices and determined two factors—the value of the U.S. dollar and the Baltic Dry Index—as significant indicators of future prices.• Used exponential smoothing algorithms with user-controllable emphasis placed on recent data and on emerging trends to forecast crude oil prices. • Predicted the jet fuel spread to within 5.39 percent of mean absolute deviation by using another exponential smoothing formula and incorporated a linear regression trend line to serve as an indicator of long-term jet fuel pricing patterns.• Built a control into the dashboard that allowed the user to apply price patterns over a certain period of time to the forecast line.

• Led a diverse team of 20 executives for sales and operations planning and supervised operations, spanning product development and research to requirement analysis to sourcing, sampling and costing. • Reduced delivery time by five days and saved $ 125K by measuring delivery performance and techniques to improve supply chain and dealing with freight forwarders to ensure best freight rates and timely shipment of consignments.• Achieved 18% cost reduction in four months and enhanced user satisfaction levels by structuring, coordinating and maintaining activities/relationships across diverse agencies and supply chains. • Saved $ 200K by negotiating sales contract with distributors – addressed issues like payment schedules, quality of goods sold/bought, delivery, warranties, damages etc.• Increased sales by four million dollars by studying potential market demand, prospecting three new accounts and resolving channel supply bottlenecks.

• Led team of 20 professionals for managing SAP Implementation Process, and managing erection work and project to purchase 46 automatic power looms.• Worked with professionals to organize a smooth transition from the “as is” state to the “to be” state • Negotiated purchase agreements of USD 1.3 million with capital equipment supplier and saved $ 250K.• Created monthly forecasts for over 100 overseas and domestic products to assist supply chain management

• Acted as lead in design and benchmark testing for a range of over 100 products manufactured, granted quality assurance approvals and evaluated assurance plans for new and existing products• Created in-house product testing facility thus reducing company expenditure incurred annually through outsourcing.

Production Planning 2007-2008• Developed plans to delegate resources - labor, machinery, capital for execution of standard and Made-to-order demands.• Tracked and monitored production operations proactively, leading to increase in plant production capacity by 40%.