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
Bachelor of Arts (B.A.) - Geography
01.2016
Class XII (Intermediate) - Humanities
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