Muhammad Waqar

1. Customer Model 360 (Data Warehouse): - Data cleaning and duplication removal using MySQL, and Python. - Developed MySQL view to track change by each customer. - Developed Python scripts and scheduled them using Airflow. 2. Customer 360 Dashboard (Power BI): - Developed Interactive Power BI dashboard with MySQL on-premises connector. 3. Application Notification Automation: - Developed Python scripts with MySQL connection to get a chunk of consumers. - Used Apache Airflow for notifications schedule.

- Developed dashboards using Microsoft Power BI and advanced Excel, providing company-wide access to collected data. - Transformed data using Python, Power BI, and advanced Excel. - Produced daily, weekly, and monthly reports using advanced Excel spreadsheet and Microsoft Power BI functions. - Corrected any data entry error to prevent later issues such as duplication etc.

1. Website Classifier: - Scrape websites for data collection using the Scrapy library. - Data cleaning using re, nltk (stop words, Stemmer, Lemmatizer) libraries. - Data pre-processing using tokenizer, pad_sequences libraries. - Developed a Website Classifier model using a machine learning algorithm (SVM). - Developed API using Flask for Website Classification through URL.

- Tested Application Link: https://app.conflee.de/ - Responsible for manual testing PWA (Progressive Web App) using different test cases including responsiveness and functionality of PWA featuring rent a car. - Developed and executed QA test cases, and scripts. - Evaluated function, performance, and design compliance of every product against design standards and customer needs. - Identified and tracked defects with PWA and supported developers in resolving problems by completing additional tests.