Back to Developers
Hema S

Hema S

Data Analyst

Bengaluru -560023
85
Profile Score

About

Detail-oriented BBA graduate with hands-on experience in Excel, VBA macros, Tableau/Power BI, SQL, and Python. Combines a strong business foundation with analytical skills to transform raw data into actionable insights that support decision-making. Eager to contribute to a data-driven organization as an entry-level Data Analyst.

Skills & Expertise (18)

Power BI Advanced
8.0/10
1
Years Exp
SQL Intermediate
6.4/10
1
Years Exp
Python Intermediate
6.4/10
1
Years Exp
DAX VBA Data Validation ETL Data Cleaning Canva NotebookLM Claude DeepAi ChatGPT Power Query Editor Macros VLOOKUP Pivot Tables Ms. Excel

Work Experience

Data-Driven Marketing Intern

SLN Communication

Jan 2024 - Feb 2024

Collaborated with cross-functional teams to resolve customer issues and ensure data accuracy. Supported creation of a new service package and marketing strategy, increasing user engagement by 15%. Optimized customer service workflows, resulting in a 10% improvement in satisfaction scores.

Junior Executive - Data Analyst

Unknown

Aug 2025 - Present

Performed product and SKU-level DOH, sales, and inventory analysis to support stock planning decisions. Developed a size brokenness and live size tracking system using advanced Excel formulas (SUMIFS, IF, IFERROR, TEXTJOIN, logical functions). Built a dynamic Weekly Sales Dashboard covering product performance, inventory status, and NOS tracking using Pivot Tables. Automated reporting and interactive charts using VBA Macros, improving efficiency and reducing manual effort. Utilized Power Query (ETL) to clean and transform raw sales data for structured reporting and analysis.

Data Analyst Intern

ITech Analytic Solutions

Apr 2025 - Jun 2025

Developed and deployed interactive dashboards in Power BI and using real-time business data. Automated Excel-based reports using VBA, reducing reporting turnaround time by 25%. Cleaned and transformed large datasets using Power Query, improving data quality by 30%. Conducted sales Analysis using Excel and visual charts.

Education

Bachelor of Business Administration (BBA) - MES Institute of Management, BCU

2021 - 2024 · Afghanistan

Certifications

Data Analytics & Reporting

ITech Analytic Solutions · 2025

Microsoft Excel Specialist (MO-200)

Microsoft · 2024

Diploma in Computer Applications

BALC Academy · 2021

CTTC

BALC Academy · 2021

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 5/5
Verified 5/5
Total Score 85/100

Profile Overview

Member sinceMar 2026

Skills (18)

Power BI SQL Python DAX VBA Data Validation ETL Data Cleaning Canva NotebookLM +8 more