Summary
Work History
Education
Skills
Technical Certifications
Technical Core Competencies
Timeline
IRSHAD AHMAD

IRSHAD AHMAD

MIS & Data Analyst
Delhi

Summary

Results-driven Data Analyst Intern at Tag Vacation Club, adept at leveraging SQL for data extraction and employing MS Excel for optimized reporting. Achieved a 30% reduction in manual data entry time while delivering actionable insights through Power BI dashboards. Strong analytical skills complemented by effective communication to support senior management in decision-making.

Work History

Data Analyst Intern

Tag Vacation Club
  • Created and maintained Power BI dashboards to track real-time sales performance and customer engagement metrics.
  • Optimized daily and weekly MIS reporting in Excel, reducing manual data entry time by 30%.
  • Utilized SQL queries to extract, clean, and validate data from internal databases, ensuring 100% accuracy.
  • Prepared detailed performance reports for senior management to assist in regional operational decision-making.

Education

Class X (High School) - General Studies

Smt. Kailashi DHSS, Akchhaya, Azamgarh, Azamgarh, Uttar Pradesh, India

Bachelor of Arts (B.A.) - Geography

Dr. Ram Manohar Lohia Avadh University
01.2016

Class XII (Intermediate) - Humanities

S.V.N.I.C., Jaitpur, Ambedkar Nagar, Ambedkar Nagar, Uttar Pradesh, India
06.2013

Skills

MS Excel (VLOOKUP/XLOOKUP, Pivot Table)

Technical Certifications

  • DCA (Diploma in Computer Applications), Venus Computer Institute, 2013
  • Diploma in Computer Hardware, Networld Inspiration Technology, 2014

Technical Core Competencies

Power BI, Tableau, Advanced Excel Dashboards, Pivot Tables, VLOOKUP, HLOOKUP, Power Query, Data Validation, SQL (Queries, Joins, Data Extraction), MS Access, ETL Fundamentals, Data Cleaning, Trend Analysis, Professional Typing Speed (30 WPM), Analytical Thinking, Problem Solving

Timeline

Data Analyst Intern - Tag Vacation Club
Dr. Ram Manohar Lohia Avadh University - Bachelor of Arts (B.A.), Geography
Smt. Kailashi DHSS, Akchhaya, Azamgarh - Class X (High School), General Studies
S.V.N.I.C., Jaitpur, Ambedkar Nagar - Class XII (Intermediate), Humanities
IRSHAD AHMADMIS & Data Analyst