About Me
Data Analyst with hands-on experience in SQL, Python, Power BI, MySQL, and Advanced Excel, specializing in data visualization, dashboard development, data cleaning, and business reporting to drive data-driven decisions.
Skills & Technologies
Work Experience
Data Analyst – SEO Team
Analyzed and visualized real estate datasets of 5,000–20,000 property records using Python (Matplotlib) and Advanced Excel to identify trends and support business decisions. Developed automated Excel reports and interactive dashboards using Pivot Tables, XLOOKUP, Conditional Formatting, and Python, reducing manual reporting effort and enhancing operational efficiency.
Data Research Intern – SEO Team
Maintained and verified 5,000–20,000 property listings ensuring data accuracy for SEO and business operations. Organized and analyzed datasets using Advanced Excel features like Pivot Tables, XLOOKUP, and Conditional Formatting to improve data quality and reporting.
Projects
Sales Management Banking Dashboard
Developed an interactive Power BI dashboard analyzing regional sales performance across multiple business units. Created DAX measures to monitor KPIs, sales trends, and incentive performance. Built dynamic reports with slicers, drill-through, and conditional formatting for quarterly performance analysis by business users.
Hospital-Patient Data Management System
Designed a normalized relational database with 5 MySQL tables using primary and foreign key constraints. Developed 8 modular Python applications using mysql-connector-python for patient management and billing automation. Connected MySQL to Power BI for interactive dashboards on admissions, billing trends, and doctor workload analysis.
MIS Reporting for Bank
Built a multi-sheet MIS reporting solution in Excel automating financial reporting using SUMIFS, Goal Seek, Pivot Tables and Macros. Created interactive dashboards using Pivot Charts and Conditional Formatting to support financial decision-making.
Education
B.E.
Information Science Engineering