Looking for a job

Shivam Dhama

@shivamdhama

Data Analyst intern at Safex Chemicals who analyzed business data and built end-to-end sales and customer-retention analytics projects.

India

Message

At Safex Chemicals, I analyzed business data using SQL, Python, and Excel to support operational and management decisions. I also cleaned and validated datasets and prepared reports and dashboards for stakeholder review.

In my analytics projects, I built a sales-performance dataset and analyzed more than 1M e-commerce transactions for customer retention, cohorts, and RFM segments. I used SQL, Python, and Power BI to explore the data, create dashboards, and document business insights.

Experience

Work history, roles, and key accomplishments

Data Analyst Intern

Safex Chemicals

May 2026 - Jul 2026 (2 months)

Analyzed business data using SQL, Python and Excel to generate insights supporting operational and management decision-making. Cleaned, validated and structured datasets to ensure accuracy and consistency for reporting and KPI tracking.

SQL Python Excel Data Cleaning Data Validation KPI Reporting Reporting Dashboarding

Cybersecurity Research Intern

NCFL

Jun 2025 - Aug 2025 (2 months)

Researched Snapchat data storage and message accessibility, including view-once media and deleted content, using an investigative model. Analyzed extracted datasets to assess availability and recoverability of digital information.

Cybersecurity Data Analysis Research Documentation Digital Forensics

Public Relations Manager

Moksha NSUT & Resonanz NSUT

Led PR and marketing for large-scale campus events, driving participation from 1.5+ lakh attendees. Coordinated 150+ team members across sponsors, artists, vendors and institutional stakeholders.

Public Relations Marketing Event Management Stakeholder Management Team Coordination