# Jyoti Gupta

Jyoti Gupta is a remote worker on Himalayas, Independent Analytics Projects at Independent, based in India.

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

```text
Operations analytics professional building workforce insights and self-service reporting with Python, Power BI, and SQL.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 140k+ INR |
| Job categories | Data Analyst, Business Intelligence Analyst, Workforce Management Analyst, Reporting Analyst, Operations Analyst |
| Skills | Business Analytics, Operations and Analytics, Data Analysis, Business Intelligence, Workforce Analytics, Customer Experience Analytics, Management Reporting, Financial Reporting, Performance Dashboards, Report Automation, Statistical Analysis, regression analysis, Exploratory Data Analysis, Root Cause Analysis, Trend Analysis |

## About

```text
At Bank of America, I delivered executive dashboards and financial performance scorecards across strategic clients and global accounts. I also redesigned the SharePoint–Tableau reporting solution, integrating ETL pipelines with the Data Lake and reducing report turnaround time by 83%.

At Aviva Global Services, I analyzed customer feedback and service measures to identify causes of transfer loops and wait times, contributing to a 37% improvement in service quality. I also automated executive reporting and cut manual processing effort by 88%.

At eClerx Services Limited, I automated SQL reconciliation across daily transaction data, reducing trade break resolution times by 40%. I partnered with Risk and Compliance on operational risk reporting and mapped process workflows to improve data validation.

In my current independent analytics projects, I use Python, Power BI, and SQL to explore workforce and business performance. I’ve also built and deployed an interactive Streamlit solution for self-service reporting and business insights.
```

## Experience

### Independent Analytics Projects (current)

Independent. Jan 2026 - Present

```text
Developed end-to-end operations and workforce analytics projects using Python, Power BI, and SQL, covering KPI, trend/variance, forecasting, and capacity analysis. Built and deployed interactive Streamlit analytics solutions for self-service reporting and business insights.
```

Skills: Python, Pandas, NumPy, Matplotlib, Power-BI, SQL, Streamlit, Statistical-Analysis, EDA, Root-Cause-Analysis, scenario-analysis

### Senior Data Analyst WFM

[Lenovo](https://himalayas.app/companies/lenovo). Jul 2025 - Dec 2025

```text
Migrated legacy Tableau reporting to Power BI for tracking sales, margins, agent performance, and customer retention. Performed descriptive analytics on SLA, occupancy, and AHT across global queues, and automated reporting using Python.
```

Skills: Power-BI, Tableau, Python, SQL, Genesys, Powerfront, Notion, Kanban, Capacity-Planning, Workforce-Management, Descriptive-Analytics

### Career Break

Personal. Jan 2024 - Jun 2025

```text
Executed comprehensive EDA projects during career break, strengthening core competency in data analysis, automation, and dynamic dashboard creation.
```

Skills: Data-Analysis, EDA, Automation, Dashboard-Creation

### Assistant Manager MI & Analytics

[Bank of America](https://himalayas.app/companies/bank-of-america). Dec 2021 - Jan 2024

```text
Served as analytics partner to senior leadership, delivering executive dashboards and financial performance scorecards. Led redesign of SharePoint-Tableau reporting with ETL pipelines, reducing report turnaround time by 83%.
```

Skills: SQL, Python, VBA, Tableau, SharePoint, ETL, Data-Lake, Jira, Notion, regression-analysis, Dashboarding, Financial-Reporting

### Assistant Manager MI & Analytics

[Aviva Global Services](https://himalayas.app/companies/aviva). Mar 2019 - Nov 2021

```text
Executed sentiment and factor analysis on customer feedback, improving service quality by 37%. Built executive dashboards and automated reports using SQL and VBA, cutting manual effort by 88%.
```

Skills: SQL, Excel-VBA, Sentiment-Analysis, Factor-Analysis, NPS, CSAT, EmSAT, CES, Root-Cause-Analysis, Dashboarding, Automation

### Senior Automation Developer

[Vodafone Shared Services](https://himalayas.app/companies/vodafone). Nov 2018 - Mar 2019

```text
Designed and deployed VBA-based automation across MS Office and SAP, boosting productivity by 20%. Modernized legacy applications and led UAT strategy sessions.
```

Skills: VBA, Microsoft-Office, SAP, Power-Pivot, MS-Access, ADO, ODBC, UAT, Automation

### Senior Analyst MI

[eClerx Services Limited](https://himalayas.app/companies/eclerx). Jun 2013 - Jan 2017

```text
Designed automated MIS dashboards using Power Query, Power Pivot, and VBA. Engineered SQL reconciliation routines reducing trade break resolution times by 40%.
```

Skills: Power-Query, Power-Pivot, VBA, SQL, Microsoft-Visio, BPMN, UML, SOPs, Data-Validation, Root-Cause-Analysis, Reporting

### Analyst MI & Reporting

Infosys BPM. Jul 2011 - Jun 2013

```text
Extracted data from ERP warehouses using SQL for spend and variance analysis, reducing telecom expenses by 15%. Built automated reporting systems and executive scorecards.
```

Skills: SQL, SAP-BW, ERP, Access, VBA, Automation, Data-Integrity, Six-Sigma, Reporting

## Education

### Six Sigma Society

Lean Six Sigma, Lean Six Sigma

```text
Completed Lean Six Sigma certification in 2026.
```

### Udemy

Statistics For Data Analytics, Statistics

```text
Completed Statistics for Data Analytics certification in 2026.
```

### Google

Maximize Productivity with AI Tools, AI Tools

```text
Completed Maximize Productivity with AI Tools certification in 2026.
```

### IBM

Data Fundamentals, Data

```text
Completed Data Fundamentals certification in 2025.
```

### Bharati Vidyapeeth Women's College of Engineering

Bachelor of Engineering, Information Technology

```text
Bachelor of Engineering in Information Technology from Bharati Vidyapeeth Women's College of Engineering.
```

## Tech stack

- Tableau
- NumPy
- Pandas
- Jira
- Python
- Streamlit
- Notion
- Google Sheets
- Genesys
- SQL
- SAP
- Matplotlib
- Power BI
- BPMN

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

## People also viewed

- [Srinivas Nithyananth](https://himalayas.app/@srinivasnithyananth): Senior Manager BI & Data Analytics, Eversana Intouch
- [Meenakshi Dutta](https://himalayas.app/@meenakshidutta): Project Lead, KG Information Systems (KGiSL)
- [Pulkit Basia](https://himalayas.app/@pulkitbasia): Analytics Manager, Enroute Services
- [RAJESH KUMAR](https://himalayas.app/@rajeshkumar17): Lead Analyst, Hcl Technologies
- [Rakesh Poddar](https://himalayas.app/@rakeshpoddar): Data Analyst, 1DigitalStack.ai
- [Balram Prajapati](https://himalayas.app/@balramprajapati): Manager, BI & Data Solutions, Teleperformance
- [Swarup Sampad](https://himalayas.app/@swarupsampad): Sales Support Analyst – Business Analytics, HP India
- [Kunal Kamble](https://himalayas.app/@kunalkamble): Business Operations Analyst, Accenture Solutions Pvt. Ltd.
- [Chandan Gaur](https://himalayas.app/@chandangaur1): Team Lead – WFM, Tech Mahindra
- [Priyanka Pagare](https://himalayas.app/@priyankapagare): Business Analyst, CBRE
