# Ajay Kumar Yadav

Ajay Kumar Yadav is a remote worker on Himalayas, MIS Executive at Alstonia LLP, based in India.

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

```text
MIS Executive at Alstonia LLP, building SQL reports that give leadership real-time visibility into operational metrics.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 5541k+ INR |
| Job categories | MIS Analyst, Data Analyst |
| Skills | MIS Reporting, SQL, Excel, Data Analysis, Data Cleaning, data transformation, ETL, ELT, Data Validation, Dashboarding, Python, Pandas, NumPy, Power Pivot, Power Query |

## About

```text
At Alstonia LLP, I maintain daily recurring MIS reports that give leadership real-time visibility into operational metrics. I also analyze datasets to inform cost and performance tracking.

I designed SQL queries using joins, CTEs, and subqueries to extract and transform datasets exceeding 10,000 rows, and maintain workflow documentation to support internal audits.

Earlier at Alstonia LLP, I generated daily and weekly operational dashboards, including IncidentAgeing, Morning Operations (MOD), and SLA compliance reports. I also managed support tickets using BMC Helix ITSM and monitored and escalated high-priority technical issues.

On my BMW Sales Data Analysis project, I used Python and SQL to analyze 14 years of global sales trends, then delivered Excel visual reports highlighting growth patterns and top-performing models. As a Data Analyst Intern at Unified Mentor, I used Pandas and NumPy to clean and transform datasets for business decision-making.
```

## Experience

### MIS Executive (current)

Alstonia LLP. Mar 2024 - Present

```text
Engineered and maintained daily recurring MIS reports with 100% accuracy, providing leadership with real-time visibility into operational metrics. Analyzed large datasets to provide actionable insights for management regarding cost and performance tracking.
```

Skills: MIS-Reporting, SQL, Data-Analysis, Data-Visualization, Cross-Functional-Collaboration, Documentation

### Data Analyst Intern

Unified Mentor. Jun 2024 - Oct 2024

```text
Applied Python (Pandas, NumPy) to clean and transform datasets, extracting insights for business decision-making.
```

Skills: Python, Pandas, NumPy, Data-Cleaning, data-transformation

### Technical Engineer L1

Alstonia LLP. Jun 2023 - Mar 2024

```text
Generated daily and weekly operational dashboards for senior management, including Incident Ageing, Morning Operations, and SLA compliance reports. Monitored and escalated high-priority technical issues, coordinating rapid response efforts to ensure swift resolution and minimal system downtime.
```

Skills: Reporting, Dashboarding, Incident-Management, SLA-Compliance, BMC-Helix-ITSM, Workflow-Optimization

## Education

### IBM Cognitive Class

SQL and Relational Databases, SQL and Relational Databases

```text
Completed a certification in SQL and Relational Databases in March 2025.
```

### Unified Mentor

Data Analyst Intern, Data Analysis

```text
Completed a Data Analyst Internship in September 2024.
```

### Dr. APJ Abdul Kalam Technical University

Bachelor of Technology, Mechanical Engineering

```text
Pursued a Bachelor of Technology in Mechanical Engineering, graduating in 2019.
```

## Tech stack

- NumPy
- Pandas
- Python
- SQL
- BMC Helix ITSM

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

## People also viewed

- [Kishor Kornule](https://himalayas.app/@kishorkornule): Project Associate I, CSIR – National Aerospace Laboratories (CSIR NAL)
- [Reshma Reghunadhan A](https://himalayas.app/@reshmareghunadhana): Junior Data Analyst, NavaltGreen Mobility Pvt Ltd
- [Laraib Khan](https://himalayas.app/@laraibkhan1): MIS Analyst, Discovery Data Center Solutions
- [Naina Sharma](https://himalayas.app/@nainasharma4): AI / LLM Intern, Ethera AI
- [SYED YASIR ALI](https://himalayas.app/@syedyasirali): HR Officer Intern, Aashman Foundation
- [Kunal Gupta](https://himalayas.app/@kunalgupta4): Data Analytics Intern, IIPSCI
- [Mani kandan](https://himalayas.app/@manikandan9): Data Analyst, Emerson
- [Shubham Moundekar](https://himalayas.app/@shubhammoundekar): MIS Executive, Timber Trunk
- [Junaid Mohammed](https://himalayas.app/@junaidmohammed): Process Specialist, Cognizant
- [Farhan Qureshi](https://himalayas.app/@farhanqureshi3): MIS Analyst Intern, KultureHire
