Ashmal Irshad
Lubbock,US
Overview
3
3
years of professional experience
1
1
Certification
Work History
IT Assistant
Texas Tech University
08.2023 - Current
- Lead a team of student assistants in the planning and execution of 3D printing projects, streamlining workflows and removing bottlenecks in the projects
- Leveraged Excel to perform costs analysis of vast print data, helping in resource allocation
- Implemented SCRUM for diverse requirements of customized orders, fostering efficient project management
Database Intern
Pillar To Post Home Inspections
02.2024 - 05.2024
- Performed ETL processes of sales data, enabling insights for strategic decision making
- Optimized SQL queries to manage relationships among customer data, improving data retrieval efficiency by 19%
- Automated data extraction and analysis processes, improving the data integration and reducing processing time by 21%
Business Analyst Intern
Plego Technologies
05.2023 - 08.2023
- Integrated SQL Aggregates to transform transactional data, fostering operational effciency by 27%
- Leveraged Excel VBA to automate financial reporting processes, streamlining analysis for cross-functional teams
- Utilized Tableau to create dynamic data visualizations, helping stakeholders with informed decision making for performance metrics
Academic Tutor
South Plains College
08.2021 - 05.2023
- Applied problem-solving techniques to assist students in completing course projects, resulting in a 100% pass rate
- Conducted customized tutoring and mentoring sessions, for students helping in overall performance in course curriculum
- Tutored students about applications of MS Excel and Access enhancing proficient learning
Education
BBA - Information Technology
Texas Tech University
Lubbock, TX05.2025
Skills
- Excellent Communication
- Leadership
- Microsoft Excel
- Problem-solving skills
- Teamwork and Collaboration
- Analytical Skills
- Attention to Detail
- Data Analysis
- Data Visualization
Certification
- Data Analytics, Google
- Applied Data Science with Python
- AWS Cloud Essentials
Projects
Predictive Sales Analysis Forecasting Model
• Leveraged ARIMA to forecast sales using past data, fostering decision making
• Utilized SQL aggregates to analyze complex data, improving efficiency by 13%
• Created Visualization and within Tableau, translating complex data into actionable insights
Supply Chain Optimization
• Conducted Exploratory Data Analysis to identify correlation in the data, helping improve KPIs
• Leveraged Featured Engineering in Python to collect in the data, removing bottlenecks in the model
• Created Visualization Dashboards in Tableau, fostering in data driven decision-making
Timeline
Database Intern
Pillar To Post Home Inspections
02.2024 - 05.2024
IT Assistant
Texas Tech University
08.2023 - Current
Business Analyst Intern
Plego Technologies
05.2023 - 08.2023
Academic Tutor
South Plains College
08.2021 - 05.2023
BBA - Information Technology
Texas Tech University
- Data Analytics, Google
- Applied Data Science with Python
- AWS Cloud Essentials