Skip to main content
Swadhin Kumar

Swadhin Kumar

Data Analyst | Power BI · Python · SQL · Excel

Talent
Bengaluru, Delhi, Hyderabad, NCRMember since October 25, 2026
Data Cleaning & ValidationExploratory Data AnalysisKPI DesignDescriptive StatisticsMonte Carlo SimulationPCAVaR / Expected ShortfallDuration & ConvexityBacktestingRegression & ClassificationSHAP ExplainabilityPythonPandasNumPyscikit-learnXGBoostPyTorchMatplotlibPlotlyOpenPyXLggplot2caretSQLDAXPower BIstar schemameasuresWhat-If parametersTabular EditorMicrosoft Excel
·

Hire this person

Send a job offer directly to this candidate

Data Cleaning & ValidationExploratory Data AnalysisKPI DesignDescriptive StatisticsMonte Carlo Simulation

About

Data Analyst combining hands-on internship experience building end-to-end analytics in Python, Power BI and SQL with 12 years of retail business operations running my own grocery store. Delivered a fixed-income risk platform covering 300 bonds and 6 currencies — Monte Carlo VaR, yield-curve modelling, 50 DAX measures and 74 automated tests — and I bring a shopkeeper's instinct for margins, stock and cash flow to every dataset.

Experience

Data Analyst Intern at Zetheta Algorithms Private Limited (2026-10 – 2026-10)

Bond Portfolio Risk Analytics & Gamified Bond Risk Lab (confidential project)

  • Priced a 300-bond, ₹3.21 Cr multi-currency portfolio (6 currencies, 44 attributes) in Python — price, Macaulay/Modified Duration, convexity, DV01, OAS and key-rate duration, verified against benchmark values.
  • Fitted yield curves (Nelson-Siegel, cubic spline) on 264 daily observations; decomposed curve moves into level, slope and curvature factors via PCA.
  • Designed a 1,000-scenario Monte Carlo engine producing VaR(99%) ₹25.17 L and Expected Shortfall ₹29.99 L, validated with Kupiec backtests (95%/99%) and a delta-gamma cross-check within 5%.
  • Delivered the reporting layer as a Power BI star schema with 50 DAX measures plus a multi-sheet Excel validation workbook; trained RF/XGBoost/PyTorch models with SHAP explainability and replicated the analysis in R (test-set R² 0.97–0.99).
  • Wrote 74 automated pytest tests across analytics, model, benchmark and reconciliation suites; 11 documented commits on a private repository.

Entrepreneur & Proprietor at Self-Employed Grocery Retail (2014 – 2026)

Family grocery store, full operations ownership

  • Ran end-to-end retail operations for 12 years: procurement and vendor negotiation, stock replenishment cycles, pricing, daily cash handling and manual accounting of sales and customer credit (khata).
  • Managed inventory across fast- and slow-moving categories, adjusting purchase volumes to seasonal demand and shelf-life limits to control waste and keep working capital moving.
  • Handled customer relationships, staff scheduling and month-end reconciliation — the margin, stock-turn and cash-flow instincts I now apply analytically in retail and e-commerce datasets.

Freelance Copy Checker at Physics Wallah (2026-02 – Present)

Study-material proofreading, ongoing

  • Review and correct study-material copy to accuracy and formatting standards, delivering every assigned batch on or before deadline.

Education

Bachelor of Science (B.Sc.) – T.N.B. College, Bhagalpur (2014 – 2017)

Skills

Data AnalystPower BIPythonSQLExcel

Reviews