Back to Developers
Aastha Singhal

Aastha Singhal

Data Analyst

Gurugram 7+ yrs exp 90 ยท Outstanding

About

Data Analyst with 3+ years of experience in Data Analytics and Power BI and 7+ years of overall professional experience. Proficient in SQL, Power BI, DAX, ETL, Data Modeling, and Dashboard Development. Skilled in building interactive reports, KPI dashboards, and business intelligence solutions to support data-driven decision-making.

Skills & Expertise (19)

Power BI Expert
9.0/10
3
Years Exp
Reporting Automation Advanced
8.5/10
3
Years Exp
DAX Advanced
8.5/10
3
Years Exp
Data Visualization Advanced
8.5/10
3
Years Exp
KPI Dashboards Advanced
8.0/10
3
Years Exp
Requirements Gathering Advanced
8.0/10
7
Years Exp
Stakeholder Management Advanced
8.0/10
7
Years Exp
ETL Advanced
8.0/10
7
Years Exp
Data Extraction Advanced
8.0/10
7
Years Exp
Data Validation Advanced
8.0/10
7
Years Exp
Data Transformation Advanced
8.0/10
3
Years Exp
Data Modeling Advanced
8.0/10
3
Years Exp
SQL Server Advanced
8.0/10
7
Years Exp
Power Query Advanced
8.0/10
3
Years Exp
SQL joins Advanced
8.0/10
7
Years Exp
Window Functions Advanced
7.5/10
7
Years Exp
CTEs Advanced
7.5/10
7
Years Exp
MySql Advanced
7.5/10
7
Years Exp
Row-Level Security Advanced
7.0/10
3
Years Exp

Work Experience

Senior Associate

Acuity Knowledge Partners (formerly Cians Analytics)

Dec 2023 - Present

Architected an end-to-end Power BI portfolio analytics dashboard for buy-side clients, delivering interactive insights on performance, risk, and asset allocation. Extracted, cleaned, and transformed multi-source financial data into a scalable, optimized data model. Designed intuitive visualizations to track portfolio trends, sector exposure, top holdings, and benchmark attribution. Automated data pipelines and scheduled refreshes, reducing manual reporting turnaround time by 75%. Engineered advanced DAX measures to calculate complex portfolio returns, risk metrics, and contribution analysis. Collaborated with stakeholders to gather business requirements and deliver customized reporting solutions, improving reporting accuracy and supporting data-driven decision-making.

Associate

Acuity Knowledge Partners (formerly Cians Analytics)

Apr 2021 - Nov 2023

Onboarded and validated multi-source datasets, ensuring accuracy and integrity. Performed data cleaning, preprocessing, and quality checks (missing data, inconsistencies, coverage). Conducted data wrangling and created data dictionaries for better data understanding. Collaborated with vendors and internal teams to resolve data issues and meet client requirements. Performed data analysis and built interactive KPI dashboards using multiple data sources.

Senior Analyst

Acuity Knowledge Partners (formerly Cians Analytics)

Nov 2018 - Mar 2021

Investment & Due Diligence: Executed comprehensive research and due diligence for potential pharmaceutical sector acquisitions and investments. Compiled comprehensive public information books by performing financial handspreads, comparable company, and precedent transaction analyses. Deal Deliverables: Authored core corporate finance materials, including detailed company profiles, buyer/target screening, and screening memos.

Education

Master of Business Administration (Finance) - ICFAI Business School (IBS)

2017 - 2019 ยท Afghanistan

Bachelor of Commerce - Institute of Management Studies

2013 - 2016 ยท Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 15/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 90/100

Profile Overview

Member sinceJul 2026