UMESH TARE
Portland
Summary
Accomplished Senior Technical Specialist at CitiusTech Inc., I excel in architecting scalable Snowflake-based data solutions and leading diverse teams. My expertise in data governance and performance optimization has driven significant improvements in healthcare analytics, ensuring robust data quality and security while fostering collaboration and knowledge sharing across teams.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Senior Technical Specialist – Data Architect / Solution Architect
CitiusTech Inc.
Portland
03.2024 - Current
- Designed and implemented scalable Snowflake-based cloud data warehouse supporting multi-domain healthcare analytics.
- Architected and led team of 4–8 onshore engineers to deliver enterprise healthcare data platform solutions.
- Optimized Snowflake workloads using micro-partition pruning, clustering strategy, transient tables, zero-copy cloning, and time travel.
- Developed Airflow orchestration pipelines on AWS, incorporating incremental load logic, source validation triggers, and automated failure alerts to enhance data processing reliability.
- Implemented SCD Type 1/2/4 and CDC frameworks, alongside temporal loading strategies, to support historical and incremental data management.
- Built enterprise DBT framework for transforming semi-structured JSON/VARIANT data into curated dimensional models.
- Designed hierarchical DAG dependencies and custom regression testing framework prior to DBT native testing evolution.
- Implemented row-level and column-level security policies for HIPAA-aligned data access governance.
Senior Technical Specialist – Data Architect
CitiusTech Healthcare Technology Private
Mumbai
07.2021 - 03.2024
- Designed and implemented scalable Snowflake-based cloud data warehouse supporting multi-domain healthcare analytics.
- Architected and led 15-member offshore engineering team to deliver enterprise healthcare data platform solutions.
- Led data architecture modernization for healthcare intelligence product.
- Architected end-to-end Data Quality engine with configurable rule framework.
- Built scalable deduplication and metadata-driven ingestion frameworks improving processing reliability and maintainability.
- Automated metadata-driven ingestion using base-view specifications.
- Designed metadata-driven dynamic SSIS package generation framework.
- Enhanced reconciliation module with lineage tracking to improve data accuracy and configurability.
- Delivered governance, data quality, integration, and security benchmarking case study adopted by client stakeholders, informing strategic decisions.
MSBI Developer | Data Analyst | Database Engineer
Infogain India Pvt. Ltd. / IDC Technologies
11.2013 - 04.2018
- Designed and developed enterprise data warehouses with SQL Server, SSIS, SSAS to support data-driven decision-making.
- Built executive dashboards and analytical solutions with Tableau and DevExpress to enhance visibility and drive strategic insights.
- Performed dimensional modeling and ensured report/data consistency across business units.
- Led BI solution deployments and conducted stakeholder training sessions, ensuring smooth adoption and effective utilization of analytics tools.
- Delivered analytics solutions across EPC, supply chain, and public safety domains.
Senior Software Developer / Database Engineer
Verchaska Infotech Pvt. Ltd.
10.2008 - 10.2013
- Led cross-database migrations and performance tuning initiatives.
- Designed and administered SQL Server, DB2, and PostgreSQL databases to ensure data integrity and availability.
- Enforced database coding standards and conducted peer code reviews to improve code quality and maintainability.
- Developed reporting and analytics systems for travel and hospitality clients, enhancing decision-making capabilities.
Education
Bachelor of Engineering - Electronics
Mumbai University
01.2008
Skills
- Data Architecture
- Cloud Data Platforms
- Data Engineering
- ETL/ELT Design
- Dimensional Modeling
- Fact/Dimension Modeling
- Slowly changing dimensions
- CDC Frameworks
- Performance Optimization
- Data Governance
- Data quality standards
- Metadata architecture
- Cloud & Orchestration
- AWS
- Snowflake
- SnowPipe
- DBT
- Airflow
- Current SQL Technologies
- Programming
- T-SQL
- PL/pgSQL
- JavaScript (Snowflake SP)
- IBM DB2
- PostgreSQL
- MySQL
- Oracle
- Sybase
- SSIS
- SSDT
- Star Schema
- Snowflake Schema
- Tableau
- SSAS
- SSRS
- DevExpress
- Pentaho
- Data Visualization Tools
- Modern Reporting Tools
- Query Optimization
- SQL Profiler
- DevOps practices
- Git
- GitLab
- TFS
- SVN
- VSS
- Team Leadership
- Healthcare data management
- HADR
Certification
- Snowflake SnowPro Core Certified
- Microsoft Certified: Implementing a Data Warehouse using SQL (70-767)
Timeline
Senior Technical Specialist – Data Architect / Solution Architect
CitiusTech Inc.
03.2024 - Current
Senior Technical Specialist – Data Architect
CitiusTech Healthcare Technology Private
07.2021 - 03.2024
MSBI Developer | Data Analyst | Database Engineer
Infogain India Pvt. Ltd. / IDC Technologies
11.2013 - 04.2018
Senior Software Developer / Database Engineer
Verchaska Infotech Pvt. Ltd.
10.2008 - 10.2013
Bachelor of Engineering - Electronics
Mumbai University