Shubham Pareek

Data Analyst with professional experience in SQL-based data validation, report reconciliation, and data-quality analysis across datasets exceeding 100,000 records. Skilled in SQL, Python, Excel, and Power BI, with hands-on projects in e-commerce analytics and AI-driven natural-language-to-SQL reporting. Experienced in validating business metrics, investigating missing or duplicate data, and ensuring reliable data flow across 4+ connected applications.

Data Analyst & QA Engineer - Birla Institute of Scientific Research - Jaipur, Rajasthan

(2025-02 - 2026-05)

Client: Estater Pvt. Ltd.

• Validated and reconciled datasets exceeding 100,000 property and transaction records across 4+ connected applications, ensuring report data matched backend database records.
• Wrote SQL queries using filters, counts, totals, aggregations, and grouping by type, date, and location to identify missing, duplicate, and inconsistent data.
• Performed report reconciliation by verifying totals, calculations, filters, search results, and cross-application data movement for property inventory, rental and pricing, transactions, valuation, and operational reports.
• Reviewed grouped data and report outputs to perform trend analysis and investigate inconsistencies affecting user-facing business information.
• Logged data-quality issues in Azure DevOps, explained findings to developers and product teams, and revalidated database and report outputs after fixes.
• Built a Python and Selenium automation framework covering 500+ test scenarios, reducing repetitive validation work and improving release-cycle coverage.

Bachelor of Technology - Computer Science & Engineering - Sangam University (2021-07 - 2025-05) Bhilwara, Rajasthan