Satyaprakash Sahoo

Satyaprakash Sahoo

Business Analyst

Gurugram, IndiaData Analytics and Business Intelligence
3roles
34skills
2education

About

I am working as a business analyst and I love thinking through data, generating insights and solving problems through structured thinking and by making data driven decisions.

Experience

Business Analyst

ProcDNA

July 2025 – Present · Gurugram, Haryana

Analyzed operational and business metrics in SQL/Snowflake using time-series and cohort analysis; designed BI-ready analytical tables with CTEs, window functions, and deduplication logic, reducing reporting turnaround time by 40%; converted business questions into measurable KPIs and Power BI dashboards for 30+ stakeholders.

Data Analyst Intern

Mobile Premier League (MPL)

May 2024 – August 2024 · Bengaluru, Karnataka

Analyzed game-category performance to identify retention drivers, contributing to a 15% improvement in user retention; built automated Tableau dashboards, alerts, and workflows that eliminated 8–10 hours per week of manual reporting; analyzed GMV, margin, and cohort-level performance to support revenue and growth decisions.

Data Science Intern

Innomatics Research Labs

January 2024 – April 2024 · Remote

Cleaned, assessed, and visualized the Aspiring Minds 2015 dataset; built and deployed a Regex Matcher web app on AWS; resolved data retrieval and insertion issues in a Note Taking Application, increasing productivity by 15%.

Education

National Institute of Technology, Kurukshetra

B.Tech, Production and Industrial Engineering

December 2021 – June 2025

CGPA: 8.24/10

Young Phoenix Public School, Bhubaneswar

Central Board of Secondary Education, Class XII

May 2021

Percentage: 92.8

Skills

SQLSnowflakePythonNumPyPandasMatplotlibScikit-learnFlaskMS-ExcelPower BITableauGoogle SheetsJupyterGCSGitHubAWSJiraExploratory Data Analysis (EDA)Data CleaningData WranglingCohort AnalysisKPI DesignRegressionClassificationClusteringModel EvaluationFeature EngineeringTime-Series AnalysisCTEsWindow FunctionsDeduplication LogicPower QueryDAXForecasting

Projects

Sales Performance and Business Insights Dashboard

Analyzed 100K+ customer feedback and sales records; identified revenue trends, regional performance gaps, and recurring service issues; defined KPIs including revenue growth, profit margin, order volume, and customer segmentation; created an interactive Power BI dashboard using Power Query and DAX with filters, drill-downs, maps, and forecasting visuals.

Volunteering

Quizzing Head

Q-Club

Newsletter Head

Antariksh, the Astronomical Society of NIT Kurukshetra

Led a 12-member sponsorship team

Confluence, NIT Kurukshetra’s annual cultural fest