Tehmina Shaik

Detail-oriented Business Analyst with 5+ years of experience in converting complex data into actionable insights to drive decision-making processes. Strong background in PostgreSQL, Excel, Tableau, R language, analyzing trends, crafting detailed reports, and enhancing business operations through technology solutions. Demonstrated ability to work collaboratively across teams to implement improvements, leading to increased efficiency and productivity.

• Project Management Professional

Data Visualization and Dashboards with Excel                                                                                      

Analyzed car sales trends for SwiftAuto Traders, focusing on dealer-specific sales and profits. Created a bar chart for Quantity Sold by Dealer ID, a line chart for Profit by Date and Model, and a column chart for Profit by Year and Dealer ID using pivot tables. Used modified datasets from IBM Accelerator Catalog to improve visualization accuracy.

Gender based Data Analysis of Health Measures Using Tableau                                                  

Conducted a gender-based analysis of health metrics across obesity categories. Developed a bar graph, line chart and interactive dashboard with gender and obesity combinations on the X-axis and metric values on the Y-axis. Identified obese individuals with the highest average age, weight, physical activity, and BMI. The analysis provided insights into gender, obesity categories, and health disparities.

Predicting Precipitation at JFK Airport Using R                                                                                   

Conducted data cleaning by handling missing values, outliers and converting data types on NOAA weather dataset. Used histograms to explore key variables and performed regression analysis with corrplot and tidyverse. Developed simple linear regression models as part of a predictive modeling approach to forecast precipitation, visualized with scatter plots and regression lines. Compared performance with R-squared and RMSE using tidymodel. Identified an accurate model for predicting precipitation at JFK Airport, aiding flight operations & delay management.

SQL for Data Science with R                                                                                                                        

Analyzed a farm prices dataset to extract insights on crop yields, prices, and geographies using techniques like inner joins, subqueries, aggregate functions, WHERE, and ORDER BY clauses. Identified top crops and provinces, and calculated average yields and prices to inform agricultural business decisions.