Business Analyst

• May 2023 - Present

Intern

• Jul 2021 - Jul 2022

Insights Generation: Constructed interactive dashboards using Power BI to identify & analyze data patterns, outliers leading to expanded insight into buying patterns. Tracked consumer & content analytics, monitored KPIs, metrics of the products generated reports & presentations, & made data-driven decisions to improve performance. Data Analysis: Designed, extended, and customized ETL modules to develop interactive dashboards, scorecards, KPIs, and reports using PowerBI independently. Created stories using concrete numbers and statistical insights. Automated daily reports using excel and SQL, and other methods to streamline the reporting operations. Worked in database administration tasks such as creating tables, indexes, views, and triggers & writing complex queries using various clauses like Select, From, Where, Joins, Group By, Having, and Order By. Category: Successfully managed a portfolio of kitchen utensils and home care products, focusing on vendor management, inventory management, & sale optimization. Developed & maintained relationships with vendors, negotiating favorable terms & improving supplier performance, resulting in 30% reduction in supplier lead times. Collaborated with sales and finance teams to develop a P&L view of the business and the category, resulting in improved market insights and forecasting accuracy. Monitored prices and updated them on the front-end to ensure accuracy and competitiveness. Show less

Intern

• Jun 2019 - Jul 2019

Participated in preparation of design documents for track work, including alignments, specifications, criteria details and estimates. Analysed energy saving calculations of the product pipeline system using Excel to obtain the ideal pipeline network for the transportation of crude & finished products. Participated in preparation of design documents for track work, including alignments, specifications, criteria details and estimates. Analysed energy saving calculations of the product pipeline system using Excel to obtain the ideal pipeline network for the transportation of crude & finished products.

Intern

• Jul 2018 - Jul 2018

Customer Research: Conducted user research and surveys to gain insights into user needs and pain points. Collaborated with finance & operations teams to evaluate 10 customer data points of store locations in India, of Royal enfield, Metro & MI. Synthesised customer reviews of 500+ stores, integrated them to develop strategies and plan of action, increasing customer engagement by 15%. Mined records from various sources & compiled into an Excel file for analysis and insights, leading to 20% increase in reporting accuracy. Show less