Anirudh Kalva

Designed and implemented Alteryx ETL pipelines with API-based Salesforce integrations, enabling seamless system-to-system data flow, eliminating manual entry, and ensuring high-quality data for a manufacturing client.

Led the strategic migration of over 50 Tableau dashboards and associated data sources to Power BI for a mortgage services client. Having originally designed and built the Tableau reporting ecosystem, conducted a detailed usage and consumption analysis to identify high-impact reports, redundancies, and optimization opportunities. Developed a phased migration roadmap aligned with business priorities and executed the transition end-to-end, including data model redesign, DAX development, validation, and stakeholder enablement. The migration ensured continuity of executive and operational reporting while improving governance, performance, and platform standardization following the organization’s shift to Power BI.

Worked on complex operational and executive-level Excel reports consumed by CXO stakeholders, integrating data from OData sources and other enterprise systems. Performed advanced ETL transformations using Power Query, including lookups, aggregations, pivots, and data modeling to prepare analytics-ready datasets. Automated report generation and distribution processes to deliver weekly insights to leadership teams. Additionally, extracted and transformed project data from Microsoft Project Pro to support operational reporting and decision-making.

I delivered Tableau solutions across industries, including banking, manufacturing, pharmaceuticals, education, and retail. As part of Tableau’s Expert Helpdesk program, I provided real-time technical support to customers and served as a Tableau SME. My experience includes building pixel-perfect dashboards focused on critical business KPIs, performance optimization, advanced calculations, and data storytelling. I have extensive experience publishing and managing content on Tableau Server and Tableau Cloud, including user, group, project, and permission administration. I have also developed Tableau Prep flows, implemented Tableau Bridge for data synchronization, and ensured reliable, secure, and high-performing analytics environments.

• Designed and implemented ELT pipelines using dbt integrated with Snowflake to build modular, version-controlled data models supporting analytics for manufacturing operations (production, inventory, quality, and supply chain).
• Ingested semi-structured data (JSON and XML) from source systems into AWS S3, then loaded into Snowflake via Snowpipe/COPY INTO for automated ingestion. Developed Python parsing scripts to flatten and normalize nested/variable-schema data prior to loading.
• Built layered dbt models (staging to intermediate to mart) following dimensional modeling best practices, using ref()/source() functions to maintain lineage. Implemented dbt tests (uniqueness, not-null, and referential integrity) to enforce data quality on datasets like production batch records and defect tracking. Used Jinja macros to standardize transformation logic across plants and business units.
• Leveraged Snowflake VARIANT columns for semi-structured storage and zero-copy cloning for dev/test environments.
• Partnered with plant operations and analysts to translate manufacturing data into curated, analytics-ready marts feeding BI dashboards. Tuned incremental models and materialization strategies to handle growing data volumes efficiently.