# Ayushi Mamgain

Ayushi Mamgain is a remote worker on Himalayas, Legal Analyst at Elevate Legal Services, based in India.

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

```text
Operations Analyst specializing in KPI reporting, process improvement, and data-driven decision-making.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | India |
| Authorized to work in | India |
| Job categories | Operations Analyst, E Commerce Operations, Legal Analyst, Legal Associate, Operational Analyst, Business Operations Analyst, Senior Operations Analyst, Lead Operations Analyst, Junior Operations Analyst |
| Skills | Pivot Tables, Power Query, Google Sheets, SQL, Power BI, Python, Tableau, KPI Tracking, Delivery Time Monitoring, Process Improvement, Cross Functional Collaboration, Stakeholder Management, GitHub, Pandas, Dashboarding, Excel |

## What I'm looking for

```text
I’m looking for a fast-paced role where I can drive KPI reporting and operational dashboards, identify bottlenecks with data analysis, and improve delivery SLAs through cross-functional collaboration. Immediate joining and continuous process improvement matter to me.
```

## About

```text
I’m an Operations Analyst with 4+ years of experience in operational data analysis, KPI reporting, process improvement, and cross-functional stakeholder coordination. I turn messy operational inputs into clear, decision-ready performance reporting that leaders can trust.

In my recent role, I built and maintained operational reporting dashboards in Excel and Google Sheets to track real-time KPI metrics, delivering daily, weekly, and monthly seller-style performance reports with 99%+ accuracy. I also identify operational bottlenecks through analysis and work with operations, finance, and legal teams to improve delivery SLAs.

I validate and clean data across multiple stakeholder sources using SQL and Excel, ensuring accurate, reliable datasets for senior leadership decision-making. I’m comfortable managing multiple concurrent workstreams in fast-paced environments where precision and speed both matter.

Previously, as a Legal Analyst and Legal Associate, I analyzed large legal datasets to identify trends and inefficiencies and delivered structured insight reports to senior stakeholders. I’ve also strengthened my analytical impact through projects like an E-Commerce Sales Operations Dashboard and a Credit Card Transaction & Fulfillment Analysis dashboard—built to surface bottlenecks, SLA gaps, and performance patterns.
```

## Experience

### Legal Analyst

Elevate Legal Services. Jan 2024 - Feb 2025

```text
Built and maintained Excel/Google Sheets operational reporting dashboards for real-time KPI tracking, delivering daily/weekly/monthly seller-style performance reports with 99%+ accuracy. Analyzed workflow bottlenecks using SQL and coordinated with operations, finance, and legal teams to implement process improvements and improve delivery SLAs.
```

Skills: Google-Sheets, KPI-Tracking, SQL, Process-Improvement, Cross-Functional-Collaboration, Dashboarding, Excel

### Legal Associate

Chambers of Satish Aggarwala. Sep 2021 - Dec 2023

```text
Analyzed operational data from large legal datasets to identify trends and process inefficiencies, delivering structured insight reports to senior stakeholders. Managed multiple concurrent workstreams and stakeholders, including representing ICICI Bank in Court Receiver proceedings using high-stakes analytical judgement.
```

Skills: SQL, Excel, Trend-Analysis, Stakeholder-Management, Process-Improvement, High-Stakes-Analytical-Judgement

## Education

### Udemy

Certification, Business Analysis

```text
Completed The Complete Business Analysis Fundamentals on Udemy (Mar 2026).
```

### Udemy

Certification, SQL

```text
Completed the Complete SQL Training & Certification on Udemy (Mar 2026).
```

### Delhi Metropolitan Education

BBA LL.B (Hons.), Law and Business Administration. 2017 - 2022

```text
Completed the BBA LL.B (Hons.) program at Delhi Metropolitan Education in Noida from 2017 to 2022.
```

## Tech stack

- GitHub
- Pandas
- Gmail
- Google Sheets
- SQL
- Jan

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

## People also viewed

- [Meenakshi Ramu](https://himalayas.app/@meenakshiramu): Operations Analyst, BankBazaar
- [Praveen Pallem](https://himalayas.app/@praveenpallem): Machine Learning Data Associate, Amazon Development Centre (India) Pvt. Ltd.
- [Saurabh Sarkar](https://himalayas.app/@saurabhsarkar): Process Analyst, Patra Corporation
- [Amit k Panjwani](https://himalayas.app/@amitkpanjwani): Operations & Service Manager, Bajaj Finance Ltd
- [Surya Prakash](https://himalayas.app/@suryaprakash7): Associate Analyst, ICICI Bank
- [Nikitha m](https://himalayas.app/@nikitham): Data Analyst Intern, AI Variant
- [Karthik A](https://himalayas.app/@karthika2): Associate Operations, Amazon
- [neelesh singh](https://himalayas.app/@neeleshsingh): Jr. Data Analyst, Uroneel India Private Limited
- [Samiul Hoda](https://himalayas.app/@samiulhoda): Data Analytics, Hands on Projects
- [swapnil singh](https://himalayas.app/@swapnilsingh4): Operation Executive, Lawyered
