Passionate about data science and automation, I specialize in using Python to manipulate, analyze, and automate complex Excel tasks. My expertise includes data processing, visualization, and generating dynamic reports.
Technical Skills
Handling Excel files with pandas and openpyxl
Automating Excel tasks with pywin32 and xlsxwriter
Data analysis with NumPy and pandas
Advanced visualization with Matplotlib and Seaborn
Generating reports and dynamic dashboards
Replacing VBA macros with Python scripts
Completed Projects
1. Automation of Excel Data Processing
Extracting and cleaning data from multiple Excel files.
Automatically merging multiple Excel sheets into a consolidated file.
Saving data in Excel, CSV, and PDF formats.
2. Sales Analysis and Visualization
Processing thousands of sales records with pandas.
Analyzing sales trends and calculating KPIs (revenue, margin, growth rate).
Generating interactive charts for a dynamic dashboard.
3. Automated Reporting
Creating weekly and monthly financial reports with xlsxwriter.
Integrating Excel formulas and conditional formatting via Python.
Automatically sending reports via email.
4. Stock and Inventory Management
Real-time stock level tracking.
Automatically updating Excel files from a database.
Automatic alerts for critical thresholds.