● Open to Work

SANIKA ARUN GHODAKE

Data & Business Analyst
Pune, Maharashtra

About Me

Data & Business Analyst aspiring professional with hands-on expertise in Python, SQL, and Advanced Excel, and a strong foundation in data analysis, documentation, and stakeholder collaboration. Experienced in requirements-driven data cleaning, exploratory data analysis (EDA), dashboard development, and KPI reporting through academic projects and internship work.

Skills & Technologies

PythonSQLData CleaningEDAStatistical AnalysisData InterpretationTrend AnalysisBusiness InsightsKPI TrackingRequirements DocumentationPower BIAdvanced Microsoft ExcelPower QueryDAXDashboard DevelopmentData VisualizationPerformance ReportingPandasNumPyMatplotlibScikit-learnMySQLMongoDBJupyter NotebookGitVS CodeDBMSOOPSDLCStatisticsFeature EngineeringStakeholder CoordinationTechnical DocumentationData Analytics - Great LearningAdvanced Microsoft Excel - Great LearningPower BI - SimplilearnMachine Learning – NPTELArtificial Intelligence - IB

Projects

E-commerce Return & Refund Analytics Dashboard

Developed an interactive dashboard analyzing 10,000+ e-commerce orders, returns, and refunds, translating business requirements into a reporting solution design. Built 12+ business KPIs, including Return Rate, Refund Amount, Average Refund Time, Customer Return Rate, and Category Performance. Cleaned and transformed raw datasets using SQL and Power Query to improve reporting accuracy and documented the data pipeline for repeatability. Analyzed customer behaviour, product categories, payment methods, and regional return trends to identify key return drivers and support stakeholder decision-making.

Power BISQLExcel

Sales Performance Dashboard

Designed an executive dashboard to monitor sales performance across regions, products, and customer segments, aligning outputs with business stakeholder requirements. Created KPI cards for Revenue, Profit, Sales Growth, Customer Retention, and Product Performance. Performed data cleaning, transformation, and modelling using Power Query and SQL, with documentation of key data definitions.

Power BIExcelSQL

Education

M.Sc. Computer Science

Computer Science

MIT Arts, Commerce and Science College2023 - 2025

B.Sc. Computer Science

Computer Science

MIT Arts, Commerce and Science College2020 - 2023
SANIKA ARUN GHODAKE - Data & Business Analyst | HiringAnt