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.
