Kumaran Rsv

Results-driven Technical Architect with 10+ years of experience in Business Intelligence, Data Analytics, and Cloud Data Engineering. Proven expertise in leading enterprise-scale data migrations (MySQL to Snowflake, SAP BOXI/BODS to Tableau), architecting cloud-native analytics pipelines on AWS and Azure, and delivering actionable insights across Finance, Pharma, Supply Chain, and Banking domains.

Certified Tableau

Consultant with a strong command of SQL optimization, Snowflake schema design, Power BI, Python, and Agile methodologies. Adept at bridging business requirements with scalable technical solutions that drive operational efficiency and data-driven decision-making.

Technical Architect - Hexaware Technologies - Bengaluru, India

(2025-08 - 2026-04)

Provided strategic leadership for the enterprise-wide data infrastructure migration from MySQL to Snowflake and SAP BOXI/BODS to Tableau, architecting scalable pipelines that align with long-term organizational BI strategy.

• Designed and optimized Snowflake data schemas and table structures — data modeling and data warehousing — using advanced SQL, ensuring scalability, partitioning strategy, and reliability for future data growth.
• Optimized complex SQL queries across multi-table datasets, performing performance tuning to reduce execution time and ensure data accuracy and integrity across analytics layers.
• Built advanced Tableau Desktop dashboards and performed dashboard performance tuning—leveraging LOD calculations, dynamic filters, and parameter-driven controls—to achieve 95% user adoption within the first month.
• Managed Agile sprint cycles as technical lead, maintaining a 98% sprint completion rate through structured planning, proactive Stakeholder Management, and seamless Cross-functional Collaboration.
• Delivered end-user training sessions, user manual documentation, and dashboard demos; provided production support by reviewing and validating reports prior to production server deployment.
• Developed Python scripts to automate Tableau Server administration tasks, incorporating robust access management and extract-refresh scheduling, which cut manual maintenance overhead.
• Architected and implemented enterprise-grade Row-Level Security (RLS) on Tableau Server to enforce strict data governance and secure multi-tenant reporting across global business units.
• Leveraged AWS S3 as a cloud data lake for staging and storing raw source data, enabling seamless ingestion into Snowflake for Tableau dashboard consumption.
• Automated S3-to-Snowflake data pipeline using Python scripts, reducing manual data transfer effort and ensuring fresh, reliable data for Tableau reporting.
• Managed Tableau extract (.hyper) backups and versioned storage on AWS S3, enabling rapid disaster recovery and consistent access across global business units.
• Provisioned and managed Azure cloud infrastructure for Tableau Server deployment, ensuring high availability and scalable compute resources for enterprise BI workloads.
• Designed data pipelines using Azure Data Factory to ingest and transform source data into Snowflake, enabling seamless Tableau dashboard consumption.
• Utilized Azure Blob Storage for staging raw data extracts and managing Tableau .hyper backup files, supporting disaster recovery and data governance.

Business Intelligence Architect & Developer - Sagent Pharmaceuticals - Telangana, India

(2024-02 - 2025-06)

Supported Supply Chain Management (SCM) analytics covering end-to-end manufacturing from raw materials to finished injectable products, integrating data from IMS, IQVIA, TMS, TrackWise, and Smartsheet.

• Developed critical financial reports including EPCIS Tracker, REP Net Sales Activity, PR Charge Backs, and Month-End Finance Reports, enabling timely regulatory and operational reporting.
• Performed IMS Monthly Process and Financial Data Reconciliation, ensuring accurate alignment between source systems and analytical outputs.
• Translated complex business requirements into technical architecture specifications; designed derived columns and user-friendly parameters to improve report usability for non-technical stakeholders.
• Implemented multi-source data blending in Tableau; managed Power BI service backup, restore, and custom view enhancements on cloud platforms.
• Diagnosed and resolved Talend TIC integration issues on a daily basis, minimizing pipeline downtime and ensuring data pipeline continuity.
• Built Python automation scripts to streamline data reconciliation workflows across IMS, IQVIA, and Smartsheet sources, improving data accuracy and reducing manual validation effort.
• Utilized AWS S3 for staging and storing source data from IMS, IQVIA, and Smartsheet, enabling efficient ingestion into Tableau for supply chain and financial analytics.
• Automated archival of monthly financial reports (EPCIS Tracker, REP Net Sales, PR Charge Backs) to AWS S3, ensuring secure, audit-ready storage and easy retrieval.
• Designed Python-based ETL workflows to move data from AWS S3 into Tableau data sources, streamlining data integration across multiple pharma supply chain systems.
• Leveraged Azure SQL Database for storing and querying pharma supply chain data, enabling efficient data source integration with Tableau dashboards.
• Architected ETL workflows using Azure Data Factory to automate data ingestion from IMS, IQVIA, and Smartsheet into Tableau-ready datasets.
• Stored and archived financial reports (EPCIS Tracker, REP Net Sales) in Azure Blob Storage, ensuring secure, audit-compliant data retention.

