Skip to content
View harsh-1817's full-sized avatar

Block or report harsh-1817

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
harsh-1817/README.md
Harsh Trivedi — Financial Data, Analytics and Business Analysis

Hey there, I'm Harsh 👋

Financial Data Analytics · Business Analysis · Market Research

Turning financial data into insights and complex information into clear decisions.

GitHub profile Finance and analytics focus Open to data analyst and business analyst roles

🧭 About Me

I'm an MBA in Computer Management professional working at the intersection of financial markets, data analytics, business analysis, and technology.

My experience in financial-market research has strengthened my ability to investigate information, verify data against reliable sources, understand market developments, and communicate findings clearly. I enjoy working with datasets, testing whether data can be trusted, building dashboards, and turning raw information into structured, useful insights and clear requirements.

  • 📊 Analytics: Stock performance, sector trends, risk and returns, funnel and cohort analysis.
  • 🧾 Business analysis: BRDs, user stories with acceptance criteria, process flows, UAT and A/B test plans.
  • 🧪 Data quality: API testing and validation of financial data.
  • 📈 Financial research: Equity markets, IPOs, company filings, and derivatives.
  • 🛠️ Tools: Python, SQL, Excel, Power BI, Postman, and data visualization.
  • 🎓 Education: MBA in Computer Management & IT.
  • 📜 Certifications: NISM Series XV – Research Analyst and NISM Series VIII – Equity Derivatives.
  • 🌱 Currently building: an e-commerce analytics project (Project 04).

🛠️ Tools & Technologies

Data Analytics & Business Intelligence

Python and SQL icons
Microsoft Excel Microsoft Power BI Pandas

Business Analysis & Quality

BRD and requirements User stories Process mapping UAT and A/B testing API testing with Postman

Financial Markets & Research

Equity research Market analysis Derivatives NSE and BSE

Development & Tools

Git, GitHub, VS Code, Postman, JavaScript, Node.js, React, and MongoDB

🚀 Featured Projects

📊 Nifty 50 Sector Performance & Risk Analysis

Python · MySQL · Power BI

An end-to-end pipeline on five years of NSE data (50 stocks, 16 sectors) that ranks sectors by risk-adjusted return and shows how an investor can diversify.

  • Star-schema MySQL database and 8 SQL queries (window functions, CTEs)
  • CAGR, volatility, Sharpe ratio, drawdown and beta for every stock
  • Found and fixed a demerger distortion and a data-feed error
  • 3-page Power BI dashboard

Explore project →

🧪 Mutual Fund NAV API: Test & Data-Validation Framework

Postman · Python · pytest · GitHub Actions

Tests the public MFapi.in API and checks whether its NAV data can be trusted for valuation and returns.

  • 56 Postman assertions and 14 data-quality checks
  • Found an API that reports unknown funds as SUCCESS, a single bad NAV record and a 100x break in a fund's history
  • Separates real market events from data errors automatically
  • HTML, Excel and CSV reports; CI-ready

View repository →

🧭 Investor Onboarding Drop-off: Business Analysis Case Study

SQL · Python · Excel · Power BI · BRD

Why do 7 in 10 people who start opening a trading account never get one? A funnel analysis (synthetic data) with the full business-analysis toolkit.

  • 20,000-user funnel, 13 SQL queries, 5-page Power BI dashboard
  • BRD, 19 user stories, process flows, UAT and A/B test plans
  • Excel impact model: about +11% funded accounts in the base case
  • Traceability from finding to requirement to test to KPI

View repository →

🛒 Project 04: E-commerce Analytics (Coming Soon)

Data Analytics & Business Intelligence

A new project using e-commerce data to understand sales performance, customer behaviour and retention.

  • Data preparation and analysis
  • KPI tracking and dashboard
  • Actionable insights and recommendations

Status: In development.

🏆 Certifications

NISM Research Analyst certification NISM Equity Derivatives certification

🤝 Let's Connect

I'm interested in data analytics, business analysis, financial research, and projects that use data to answer meaningful questions. I'm open to Data Analyst and Business Analyst opportunities.

Explore my GitHub Connect on LinkedIn



Thanks for stopping by!

Analyze the data. Understand the market. Find the insight. 💙

Blue wave footer

Popular repositories Loading

  1. mf-nav-api-validation mf-nav-api-validation Public

    [v2] Postman + Python framework that tests the MFapi.in mutual fund API and validates NAV data quality (found a 100x series break and an unknown-fund defect)

    Python 1

  2. nifty50-sector-analysis nifty50-sector-analysis Public

    Python + MySQL + Power BI pipeline analysing Nifty 50 sector performance using real NSE data, with automated data cleaning, outlier flagging and an interactive dashboard.

    Python

  3. harsh-1817 harsh-1817 Public

    Financial Data Analytics | Market Research | Business Intelligence

  4. onboarding-dropoff-analysis onboarding-dropoff-analysis Public

    Business-analysis case study on broker account-opening drop-off: SQL + Python funnel analysis, BRD, user stories, process flows, UAT and A/B test plans, Excel impact model and Power BI dashboard (s…

    Python

  5. win2GP win2GP Public

    Jupyter Notebook