Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Tharun Krishna

Kitchener,ON

Summary

Results-driven Azure and BI Engineer with 5 years of experience in developing advanced data models and dashboards using Power BI and Azure services to streamline enterprise reporting. Skilled in data visualization, statistical analysis, and database management, with a proven ability to deliver impactful insights and drive strategic business decisions. Proficient in Python, SQL, and Excel, with a strong focus on teamwork, adaptability, and analytical thinking to deliver robust data solutions and actionable recommendations. Recognized for reliability, problem-solving, and a results-oriented approach.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Data Analyst

BCLC
02.2024 - Current
  • Designing and implementing data retention policies in Azure Synapse to manage data lifecycle and compliance requirements
  • Creating and expertly managing data storage and file systems within Azure Data Lake, organizing data for easy retrieval and management
  • Orchestrating the comprehensive management of data lifecycle stages within the Azure Purview environment
  • Implementing advanced Power BI features such as drill-through, cross-filtering, and bookmarks for enhanced data exploration
  • Implemented SQL server auditing features to track database activity and maintain an audit trail for compliance and security purposes
  • Utilized Python's asyncio and aiohttp libraries for high-performance web scraping
  • Thoughtfully engaging with data analysts and report consumers, gaining deep insights into their unique reporting needs and delivering exemplary results using SSRS
  • Experienced in collaborating with team members using Git, including resolving merge conflicts and reviewing code changes
  • Implementing and managing data integration with cloud-based data sources in Azure Data Factory, enabling seamless cloud-to-cloud integration
  • Utilize Snowflake native support for semi-structured data such as JSON and XML, allowing for the ingestion and processing of diverse data types
  • Crafting comprehensive data quality standards within Azure Purview to ascertain data accuracy and consistency across the board
  • Implementing Power BI's integration with Azure Analysis Services for high-performance data analysis
  • Conducting performance testing and optimization of Power BI reports and dashboards to enhance query performance and user experience
  • Implementing best practices for data security, access control, and compliance with data governance policies in Azure Databricks
  • Configure Snowflake data sharing for sharing data with external parties securely and efficiently
  • Integrated data from multiple sources, including databases, APIs, flat files, and cloud storage, using ETL tools and technologies
  • Diligently monitoring data integration performance and resource utilization, proactively optimizing costs and efficiency within Azure Data Factory, ensuring a symphony of cost-effective data orchestration
  • Established data quality governance frameworks to define roles, responsibilities, and escalation procedures
  • Utilizing advanced data modeling techniques to create OLAP cubes that accommodate complex business scenarios
  • Managing and fine-tuning Azure Data Lake Storage, optimizing its performance and scalability
  • Thoughtfully designing and implementing SSRS report layouts, skillfully incorporating headers, footers, and groupings, creating reports that are organized and visually intuitive
  • Creating and maintaining data cubes, dimensions, hierarchies, and other SSAS database objects to support data storage and analysis needs
  • Conducted geodemographic segmentation to classify individuals or households based on their demographic and geographic characteristics, enabling targeted marketing strategies during data analysis
  • Implementing row-level security (RLS) in Power BI to control data access based on user roles and permissions
  • Integrating Azure Data Bricks with Azure Active Directory for seamless and secure user authentication
  • Develop and maintain dashboards and visualizations to communicate insights and trends to business stakeholders
  • Utilizing PostgreSQL support for server-side programming to implement custom database logic
  • Fine-tuning data loading and query performance in Azure Synapse, harnessing its full potential for accelerated data processing and analytics

BI and Azure Engineer

Interac
12.2022 - 02.2024
  • Utilized Python's socket module to implement network communication and socket programming
  • Setting up and overseeing data lake integration with Azure Firewall, fortifying network security and safeguarding data
  • Implemented SQL server change data capture (CDC) for capturing and tracking historical data changes
  • Harmonizing data integration with analytics and reporting platforms, orchestrating a grand performance of data-driven insights that take center stage within Azure Data Factory
  • Implementing synchronization and coordination with external systems to allow secure sharing of cryptographic keys in Azure Synapse
  • Implementing MongoDB security measures, such as encryption and access controls, helps protect data from unauthorized access
  • Developed and maintained scalable data pipelines for ingesting, processing, and transforming large volumes of data
  • Implemented data masking and data anonymization techniques within ETL workflows to protect sensitive data
  • Building and configuring Azure resources, including virtual machines, storage accounts, networks, and security groups
  • Implementing data security and access controls in Power BI through row-level security and other security mechanisms
  • Skillfully crafting and implementing cutting-edge package performance tuning tactics, including optimized buffer management and expertly executed parallelism, to unlock SSIS's true potential
  • Creating and managing Power BI datasets with calculated hierarchies for complex data navigation
  • Building and maintaining data pipelines and ETL processes to extract, transform, and load data from various sources into Power BI
  • Artfully designing and implementing report filters and data-driven filtering in SSRS, empowering users to explore data through interactive and precise filtering options
  • Generated auditing and compliance reports for databases, ensuring adherence to regulatory requirements
  • Implementing role-based security within SSAS to control user access to specific cube data and functionality
  • Configuring security roles to enforce data access restrictions and protect sensitive information
  • Developing and maintaining Power BI reports with dynamic visuals and conditional formatting for data highlighting
  • Designing and implementing custom data visualization and reporting solutions in Azure Data Bricks to present insights from big data
  • Employing Azure Purview's AI-driven recommendations to optimise data discovery and usage patterns
  • Implement Snowflake result caching feature to cache query results and improve query performance for frequently accessed data
  • Skills: Azure Synapse, Azure Data Lake, Azure Purview, Azure Data Factory, Azure Data bricks, Snowflake, python, SSIS, SSRS, SQLServer, PostgreSQL, PowerBI, Git, OLAP Cubes, SSAS, Stakeholder Communication, Problem-Solving, Collaboration

