Prashant Sagar
Data Analyst
Based in Bhilai
About
Hey! I am a data engineering enthusiast with 9+ year of experience as a data analytics professional, eager to pivot into the dynamic world of data engineering. Adept at leveraging programming skills for insightful data analysis. data migration with a focus on large-scale Cloud Migration programs. Extensive experience with Snowflake cloud & GCP cloud with solid foundation in database concepts Proven ability to migrate data and analytical workloads to GCP platforms including BigQuery. Experience in data insights to tackle complex problems and extract meaningful insights from data. Open to learning and collaborating with fellow data enthusiasts. Let's connect and explore the possibilities of data-driven innovation together!
Skills
Projects
Experience
2019 - Present
Data Analyst
Collaborate with Product teams & business stakeholders in agile environment to develop strategic product vision for shoppers. Led migration of data and analytical workloads from Snowflake cloud to Google BigQuery. Extract vast pool of promotional & media data for descriptive analysis on redemption cost, user trends & sales pattern. Developed and optimized ETL processes to ensure smooth and efficient scheduling tasks on Airflow connecting with MicroStrategy dossier providing active shoppers & digital shoppers. Build scorecards for retailers in overall product performance that track KPIs & reports to generate insights Strong knowledge with SQL, and Power BI
2015 - 2019
Senior Strategy Insights Analyst
Daily analysis of key trading, pacing and performance indicators around Sponsored Search. Daily analysis of key trading, pacing and performance indicators around Sponsored Search. Recognition of and immediate escalation of any potential data quality issues that surface. Contribute to efforts to further scale trading analytics/beta test new tools in this space.
Education
2006 - 2010
Bachelor of Technology in Bio-Technology and Engineering
Vinayaka Missions University, Chennai
2024
Snowflake Certificate - The Complete Masterclass
Mastering database fundamental concepts & advanced topics of Snowflake Architecture. Build professional-quality understanding of Snowflake setting up warehouse using SnowSQL, managing warehouse, loading data in snowflake. Understanding Snowflake editions, pricing, data storage & cost, setting up resource monitor. Loading data in snowflake with copy options command, loading semi-structured and unstructured data (JSON & Parquet file), cloud concepts of AWS, Azure, GCP and Snowpipe for Azure. Understanding snowflake features fail safe, time travel, types of tables, data sharing, data sampling, scheduling tasks, streams, creating materialized views and understanding data masking fundamentals In this entire course I have build hands on 13 assignments on each of the topics listed above