Tharoon (RID : 13evlbffyjd7)

designation   PowerBi Data Analyst

location   Location : Hyderabad, India

experience   Experience : 6 Year

rate   Rate: $13 / Hourly

Availability   Availability : Immediate

Work From   Work From : Offsite

designation   Category : Information Technology & Services

Shortlisted : 0
Total Views : 20
Key Skills
Power BI Data Integration Dashboard Design Data Analysis SQL
Discription

PowerBi Data Analyst

  • Extensive experience in Data Analysis, PowerBI and Consumer Marketing analytics using SQL and Excel.
  • 5.8 Yrs. of experience as a Data Analyst and PowerBI Developer into Banking and IT industries.
  • Expert in writing SQL Queries to pull the data from different sources, creating data sets, Understanding of Views.
  • Having knowledge of MDX Cube and Visual Studio.
  • Performed in-depth analysis on the data pulled for an adhoc request and prepared graphs using MS Excel, MS PowerPoint, and PowerBI.
  • Expert in creating Dashboards, implementing Power Query, RLS (Dynamic and Static), and DAX Query writing.

Skill-set Summary:

Languages

SQL (4 Yrs.)

SQL

Functions, Joins, Unions, Aggregation Functions, Sorting, Filters, Groupings, CTE Creation, Temp Tables Creation

Reporting Tools

PowerBI (3.8 Yrs.)

PowerBI

Data Integration, Dashboard Design, Row Level Security Implementation,

Publishing of Dash Boards, DAX, Power Query

Microsoft Tools

MS Office Suite, SSMS, SSAS(MDX),SSDT (Visual Studio)(Basics)

Excel

Lookup, Conditional Formatting, Pivot Tables, Macros, Validation, Dash Board

Creation

Operating Systems

Windows

Project Details:

Objective: Migration of Cognos and Excel Reports to PowerBI and creating dashboards as per client’s requirement.

Project Development Process:

  • Requirement Gathering:
    • Receiving a list of Cognos reports from the client indicating which reports must be migrated
    • Analysing the reports and understanding the business requirements

Data Profiling:

    • Interacting with the Cognos team to understand more about the business logic, report structure, and SQL logic of the reports.

Data Mining:

    • SSMS and SSDT can be used to analyse MDX cubes.
    • Create documents with dimensions, measures, and KPIs.

Data Analysis:

    • Writing SQL queries in Legacy (Existing Source) and validating the results with Cognos reports, creating joins between tables to retrieve the data, using SQL Functions to optimise the query.
    • Analysis of the gap between legacy and cloud query results so that the query can be replicated in the cloud.
    • Find the most relevant tables in the cloud to be used in an SQL query.
    • Analyse Cognos Reports and do gap analysis with Azure Cloud DB for available data.
    • Organize, extrapolate, and disseminate data to be used for migrating the Cubes (Legacy) to the Cloud DB

Visualization:

    • SQL Query Implementation in PowerBI
    • Transformation of raw data into meaningful insights
    • Replication of Cognos Reports into PowerBI.

UAT:

    • Validation of PowerBI Reports results with Cognos Reports results
    • Complete the process of UAT by sharing the PowerBI Dashboard Links to Testing Team

Roles & Responsibilities:

  • Daily Interaction with the Client
  • Updating the Agile Scrum Board on a Daily Basis
  • Working on assigned tasks and making sure to complete the tasks within the sprint period
  • Attending daily scrum calls with the client
  • PowerBI DashBoard Creation, and making sure that reports are published to clients' workspace.

Project Name: Customer Segmentation Client: Banking and Finance

Objective:

  • To group similar purchase customers
  • To serve better for customer’s needs and wants
  • Group / Cluster based on common characteristics, so Investment banks can market to each group effectively and appropriately

Roles and Responsibilities:

Data Gathering

  • Collect Sales data (Rolling 12 months)
  • Cross sales Product Information
  • Behavioral information
  • Locations specific

EDA / Data Pre-processing

  • Bring out Insights / buying pattern of customers
  • Clean data –Missing values, Outliers
  • Feature Engineering / Selection

List the characteristics of each cluster

  • This information will be shared with the sales/marketing team for smooth targeting of the right audience for campaigns.

Visualization:

 
Matching Resources
My Project History & Feedbacks
Copyright : 2022 – OnBenchMark All Right Reserved.
Request Demo
Loading…

stuff goes in here!