Yoga
Vishwa Ahir - Data Analyst
Bengaluru
Summary
Detail-oriented Data Analyst with a passion for analyzing data, I am eager to apply data analytical skills, statistical skills, and passion for data to contribute effectively to data analysis projects. Proficient in Microsoft Excel, SQL, Power BI, and Tableau with a proven track record of effectively monitoring key performance metrics, collaborating with cross-functional teams, and driving data-informed decision-making processes.
Overview
3
3
years of professional experience
1
1
Certification
2
2
Languages
Work History
Data Analyst Internship
Ai Variant
06.2023 - 03.2024
- Developed interactive Tableau, Power BI and Excel dashboard and reports visualizing key performance indicators (KPI) reporting and Metrics for various departments within the organization
- Conducted the data extraction, transformation and loading (ETL) processes using SQL and Excel Power Query
- Designed and implemented the data models including creating the relationships, creating the calculated columns and tables with the help of complex DAX expressions in Power BI
- Automated various reporting and analytical tasks using excel and query, reducing manual data processing time by 30%.
- Developed trend analysis reports to provide actionable insights for strategic decision-making processes.
Software Developer
Anakage Technologies Private Limited
07.2021 - 07.2023
- Designed and implemented various web-based applications for clients using html, css and bootstrap
- Developed and optimized SQL queries, reducing query execution time by 30% and enhancing overall database performance
- Conducted complex data analysis using advanced software tools such as Excel
- Adapted to new technologies and project requirements quickly, demonstrating strong learning and problem-solving skills.
Education
Bachelor of Science - Computer Engineering
LDRP Institute of Technology & Research
Gandhinagar, Gujarat05.2020
Skills
- MS-Excel
- Power BI
- SQL
- Tableau
- Data Analysis
- Data Visualization
- Python
Additional Information
HR Analysis Report
- Collected and analyzed data on total employees, male, and female counts, and percentage of persons in service and retrenched.
- Examined overtime disparities among male employees and explored gender differences between level 4 and level 5 employees.
- Analyzed HR department data using SQL, Tableau, Power BI and Excel, Python leveraging Power Query for data transformation.
- Identified areas for improvement to enhance HR efficiency, effectiveness, and data-driven decision-making.
- Implemented BI tools to create reports that save 3-4 hours of daily work for the HR department.
Olist Store Analysis
- Developed interactive dashboards in Power BI, Tableau, and Excel to provide comprehensive insights into various aspects of the Olist store operations. Gathered and preprocessed data from 9 diverse CSV files, totaling 45 MB, to ensure accuracy.
- Wrote SQL queries to extract and transform data, ensuring accurate and timely analysis of diverse datasets.
- Designed and created 5 visualizations, highlighting aspects like Weekday vs. Weekend Payment Statistics and more.
- Emphasized KPIs such as Average Price, Payment Values, and Review Scores to facilitate strategic analysis.
- Presented actionable insights, with the aim of enhancing overall performance and strategies for the Olist store.
Certification
- Data Analyst - ExcelR Solution
- Data Analyst Internship – Ai variant
- Power BI Virtual Case Experience – Forage
- Fundamentals of Data Analysis in Excel – Corporate Finance Institute
Interests
Dancing
Timeline
Data Analyst Internship
Ai Variant
06.2023 - 03.2024
Software Developer
Anakage Technologies Private Limited
07.2021 - 07.2023
Bachelor of Science - Computer Engineering
LDRP Institute of Technology & Research
Similar Profiles
SUJEET KUMARSUJEET KUMAR
Data Analyst Intern at AI VariantData Analyst Intern at AI Variant
ASISH NANDANAASISH NANDANA
Data Analyst Intern at AI VariantData Analyst Intern at AI Variant
Kailash TalkarKailash Talkar
Data Analyst Intern at AI VARIANTData Analyst Intern at AI VARIANT
Jyoti DixitJyoti Dixit
Data Analyst Intern at AI VariantData Analyst Intern at AI Variant
Keshav PushadappuKeshav Pushadappu
Community Specialist at G2.com Private LimitedCommunity Specialist at G2.com Private Limited