# Shashank Bajpai

Shashank Bajpai is a remote worker on Himalayas, MIS Executive at eBotics Solutions LLP, based in India.

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

```text
Data Analyst at eBotics Solutions who built an AR dashboard used in client presentations and automated five hours of daily reconciliation.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Job categories | Data Analyst, MIS Executive, Executive Logistics, Business Analyst |
| Skills | Data Analysis, Dashboard Design, Power BI, DAX, Data Modeling, SQL, Power Query, Excel, VBA, Data Visualization, KPI Reporting, SLA Reporting, TAT Reporting, Trend Analysis, Data Validation |
| Portfolio | https://github.com/Shashank552-dotcom |
| LinkedIn | https://linkedin.com/in/shashank-bajpai-53871222a |
| GitHub | https://github.com/Shashank552-dotcom |

## About

```text
At eBotics Solutions LLP, I built an AR management dashboard that links inventory, payment, and production files, and refreshes about every minute. The Director of Operations uses it in presentations to existing clients, and the AR team uses the application for daily tracking.

I also built 20+ VBA tools and automated daily reconciliation reports across 18 practices, saving about five hours of manual work a day. At Livpure Smart, I built 15+ Power BI dashboards that became standard reporting for a 17-warehouse network.

My work also includes a route-optimisation tool that cut pincode route lookup from 2–3 days to about 25 minutes, and a personal DataCo Supply Chain Dashboard modelling 180K+ transactions. I work with Power BI, SQL, Excel, and VBA across healthcare revenue cycle and logistics reporting.
```

## Experience

### MIS Executive (current)

eBotics Solutions LLP. Jun 2026 - Present

```text
Built the AR management dashboard in Power BI and within the AR application, linking inventory, payment, and production files. Automated daily reconciliation reports across 18 practices, saving about 5 hours of manual work daily.
```

Skills: Power-BI, DAX, SQL, Excel, VBA, HTML, SQL-Express, Data-Modeling, Dashboard-Design, Requirements-Gathering

### Logistics Executive

Livpure Smart. Nov 2025 - May 2026

```text
Built 15+ Power BI dashboards for a 17-warehouse network, becoming the standard reporting. Designed star-schema models and DAX measures for SLA, TAT, and warehouse KPIs.
```

Skills: Power-BI, DAX, SQL, Excel, Power-Query, Mapbox, Data-Modeling, Dashboard-Design, KPI-Reporting

### Business Analyst Intern

InLighnX Tech Global. Sep 2025 - Feb 2026

```text
Automated 6+ recurring reports in Excel and Google Sheets, cutting preparation time by about 60%.
```

Skills: Excel, Google-Sheets, Automation, Reporting

### Business Analyst Intern

Unified Mentor. Apr 2025 - Jun 2025

```text
Cleaned and analysed 50,000+ records in Excel and SQL and built dashboards for recurring reviews.
```

Skills: Excel, SQL, Data-Cleaning, Data-Analysis, Dashboard-Design

## Education

### Dr. A.P.J. Abdul Kalam Technical University

Bachelor of Technology, Mechanical Engineering. 2022 - Present

```text
Pursuing a Bachelor of Technology in Mechanical Engineering, expected to complete in 2026.
```

### Skill Academy

Certification, Data Analytics. 2025 - 2025

```text
Completed certifications in Power BI & Tableau, SQL for Data Analytics, and Advanced Excel for Business Analytics in 2025.
```

### Board of Technical Education Uttar Pradesh

Diploma, Mechanical Engineering. 2019 - 2022

```text
Completed a Diploma in Mechanical Engineering from 2019 to 2022.
```

## Tech stack

- Tableau
- Google Sheets
- SQL
- Power BI
- Power Query
- HTML

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

## People also viewed

- [Latha Kovvuri](https://himalayas.app/@lathakovvuri): Data Analyst Freelancer, Self Employed
- [Mit Modi](https://himalayas.app/@mitmodi): Junior Data Analyst, Aurita Diamond Pvt. Ltd.
- [Naga Lakshmi](https://himalayas.app/@nagalakshmi2): Data Analyst Trainee, ExcelR Solutions
- [Meenal Talnikar](https://himalayas.app/@meenaltalnikar): Trainee SCCP, Flipkart
- [Vishal Kashyap](https://himalayas.app/@vishalkashyap4): MIS Executive, Brandaholic
- [Abhi M](https://himalayas.app/@abhim1): Data Analyst Intern, Rows and Columns
- [Abhishek Pillai](https://himalayas.app/@abhishekpillai): Data Analyst, Hi Tech Digital Solutions
- [Suraj Suryawanshi](https://himalayas.app/@surajsuryawanshi1): MIS Executive, B.P. Logistics Pvt. Ltd.
- [Gunjan Gupta](https://himalayas.app/@gunjangupta3): Data Operations Assistant, Unknown
- [Sourav Karmakar](https://himalayas.app/@souravkarmakar1): Data Analyst, Committed Cargo Solutions Pvt Ltd
