Skip to main content
Shashank BajpaiSB
Looking for a job

Shashank Bajpai

@shashankbajpai

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

India
Message

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

Work history, roles, and key accomplishments

EL
Current

MIS Executive

eBotics Solutions LLP

Jun 2026 - Present (5 months)

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.

IG

Business Analyst Intern

InLighnX Tech Global

Sep 2025 - Feb 2026 (5 months)

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

UM

Business Analyst Intern

Unified Mentor

Apr 2025 - Jun 2025 (2 months)

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

Education

Degrees, certifications, and relevant coursework

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

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

Bachelor of Technology, Mechanical Engineering

2022 -

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

SA

Skill Academy

Certification, Data Analytics

2025 - 2025

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

BP

Board of Technical Education Uttar Pradesh

Diploma, Mechanical Engineering

2019 - 2022

Completed a Diploma in Mechanical Engineering from 2019 to 2022.

Tech stack

Software and tools used professionally

Interested in hiring Shashank?

You can contact Shashank and 600K+ other talented remote workers on Himalayas.

Message Shashank

People also viewed

View all talent

Get matched with your dream remote job

Sign up now and join over 1,000,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan