Summary
Overview
Work History
Education
Skills
Projects
Languages
Certification
Timeline
Generic

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

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

undefined

Bodhisattwa GuhaData & Analytics