Goutham Kumar

The project aimed to enhance the National Bank of Canada's data processing capabilities, improve data reliability, and optimize cost efficiency by leveraging Microsoft Azure's cloud platform. The primary focus was transforming the existing data pipeline to support real-time analytics, scalable data processing, and efficient resource utilization. Insightful Power BI KPIs and dashboards helped stakeholders in data-driven decision-making.

Implemented autoscaling in Azure Databricks to dynamically adjust worker nodes based on workload demand for banking data processing. I optimized cost and performance, ensuring scalable and efficient data handling. A performance analyzer in Power BI helped optimize dashboard performance as well as SAMEPERIODLASTYEAR and USERELATIONSHIP in DAX helped in KPIs and also invoked inactive relationships, respectively.

I addressed and resolved data ingestion issues in AWS Glue and Lambda functions to improve the reliability of retail inventory data pipelines. I implemented solutions to ensure accurate and timely data for Walmart’s inventory management systems.

I used my understanding of legacy SAP BO dashboards and underlying .unx/.unv files to analyze table relationships among fact/dimension tables. I created a Tableau dashboard from scratch using the custom SQL query as DS, where we joined tables to bring in relevant attributes—used Table calculation String/Logical functions alongside date/time functions to create calculated fields, used sets for top N/bottom N functionality, parameters for sheet swapping, etc.

Discussions with stakeholders were done to understand their exact requirements, which were the conversion of BRD to a technical document, the building of calculated fields, various insightful charts like Waterfall charts for yearly growth in connections, network increment, dynamic insights based on filter selection, donut chart for regional percentage contributions, table calculations, sheet swapping, URL/filter actions for the summary to a detailed view of the dashboard, vertical/horizontal container for dashboard structuring, etc.

I managed and administered multiple big data platforms, including Hadoop, Kafka, HBase, and Spark clusters. I containerized nodes using Docker and orchestrated deployments with Kubernetes, enhancing the scalability and reliability of Bell Canada's data processing infrastructure. A customized calendar table was created to cater to time-based KPIs on the Power BI desktop, which communicates and calculates all the KPIs and further drills down from the summary table. FILTER, CALCULATE, SUMX, etc., are some of the DAX functions that are regularly used in this dashboard.