Sumer Pasha 1sumer

🌐 Portfolio

Explore my projects and achievements on my

🔭 Currently working at Analogica Software Development Pvt Ltd as a Data Analyst & Python Automation Engineer.
🌱 Currently exploring advanced Machine Learing.
👯 Open to collaborating on Data Analytics, Python Automation, ETL Pipeline Development and Macine Learning projects.
💬 Ask me about Python, SQL, R, Data Visualization(Power BI), and Machine Learning.
📫 Reach me at: [email protected]

Languages: Python, SQL, R
Programming & Automation: Python (Pandas, Numpy, PySpark, Regex).
Data Analysis & Visualization: Excel, Power BI, Exploratory Data Analysis (EDA), Matplotlib, Seaborn, Pandas
Statistical Analysis: Probability Distributions, Inferential Statistics, Regression Analysis, Hypothesis Testing
Data Management: MySQL, MongoDB, ETL Processes, Data Cleaning, Data Modeling
Business Intelligence: Dashboard Creation, Reporting, and KPI Monitoring.
Tools & Technologies: Git, GitHub, Jupyter Notebooks, VS Code.
Automation: Python Automation, GUI (Tkinter), Email Automation (SMTP), Web Scraping (BeautifulSoup, Selenium)
Machine Learning: Supervised & Unsupervised Learning, Scikit-Learn.
Cloud & Big Data: AWS (S3, Athena, Glue), Apache Spark
Soft skills: problem-solving, analytical thinking, and team collaboration.

Bachelor of Engineering (Mechanical) – R L Jalappa Institute of Technology, Doddaballapur (2016–2020)
PUC (PCMB) – Poorna Prajna P U College, Chickballapur (2014–2016)

Tools Used: SQL Server, Python (pandas, matplotlib, seaborn)
Performed end-to-end analysis of a pizza chain's sales data to uncover business insights around revenue, customer behavior, and product performance.
Integrated SQL Server with Python for seamless data extraction and transformation using pandas.
Wrote advanced SQL queries (joins, CTEs, subqueries, aggregations) to analyze time-based trends, top products, and ingredient segmentation.
Visualized key metrics using matplotlib and seaborn (e.g., peak sales hours, daily/weekly patterns, top categories).
Delivered actionable insights through Python-driven reports and charts, supporting strategic decisions for marketing and operations.

Tools Used: Power BI, DAX
Designed and developed interactive Power BI dashboards to analyze hotel performance across revenue, ratings, bookings, and occupancy.
Created calculated columns and measures using DAX for KPIs such as revenue generated vs. realized, occupancy rate, cancellation rate, and average rating.
Segmented performance analysis by hotel category, city, room type, booking platform, and day type to identify top-performing segments and areas for improvement.
Delivered actionable insights that supported strategic decisions in pricing, marketing, and operational planning.

Tools Used: Python, Tkinter, Pandas, scikit-learn, Numpy, Flask, Render
Developed a Flask-based web application that predicts the optimal crop to grow based on soil and weather conditions and recommends the right fertilizer for a healthier yield using a Random Forest Classifier.
Implemented a machine learning model integrated with a Python backend and deployed the solution on Render Cloud.
Planned future enhancements include integrating a real-time weather API for dynamic predictions, deploying on AWS SageMaker for scalability, and expanding to a mobile app version.
Live App: agriculture-pridiction.onrender.com | GitHub Repo: github.com/1sumer/Agriculture_Pridiction.

Tools Used: Python, MySQL, Tkinter, Pandas
Developed a Python-based invoicing system that collects transaction data and stores it in MySQL for analysis.
Automated invoice generation, improving accuracy and reducing manual errors by 30%.
Performed customer behavior analysis to derive actionable insights for sales optimization.

Tools Used: SQL, Python, Power BI, Pandas, NumPy
Analyzed sales and shipping dynamics to improve profitability and operational efficiency.
Built Power BI dashboards to identify trends, top-performing regions, and customer segments.

Tools Used: Python (BeautifulSoup, Pandas), Power BI
Scraped product data from e-commerce platforms to identify pricing trends and market positioning.
Generated reports that informed competitive strategy formulation.