OnBenchMark Logo

Ajay (RID : 6v6vlsvre2mm)

designation   Senior Data Analyst

location   Location : Mumbai, India

experience   Experience : 6.3 Year

rate   Rate: $15 / Hourly

Availability   Availability : Immediate

Work From   Work From : Offsite

designation   Category : Training & Development

Shortlisted : 0
Total Views : 49
Key Skills
Senior Data Analyst Power BI SQL Tableau Desktop
Discription


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.
 

 
Matching Resources
My Project History & Feedbacks
Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon
Loading…

stuff goes in here!