Ali Mehdi
Data Analyst
Indore
Summary
Professional data analyst with experience in data collection, analysis, and visualization. Skilled in SQL, Power BI, Power Apps and Excel, with strong focus on deriving actionable insights and optimizing processes. Known for effective collaboration within teams and adapting to changing project needs. Reliable and results-driven with passion for leveraging data to drive decision-making and business growth.
Overview
10
10
years of professional experience
4
4
Certifications
2
2
Languages
Work History
Jr. Data Analyst
VCREATEK CONSULTING SERVICES PVT LTD
05.2023 - Current
- Connected to diverse data sources including Excel, SharePoint, SQL Server, and CSV file for data extraction and integration.
- Performed data cleansing and transformation using Power Query and SQL, improving dataset accuracy and usability.
- Designed and maintained data models in Power BI using star schema and relationship management best practices.
- Leveraged DAX formulas to create custom measures, calculated columns, and time intelligence functions to enhance data analysis and reporting.
- Developed interactive dashboards and reports in Power BI with DAX calculations for KPIs, trends, and comparative analysis.
- Automated ETL workflows for recurring reports, reducing manual effort by 60%.
- Collaborated with cross-functional teams to understand business requirements and translate them into data solutions.
- Conducted performance tuning of SQL queries and Power BI data models to optimize report refresh and load times.
- Ensured data governance and validation by implementing rules for data quality, filtering, and anomaly detection.
Junior Network Engineer
Netlink Software Pvt. Ltd.
01.2015 - 01.2017
- Provided network support and troubleshooting to ensure optimal performance.
- Worked with cross-functional teams to improve network infrastructure.
- Managed IP address allocation within the organization's LAN/WAN environments using DHCP best practices efficiently.
Education
Bachelor's degree - Computer Science Engineering
RGPV
Indore, Madhya PradeshSkills
- SQL
- Power BI
- Power Apps
- Excel
- DAX formulas
- Data modeling
- Data visualization
- ETL processes
- Data integration
- Data cleaning
- Data analysis
Certification
Microsoft Power BI, Udemy, Comprehensive training on data visualization and dashboard creation.
Timeline
Jr. Data Analyst
VCREATEK CONSULTING SERVICES PVT LTD
05.2023 - Current
Junior Network Engineer
Netlink Software Pvt. Ltd.
01.2015 - 01.2017
Bachelor's degree - Computer Science Engineering
RGPV
Similar Profiles
Mahipal VemulaMahipal Vemula
Data Analyst at VCREATEK CONSULTING SERVICES PVT LTDData Analyst at VCREATEK CONSULTING SERVICES PVT LTD
Pradeep AnandrajPradeep Anandraj
Sr. Project Manager at vCreaTek Consulting Services Pvt LtdSr. Project Manager at vCreaTek Consulting Services Pvt Ltd
Sharath Chandra KujalaSharath Chandra Kujala
Senior Business Analyst at IndraSur Consulting Services, Pvt. Ltd (Akytech Consulting LLC & ProGov Partners LLC)Senior Business Analyst at IndraSur Consulting Services, Pvt. Ltd (Akytech Consulting LLC & ProGov Partners LLC)
Akhilesh PatidarAkhilesh Patidar
Service Engineer at Safew Tech SystemsService Engineer at Safew Tech Systems
Pranshu SoniPranshu Soni
Application Development Analyst at Accenture Solutions Pvt. Ltd.Application Development Analyst at Accenture Solutions Pvt. Ltd.