Summary
Overview
Work History
Education
Skills
Websites
Technical Skills
Certification
Languages
Accomplishments
Timeline
Generic
Somspandan

Somspandan

Bengaluru

Summary

Results-driven Power BI Developer with a proven track record at Convergint, adept at transforming complex datasets into actionable insights. Expertise in data modeling and dashboard optimization, coupled with strong analytical thinking, has led to enhanced report efficiency and impactful business intelligence solutions. Skilled in ETL transformations and project management.

Overview

1
1
Certification

Work History

Power Bi developer

Convergint
  • Developed comprehensive Power BI reports by integrating complete datasets, creating measures, and adding calculated columns for real-time analysis while optimizing performance
  • Executed ETL transformations within Power BI to ensure accurate and meaningful data representation in reports
  • Expertise in data modeling, dashboard optimization, RLS implementation, custom visuals, mapping, and end-to-end Power BI report development
  • Deployed Power BI reports to Power BI Service and configured scheduled data refresh for seamless automation
  • Defined BI requirements by identifying key KPIs, dimensions, target audience, and essential business questions that reports should address
  • Designed BI wireframes based on project briefs and conducted bottleneck analysis to enhance report efficiency
  • Implemented Power BI Deployment Pipelines to streamline development, testing, and rollout of strategic BI applications

Power Bi Developer

TRG (Total Retail Group)
  • Generated and shared weekly POS data analysis reports via email, including key KPIs, using Python
  • Designed interactive Power BI reports with various built-in and custom visuals to address business challenges
  • Conducted deep-dive analyses to identify the root causes of sales fluctuations and evaluate the best- and worst-performing states/regions
  • Identified valuable data sources and automated data collection processes using Python, including web scraping and PDF extraction
  • Led the migration of reports and dashboards between reporting tools, successfully transferring 40 dashboards from Sisense to Power BI
  • Integrated data from multiple sources, including client website backends, Excel files, and client databases
  • Developed stored procedures to clean and transform data from landing tables into main operational tables

Data Analyst

Blik.ai
  • Contributed to the development of Blik.ai, a proprietary product, by building dashboards for platforms like Adobe Analytics, Google AdWords, Google Analytics, Jira/Monday.com, and Pipedrive/HubSpot
  • Clients can input their API keys to instantly generate and customize their company reports within minutes
  • Designed and developed Power BI reports with complete datasets, creating measures and calculated columns for period-based, trend, and real-time analysis, including mobile-optimized views, while ensuring performance optimization
  • Deployed Power BI reports to Power BI Service, configuring automated data refresh schedules for seamless updates
  • Defined BI briefs, outlining key KPIs, dimensions, target audiences, and critical business questions the reports should address
  • Developed BI wireframes based on project briefs, identifying and resolving potential bottlenecks to enhance report efficiency

Education

MBA - Data Analytics

Centurion University of Technology And Management
Bhubaneswar
06-2019

Bachelor of Commerce - Accounting

Udayanath Autonomous College Of Science & Technolo
Cuttack
06-2017

Skills

Microsoft Power BI

  • Microsoft Office 365
  • SSAS
  • SSIS
  • Power Automate
  • Tableau
  • SQL Server 2019
  • Python
  • Dashboard optimization
  • Data visualization
  • Business intelligence
  • Problem-solving aptitude
  • Project management
  • ETL transformations
  • Data modeling
  • Critical thinking
  • Analytical thinking

Technical Skills

Data Analytics, Microsoft Power BI, Excel, SSAS, SSMS, Power BI robots, Tableau (Basics), SQL Server 2017, PG-admin 4, Intermediate in Python, Retail Marketing, Product Development

Certification

  • Microsoft Power BI Desktop for Business Intelligence
  • PostgreSQL Bootcamp : Go From Beginner to Advanced

Languages

English
First Language
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Odia
Proficient (C2)
C2

Accomplishments

1. At Convergytics, I trained 40 participants in Power BI and received the Best Instructor award.
2. Recognized as a Center of Excellence for completing the TRG dashboard migration to Power BI ahead of
schedule.

Timeline

Power Bi developer

Convergint

Power Bi Developer

TRG (Total Retail Group)

Data Analyst

Blik.ai

MBA - Data Analytics

Centurion University of Technology And Management

Bachelor of Commerce - Accounting

Udayanath Autonomous College Of Science & Technolo
Somspandan