Analytics Consultant - Wells Fargo - Bengaluru, India

(2023-06 - 2024-02)

Developed and maintained Tableau and Power BI dashboards for the Financial Delivery unit, supporting Glidepath, Location Strategy Golden Copy, and Weekly Loans & Deposits programs.

• Designed KPI metrics (MTD, QTD, YTD) using time intelligence functions; created heat maps, waterfall charts, bar/column charts, and geographic maps for financial performance tracking.
• Applied multi-source data blending and Agile Kanban methodology (Jira) to deliver high-priority financial reports under tight SLA requirements.
• Collaborated with offshore teams and project managers to gather requirements, investigate data quality issues, and deliver validated, production-ready dashboards.
• Led comprehensive Requirement Gathering sessions with business leads to translate complex operational challenges into actionable, persona-based BI solutions and technical specifications.
• Conducted deep-dive exploratory analysis on financial datasets to identify anomalies and actionable patterns, directly informing the design of persona-based dashboards and strategic BI initiatives.
• Created Python-based ETL automation to integrate multi-source financial data for Tableau dashboards, accelerating data refresh cycles and enabling timely KPI reporting.
• Connected Tableau dashboards to Azure SQL Database for real-time financial KPI reporting, supporting Glidepath and Loans & Deposits programs.
• Developed Python-based ETL scripts to move financial data from Azure Blob Storage into Tableau data sources, accelerating monthly reporting cycles.
• Managed Power BI Service deployment on Azure cloud platform, handling backup, restore, and custom view configurations for enterprise reporting.

Business Intelligence Developer - Stratsol Software Systems - Hyderabad, India

(2022-06 - 2023-03)

Delivered end-to-end BI solutions across Banking, Automotive, and Oil & Gas sectors using Power BI, Tableau, SSIS, SQL Server, Power Query, Power Pivot, and Power View.

• Designed and implemented ETL pipelines and data transformation workflows using Microsoft BI suite; documented and monitored data extracts for reliability across SDLC phases.
• Built interactive executive dashboards with DAX-based measures, advanced SQL queries, and Tableau visualizations that surfaced actionable business insights.

Senior Consultant - Bristlecone (Mahindra Group) - Bengaluru, India

(2021-07 - 2022-06)

Developed Balance Sheet and Income Statement visualizations in Tableau and Power BI, connected to PostgreSQL; created KPIs for C-suite and top management reporting.

• Built dashboards with dual-axis comparisons, trend lines, bookmarks, and table calculations for quarterly sales performance analysis; optimized dashboard load time for large-volume data sources.
• Leveraged DAX language and SQL Server for complex data modeling; ensured daily data source refresh, accuracy, and performance optimization across all deployments.

Senior Financial Reporting Analyst - Kelly Services - Bengaluru, India

(2017-01 - 2021-07)

Led end-to-end design and deployment of Power BI and Tableau dashboards (pie charts, bar charts, tree maps, geographic maps) for sales and operational reporting.

• Built KPI frameworks using time intelligence (MTD/QTD/YTD), trend lines, and table calculations; managed scheduled extracts and refresh cycles via Power BI Service.
• Validated and tested all reports for data accuracy before production release; translated business requirements into structured analytical dashboards for cross-functional stakeholders.

Sales Analyst - Akamai Technologies - Bengaluru, India

(2014-07 - 2015-06)

Managed sales data extraction, validation, and reporting for regions including Inside Sales Media, ECG High Tech, and ECG VAR LATAM; delivered executive-ready VBA dashboards in MS Excel.

• Translated customer needs from Sales teams into valid service orders; partnered with data owners and master data process teams to resolve data quality issues and maintain governance standards.
• Established Business Intelligence Center of Excellence practices to standardize dashboard development, analytical reporting, and ad-hoc report delivery.

Bachelor of Commerce - Finance - Bangalore University (2006-06 - 2009-03)