Data & Analytics Engineer · Kathmandu

I turn messy ERP data into warehouses, cubes and dashboards that teams actually trust.

Mail me Download CV

01 / About

About me

Portrait of Bibek Bikram Shahi Bibek Bikram Shahi with his motorbike Power BI · SQL
Kathmandu, NP

Associate BI Developer · BSc CSIT student

I build the data foundations and the dashboards on top of them. At Agile Solutions I shape SQL Server warehouses, model SSAS cubes and deliver Power BI reports that give sales, finance, HR and service teams a clear view of how their business is doing. A lot of that work lives inside Microsoft Dynamics NAV and Business Central data — migrating it, checking it and turning it into models people can rely on.

Outside the day job I'm in the final stretch of my BSc CSIT at Bhaktapur Multiple Campus, and I keep growing my Python and machine learning skills through the side projects you'll find further down.

Since
Apr 2025
building BI professionally
Rollouts
3
enterprise BI implementations
Degree
8th
semester of BSc CSIT
Download CV

02 / Experience

Where I've worked

Delivering business intelligence end to end, from the source database to the last chart on the report.

  1. Apr 2025 — Present Agile Solutions Pvt. Ltd. Kathmandu, Nepal

    Associate BI Developer Current

    • Deliver BI solutions across Microsoft SQL Server, SSAS Multidimensional, MDX and Power BI.
    • Write and tune T-SQL stored procedures that reshape warehouse data for analysis.
    • Model and maintain multidimensional cubes in Jet Data Manager for slice-and-dice reporting.
    • Ship Power BI reports covering sales, service, spare parts, HR and finance.
    • Handle migration and reporting on Microsoft Dynamics NAV / Business Central databases.
    • Reconcile source systems, cubes and reports so the numbers always line up, and suggest workflow improvements for business users.
    • SQL Server
    • SSAS
    • MDX
    • Power BI
    • Jet Data Manager
    • NAV / BC
  2. Feb 2023 — Feb 2027 Bhaktapur Multiple Campus Expected graduation

    BSc in Computer Science & IT

    Currently in the 8th semester, combining coursework with full-time BI work and machine learning side projects.

02.1 Key client projects

Gorkha Brewery · Carlsberg Group C/01

Sales & material requisition analytics

  • SSAS cubes and MDX calculations behind the sales and requisition dashboards.
  • Stored-procedure ETL moving ERP data into the warehouse via Jet Data Manager.
  • Requirements turned into data models, plus SQL Server upkeep for integrity and speed.
  • SSAS
  • MDX
  • ETL
Agni Group · Mahindra Nepal C/02

Sales, spare parts & service analytics

  • Cubes with dimensions, measures and MDX logic across three business lines.
  • Warehouse transformations built on Dynamics NAV / Business Central data.
  • Dashboards on top of the cubes, validated against source data.
  • SSAS
  • NAV / BC
  • T-SQL
NMB Bank Ltd. C/03

HRMS analytics dashboard

  • Power BI
  • DAX
  • Power Query
  • Interactive Power BI report on workforce demographics, turnover and appraisals.
  • Complex DAX measures over a data model tuned with Power Query.

03 / Stack

Tech stack

The engines, query languages and tools I use to move data from source systems to dashboards.

Core competencies

01 Python Language
02 PySpark Distributed compute
03 ClickHouse Columnar OLAP
04 SQL Query · T-SQL

BI & tooling

05 SQL Server RDBMS
06 SSAS · MDX OLAP cubes
07 Power BI Visualisation
08 DAX · M Modelling
09 Jet Data Manager ETL · DWH
10 Docker · Git Tooling

03.1 Full toolkit

Databases & SQL
SQL Server, T-SQL, stored procedures, data transformation
Business intelligence
Power BI, DAX, Power Query, SSAS Multidimensional, MDX, data modelling
Data engineering
ETL, data warehousing, integration, validation, Dynamics NAV / BC data
Programming & AI
Python, SQL, data analysis, machine learning fundamentals
Tools
SSMS, Power BI Desktop, Jet Data Manager, ClickHouse, Docker, Git, VS Code

04 / Work

Side projects

Analytics and machine learning work I build to keep learning.

Power BI project
P/01
  • Power BI
  • BI

Power BI Reports

A collection of interactive Power BI dashboards and business intelligence reports exploring different datasets.

Sentiment Analysis project
P/02
  • LSTM
  • NLP

Sentiment Analysis

Sentiment analysis on the IMDB movie reviews dataset using an LSTM model.

Hand Digit Recognition project
P/03
  • CNN
  • Vision

Hand Digit Recognition

Handwritten digit recognition with CNN models.

Movie Recommendation project
P/04
  • TF-IDF
  • RecSys

Movie Recommendation

A recommendation system using TF-IDF and cosine similarity to suggest movies based on user preferences.

Chitchat chatbot project
P/05
  • Rasa
  • NLU

Chat Bot

Chitchat, a chatbot powered by Rasa for COVID-19 FAQs.

Kampana project
P/06
  • Python
  • Signal

Kampana

Seismic detection project that analyzes and visualizes seismic activity on the Moon and Mars using Python algorithms.

05 / Hobbies

My hobbies

Away from the dashboards: Barça on matchday, the latest space missions, and side projects that keep me curious.

Football
H/01

Football

I love watching football. I follow LaLiga and other leagues too. I am a Barça fan.

Outer space
H/02

Astronomy

Fascinated with space. I follow different space missions.

Code on a screen
H/03

Coding

Learning to code to enhance and increase the power of computers and the internet.

06 / Contact

Contact me

[email protected]

Get in touch

Got a reporting headache, a dashboard idea or a data role in mind? I'm happy to talk it through.

Social

Message me