AVHIYAN
0
I am


Mechanical EngineerMBA — Major: FinanceMinor: Data AnalyticsKathmandu, NP
SCROLL
MECHANICAL ENGINEER✦MBA FINANCE✦DATA ANALYTICS✦FSAE — TEAM URJA✦INVESTING✦KATHMANDU✦
01about

Engineer.Analyst.Writer.

I like how things are built, and how value is made.

01From FSAE powertrains 02to portfolio models 03to op-eds

The throughline is the same — take something messy, understand it properly, and make a call.

Avhiyan Pandey
02selected work

Things I’ve built & analyzed

A Satellite-Based Environmental Assessment of Nepal’s Cement IndustryIn journal submission
A remote-sensing framework that monitors industrial NO₂ where firms publish no emissions data — a plant-level inventory of 25 cement facilities from TROPOMI satellite data (2018–2026), with background-corrected rankings, wind-resolved plume analysis, interrupted time-series regression and change-point detection. First and corresponding author.
ESG Research · Remote Sensing
2026
TROPOMI · PYTHON
Equity Valuation — Himalayan Distillery Ltd
A full intrinsic valuation triangulating three methods — DCF (FCFF), Residual Income and Relative Valuation — built from the company’s financial statements and a CAPM cost of equity, then blended into a single defensible estimate against market price.
Corporate Finance
2026
DCF · RI · RELATIVE
The EV Dominance Battle — Tesla vs. BYD
A board-level strategy case (International Business, GEM 631) on whether Tesla’s differentiation can survive BYD’s cost leadership and vertical integration in China. Concludes Tesla cannot win a price war and sets out “Differentiation 2.0” — defend margin, migrate value to software, energy and autonomy — with a 12–24 month execution plan.
International Business · Strategy
2026
STRATEGY · CASE
NYC Flight Delay Analytics
Five business questions answered with five techniques on 336,776 NYC flights (2013) joined to hourly weather — regression, classification, clustering, association rules and forecasting. Delay minutes are near-unpredictable pre-departure, but risk ranking catches 56% of late flights and daily volume forecasts to within ~5.7%.
Data Analytics
2026
R · ML · FORECASTING
Data-Driven Profitability & Route Analysis — FMCG Distributor
A self-initiated analyst project turning a distributor’s raw operations into decisions — cleaning route, delivery, cost and revenue data to compute per-route profitability-to-expense ratios and surface loss-making routes.
Data Analyst · Operations
2026
PYTHON · EXCEL
8-Week NEPSE Stock Market Simulation
Managed an NPR 500,000 virtual portfolio (team of three): fundamental screening, technical signals, Markowitz optimization and Value-at-Risk (Historical, Variance-Covariance, Monte Carlo) with full performance attribution.
Finance · Risk
2025
EXCEL · R
Global EV vs. Petrol Adoption
Panel-data analysis of EV adoption across 25 countries (2010–2025) in R — multi-model regression, multicollinearity checks and structural-break detection; emission-regulation stringency and average EV range emerged as the strongest drivers.
Capstone · Data
2026
R · PANEL DATA
Clustering & BI Dashboards
K-Means and hierarchical clustering for segmentation, plus Power BI dashboards on the AdventureWorks and Northwind Traders datasets.
Machine Learning · BI
2026
PYTHON · POWER BI
Electric FSAE Powertrain
Developed the powertrain for an electric Formula SAE car with Team Urja — FEM analysis of structural mounts and dynamometer testing of motor performance.
Engineering · FEA
2024
CATIA · ANSYS
Regenerative Braking System
Designed and fabricated a working scale model to measure regenerative-braking efficiency — a year-long hands-on build.
Engineering
2023
SOLIDWORKS
03two disciplines, one mind

Steel & spreadsheets

</>

The Engineer

Trained in applied physics, thermodynamics, and fluid mechanics. I design, simulate, and fabricate — then test it on the bench.

  • FSAE powertrain & structural FEA
  • SOLIDWORKS · CATIA V5 · ANSYS
  • C, C++
↗

The Strategist

MBA in Finance. I model markets and operations, weigh risk, and make the call. Engineering rigor, business instinct.

  • Valuation, portfolio & risk (VaR)
  • Python, Power BI, SPSS
  • Investing & market analysis
04field notes — team urja
Formula Bharat 2024 grid
Built in Nepal. Raced in India.
FORMULA BHARAT 2024 — TEAM URJA, NEPAL’S FIRST FORMULA SAE TEAM
Team Urja FSAE carOUR CAR — SCRUTINY BAY
Team Urja at Formula BharatTHE TEAM — FB 2024
05how i work

The method

01

Define

Frame the real problem and the constraints before touching a tool.

02

Model

Build the model — CAD, a dataset, or a financial model that mirrors reality.

03

Build

Make it real: fabricate, code, simulate, run the numbers.

04

Decide

Test against evidence, attribute results, and make the call.

06the toolbox

What I work with

ValuationPortfolio & Risk (VaR)Technical AnalysisESG Analysis
PythonPower BISPSS
SOLIDWORKSCATIA V5ANSYS (FEA)C / C++
FSAE Financial HeadSponsorship & StakeholdersMillennium FellowshipTeam CoordinationFMCG Operations
07writing

On Nepal’s economy

OP-ED 01

Dear Investors. Stay Home. We’re Closed for Business.

Nepal’s systemic failure to attract and retain FDI — three decades of pledged capital that never materialized.

OP-ED 02

The Handrails Nepal Could Never Forge

The only major South Asian economy without futures or interest-rate-swap markets — and who pays for it.

OP-ED 03

The Impossible Trinity in Practice

Mundell-Fleming applied to Nepal’s India peg: monetary independence, capital mobility, geopolitics.

BEYOND THE NUMBERS

I also write literature.

Essays, prose, and creative pieces — the writing I do for myself, collected on my personal blog.

READ THE BLOGREAD THE BLOG ↗
08contact

Let’s build something that works.

Open to roles and collaborations in finance, data analytics, and operations. Fastest way to reach me is email.

LOCATION — Kathmandu, Nepal
RESPONSE — Within 24–48 hrs
STATUS — Open to opportunities
preview