Santosh Dash

Provide designing, developing, implementing, optimizing, and troubleshooting data strategy roadmap for the cloud data warehouse on Snowflake.
Involve in technical solutions from design and architecture perspective for projects in presales phase as well as on-going projects with Snowflake Team.
Lead data engineers to architect and deliver the solutions that fulfil the Business information needs and align with the information vision and strategy.
Design and implement effective data warehouse POC solutions and RFP activities.
Design a Master Data Management program that will help create a common view of master data and provide a centralized mechanism for its aggregation, cleansing, transformation, augmentation, validation, and syndication.
Involved in design data strategy migration framework from Redshift to Snowflake.
Designing near real time data pipeline to feed the data into Snowflake Data Vault2.0 Objects.
Assess database implementation procedures to ensure they comply with internal and external regulations.
Involved in design Snowflake stored procedure for batch load and SnowPipe scripts for continuously loads data from Azure Blob storage into Snowflake.

Provide designing, developing, implementing, optimizing, and troubleshooting data strategy roadmap for the cloud data warehouse on Snowflake
Involve in technical solutions from design and architecture perspective for projects in presales phase as well as on-going projects with Snowflake Team
Lead data engineers to architect and deliver the solutions that fulfil the Business information needs and align with the information vision and strategy
Design and implement effective data warehouse POC solutions and RFP activities
Design a Master Data Management program
Design data strategy migration framework from Redshift to Snowflake
Designing near real time data pipeline to feed the data into Snowflake Data Vault2.0 Objects
Assess database implementation procedures to ensure they comply with internal and external regulations
Design Snowflake stored procedure for batch load and SnowPipe scripts for continuously loads data from Azure Blob storage into Snowflake

Provide designing, developing, implementing, optimizing, and troubleshooting complex cloud data warehouse databases on Snowflake.
Design and implement effective database solutions and models to store and retrieve company data.
Examine and identify database structural necessities by evaluating client operations, applications, and programming.
Involved in taking care of Data Vault2.0 Data modelling with respect to Snowflake cloud datwarehouse.
Involved in near real time data pipeline to feed the data into Snowflake Data Vault2.0 Objects.
Assess database implementation procedures to ensure they comply with internal and external regulations.
Developed SnowPipe scripts for continuously loads data from Azure Blob storage into Snowflake.
Developed automated data ingestion using SnowPipe, which consumed data from Azure Blob storage into Snowflake tables using Azure Event service.
Designed the Snowflake Task to process the stream for loading the CDC data into Snowflake and used COPY to bulk load the data.
Created internal and external stage and transformed data during load.
Used FLATTEN table function to produce lateral view of VARIENT, OBECT and ARRAY column.
Used Temporary and Transient tables on diff datasets and cloned Production data for code modifications and testing.
Implemented Snowflake advanced concepts like resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, zero copy clone, time travel etc.

Provide designing, developing, implementing, optimizing, and troubleshooting complex cloud data warehouse databases on Snowflake.
Created and maintained the Logical/Physical Data Model for a scalable Data Vault 2.0 Data model design by utilizing cloud Datawarehouse design methodologies.
Design and implement effective database solutions and models to store and retrieve company data.
Examine and identify database structural necessities by evaluating client operations, applications, and programming.
Assess database implementation procedures to ensure they comply with internal and external regulations.
Experience with creating Snowflake data modeling, ELT using Snowflake SQL, implementing stored procedures and standard DWH& ETL concepts.
Involved in converting Teradata Objects, SQL, ETL scripts Into Snowflake.
Involved in designing CDC data pipelining to AWS S3 using DMS replication service.
Developed SnowPipe scripts for continuously loads data from Amazon S3 into Snowflake.
Developed automated data ingestion using SnowPipe, which consumed data from Amazon S3 bucket into Snowflake tables using AWS SQS event.
Implemented data pipeline using DBT tool for continuous integration and data transformations.
Designed the Snowflake Task to process the stream for loading the CDC data into Snowflake and used COPY to bulk load the data.
Created internal and external stage and transformed data during load.
Used FLATTEN table function to produce lateral view of VARIENT, OBECT and ARRAY column.
Used Temporary and Transient tables on diff datasets and cloned Production data for code modifications and testing.
Implemented Snowflake advanced concepts like resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, zero copy clone, time travel, and data sharing and fail-safe concepts.
Created Secure Data Sharing that enables account-to-account & reader account sharing of data through Snowflake database tables, secure views, and secure UDFs.

