Balaji M. Email & Phone Number

India

Chennai, Tamil Nadu, India

• Implemented SQL Server to store metadata in SQL Tables, employing Stored Procedures for optimized data management and utilizing logging for output data tracking.• Designed and executed Azure Data Factory pipelines to trigger a function app responsible for posting messages into a service bus, enhancing data orchestration.• Leveraged Azure Databricks to meticulously validate a staggering 100 billion rows of output data, ensuring data integrity & accuracy.• Decoded payload data for diverse signals sourced from Data Logger, employing ARXML files to discern signal details, contributing to data interpretation.• Crafted insightful Tableau dashboards for in-depth analysis of distinct signals and their values in relation to Ground Truth values, aiding in data-driven decision-making.• Developed and maintained Python scripts for data extraction and transformation, resulting in a reduction in data processing time.• Developed custom SQL queries to create new data sources, improving data accuracy.• Customized dashboard templates, including complex tabular reports and various chart types, resulting in an improvement in data visualization effectiveness.• Administered Tableau infrastructure, ensuring security and optimal performance for a user base of over 2000.• Created schedules and permissions, publishing data sources and dashboards on Tableau Server.

Chennai, Tamil Nadu, India

• Orchestrated a retail project aimed at enhancing planning and accuracy, resulting in improved overall business performance.• Directed the implementation and management of Azure Data Factory (ADF) solutions, optimizing data processing efficiency.• Led the development of multiple ADF pipelines and Data Flow workflows for automated data extraction, cleansing, transformation, and loading into DB. • Produced comprehensive Low-Level Design documents, including data flow diagrams and Tableau templates, ensuring alignment with project objectives.• Managed access provisioning and facilitated the production of weekly reports to streamline communication and reporting.• Resolved client-reported issues related to Azure and Tableau, providing prompt and effective solutions.• Optimized report generation time through the utilization of various functions (logical, numeric, string, aggregation, date).• Streamlined dashboard performance with context filters and performance actions, resulting in a faster load time.• Designed and deployed dashboards featuring a variety of Tableau visualizations, such as bar charts, line charts, pie charts, and donut charts, elevating data presentation and comprehension.