Summary
Overview
Work History
Education
Skills
Technical Skills
Timeline
Generic

Shrey

Deputy Manager - Business Application | Data Warehousing and Cloud Solution Architect
New Delhi

Summary

Proven expert in data warehousing and analysis, with a total experience of 5.11 years and a track record of deploying innovative solutions at Varun Beverages Limited like sales chatbot and sales forecasting. Skilled in programming, data analysis and technical analysis, excel in transforming complex data into actionable insights, achieving significant efficiencies. My leadership in implementing Snowflake and Python solutions underscores my analytical prowess and problem-solving capabilities.

Overview

6
6
years of professional experience
5
5
years of post-secondary education

Work History

Deputy Manager - Business Application

Varun Beverages Limited
Gurugram
07.2023 - Current
  • Developed multi-page chatbot for secondary sales using OpenAI API, Snowflake, Streamlit, and Python. Chatbot translates user's large language queries into Snowflake queries, retrieving and displaying data in Streamlit app. Designed custom login and FAQ page, implemented prompt engineering for accurate query generation, and successfully deployed on AWS EC2 and on-prem servers.
  • Executed data engineering tasks for Creambell, SAMNA (V8 DMS tool for VBL), SPEED (V8 DMS tool for VBL) and Devyani International Limited (DIL), including creating tasks, stored procedures, Snowpipes, and storage integrations on Snowflake. Managed S3 buckets, IAM policies, roles, and SQS notifications on AWS. Established and maintained data sharing on Snowflake for DIL, enabling data exchange with YUM! Brands.
  • Automated various tasks to streamline data processing and integration utilizing Python. These tasks included fetching GST details of distributors via an API in JSON format and loading the data into Snowflake as semi-structured data, accessing Zoho via an API to retrieve ticket details and loading the semi-structured data into Snowflake, creating distribution network map using latitude and longitude coordinates for different districts under Head of Sales (HOS), continuously converting distributor-wise transaction files from Excel to CSV in S3 for Snowpipe, developing sales API to extract data from the source (MS SQL) used by operations team.
  • Served as Database Administrator on Snowflake, handling database creation and management, warehouse setup, and resource monitor creation. Additionally, executed Database Security Administrator duties, including creating roles and users, as well as determining and assigning privileges to roles.
  • Implemented Geospatial functions on Snowflake by utilizing location logs generated when salespersons confirm orders, making use of MAKEPOINT and DISTANCE functions to calculate distance between starting and ending latitude and longitude coordinates. Leveraged this data to create maps on Carto and various BI tools.
  • Implemented Snowflake Cortex ML-based functions to forecast sales on the basis of Head of Sales (HOS) month-by-month. Utilized sales data from 2022 and 2023 to train the forecasting model, enabling accurate predictions and insights for planning and decision-making purposes.
  • Developed Python jobs to efficiently load master and transaction table data from the source systems (MS SQL for Secondary Sales and SAP HANA for Primary Sales) to Snowflake daily incrementally, replacing AWS Glue and Lambda jobs. Deployed on an on-premises server and scheduled with Windows Scheduler, optimizing costs by reducing AWS storage and processing expenses.
  • Implemented sentiment analysis and summarization of customer care calls for Cryoviva Biotech using Snowflake and Whisper API to convert voice recordings to text. Utilized Snowflake's SNOWFLAKE.CORTEX.SENTIMENT and SNOWFLAKE.CORTEX.SUMMARIZE functions for analysis. Additionally, performed sentiment analysis on data scraped from Instagram and X using Apify, loading data into Snowflake for insights and decision-making.
  • Implemented and managed Snowflake SQL REST API to deliver subsets of sales and distributor data efficiently. Additionally, facilitated data sharing from Snowflake to MS SQL, ensuring seamless integration and accessibility across platforms.

Analyst

Deloitte USI
Gurugram
08.2018 - 06.2023
  • Conducted tests to identify issues in data and resolved problems through root cause analysis and research.
  • Developed and updated analytical data structures to handle complex data.
  • Developed scripts, processes and data models for data integration and maintenance.
  • Prepared complex SQL queries, views and tasks in Snowflake.
  • Identified issues within databases, performed troubleshooting and implemented effective solutions.
  • Created SnapLogic pipelines to automate, generate, share and place the product structure files in MFT for processing. previously this process was manual.
  • Queried databases for information needed for report processing.
  • Performed system analysis, technical documentation, testing, implementation, and user support for platform transitions.
  • Collected, arranged, and input information into database system.
  • Developed and updated databases and table structures to handle data from internal as well as third party sources.
  • Evaluated, designed, implemented, and modified databases and data structures.
  • Created and Updated reports and visuals on Power BI to track company's revenue, dealer's inventory and inventory gap.

Education

Bachelor of Computer Applications - Computer Science And Programming

Vivekananda Institute of Professional Studies
New Delhi, India
06.2015 - 05.2018

Senior School Certificate Examination (12th) - Computer Science

Kendriya Vidyalaya Vikas Puri
New Delhi, India
04.2014 - 03.2015

Secondary School Examination (10th) -

Kendriya Vidyalaya Vikas Puri
New Delhi, India
04.2012 - 03.2013

Skills

Data research and analysis

Technical Analysis

Data Analysis

Data Modelling

Data Warehousing

Programming

Technical Skills

  • Close to four years of relevant experience on Snowflake.
  • Hands on experience on AWS components like S3, lambda jobs, glue jobs, EC2, IAM policy and roles.
  • Hands on experience in Anaconda and Jupyter. Worked on Python libraries like pandas, numpy, boto, hdbcli, pyodbc, snowflake.connector etc.
  • Worked on SAP Hybris Commerce tool.

Timeline

Deputy Manager - Business Application

Varun Beverages Limited
07.2023 - Current

Analyst

Deloitte USI
08.2018 - 06.2023

Bachelor of Computer Applications - Computer Science And Programming

Vivekananda Institute of Professional Studies
06.2015 - 05.2018

Senior School Certificate Examination (12th) - Computer Science

Kendriya Vidyalaya Vikas Puri
04.2014 - 03.2015

Secondary School Examination (10th) -

Kendriya Vidyalaya Vikas Puri
04.2012 - 03.2013

Similar Profiles

CREATE PROFILE
Shrey Deputy Manager - Business Application | Data Warehousing and Cloud Solution Architect