Karthik Swamy

WORK HISTORY

EDUCATION

ABOUT KARTHIK SWAMY

Having 8+ years hands on experience in the software industry and proficient in working with Business Intelligence & Data visualization tools such as Power BI,SQL Server, and Excel.Having 4+ years of BI reporting experience, as a Power BI Developer (Power BI Desktop and Power BI Service) Proficient in designing interactive reports and dashboards using Power BI Desktop & publishing reports.Extensively worked on performing the ETL Activities in Power Query.Good Experience in filtering the Unwanted Data in Power Query.Extensively used transformations like add column, split column, pivot column, unpivot column, changing data type, Merge queries and Append queries.Good Knowledge in doing Data Modeling in Power Pivot Model.Familiar to write the DAX queries in Power BI, creating calculated measures, computed columns and table using DAX.Good knowledge in different Categories of DAX functions like Time Intelligence Function, Filter Functions, Date Functions, Logical Functions, Text Functions, Number and Statistical Functions for creating new information.Having valuable experience with Visual level, Page level, Report level and Drill Through filters for filtering the data in a Report.Good at creating native visualizations (table, matrix, kpi, gauge, various types of charts, and maps) and custom visualizations (Multi Slicer and Hierarchy Slicer, Histograms, Shape maps, Dual KPI, Bullet Chart, Heat Maps.Good knowledge on Power BI Service for creating APP Workspaces and adding the Members to APP Workspace to Manage the Content. Worked on On-Premise Data Gateway to Refresh and Schedule Refresh the Data in the Dataset.Good experience in publishing the Reports and Dashboards to Power BI Service along the outputs with applying row level security.Hands on Experience on writing SQL Queries as part of testing the Data.Good knowledge on Data warehouse concepts like Star schema, snow-flake schemas etc.