Penchala Vamshi
DataAI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Detail-oriented Data Analyst with strong SQL & Excel skills for data quality and reporting.
Detail-oriented Data Analyst with hands-on experience in Excel and SQL for data cleaning, validation, and quality checks across multiple real-world datasets. Comfortable auditing data for accuracy, identifying inconsistencies, and structuring findings clearly for reporting. Academic background is in Information Technology, supported by strong analytical thinking, attention to detail, and the ability to pick up new domains quickly. Reliable, organized, and comfortable working independently to meet project deadlines.
Acciojob
Advanced Certification · Data Analytics
August 1, 2025 – June 1, 2026
CMR Engineering College
B.Tech · Information Technology
October 1, 2022 – May 1, 2025
Retail Sales Analysis
June 19, 2026 – Present
Analyzed multi-region retail transaction data to identify sales trends and regional performance gaps. Cleaned and validated raw data in Excel — removed duplicate records and standardized inconsistent date and category formats before analysis. Wrote SQL queries using joins, aggregations, and filters to isolate underperforming regions and product categories. Built a Power BI dashboard with region-wise and category-wise KPI views for clearer reporting.
E-Commerce Sales and Customer Analysis
June 19, 2026 – Present
Analyzed e-commerce order and customer data to identify revenue trends, top-selling products, and repeat-purchase patterns. Used CTEs, subqueries, and window functions to rank products and customers by revenue contribution. Validated transaction-level data for accuracy before building summary dashboards. Built a Power BI dashboard tracking month-over-month revenue and top product categories.
Movie Rental Analysis (Sakila Database)
June 19, 2026 – Present
Performed exploratory data analysis on a multi-table relational rental database to identify customer behavior and rental trends. Wrote join queries and window functions to surface high-frequency rental categories and customer patterns. Cross-checked output totals against source tables to catch and correct join-related duplication before finalizing results. Built an interactive Power BI dashboard with filters for store location and rental period.
SQL (Intermediate)
HackerRank
June 1, 2026 – Present
Python
Spoken Tutorial
June 1, 2026 – Present
Cultural Fit Analysis
The candidate's projects are diverse within the data analysis domain, covering retail, e-commerce, and entertainment, which indicates adaptability. The target role is 'Data', and the projects align well with a Data Analyst profile. The breadth of skills includes SQL, Excel, Power BI, and foundational Python, suggesting a willingness to learn and apply various tools. The personal nature of all projects, however, limits insight into collaborative work or experience in a corporate setting.
Soft Skills & Operational Fit
The candidate demonstrates attention to detail, time management, and the ability to work independently, as highlighted in the resume summary. The project descriptions indicate a structured approach to problem-solving, from data cleaning to reporting. However, without direct assessment, the depth of these soft skills and operational fit in a team environment cannot be fully validated.