Satkar Karki Headshot

Satkar Karki

Data Analyst / Data Scientist

Resume LinkedIn GitHub Email

About Me

I am a data sense-maker who specializes in forecasting, visualization, and data storytelling. My work ranges from helping a local bakery stabilize supplier pricing and reduce procurement risk to building dashboards at Coyote Capital Management that guide sector-level investment decisions. I enjoy modeling and analytics as much as communicating insights and teaching non-technical teams to use data for better business performance.

I am set to graduate with an M.S. in Business Analytics from the University of South Dakota and am seeking data analyst or data scientist roles where I can turn complex data into practical decisions that drive measurable results.

Toolkit: SQL, Python, R, Power BI, Excel, SAS, Spark, Tableau

Projects

Stakeholder Projects

These projects were created in collaboration with real organizations or student groups. The focus was on building solutions that could be applied and shared with others.

Egg Price Forecasting

Forecasted egg price fluctuations for Mister Smith's Bakery to secure cost-effective supplier contracts and avoid price shocks for customers.

R

Trail Trekker – Subscription Analytics

Growth analytics pipeline using DuckDB and SQLMesh (SCD2 dims + subscription-change fact) with hourly cron for upgrade, churn, and revenue insights.

SQL Python

Canyon Ranch Data Warehouse

Engineered a centralized reservation tracking system for Canyon Ranch resorts, improving service responsiveness and replacing outdated data systems.

SQL

DoorDash Delivery Time Prediction

Built a machine learning model to predict delivery times based on traffic and order flow, helping DoorDash improve ETA accuracy and customer satisfaction.

Python

NCAA Referee Dashboard

Scraped and structured NCAA game data into a relational database, then developed an interactive dashboard to optimize referee scheduling and performance insights.

Python SQL R

PlaylistPro Churn Prediction

End-to-end customer churn analysis combining descriptive insights and predictive modeling (XGBoost, Random Forest) to identify at-risk subscribers and optimize retention strategy for a music streaming service.

R Python

Personal Projects

These are self-initiated projects where I explored new tools, models, or ideas. They reflect my curiosity and commitment to continuous growth.

NFL 4th Down Analysis

Modeled 4th down plays in SAS to guide better game-time decisions.

SAS

Audi Price Prediction

Predicted used car prices with regression based on year, mileage, and engine specs.

R

TSA Claims Analysis

Analyzed passenger claims to find trends in baggage handling incidents.

Python SAS

RFM Segmentation – AdventureWorks

Segmented customers by RFM metrics to guide loyalty strategies.

SQL Excel

Smoothie Optimization

Built Solver-based model to reduce production cost while meeting nutrition targets.

Excel

Experience

USD Business Analytics Club, Vermillion, SD
President & Founder
Mar 2025 to Present
  • Launched and scaled a campus-wide club focused on applied analytics and career development.
  • Built a community of 30+ members in the first semester and now lead multiple student teams working on real-world projects across sports analytics, e-commerce, and pricing.
  • The club hosts end-of-semester showcases to connect students with faculty and industry.
Coyote Capital Management, Vermillion, SD
Junior Financial Analyst
Aug 2024 to Present
  • Support equity research within a $4M student-managed investment fund.
  • Led valuation and forecasting for healthcare sector holdings using XLMiner, contributing to a buy recommendation that outperformed benchmarks.
  • Collaborate with teammates to deliver professional-grade stock presentations backed by Bloomberg Terminal analysis.
Krinjal Foundation, Kathmandu, Nepal
Project Data Analyst
Mar 2020 to Nov 2023
  • Built and automated interactive dashboards to track project KPIs, reducing manual reporting time significantly.
  • Developed workforce scheduling models in Excel using Solver, which streamlined operations and cut down recurring scheduling inefficiencies.

Education

University of South Dakota

Master of Science in Business Analytics
Expected Dec 2025
  • President, USD Business Analytics Club
  • Junior Financial Analyst, Coyote Capital Management (student-led investment fund)
  • Coursework: Data Mining, Time-Series Forecasting, Business Analytics Modeling, Natural Language Processing (NLP), Database Management and Warehousing

Westcliff University

Bachelor of Business Administration (BBA)
2016 – 2020
  • Awarded seed funding through on-campus incubator to launch an artist management and music streaming platform
  • Focus areas: HR Strategy, Organizational Behavior, Business Planning

Latest Writing on Medium

NBA Careers through Analytical Patterns
A deep dive into how basketball data reveals career-shaping performance patterns.
NBA Careers through Analytical Patterns
How I Turned Class Projects into Real-World Analytics Wins
Turning academic case studies into portfolio-ready wins for real businesses.
How I Turned Class Projects into Real-World Analytics Wins
Expanding Fact Tables into Behavioral Analytics Scaffolds
A framework for evolving basic tables into robust systems for behavioral analytics.
Expanding Fact Tables into Behavioral Analytics Scaffolds
View All on Medium

Certifications

Microsoft Excel: Data Analysis with Excel Pivot Tables
Microsoft Excel: Data Analysis with Excel Pivot Tables
View Certificate
Python Intermediate
Python Intermediate
View Certificate
R Programming A-Z: R for Data Science
R Programming A-Z: R for Data Science
View Certificate
SAS Base Programming
SAS Base Programming
View Certificate