Naren D.

Principal Data Analyst Bi Lead Developer @Capital One

Plano, TX, US

Gathering the report requirements from various stakeholders, cross functional departments, business users and documenting them in the reports specifications document and report inventory.Build, publish customized interactive reports and dashboards, report scheduling using Tableau desktop/server and acted as POC for all the Sales and Originations reports and Amazon Connect reports.Designed and built critical hierarchy rollup tables for RANKING the associates/territories based on the performance, quality, economics, customer relations, SLA, inventory and call metrics.Created Action filters, Context filters, Quick filters, Cascading filters, Parameters and calculated sets for preparing interactive dashboards and worksheets in Tableau and effectively used data blending feature in tableau.Involved in creating a Python framework that automates the addition of new metrics into the reports without any manual effort.Worked with a diverse team on a decommissioning project from Cassandra to Snowflake DB & MEMSQL warehouses.Understood the data transformations in Cassandra and developed complex codes in Snowflake as per the new model to populate key metrics for BI/reporting. Worked on internal frameworks to export data to Amazon S3 and created Symphony pipelines to flow data from Amazon S3 buckets to Snowflake (Extract, Load and Transform)Developed persisted metric layer for the Tableau layer and coded the metrics in such a way to process only the incremental records in the base table to improve the SQL performance and execution time drastically. Created New Schedule\'s and monitoring the health of reports on the server.Created metadata and lineage about the table developed, classified the sensitivity of data (NPI, API, PCI, etc.) as per the Data risk policies and documented all the code, process for easy transition to the business teams.(Data Risk Management and Data Governance).