Pulkit Chandna

Data Analyst - SARVATECH - London

(2025-02 - 2025-08)

Integrated and consolidated datasets from multiple sources (databases, spreadsheets, APIs), performing ETL and validation to ensure data accuracy and completeness.
Engineered and maintained interactive Power BI dashboards and paginated reports to monitor KPIs, enabling senior stakeholders to track performance and make data-driven decisions.
Composed and optimised SQL queries to extract and reshape data for reporting and exploratory analysis, improving efficiency.
Conducted exploratory data analysis (EDA) and data quality checks to identify trends, anomalies, and actionable insights; presented findings to both technical and non-technical audiences.
Facilitated early-stage machine learning experiments and feature engineering work, contributing to model evaluation and documentation of analytical processes and data governance.

Data Analyst - Nextgen / Nemo Technology - Chandigarh, India

(2023-08 - 2025-01)

Analysed large datasets using SQL, Excel, and Python (Pandas, NumPy), performing EDA to identify trends, anomalies, and actionable business insights.
Designed, built, and maintained interactive Power BI and Tableau dashboards to track KPIs and support data-driven decision-making for stakeholders, extracting and analysing data using SQL and Snowflake.
Developed and optimised ETL/ELT pipelines integrating data from Snowflake and multiple sources (databases, spreadsheets, APIs), ensuring reliable data ingestion and transformation.
Performed data cleaning, validation, and quality assurance; implemented data quality checks and documentation to maintain consistency across reporting systems, identifying key revenue drivers (top 20% products generating ~60% revenue).
Automated reporting workflows using Python and Excel, and managed code/version control with Git, reducing manual effort and improving report refresh frequency.
Collaborated with cross-functional teams to gather requirements, translate business needs into analytical solutions, and present clear recommendations to technical and non-technical audiences.

About