Back to Developers
Vinay Goud

Vinay Goud

Junior Data Analyst

Hyderabad, Telangana 80 · Excellent

About

Detail-oriented Data Analyst with hands-on experience in SQL, Microsoft Excel, Python, and Power BI. Skilled in data cleaning, validation, reporting, dashboard development, KPI tracking, and analyzing datasets to identify trends and business insights. Experienced in supporting KPI reporting, maintaining data integrity, and documenting analysis for stakeholder review. Collaborated on analytics projects to translate business requirements into dashboards and reports. Strong attention to detail, communication, and problem-solving skills, with a solid foundation in ETL processes and business reporting.

Skills & Expertise (53)

SQL Advanced
8.0/10
4
Years Exp
Data Cleaning Advanced
8.0/10
4
Years Exp
Data Visualization Advanced
8.0/10
4
Years Exp
Power BI Advanced
8.0/10
4
Years Exp
Data Validation Intermediate
7.5/10
3
Years Exp
Python Intermediate
7.5/10
3
Years Exp
Exploratory data analysis Intermediate
7.5/10
3
Years Exp
Feature Engineering Intermediate
7.0/10
3
Years Exp
ETL Processes Intermediate
7.0/10
3
Years Exp
Data Modeling Intermediate
6.5/10
3
Years Exp
KPI Tracking Postgresql Ad-Hoc Reporting Business Reporting Aggregations Joins Window Functions CTEs SQLite Time management Process Optimization Git VS Code MySQL WorkBench Google Sheets Analytical Thinking Communication Documentation Attention to Detail Cross-Functional Collaboration KPI Dashboards Data Quality Assurance Data Transformation Probability T-test Chi-Square test ANOVA correlation analysis Hypothesis Testing Tableau DAX Dashboard Development MySql Excel Dashboards Matplotlib Seaborn Pivot Tables VLOOKUP XLOOKUP Index-match Charts What-If Analysis Forecasting

Work Experience

Data Analyst

Olist

Present - Present

Analyzed 96K+ e-commerce orders to evaluate revenue trends, customer retention, seller performance, and logistics efficiency. Collected, cleaned, and consolidated data from multiple relational sources to support reporting, dashboard development, and business analysis. Built SQL workflows using joins, CTEs, window functions, RFM segmentation, cohort analysis, and NTILE functions to automate business reporting and KPI analysis. Built Excel Pivot Table reports and What-If Analysis models for operational KPI reporting. Performed data validation and report testing to verify KPI accuracy before dashboard delivery. Developed interactive Power BI dashboards and business reports enabling stakeholders to monitor operational KPIs and business performance. Identified business risks such as low repeat-purchase rates, revenue concentration, and delivery delays through statistical analysis. Integrated multi-table relational datasets including customers, orders, sellers, payments, and deliveries for end-to-end analytical accuracy. Maintained analytical documentation and SQL workflows to improve report consistency and reproducibility.

Data Analyst

Insurance Claims

Present - Present

Built an end-to-end analytics pipeline across 10,004 policy records, including data cleaning, data validation, data quality assurance, exploratory data analysis, statistical testing, and claim lifecycle reporting. Built a Power BI dashboard for KPI tracking, claim status monitoring, risk segmentation, and anomaly insights to support data-driven decision-making. Applied Chi-Square, ANOVA, and T-Test to identify key drivers of claim outcomes across customer demographics and policy characteristics. Designed a multi-layer anomaly detection framework using IQR, Z-Score, and Isolation Forest that flagged 1,817 potentially anomalous policies for further investigation. Trained a Logistic Regression model on 7,741 claims for predictive risk scoring, identifying claim amount and coverage utilization as the strongest predictors.

Data Analyst

Financial Transaction

Present - Present

Worked with 6M+ financial transaction records, performing ETL, data cleaning, feature engineering, and structured reporting. Developed 15+ SQL queries using CTEs, window functions, ranking functions, and aggregations to support investigation workflows and KPI reporting. Designed Power BI dashboards visualizing fraud rate, detection rate, and total loss KPIs to support operational and strategic risk decisions. Tracked model outputs, results, and KPI trends through Power BI dashboards and documented workflow steps clearly. Engineered 10+ fraud-detection features and trained Random Forest and Logistic Regression models, achieving ROC-AUC of 0.92 and recall above 0.78 on imbalanced data. Validated high-volume transaction data to ensure reporting accuracy and consistency across analytical workflows.

Education

Bachelor of Technology (B.Tech) - Computer Science & Engineering - Guru Nanak Institute of Technology (GNIT)

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

Profile Overview

Member sinceJul 2026

Availability Details

Visa Status

Need Sponsorship

Relocation

Open to Relocation