Shariq Chohan

Freelancing

Freelancing • Freelance

Aug 2025 - Present • 9 mos

I am a motivated Data Analyst / SQL Developer with hands-on experience in designing real-world database systems, writing analytics-driven SQL queries, and building dashboards that transform raw data into actionable insights. I enjoy solving problems with data and creating clear stories that support decision-making. I have completed multiple SQL and Power BI portfolio projects, including: 🔹 Sales Analytics Database (SQL) Analyzed top-selling products, revenue trends, order patterns, and customer behavior using advanced SQL queries. 🔹 Employee Attendance & HR Analytics (SQL + ERD + Python) Built an HR attendance system to track presence, late check-ins, work patterns, and employee performance insights. 🔹 HR Attrition Analytics Dashboard (1,000,000+ Rows) – Power BI Built a complete HR Analytics dashboard using 1M+ synthetic employee records Performed deep Power Query cleaning, data modeling, and DAX measure creation Analyzed attrition by age, salary band, role, department, and experience Created KPI cards, heat maps, segmentation visuals & dynamic filters Demonstrates advanced BI reporting, modeling, and data storytelling skills 🔹 Superstore Sales Dashboard – Power BI Designed an end-to-end sales analytics dashboard Performed data cleaning, modeling & DAX calculations Delivered KPIs for Sales, Profit, Margin & Quantity Built trend charts, profit heat maps, product performance visuals & region insights Showcases strong analytical and BI visualization capabilities 🔹 Saloon Management System – Full Stack Web App (PHP + HTML/CSS/JS + SQL) Developed a complete management system with backend database workflows, authentication, and functional UI. 💡 What I Can Do ✔ Advanced SQL (Joins, Aggregations, Window Functions, Subqueries) ✔ Database Design & ERD Modeling ✔ Power BI: DAX, Data Modeling, Power Query, Dashboard Building ✔ Data Cleaning, Exploration & Visualization ✔ GitHub Project Documentation ✔ Python (Matplotlib, Pandas for charts & analysis)

Data Analyst Intern at Robaitec (SMC Private) Limited

DatacenterDynamics • Full time

Jun 2025 - Dec 2025 • 6 mos

Worked as a Data Analyst Intern/Entry Level for 6 months, gaining hands-on experience in data analysis, reporting, and database management. Responsible for handling end-to-end data processes including data collection, cleaning, validation, and transformation to ensure accuracy and consistency. Developed and optimized SQL queries for efficient data extraction and reporting. Built interactive dashboards and reports using Power BI, utilizing DAX functions to create KPIs and business insights. Performed data analysis in Excel using Pivot Tables, Lookups, and data cleaning techniques. Analyzed business and operational data to identify trends, patterns, and anomalies, supporting data-driven decision-making. Assisted in database design concepts including relational schemas, joins, aggregations, and indexing. Also contributed to improving reporting efficiency by supporting automation tasks using Excel and structured data processing methods.