Sainath J



Professional Summary:
• 3.7 years of Professional experience in IT industry, working on Power BI.
• 3+ years of experience in Power Bi.
• 1.5+ years of experience on Azure SQL.
• 1.5+ years of experience on SQL
• Experience on Azure SQL and Power Apps, Azure Analysis Services.
• Having Good Experience on Power BI Desktop and Service Development and worked on
the Power BI Reports & Dashboards with SQL Server.
• Imported data from multiple data sources into BI Tools, created relationships between
data, created calculated columns and measures using DAX Query.
• Good Expertise on working with Import Data source, Direct Query, Power Query in Power BI
• Having experience in creating different charts like Line chart, bar chart, table, matrix table, area chart, scattered chart, tree map.
• Experience in creating different custom visualizations like Donut chart, waterfall chart, and gauge chart, bar chart etc.
• Experience on creating azure account, resources and Blob Storage, Servers and Databases in AZURE Services.
• Experience on Migrate On-premise databases to Azure SQL using DACPAC, BACPAC, DM (Data Migration Assistance).
• Experience in creating maps like filled map, shape map and having experience in using filters like page, visual, report and drill through filters.
• Experienced using standard visualizations like Slicer, Card, stacked column chart, Clustered column chart, Line and stacked column chart, Line and clustered column chart, and map.
• Comfortable in working with filters, calculated columns, measures, relationships and transformations of edit query section.
• Working on DAX functions to create Calculated Columns and Measures.
• Having experience in creating new measures for YTD, MTD, QTD growth analysis in power desktop.
• Used Aggregate DAX functions like SUM, SUMX, COUNT, COUNTA, MIN, MAX, hierarchies, charts, filters, quick filters, table calculations, calculated measures.
• Published/shared the reports by creating a content pack in app.powerbi.com.
• Having experience in creating Dashboards based on client requirements.

Education:
Bachelor Degree B.COM from Mewar University in 2018.

WORK EXPERIENCE:
Working as Software Engineer in
Webority technologiesform 2019 September till date.






Technical Skills:
BI Skills : SSAS, POWER BI
Databases : SQL Server, Azure SQL, AAS
Languages : MS-SQL, T-SQL

Project #

Title : Sales Analytical System
Client : SanDisk
Role : Power BI developer
Environment : Azure SQL, Blob Storage, Data Lake, Power BI
Duration : October 2021– Till Date

Description:
The Sales Analytical System will able to provide the information of business of the client. The
system helps in improving the sale of the business by providing information of customer details
according to the location. As the business of our client is expanding, he wanted to understand better
about the business and also to analyze the trend. It enables to perform risk analysis by providing
detailed information of the product’s history.

Responsibilities:
• Indexes, views, stored procedures and triggers are used using the SQL Server.
• Creating azure account, resources and Blob Storage, Servers and Databases in AZURE Services.
• Migrate On-premise databases to Azure SQL using DACPAC, BACPAC, DMA (Data Migration
Assistance).
• Build reports and dashboards using visualizations and custom visuals.
• Created Drill Down, Drill Through, and Bookmarks for navigation.
• Implemented Conditional Formatting on Tables and Matrix.
• Published the reports and dashboards from desktop to service.
• Created workspaces, add users, and give permissions to users.
• Share the content through Power BI Apps.
• Implemented Role Based Security as part of security in Power BI.



Project #
Title : RBC-PFS DW




Client : Royal Bank of Canada
Role : Power BI Developer
Environment : SQL Server, POWER BI
Duration : February 2020 – August 2021


Description:
This project is involved in the development of Data Warehouse for different kinds of Data Marts such
as Accounts, Loans, Credit Cards, Insurance, Arrangement, Condition, Event, and Application. Each
data mart represents a collection of data pertaining to a single business process. The Client requires
different level of analysis regarding loan amount, type of loans, type of customers, type of payment
schedules, interest rates (variable of fixed), defaulters list and the penal interest calculations, Credit
Payments etc.

Roles and Responsibilities:
• Created Drill Down, Drill Through, and Bookmarks for navigation.
• Implemented Conditional Formatting on Tables and Matrix.
• Published the reports and dashboards from desktop to service.
• Created workspaces, add users, and give permissions to users.
• Share the content through Power BI Apps.
• Implemented Role Based Security as part of security in Power BI.
• Created Calculated Measures, Columns and Tables with the help of DAX (Data Analysis
Expression)
• Implemented perspectives, Relationships and Handling the Active and Inactive Relationships.
• Handling the Many TO Many Relationships in SSAS Tabular Model.