Krishna K

Experience

1. Power Bi Developer

   Solix, Inc.

   Apr 2023 — Present · NJ, US

   Designed and implemented the ETL processes using SSIS which involved collection of data from sources like SQL Server 2016. • Participated in gathering User Requirements and System Specifications for dimensioning modeling of data warehouse.• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports. • Developed JSON Scripts for deploying the Pipeline in Azure Data Factory (ADF) that process the data using the SQL Activity.• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing.• Developed ETL process to transform the data from different systems using the ADF pipelines and used Data Lake process in-order to perform data massaging or conversions.• Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL data warehouse environment. experience in DWH/BI project implementation using Azure DF.• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps. • Generated Monthly, Yearly, Quarterly and daily reports in Power BI.• Worked and joining the queries and merging the tables in Power BI.• Worked and joining the queries and merging the tables in Power BI.• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to Power BI Service.• Expertise in DAX & MDX Languages which helps in understanding and analyzing the data.• Explore data in a variety of ways and across multiple visualizations using Power BI.• Developed and deployed SSIS packages, configuration files and scheduled job to run the packages to generate data in CSV files and Flat files. • Automated File Transfer Processes and mail notifications by using FTP Task and Send Mail task in packages.