Data Analyst with less than a year in SQL & Power BI
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 transitioning from Mechanical Engineering, with hands-on project experience in SQL, Power BI, Python, and ETL automation. Delivered end-to-end data projects handling 10,000-50,000+ records, automated ETL pipelines improving data reliability by 30%, and built KPI dashboards enabling faster business decisions. Skilled in data visualisation, statistical analysis, stakeholder reporting, and advanced SQL - Window Functions, CTEs, CASE, and RANK.
JNTUH College of Engineering, Sultanpur
B.Tech · Mechanical Engineering
August 1, 2022 – June 30, 2025
Government Polytechnic, Kotagiri
Diploma · Mechanical Engineering
August 1, 2019 – June 30, 2022
Telangana State Model School
Secondary School Certificate
June 1, 2019 – May 31, 2019
Walmart Sales Data Analysis - End-to-End Project
April 1, 2026 – May 31, 2026
Extracted 10,000+ Walmart sales records via Kaggle API; cleansed data using Pandas - removed duplicates, corrected data types, and engineered a revenue column (unitprice × quantity). Built a PostgreSQL database, loaded data via SQLAlchemy, and solved 9 business problems using advanced SQL - Window Functions, CTEs, CASE, RANK, and EXTRACT. Identified the highest-rated product category per branch using RANK() partitioned by branch, and determined the most common payment method per branch using CTEs combined with RANK(). Categorised all transactions into Morning, Afternoon, and Evening shifts using CASE and EXTRACT(HOUR) to analyse shift-wise invoice volume and support staffing decisions. Identified the top 5 revenue-declining branches (2022 vs 2023) using dual CTEs, year-on-year JOIN, and a calculated decrease ratio - supporting strategic branch review. Published complete project on GitHub with a structured README covering business questions, SQL logic, and key insights.
View ProjectCrypto Analytics Dashboard
February 1, 2026 – March 31, 2026
Automated ETL pipelines in Microsoft Fabric with data validation checks, improving data reliability by 30% across the entire workflow. Built an interactive Power BI dashboard tracking market capitalisation, price trends, and 24-hour changes with scheduled refresh automation for near-real-time insights. Designed validation rules to detect and resolve price anomalies and missing values, maintaining audit-ready data throughout the pipeline.
View ProjectBusiness Performance Reporting Dashboard, Global Chocolate Sales Performance Dashboard
February 1, 2026 – March 31, 2026
Analysed a multi-dimensional sales dataset covering 10 sales representatives, 9 chocolate product categories, and 6 countries (UK, USA, India, Canada, Australia, New Zealand). Built an interactive Excel dashboard with KPI cards tracking total sales ($522K), total customers (27,416), headcount, and geographic reach - giving instant business visibility. Visualised customer distribution across 6 countries using a pie chart, highlighting regional customer concentration for strategic planning.
SQL Exploratory Data Analysis
January 1, 2026 – January 31, 2026
Applied RANK(), DENSE_RANK(), and ROW_NUMBER() to identify top and bottom performers across multiple dimensions; wrote multi-table JOINs and correlated subqueries to uncover hidden trends. Implemented anomaly detection and validation techniques to surface outliers and ensure data integrity prior to reporting.
SQL Analytics Certification
Databricks
June 1, 2026 – Present
Data Analytics Job Simulation
Deloitte
June 1, 2026 – Present
Cultural Fit Analysis
The candidate's project portfolio shows a strong alignment with the target role of Data Analyst, covering various aspects of data analysis, reporting, and dashboarding. The diversity of projects (Walmart sales, crypto analytics, chocolate sales) indicates adaptability and a broad interest in applying data skills to different domains. The self-initiated personal projects and certifications suggest a proactive and self-driven learning attitude, which is a positive indicator for cultural fit in a growth-oriented environment. However, the lack of team-based projects or professional experience limits the assessment of collaboration and interpersonal skills.
Soft Skills & Operational Fit
The candidate's project descriptions indicate a detail-oriented approach and a focus on delivering actionable business insights. The ability to work on end-to-end projects suggests good problem-solving and project management skills. The automation of ETL pipelines and data validation points to a proactive approach to data quality and operational efficiency. However, without direct work experience, it's difficult to fully assess collaboration, stress handling, or stakeholder communication skills.