Tarleen Dand
Logistics Analyst · The TJX Companies, Inc
Work Experience
Logistics Analyst
The TJX Companies, Inc2021 – Present
Graphed Inbound SC load variability and trends using Pivot charts and Power BI for approx. 20 service centers by extracting data from SQL Server DB and Itrack for 52 weeks • Prepared 5 yr. data and load graph for 3 service center bids by using Pivot tables and coordinated with GS&P team for release • Performed cost analysis on transportation rates from 5+ providers across 25-mile ranges using Nested If and Match functions • Reduced FSC charges by 7 - 12% by influencing the negotiations for the smaller set of lanes • Verified and Validated invoices worth $900K to $1.3M weekly • Assisted in new PO process for 25service centers and organized training for 30+ including TM's and providers • Used PC miler 32 (street version) to capture cost fluctuations impacted by transition of 39 stores from one SC to another
Co-op
3PL2020 – 2020
Achieved a 70% reduction in the operational turnaround time by automating data retrieval processes from the Warehouse Management System (WMS) database utilizing report generation for Inventory Optimization/accuracy • Lowered waiting time by 60% for OS&Ds by updating transportation policy, fuel surcharges and zone charts, and contract validity in Transportation Management System (TMS) • Associated with the Inventory Manager to drive inventory cycle counts worth $50K to facilitate efficient MRP, inventory tracking, and stock management for FMCG • Improved data quality of more than 100 employee records by using VLOOKUP and Pivot tables to perform data clean-up • Implemented 5s by sorting Bill of Lading (BOL) for 7 months and creating racks with shadowed/Colored areas • Created Value Stream Map (VSM) to measure inbound and outbound logistics/warehouse operations metrics for performance improvement in warehouse and transportation by conducting Gemba walk • Functioned with the management team in forecasting and creating a warehouse RFP approx. worth $5M
Associate Engineer (Supply Chain Management)
Accenture2017 – 2018
• Administered a daily average of 50-100 SCM Retail order issues worth $100K-$500K by tracking dashboard KPI's • Monitored Supply Chain Dashboard for orders from 23+ countries • Designed a database project during training and used SQL queries to pull/retrieve data and perform data analysis • Owned relationship with different cross-functional teams to resolve technical issues between retailers and client company • Fostered a group of 25-30 employees during green field and core training
Education
Bachelor of Engineering in Electronics and Telecommunication
Mumbai University, Vivekanand Education Society's Institute of Technology2017
Bachelor of Engineering in Electronics and Telecommunication
Master of Science in Engineering Management
Northeastern University2020
Master of Science in Engineering Management