Mahesh Rathod

Overall, my three years of work experience as a data analyst have equipped me with the skills, knowledge, and expertise to tackle challenging analytical tasks and contribute positively to organizational success. I am passionate about leveraging data-driven insights to solve problems and drive innovation, and I am eager to continue growing and making meaningful contributions in the field of data analysis.

E-commerce Sales Data :

• Data Collection and Preparation: Collected sales data and cleaned with ensuring accuracy and consistency. This involved data cleaning, transformation, and integration to create a unified dataset for analysis.
• Exploratory Data Analysis (EDA): Employing Python libraries such as Pandas, NumPy,and Matplotlib, I conducted in-depth EDA to uncover trends, patterns, and anomalies within the sales data. Through visualization techniques, I identified key performance indicators, seasonality trends, and customer segmentation.
• Insights Delivery: I crafted comprehensive reports and dashboards using tools like Jupyter Notebooks and Matplotlib& Seaborn to communicate actionable insights to stakeholders. These insights informed strategic decisions and drove revenue growth initiatives across the organization.
• Creating effective report using various tool and get reports on Products wise data and Gender wise data.

Bank Loan Analytics Dashboard :

• Use SQL queries to retrieve loan data from the bank's database.
• Data Cleaning and Preparation: Cleanse the loan data to ensure accuracy and consistency. This involves tasks such as handling missing values, standardizing formats, and removing duplicates or outliers.
• Portfolio Analysis: Analyze loan portfolios to assess performance metrics such as total loan volume, average loan size, distribution of loan types.
• Performance Monitoring: Track key performance indicators (KPIs) such as loan repayment rates, profitability, and portfolio turnover using SQL queries. Monitor changes in performance metrics over time and identify areas for improvement or optimization.
• After cleaning data i am created dashboard using Power BI.
• Primary objective of detail dashboard is to provide a comprehensive and user-free accesing vital loan data to customer.

• Machine Learning with Python to Deep Learning By MIT University (05/2023)