Aniket Sonawane

• The Data Analyst Course: Complete Data Analyst Bootcamp.(Udemy)
• SQL – Microsoft SQL for Beginners.(Udemy)
• Python for Data Science and Machine Learning Bootcamp.(Udemy)

Project Work Experience

Client: WPP-OPEN

Project description:

• Developed a comprehensive Marketing Mix Model to analyse the impact of various marketing channels (e.g., TV, radio, digital ads, social media, etc.) on sales and ROI.
• Utilized time-series data to forecast marketing performance and optimize budget allocation.

Tools/ Technologies:

• Python scikit-learn (for modeling and data processing)
• SQL (for data extraction)
• Tableau (for visualization)
• Excel (for budget analysis)

Roles and responsibilities:

• Gathered, cleaned, and processed large datasets using pandas from multiple sources, including marketing spend, sales data, and external factors (e.g., seasonality, economic trends).
• Developed and validated regression-based models using scikit-learn to estimate the impact of marketing channels.
• Optimized model performance with hyper parameter tuning using regularization techniques like Ridge and Lasso.
• Forecasted marketing performance and analysed trends using Facebook Prophet for time-series forecasting.
• Visualized data and insights using matplotlib and seaborn, creating clear, actionable dashboards.

2. Face Recognition System (POC)

Technologies: Python, OpenCV, Scikit-learn, TensorFlow

Project description:

The Face Recognition System Project aims to create a robust and accurate facial recognition system capable of identifying and verifying individuals based on their unique facial features. This project will utilize deep learning and machine learning techniques to detect and match facial pattern.

Roles and responsibilities:

• Understand the flow of Image Processing
• Understanding and implementing OpenCV
• Learning Face detection Algorithms
• Data cleaning
• Comparing Faces with Deep face

3. Cricket Match Analysis and Data Warehouse Development(POC)

Technology: Snowflake, Python, SQL, JSON, Power BI

Objective: Build a data warehouse to analyze cricket match data, converting raw JSON data into a structured format and providing insights based on various match statistics.

Roles and Responsibilities:

• Data Extraction & Transformation: Collected raw cricket match data in JSON format and used Python scripts to parse and transform the data into structured tables, including player stats, match details, and score breakdowns.
• Data Warehouse Design: Designed and implemented a data warehouse in Snowflake based on the business requirements, organizing data into fact and dimension tables to facilitate efficient querying and reporting.
• SQL Query Development: Wrote complex SQL queries to generate insights such as player performance, team comparison, match outcomes, and win probabilities based on historical data.
• Visualization & Reporting: Created Power BI dashboards to visualize key cricket metrics, such as player performance trends, match-winning patterns, and team statistics. Enabled stakeholders to explore match outcomes and player comparisons interactively.
• Business Impact: Provided the business with a data-driven approach for evaluating player performances and match strategies, allowing them to make more informed decisions in future cricket campaigns.

4. Cybage Training Project

SkyHeights – Online Flight Ticket Booking

Technology: Angular, Spring-Boot, MySQL

Project description:

It is web-based application of online flight reservation system. There are two major roles in our application, Admin and User. Both admin and user can login using OTP via email. After successful login, user can search, view, book flight tickets and can cancel previous bookings also. A user can edit profile, give feedback and make a complaint for previous bookings. Admin can add, update, delete flights and also add and delete flight offers. Admin can view all the complaints and can act on complaints.

Roles and responsibilities:

• Gathered project requirements
• Implemented Admin Part
• Designed Database