Summary
Overview
Work History
Education
Skills
Tools & Technologies
Accomplishments
Certification
Timeline
Generic
Dheeraj Manchanda

Dheeraj Manchanda

Vancouver

Summary

Experienced Snowflake Platform Engineer with 10+ years of expertise in architecting, optimizing, and securing data environments across Snowflake and other RDBMS platforms. Proven skills in automation, performance tuning, and cost-efficient design of scalable data pipelines. Adept at integrating Snowflake with CI/CD and DevOps practices, implementing robust data governance, and leveraging AI/ML solutions using Snowflake Cortex and LLMs. Hands-on experience building interactive Streamlit dashboards for real-time insights and enhancing user access to advanced analytics. Passionate about enabling business innovation through automation, intelligent data platforms, and best practices for reliability, scalability, and operational excellence.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Snowflake Platform Engineer

TJX Inc. [Infosys Limited]
04.2024 - Current
  • Designed and implemented scalable, high-performance data architecture solutions using Snowflake, with focus on automation, costefficiency, and reliability.
  • Developed interactive dashboards and reports using Power BI Desktop to visualize KPIs and business metrics.
  • Developed and optimized data models and ETL/ELT frameworks using dynamic clustering, indexing, and partitioning to enhance query performance.
  • Built interactive Streamlit apps on top of Snowflake Cortex LLMs, enabling business users to explore real-time insights with natural language queries.
  • Built complex data models with relationships,calculated columns, and measures using DAX.
  • Integrated AI/ML workflows using Snowflake Cortex for predictive analytics, embedding intelligence into data pipelines and dashboards.
  • Implemented cost governance strategies using resource monitors, warehouse auto-suspend policies, and credit usage dashboards to reduce spend by 20%.
  • Scheduled Data Refreshes and managed Power BI Gateways for on-premise and hybrid data sources.
  • Automated platform operations with CI/CD pipelines via GitHub Actions and Terraform, enabling seamless deployment and environment management.
  • Optimized workload performance by monitoring queries, resolving concurrency issues, and applying tagging and resource utilization best practices.
  • Enforced enterprise data governance and security with RBAC, network policies, masking, and compliance-driven data sharing frameworks.
  • Supported multi-cloud and hybrid deployments across AWS and Azure, ensuring seamless interoperability and platform consistency.
  • Collaborated cross-functionally with engineering, analytics, and business teams to translate requirements into high-performing Snowflake solutions.
  • Conducted technical evaluations of engineering designs and test results.

Synapse Administrator

Kroger [Infosys Limited]
03.2023 - 04.2024
  • Manage and maintain Azure Synapse Analytics environments, ensuring high availability, performance, and scalability.
  • Implement and oversee security measures, including role-based access control and data encryption, while ensuring compliance with data protection regulations.
  • Monitor system performance, troubleshoot issues, and optimize resources to maintain efficient operation of Synapse services.
  • Develop and enforce data governance policies, automate administrative tasks, and support stakeholders in their data processing and analytical needs.
  • Stay updated with the latest Synapse features and updates, continuously enhancing system performance and functionality.
  • Optimize Synapse workloads by implementing workload management strategies, resource classification, and dynamic scaling to improve query performance and cost efficiency.
  • Integrate Synapse with Azure Data Services, such as Data Factory, Databricks, and Power BI, to streamline ETL/ELT pipelines and data analytics workflows.
  • Implement disaster recovery (DR) and high availability strategies, including failover mechanisms and backup retention policies, to ensure business continuity.
  • Automate monitoring and alerting using Azure Monitor, Log Analytics, and custom dashboards to proactively detect performance bottlenecks and security threats.
  • Manage Synapse networking and security, configuring Private Endpoints, Managed Virtual Networks, and Firewall rules to ensure secure data access.
  • Enhance query performance by optimizing distributed processing, partitioning strategies, indexing, and materialized views for large-scale data workloads.
  • Collaborate with data engineering and BI teams to support business intelligence, reporting, and machine learning initiatives within the Synapse environment.

Snowflake Administrator

Lululemon [Infosys Limited]
10.2018 - 03.2023
  • Played a key role in migrating legacy systems to cloud-based Snowflake Data Warehouse, impacting over 200 users.
  • Customized Snow SQL scripts to enhance data load performance by 40%, accommodating an increase in data volume.
  • Facilitated team knowledge sharing by documenting ETL and data transformation techniques, which cut onboarding time by half.
  • Integrated analytics into customer facing products, boosting user engagement by 20% through tailored insights.
  • Implemented database migrations, replication, and backup/recovery techniques utilizing Time Travel and Clone Utility in Snowflake.
  • Monitored Snowflake consumption, including warehouse load, user query history, and billing, providing detailed reports to customers on demand.
  • Conducted regular health check-ups of Snowflake environments, analyzing long-running queries, warehouse performance, session stats, and addressing any issues.
  • Performed data refreshes across environments using the Share Utility, ensuring data consistency and availability.
  • Managed manual re-clustering and resource monitors, optimizing performance and resource utilization in Snowflake.
  • Designed and enforced Snowflake security policies, implementing role-based access controls (RBAC), network policies, and auditing mechanisms to ensure compliance.
  • Optimized Snowflake storage costs by implementing automated retention policies, partitioning, and storage tiering strategies to reduce unnecessary data storage expenses.
  • Automated monitoring and alerting mechanisms for performance tuning, query optimization, and resource utilization to ensure proactive issue resolution.
  • Integrated Snowflake with third-party tools, such as Power BI, Tableau, and Azure Data Factory, to enhance data visualization, reporting, and ETL workflows.
  • Collaborated with DevOps teams to implement CI/CD pipelines for Snowflake, automating schema updates, deployment processes, and version control.
  • Led cross-functional initiatives to drive Snowflake best practices, performance tuning, and cost optimization strategies across the organization.

Netezza Administrator

BB&T [HCL Technologies Limited]
12.2016 - 10.2018
  • Administered and optimized Netezza TwinFin and Mako data warehouses, ensuring peak performance and high availability for critical business applications.
  • Developed and implemented ETL processes to streamline data integration and transformation, enhancing data accuracy and consistency across the organization.
  • Conducted regular performance tuning and query optimization, reducing query execution times and improving overall system efficiency.
  • Managed data security and access controls, ensuring compliance with corporate data governance policies and protecting sensitive information.
  • Collaborated with cross-functional teams, providing technical expertise and support for data-driven projects and initiatives.
  • Optimized database storage and workload management, improving disk utilization, query distribution, and resource allocation for highperformance analytics.
  • Designed and executed database migrations and upgrades, ensuring seamless transitions with minimal downtime while enhancing system capabilities.
  • Implemented backup, disaster recovery (DR), and failover strategies, ensuring business continuity and data resilience in case of unexpected failures.
  • Automated monitoring and alerting mechanisms to proactively detect and resolve performance bottlenecks, query slowdowns, and system anomalies.
  • Integrated Netezza with external BI and reporting tools, such as Power BI, Tableau, and Cognos, to enable real-time analytics and dashboarding.
  • Supported complex SQL development and query optimization, improving report generation and reducing execution time for large-scale analytical queries.

Db2LUW Administrator

GAP [HCL Technologies Limited]
05.2015 - 12.2016
  • Administered and maintained DB2 LUW databases, ensuring optimal performance, availability, and reliability.
  • Implemented database backup and recovery strategies, minimizing downtime and ensuring data integrity.
  • Conducted performance tuning and query optimization, reducing execution times and improving overall database efficiency.
  • Managed database security and user access controls, ensuring compliance with organizational policies and protecting sensitive information.
  • Performed regular database health checks and capacity planning, proactively identifying and addressing potential issues.
  • Automated database maintenance tasks, including reorganization, statistics collection, and index optimization, to enhance system performance and reduce manual workload.
  • Developed and fine-tuned stored procedures, triggers, and query execution plans, improving application responsiveness and transaction efficiency.
  • Implemented high-availability solutions, including HADR (High Availability Disaster Recovery), database clustering, and failover mechanisms, ensuring business continuity.
  • Monitored and optimized storage usage, implementing tablespace management and compression techniques to reduce storage costs and enhance performance.
  • Led database upgrades and patching initiatives, ensuring compatibility with new features, security enhancements, and industry best practices.

Education

PG-DAC - Post Graduation Diploma in Advanced Computing

KNOW-IT, CDAC Institue
Pune, India
02.2015

Bachelor of Technology - Computer Science And Engineering

Manav Rachna International Institute Of Research And Studies
Faridabad, India
05.2014

Skills

  • Cloud & Data Platforms : Snowflake, Azure Synapse Analytics, Microsoft Azure, Amazon S3, Azure SQL DW
  • Programming & Scripting : Python, Shell Scripting, SQL, JavaScript (for Snowflake Procedures), Powershell
  • Data Engineering & Integration : ETL/ELT Design, Data Modelling, Data Pipelines, Azure Data Factory
  • Databases : Snowflake, IBM Db2LUW, Netezza(TwinFin/Mako), SQL Server, PostgreSQL
  • BI & Reporting : Data Visualization, PowerBI (DAX, Power Query), Streamlit, Snowsight, KPI Dashboards

Tools & Technologies

Snowflake Ecosystem : Snowsight, SnowSQL, SnowCLI

Development & Scripting : Visual Studio, Git, GitBash, Winfows PowerShell, WinSCP, Putty

Database Tools : Azure Data Studio, SSMS, Aginity Workbench, DBVisualizer, DBeaver

BI & Reporting : PowerBI Desktop, PowerBI Service, DAX Studio, Excel

ETL & Integration : Azure Data Factory

Monitoring & Scheduling : Control-M, Airflow(basic), Azure Monitor

Collaboration & Ticketing : Jira, Confluence, ServiceNow, MS Teams

Accomplishments

  • Received client appreciation for exceptional performance in improving data warehouse ETL times by 30%, benefiting project timelines.
  • Awarded for leading AI/ML and LLM Research within Snowflake using Cortex and Streamlit. Designed Proof-of-concepts for predictive analytics and automated decision-making using advanced models and visualized outcomes with Streamlit Dashboards.
  • Conducted thorough disaster recovery testing, ensuring all DR protocols were effective and that systems could be quickly restored in the event of an outage. Documented and refined DR procedures based on test outcomes.
  • Led the development and deployment of a robust data synchronization process across multiple environments, ensuring data consistency and minimizing downtime during migrations and updates.
  • Received recognition for designing and implementing an automated backup and data purge strategy, significantly reducing manual intervention and ensuring data integrity and compliance.
  • Built interactive Streamlit Apps on Snowflake Cortex for real-time LLM-driven data insights and user interaction. Enabled business users to query and explore insights with minimal technical input.
  • Established comprehensive resource monitoring at both account and warehouse levels to track credit usage. Implemented dashboards and alerts for proactive management of resource allocation and cost control.
  • Created and integrated an automated email alert and notification system to inform stakeholders of critical events, performance issues, and usage thresholds, enhancing responsiveness and operational efficiency.
  • Boosted query performance by 40%, implementing advanced indexing and clustering strategies.

Certification

  • AZ-303(Azure Architect Technologies) Microsoft
  • AZ-900(Azure Fundamentals) Microsoft
  • AZ-104(Azure Administrator) Microsoft
  • SnowPro Core Snowflake
  • Hands On Snowflake - Web UI Essentials Snowflake
  • Hands-On Essentials: Collaboration, Marketplace & Cost Estimation Workshop Snowflake
  • Hands-On Essentials: Data Warehousing Workshop Snowflake

Timeline

Snowflake Platform Engineer

TJX Inc. [Infosys Limited]
04.2024 - Current

Synapse Administrator

Kroger [Infosys Limited]
03.2023 - 04.2024

Snowflake Administrator

Lululemon [Infosys Limited]
10.2018 - 03.2023

Netezza Administrator

BB&T [HCL Technologies Limited]
12.2016 - 10.2018

Db2LUW Administrator

GAP [HCL Technologies Limited]
05.2015 - 12.2016

PG-DAC - Post Graduation Diploma in Advanced Computing

KNOW-IT, CDAC Institue

Bachelor of Technology - Computer Science And Engineering

Manav Rachna International Institute Of Research And Studies

Similar Profiles

CREATE PROFILE
Dheeraj Manchanda