Data Analyst Fresher - SQL, Power BI, Python

ABIRAYANA K

Data Analyst Fresher

Rajajinagar, Bangalore +91-843******* ***********@*****.*** linkedin.com/in/abi-rayana

PROFESSIONAL SUMMARY

Detail-oriented M.Sc. Computer Science candidate seeking an entry-level Data Analyst role. Skilled in Data Cleaning, Exploratory Data Analysis (EDA), Data Visualization, and KPI Reporting using SQL, Excel, Power BI, Python (Pandas, NumPy), and Statistics. Builds interactive dashboards that turn raw data into insights for data-driven business decisions.

EDUCATION

M.Sc. Computer Science Bharathidasan University, Tiruchirappalli 2024 – 2026

B.Sc. Computer Science Jayaraj Annapackiam College for Women, Periyakulam 2021 – 2024

EXPERIENCE

Fresher

Seeking an entry-level Data Analyst opportunity to apply my skills in Data Cleaning, SQL, Excel, Power BI, Python, and Statistics. Eager to contribute to real-time projects and build practical experience.

PROJECTS

Facial Emotion Recognition using Machine Learning with Age and Gender Prediction

• Developed a machine learning application to detect facial emotions using images and live webcam input.

• Used Python, OpenCV, TensorFlow/Keras, and CNN for image processing and classification.

• Worked with FER2013 and UTKFace datasets for emotion, age, and gender prediction.

• Applied image preprocessing techniques including resizing, grayscale conversion, and normalization.

Sales Data Analysis & Business Intelligence Dashboard

• Analyzed sales data using Excel, SQL, Python, and Power BI to identify business insights.

• Cleaned and transformed raw data by handling missing values and duplicates.

• Created interactive Power BI dashboards to track sales, revenue, profit, and product performance KPIs.

• Identified trends and top-performing products to generate insights supporting data-driven decision-making.

Restaurant Website with QR Code

• Developed a responsive restaurant website using HTML, CSS, and JavaScript.

• Implemented QR code functionality for easy access to the restaurant menu.

• Designed a simple and user-friendly interface for browsing food items.

TECHNICAL SKILLS

Data Analysis: Data Preprocessing, Exploratory Data Analysis (EDA), Data Visualization, Identifying Trends, KPI Reporting, Generating Insights

Data Cleaning: Handling Missing Values, Removing Duplicates, Correcting Inconsistent Data, Data Formatting, Data Validation

Excel: VLOOKUP, XLOOKUP, Pivot Tables, IF Formulas, SUMIFS, COUNTIFS, Conditional Formatting, Data Sorting & Filtering

SQL: SELECT, WHERE, GROUP BY, ORDER BY, JOINs, Subqueries, Aggregate Functions, Basic CTEs

Power BI: Interactive Dashboards, Data Visualization, Power Query, Data Transformation, Basic DAX

Python: Pandas, NumPy, Data Manipulation, Data Cleaning, Exploratory Data Analysis (EDA)

Statistics: Descriptive Statistics, Mean, Median, Mode, Standard Deviation, Correlation

Reporting: Dashboard Reporting, MIS Reports, Presenting Data-Driven Insights

Others: MS Office

ADDITIONAL SKILLS

Analytical Thinking • Problem Solving • Communication Skills • Teamwork

CERTIFICATIONS

• Python Course — Udemy

• Machine Learning Course — Coursera

LANGUAGES

Tamil, English

Contact this candidate