Microsoft Power BI, Microsoft Fabric, SQL

Somashekar Aloor

E-Mail:**********@*****.***

DOB: 3/41993, Phone: 789-***-****

Professional Summary:

Having 4+ years experience in software industry and proficient in Microsoft technologies such as SQL Server, SSAS, SSRS, MS Power BI and Azure analysis services, Azure Data Factory

Have experience in developing Reports and Dashboards in Power BI Desktop and SQL Server.

Expert skill in data migration and ETL from various data sources like Excel, SQLServer, Flat files using SSIS packages and T- SQL constructs. Monitoring, debugging and tuning ETL jobs and workflows.

Develop the overall application architecture for projects, ensuring that the architecture is appropriate across the business domain(s), evolves to meet changing business and technology environments, and adheres to the enterprise architecture.

Ability to migrate and build applications to azure services.

Extensive Experience on Azure Services of Data Factory, Data Lake

Experience on creating effective reports, dashboards using Power BI desktop and published in to Power BI Service.

Involved in defining roles for reports/dashboards, sharing the developed dashboards to client in Power BI Service.

Experience in developing, monitoring, extracting and transforming data using SSAS & Power Query Editor, Import Export Wizard, and Bulk Insert.

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.

Expertise in writing T-SQL Queries, Sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors

Experience in Performance Tuning and Query Optimization

Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.

Proficient in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.

Experience in creating & managing Gateway.

Experience in maintaining & monitoring the performance of Capacity.

Working closely with top level IT Project Management to gather requirement.

Having Good Knowledge in Complete System Development Life Cycle (SDLC).

Experience and ability to coordinate/Communicate within team and outside team based on project requirements

Experience Summary:

Currently working as Consultant for Capgemini India Pvt Ltd from April 2025.

Worked as Power BI developer for Ingredion Corporation from May-2021 to April-2025.

Education:

M.Tech from VTU Belgaum in 2016.

Technical Skills:

Reporting Tools

Power BI, Excel

Azure Cloud

Azure analysis services, Azure Data Factory

Database

MS SQL Server 2016/2012, MS-ACCESS.

OLAP Tool(s)

SQL Server Analysis Services (SSAS).

Query Language(s)

T-SQL, DAX, M Query language(Basics)

ETL

SSIS, Azure Data Factory

Project Summary:

Client : Ingredion, USA

Role : Power BI Developer

Responsibilities:

Model & Architect DW design, direct and/or execute the technical characteristics of the overall strategy of the data warehouse and ETL process.

Map source system data elements to target system and develop, test, and support extraction, transformation, and load processes.

Development of custom scripts and stored procedures for data import and manipulation

Used Azure Data Factory to create ETL pipelines to validate, extract, transform and load data to data warehouse and data marts.

Involved in Bug fixes and code debugging and job monitoring in Production Environment.

Created Data Factory pipelines processing data loading from source to destinations.

Data processed by using Poly base in Azure Synapse Analytics DW.

Migrated all SSIS packages from on premises to Azure Data factory.

Extensively using Azure Analysis Services to create semantic models

Developed Star and Snow flake schema models.

Developed Pipelines in Azure Data factory using Multiple Activities.

Designed Power BI reports and published into Power BI report server.

Designed Power BI dashboards in Online by taking Data from Azure DW.

Created Tabular cube and published to Azure Analysis Services.

Designed extensive reports and dashboards using Power BI Desktop and Cloud.

Contact this candidate