Help & Supportcareers@gravityer.com
Data Analyst with 1+ years 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
Results-driven Data Analytics student with hands-on project experience in SQL data cleaning, Excel dashboard development, and Power BI reporting. Skilled in transforming raw data into actionable insights and business intelligence reports for data-driven decision making. Proficient in advanced SQL (CTES, Window Functions, ROW_NUMBER, REGEXP, STR_TO_DATE, Self Joins), Microsoft Excel (Pivot Tables, KPI dashboards, slicers), and Power BI (Power Query, DAX measures, data modelling, interactive dashboards). Completed 8+ months of remote internship experience demonstrating strong stakeholder communication, analytical thinking, and problem-solving skills. Seeking entry-level Data Analyst or Business Analyst roles in Sri Lanka or remotely.
BCAS Campus
Higher National Diploma (HND) · Software Engineering
August 1, 2023 – June 30, 2025
Internshala
QA Intern
October 1, 2024 – February 1, 2025
India
Turing
Front-End Developer Intern
June 1, 2024 – December 1, 2024
India
Power BI - Retail Sales Dashboard
January 1, 2026 – Present
Cleaned and transformed a 5-table retail sales dataset using Power Query – resolved NULLs, standardised date formats across 3 types, corrected data types, and removed inconsistencies. Built data model relationships across all 5 tables and created a dedicated KPI measures table using DAX (Total Revenue, Total Profit, Total Orders, Completed Orders, Total Customers, Total Quantity). Designed a single-page executive dashboard with 6 KPI cards, regional revenue bar chart, monthly trend line chart, top products ranking, sales rep performance, order status pie chart, and payment method analysis.
View ProjectSQL Data Cleaning - World Layoffs Dataset
January 1, 2025 – Present
Cleaned 3,982-row dataset using staging tables; removed duplicates via CTEs and ROW_NUMBER() with PARTITION BY. Resolved NULLs via self-join; standardised labels with TRIM, LIKE, UPDATE; converted dates with STR_TO_DATE(). Performed EDA: rolling totals with SUM() window function; ranked companies with GROUP BY and ORDER BY.
SQL Data Cleaning - Sales Datasets (x2)
January 1, 2025 – Present
Cleaned 10,000+ rows; improved completeness by ~18% using COALESCE; reduced 9 category variants to 3 with CASE WHEN. Executed full 6-step pipeline: deduplication, NULL handling, standardisation, type conversion, REGEXP validation. Corrected product-category mismatches across 200+ records; documented methodology for portfolio reproducibility.
Excel Dashboard - Bike Sales Customer Analysis
January 1, 2025 – Present
Engineered Age Bracket column using nested IF(); built 3 Pivot Tables for income, commute, and purchase rate analysis. Designed interactive dashboard with bar, column, and line charts; slicers for Marital Status, Region, and Education.
Excel Analytics - Sri Lanka Sales Performance
January 1, 2025 – Present
Built calculated columns (Gross_Total, Discount, Net_Total); KPI sheet using SUM, COUNTA, COUNTIF. Built 5 Pivot Tables: monthly revenue, city-wise performance, category sales, order status, payment method.
Cultural Fit Analysis
The candidate's project diversity, covering SQL, Excel, and Power BI, aligns well with a Data Analyst role. Their experience in remote internships and use of Git/GitHub indicates a readiness for collaborative and distributed work environments. The focus on practical, project-based learning suggests a proactive and results-oriented approach, which is a good cultural fit for dynamic teams.
Soft Skills & Operational Fit
The candidate demonstrates attention to detail, analytical thinking, and problem-solving skills through their project descriptions. Experience in remote internships suggests adaptability and self-management. The QA intern role highlights defect tracking and structured workflow experience, which are valuable for data quality assurance.