Rajarshi Ghose Dastidar

• Solved a business use case to find the optimal time for a retailer to place order to a supplier for a new product line of Batik T-shirts for its summer 2017 collection
• Built a linear regression and newsvendor model to find the optimal time, taking into considering uncertainty in production and delivery process
• Analyzed risk on profits and costs that may incur due to delivery delays
• Recommended steps for better vendor management and negotiation

The objective of this project is the application of business intelligence and analytics processes and methodologies to identify potential drivers for aircraft crashes.

Data for last 30 years has been collected to identify:

- Possible segments in crashes and fatalities using Clustering
- Analyze crashes based on aircraft types, number of engines, manufacturing company, etc.
- Impact of other factors such as weather, pilots error, mechanical failure, crew, sabotage, aircraft… Show more

The objective of this project is the application of business intelligence and analytics processes and methodologies to identify potential drivers for aircraft crashes.

Data for last 30 years has been collected to identify:

- Possible segments in crashes and fatalities using Clustering
- Analyze crashes based on aircraft types, number of engines, manufacturing company, etc.
- Impact of other factors such as weather, pilots error, mechanical failure, crew, sabotage, aircraft type and other forms of human errors resulting in air crashes using Logistic Regression
- Use text mining algorithms to mine unstructured text data to identify patterns and relationships Show less

Research and analysis on McDonald's retail operations on the following elements:

1. Overall presentation of McDonald’s: products sold, company history, business model, financial performance, market analysis, primary competitors, distribution model, new market strategies
2. Inventory management, stocks outs and replenishments
3. Inventory inaccuracy and store management
4. Inventory turnover and related KPI’s
5. Assortment planning – breadth vs. depth, customization
6.… Show more

Research and analysis on McDonald's retail operations on the following elements:

1. Overall presentation of McDonald’s: products sold, company history, business model, financial performance, market analysis, primary competitors, distribution model, new market strategies
2. Inventory management, stocks outs and replenishments
3. Inventory inaccuracy and store management
4. Inventory turnover and related KPI’s
5. Assortment planning – breadth vs. depth, customization
6. Technology usage in daily operations and management
7. Pricing practices
8. Internet channel
9. Green practices
10. Expansion to or from emerging markets and associated challenges Show less

• Implemented lean methodologies for achieving process efficiency for Add-on-Sales by increasing throughput for flow from ‘Submission’ to ‘Approval’ duration, improving flow and resource efficiencies, mitigating risk, and optimizing flow function
• Achieved reduction of application processing time from 68 to 15 days, leading to significant process improvement
• Recommended ways to improve operational functioning to Governance Board

- Researched on Amazon's supply chain strategy and business practices.
- Analyzed supply chain drivers including Facilities, Inventory, Transportation, Pricing, Information and Sourcing.
- Conducted market research, competitor analysis, push/pull boundary.

• Hands-on practicum in creating master and transaction data such as BOM, Purchase Order and Invoice Receipts on the SAP ECC 6.0 (MM, SD, PP), SAP 7.0 (DP, SNP) platforms
• Executed routings for 25 finished products and planned transportation lanes
• Forecasted and planned the demand using MRP to simulate the material planning process for 15 BOM structures

Computed cycle time, throughput and equipment utilization through process analysis for 15 processes
Performed Gantt Chart Analysis to reduce lead time by 30 minutes and ensured 100% customer order fill rate
Identified bottleneck operations and increased productivity by 50% through efficient resource planning

- Analysis of Walmart's business segments and business model
- SWOT Analysis
- Corporate financial analysis
- Business offerings and revenue sources
- Key elements of supply chain
- Walmart's distribution network
- Purchasing policy : strategic vendor partnerships
- Global procurement strategy
- Supplier relationship management
- Cross docking
- Current & future trends