SAHIBA BOHRA

DATA ANALYST/ ENTHUSIAST WITH WORKING EXPERIENCE OF Python/ SQL/ TABLEAU/MS EXCEL.

Enthusiastic Data consultant eager to contribute to team success through hard work, attention to detail and excellent organizational skills. Clear understanding of data analysis by MS Excel, SQL and tableau and training in Python. Motivated to learn, grow and excel as a subject matter expert and problem solver in data analytics domain . As Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.

2022 IIT ROORKEE

Prediction of bad or good credit for Indian Bank- Machine learning based project.

2015 State Bank of India, New Delhi

Market research of Jaipur Region for the business of letter of credit.

Rishabh International Manufacturers & Exporters,Jodhpur Academic Projects:

‘Women Empowerment In RAJASTHAN'

'Consumer Satisfaction at Coffeecafé Day '

‘Profit Analysis OF Reliance Telecom Pvt. Ltd.

• IIT ROORKEE APPLIED DATA SCIENCE & MACHINE LEARNING

• GOOGLE DATA ANALYTICS

Projects:

• Financial Analysis(Oct 2022 - Nov 2022)
• As a Data Scientist working for a consulting firm. One of your
  colleagues from the Auditing department has asked you to help them assess the
  financial statement of an organization .
  You have been supplied with two lists of data: monthly revenue and monthly expenses for the financial year in question. Your task is to calculate the following
  financial metrics:
  - profit for each month
  - profit after tax for each month (the tax rate is 30%)
  - profit margin for each month - equals to profit after tax divided by revenue
  - good months - where the profit after tax was greater than the mean for the year
  - bad months - where the profit after tax was less than the mean for the year.
  - the best month - where the profit after tax was max for the year.
  - the worst month - where the profit after tax was min for the year. As a Data Scientist working for a consulting firm. One of your colleagues from the Auditing department has asked you to help them assess the financial statement of an organization . You have been supplied with two lists of data: monthly revenue and monthly expenses for the financial year in question. Your task is to calculate the following financial metrics: - profit for each month - profit after tax for each month (the tax rate is 30%) - profit margin for each month - equals to profit after tax divided by revenue - good months - where the profit after tax was greater than the mean for the year - bad months - where the profit after tax was less than the mean for the year. - the best month - where the profit after tax was max for the year. - the worst month - where the profit after tax was min for the year
• Customer Analysis (Oct 2022 - Oct 2022)

Customer Analysis Dashboard ,the one created by using different types of charts including a butterfly chart, a donut chart, a scatter plot and more. We have compared revenue based on various factors and there proportionality so that strategies could be built based on these. Customer Analysis Dashboard ,the one created by using different types of charts including a butterfly chart, a donut chart, a scatter plot and more. We have compared revenue based on various factors and there proportionality so that strategies could be built based on these.

• Profitability and Efficiency of Startups (Sep 2022 - Sep 2022)

The focused aim of this project was to derive the dynamic list of startups from a Index of 1000 startups which are working on achieving optimum efficiency by reducing the expanses and maximizing the Revenues. It is a data visualization done using Tableau tool.The focused aim of this project was to derive the dynamic list of startups from a Index of 1000 startups which are working on achieving optimum efficiency by reducing the expanses and maximizing the Revenues. It is a data visualization done using Tableau tool.

• San Francisco Airport Dashboard (Aug 2022 - Aug 2022)
• It is a complete display of Important details about the functionality, flights, No of Passengers, Top Routes ,etc. of the flights taking off from the busiest Airport of the World. This dashboard was created using Tableau.It is a complete display of Important details about the functionality, flights, No of Passengers, Top Routes ,etc. of the flights taking off from the busiest Airport of the World. This dashboard was created using Tableau.

• Regional Sales Projection (May2022 - May 2022)

This Project is showing the year wise sales in different regions for different products. It will be a piece of cake to track the high performing and profitable products and regions as well as its contrary. It is created using Tableau for visualization.This Project is showing the year wise sales in different regions for different products. It will be a piece of cake to track the high performing and profitable products and regions as well as its contrary. It is created using Tableau for visualization.

• Sales and Profits Projections (May 2022 - May 2022)

This is a visualization to cater to the understanding of sales and profits earned year wise for different departments and products in respective geographical regions. This is a visualization to cater to the understanding of sales and profits earned year wise for different departments and products in respective geographical regions.

• World Carbon Dioxide Emissions World (May 2022 - May 2022)

This is dashboard (Tracker) for understanding the carbon dioxide emissions levels across the globe.