# Deepika Bajaj

Deepika Bajaj is a remote worker on Himalayas, MIS Executive at KollegeApply, based in India.

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

```text
Data Analyst focused on turning messy data into decision-ready dashboards using SQL, Python, and Power BI.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | India |
| Authorized to work in | India |
| Job categories | Data Analyst, Data Visualization Analyst, Data Analyst, MIS Executive, Business Intelligence Analyst, Reporting Analyst, Associate Data Analyst, Data Analytics Specialist |
| Skills | Data Analysis, data transformation, Data Cleaning, Data Wrangling, Data Validation, Web Scraping, KPI Tracking, Power BI, DAX, Data Modeling, Pivot Tables, XLOOKUP, Power Query, Google Sheets, SQL, SQL Joins, Subqueries, Window Functions, Data Extraction, Python, Pandas, NumPy, Matplotlib, SeaBorn, Data Visualization, Dashboard Design, Content Management Systems, PE Stakeholder Reporting, JavaScript, HTML, CSS, Fuzzy Matching, ChatGpt, Claude, Perplexity, Google Antigravity, MySQL |

## What I'm looking for

```text
I’m looking for a Data Analyst role where I can automate data cleaning, build reliable SQL/Python pipelines, and deliver clear Power BI dashboards—collaborating with non-technical stakeholders and using AI to iterate faster.
```

## About

```text
I’m a results-driven Data Analyst who works end-to-end across the data lifecycle—collection, wrangling, analysis, and reporting. I take raw, unstructured inputs and translate them into clear, actionable insights for non-technical stakeholders.

In my current role as a MIS Executive, I scrape and consolidate college data from 200+ university websites using Python-based web scraping and structured extraction. I write SQL queries to extract, join, and cross-verify records against sources, ensuring data integrity before publishing.

I also build automation to reduce manual effort and improve accuracy—using Python (Pandas) scripts for deduplication and repetitive cleaning, and standardizing 50,000+ records in Google Sheets with validation logic to minimize entry errors. For operational visibility, I develop Excel tracking sheets with conditional logic to flag missing or inconsistent fields, accelerating reporting with AI tools.

My project work reflects the same focus on data quality and business impact: I built a fuzzy-matching solution to normalize 500+ non-uniform course names, reducing duplicate records by 60% and manual lookup time by 70%. I’ve delivered Power BI reporting from consolidated datasets (including an example tracking $1.2M in total sales) and used query tuning to lower report load time by 30%, with insights adopted by stakeholders such as marketing.
```

## Experience

### MIS Executive (current)

KollegeApply. Dec 2025 - Present

```text
Scraped, consolidated, and standardized college data from 200+ university websites, ensuring accurate, up-to-date records for publication. Automated data cleaning and deduplication workflows and used SQL/Python and Google Sheets to validate and maintain data integrity.
```

Skills: Reporting, Data-Modeling, Web-Scraping, Python, Pandas, SQL, Data-Cleaning, Data-Wrangling, Deduplication, Data-Validation, Google-Sheets, Excel, Data-Integrity, CMS-Publishing, Data-Consolidation, AI-Tools, ChatGpt, Claude, Perplexity

## Education

### Croma Campus

Data Analytics (NASSCOM Certified), Data Analytics

```text
Earned a Data Analytics certification (NASSCOM Certified) from Croma Campus.
```

### J.C. Bose University of Science & Technology

B.Tech, Computer Science and Engineering. 2020 - 2024

```text
Completed a B.Tech in Computer Science and Engineering with an AI & ML specialization from J.C. Bose University of Science & Technology (Faridabad).
```

### J.C. Bose University of Science & Technology

Bachelor of Technology (B.Tech), Computer Science and Engineering (AI & ML). 2020 - 2024

```text
B.Tech in Computer Science and Engineering with an AI & ML specialization at J.C. Bose University of Science & Technology from 2020 to 2024.
```

### NPTEL

Soft Skills, Soft Skills

```text
Completed a Soft Skills certification through NPTEL.
```

## Tech stack

- NumPy
- Pandas
- MySQL
- JavaScript
- Google Sheets
- SQL
- Google Antigravity
- ChatGPT
- Seaborn

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

## People also viewed

- [chaitanya lakshmi](https://himalayas.app/@chaitanyalakshmi): Data Analyst Intern, Self Employed
- [Mithil Gundeti](https://himalayas.app/@mithilgundeti): Customer Data Quality Validation, Personal Project
- [Shagun Singh](https://himalayas.app/@shagunsingh2): Data Analyst, Trailytics AI
- [Gurjinder Singh](https://himalayas.app/@gurjindersingh): Data Analyst, Galaxy Data Solutions Pvt. Ltd.
- [Swati Shinde](https://himalayas.app/@swatishinde1): Data Analyst, Self Employed
- [Mohammad Maaz](https://himalayas.app/@mohammadmaaz1): Data Analyst, Self Employed
- [Rahul Singh](https://himalayas.app/@rahulsingh38): Data Analyst, CMOTS
- [Shivanjan Gajjela](https://himalayas.app/@shivanjangajjela): Data Analyst, Self Employed
- [Balagondla Prasad](https://himalayas.app/@balagondlaprasad): Data Analyst, Self Employed
- [Praveen K](https://himalayas.app/@Praveenk2): Data Analyst, Sapiens Research and Analysis
