Ayush Shrivastava
DWH/BI Developer
Hoshangabad
Summary
Experienced Data Warehouse Developer with 3 years of hands-on experience in ETL, data modeling, and cloud-based data solutions using Snowflake and Azure. Adept at creating efficient data pipelines and scalable data models to ensure accurate and timely data flow. A collaborative team player with a strong focus on delivering high-quality data solutions that provide actionable insights and support business growth.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Data Warehouse Developer
Amdocs
09.2022 - Current
- Developed and deployed robust end-to-end data solutions from scratch using Snowflake, enabling scalable and reliable data warehousing capabilities.
- Led the migration of legacy systems from Teradata and Mainframe to Snowflake and Azure Virtual Machines, contributing to a large-scale cloud transformation initiative.
- Authored and optimized complex ETL workflow to extract data from Teradata, apply standard transformations, and load it into Snowflake with high performance.
- Automated data ingestion workflows by creating a shell script wrapper that efficiently transfers source files from a azure blob container to an external stage using Azure services, significantly reducing manual effort by 100% and ensuring timely data availability for Snowflake objects (Snowsqls).
- Designed and maintained custom BI views to deliver business logic to reporting tools like Power BI and Tableau, supporting data-driven decision-making.
- Engineered and optimized materialized views to enhance query performance by 50% and reduce storage and computational costs by 30% through pre-computing and storing the results of resource-intensive operations.
- Managed performance tuning and production support activities for daily and weekend jobs, consistently meeting strict SLA targets.
- Delivered rapid deployment and full-scale BI solutions for enterprise clients, including AT&T, by meeting stringent timelines and business requirements.
- Created and managed data shares to provide clients with efficient and secure access to data directly from our warehouse objects, improving data availability and collaboration.
- Presented and resolved data issues during User Acceptance Testing (UAT) and client handover sessions, ensuring alignment and stakeholder satisfaction.
- Designed and implemented Role-Based Access Control (RBAC) policies in Snowflake and Azure, reducing unauthorized access incidents by 100% and strengthening data security posture.
Education
Bachelor of Technology - Computer Science
Bharati Vidyapeeth College of Engineering
Pune 04.2001 -
Secondary School - Science Education
Servite Convent Sr. Sec. School
Hoshangabad 04.2001 -
Skills
Snowflake
Azure
Data modeling
Shell Scripting
SQL programming
Python programming
Data warehouse architecture
ETL development
GitHub
Linux
Orchestration (TWS)
Certification
Snowflake SnowPro Core Certified
Timeline
Snowflake SnowPro Core Certified
10-2024
Data Warehouse Developer
Amdocs
09.2022 - Current
Bachelor of Technology - Computer Science
Bharati Vidyapeeth College of Engineering
04.2001 -
Secondary School - Science Education
Servite Convent Sr. Sec. School
04.2001 -
Similar Profiles
Pranjal SharmaPranjal Sharma
Advanced Software Developer at AmdocsAdvanced Software Developer at Amdocs
Richard VitalizRichard Vitaliz
Senior Frontend Web Developer at AmdocsSenior Frontend Web Developer at Amdocs
VAIBHAV MITTALVAIBHAV MITTAL
DevOps Team Lead at AmdocsDevOps Team Lead at Amdocs
AAKASH TOMERAAKASH TOMER
Assistant Manager Sales at AXIS BANKAssistant Manager Sales at AXIS BANK