Sai K.

Sai K.

Data scientist

,

Experience: 4 Years

Sai

Data scientist

13345.8 USD / Year

  • Notice Period: 30 Days

4 Years

Now you can Instantly Chat with Sai!

About Me

  • Having 4.8 years of experience as BI Developer with a proven track record in Business Intelligence (BI), Data Warehouse (DWH) and Data Analytics. Proven ability to identify business needs and develop valuable solutions to drive accuracy and...
  • Over 3.1 Years of experience in Power BI Desktop, Power BI service & Power BI Premium
  • Delivered BI Solutions in Power BI and Tableau
  • Knowledge in Microsoft power apps, Microsoft flow, Power Automate, Power Robots and Report Builder.
  • Strong Experience in Data Analysis, Design, Implementation, Administration and Support of Business Intelligence.
  • Having Experience in designing Star schema, Fact constellation Schema, Fact and Dimension tables
  • Created Tables, Views, Constraints, Index
  • Integrated Custom Visuals based on Business Requirements using Power BI Desktop
  • Strong Experience in writing DAX (Data Analysis Expression) while Creating Custom Calculated Columns, Measures, Tables and Formatting etc., as per the Business needs
  • Having Strong Experience in Creating Dashboards and reports using Charts like Pie-Chart, Donut, Bar Chart, Word Cloud, Multi Row Card, Card, Map, Hear Map, Table, Matrix, Scatter Chart, Line Chart, Slicers etc., of Power BI.
  • Having Experience in Creating Hierarchy's and Drilldown, Drill up and Drill through Approaches
  • Having Experience in Sync Slicers, Buttons, Shapes in Power BI
  • Having Experience in Edit Queries of Power BI for Modelling the data like Append Data, Merge Queries and Using Joins, Group By, Conditional Column, Index Column and Other Data Cleansing Operations.
  • Having Experience in Publishing to Power BI Service and giving access control to Reports towards Various Departments for Business use
  • Implemented RLS (Row Level Security) on many reports by using Manage Roles and adding users into those roles in Power BI Service as per the Business Requirements.
  • Good knowledge on logical and physical Data Modelling using normalizing Techniques
  • Good Knowledge on SSIS and SSRS

Strong knowledge in End to End implementation

Show More

Portfolio Projects

Liberty Latin America

Company

Liberty Latin America

Description

Environment: MS Power BI, Power BI Pro, SQL, Windows 10.

Description: Liberty Latin America (NASDAQ: LILA and LILAK, OTC Link: LILAB) is a leading telecommunications company operating in over 20 countries across Latin America and the Caribbean under the consumer brands VTR, LCPR,LLA,CWC

Roles & Responsibilities:

  • Using SQL and Share point as data source imported data to Power BI Desktop and performed Data conversions and Data cleansing in Power Query like using Append Query, Merge Query, Table Extend, remove null and replace with empty space etc.…
  • Creating relationships as per the requirement in Data Model and using standard visuals like Table, Matrix etc., created interactive reports in Power BI.
  • Created calculated columns, measures and tables using DAX expressions as per the requirement
  • Implement RLS( Row Level Security) in Power BI Desktop
  • Have gone through Formatting options of various visuals like Conditional Formatting, Field Formatting, Selection Controls, Icons, and Filters.
  • Publish into Power BI service and Create Workspaces

 

Show More Show Less

Greif

Company

Greif

Description

Environment: MS Power BI, Power BI Pro, SQL, SSMS, Snow flake.

Description: Greif is a global leader in industrial packaging products and services and is pursuing its vision: In industrial packaging, be the best performing customer Service Company in the world

Roles & Responsibilities:

  • Using Snowflake data source create datasets and published into service and connect that source using Power BI Desktop.
  • Creating relationships as per the requirement in Data Model and using standard visuals like Bar Charts, Pie Chart, Donut, Scatter Chart, Waterfall Chart Slicers, Cards, Multi Card, Table, Matrix etc., created interactive reports in Power BI.
  • Created calculated columns, measures and tables using DAX expressions as per the requirement
  • Have gone through Formatting options of various visuals like Conditional Formatting, Field Formatting, Selection Controls, Icons, and Filters.
  • Develop Power BI reports & Effective dashboards after gathering and translating end user requirement.
  • Created Buttons for reset and added Bookmarks, Selection Pane and updated.
  • Implemented RLS as per the requirement and shared report access to the users accordingly.
  • Published Report to Power BI Service and shared to various users who exists on Power BI Service.
  • Installing Power BI gateways and Schedule Power BI reports.
  • Identified complex bug in data modelling and fixed it by creating Power BI table using values function and relating it as per the business requirement.
  • Documenting every report that has been developed.
  • Create Forecast reports for feature analysis

Show More Show Less

Axis Capital

Company

Axis Capital

Description

Environment: Microsoft Power BI, Tableau, Tableau Server 9.3, SQL Server 2012, Excel, CSV

Roles & Responsibilities:

  • Designed and documented the entire Architecture of Power BI Poc.
  • Expertise in writing complex DAX functions in Power BI and Power Pivot.
  • Used various sources to pull data into Power BI such as MS Sql Server, Excel, and CSV.
  • Implemented RLS by creating roles in Manage Roles and assigned roles to users on Power BI Service as per the requirements.
  • Develop Power BI reports & Effective dashboards after gathering and translating end user requirement.
  • Experience in resolving the client tickets.
  • Created Workspace and content packs for business users to view the developed reports.
  • Scheduled Automatic refresh and scheduling refresh in power bi service
  • Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
  • Weekly presentation to the business users about the reports and their changes as required.
  • Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
  • Worked and delivered all types of Report/Dashboards such as Insurance, Re-Insurance, Corporate, A&H.
  • Worked on all types of transformations that are available in Power BI query editor.
  • Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
  • Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
  • Designed and created data extracts, supporting POWER BI or other visualization tools reporting applications.
  • Created Reports using Charts like Pie-Chart, Donut, Bar Chart, Word Cloud, Multi Row Card, Card, Map, Hear Map, Table, Matrix, Scatter Chart, Line Chart, Slicers etc.,.
  • Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.
  • Created Drill Down Reports, Drill Through Report by Region.

Show More Show Less