Post Job Free

Resume

Sign in

Supply Chain Analyst

Location:
Somerville, MA
Posted:
October 05, 2020

Contact this candidate

Resume:

AKSHAY J KOCHHAR

Boston, MA ***** 609-***-**** adgosw@r.postjobfree.com linkedin.com/in/akshayk9 github.com/kochharakshay EDUCATION

Master of Science in Engineering Management, (GPA: 3.8/4.0) June 2020 Northeastern University – Boston, MA

Relevant Coursework: Global Supply Chain Strategy, Supply Chain Analytics, Demand Planning & Forecasting Bachelor of Engineering in Computer Engineering, (GPA: 3.2/4.0) May 2017 Mumbai University - Mumbai, India

Relevant Coursework: Data Warehousing & Business Intelligence, Database Management & Design SKILLS

Databases: MySQL, MongoDB, SQL Server, PostgreSQL

Programming Languages: R, Python(NumPy, SciPy, Pandas, Selenium, BeautifulSoup), C++, Java Tools: Tableau, PowerBI, MS Suite, Qlik Sense, MS Access, Alteryx ERP: SAP ERP, Oracle PLM

Lean Tools: Root Cause Analysis, Kaizen, 5S, Gemba, Bottleneck Analysis Certifications: Lean Six Sigma-Green Belt, Tableau Analyst PROFESSIONAL EXPERIENCE

Supply Chain Analyst Co-op August 2019 – December 2019 Hilco Vision – MA, USA

• Managed a supply base of over 150+ suppliers and was responsible for identifying, quoting, negotiating and sourcing 43% of total annual spend (total annual of over $50M)

• Achieved annual savings of over $70,000 by leveraging supplier negotiations, supplier consolidations, inbound transportation optimization, market analysis and forecast future trends of key commodities

• Designed a Part Shortage Tableau dashboard to identify parts at risk for production based on daily demand, next shipment date, inventory quantity on hand and contingency plan to reduce risk

• Increased inventory turns by 25-35% by developing an EOQ model leveraging BI tools (Tableau, PowerBI) to formulate an optimal ordering model that improved efficiency in the replenishment process and minimized inventory cost

• Designed P&L and Order Intake dashboards, accessing data directly from SAP and Oracle through VBA, thus providing immediate visibility and reducing decision-making time by 35%

• Strategized methods to work through any excess inventory, initiated vendor reviews and item MOQ negotiations, maximized fill-rates up to 95% and on-time deliveries up to 100% while driving operational improvements Supply Chain Analyst January 2016 - July 2018

Mohan Exports – Mumbai, India

• Managed 100+ suppliers for timely delivery of components and expedited the deliveries of critical items. Enabled automation in material management system, which furnished material requirements, saving storage costs by 40%

• Managed multiple RFX and helped the company save $60,000 through contract re-negotiations and reduced prices by 27% while utilizing extensive vendor management techniques to ensure enhancement and continuation of services

• Collaborated with planning and product development team to develop forecasts and aggregate plan of raw materials

• Identified and assessed quality, systems, parts and process verification for existing suppliers to conform to quality assurance. Created region-wise demand plans by collaborating with sales, marketing and demand planning

• Planned and created a Master Production Schedule for orders worth $20M every year in line with clients requirement and monitored production to improve on-time project delivery by 24%

• Partnered with Marketing, Manufacturing, Demand Planning team to develop launch strategies for NPI’s & ensuring material readiness for timely launch & reducing the risk of E&O inventory at the end of the product life cycle PROJECTS

BI application to improve performance of Retail Company (SQL, Tableau, Power BI, Qlik Sense) July 2019

• Developed interactive BI dashboards to analyze sales, inventory planning for over 20M transactions

• Performed reject analysis to provide solutions to improve pricing & profit, successfully carried out budgeting, forecasting, and planning review for products, product categories, geography, and stores



Contact this candidate