SHASHANK KATARE

Data Analyst

https://www.opentalent.in/shashank-katare-5697138

Data Analyst with less than a year in Python, SQL & Excel for Automation and Reporting

Key Strengths

Demonstrated ability in data cleaning, validation, and ETL pipeline development using Python.
Experience in creating dashboards and reports with Power BI and Excel, including DAX-driven KPIs.
Proficiency in automating reporting workflows, leading to measurable efficiency improvements.
Strong foundational understanding of SQL for data extraction and manipulation.
Exposure to statistical analysis, anomaly detection, and root cause analysis in projects.

Cultural & Operational Fit

Cultural Fit Analysis

The candidate's academic projects demonstrate a practical application of data analysis skills across different scenarios (consumer revenue, demand, academic performance). The inclusion of industry simulations (Deloitte, Tata) shows initiative and an interest in applying skills in a professional context, which aligns with a proactive learning culture. The breadth of tools (Python, SQL, Excel, Power BI, Tableau) indicates adaptability. As a fresher, the focus on academic projects is expected and shows a foundational alignment with a data-driven role.

Soft Skills & Operational Fit

The candidate's professional summary highlights an 'ownership mindset' and 'willingness to handle end-to-end tasks,' which suggests a proactive approach. The project descriptions indicate an ability to translate data findings into business-ready outputs and document SOPs, pointing to good operational fit and attention to detail. However, without direct interview data, these are inferred from self-reported project outcomes.

AI is analyzing your overall score…

Identifying your key strengths…

Evaluating your skill match against the job requirements…

Assessing your cultural and operational fit

About

B.Tech Computer Science fresher (Final Year) with hands-on experience in data validation, report generation, and automation using Python, SQL, and Advanced Excel on datasets of 100,000+ records. Experienced in building ETL pipelines, automating manual reporting workflows, and delivering clear, accurate data outputs for business stakeholders. Quick learner with strong analytical thinking, ownership mindset, and willingness to handle end-to-end tasks — from manual report generation to full pipeline automation.

Projects

Consumer Demand & Delivery Delay Analytics

June 1, 2026 – Present

Applied statistical trend decomposition to detect 25% seasonal demand surge and classify 11% anomalous data patterns — supporting accurate, validated automated report outputs. Isolated 2 root-cause bottlenecks driving 40% of operational failures; automated manual reporting pipeline delivering 15% measurable KPI improvement.

Academic Performance Analytics Pipeline

June 1, 2026 – Present

Built modular Python pipeline reducing data preprocessing time ~30% through automation; conducted EDA and cohort analysis uncovering 20% performance gap across segments.

Consumer Revenue & Regional Segmentation Analytics

June 1, 2026 – Present

Collected, cleaned, and validated 100K+ retail records using Python ETL pipelines; resolved 18% data inconsistencies — directly replicable as a report validation and automation workflow. Generated 10+ Power BI and Excel dashboards with DAX-driven KPIs; produced SOP-documented stakeholder reports translating data findings into clear, business-ready outputs. Automated recurring data reporting pipeline, reducing manual effort and ensuring consistent, accurate data outputs for downstream analysis.

Certifications

Advanced Excel, VBA & Macros Automation

Udemy

June 1, 2026 – Present

SQL (Basic)

HackerRank

June 1, 2026 – Present

Certified Data Analyst Foundations

Udemy

June 1, 2026 – Present

Key Strengths

Demonstrated ability in data cleaning, validation, and ETL pipeline development using Python.
Experience in creating dashboards and reports with Power BI and Excel, including DAX-driven KPIs.
Proficiency in automating reporting workflows, leading to measurable efficiency improvements.
Strong foundational understanding of SQL for data extraction and manipulation.
Exposure to statistical analysis, anomaly detection, and root cause analysis in projects.

Cultural & Operational Fit

Cultural Fit Analysis

Soft Skills & Operational Fit

SHASHANK KATARE

Key Strengths

Cultural & Operational Fit

About

Skills

Education

Projects

Certifications

Key Strengths

Cultural & Operational Fit