B.Jansepyara

Accomplished Analyst with over 2 years of expertise in data analysis, statistical modeling, and effective problem-solving. Proficient in dissecting large datasets, uncovering trends, and generating insightful findings to guide strategic business decisions. Mastery in statistical tools and programming languages, including Python and SQL. Skillful in developing and presenting comprehensive reports, dashboards, and visualizations to convey complex information with clarity. A proactive problem solver, known for attention to detail, and equally effective working independently or collaboratively within a team.

Advance Excel for Data Analysis by Coursera

• Big Mart Sales Prediction Goal: - The aim is to build a predictive model and find out the sales of each product at a particular outlet.
• Key Skills: - Data Preprocessing, Data Visualization, Feature Engineering, Statistical Analysis, Statistical Modelling, Sci-kit Learn Models like Linear Regression, Decision Tree Regressor, Random Forest
• Food Demand Forecasting Goal: - The aim is to predict the demand for the next 10 weeks
• Key Skills: - Data Preprocessing, Data Visualization, Feature Engineering, Statistical Analysis, Statistical Modelling, Sci-kit Learn Models like Linear Regression, Decision Tree Regressor, Random Forest.
• Prediction of Duration of Stay in Hospital For each Patient (Capstone Project):-The task is to accurately predict the Length of Stay for each patient on case-by-case basis so that the Hospitals can use this information for optimal resource allocation and better functioning.
• Key Skills: - Data Preprocessing, Data, Data Mining, Feature Engineering, Clustering, Statistical Analysis, Logistic Regression, SVM Classifier, Decision Tree, Naive Bayes, Random Forest and Ensemble Classifier Model, Model Validation.
• Data Verse Hack Insurance Claim Prediction by Analytics Vidhya:-Predict whether the policyholder will file a claim in the next 6 months or not.
• Key Skills: - Data Preprocessing, Data, Data Mining, Feature Engineering, Clustering, Statistical Analysis, Logistic Regression, SVM Classifier, Decision Tree, Naive Bayes, Random Forest and Ensemble Classifier Model, Model Validation.
• The Classic Microsoft Northwind Database by using My SQL:-
• The Northwind database is a fictional sample database used for learning and practicing SQL concepts. It was originally created by Microsoft and has been widely used in database courses and tutorials.
• It is designed to simulate a small trading company, with 14 tables connected using primary and foreign key concept
• HR Analytics Dashboard by using Power BI :-
• The HR analytics dashboard, designed using Power BI, is specifically aimed to find out the reasons for increasing attrition rate. It provides a comprehensive and user friendly view of key HR metrics such as turnover rate, headcount, and employee engagement, with a specific focus on identifying the factors that are contributing to the high attrition rate.
• The dashboard allows HR professionals and managers to easily track and analyze data on employee performance, demographics, and compensation, as well as measure employee satisfaction and engagement levels.
• With interactive visualizations and drill-down capabilities, users can quickly identify patterns and trends in the data, enabling them to make data driven decisions to improve the overall performance and productivity of the organization by reducing the attrition rate.