Overview
Hello! I’m Aman Bana, a passionate Data Analyst with over two years of experience in leveraging data to drive business insights and improvements. My journey in data analysis has equipped me with a robust skill set in SQL, Power BI, Python, Excel, and data governance, allowing me to tackle complex data challenges with confidence.
Professional Background:
I have had the privilege of working on diverse projects that span various domains, including real estate, social media, and the banking sector. My role as a Data Analyst involves analyzing complex data sets, creating impactful visualizations, and ensuring data quality and integrity. Notably, I have received the Star Performer of the Quarter Award for Q1 2024, recognizing my outstanding performance and contributions.
Skills and Expertise:
- Languages: Python, SQL, HTML
- Python: Pandas, NumPy, Matplotlib, Seaborn, BeautifulSoup
- SQL: Create, Alter, Insert, Select, Update, Merge, Drop, Truncate, Delete, Joins, CTE, Temp Tables, Indexes, Windows Functions, Aggregate Functions, Views, Stored Procedures
- Excel: Pivot tables, formulas (V-Lookup and others), data validation, and conditional formatting
- Databases: SQL Server, MySQL, MS Access
- BI Tools: Tableau, Power BI
- Data Analytics Skills: Data Analysis, Data Visualization, Data Modeling, Data Cleaning, Data Transformation, Data Wrangling, Data Quality
- Documentation Tools: JIRA
- Other: GitHub, API
- Soft Skills: Clear Communication, Data Presentation, Team Collaboration, Team Leadership
Notable Projects:
- YouTube Channel Performance Analysis Using Python: Analyzed YouTube channel playlists to gain insights into subscriber counts, total views, and video uploads. Utilized the YouTube Data API, pandas, and seaborn to handle data and create visualizations.
- Power BI Projects:
- Revenue Forecasting and Top Distributor Analysis: Created visualizations to forecast revenue and identify top distributors in the region, aiding strategic planning and decision-making.
- Employee Analysis: Analyzed employee data to determine average satisfaction rates, age group distributions, and the relationship between promotions and employee turnover.
- SQL Data Exploration:
- Data Clinic Analysis: Performed various SQL queries, including joins, window functions, and aggregate functions, to analyze clinic data. Identified patients with the highest outstanding bills, prevalent diseases in different regions, and other critical insights.
Achievements:
- Star Performer Award: Received the Star Performer of the Quarter Award for Q1 2024 in my current role, recognizing outstanding performance and contributions to the team.
- Two of Business Correspondent were conferred Best BC in overall performance in all Surat District Region.
Education
Dr K N Modi University, Bachelor of Technology - Automobile, Rajasthan, India, April 2013 - June 2017