Back to Developers
Prajwal Sakore

Prajwal Sakore

Data Analyst

Pune
80
Profile Score

About

Data Analyst with 2+ years of experience in analyzing, validating, and transforming data to support strategic business decisions. Proficient in Advanced Excel (Pivot Tables, VLOOKUP, HLOOKUP, INDEX-MATCH, Macros), SQL (Joins, Subqueries, Views, Stored Procedures), and Python (Pandas, NumPy) for data manipulation and analysis. Experienced in data visualization and dashboard creation using Power BI, Tableau, and Google Data Studio to deliver actionable insights to stakeholders. Strong knowledge of data cleaning, data modeling, statistical analysis, and KPI reporting. Skilled in working with MySQL and SQL Server, performing ad-hoc analysis, and ensuring data accuracy and consistency. Adept at collaborating with cross-functional teams and thriving in fast-paced, data-driven environments.

Skills & Expertise (36)

Tableau Intermediate
8.5/10
2
Years Exp
Power BI Intermediate
8.5/10
2
Years Exp
Exploratory data analysis Intermediate
8.0/10
2
Years Exp
KPI Reporting Data Transformation MySql SQL Server ER diagrams Normalization Data Warehousing concepts Data Cleaning Ad-hoc Analysis Trend Analysis Descriptive Statistics correlation analysis Requirement gathering stakeholder communication Documentation Data Quality Checks Stored Procedures VLOOKUP HLOOKUP Index-match Macros Joins Subqueries Views CTEs Data Validation Window Functions Pandas NumPy Matplotlib Seaborn Google Data Studio Pivot Tables

Work Experience

Data Analyst

Sofrego Private Limited

Sep 2023 - Present

Collected, cleaned, and validated customer and transaction data from multiple sources. Analyzed credit history, income patterns, and repayment behavior to assess credit risk. Developed complex SQL queries to extract, join, and transform large datasets. Performed Exploratory Data Analysis (EDA) to identify trends, anomalies, and risk factors. Created interactive dashboards and reports using Power BI and Tableau for loan status, approval rates, and delinquency metrics. Automated reports using Advanced Excel (Pivot Tables, VLOOKUP, Macros). Collaborated with business and risk teams to understand requirements and define KPIs. Ensured data accuracy and consistency through regular data quality checks.

Education

B.Sc. in Computational Mathematics and Statistics - MIT World Peace University

- 2023 · Afghanistan

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 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 80/100

Profile Overview

Member sinceMar 2026

Availability Details

Visa Status

Citizen

Relocation

Not Open to Relocation

Skills (36)

Tableau Power BI Exploratory data analysis KPI Reporting Data Transformation MySql SQL Server ER diagrams Normalization Data Warehousing concepts +26 more