Nikita Nainwal

Built and automated an internal task allocation system using Google Apps Script, streamlining coordination and automating email workflows across departments. Developed and automated Power BI dashboards for sales performance tracking (Target vs Achievement) and other key business metrics. Optimizing SQL queries in Metabase to support team data requirements and ensure reliable reporting. Conducting sales data analysis using Python (Pandas, NumPy) to generate detailed reports and uncover actionable insights. Implemented automation workflows to minimize manual effort and enhance data accessibility for business users.

Analyzed and managed data related to MTF, T+7, LAS, brokerage transactions, and interest rates to support strategic decision-making in the firm. Used Python scripts to automate risk assessment tasks and daily reports, reducing manual workload by 80%. Created interactive reports and dashboards using Advanced Excel and Power BI.

Spearheaded the geo-taxonomization of over 5,000 data points, achieving an impressive precision rate of 98.5% at 99 Acres. Conducted thorough data quality checks using both manual validation and Python automation scripts. Built interactive dashboards and trackers in order to monitor project progress and ensure stakeholder alignment.

Worked with 75+ datasets from UDISE, India’s national Education Database, covering key indicators like enrollment, infrastructure, and teacher data. Built a Python-based ETL pipeline to automate data extraction and transformation. Streamlined data workflows, improved accuracy, and accelerated delivery of insights for education policy and planning.