Somshekar Aloor

Analyst

5years in Analytics

4years leading teams

10people in the team led

Master’sVisvesvaraya Technological University (VTU)

Overview

Data and BI professional with 5+ years in building reporting and data warehouse solutions using Microsoft technologies. Experience includes Power BI report/dashboard development, Azure Data Factory/ETL workflows, Azure data services, and SQL-based data modeling and performance tuning.

Phone

Timeline

Consultant · Middle

Capgemini Technology India Pvt Ltd · Full-Time

Apr 2025 to Present 1 Year 7 Months In office

Worked on data warehouse and ETL/analytics initiatives using the Microsoft data stack. Built and maintained Power BI reporting artifacts, including models and dashboards, and supported production monitoring and debugging of data pipelines. Implemented data movement and transformation workflows using Azure services and SQL-based logic.

Azure

Power BI

Microsoft Fabric

Azure Data Factory

MS SQL

SSAS

SSIS

SQL

ETL/ELT

Senior Data Analyst · Senior

Brisa Technologies Pvt Ltd · Full-Time

Jun 2021 to Apr 2025 3 Years 10 Months In office

Delivered analytics solutions focused on data modeling, ETL development, and reporting with Microsoft tools. Created and tuned ETL workflows and SQL logic for loading data into warehouse structures, including dimensional models. Developed Power BI reports and dashboards and supported ongoing performance and issue resolution for data and reporting components.

Azure

Power BI

Microsoft Fabric

Azure Data Factory

MS SQL

SSAS

SSIS

SQL

ETL/ELT

Visvesvaraya Technological University (VTU)

Master's Degree

2016 Belagavi, Karnataka

Projects

Ingredion Power BI and Azure Data Warehouse Work

Built a data warehouse and analytics reporting solution for an enterprise client. Designed and operated Azure Data Factory pipelines for ETL from source systems into warehouse and marts, including semantic modeling with Azure Analysis Services. Created Power BI reports and dashboards and supported data publishing to the Power BI reporting environment.

Technical skills

SQL

Analytics

Power BI

Azure Data Factory

SSAS

SSIS

ETL/ELT

Databases

MS SQL

Microsoft Fabric

DevOps

Azure

Job preferences

Work permits: India
Salary: from $40k per year
Employment type: Full-Time
Locations: Hyderabad, Bengaluru, Pune

Open to AI agents: they read this profile and start a dialog through Alionalion.io/@somshekar-aloor/mcp