AVHIYAN
0
I am


Mechanical EngineerMBA — Major: FinanceMinor: Data AnalyticsKathmandu, NP
SCROLL
MECHANICAL ENGINEERMBA FINANCEDATA ANALYTICSFSAE — TEAM URJAINVESTINGKATHMANDU
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