Satyajit pradhan

Aspiring Data Analyst and Business Analyst fresher

Data Analytics and Business Analysis
2roles
38skills
2education
4credentials

About

Aspiring Data Analyst and Business Analyst fresher with hands-on experience in Python, SQL, Excel, Power BI, data cleaning, data wrangling, exploratory data analysis, KPI dashboards, and business intelligence reporting.

Experience

Data Science Intern

Oasis Infobyte

2024

Performed data cleaning, data wrangling, and exploratory data analysis on multiple complex datasets using Python, Pandas, and NumPy to extract actionable insights and identify business trends. Created data visualizations using Matplotlib to communicate findings clearly to stakeholders, supporting data-driven decision-making and reporting requirements.

Web Development Intern

Navodita Infotech

2023

Developed a responsive weather application integrating real-time data via REST API using HTML, CSS, and JavaScript. Implemented efficient data fetching and presentation mechanisms ensuring cross-platform compatibility.

Education

GIET University, Gunupur

B.Tech, Computer Science Engineering

2021 – 2025

Ganesh +2 Science College

+2 Science, PCM & IT

2019 – 2021

Skills

PythonStructured Query Language (SQL)MySQLData AnalysisPandasNumPyExploratory Data Analysis (EDA)Data WranglingData CleaningData CleansingStatistical AnalysisPivot TablesBusiness Intelligence (BI)Power BIMicrosoft ExcelMatplotlibData VisualizationDashboard ReportingDashboard DevelopmentRequirement GatheringKPI TrackingKey Performance Indicators (KPI)Gap AnalysisProcess UnderstandingStakeholder ReportingData-Driven Decision MakingREST APIPower QueryDAXGoogle SheetsMicrosoft OfficeData ModelingTrend AnalysisReport GenerationData InterpretationHTMLCSSJavaScript

Projects

Sales Analytics Intelligence Dashboard

Analyzed 10,000 orders across five categories, four regions, and two sales channels using Python and Pandas to uncover revenue and profitability patterns. Built an end-to-end multi-page Power BI dashboard with KPI cards, trend charts, and dynamic filters. Performed data wrangling and exploratory data analysis to identify revenue trends and a discount-optimization opportunity.

Data Analyst Job Market Dashboard

Built an interactive Power BI dashboard analyzing 100 job postings and 329 skill mentions. Cleaned and normalized raw data using Power Query and created dynamic filters to analyze in-demand skills and salary variance across locations.