NICKY DABAS

Data Analyst | BI & Reporting Analyst

About

Highly analytical Data Analyst with 1+ year of experience in developing robust reporting dashboards and optimizing complex SQL queries across large-scale datasets, specifically within higher education admission systems. Proven expertise in data validation, KPI reporting, and ETL analysis, leveraging tools like Apache Superset, ClickHouse, and Python to drive data-driven decision-making. Adept at translating business requirements into actionable insights and reports, enhancing operational efficiency and stakeholder communication.

Work

Samarth eGov Foundation

|

Junior Software Developer

India

→

Summary

Led the development and maintenance of analytical dashboards and optimized SQL queries, ensuring data integrity and delivering critical business insights for higher education admission systems.

Highlights

Developed and maintained a suite of analytical dashboards using Apache Superset, enhancing data accessibility and reporting efficiency for higher education stakeholders.

Optimized complex SQL queries in ClickHouse and MySQL, improving data retrieval performance by an estimated 20% for large-scale admission and payment datasets.

Validated and reconciled critical admission, payment, and reporting data across multiple sources, ensuring data accuracy and integrity for over 100,000 records monthly.

Investigated and resolved data quality, ETL, and reporting issues using DataGrip, reducing data discrepancies and improving report reliability by 15%.

Collaborated with cross-functional teams to translate complex business requirements into actionable dashboards, directly supporting strategic decision-making for senior management.

ConsultBae

|

Project Coordinator Intern

India

→

Summary

Supported project execution and stakeholder communication, ensuring timely progress tracking and effective team collaboration for various initiatives.

Highlights

Supported the coordination of multiple projects, meticulously managing documentation and facilitating clear communication between stakeholders and project teams.

Implemented a systematic approach to track project progress, ensuring milestones were met and identifying potential delays proactively.

Collaborated effectively with internal teams to streamline workflows and resolve operational bottlenecks, contributing to a 10% improvement in project delivery efficiency.

Masai School

|

Junior Data Scientist

India

→

Summary

Conducted comprehensive data analysis and developed analytical models to support strategic business decisions, leveraging Python and SQL.

Highlights

Performed in-depth data analysis using Python and SQL, extracting key trends and patterns from large datasets to inform strategic initiatives.

Developed and implemented predictive analytical models, resulting in actionable insights that supported critical business decisions and improved operational forecasting.

Designed and built interactive dashboards to visualize complex data, enabling stakeholders to monitor key performance indicators and track progress effectively.

Education

Maharishi Dayanand University

Rohtak, Haryana, India
→
M.Sc. Computer Science

Skills

Data Analysis & Visualization

Dashboard Development, Data Visualization, KPI Reporting, Reporting Analytics, Business Intelligence, Root Cause Analysis, Data Analysis, Analytical Models.

Databases & Querying

SQL, ClickHouse, MySQL, DataGrip, Data Validation, ETL Analysis, Large Datasets, Query Optimization, Data Reconciliation.

Programming & Tools

Python (Pandas), Excel, Power BI, Apache Superset, Git, GitLab, Docker, Machine Learning.

Projects

Admissions Analytics Dashboards

Summary

Developed reporting dashboards, optimized SQL queries, and validated large-scale admission datasets.

Employee Attrition Prediction

Summary

Built a predictive model using Python, SQL, and Machine Learning; presented findings via an Excel dashboard.

Superstore Sales Dashboard

Summary

Built an interactive sales performance dashboard using Power BI and Power Query.