About Me
Entry Level Data Analyst with a Finance and Accounting foundation and hands-on proficiency in Python, SQL, Power BI, and Advanced Excel. Experienced in data cleaning, exploratory data analysis, reporting, and interactive dashboard development, translating KPIs into clear, decision-ready insights for non-technical stakeholders. Skilled in statistical analysis, forecasting, data validation, and reporting across inventory, sales, and financial datasets, with a strong focus on data accuracy and integrity. Seeking a data analyst role where analytical skills can drive meaningful business insights and decisions.
Skills & Technologies
Work Experience
Data Analyst Intern
Processed 400K+ village-level records across 30+ datasets using Python and Pandas for data cleaning, transformation, and validation. Queried and structured data with MySQL for large-scale geographic analysis ensuring accuracy. Designed and deployed an interactive Power BI dashboard visualizing state-wise insights to highlight regional trends and patterns.
Sales Operations Analyst
Analyzed multi-year sales and inventory data in Excel to identify trends guiding buying decisions and merchandise planning. Developed Excel reporting models with Pivot Tables and XLOOKUP reducing manual reporting time and accelerating sales reviews. Recognized slow-moving SKUs recommending markdowns improving inventory and gross margin. Collaborated with ownership to align stock levels with seasonal demand through promotional calendars.
Accountant
Reconciled financial records ensuring zero discrepancies in monthly close cycles. Automated financial reports in Excel reducing preparation time and enabling faster management review.
Projects
Metal Futures Analysis
Analyzed historical price data for multiple metals to identify price trends and market patterns. Cleaned and combined datasets, handled missing values, and performed exploratory and statistical analysis. Created visualizations including line charts, histograms, boxplots, scatter plots, and heatmaps to analyze price trends, volatility, and correlations. Used analysis to support procurement-related insights about copper demand.
Pharmaceutical Inventory Analysis
Cleaned and integrated inventory data from multiple sources using Python and SQL. Analyzed stock levels, inventory turnover, demand patterns, and categorized products by speed of movement. Built demand forecasting to identify overstock risks and inventory needs. Created Power BI dashboard to track inventory KPIs and stock movement.
E-commerce Sales Analysis
Cleaned and analyzed e-commerce sales data to understand revenue, product categories, customer purchasing patterns, and sales performance. Performed exploratory data analysis identifying monthly trends, location-based sales, payment preferences, and demographics. Created visualizations using Matplotlib and Seaborn to support sales, marketing, and customer experience decisions.
Education
Bachelor of Commerce (B.Com)
Accounting and Finance