AT
Aman Thakur
MES Data Analyst
No profile blueprint available for this candidate.
Job Compatibility Score
MES Data Analyst
72%Here is the completed Candidate Evaluation Table for Aman Thakur, built against the provided Job Description for a Data Analyst role focused on MES systems and semiconductor/electronics manufacturing.
Total Score: 72 / 100
Key Insights:
- Strong Fit: This is a very strong candidate. The resume shows direct, recent experience with MES data, SQL optimization, and operational analytics in a manufacturing environment (EV production at Rivian via Capgemini, and industrial plants at Siemens). The domain expertise is highly relevant.
- Primary Skills: The candidate nails the core SQL requirements (CTEs, window functions, optimization) and has hands-on experience with data validation, root-cause analysis, and large dataset analysis. This is the strongest part of the profile.
- Domain & Experience: The experience in EV and industrial manufacturing is a perfect match for the "electronics or semiconductor" requirement. The 5+ years of experience aligns well with the implied seniority of the role.
- Minor Gaps: The JD doesn't explicitly list tools or certifications, so those categories are scored neutrally. The candidate's recent academic role is a slight deviation from pure industry work, but the Capgemini/Rivian role is current and highly relevant.
- Verdict: Highly Recommend for Interview. This candidate can likely step in and contribute immediately to data quality, analysis, and process improvement initiatives.
📊 Candidate Evaluation Table: Aman Thakur
| Category | Details from Job Description | Claimed Experience | Relevant Experience | Evidence from Resume | Score |
|---|---|---|---|---|---|
| Job Titles | Data Analyst (with MES/Operational Data focus) | 5+ years | 5+ years | "Data Analyst" at Capgemini (Jun 2025 – Present) and Siemens (Apr 2019 - Aug 2023). The title is a direct match. | 15/15 |
| Primary Role-Based Skills | |||||
| Advanced SQL (CTEs, Window Functions, Joins) | Not explicitly claimed in summary, but demonstrated in experience. | 5+ years | "Spearheaded optimization of large-scale SQL queries using CTEs, window functions, and indexing strategies...decreasing data processing time by 32%." (Capgemini) | 20/20 | |
| Data Analysis & Validation (Large Datasets) | Not explicitly claimed in summary, but demonstrated in experience. | 5+ years | "Audited and analyzed 10M+ equipment and inventory records using SQL and Python" (Siemens). "Designed SQL checks to flag missing or inconsistent data" (Siemens). | 20/20 | |
| Root-Cause Analysis & Data Discrepancy Resolution | Not explicitly claimed in summary, but demonstrated in experience. | 5+ years | "Performed Root Cause Analysis (RCA) on production bottlenecks using Python...identifying a calibration error...that increased throughput by 5%" (Capgemini). | 20/20 | |
| MES / Operational Data Analysis | Not explicitly claimed in summary, but demonstrated in experience. | 5+ years | "Orchestrated end-to-end ETL pipelines...to extract production data from MES, ERP, and sensor systems into Snowflake" (Capgemini). "Managed large-scale operational and performance data...across five global manufacturing plants" (Siemens). | 20/20 | |
| Secondary Skills | |||||
| Python for Data Analysis | Not explicitly claimed in summary, but demonstrated in experience. | 5+ years | "Developed a Python/SQL-based predictive stock-out model" (Capgemini). "Applied advanced time-series trend analysis" (Capgemini). | 10/10 | |
| Data Quality Improvement Initiatives | Not explicitly claimed in summary, but demonstrated in experience. | 5+ years | "Designed SQL checks to flag missing or inconsistent data, which improved trust in dashboards" (Siemens). "Conducted validation checks for schema mismatches, missing values, and outliers" (UMass). | 10/10 | |
| Stakeholder Collaboration | Not explicitly claimed in summary, but demonstrated in experience. | 5+ years | "Coordinated with operations, engineering, and supply chain stakeholders to align KPI definitions" (Siemens). | 10/10 | |
| Tools & Platforms | |||||
| SQL (PostgreSQL, MySQL) | Not explicitly claimed in summary, but demonstrated in experience. | 5+ years | "Spearheaded optimization of large-scale SQL queries...in PostgreSQL and Snowflake" (Capgemini). Skills section lists "SQL (PostgreSQL, MySQL)". | 10/10 | |
| Power BI | Not explicitly claimed in summary, but demonstrated in experience. | 5+ years | "Built and deployed Power BI dashboards to track real-time inventory levels and equipment health" (Capgemini). "Built Power BI dashboards to track downtime...across 5 plants" (Siemens). | 10/10 | |
| Snowflake | Not explicitly claimed in summary, but demonstrated in experience. | 5+ years | "Orchestrated end-to-end ETL pipelines...into Snowflake" (Capgemini). "Spearheaded optimization of large-scale SQL queries...in...Snowflake" (Capgemini). | 10/10 | |
| Certifications | Not specified in JD. | ||||
| SnowPro Core Certification | N/A | N/A | Listed under "Certifications & Achievements". | 5/5 | |
| Experience Level | Not explicitly stated, but implies mid-level (3-5+ years). | 5+ years | 5+ years | "Data Analyst with 5+ years of progressive experience" (Summary). Roles at Siemens (4+ years) and Capgemini (current). | 10/10 |
| Domain Expertise | Electronics or Semiconductor Manufacturing | 5+ years | 5+ years | "Managed the end-to-end data lifecycle for electric vehicle (EV) production lines" (Capgemini/Rivian). "Managed large-scale operational and performance data...across five global manufacturing plants" (Siemens). | 10/10 |
| Consistency Across Summary, Experience, and Education | N/A | N/A | N/A | High consistency. The summary accurately reflects the experience in manufacturing analytics, SQL, and BI. The education (MS in Data Science, BE in Electronics & Telecomm) supports the technical and domain background. | 10/10 |