Summary
Overview
Work History
Education
Skills
Timeline
Generic

Muthyam Sathish

Concord

Summary

Snowflake Architect/Developer with over 18 years of professional experience in Data ware housing area in design, development and implementation of business applications. Around 6 years of extensive experience in Snowflake and Migrating Data from SAP S4 HANA to Snowflake and around 3 years of experience in Python. In depth understanding of Snowflake cloud technology and Snowflake Multi-cluster Size and Credit Usage. Played Key role in migrating Sap HANA objects into snowflake environment. Experience with Snowflake Multi-Cluster Warehouses, Snowflake Virtual Warehouses and in building Snow pipe. In-depth knowledge of Data Sharing in Snowflake and Snowflake Database, Schema and Table structures. Experience in using Snowflake Copy Clone. Experience in Disaster recovery using Time Travel and Fail safe. Worked on Microsoft SQL and T- SQL Programing including Store Procedure user defined functions views and cursors. Worked on Oracle SQL and PL SQL Programing including Store Procedure user defined functions views and Cursors and Very good knowledge with Teradata. Worked on Oracle SQL and PL SQL programming including Store Procedure user-defined functions views and Cursors Engineered and maintained Snowflake data warehouses, overseeing the entire data lifecycle from ingestion to consumption. Implemented robust data modeling strategies in Snowflake, optimizing schema design for efficient storage and query performance. Collaborated with cross-functional teams to integrate Snowflake with various data sources and destinations, ensuring seamless data flow. Implemented and managed Snowflake's features such as time travel and zero-copy cloning for efficient data versioning and testing. Conducted performance tuning on Snowflake warehouses, optimizing SQL queries for faster execution and resource utilization. Established and enforced data governance policies in Snowflake, ensuring data quality, security, and compliance.

Overview

19
19
years of professional experience

Work History

Snowflake Architect Solution Architect

ITCS, AdaliteK
09.2021 - Current
  • Involved in Migrating Objects from SAP HANA to Snowflake.
  • Extensively worked in all phases of design, development from business requirement gathering creating Functional specs and Technical specs and did end to end development.
  • Worked with a testing team to create test cases and performed all unit tests.
  • Worked closely with Testing team in doing SIT and Worked closely with business team in getting UAT.
  • Conducted regular monitoring and maintenance of Snowflake databases to ensure optimal performance and availability.
  • Automated routine tasks and processes in Snowflake using Snowflake's scripting and task scheduling features.
  • Clients: Cisco - Sep2021 to April 2022
  • Verizon – Apr 2022 – June 2023
  • Molex - June2023 – May 2024
  • Adobe – June 2024 – Till Date

Snowflake Developer/Data Engineer

Cognizant Technology Services
01.2020 - 09.2021
  • Involved in Migrating Objects from SAP HANA to Snowflake.
  • Time traveled to recover missed data.
  • Created a Snow pipes by using auto ingest and loaded the data from AWS s3 buckets to Snowflake and extensively worked on AWS redshift.
  • Clients: PG&E, HBO and Medtronic

Snowflake Developer/Data Engineer

Cognizant Technology Services
Bentonville
06.2018 - 12.2019
  • Involved in end-to-end migration of objects from SAP HANA to Snowflake as part of Walmart’s modernization initiative.
  • Successfully migrated S/4HANA FI and SD module data into Snowflake using Talend pipelines and Azure Data Factory for advanced reporting and analytics.
  • Extensively worked on aligning with supply chain and finance data reporting needs.
  • Client: Walmart

SAP BW/HANA Principal Architect

Cognizant Technology Services
New York
12.2017 - 05.2018
  • Designed and implemented SAP HANA data models (calculation views, SQL scripts) for finance and operations reporting.
  • Architected SAP S/4HANA FI & SD data integration into SAP BW/4HANA and further to Snowflake for modern BI architecture.
  • Led the migration of legacy EDW reports and data pipelines to SAP BW and Snowflake using BODS and SAP Data Services.
  • Used SAP SLT replication and SDI/SDQ for real-time and batch data provisioning from S/4HANA into HANA views.
  • Modeled calculation views using SLT replicated tables, enabling unified views for analytics on FI/CO and SD data.
  • Delivered complex reports: Inventory Aging, First Pass Quality, MTTR/MTBR, Plant Maintenance, and QM analytics.
  • Client: Mizuho Bank

SAP BW/HANA Principal Architect

Cognizant Technology Services
St Paul
08.2016 - 12.2017
  • Involved in Business requirement gathering, creating the functional and technical specs, design, development, testing and implementation of Business Warehouse Change requests.
  • Working on different GTS reports like Import, Export and Preference Reports
  • Developed SAP HANA data modeling using Analytic Views and Calculation Views User Management, Optimization of HANA models.
  • SAP HANA enabled solutions design (Data Provisioning, Application, Security, and Reporting).
  • Creating Information Models (Calculation Views, Analytical views, Attribute views) as per the business requirements
  • Calculation Views with SQL Script to access data from Row store tables.
  • Client: 3M

SAP BW/HANA Solution Architect

Tech Mahindra America
01.2016 - 08.2016
  • Worked on different retailers reports like Sales and Stock, New Items , OSA reports
  • Developed Composite Providers, Calculation views based on different requirement of reports.
  • Working closely with BO and BODS team to develop different reports in Design Studio and to extract data from 3rd party systems.
  • Client: Nestle USA

SAP BW/HANA Solution Architect

