Senior Data Analyst
Location : Mumbai, India
Experience : 6.3 Year
Rate: $15 / Hourly
Availability : Immediate
Work From : Offsite
Category : Training & Development
PowerBI Developer
P RO F I L E
Research professional & Data enthusiast with more than 4.2 years of experience in Business Intelligence.
Proficient in BI Reporting Solutions like Power BI with expertise in data warehouse concepts to write and
analyze SQL Queries. Well-informed in Power BI & troubleshooting for Web & Mobile.
P RO F ES S IO N A L E X P E R T I S E
Having 6.2 years of overall experience in IT Industry,
Relevant 4+ experience in SQL server and Business
Intelligence tools such as Power BI, DAX, SSRS, SSAS,
Azure DWH and Azure SQL, etc.
Expert in creating and developing Power BIreports
and Dashboards with best UI/UX features.
Expertise in Power BI, Power BI Pro, Power BI
Mobile, Power BI Report Server.
Experience in developing Reports by slicers, drill
down, drill through reports and bookmarks,
filters/calculated columns/measures/relationships
and transformations of Edit Query section.
Shared reports/dashboards by creating Apps or
individual sharing reports/dashboards and having
experience in publishing reports toapp.powerbi.com
(POWER BI SERVICE) by configuring gateways.
Developed Power BI reports using multiple sources
like Excel, CSV, SQL Server, SQL Server Analysis
Services and Power BI Service etc.
Worked on DAX functions like Date & Time functions,
textual functions and Time intelligence functions.
Created DAX measures like TOTALYTD, TOTALQTD,
TOTALMTD, last year sales, last 30 days’ sales etc.
Having knowledge on Row and Role Based Security as
a part of security in Power BI.
E D U C ATIO N
B. TECH(Mech) from JNTU
University Anantapur
S K I L L S E T
Power BI
DAX
SQL SERVER
Data Modelling
Power Bi Service
SKILLSET
SSAS
SSRS
SSIS
DWH
Excel
ADF
PRO FES SIO N AL EX P ERT IS E
Worked with Custom Visuals like Scroller,
Sunburst chart, Advanced card etc.
Hands on experience in MS SQL Server Database
Queries, Joins, Stored procedures and Views.
Excellent knowledge in creating Databases,
Tables, Stored Procedures, DDL/DML Triggers,
Views, User defined data types, functions, Cursors
and Indexes using T-SQL.
Having Knowledge on SQL Server Analysis
Services (SSAS) and SQL Server Reporting
Services (SSRS).
Having Knowledge on shared dataset, parameters
and cascading parameters concepts in SSRS.
Having good knowledge in SSIS, used
Transformations such as Derived Column,
Conditional Split, Aggregates, Sort, Data
Conversion, Merge join and Union all etc.
Having good Knowledge on Azure SQL, Azure WH,
Azure ADF and building blocks of ADF such as
Pipelines, Activities, Linked Services, Integration
Runtime, Data flows, Triggers, Scheduling.
Created Pipelines and Triggers and worked on
transformations like derived transformation,
Lookup transformation, Filter transformationetc.
Having good knowledge on Databricks. Data
loading, Query writing with Spark SQL, Notebook,
Database, tables, views, Visualizing and
dashboard creation etc.
Quick learner and good team player, ability to
meet tight deadlines and work under pressure.
Having good knowledge in Azure Data Factory
(ADF), Azure Analysis services, Azure SQL DW,
and willing to learn new technologies.
Good knowledge in creating deployment
pipeline using PowerBI service.
P ROJ EC T UNDERTA KEN
Client: HINDWARE, Project Name: MIS Report Management
TOOLS: Power BI, DAX, Azure SQL, SQL (Sep 2021 – July 2023)
Responsibilities:
Extracted data from different sources like SQL Server, Excel, CSV files, Azure SQL.
I have transformed the data using power query like renamed the columns, changed
the data types, Split the column, and append the data, Conditional columns etc.
I have different kind of advanced DAX functions like SUM, COUNT, DIVIDE, IF
Conditions, Replace, TOP N, Cumulative total and by default current month value
etc.
Having good experience in Power bi Desktop and Power bi Service.
Proficient at data visualization using power BI and a strong application maintenance
and development knowledge.
{{contact.cdata.phone}}
{{contact.cdata.email}}
View Resume
