Bodhisattwa Guha
Data & Analytics
Kolkata
Summary
Results-driven Data Analyst with nearly 4 years of experience in database management, data analysis, and visualization. Proficient in SQL, Python, and Power BI, with a proven track record of enhancing data accuracy, automating processes, and delivering actionable insights. Skilled in developing interactive dashboards, forecasting, and optimizing data management practices to support strategic decision-making and process improvement.
Overview
4
4
years of professional experience
4
4
years of post-secondary education
2
2
Certifications
Work History
Business Analyst
Pemlix Technology Solutions Pvt Ltd
Kolkata
10.2020 - 08.2024
- Managed and maintained SQL database with over 10 million records, ensuring data integrity and optimal performance
- Designed and developed numerous interactive dashboards to visualize key metrics and performance indicators, providing actionable insights for improvement
- Created and implemented data models to support complex data analysis and ensure accurate representation of business processes and metrics
- Coordinated with operations team to align with client expectations, ensuring timely and accurate delivery of data-driven solutions
- Conducted comprehensive data analysis to identify key performance indicators (KPIs) such as cost, revenue, profit margin, and hourly revenue rate, driving informed decision-making and strategic planning
- Prepared forecasting models and developed trend lines to analyze and predict process performance, aiding in long-term strategic planning
- Identified areas of improvement from production and compliance perspectives through detailed data analysis, contributing to enhanced operational efficiency and compliance adherence.
Education
B.Tech in Electronics and Communication Engineering -
Budge Institute of Technology(Undertaken by MAKAUT)
01.2014 - 04.2018
undefined
Skills
Programming: SQL, Python, Python Libraries(Pandas, Numpy, Matplotlib, Seaborn), R
Data Visualization: Power BI, EXCEL, Power Query, DAX
Soft Skill:
Team Work & Problem Solving: Certificate of Project Completion: Weather Server Using ESP8266
Presentation and Communication Skill: Certificate of Delivering Presentation: Li-Fi in the seminar of Modern Application of electronics
Quick Learning ability: RNR Certificate: Best Newcomer in the Organization
Projects
Data Analytics Project: Performance Review for UK Outbound Contact Center
- Analyzed performance across three separate teams within a UK outbound contact center, using Power BI to identify key trends and actionable insights.
- Automated data collection processes, reducing manual effort by 20% and improving data accuracy.
- Developed interactive dashboards for real-time monitoring of team performance and decision support.
- Provided strategic recommendations that led to a 10% improvement in process efficiency.
Implementation of Data Warehousing Setup
- Implemented a structured database server to systematically store raw data from CRM, surveys, and point-of-sale transactions, enhancing data organization and accessibility.
- Automated data storage processes, reducing manual tasks and errors, leading to higher data accuracy.
- Streamlined data cleaning and transformation by centralizing data storage, making data preparation more efficient.
- Optimized data management practices for more effective future analysis and informed decision-making.
Languages
English
Advanced (C1)
Bengali
Bilingual or Proficient (C2)
Hindi
Upper intermediate (B2)
Certification
ASP.NET(Using C#) from TCS ION
Timeline
Business Analyst
Pemlix Technology Solutions Pvt Ltd
10.2020 - 08.2024
ASP.NET(Using C#) from TCS ION
11-2018
B.Tech in Electronics and Communication Engineering -
Budge Institute of Technology(Undertaken by MAKAUT)
01.2014 - 04.2018