Arkit Shah

Developed 10+ robust ETL pipelines using Microsoft SSIS and Azure Data Factory for data cleansing, transformation, and incremental loads in the Data Warehouse. Collaborated in an Agile Software Development Environment, implementing business logic with T-SQL Stored Procedures, Common Table Expressions, User Defined Functions, Azure Functions (Python), and Logic Apps. Extracted data from varied sources and utilized it for generating 50+ insightful Tableau reports for analyzing sales performance and customer feedback to enable data-driven decision making. Designed 5+ flexible Data sources in Tableau for year-to-year sales performance comparisons, enabling comprehensive analysis and reporting. Orchestrated the migration of 50+ Data Sources and Reports from QlikView to Tableau, enhancing data visualization capabilities and improving the user experience. Streamlined the decommissioning of processes in On-premises servers, transitioning 30+ processes to the Azure Platform. Mentored and empowered Business Intelligence interns and new hires, providing guidance and setting them up for success.

Created Dashboards in Tableau for automated monitoring of daily processes, resulting in time savings of 3+ hours per day. Delivered support to users across diverse business areas and teams, conducting maintenance checks and daily monitoring. Implemented a robust Row-Level Security mechanism in Tableau on Data Source level, ensuring secure access for 100+ external operators. Achieved a 20-30% performance boost through ETL optimization and Efficient Indexing, leading to notable enhancements in data processing speed and system efficiency. Managed licenses for 200+ users in QlikView and Tableau, configuring permissions, resolving access issues, and addressing various data related concerns. Developed Workbooks in Tableau to monitor ETL Pipelines and 200+ jobs, providing visibility into data-related errors and rejections.