Back to Developers
Marka pranay

Marka pranay

Data Analyst

Hyderabad, India 0+ yrs exp 81 · Excellent

About

Detail-oriented Data Analyst with internship experience in collecting, cleaning, organising, and validating data from multiple sources. Proficient in MS Excel (VLookup, XLookup, Pivot Tables), SQL, Power BI, and Python — skilled at preparing reports, dashboards, and performance metrics that identify trends and support data-driven decisions. Proven ability to work with cross-functional teams and translate business requirements into actionable insights.

Skills & Expertise (37)

MS-Excel Advanced
8.5/10
1
Years Exp
Python Advanced
8.0/10
1
Years Exp
Pandas Advanced
8.0/10
1
Years Exp
Power BI Advanced
8.0/10
1
Years Exp
Time-Series Forecasting Advanced
8.0/10
1
Years Exp
Data Extraction Intermediate
7.5/10
1
Years Exp
DAX Intermediate
7.5/10
1
Years Exp
scikit-learn Intermediate
7.5/10
1
Years Exp
SQL Intermediate
7.2/10
1
Years Exp
Jupyter Notebook Intermediate
7.0/10
1
Years Exp
Matplotlib Intermediate
7.0/10
1
Years Exp
NumPy Intermediate
7.0/10
1
Years Exp
Statistical Analysis Intermediate
7.0/10
1
Years Exp
Seaborn Intermediate
6.5/10
1
Years Exp
process automation Intermediate
6.5/10
1
Years Exp
ETL Pipelines Intermediate
6.5/10
1
Years Exp
Git Intermediate
6.0/10
1
Years Exp
GitHub Intermediate
6.0/10
1
Years Exp
Data Modelling Intermediate
6.0/10
1
Years Exp
Postgresql Intermediate
6.0/10
1
Years Exp
Tableau Intermediate
6.0/10
1
Years Exp
BigQuery Intermediate
5.5/10
1
Years Exp
XGBoost VLOOKUP XLOOKUP Pivot Tables EDA Charts SARIMA ARIMA Data Interpretation Power Query Trend Analysis Funnel Analysis Cohort Analysis Data Validation KPI Dashboards

Work Experience

Data Analytics & Data Science Intern

Zidio Development

Jul 2025 - Oct 2025

Project 1: Built ARIMA & SARIMA time-series models on 2,516 rows of Apple stock data; evaluated with RMSE and MAE; quantified forecast bias to communicate overestimation risk to stakeholders. Delivered a Power BI dashboard with DAX — prediction charts, risk cards, trend direction & seasonality table — enabling data-driven decisions. Performed EDA in Python to identify seasonal trends and volatility patterns, informing model design and KPI definitions. Project 2: Built an XGBoost model achieving 80.2% accuracy (AUC 0.84); segmented 2,461 customers via cohort analysis into Critical, Medium & Low retention-risk groups. Extracted, cleaned & validated 2,461 customer records using Python (Pandas), analysing churn behaviour, subscription tenure, engagement scores & fragmentation patterns. Delivered a Power BI dashboard enabling the retention team to instantly identify at-risk customers and act on data-driven insights.

Education

B.Tech — Artificial Intelligence & Machine Learning - JNTUH

2022 - 2026 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 6/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 81/100

Profile Overview

Member sinceJun 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation