Yash S.
Senior Snowflake & Data Warehouse Consultant | Cloud Data Architect
Experienced Data Warehouse Consultant and Cloud Data Architect with 12+ years of experience in designing, developing, and supporting enterprise data solutions.
With Aegis Softtech Since: February 2014
No. of Projects: 18+ Projects
Language: English – Fluent | Kannada – Fluent
Professional Summary
Strong experience in Snowflake, cloud data platforms, data warehousing, ETL/ELT, data integration, data modeling, and analytics solutions. Experienced in working across AWS, Azure, and GCP environments and designing scalable data platforms that support business reporting and analytics.
Hands-on experience in building data warehouses, data marts, automated data pipelines, and cloud-based data solutions. Skilled in improving data processing, query performance, data quality, and cloud costs.
Experienced in working as a Data Warehouse Developer, Senior Developer, Snowflake Consultant, and Cloud Data Architect, taking ownership from requirement understanding and solution design through development, testing, deployment, and support.
Core Technical Skills
Snowflake Data Warehouse
Cloud Data Architecture
Data Warehouse Design
Data Modeling
ETL / ELT Development
Data Migration
Data Integration
Data Lake Integration
Data Marts
Data Pipeline Development
Performance Optimization
Cloud Cost Optimization
Data Governance
Data Security
Technical Solution Design
AI Projects
Project 1: Enterprise Snowflake Data Warehouse
| Role | Cloud Data Architect / Senior Snowflake Consultant |
| Project Overview | Designed and implemented a cloud-based data warehouse using Snowflake to bring data from multiple business systems into a central platform. The solution provided a reliable data foundation for reporting, analytics, and business decision-making. |
Key Responsibilities
- Understood business and reporting requirements.
- Designed the overall Snowflake data warehouse architecture.
- Created data models for different business areas.
- Designed data ingestion and transformation processes.
- Defined data warehouse and data mart structures.
- Guided developers during implementation.
- Worked with BI teams to ensure the data met reporting requirements.
- Reviewed performance and improved slow-running queries.
- Implemented appropriate data access and security controls.
- Supported production deployment and ongoing improvements.
Key Features
- Snowflake
- Data Warehouse
- Data Modeling
- ETL/ELT
- Cloud Data Architecture
- Business Intelligence
Project 2: Cloud Data Migration & Modernization
| Role | Senior Data Engineer / Cloud Data Architect |
| Project Overview | Worked on a data modernization initiative to move existing data warehouse and data processing workloads to a modern cloud data platform. The objective was to improve scalability, simplify data processing, and provide a better foundation for analytics. |
Key Responsibilities
- Reviewed the existing data warehouse and data processing setup.
- Identified data sources, dependencies, and existing workflows.
- Designed the target cloud data architecture.
- Planned data migration activities.
- Developed data pipelines for moving and transforming data.
- Validated migrated data against existing systems.
- Worked on data quality and reconciliation.
- Supported performance improvements after migration.
- Worked with development and business teams during migration activities.
- Supported production deployment and issue resolution.
Key Features
- Snowflake
- AWS / Azure / GCP
- Data Migration
- Data Integration
- ETL/ELT
- Cloud Data Architecture
Project 3: Sales & Marketing Data Mart
| Role | Senior Data Warehouse Developer |
| Project Overview | Developed Snowflake-based data marts to support sales and marketing analytics. The solution brought together customer, sales, marketing, and campaign information to provide a consistent data source for business reporting. |
Key Responsibilities
- Designed data models for sales and marketing reporting.
- Developed data marts in Snowflake.
- Created data transformation processes.
- Integrated data from multiple business systems.
- Automated recurring data processing.
- Worked with BI teams to define reporting data requirements.
- Supported KPI and dashboard development.
- Performed data validation and quality checks.
- Optimized queries and data processing for better performance.
Key Features
- Snowflake
- SQL
- Data Modeling
- dbt
- Airflow
- Power BI
- Tableau
- Business Analytics
Project 4: Automated Data Pipeline Platform
| Role | Data Engineer / Senior Developer |
| Project Overview | Developed automated data pipelines to collect, transform, and load data from multiple sources into the cloud data warehouse. The solution reduced manual data processing and improved the reliability of regular data loads. |
Key Responsibilities
- Designed data pipeline workflows.
- Developed automated ETL/ELT processes.
- Created data transformation logic.
- Scheduled and monitored data processing jobs.
- Implemented error handling and data validation.
- Investigated failed data loads and resolved issues.
- Worked with developers and business teams to understand data requirements.
- Improved pipeline performance and reliability.
- Supported production monitoring and troubleshooting.
Key Features
- Snowflake
- SQL
- Python
- dbt
- Apache Airflow
- ETL/ELT
- Data Integration
Project 5: Snowflake Performance & Cost Optimization
| Role | Senior Snowflake Consultant / Cloud Data Architect |
| Project Overview | Worked on improving Snowflake performance and controlling cloud data warehouse costs. The project focused on identifying inefficient workloads, improving query performance, and providing better visibility into resource usage. |
Key Responsibilities
- Reviewed Snowflake workloads and query performance.
- Identified slow and inefficient queries.
- Optimized SQL queries and data structures.
- Reviewed warehouse usage and workload patterns.
- Implemented monitoring for compute usage.
- Developed cost monitoring dashboards.
- Identified opportunities to reduce unnecessary resource usage.
- Worked with teams to establish better usage practices.
- Provided recommendations for performance and cost improvement.
Key Features
- Snowflake
- Performance Optimization
- Query Optimization
- Cost Management
- Resource Monitoring
- SQL
Professional Experience
Aegis Softwares
Senior Snowflake & Data Warehouse Consultant : March 2015 – Present
- Designed and implemented enterprise data warehouse solutions using Snowflake.
- Worked with business and technical teams to understand data and reporting requirements.
- Designed scalable data models for reporting, analytics, and business intelligence.
- Developed data pipelines to move and transform data from multiple sources.
- Worked with cloud platforms including AWS, Azure, and GCP.
- Designed solutions for integrating data warehouses with data lakes and other data platforms.
- Improved Snowflake query performance and optimized data processing.
- Implemented data security using role-based access and data protection controls.
- Worked on monitoring Snowflake usage and identifying opportunities to reduce cloud costs.
- Supported data migration and modernization initiatives.
- Worked closely with BI teams to provide reliable and well-structured data for dashboards and reports.
- Guided developers on data warehouse design, development standards, and best practices.
- Reviewed technical solutions and supported teams in resolving complex data issues.
- Participated in architecture discussions and helped define the right data solution based on business requirements.
Data Warehouse / ETL Developer
February 2014 – Present
- Designed and developed data warehouse and data mart solutions for business analytics.
- Developed Snowflake-based data marts for marketing and sales reporting.
- Built automated data pipelines using modern ETL/ELT tools.
- Developed data transformation processes using SQL, Python, dbt, and other data tools.
- Automated recurring data processing activities to reduce manual work.
- Worked with large volumes of business data and improved data processing efficiency.
- Developed data models to support customer, sales, marketing, and operational reporting.
- Worked with BI teams to provide trusted data for business dashboards.
- Supported data quality checks and issue resolution.
- Developed monitoring solutions to track data processing and cloud resource usage.
- Assisted senior architects in designing data warehouse solutions.
- Supported production deployments and resolved data-related issues.
Professional Strengths
- 12+ years of experience in data warehouse and data engineering projects.
- Strong hands-on experience with Snowflake and cloud data platforms.
- Experienced in both development and architecture roles.
- Ability to design data solutions based on business requirements.
- Strong experience in data warehouse modernization and cloud migration.
- Experienced in building reliable and automated data pipelines.
- Focused on performance, scalability, security, and cloud cost management.
- Comfortable working with developers, BI teams, business users, and technical leadership.
- Strong problem-solving and production support skills.
- Experience guiding developers and reviewing technical solutions.
Career Progression
Cloud Data Architect / Senior Snowflake Consultant
Aegis Softtech | March 2015 – Present
Responsible for cloud data architecture, Snowflake solutions, data warehouse design, performance optimization, data governance, and technical leadership.
Senior Data Warehouse Developer
Aegis Softtech
Designed and developed enterprise data warehouses, data marts, ETL/ELT processes, and analytics solutions.
Data Warehouse / ETL Developer
Aegis Softtech | February 2014 – Present
Hands-on development experience in data warehousing, ETL, data integration, SQL, data modeling, and business reporting.
Education
Atmiya Institute
Bachelor of Science (B.Sc.) – Information Technology
2008 – 2011