YASH PANSE
617-***-**** Boston, MA *****.*@************.*** linkedin.com/in/yashpanse
EDUCATION
Masters of Science in Engineering Management September 2018 – December 2020 Northeastern University, Boston MA
Bachelor of Engineering in Mechanical Engineering July 2013 – June 2017 SRM University, Chennai TN, India
WORK EXPERIENCE
Logistics Business Analyst Co-op at Dell Technologies, Franklin, MA Feb 2020 – July 2020
Evaluated fundamental data sets – install base, demand, inventory levels & service maintenance revenue using data visualizaton functons on Tableau to provide compelling insights into the utlizaton of Dell EMC global parts proile
Analyzed bulk parts dispatch proile & indicated sharp correlatons between bulk orders & unused return actvity
Developed a global country KPIs dashboard consistng of 90+ countries in the Dell EMC network infrastructure
Collaborated with Global services and planning teams to review and identfy potental shipments missed in Canada and inform alert team about the tracking status of the 600 shipments weekly to get 16% less delayed shipments in a month
Assisted the Logistcs team with re-mapping of customers and warehouses, forecastng the part usage and inventory levels & updatng the enablement Power BI tool to expand the support network in EMEA and APJ regions
Proposed distributon network in Okinawa, Japan to save $350k of distributon and transportaton costs annually
Worked with Inventory Control team to track the monthly fulillment actvity of inbound & outbound orders on Oracle 11i and identied RTG material, scrap and warranty recovering parts at Distributon centers in Cork & Franklin
Leveraged opportunites with cross functonal teams to manage new product development by using tools like PLM, ERP and databases that drive consistency in logistcs operatons processes Supply Chain Intern at Tata Motors Limited, Pune, Maharashtra, India June 2015
Operated warehouse equipment, assisted in the creaton of process maps, reviewing & analyzing data on demand variability, supplier shipping performance & replenishment orders for purchased inished material
Monitored, examined and listed 50 skin panels of various grades of sheet metal and tested durability of each using cupping tester that helped in process improvement of 3500 motors over a period of a month
Proposed and developed lean method for eliminatng scrap coil processing equipment at the start and end of the blanking line at the Press Shop Warehouse saving 7% of scrap material in the manufacturing car plant
Managed MRP and metric reportng systems to replenish inventories of 65+ SKUs, developed pricing grids and forecast accuracy models to enable real tme decision making in supply chain
Implemented Project plans for budgetng, monitoring & scheduling throughout project tmeline to monitor WIP TECHNICAL SKILLS
Sofware & Programming : R Studio, MySQL, Lingo, AMPL, MATLAB, C++
Statstcal & Visualizaton : Minitab, Tableau, Power BI, Oracle 11i (ERP), Macros, Advanced Excel and VBA, MS Ofce
Certicatons : Lean Six Sigma Green Belt, Diploma in Product Designing & Analysis (AutoCAD, Solidworks, Ansys) ACADEMIC PROJECT
Transportation Network Design September 2019 – December 2019
Formulated and Structured the Transportaton network by analyzing two complex transportaton networks
Implemented mult commodity fow process across the concurrent rings in network to achieve optmality gap of 0.05
Proposed method for passage of fow resulted in cost reducton by approximately 27% Expansion of Distribution Network in a Remote Location September 2020 – December 2020
Analyzed data of existng distributon network consistng of multples warehouses of an established MNC
Identied and ploted locatons for seing up a storage warehouse expanding the network
Evaluated the project plan to exploit the customer base, allocated resources and estmated cost parameters Modeling of Sports Training Schedule on AMPL September 2018 – December 2018
Developed an optmizaton model that can help identfy the best groups for each training session
Enhanced teams ability with 8% increase player performance & meetng requirements given by the coaching staf
Provided a comprehensive soluton to create an easy and moldable soluton to the training schedule