Subrata Ghosh

Project 1 :

• Commodity Strengths: Sheet Metal, Machined Components, Fasteners, Assembled Parts, Wiring Harness and Hydraulic Hose.
• Process Strengths: Assembly, Sub-assembly, Routing, Inspection and Run-off.
• Reviewing supplier PPAP documents and providing approval for production and shipment.
• Collaborating with global suppliers on design reviews for new developments.
• SAP expert: creating Quality Inspection Plans, Q-notes, and Deviations.
• Ensuring timely PPAP submissions and resolved supplier concerns.
• Analyzing SAP data to visualize assembly line quality risks.
• Generating daily reports: Q-note, Deviation, scrap and more.
• Implemented corrective actions at the supplier end for quality issues.
• Reviewing designs and drawings with Product Engineer. Creating PFMEA with MP Planner.
• Verifying wiring & hose routing, suggesting design improvements.
• Performed FMEA on 3 key systems: Boom, Chassis & Solution System.
• Worked on various product lines: Sprayer, Harvester, Tillage, Seeding and more.
• Quality reporting for 3 global sites: Des Moines (USA), Catalao (Brazil) and Horst (Netherlands).

Project 2:

• Unlocking insights using Power BI: in-depth analysis and data visualization.
• Skilled in data visualization: reports, dashboards and charts.
• Creating interactive Power BI reports using DAX features.
• Power Query and Data Modeling: streamlining data analysis and reporting.
• Enhancing report interactivity with Power BI features: tooltips, drill-downs, slicers, row-level security, buttons, and bookmarks.
• Ensuring data accuracy in Power BI reports through expertise in relationships, cardinality, and cross-filter direction.
• Publishing and sharing reports with ease, managing user access and permissions.
• Connecting to data sources: SAP HANA, SharePoint and flat files.
• Developing KPI reports for Quality Data Analysis, driving informed decisions and strategic planning.
• Delivering frequent reports (daily, weekly, monthly) on production, quality, and workflow metrics.
• Built secure access control with Row Level Security (RLS).
  

• Commodity Strengths: Special Fasteners, Machined Components and Fuel Injector Parts.
• Analyzed rejection & rework data, implemented solutions using 8-D & 5-Why
• Developed rejection reports & corrective action plans
• Addressed customer complaints via root cause analysis (8D)
• Optimized processes through GD&T analysis
• Performed process & product audits
• Handled customer audits
• Qualified inspection team through Gauge R&R, Poison test, & kappa study
• Proactively resolved supplier quality issues
• Developed inspection methods to meet customer & system needs.

• Commodity Strengths: Metal Fabrication, Suspension Parts, Bottle Jack and Steering Components.
• Developed process & fixture innovations to reduce cycle time & rejection
• Managed rejection rates, maintaining PPM levels & analyzing failures
• Ensured quality through pre-dispatch & process inspections
• Skilled in various manufacturing processes & machinery
• Ensured smooth operations through machine & tool maintenance
• Implemented KAIZEN & POKA-YOKE for efficiency gains
• Successfully implemented quality management systems (ISO/TS 16949 & ISO 9001)
• Resolved customer and internal quality issues, driving CAPA/8D initiatives and quality enhancements
• Collaborated across functions (production, quality, supply chain, engineering) to resolve quality issues & implement corrective/preventive actions
• Conducted internal audits, ensuring quality compliance through corrective actions
• Developed a customer-focused quality team, driving alignment with organizational objectives.