# Aanushka Chauhan

Aanushka Chauhan is a remote worker on Himalayas, Business Analyst Intern at Shadow Infosystem Pvt Ltd, based in India.

Source: https://himalayas.app/@aanushkachauhan

```text
I turn operational data into clear dashboards, KPI insights, and process improvements using SQL, Python, and Power BI.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 70k+ INR |
| Job categories | Data Analyst, Business Analyst, Operations Analyst, Business Intelligence Analyst |
| Skills | SQL, SQL Joins, Common Table Expressions (CTEs), Window Functions, data transformation, BigQuery, Google Cloud Platform, Data Modeling, Python, Pandas, NumPy, Process Automation, Git, GitHub, ETL, Power BI, DAX, Power Query, Dashboard Development, Looker, Excel, Pivot Tables, Advanced Formulas, Customer Service Analytics, Journey Performance, KPI Monitoring, Data Quality Auditing, Root Cause Analysis, Exploratory Data Analysis, predictive modeling |
| Portfolio | https://github.com/mistyy-og |
| LinkedIn | https://linkedin.com/in/aanushka-chauhan-433663224 |
| GitHub | https://github.com/mistyy-og |

## What I'm looking for

```text
I'm looking for an analytics role where I can use SQL, Python, Power BI, and Excel to improve reporting, monitor KPIs, uncover operational bottlenecks, and support data-driven business decisions.
```

## About

```text
I'm building practical analytics solutions that turn operational data into reporting, dashboards, and actionable insights. My work spans SQL, Python, Power BI, BigQuery, and Excel.

At Shadow Infosystem, I developed SQL queries with CTEs, window functions, and complex joins to transform operational data for business-performance reporting. I also ran data-quality checks, investigated discrepancies, and analyzed customer touchpoints and workflows to identify delivery bottlenecks.

At BharatPe, I evaluated more than 100 candidate profiles and modeled recruitment-funnel metrics in Excel to improve sourcing workflows. I also supported employee-retention analysis against business KPIs to refine talent acquisition and onboarding procedures.

Through projects in call-centre operations, workforce capacity, and hospital readmissions, I've built relational data models, automated cleaning and feature engineering, and created Power BI dashboards for operational and clinical KPIs. I've also applied Python for data cleaning, exploratory analysis, and predictive modeling in BCG's Data Science Job Simulation.
```

## Experience

### Business Analyst Intern

Shadow Infosystem Pvt Ltd. May 2023 - Jun 2023

```text
Developed SQL queries using CTEs, window functions, and complex joins to transform and analyze operational data. Conducted data-quality checks and root-cause analysis to improve reporting reliability.
```

Skills: SQL, CTEs, Window-Functions, Data-Quality, Root-Cause-Analysis, Data-Modeling, Self-Service-Reporting

### HR Support & Analytics Intern

[BharatPe](https://himalayas.app/companies/bharatpe). Aug 2021 - Nov 2021

```text
Evaluated 100+ candidate profiles and modeled recruitment funnel metrics using MS Excel to streamline sourcing workflows. Supported analysis of employee retention data against business KPIs.
```

Skills: Excel, Recruitment-Analytics, Data-Analysis, KPI-Monitoring

## Education

### E&ICT Academy, IIT Roorkee

Data Analytics with AI & Gen AI Program, Data Analytics

```text
Pursuing a Data Analytics with AI & Gen AI program.
```

### NMIMS University

Master of Business Administration, Business Analytics

```text
Pursuing an MBA in Business Analytics.
```

### Bharati College, University of Delhi

Bachelor of Commerce, Commerce. 2020 - 2023

```text
Completed Bachelor of Commerce from Bharati College, University of Delhi from 2020 to 2023.
```

### Google

Google Data Analytics Professional Certificate, Data Analytics

```text
Earned the Google Data Analytics Professional Certificate.
```

### IBM

IBM Advanced Excel Certification, Excel

```text
Earned the IBM Advanced Excel Certification.
```

## Tech stack

- Looker
- Google Cloud Platform
- GitHub
- NumPy
- Pandas
- Python
- Microsoft Excel
- Git
- SQL
- Power BI

To contact Aanushka, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Sumit Kumar](https://himalayas.app/@sumitkumar24): Data Analyst Intern, Self Directed Projects
- [Shagun Sharma](https://himalayas.app/@shagunsharma4): Data Analytics Project Lead, Personal Portfolio Projects
- [Pushkar Suryavanshi](https://himalayas.app/@pushkarsuryavanshi): Business Analyst Intern, AI Variant
- [Upeksha Arya](https://himalayas.app/@upekshaarya): User Engagement & Marketing Analysis, Meta
- [Praveen Kumar](https://himalayas.app/@praveenkumar38): Jr Business Intelligence Analyst, Pulp Strategy
- [Chinnolla Sri Ram Goud](https://himalayas.app/@chinnollasriramgoud): Data Analyst Intern, Dataview Analytics
- [Abhishek Kumar](https://himalayas.app/@abhishekkumar105): Operations Associate, Blinkit
- [Chaitanya User](https://himalayas.app/@chaitanyauser8): Data Analyst Intern, Analytics Space
- [Mohan K](https://himalayas.app/@mohank1): Business Analyst, Advanced Datawork
- [Saami Anware](https://himalayas.app/@saamianware): Data Analyst Intern, Intrepedians
