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
Optimized Database Performance and CI/CD Automation
Optimized database performance using PostgreSQL and MongoDB, ensuring scalable and efficient data handling.
Automated CI/CD pipelines with Jenkins, Docker, and Kubernetes for rapid and reliable deployments.
Cloud Migration and Scalability
Migrated legacy systems to cloud platforms like AWS, enabling higher scalability, availability, and cost efficiency.
Ensured adherence to security best practices and minimized production downtime.
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.
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.
Automated Reporting
Creating weekly and monthly financial reports with xlsxwriter.
Integrating Excel formulas and conditional formatting via Python.
Automatically sending reports via email.
Stock and Inventory Management
Real-time stock level tracking.
Automatically updating Excel files from a database.
Automatic alerts for critical thresholds