Provide technical analysis, design, development and implementing data model & database security and deliver Bigdata and data lake projects.
Collaborate with business subject matter experts and technology teams to make strategic recommendations on data collection, integration and retention.
Analyzed Business Requirements and translate those into a scalable Data model design by utilizing best B design methodologies.
Created and maintained the Logical/Physical Data Model repository as per company standards.
Designed Data vault model (Hubs, Links and Satellites) to consume data from data lake (MongoDB) into Oracle 12c with Exadata analytical data system.
Created collection, Index Data Lake stores the large amount of raw data in MongoDB.
Created NOSQL/ SQL object mapping and bridging the gap between ETL developers and data modelers.
Developed Oracle database security implementation strategy using Oracle VPD with LDAP in SAP BO dashboard and Java application.
Designed and developed data flow/solution architecture with flexible schema to handle structured/unstructured data for real time and batch processing using Oracle, Mongo DB, Hive and Sqoop.
Write ETL pipeline and design batch jobs to automate processes using a variety of traditional and large-scale distributed data systems.
Strategized development and integration plan among internal and external teams.
Strong knowledge on AWS environment and Service knowledge with S3 storage understanding and Involved in configuring RDS and Redshift instance in AWS RDS.
Involved in creating scripts for moving data from RDBMS/S3 to HDFS/Hive and vice versa using Sqoop.

Analysed Business Requirements and translate those into a scalable Datamart design by utilizing best DW design methodologies.
Analysing and mining business data to identify patterns and correlations among the various data points.
Mapping and tracing data from system to system to solve a given business or system problem.
Developed Tableau visuals for Controls and Compliance team mapping banking regulations to internal policies, standards, and processes to be used in presentations for ECB leadership.
Cleaning and blending multiple data sources to allow for different views on application data in a single dashboard.
Designing semantic data model from scratch to aid team in data collection to be used for Tableau visuals.
Develop Tableau reports that provide clear visualizations of various industry specific KPIs and access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.
Creates and maintains new data marts for use in Tableau Server in partnership with the Data Architecture team.
Streamlines and improves existing reports with adherence to defined policies and data definitions across financial system.
Perform statistical analysis of business data.
Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for new enhancements of reports.
Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
Ensured the feasibility of the logical and physical design models.

Involved in Analysis of the specifications & requirements provided for the UR’s and understand the business from different perspectives, as well as the technology side of what can be effectively used to improve the business.
Involved in gap analysis before finalizing design, to make sure data availability in DWH core layer.
Map source system attributes to targets within the FSLDM.
Involved in design in Semantic layer.
Involving in Teradata Utility Scripts and used appropriate indexes such as PI, SI, JI, HI, etc.
Developing data models for applications, metadata tables, views or related database structures.
Write & troubleshoot Teradata SQL queries and stored procedures.
Developed Teradata scripts using TD utilities for loading data from source to Teradata Staging area.
Optimizing / tuning mappings for better performance and efficiency.
Loaded the dataset into Hive for ETL Operation.
Developed Hive queries for the analysts.
Successfully loaded files to Hive and HDFS using XML, CSV and JSON data files.

Analysing business-defined problems in the data, finding the underlying technical problems, and proposing solutions.
Actively involved in Data Modelling/Mapping activities.
Designing SMX /SMLX and bridging the gap between ETL developers and data modellers.
Map source system attributes to targets within the FSLDM.
Write & troubleshoot Teradata SQL queries and stored procedures.
Developed Teradata scripts using TD utilities for loading data from source to Teradata Staging area.
Optimizing / tuning mappings for better performance and efficiency.
Involved in data Extraction and Transformation from source databases and Loading to Mart.

Involved in analysis of the specifications & requirements provided by the clients and understand the business from different perspectives, as well as the technology side of what can be effectively used to improve the business.
Developing Teradata BTEQ, Fast Load, and MLOAD Scripts to export data from Teradata and involved in Teradata performance tuning, SQL tuning.
Design and development of Scripts using to load the data into the Netezza database.
Involved in creating Materialized view, external table, CBT, NZLOAD, GROOM etc.
Involving and analysing the Netezza performance tuning, SQL tuning using Query Plans and SPU distribution.
Developing data models for applications, metadata tables, views or related database structures.
Coordinated with external (customers, vendors, partners in various countries) IT teams and internal departments to compile and document data requirement for supporting various business operations.
Communicated business requirements, data model & ETL architecture to development team.