Office Assistant Data Analyst

SHRUTIK KATTISHETTI BUSINESS AND SUPPLY CHAIN ANALYTICS

******************@*****.*** 312-***-**** Chicago, IL https://www.linkedin.com/in/shrutikkattishetti/ PROFILE

An accomplished professional with 4+ years’ experience. Adept at understanding demand management & forecasting, MRP, strategic sourcing, inventory management and most importantly communicating actionable recommendations to stakeholders through highly consultative approach.

EDUCATION

o Master of Science in Industrial Engineering, University of Illinois at Chicago. (Jan.’18 - Dec.’19) o Bachelor’s in Mechanical Engineering, Visvesvaraya Technological University. (Aug.’11 - May’16) CORE COMPETENCIES

Technical skills: Advanced MS Excel SAP Tableau SQL Oracle R-Studio Power BI Python Relational Databases Soft skills: Strategic Thinker Problem Solver Effective Communication Strong Analytical Skills Team Player CERTIFICATIONS

APICS CPIM Certified Supply Chain Professional aspirant. WORK EXPERIENCE

Jr. Data Analyst Intern LEICA BIOSYSTEMS, IL (Jan.’19 – May’19) o Developed Q3 & Q4 demand forecasts for various product families & assisted in MRP using SAP MM system. o Analyzed material flow & tracked inventory levels to recommend safety stock & prevent back-orders. o Executed data extraction and transformation to develop hard-hitting analyses & solved complex business challenges. o Analyzed market strategies, trends & future opportunities to present insights through scorecards, visualization reports and PPT presentations to higher management.

General Office Assistant UI HEALTH, IL (July’18 – Dec.’18) o Ensured accurate monthly JIT inventory of UI Health supplies & equipment for various departments. o Collaborated with vendor management, purchasing and warehouse teams to avoid stock-outs. o Reduced on-hand inventory for three locations resulting in total savings of $250,000. o Maintain contract database in MMIS along with analyzing supply spend to recommend strategic sourcing insights. Supply Chain Analyst UNITED INDUSTRIES, INDIA (June’14 – Nov.’17) o Designed and implemented tracking monthly metrics & performed process improvements (Lean/DMAIC) resulting in increased lead times by 21%.

o Created predictive forecasting using utilizing previous MRP data ensuring proper level of inventory with >1200 job parts in warehouse. Identified and removed >$400,000 in excess and obsolete inventory. o Played key role in design and implementation of new SOPs to enhance process and business improvements. Supply Chain Intern BELGAUM METALS, INDIA (Sep.’13 – Feb.’14) o Worked with supply chain team to ensure production, inventory, and outgoing products to match and deliver the orders in optimized manner.

o Cultivated 5S and Lean Six Sigma methodologies that led efficiency in all characteristics of operations and eliminated errors within processes.

CASE STUDIES

o Apple Inc: Managing a Global Supply Chain: As termed world’s best supply chain managing company, analyzed Apple’s four main supply chain domains Strategy, Supplier, Distribution and Retailer. Further formulated detailed recommendations to the management whether to make the required investments in Apple. o Walmart- Kaggle Forecasting- Python: Analyzed past sales data to forecast new demand using 3 different models where the Holt Winter’s Aggregated Model gave the lowest Mean Absolute Percentage Error of 3.06, indicating the forecast was almost similar- to the Actual Demand. Also identified Key Trends and KPI that affected past sales. o Time Series with R Studio: Forecasting of demand using R studio for Specialty Plastics Corporation by using Holt-Winter model and reduced MSE by 75% and MAPE by 46% from baseline model of average demand over same quarters.