Mumbai, Maharashtra, India
Driving transformative data solutions with expertise in AWS Cloud, Snowflake, and advanced analytics. As a seasoned leader in Data & Analytics, I bring a wealth of experience in leveraging cutting-edge technologies to drive data-driven decision-making and business innovation. My expertise spans across cloud platforms, data engineering, and analytics, including AWS Cloud, Snowflake, SAS, Oracle, MSSQL, MYSQL, and data warehouse solutions. I specialize in building robust data ecosystems, from Master Data Management (MDM) to Data Warehousing (DWH) and Cloud-Based Data Lakes, enabling seamless data flow and actionable insights. Proficient in Python, SAS ETL, and advanced analytics, I empower organizations to unlock the full potential of their data. Key achievements include implementing scalable analytics platforms, driving data strategy for enterprise transformation, and leading cross-functional teams to deliver high-impact business outcomes. My proficiency in Tableau and SAS Visual Analytics ensures the delivery of intuitive, actionable insights to stakeholders at every level. Passionate about leveraging technology to solve complex problems, I thrive in fast-paced, innovative environments where data is at the heart of success. Let’s connect to explore synergies in the data and analytics space or to discuss how we can drive value through transformative solutions.
• Customer Segmentation Model: Built, Customer Segmentation model to understand customer behavior on 1.2 Cr. customer base. • Propensity Model to decide customers who are likely to buy and behavior analysis to decide what to product to pitch. • Data Enrichment - Work closely to enhance investor database with behavioral attributes. Vision to use these attributes to predict customer behavior and be used to cross sell products to investors. • Implementing predictive Model to predict customer who will cancel SIP. Business objective to reduce SIP cancellation rate. • Business analytics to drive various campaigns internally to minimize efforts and maximize rewards. • Created dashboards to monitor and track key performance indicators • Developed complex dashboard and reporting tools to track business performance metrics
• Setting up Warehouse for analytics sourcing data from systems like Digital footprints, CRM, Benchmarking, Feedback, transactions, etc. and hosting in EW for analytics • Sales Incentive Automation/Policy Changes, Automation of complex Sales Incentive process which was carried out manually and manage dashboard on Tableau which gave organization employee better way to track their performance and help them improve achieve better for organization • Ad-hoc Analytics with respect to various business needs and campaign activities by providing propensity data & performance measurement of campaigns
• Implemented Customer Data Platform to build unified Customer view with enterprise data, Web Analytics, App Analytics, Campaign responses to target customer with relevant content and relevant channel of engagement • Implemented Pricing and Profitability model tool for Business stakeholders to make pricing decision and measure impact on Profitability and make prediction basis historical trends of flow. It allows business to see asset attrition rates and profitability down to fund / distributor level, or for overall book of assets • Implemented Unsupervised learning using clustering methodology for customer segmentation in B2B2C campaign with key distributor Identifying segments for cross-sell/up-sell opportunities • Analysis to help stakeholders in making strategies like SIP Retention, Contact Coverage, loyalty, Attrition life cycle of customer • Designed Dashboards for business to provide insights and take away around Sales business aspects, Digital websites, Market Insights, GA, etc. • Analyze digital footprints and understanding sentiments and behaviors of investors on digital website. Set up recommendation engine basis business rule.
• Work closely with stakeholders from various business units using application Applied Epic to determine reporting and application requirements, perform analysis to create statement of work and provided time estimates • Develop SSRS reports and dashboards using Microsoft Reporting Services platform • Design layout of SSRS reports and determine best way to present data to end users.
• Playing crucial Techno-function role. Understanding business requirements and translating data into actionable insights to make meaningful business decisions • Worked closely to generate insights for wealth business of 360One, identifying families generating ARR for the firm based on study of investment in revenue vs non-revenue generating products. • Identified pareto analysis highlighting the concentration risk to business. • Deployed data warehouse and data marts for reporting and analytics dashboards. • Built data quality control check to ensure data on reports are accurate and if not, is highlighted to relevant teams for correction action. • Developed framework, Data Model and solution using AWS and Snowflake. Project divided into multiple phases: 1. Sourcing Data from SOR to Cloud (S3) 2. Implementing DMS solution to capture changed records from SOR 3. Deploying Scala code on EMR to complete ETL. 4. Step Functions for automation. • Implemented publishing layer of data into snowflake where entire ETL and DAG Implemented to have homogenous, governed and single source of truth for organisation.