Aayushi Agrawal

Senior Data Analyst @ Paytm

About

Data analyst having 3+ year of experience in Travel and FMCG industry. I have honed my skills in data analysis and visualization, and have worked on a variety of projects that have provided me with a solid understanding of consumer behavior and market trends. During my professional journey, I developed a proficiency in data analysis tools such as Excel and SQL, and used my knowledge of programming languages like Python to automate data processes and create more efficient workflows. I also have experience using Power BI to create visually compelling dashboards and reports that effectively communicate complex data insights to stakeholders. As a data analyst, I am passionate about using data-driven insights to inform decision-making and drive business success. In the future, I hope to continue building on my skills and experience, and to work on projects that have a positive impact on society and the world. If you're interested in learning more about my work or would like to connect, please don't hesitate to reach out.

Country

India

City

Bengaluru

Industry

Market Research

Skill

looker, Microsoft SQL Server, Amazon Athena, Teamwork, Business Analysis, Consumer Insight, Business Insights, Critical Thinking, Statistics, Presentations, Data Visualization, Data Visualzation, Problem Solving, Data Analytics, Analytical Skills, Microsoft Excel, Python (Programming Language), Data Analysis, Research, SolidWorks

Experience

Senior Data Analyst

Paytm

2024-11 - Present · 1 yr 11 mos

Noida, Uttar Pradesh, India

Designed and developed dynamic dashboards using SQL and LookML to track daily flight booking performance, delivering real-time insights into performance fluctuations and enabling the identification of key areas driving both underperformance and success. Assisted in setting airline revenue targets based on historical data. Used predictive analysis to project performance, identifying shortfalls and collaborating with the growth team to implement corrective actions, achieving 95% target attainment. Analyzed live fare data to identify discount pricing opportunities, driving additional monthly revenue through optimized fare management strategies. Conducted TOFU (Top of Funnel) analysis to track customer behavior, identify conversion bottlenecks, and implement data-driven strategies to improve conversion rates. Evaluated Meta campaign performance, ratings, and customer reviews to derive actionable insights and optimize marketing strategies, improving overall campaign effectiveness. Monitored and benchmarked Paytm’s market position through competitor performance analysis and share-of business tracking, providing insights for strategic decision-making and growth.

Senior Analyst - Data strategy and Engineering

Kantar

2022-6 - 2024-11 · 2 yrs 6 mos

Bengaluru, Karnataka, India

Conduct in-depth analysis of e-commerce channel data in the home care category across multiple countries using Excel to identify fast-growing and top-selling SKUs by analyzing sales trends and demand Perform data mapping and distribution using Python during a dashboard project, ensuring data accuracy and error-free delivery to stakeholders by conducting quality and functionality checks Collaborate with tech and design teams throughout projects to ensure effective communication and coordination Analyze store images to identify growth areas and white space opportunities for improvement Create presentation decks summarizing findings and proposed strategies to clients Led an FMCG Store Analysis project, piecing together how the Homecare category looks across different stores in perspective of brand, variant, and pack size, and identifying growth areas and white space opportunities