BI and Data Engineer

Axis Bank
02.2020 - 11.2022
  • Ensuring data security and access control by implementing report security measures in SSRS, deftly managing user access to reports and folders
  • Designed and implemented database views in PostgreSQL to provide simplified and optimized access to data
  • Implemented data replication and synchronization between data warehouses for data consistency and disaster recovery
  • Skillfully employing data wrangling techniques, transforming raw data into valuable nuggets of knowledge on Azure Data Lake
  • Enforcing data validation tasks within SSIS packages, guaranteeing data accuracy and consistency
  • Conducted sensitivity analysis to evaluate the impact of parameter changes on model outputs, enhancing the robustness and reliability of analytical insights through data analysis
  • Collaborated with database administrators to version control SQL scripts for database data seeding using Git, ensuring consistent data setup
  • Monitoring the usage and performance of Power BI reports and dashboards, identifying areas for improvement and optimization
  • Developed and maintained data governance governance frameworks to ensure data governance governance frameworks organizational learning and development
  • Diligently maintaining comprehensive SSIS package documentation, providing up-to-date and well-documented project records for effective management
  • Crafting and deploying containerized applications using Azure Kubernetes Service (AKS) as an Azure Developer, ensuring scalability and high availability
  • Implement best practices for SSIS data integration, including data governance, lineage, and security measures
  • Expertly configuring and managing Azure Data Factory self-hosted Integration Runtimes for seamless data integration with on-premises systems
  • Enabling user-friendly navigation through large reports with interactive features in SSRS, skillfully implementing report pagination and user interactions
  • Designing and developing advanced calculations and expressions using MDX or DAX in SSAS, creating complex calculations and expressions to support advanced analysis
  • Optimized database performance through cutting-edge tools and procedures, ensuring superior database operations
  • Crafting visually captivating data lineage representations through customisation options provided by Azure Purview
  • Utilizing Azure Data Bricks for anomaly detection and outlier analysis in big data
  • Designing and developing data warehouse solutions using SSAS as the primary ETL tool
  • Integrating SSAS with other components of the data warehouse architecture to ensure seamless data integration and accurate reporting capabilities
  • Develop and maintain data quality checks and data cleansing processes to ensure data integrity
  • Conducting data profiling and data quality assessments to ensure data accuracy, completeness, and consistency
  • Developing custom SSRS reports to complement Power BI dashboards, offering a comprehensive view of data insights
  • Developed SQL database monitoring and alerting systems for proactive issue detection
  • Skills: ETL, SQL, SSAS, PowerBI, SSIS, SSRS, Azure Synapse, Azure Firewall, Azure Purview, Azure Data Factory, Azure Data Bricks, MongoDB, Snowflake, Python(Socket Programming), Git, Data Security, Data Integration, Big Data Insights, AI-driven Recommendations

Education

Bachelor of Science - Computer Science And Engineering

Lovely Professional University
India

Skills

  • Azure Data Factory
  • SSAS and SSRS
  • Data Analysis
  • Azure Databricks
  • Azure Data Lake Storage
  • SQL Database
  • Azure Analysis Services
  • Azure Blob Storage
  • SQL Server Management Studio
  • Azure DevOps
  • MSBI
  • SSIS
  • T-SQL
  • Power Shell
  • Excel functions
  • SQL Profiler
  • SQL Server Data Tools
  • Power BI
  • ETL Development
  • Python programming

Certification

EDX Certified Data Analyst.

Timeline

Data Analyst

BCLC
02.2024 - Current

BI and Azure Engineer

Interac
12.2022 - 02.2024

BI and Data Engineer

Axis Bank
02.2020 - 11.2022

Bachelor of Science - Computer Science And Engineering

Lovely Professional University

Similar Profiles

CREATE PROFILE
Tharun Krishna