Rojin Sapkota
Finance Data Analyst | Advanced Excel & VBA | Power Query & Power BI | Financial Modeling
About Me
I'm Rojin Sapkota, a passionate and dedicated Finance Data Analyst with deep expertise in financial planning, budgeting, forecasting, financial modeling, and variance analysis.
With expertise in Advanced Excel (including VBA macros, Power Query, and PivotTables), Power BI for interactive dashboards, and financial modeling, I transform complex data into actionable insights that drive informed business decisions.
Dedicated to delivering clear, data-driven solutions, I'm committed to excellence in financial analysis and continuously enhancing my skills to support strategic growth.
I love to work in the field of data and finance, aligning with Tech and Visualization
Feel free to explore my portfolio of dashboards, automation tools, and valuation models!
Skills
- Advanced Excel (Dynamic PivotTables, Scenario Modeling, Visualization, Excel Dashboard & Formulas)
- VBA Macros & Automation
- Power Query (Data Transformation & ETL)
- Power BI (DAX, Interactive Dashboards, Data Modeling)
- Financial Modeling & Forecasting
- Budgeting & Variance Analysis
- Equity Valuation
- Data Visualization & Reporting
- Microsoft Office Suite
- Time Management & Project Delivery
My Portfolio
A section of my work demonstrating data scrapping & transformation, visualization, automation, and financial valuation skills in the context of Nepal's financial markets.
Brokerage Firm Performance Dashboard
Interactive Power BI dashboard scrapping datewise daily turnover of brokers and performance trends of brokerage firms in Nepal.
Accumulation-Distribution Analysis using Floorsheet Data
Automated daily floorsheet scraping (~90,000 rows) from merolagani.com using Python + Selenium, with multi-day aggregation and broker-level accumulation/distribution calculation for any stock.
Valuation of Standard Chartered Bank Nepal – Top-Down Approach
Top-down valuation model for Standard Chartered Bank Nepal (SCB) with scenario analysis. Projects private sector lending growth aligned with Nepal's GDP forecasts and estimates SCB's market share. Incorporates NRB capital adequacy constraints, SCB's strong CAR & low NPL advantage, and conservative CD ratio due to high call deposit composition.
Resume
My detailed resume is available upon request. Please contact me or visit my LinkedIn profile for the latest version.
Contact
I'm open to new opportunities, collaborations, and discussions on financial analysis or data projects.
Email: rojinsapkota17@gmail.com
LinkedIn: linkedin.com/in/rojin-sapkota
GitHub: github.com/Rojin-77
Instagram: @rojin_cr7