Karna S.

Karna S.

Data Architect | MSBI | Azure Data Platform | Power BI SME

New Delhi , India

Experience: 11 Years

Karna

New Delhi , India

Data Architect | MSBI | Azure Data Platform | Power BI SME

75793.6 USD / Year

  • Start Date / Notice Period end date: 2021-10-02

11 Years

Now you can Instantly Chat with Karna!

About Me

10.5 + years of experience working in IT. I have worked in various roles such as Cloud Data Architect, Data Warehouse Architect, Product Specialist, and Analyst.

 

  • Has experience of leading the Data Analytics Pr...

    Show More

Skills

Networking & Security

Operating System

Graphic Design

Portfolio Projects

Data Services

Company

Data Services

Description

  • Desing the Intial Cloud migration Stretagy for the on Prem Data Warehouse.
  • Developed the comonent with parallel execution for the faster cloud data migration
  • Designed the data model, deployment architecture, hardware sizing for the Data Services requirement implemented using SQL Server.
  • Worked on design for the Azure migration approach of the On-Prem Data Warehouse.
  • Implemented Self-service BI solution.
  • Created SSIS packages to the data from legacy data source system to SQL Server. Implemented a variety of transformations, for example Slowly Changing Dimensions, Look up, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
  • Involved in creation of Tabular Data Model and DAX calculations for SSAS.
  • Hosted the SSAS services on IIS for the HTTP Access

Show More Show Less

Health Information Exchange - Data Services

Company

Health Information Exchange - Data Services

Description

Technical Skills :Azure SQL Database, Azure DWH, Azure Data Lake Store, SQL Server 2016/14/12, SSAS, SSRS, SSIS, Power BI, Tableau, SAP BO

  • Desing the Intial Cloud migration Stretagy for the on Prem Data Warehouse.
  • Developed the comonent with parallel execution for the faster cloud data migration
  • Designed the data model, deployment architecture, hardware sizing for the Data Services requirement implemented using SQL Server.
  • Worked on design for the Azure migration approach of the On-Prem Data Warehouse.
  • Implemented Self-service BI solution.
  • Created SSIS packages to the data from legacy data source system to SQL Server. Implemented a variety of transformations, for example Slowly Changing Dimensions, Look up, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
  • Involved in creation of Tabular Data Model and DAX calculations for SSAS.
  • Hosted the SSAS services on IIS for the HTTP Access

Show More Show Less

Microsoft I CoE

Company

Microsoft I CoE

Description

Technical Skills :SQL Server 2016/14/12, SSAS,SSRS,SSIS,Power BI, SharePoint 2013 BI, Azure SQL Database ,Azure ML, Azure DWH, Azure Data Factory

  • Involved on the requirement gathering and effort estimations for the different RFPs
  • Provided data model, Deployment architecture, hardware sizing, Conceptual architecture for the Enterprise dashboard requirement implemented using SQL Server
  • Implemented Self-service BI solution using Power BI and SharePoint BI.
  • Developed the XMLA Scripts to automate the SSAS Cube Partition processing and process logging operations of SSAS objects using PowerShell
  • Created SSIS packages included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion
  • Developed Calculations including the time intelligence and KPIs using MDX in the multi-dimensional cube.
  • Involved in creation of Tabular Data Model and DAX calculations for SSAS 2014
  • Created the reports with various Microsoft reporting platforms like SSRS, Power View, Power Pivot and Performance Point Services
  • Designed Ad hoc reports, Drill down reports, stepped reports, matrix reports, and table reports.
  • Designed and Deployed reports in SQL Server Reporting Services (SP Integrated) and SharePoint PerformancePoint Services.

Show More Show Less

DES Power BI Analytics

Company

DES Power BI Analytics

Description

Technology : SQL Server 2014, SSIS, Power BI

  • Involved on the requirement gathering and effort estimations
  • Designed the end to end System Architecture along with the Data Model, Deployment architecture
  • Created the SSIS Packages to Load the data from On-Premise database to Azure Blob storage on scheduled bases.
  • Designed and Deployed Power BI Dashboards and Reports with the scheduled data refresh.

Show More Show Less

Tools

Power BI

UA Carbon foot print Analytics

Company

UA Carbon foot print Analytics

Description

Technical Skills : SQL Server 2012,SSIS, Power BI, Share Point,SSAS

  • Proactively involved to find business problem and proposed the best suited solution using existing stack of software and skills.
  • Designed the end to end System Architecture along with the Data Model.
  • Developed the Power view reports integrated with Share Point using Power Pivot SSAS Instance.
  • Designed Deployment architecture and implemented the same on Share Point Power Pivot Instance of SSAS.

Show More Show Less

Tweeter Classification and Sentiment Analytics

Company

Tweeter Classification and Sentiment Analytics

Description

Technical Skills : Azure DWH, Azure Machine Learning, R ,Azure Data Factory, Power BI, Azure Stream Analytics

  • Created ADF jobs to load the data to the Azure DWH.
  • Created the Azure ML model to classify the sentiment of the Tweets using classification algorithms.
  • Created R scripts for the data cleansing and formatting.
  • Designed and Deployed Power BI Dashboards to show real time tweet analytics using Stream Analytics.

Show More Show Less

PMART (Performance Monitoring, Analysis and Reporting Tool)

Company

PMART (Performance Monitoring, Analysis and Reporting Tool)

Description

Technical Skills : SQL Server 2014,Windows server 2012,SSRS,SSIS,SSAS.

  • Created SQL Agent job for SQL Server Profiler Analysis Services trace data.
  • Designed and Deployed SSIS packages for Loading the trace data in to the Data base using automated SQL Agent job.
  • Configure the Management Data Warehouse to collect Analysis Services Performance counters.
  • Designed and Deployed SSRS, Power View Reports for visualizing the performance related data.

Show More Show Less

Banking Analytics Solution with Customer Churn Model

Company

Banking Analytics Solution with Customer Churn Model

Description

Technical Skills : SQL Server 2014,SSAS,SSRS,Share Point 2013, SharePoint BI, Power BI,Azure Machine learning ,R

  • Involved in designing the data model for the Banking Analytics solution
  • Involved to planning and designing SSAS 2014 Cubes
  • Worked on building attribute relationships, Hierarchies and Fact Dimensions.
  • Created the Azure ML model to predict customer churn using classification algorithm.
  • Designed and Deployed the reports with various Microsoft reporting platforms like SSRS, Power View, Power Pivot and Performance Point Services

Show More Show Less

GTEL Analytics and Reporting

Company

GTEL Analytics and Reporting

Description

Technical Skills : SQL Server 2005, SSAS 2005 and 2008, SSIS 2005, SSRS,.NET

  • Involved in Business Process, Client and prospective business demo’s and interaction with BA and end users.
  • Investigating and gathering the requirements.
  • Deployment of SSIS packages, SSAS Cubes and SSRS reports
  • Developed Stored Procedures, Triggers, and SQL scripts for performing automation tasks for SQL Server 2005.
  • Involved in Creation, Development and Deployment of SSIS packages
  • Responsible for Effort estimation, Analysis, Design, Development, UAT Support, Implementation, Post Implementation Support and Quality

Show More Show Less
Share: