Summary
Overview
Work History
Education
Skills
Timeline
Generic
Susnata Bhattacharya

Susnata Bhattacharya

Summary

Results-driven Power BI Developer with over 3 years of experience in creating impactful data visualizations, dashboards, and reports. Expertise in SQL and Data Modeling, complemented by a proven ability to collaborate with cross-functional teams to gather business requirements and deliver tailored solutions. Demonstrates strong analytical and problem-solving skills, with a commitment to continuous learning and improvement.

Overview

3
3
years of professional experience

Work History

Senior Software Engineer

Capgemini
09.2022 - Current
  • Designed and developed 20+ interactive reports and dashboards for internal and client-facing projects using Power BI.
  • Integrated Row-Level Security (RLS) for enhanced data access management and ensured data security in Power BI reports, and share the reports in Power BI service.
  • Performed R&D and POCs on emerging AI features for optimizing report performance and enhancing report efficiency.
  • Ensured proper data modeling by segregating tables into facts and dimensions, optimizing the data structure for better performance and scalability.
  • Worked with diverse data sources including Excel, SQL Server, and Amazon Redshift for data extraction, transformation, and analysis. Ensured proper data modeling by segregating tables into facts and dimensions, optimizing the data structure for better performance and scalability.
  • Designed and imported data from SQL Server DB, CSV, and SharePoint folder to Power BI to generate reports.
  • Experience in data model optimization and improvement, model performance, speed, and efficiency.
  • Good knowledge of DAX.
  • Published Power BI reports in the required organizations, and made Power BI dashboards available in web clients.

Software Engineer

Capgemini
03.2022 - 09.2022
  • Database Design & Schema Development: Define and implement relational schemas (tables, keys, constraints), ensuring normalization and alignment with application requirements. reddit.com, 15alooba.com, 15coursera.org.
  • Query Authoring & Optimization: Write complex, performant SQL: SELECT statements, joins, subqueries, stored procedures, functions, triggers, and views. Analyze execution plans and add indexes to boost performance.
  • Data Integration & ETL: Develop pipelines to extract, transform, and load data between systems (e.g., SSIS, custom scripts). Scrub, standardize data, and load it into data warehouses: dreamjobnavigator.com, +1, alooba.com, +1.
  • Database Maintenance & Administration: Schedule backups, implement recovery plans, monitor health, apply patches, manage user accounts, and handle permissions.

Education

Bachelor of Technology - Information Technology

Future Institute of Engineering And Management
Kolkata, India
01-2019

Skills

  • Power BI
  • Data modeling
  • DAX functions
  • Data visualization
  • Dashboard design
  • Data warehousing
  • ETL processes
  • PL/SQL Programming
  • Python language

Timeline

Senior Software Engineer

Capgemini
09.2022 - Current

Software Engineer

Capgemini
03.2022 - 09.2022

Bachelor of Technology - Information Technology

Future Institute of Engineering And Management

Similar Profiles

CREATE PROFILE
Susnata Bhattacharya