Tech Mahindra America
08.2014 - 01.2016
  • Working on DSIM models on HANA and responsible for create and setup Complete DSIM system and DSR Reports and complete responsible for design and development of different retailers reports.
  • Worked extensively on BODS to extract transform and load data from different legacy systems to BW.
  • Creating Information Models (Calculation Views, Analytical views, Attribute views) as per the business requirements with functional areas of FI, CO, MM, SD, CRM and PS data.
  • Very good in writing Procedures, Functions using the SQL Script and used them in Calculation view.
  • Calculation Views with SQL Script for complex logic.
  • Expert in writing ABAP code as per the requirements like Expert routine, End routine, Start routine and customer exits for reports.
  • Client: Bell Helicopters USA

SAP BW/BI Developer

Tech Mahindra America
03.2014 - 08.2014
  • Interaction with Business for proper understanding of requirements and deliverables.
  • Analysis of the Business Requirement.
  • Preparation of the design and design documents as per Business Requirement.
  • Development of Backend objects to meet Business Requirements.
  • Analyzing and modifying standard extractors as per the requirement and creation of Generic Extractors for reconciliation data
  • Writing ABAP code whenever necessary.
  • Client: Applied Materials

Sr. SAP BW/BI with ABAP Developer

Hewlett-Packard(HP)
09.2011 - 02.2014
  • Responsible for Leading the BI support team to support finance and sales work streams.
  • Closely associated with HP business and delivered optimized business solutions, also regularly monitoring OLTP changes.
  • Involved in the design, development, testing and implementation of Business Warehouse using extended star schema and configuring the system and users.
  • Extracted data for Inventory and Sales from Different Business Content extractors 2LIS_03_BX, 2LIS_03_BFand 2LIS_03_UM for Stock initialization, Stock moments, Stock Revolutions.
  • Working experience on BTE extractors
  • Developed complex queries for Inventory Management: Inventory on Cycle Counts, Inventory Overview: Simple and Extended views and analysis using Structures, RRI, calculated and restricted Key Figures, query properties and Variables etc.
  • Sole responsible for designing & developing Inventory Management reports such as Stock Overview, Inventory Overview and demand supply match reports.
  • Developed User Training Material and Worked on developing detailed material for Knowledge Transition for maintenances of the project.
  • Environment: BW 3.5, BI 7.0 SAP ECC, LO Cockpit, ABAP.

Sr. SAP BW/BI with ABAP Developer

KPIT Cummins
08.2010 - 09.2011
  • Involved in analyzing the available models, realization, design, development and Cut over Activities to extract data into BW from different work streams and provide support for various areas like GL, AR and AP.
  • Used LO extract structures for extracting sales order, Delivery , Billing and Purchasing data (Header, Item level and Schedule line) from SAPR/3 Source system.
  • Extracted accounts receivable and payables and GL data transaction figures (0FI_GL_04) and Line items for the Customers (0FI_AR_04) and Vendors (0FI_AP_04)data from SAPR/3 TO BW.
  • Worked on Open hub destinations and developed various customized tools to analyze the BW Objects in the system
  • Environment: BW 3.5, BI 7.0 SAP R/3 4.7, LO Cockpit, ABAP.

SAP BW/BI Developer

MII Systems Corp
11.2006 - 10.2009
  • Involved in gathering user requirements, creation of Business Specification and BW Implementation design document.
  • Extracted data using LO Cockpit Extractions (SD-Sales Order, Billing, Notification) , Generic Extractions and CRM Extractors.
  • Generating Enterprise Portal, Web Templates and Process Chain Implementation
  • Used Cell Restrictions, filtering, conditions, variables, RRI interfaces and jump queries.
  • Developed different reports in FI such as Balance Sheet, P&L, Cash Flow, Day Sales Outstanding, 7th Work day analysis, Top Ten Customer based on outstanding Balance.
  • Unit/Integration/System test design and Performance Tuning for the Bex Queries.
  • Monitoring of the data load and update processes running in the production environment
  • Environment: BW 3.5, SAP R/3 4.7, LO Cockpit, CO-PA, FI, ABAP.

Education

Master of Science - Information Technology

Indiana Wesleyan University
Marion, IN
12-2024

Bachelor of Science - Computer Engineering

VTU
Belagum, Karnataka
08-2004

Skills

  • Data analysis
  • Cloud computing
  • Database management
  • Business intelligence
  • Software development
  • Data visualization

Timeline

Snowflake Architect Solution Architect

ITCS, AdaliteK
09.2021 - Current

Snowflake Developer/Data Engineer

Cognizant Technology Services
01.2020 - 09.2021

Snowflake Developer/Data Engineer

Cognizant Technology Services
06.2018 - 12.2019

SAP BW/HANA Principal Architect

Cognizant Technology Services
12.2017 - 05.2018

SAP BW/HANA Principal Architect

Cognizant Technology Services
08.2016 - 12.2017

SAP BW/HANA Solution Architect

Tech Mahindra America
01.2016 - 08.2016

SAP BW/HANA Solution Architect

Tech Mahindra America
08.2014 - 01.2016

SAP BW/BI Developer

Tech Mahindra America
03.2014 - 08.2014

Sr. SAP BW/BI with ABAP Developer

Hewlett-Packard(HP)
09.2011 - 02.2014

Sr. SAP BW/BI with ABAP Developer

KPIT Cummins
08.2010 - 09.2011

SAP BW/BI Developer

MII Systems Corp
11.2006 - 10.2009

Master of Science - Information Technology

Indiana Wesleyan University

Bachelor of Science - Computer Engineering

VTU
Muthyam Sathish