Sahil Bhore
Mumbai
Summary
Proactive and insightful professional with strong skills in Python and data analysis, specializing in pandas, seeking a Data Analyst role. Eager to leverage expertise in Python and pandas, along with strong problem-solving abilities, to drive data-driven decision-making and support business objectives.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Data Analyst
Green Cell Mobility Pvt .Ltd
Mumbai
10.2023 - Current
Data Analyst
Greencell Mobility Pvt. Ltd.
Mumbai
10.2023 - Current
- Overall 2 Years of professional experience as Data Analyst.
- Well-versed with Handling Elements in Python pandas.
- Web scrapping from various sites to create the competition data.
- Proficient in data cleansing, transformation, and integration using Pandas.
- Data Analysis for Marketing, Sales and RA.
- Optimized Power BI reports were developed by a previous developer by implementing incremental refresh, and moving certain filtering logic from Power BI to the SQL query.
- Efficient in data retrieval and manipulation using Python.
- Perform back-end data validation on the target table regarding transformations.
- Duplicate. Null value. Data types. Data Info. Length, and Exploratory data analysis using and PYTHON.
- Automated marketing analytics using Python, including repeat ratio analysis and customer segmentation reports (B2C, B2G, install/uninstall percentages) to improve customer retention.
- Data analysis using Pandas, NumPy.
- Imported Data from SQL and Azure Servers.
Education
B.sc - Information Technology
Kirti college, Mumbai university
Mumbai01.2023
HSC - Science
Kirti M Doongursee College
Mumbai, Maharashtra01.2019
SSC -
IES New English School
Mumbai, Maharashtra01.2018
Skills
- Python
- Pandas
- Numpy
- MYSQL
- Excel
- Web Scraping
- Azure Blob
- SQL querying
- Marketing analytics
- Postman
- Seaborn
- Selenium
- Beautiful Soap
- Data Optimization
- Data Pre-processing
- Data Transformation
- Data Warehousing
- Time Management
- Data Visualization
- Team Work
- Problem solving
- Communication
Certification
- Certified in Python
- Certified Data Analyst using SQL
Projects
Passenger Data Analysis Report
Created a script that retrieves 500 rows for a given day with each call in PostgreSQL, designed visualizations for booking details, including month-wise and day-wise breakdowns, created a cohort report on the repeat count of passengers since inception, implemented advanced reporting features to analyze booking trends relative to scheduled journey dates, calculated Average Selling Price (ASP) and ASP per ticket metrics, as per business need to enhance revenue forecasting, created the Python script of uploader of scraper data to Azure, created a revenue KPI dashboard in Python based on route, bus count, type of bus, and revenue per kilometer.
Created and Automated Multiple Scrapers
Created and automated the bus operator frontend scraper.
Created a backend scraper that retrieves data through an API, automated and created both the frontend and backend (API) scrapers for bus aggregator, which retrieve data from the web and store it in a CSV file.
Automated the Python script to download the CSV from the website on a daily basis.
Relevant Experience
1.5 years
Overall Work Experience
2 Years
Timeline
Data Analyst
Green Cell Mobility Pvt .Ltd
10.2023 - Current
Data Analyst
Greencell Mobility Pvt. Ltd.
10.2023 - Current
B.sc - Information Technology
Kirti college, Mumbai university
HSC - Science
Kirti M Doongursee College
SSC -
IES New English School