Summary
Overview
Work History
Education
Skills
Timeline
Generic

Harish V

Summary

Accomplished Technical Specialist with over 8.6+ years of comprehensive experience in business intelligence and data management, driving impactful solutions through advanced data integration and visualization techniques. Proficient in SSIS, SQL Server,Snowflake,Azure Data factory, Microsoft Fabric, Copilot, Mosaic Tools and Power BI, leveraging these tools to enhance data workflows and optimize performance. Demonstrated expertise in ETL processes, data transformation, and performance tuning, ensuring robust data delivery for insightful decision-making. Committed to delivering high-quality results and fostering collaborative environments to achieve required goals.

Overview

12
12
years of professional experience

Work History

Technical Specialist

LTIMINDTREE
01.2021 - Current
  • Conducting detailed analysis, generated insights and visualizations and published report based on company wide data.
  • Improved data accuracy, viability and value by improving and streamlining processes regarding data flow and data quality.
  • Converted over 20-25 manually uploaded excel and power point reports into fully automated power bi dashboards for the CFO.
  • Worked on SQL to Snowflake data migration for all power bi dashboards assigned to me and developed all ETL packages in internal tool Mosaic as part of this migration.
  • Built Power BI Dashboards for various business requirements and domains like Finance, PSC, HR, Operations, Manufacturing, Visa among others.
  • Developed SQL queries/Stored Procedures as needed for report requirements.
  • Worked on SQL to Snowflake data migration project for few Power BI Dashboards.
  • Experienced in advance DAX and Power Query transformations.
  • Optimized existing code/dashboards and created efficient new dashboards.
  • Reduced refresh time by many folds implementing incremental refresh in Power BI Dashboards.
  • Experienced in creating ADF Pipelines for various project requirements.
  • Utilized different sources like Azure, SQL, MySQL, Excel, Snowflake for Power BI reports.
  • Automated tasks using Logic Apps.
  • Worked on internal ETL tool Mosaic for migration projects.
  • After getting promoted got new responsibility of handling a team of 9 members and Mosaic has been decommissioned so worked on migrating the flows to Microsoft Azure DataFactory.
  • Migrated the flows( API based pipelines, SQL, Excel, OneDrive and Azure Data Storage) as Data Sources and various Data Sources.
  • Explored more on Azure Data Factory and trained new resources on it and help them monitor daily data load activities.
  • Explored new technology called Microsoft Fabric.
  • Working on migrating few flows from Azure Data Factory to Microsoft Fabric.
  • Explored more activities in Microsoft Fabric like Snowflake Mirror,DataAgent, Copy Activities, Creating reports based on the data available in the OneLake.
  • Working on moving data from Snowflake to OneLake and exploring the feasibilities.
  • Exploring new tools, data sources in Power BI like new visualizations.
  • Good exposure to HR, Marketing, Sales and Finance domain.
  • Developed more complicated Power BI reports from scratch.
  • Exploring more possibilities on Copilot.
  • Environment: MS SQL Server 2016, SSIS, SSRS, ETL, T-SQL, Visual Studio 2016, SQL Server Profiler, Mosiactools, Microsoft fabric, ADF, COPILOT, Dashboard, SQL Server Management Studio, Power BI

Power BI Developer

Accenture
09.2018 - 09.2019
  • Developed and optimized SSRS reports, Power BI dashboards, from the source SSMS and AXDynamics 2012 R2,R3, using T-SQL to enhance data visualization and decision-making.
  • Led data integration initiatives utilizing SQL Server Integration Services (SSIS) for efficient ETL processes.
  • Collaborated with cross-functional teams to gather requirements and deliver tailored BI solutions.
  • Implemented performance tuning strategies for SQL queries and data models, improving data retrieval times.
  • Provided training and support for end-users on BI tools, fostering a data-driven culture.
  • Client: Denmark Medical Project
  • Description: Hearing Aid manufacturing company for Wholesale.

Data Curator

Zen3InfoSolutions
10.2013 - 02.2016
  • Involved in designing functional specifications.
  • Involved in Code Development and User Interface.
  • Involved in Development and Execution of the test cases.
  • Executing Test cases should go through the uni-testing.
  • Preparation of Unit Test Cases.
  • Environment: SSIS, SSRS, SQL Server 2005

Education

MBA - Marketing

NMIMS
01.2017

B.Tech - Computer Science

Andhra University
01.2010

Skills

  • Power BI
  • Microsoft Fabric
  • T-SQL
  • MDax
  • SQL Server 2012 and above
  • Microsoft ADF
  • MSBI
  • Snowflake
  • MS Office
  • SSIS
  • SSRS
  • Microsoft ADF
  • Mosaic tools
  • Azure data storage

Timeline

Technical Specialist

LTIMINDTREE
01.2021 - Current

Power BI Developer

Accenture
09.2018 - 09.2019

Data Curator

Zen3InfoSolutions
10.2013 - 02.2016

MBA - Marketing

NMIMS

B.Tech - Computer Science

Andhra University

Similar Profiles

CREATE PROFILE
Harish V