Mahesh Hadapad

Project: CDMO Governance & Compliance

• Handled the larger amount of data from multiple social media channels to validate whether the data is compliant or not.
• Investigating improper or incorrect data to make it correct for further processing.
• Cleaning the data after fetching information from social media platforms using tools like Python and MySQL.
• Created the interactive and well-maintained BI dashboards using Tableau BI software, as per client request.
• Analyzed large datasets to identify trends, patterns and correlations for business insights.
• Identified needs of clients promptly and efficiently.
• Developed and maintained documentation of all the processes related to data analysis.
• Designed the automation process of the project using Python scripts and MySQL queries to obtain the results faster and more accurately.
• Built the templates in Google sheets to identify the scores of each platform across multiple standard division

Project: Blibli E-commerce

• Providing end to end solutions for client depending on client requirements, We do understand the business problem,understand and analyze the historical data depending on that we can get insights and we predict what will our business
• I have handled more than 1M+ records from various data sources (MySQL and S3 Bucket)
• Prepared various BI dashboards in Dash-ploty for Trend analytics
• Evaluation and analysis of E-commerce (blibli) sales transaction dataset using pandas and python
• Sometimes we will use Excel and Google sheets to create a summary report
• I can understand the data and remove unwanted data to prepare it very useful data and process it using pandas and python. Good at writing SQL queries, handling pandas, and numpy Libraries. Good at EDA(Exploratory Data Analysis)

• Able to write complex MySQL queries like window functions, Join
• Learned Python Data Processing and cleaning very well
• Practiced designing of dashboard very well using Tableau

Project: Blibli E-commerce

• Providing end to end solutions for client depending on client requirements, We do understand the business problem,understand and analyze the historical data depending on that we can get insights and we predict what will our business
• I have handled more than 1M+ records from various data sources (MySQL and S3 Bucket)
• Prepared various BI dashboards in Dash-ploty for Trend analytics
• Evaluation and analysis of E-commerce (blibli) sales transaction dataset using pandas and python
• Sometimes we will use Excel and Google sheets to create a summary report
• I can understand the data and remove unwanted data to prepare it very useful data and process it using pandas and python. Good at writing SQL queries, handling pandas, and numpy Libraries. Good at EDA(Exploratory Data Analysis)

Project: Knowledge Pro

• Knowledge Pro is designed for educational institutions, autonomous colleges, and universities to simplify the needs of college administration. The software helps in keeping a track of students complete academic details from application submission to course completion and the alumni details too
• I have handled more than 1M+ data from MySQL database and written more SQL queries used in tableau custom query for visualization and generating the report using Tableau
• Summing up the requirements and designs for the report and deciding on how the query has to be built in order to achieve client format in Tableau
• Develop parameterized basic, consolidated, and tabulated student attendance reports, and annual marks sheets using Tableau and SQL queries, sheets using Tableau and SQL queries
• Good at designing interactive dashboards using Tableau