Logistics Operations Optimization
Implemented LP-based optimization to minimize transportation costs and visualized routing strategies using Power BI.
PythonSQLPower BI
Hi, my name is
Rajan Shrestha.
I analyze data to build solutions.
I'm a Data Analyst based in Kathmandu, Nepal. Currently, I'm analyzing complex datasets at Innovate Nepal Group, focusing on operational efficiency and educational business intelligence.
01.
About Me
Hello! My name is Rajan and I enjoy translating raw data into meaningful stories. My journey into data started during my Industrial Engineering degree, where I discovered the power of Operations Research and Statistics.
Fast-forward to today, I am working at Innovate Nepal Group (ING), Nepal's leading investment holding company in education and technology. My work involves leveraging data to optimize operations across the group's ecosystem of colleges and tech ventures.
Here are a few technologies I've been working with recently:
- Python (Pandas)
- SQL (Postgres/MySQL)
- Power BI
- Google Sheets
- Tableau
- Looker Studio
- Excel Solver
- Linear Programming
Skillset
Data Analysis
SQLExcel (Advanced)Google SheetsData Cleaning
Programming
PythonPandasApps ScriptMatplotlib
Visualization
Power BILooker StudioTableauExcel Dashboards
02.
Where I've Worked
Jan 2026 - Present Kathmandu, Nepal
Data Analyst @ Innovate Nepal Group (ING)
Analyzing operational and educational datasets to support strategic decision-making. Currently focusing on automating workflows using Google Apps Script and building interactive dashboards with Looker Studio and Google Sheets.
03.
Case Studies
Uber Trip Data Analysis
Performed EDA on large-scale ride-hailing data to identify peak demand hours and usage patterns for operational planning.
PythonPandasSeaborn
Sales Data Analysis & Forecasting
Computed KPIs for revenue growth and applied regression-based forecasting for inventory planning.
SQLTime-SeriesForecasting
Manufacturing Defect Analysis
Analyzed production quality data to identify defect sources, recommending process improvements to reduce waste by 15%.
Pareto AnalysisRoot Cause Analysis
Get In Touch
I am currently working at ING Group, but my inbox is always open. Whether you have a question about data engineering or just want to say hi, I'll try my best to get back to you!