Bhupesh Pandey

To work in a healthy, innovative and challenging environment extracting the best out of me, which is conducive to learn and grow at professional as well as personal level so that I can explore myself fully and realize my potential.

• Certification on mysql
• Achieved microsoft PowerBi Data Analyst learning badge.
• Oracle SQL certification-ongoing
• Google Certification on Fundamental of Digital mkt
• Pycharm, juypter notebook, Lab manager & Starlims,Anaconda,Eagle,Apex.oracle,Ms Excel ,Eclipse IDE,mysql workbench, Powerbi.,Dev c++.
• Best team Award from the manager
• On the spot Award and appreciation note from the lead
• Certification on various Life Sciences domain courses

Python Project

Performed data cleaning and manipulation Performed exploratory data analysis (EDA) using pandas , matplotlib and seaborn libraries improved customers experience by identifying potential customers across different states, occupation ,gender and age groups. improved sales by identifying most selling product categories and products ,which can help to plan inventory and hence meet the demands

Wafer fault Detection

To build a model to predict wafer sensors,model identifies whether the wafer is wrong ,if the wafer is wrong that wafer section will be closed & the wafer is replaced and starts the process so that entire production doesn't stop. data is in csv format and the data in DB used for model training. My role is data validation & data cleaning. i have checked whether the data is standard , i have checked whether the data is in csv format or not & i check if data contains time and date format or not. if it is not in that format than we have to reject the data & coming to cleaning part i have to check if the data contains any null values or not . data cleaning is a part where we remove unwanted data like transforming the data , standardizing the data ,removing the null values and missing values and convert into a useful data. i have to check whether the data contains any categorical values.if the data is good we keep it in a good data file, if the data is bad we dump it into archive files ,for all these process i used python and its liabraries like pandas, numpy, pandas profiling.

Power Bi Project

Created interactive dashboard to track & analyze online sales data Used complex parameters to drill down in worksheet and customization using filters and slicers Created connections, join new tables, calculations to manipulate data and enable user driven parameters for visualizations Used different types of visualizations (bar chart , pi chart, donut chart, clustered area chart, scatter chart, line chart,area chart, map , slicers etc)

HR Analytics Project

PROJECT OBJECTIVE: - To help an organization to improve employee performance and improve employee retention by creating HR Analysis Dashboard. and finding out the reason behind the number of employees leaving the company. VISUALS USED: - Utilize a wide range of visualizations in Power Bi including Cards, Slicers, Tree Map, Donut Chart, Clustered Bar Charts, Stacked Column Chart, Matrix, Area Chart, Used KPIs.

Conclusion :- Draw insights from data, such as average salary ,attrition rate ,trends, and patterns to identify potential areas of concern and improvement in HR strategies. >> The project gives the insight related the reason of attrition Therefore , the fields are divided into three Research and Development , Human Resource , Sales.

Learning Outcomes:- Key learning outcomes include creating an interactive HR Analytics dashboard ,utilizing complex parameters and data cleaning techniques and improving HR strategies though data driven Insights.

1-Obstacle avoiding Robot using ultrasonic sensor: Arduino based robot that uses Ultrasonic range finder sensors to avoid collisions with unexpected obstacles.

2-Mini cnc plotter machine: objectives of this project is to design the CNC Plotter Machine and to develop open source software and hardware to control it using stepper motor in x and y axis (using python programming).

3-Line follower Robot: An automated guided vehicle, which follow a visual line embedded on the floor or ceiling using IR Sensors and a command.