Feb 2024 – Sep 2024 · 7 mos

• Led a marketing portfolio project for 𝐀𝐩𝐩𝐥𝐞 𝐈𝐧𝐜., utilising Snowflake for comprehensive data analysis, Python for automation, and business intelligence to drive actionable insights.
• Collaborated with a multi-vendor team to identify and streamline data sources, optimising data collection processes.
• Integrated advanced features like 𝐓𝐢𝐦𝐞 𝐓𝐫𝐚𝐯𝐞𝐥 for data versioning and 𝐙𝐞𝐫𝐨 𝐂𝐨𝐩𝐲 𝐂𝐥𝐨𝐧𝐢𝐧𝐠 for efficient environment replication.
• Implemented 𝐝𝐲𝐧𝐚𝐦𝐢𝐜 𝐝𝐚𝐭𝐚 𝐦𝐚𝐬𝐤𝐢𝐧𝐠 to strengthen security measures and ensure compliance with regulatory standards.
• Scraped data from YouTube channels related to Apple and influencer content to analyze engagement metrics such as comments, likes, and shares. Integrated this data into Snowflake for comprehensive analysis, providing insights into audience sentiment and content effectiveness across digital platforms.
• Achieved significant 𝐩𝐞𝐫𝐟𝐨𝐫𝐦𝐚𝐧𝐜𝐞 𝐠𝐚𝐢𝐧𝐬 by employing advanced performance tuning techniques, reducing query load times by 𝟔𝟎%.

Jan 2022 – Jan 2024 · 2 yrs

• Managed end-to-end migration of Enterprise DWH for 𝐍𝐨𝐫𝐝𝐞𝐚 𝐁𝐚𝐧𝐤 from Teradata to Snowflake, handling 𝟓𝟎𝟎𝐓𝐁+ data and achieving $𝟏𝟖𝐌 cost savings.
• Led a 𝟏𝟎+ member team in remediating and optimising 𝟐𝟎,𝟎𝟎𝟎+ tables, 𝟑𝟎,𝟎𝟎𝟎+ views, and 𝟏𝟐,𝟎𝟎𝟎+ procedures, ensuring seamless transition and preserving functionality.
• Developed automated Python scripts to streamline data workflows, reducing manual intervention by 𝟒𝟎% and enhancing operational efficiency.
• Conducted 𝐩𝐞𝐫𝐟𝐨𝐫𝐦𝐚𝐧𝐜𝐞 𝐭𝐮𝐧𝐢𝐧𝐠 on codebase, achieving a 𝟓𝟎% reduction in query load times, thereby optimizing system performance.
• Mentored junior engineers in data warehousing best practices, boosting departmental productivity by 𝟐𝟎% and ensuring team-wide knowledge transfer.
• Collaborated with clients to implement 𝐫𝐨𝐥𝐞-𝐛𝐚𝐬𝐞𝐝 𝐚𝐜𝐜𝐞𝐬𝐬 𝐜𝐨𝐧𝐭𝐫𝐨𝐥 (𝐑𝐁𝐀𝐂) and created 𝐩𝐫𝐨𝐨𝐟-𝐨𝐟-𝐜𝐨𝐧𝐜𝐞𝐩𝐭𝐬 (𝐏𝐎𝐂𝐬) for unsupported Teradata functions, ensuring robust security and functionality.
• Optimized data operations and ensured data integrity by using advanced Snowflake features such as 𝐓𝐚𝐬𝐤𝐬 for workflow automation, 𝐒𝐭𝐫𝐞𝐚𝐦𝐬 for real-time replication, and 𝐓𝐢𝐦𝐞 𝐓𝐫𝐚𝐯𝐞𝐥 for data recovery and audit trails.

Aug 2020 – Dec 2021 · 1 yr 4 mos

• Engineered real-time financial dashboard in Power BI leveraging transactional data from SAP HANA data, enabling dynamic KPI monitoring.
• Optimised data processing with indexing and partitioning, cutting dashboard load times by 30% for seamless data access.
• Enabled informed decision-making by delivering actionable insights through streamlined data analysis and visualisation techniques.
• Implemented data governance best practices to maintain data integrity and ensure the accuracy of financial metrics monitored on the dashboard.

Jan 2020 – Apr 2020 · 3 mos · Greater Bengaluru Area

• Performed demand forecasting analysis and created a recommendation model for the retail warehouse sector.
• Study on Market Basket Analysis
• Performed Association rule mining on Instacart Dataset

Mar 2019 – Dec 2019 · 9 mos · India

• Objective and Scope:
• Engage the community to prepare students and make them employable through live projects
• Platform for students, mentors to collaborate and co-create solutions for technical problems that will either directly or indirectly impact a product/solution
• Create a portal with repository of industry projects – creating collaboration platform where students are guided , mentors solve their problem
• Organizations /start ups /researcher post projects with description
• Provide e-certificate, badges, ratings
• It is an industry wide portal and will be popularized across Academia and industry