Tatwa Ranjan Acharya

Knowledgeable Cloud Data Architect with proven track record in designing and implementing robust data architectures. Successfully developed scalable solutions and enhanced data management frameworks to support critical business operations. Demonstrated expertise in data modeling and database design, consistently ensuring data integrity and optimizing performance.

Duration: Feb 2025 – Present | Role: Data Architect
Description:
Designed and implemented a Customer 360 platform by integrating data across ERP, Patient Portals, and Diagnostics to enable unified reporting and AI/ML-driven analytics.

Responsibilities:

• Architected scalable, secure Snowflake data platform
• Developed a common healthcare data model for semantic consistency
• Built ELT pipelines using Snowflake, dbt, and Azure Data Factory
• Implemented data masking, encryption, and quality checks for HIPAA compliance

Tech Stack: Snowflake, dbt, ADF, Azure DevOps | Platform: Azure, Snowflake

Duration: Oct 2023 – Jul 2024 | Role: Data Architect
Description:
Developed Snowflake-based data warehouse to reduce insight lead time, forecast claims, and enable targeted marketing for a growing customer base (35M to 120M).

Responsibilities:

• Migrated legacy SQL Server to Snowflake ensuring data integrity
• Modeled data to enable segmentation and campaign personalization
• Built scalable ELT pipelines for financial and transactional data
• Implemented data auditing, validation, and accuracy checks
• Improved campaign effectiveness by 20%

Tech Stack: Snowflake, dbt, ADF, Azure DevOps | Platform: Azure, Snowflake

Duration: Jul 2023 – Oct 2023 | Role: Data Architect
Description:
Delivered personalized EV charging insights and cost-saving recommendations using data from Smart Car APIs.

Responsibilities:

• Developed Lambda functions for proxy API calls to SmartCar
• Ingested, flattened, and modeled EV charging data
• Applied business logic for savings calculation in Redshift
• Automated email reports using Azure Data Factory

Tech Stack: PySpark, Redshift, AWS Glue | Platform: AWS

Duration: Aug 2022 – Feb 2023 | Role: Data Architect
Description:
Led cloud migration of financial data warehouse from SQL Server to Snowflake.

Responsibilities:

• Designed Snowflake data architecture for financial operations
• Converted dimensional model to Data Vault 2.0 using dbt
• Developed CICD pipelines in Azure DevOps
• Built migration accelerators and contributed to Analytics CoE
• Participated in RFP solutioning for enterprise clients

Tech Stack: Snowflake, dbt, Azure DevOps | Platform: Azure, Snowflake

Duration: Jan 2020 – Apr 2021 | Role: Database Lead
Description:
Built centralized ingestion pipelines for structured and semi-structured data sources into Snowflake.

Responsibilities:

• Led offshore team of 8 for ingestion platform delivery
• Designed Python-based ingestion framework (70% automation)
• Tuned Snowflake performance and improved data load efficiency
• Oversaw agile cycles and stakeholder communications

Tech Stack: Python, Snowflake, AWS | Platform: AWS

Duration: Sept 2018 – Jul 2019 | Role: Data Engineer – Specialist
Description:
Migrated legacy BIDE platform from Hadoop to Snowflake, modernizing CX reporting infrastructure.

Responsibilities:

• Rewrote 120+ Scala scripts to SnowSQL and Python
• Created execution pipelines and reporting data marts
• Evaluated and re-architected legacy platform components

Tech Stack: Scala, Python, Snowflake | Platform: AWS

Duration: Jul 2016 – Jun 2018 | Role: Senior Data Engineer
Description:
Developed data pipelines for analytics over 75 PB data and 120M+ users.

Responsibilities:

• Delivered curated and cleansed datasets for data science use
• Designed and optimized data transformation pipelines

Tech Stack: Vertica, Teradata, Autosys, Business Objects

Duration: Jul 2011 – Jun 2016 | Role: System Analyst
Description:
Enabled enterprise BI solutions on EDW across sales and supply chain domains.

Responsibilities:

• Created ETL pipelines and data models for semantic layer
• Performed data transformation, optimization, and reporting
• Designed BO universes and developed dashboards

Tech Stack: Teradata, Vertica, SAP BO, Unix, Autosys