Abhirup Das, Business Analyst- Corporate

Abhirup Das

Business Analyst- Corporate

Bhatia Brothers Group

Location
India
Education
Master's degree, Supply Chain, Finance
Experience
7 years, 10 Months

Share My Profile

Block User


Work Experience

Total years of experience :7 years, 10 Months

Business Analyst- Corporate at Bhatia Brothers Group
  • United Arab Emirates - Dubai
  • November 2013 to March 2016

• Sales & Financial Analysis: Analyzing key financials including P/L, cash flow, expense statements, creditors/debtors, cost control and sales data including customer/ product segment wise profitability, coverage, market share, NPD, channel effectiveness for engineering retail business units with annual turnover at AED 400 mn. Preparing annual sales budget, business plans, resource allocation and re-structuring strategy. Reporting to group-CEO

• Supply Chain Strategy: Implementing inbound logistics integration by effective utilization of existing warehouses and fleet. Monitoring import/ local purchases vs. demand forecast, inventory ageing & liquidation, PI, alternate sourcing. Mapping AS-IS business processes, GAP analysis and designing TO-BE processes (materials management) for migration from Sun-Systems to Procurement ERP

• MIS: Measuring organizational performance through balanced score-card: formulated KPI, data collection, scoring & evaluation technique and dash board presentation. Conducting monthly reviews with business heads and support functions on BSC KPI and preparing MIS for senior management

Manager-Supply Chain at Tata Motors Ltd
  • India
  • June 2011 to October 2013

• SAP MM: Worked on MDM (master data management). Implemented MRP (material requirement planning in SAP-MM) for 72 class A item-family with annual buy-value of INR 70000mn (M & HCV plant). Conducted several UAT (user acceptance test) for ERP configuration. Trained new suppliers on SAP-SRM utilities like ASN to improve business process performance

• Procurement & Logistics: Buyer of high-value proprietary auto components. In depth knowledge of procurement and receiving systems i.e. supplier development, RFP, RFQ, SA, PO, GR/GI, QA. Strategic sourcing initiative for vendor base localization and optimization. Liaison with mother-satellite plants and logistics service providers for factory logistics and warehousing

• MIS: Prepared plant level supply chain MIS including inventory reports, consumption gap analysis, VQR, TAT, end to end reconciliation reports, spend analytics, CR/PI analysis, spare parts demand planning and maintaining divisional BSC (Balanced Score-card)

• Planning: Under the framework of Integrated Capex Management, formulated possible capacity expansion scenarios (Greenfield as well as brown field), in combination with different levels of volume, flexibility and investment and prepared decision tree based on 3P (production preparation process) methodology. Devised outsourcing terms with 3rd party logistics service provider-delivered an alternative service outsourcing model (cost plus model changed to transactional billing) by linking level of service with incoming parts freight tonnage

Assistant Systems Engineer at Tata Consultancy Services - EIS
  • India - Kolkata
  • August 2006 to July 2009

Tata Consultancy Services - EIS Assistant Systems Engineer Sept '06 -Jul '09


• Worked in TCS - Engineering and Industrial Services as a Product Design Engineer in pharmaceutical domain.
• Gained knowledge of FMEA, FTA and other risk mitigation and control procedures.
• Worked on entire phase of product development of surgical instruments including concept development, design, risk analysis and change management.
• Carried out development of 3-D models using CAD software (Unigraphics NX, I-DEAS) for human implants and medical devices to be used in minimally invasive surgery.
• Proficient in using MS-Project and Team Center Engineering.

Education

Master's degree, Supply Chain, Finance
  • at IIT Kharagpur
  • April 2011

General Management, Analysis, Process Improvement, Corporate Functions

Bachelor's degree, BE
  • at Jadavpur University
  • March 2006

Mechanical Engineering

Specialties & Skills

Supply Chain Management
Business Analysis
Strategising
Supply Chain MANAGEMENT
Business Analysis
Functional Consulting
Manufacturing Planning
Vendor Development

Languages

English
Expert
Hindi
Intermediate

Memberships

APICS
  • Supply Chain Strategy
  • May 2010

Training and Certifications

• Certified Supply Chain Professional (CSCP) from APICS, US. (Certificate)
Date Attended:
August 2010
Valid Until:
July 2016

Hobbies

  • Business Quiz, Extempore, Blogging
    •Winner of 2nd prize at “Blitzkrieg 2011”, quiz contest conducted by Tata Motors •Winner of 1st prize at “Vision 2020”, concept paper writing contest conducted by Tata Motors •Winner of 3rd prize at “BIZWIZ”, a business quiz contest conducted by VGSoM. •Certified by Indian Medical Association (IMA) and National Council of Science Museum for writing ability and general awareness.