Keerti V Mokashi

Data Analyst

Accenture•  January 2021 - Present•  Bengaluru, India

Enhanced the effectiveness and reach of various political and product ad campaigns, leveraging SQL and Excel for data analysis, directly leading to a significant 9% boost in campaign ROI and revenue growth. Utilized SQL, advanced Excel, and Python for data processing and analysis, successfully deploying a quality project for clients, focusing on efficiency and accuracy in data handling. Led the design of migrating an older data system from legacy Hadoop to a cloud-based data warehouse solution using Snowflake, resulting in optimized data storage and compute resources with disaster recovery, enabling business continuity with 99.99% availability. Improved data scalability and retrieval times by 40%, supporting 100+ reporting users. Automated complex data pipelines, reducing the ETL process time by 30% through the introduction of SnowPipe and implementing scheduled data refreshes to ensure reports provide up-to-date insights. Boosted team productivity by 40% by implementing Splunk for task maintenance and performance monitoring, resulting in streamlined operations and enhanced accountability. Trained junior engineers in data warehousing best practices, resulting in a 20% increase in department productivity and Designed a comprehensive data model in Snowflake, which allowed real-time tracking of information from various data sources, facilitating actionable insights for stakeholders. Innovated and automated critical performance tracking dashboards using Python, substantially improving reporting processes and contributing to a 17% increase in revenue through strategic inventory management insights. Conducted requirement elicitation sessions with stakeholders to clarify project objectives and deliverables, enhancing client engagement by 30% throughout the project lifecycle and ensuring alignment with business goals. Collaborated with cross-functional teams to gather ambiguous requirements and translate them into concrete data solutions, enhancing user satisfaction by 35% and fostering a data-driven decision-making culture. Performed optimal TD discount analysis for both regular (BAU) and event days, significantly enhancing inventory liquidation across various brands, leading to a 27% increase in overall inventory movement. Streamlined and optimized SQL query operations, successfully reducing processing times by over 50%, thus enhancing overall database efficiency and response times for business-critical operations. Leveraging my expertise in Snowflake data modeling and ELT using Snowflake SQL, I demonstrated strong client interfacing skills to effectively engage stakeholders and address their data-related needs. Applied statistical analysis and predictive modeling in ad targeting and segmentation, resulting in a 25% increase in campaign precision and improved ROI for marketing initiatives. Employed advanced Excel functions (VLOOKUP, Pivot Tables) for in-depth data analysis and report creation, reducing manual work by 2 hours and increasing workflow efficiency. Played a key role as an ETL Tester in migrating legacy systems to a cloud-based Snowflake Data Warehouse, impacting over 15 years of data.