Aliraja Ansari

Data Analytics Intern

Surampalem, Andhra Pradesh, IndiaData Analytics and Business Intelligence
2roles
24skills
1education
5credentials

About

Computer Science Engineering graduate with hands-on experience in Python, SQL, Power BI, Tableau, Excel, data cleaning, exploratory data analysis, dashboard development, KPI reporting, customer segmentation, and business intelligence.

Experience

Data Analytics Intern

SmartBridge (APSCHE)

Six months

Completed a six-month internship focused on Tableau, Excel, and data analytics; cleaned and validated datasets, performed exploratory data analysis, created dashboards, documented findings, and presented actionable business insights.

Virtual Job Simulations

Deloitte Australia & Tata (Forage)

Completed analytics, visualization, and business insight projects using realistic datasets; developed dashboards and communicated recommendations through data storytelling.

Education

Aditya College of Engineering and Technology

Bachelor of Technology, Computer Science Engineering

April 2026

CGPA: 8.35/10. Relevant coursework: Database Management Systems, Statistics, Data Structures, Data Mining, Data Visualization, Machine Learning Fundamentals.

Skills

PythonPandasNumPySQLMySQLData CleaningData ValidationData ProcessingExploratory Data Analysis (EDA)Data VisualizationBusiness IntelligenceKPI ReportingRFM AnalysisPareto AnalysisReportingPower BITableauMicrosoft ExcelGoogle SheetsGoogle WorkspaceGitGitHubJupyter NotebookVS Code

Projects

Retail Sales & Customer Insights Dashboard

Cleaned and analyzed retail transaction data using Python and SQL; performed RFM analysis to segment customers and identify high-value groups; evaluated revenue trends, customer behavior, and product performance; designed an interactive Power BI dashboard with KPIs to support business decisions.

Restaurant Sales & Demand Analysis

Analyzed 21,000+ transactions generating $817K+ revenue; used joins, CTEs, window functions, and aggregate queries to uncover insights; identified top-selling products, peak sales hours, and demand patterns; applied Pareto analysis to prioritize high-impact revenue drivers.

Mobile Sales Dashboard

Built an interactive Power BI dashboard tracking sales, revenue, profit, and year-over-year growth; implemented KPI cards, filters, and drill-through reports for business reporting.