RC
RIYA CHADDHA
MES Data Analyst
No profile blueprint available for this candidate.
Job Compatibility Score
MES Data Analyst
38%Here is the completed Candidate Evaluation Table for Riya Chaddha, based on the provided Job Description and Resume.
Total Score: 38 / 75
Key Insights:
- Strong Data Foundation: Riya has excellent hands-on experience with SQL, ETL pipelines, and cloud platforms (Azure, GCP, Snowflake). Her technical skills are solid and well-documented.
- Domain Mismatch: The primary gap is the lack of experience in electronics or semiconductor manufacturing and MES systems. Her entire career is in insurance, biotech, and academic projects. This is a significant miss for a role that explicitly requires this domain.
- Title Alignment: Her current and recent titles ("Data Analyst," "Data Engineer") are a good match for the role's focus on data analysis and validation.
- SQL Proficiency: She clearly demonstrates advanced SQL skills (complex joins, window functions, CTEs) in her resume, which directly aligns with the JD's primary requirement.
- Overall Fit: She is a strong technical candidate for a data role, but the lack of domain-specific experience (MES, semiconductor) makes her a moderate-to-low fit for this specific position. She would likely need significant ramp-up time to understand the operational context.
📊 Candidate Evaluation Table: Riya Chaddha
| Category | Details from Job Description | Claimed Experience | Relevant Experience | Evidence from Resume | Score |
|---|---|---|---|---|---|
| Job Titles | Data Analyst / Data Engineer (working with MES and operational data) | 5+ years as a Data Analyst | 2.5 years as a Data Engineer, ~1 year as a Data Analyst | "Data Analyst" at MelliCell (Mar 2025 - Present); "Data Engineer" at L&T Infotech (Jan 2021 - Jun 2023) | 10/15 |
| Primary Role-Based Skills | Advanced SQL (complex joins, CTEs, window functions, aggregations) | 5+ years | 2.5 years of heavy, production-level SQL usage | "Wrote complex SQL queries (joins, aggregations, subqueries, window functions) to verify data integrity" at L&T Infotech; "Performed large-scale data transformation and validation using SQL" at MelliCell | 18/20 |
| Data Validation & Quality Checks | 5+ years | 2.5 years | "Implemented Python-based QC data validation and anomaly detection workflows" at MelliCell; "Executed data validation across UI, SQL Server, Snowflake" at L&T Infotech | ||
| Root-Cause Analysis for Data Discrepancies | Not explicitly claimed | 2.5 years | "Proactively identifying inconsistencies in imaging and metadata" at MelliCell; "Managed defect lifecycle... with detailed evidence" at L&T Infotech | ||
| Large Dataset Analysis (Trends & Issues) | 5+ years | 2.5 years | "Analyze large datasets to identify issues, trends" is implied by her work building dashboards for "loss ratios, claims lifecycle, premium trends" at L&T Infotech | ||
| Secondary Skills | ETL Pipeline Development | 5+ years | 2.5 years | "Built and maintained 20+ production-grade ETL pipelines using Azure Data Factory and Databricks" at L&T Infotech | 6/10 |
| Data Warehousing / Dimensional Modeling | 5+ years | 2.5 years | "Developed scalable transformation workflows... to standardize and model insurance datasets into dimensional warehouse schemas" at L&T Infotech | ||
| Python for Data Analysis | 5+ years | 1+ year | "Performed data analysis using Python (NumPy, Pandas, Scikit-learn)" at MelliCell | ||
| Collaboration with Stakeholders | 5+ years | 2.5 years | "Partnered with cross-functional teams to deliver 15+ Power BI dashboards" at L&T Infotech; "Collaborated with research stakeholders" at MelliCell | ||
| Tools & Platforms | MES Systems | Not mentioned | Not mentioned | No evidence found in resume. | 0/10 |
| SQL (T-SQL, MySQL) | 5+ years | 2.5 years | "SQL (T-SQL, MySQL)" listed in Skills; heavy usage at L&T Infotech and MelliCell | ||
| Cloud Platforms (Azure, GCP) | 5+ years | 2.5 years | "Microsoft Azure, Google Cloud Platform (GCS, BigQuery)" listed in Skills; used at L&T Infotech (Azure) and MelliCell (GCP) | ||
| Snowflake | 5+ years | 2.5 years | "Snowflake" listed in Skills; used as target for ETL pipelines at L&T Infotech | ||
| Certifications | Not specified in JD | N/A | N/A | Holds "AWS Certified Data Engineer – Associate" and "Big Data Practices with PySpark and Spark Tuning" | 3/5 |
| Experience Level | Mid-level (implied by responsibilities) | 5+ years | 2.5 years of direct data engineering/analysis | Roles: Data Analyst (MelliCell), Data Engineer (L&T Infotech). Total professional experience is ~4.5 years post-graduation. | 5/10 |
| Domain Expertise | Electronics or Semiconductor Manufacturing | Not mentioned | 0 years | Entire professional experience is in Insurance (L&T Infotech) and Biotech (MelliCell). No mention of semiconductor or electronics. | 0/10 |
| Consistency Across Summary, Experience, and Education | N/A | N/A | N/A | Summary claims "5+ years" which aligns with her timeline. Skills listed are consistently demonstrated in experience. Education (MS in Info Systems) supports the technical profile. | 5/5 |