Karan Ksheersagar
MES Data Analyst
No profile blueprint available for this candidate.
Job Compatibility Score
MES Data Analyst
55%Here is the completed candidate evaluation for Karan Ksheersagar, based on the provided Job Description and Resume.
Total Score: 55 / 100
Key Insights: This candidate is a strong Data Analyst with solid technical skills, but he is not a fit for this specific role. The JD is for a Manufacturing Execution Systems (MES) Analyst within an electronics or semiconductor environment. While Karan has relevant SQL and data analysis skills, his domain experience is in non-profit, fintech, and automotive (Bosch), not in the specific MES/semiconductor context required. His experience at Bosch is the closest match, but it was a short tenure and focused on general ERP data, not MES systems. The lack of direct MES experience and the specific semiconductor domain is a critical gap. He would be a strong candidate for a general Data Analyst role, but not this one.
📊 Candidate Evaluation Table
| Category | Details from Job Description | Claimed Experience | Relevant Experience | Evidence from Resume | Score |
|---|---|---|---|---|---|
| Job Titles | MES Analyst / Data Analyst (in MES context) | 4+ years as Data Analyst | 1 year (Bosch role) | "Data Analyst" at Bosch (Feb 2021 - Feb 2022) | 5/15 |
| Primary Role-Based Skills | Advanced SQL (joins, CTEs, window functions, aggregations) | 4+ years | 4+ years | "Engineered complex SQL transformations using joins, CTEs, and window functions" at Harlem Children's Zone. "Developed SQL-based data extraction, cleansing, and transformation logic" at Keeper AI. "Executed advanced SQL-based analysis on ERP and operational datasets" at Bosch. | 18/20 |
| Data Validation & Quality Assurance | 4+ years | 4+ years | "Conducted root-cause analysis on data discrepancies and implemented validation frameworks" at Harlem Children's Zone. "Performed end-to-end data validation from source systems to reporting layers" at Keeper AI. "Implemented data validation and reconciliation checks" at Bosch. | ||
| Root-Cause Analysis for Data Discrepancies | 4+ years | 4+ years | "Conducted root-cause analysis on data discrepancies" at Harlem Children's Zone. | ||
| Analyzing Large Datasets for Trends & Issues | 4+ years | 4+ years | "Analyzed high-volume behavioral and transactional datasets across 1M+ records" at Keeper AI. "Executed advanced SQL-based analysis on ERP and operational datasets to identify bottlenecks" at Bosch. | ||
| MES Systems & Operational Data | Not mentioned | Not mentioned | No mention of MES, manufacturing execution systems, or semiconductor/electronics operational data. | 0/20 | |
| Secondary Skills | Data Investigation & Insights for Decision-Making | 4+ years | 4+ years | "Support data investigation activities and provide insights for operational and business decision-making" is a direct match for his summary: "generate actionable insights that support business and operational decisions." | 8/10 |
| Continuous Data Quality Improvement | 4+ years | 4+ years | "Automated data cleansing and validation workflows... reduced data pipeline errors by ~25%" at Harlem Children's Zone. | ||
| Collaboration with Stakeholders | 4+ years | 4+ years | "Collaborated with cross-functional teams to gather business requirements, define KPIs" at Harlem Children's Zone. "Collaborated with cross-functional teams across finance, operations, and IT" at Bosch. | ||
| Process Improvement Opportunities | 4+ years | 1 year (Bosch) | "Identifying process inefficiencies that led to a 15% reduction in production downtime" at Bosch. | ||
| Tools & Platforms | MES Systems (e.g., Siemens, Rockwell, SAP ME) | Not mentioned | Not mentioned | No mention of any MES platforms. | 0/10 |
| SQL Databases (e.g., SQL Server, Oracle) | 4+ years | 4+ years | "SQL Server, Oracle, PostgreSQL" listed in skills. Used SQL Server at Harlem Children's Zone. | ||
| Data Visualization (e.g., Power BI, Tableau) | 4+ years | 4+ years | "Built Power BI dashboards" at all three roles. "Tableau" listed in skills. | ||
| Certifications | Not specified in JD | N/A | N/A | Databricks Fundamentals. LinkedIn Learning courses. | 2/5 |
| Experience Level | Implied Mid-Level (3-5 years) | 4+ years | 4+ years | Consistent with the JD's implied level. | 8/10 |
| Domain Expertise | Electronics / Semiconductor Manufacturing | 1 year (Bosch - Automotive) | 1 year (Bosch) | "BOSCH... Developed production analytics and operational dashboards on ERP data... manufacturing processes." This is the closest domain match, but it's automotive, not electronics/semiconductor, and was a short tenure. | 4/10 |
| Consistency Across Summary, Experience, and Education | N/A | N/A | N/A | Summary, experience, and education are highly consistent. He presents as a Data Analyst with a clear career trajectory. | 10/10 |