Profileimage by Rahul Dev BI Analyst with 5 years of experience from Bengaluru

Rahul Dev

available

Last update: 06.09.2022

BI Analyst with 5 years of experience

Company: SignOn.ai
Graduation: Bachelor of Technology Computer Science
Hourly-/Daily rates: show
Languages: English (Native or Bilingual)

Attachments

Rahul_BI.pdf

Skills

Created advanced chart types, visualizations and complex calculations to manipulate the
 data.
 Designed, developed and supported BI solutions.
 Implemented advanced geographic mapping techniques.
 Experience in Developing Performance Dashboards, Drills, Search, KPI, Reports, etc.
 Creation of reports and dashboards.
 Created pie charts, Bar charts, Line charts, Scatter plots, Tree chart, Cards, area charts
 according to deliverable specifications.
 Worked with Actions, calculations, parameters and table calculations.
 Expert in developing Power BI dashboards in rich look.
 Expertise in writing complex DAX functions in Power BI.
 Used various sources to pull data into Power BI such as MySQL Server, MS SQl, Azure SQL
 DB, Excel Sheets, CSV Files, etc.
 Expert in creating calculated columns and calculated measures in Power BI desktop
 Generated computed tables in PowerBI using DAX.
 Experience in the implementation of Row Level Security.
 Implementation of Connection parameterizations for handling various servers and
Databases.
 Experience in the Bookmark feature of Power BI.
 Flexible in Import mode and Direct Query.
 Worked on most of the transformations that are available in PowerBI query editor.
 Integrated custom visuals based on business requirements using PowerBI Desktop.
 Designed PowerBI Data visualization utilizing Tables, Crosstabs, Scatter plots, Gauges,
Pie charts, Bar charts, Line charts, Maps, Cards, etc.
 Involved in extracting, transforming and loading data from multiple sources into Qlik
 sense/ QlikView applications.
 Experience in Using QlikView Functions (Date and Time, Join, Mapping, String & input
 Fields, etc.).
 Developed QlikView Dashboards using Chart Box (Drill Down, Drill up, etc.), List, Input
 Field, Table Box, and Calendar & Date.
 Worked on SQL Scripts to load Data in QlikView Applications.

Project history

06/2015 - Present
BI Engineer
SignOn.ai (Internet and Information Technology, 50-250 employees)

=>Worked on a Data Visualization Project for a mining Company.
 The goal of the project is to implement an advanced analytics system, that collects data from
various systems and utilize it to predict insights to improve the overall operational efficiency.
 Developed various dashboards using native and custom visuals.
 Wrote complex DAX functions for monitoring the performance and utilization activities of various
equipment.
 Used mixed storage mode (Combination of Import mode and Direct Query mode).
 Implemented connection Parametrization.
 Worked on the Power BI embedding part for consuming the reports.
 Configured Power BI gateway for doing the data refresh in Power BI service.
=>Worked on the analysis of E-Commerce portal.
 Involved in developing various reports for analyzing the sale performance of the E-Commerce
matrix using native and custom visuals.
 Used Direct Query as the storage mode
 Established Connection Parameterization in order to deal with various servers and databases.
 Implemented Row Level Security in the reports to provide data confidentiality.
=>Worked on used car logistics and cost reduction.
 The objective of the project is to improve the lead time of a vehicles between the park
entry and the exit.
 Involved in writing DAX functions in Power BI.
 Created customized reports in Power BI.
 Modification of source files on weekly basis.
=>Worked on Data Visualization project to monitor automotive sector activities.
 Involved in writing DAX functions in Power BI.
 Created several dashboards in Power BI using data sources like Excel sheets, CSV files,
and MYSQL DB.
 Published report in Power BI service.
=>Worked on Data Visualization project to monitor the employee activities in the company.
 Created various dashboards in Power BI to analyze the employee attendance, status of
projects, meeting details, etc. using MySQL DB as data source.
 Developed Qlik Sense dashboards to visualize the clustering of retail customers against specific
customer purchasing patterns.
 Designed and developed a Spotfire dashboard to monitor the lifecycle of cost-cutting ideas in car
manufacturing.
=> Worked on Data visualization project to monitor the LinkedIn activities of the company.
 Created Power BI dashboards to monitor the activities and trends in company LinkedIn
page.
=>Involved in POC works for
 Invoice Monitoring of used cars using Power BI dashboards.
 Sales and production analysis of used cars using Power BI dashboard and excel sheets.
=>Worked on Analytics as a Service for a lifestyle application.
 This analytics project was part of a campaign application. The objective was to collect all
the user action and its correlation to a set of predefined metrics.
 Was involved in the development of the analytics portal.
=>Worked on the development of a Performance Management System.
 This tool is used to capture the involvement of employees in various activities and tasks
 Was involved in the development of analytics portal of this system
 Worked with Power BI and MySQL.
=>Worked on the analytics part of WAF Real Time Monitoring Tool using Tableau and Excel as data
source.

Local Availability

Only available in these countries: India
Profileimage by Rahul Dev BI Analyst with 5 years of experience from Bengaluru BI Analyst with 5 years of experience
Register