Kalash Negi

Data Analyst with 3+ years of experience leveraging SQL, Python, Power BI, Excel, and Machine Learning to drive business decisions. Skilled in complex SQL querying, interactive dashboarding, automated ETL pipelines, EDA with Pandas/NumPy, and spatial/predictive data analytics.

Data Analyst - AeonX Digital - Dehradun, India

(2025-01)

• Query multi-cloud databases (Google BigQuery, PostgreSQL, MySQL) using SQL to aggregate key business metrics.
• Build and publish Power BI dashboards featuring star schema data models, DAX measures, and automated refreshes.
• Conduct exploratory data analysis (EDA) using Python (Pandas, NumPy) to identify operational trends and anomalies.
• Build dynamic Excel reports utilizing pivot tables, Power Query, and advanced lookup functions.
• Enforce Row-Level Security (RLS) and workspace governance to ensure strict data security and compliance.
• Optimize query execution and report loading times using database indexing and Performance Analyzer tuning.

Data Analytics Intern - Brillica Services - Dehradun, India

(2024-07 - 2024-12)

• Trained ML models (Regression, Classification) in Python (Scikit-learn) for trend prediction and pattern analysis.
• Wrote complex SQL scripts to extract and process multi-table relational data.
• Built visual reports in Power BI and Tableau, integrating heterogeneous datasets for tracking business KPIs.

Data Analyst - Survey of India (SOI) - Dehradun, India

(2023-01 - 2023-12)

• Processed large-scale public datasets, establishing automated validation checks using Python and Excel for data integrity.
• Built structured visual reports and analytical dashboards to assist key stakeholders in spatial mapping decisions.

Master of Computer Application - MCA - Graphic Era University (2023)

Bachelor of Computer Application - BCA - Uttaranchal University (2020)