Spinny is an online car reselling platform serving to organise the large 2nd sale car market by providing assured cars and after sales services across 5 metropolises in the country. As a Business Analyst, my key projects and inputs are as follows:• Data Visualization and Dashboards- Developed an automated funnel for the supply sources using for monitoring and identifying key business issues at problems on a regular basis- Developed an automated funnel for managing the inspectors by… Show more Spinny is an online car reselling platform serving to organise the large 2nd sale car market by providing assured cars and after sales services across 5 metropolises in the country. As a Business Analyst, my key projects and inputs are as follows:• Data Visualization and Dashboards- Developed an automated funnel for the supply sources using for monitoring and identifying key business issues at problems on a regular basis- Developed an automated funnel for managing the inspectors by governing the quality of inspection for procurement of cars- Created a payment reconciliation view to automatically filter the unreconciled transaction for weekly payment • Modeling- Built logic to give feedback on current procurement price of car by (i) comparing the current price with the market price and, (ii) factoring in depreciation on new car price - Developed a tool for automating the revision of listing price of cars to maximize margins and minimize selling tat• Planning- Developed action plan for an in-house project ‘Budget Car Mall’ w.r.t supply, refurbishment and demand - Determined the supply size, modalities of procurement channels and refurbishment cycles to achieve the target of selling 300 budget cars in 2 months - Determined the resource requirements across the levels for meeting the supply and demand targets● Task Automation- Automate supply and demand sheet which fetch information from database and print against every car- Developed an automated inventory sheet and framed compliance parameters for information added to the dashboard for the utilization by sales team● Additional- Scrapping of required data from online sources for database population and listing price determination as per market trends Show less

Career Power is India's leading education-technology company focussing on training students for the entrance examinations in the Govt. space. As a Data Analyst, my key projects and inputs are as follows:• Modeling- Built product recommendation logic for users based on user behavior and increased the conversion by 3%- Built Coupon Code logic to recommend best real-time coupon code available for any product- Developed a data pipeline of major business metrics to automatically… Show more Career Power is India's leading education-technology company focussing on training students for the entrance examinations in the Govt. space. As a Data Analyst, my key projects and inputs are as follows:• Modeling- Built product recommendation logic for users based on user behavior and increased the conversion by 3%- Built Coupon Code logic to recommend best real-time coupon code available for any product- Developed a data pipeline of major business metrics to automatically trigger a response upon disruption• Data Visualization & Dashboard- Developed automated real-time dashboard by creating data lake from SQL, Big Query, Google Analytics to show information on key business metrics- Built real-time view of post-purchase user experience of product for understanding the product quality• Marketing Automation- Built real-time feed of best-selling products in different categories to automate online marketing campaigns and sales activities for increasing revenue and maximizing efficiency• Product Management- Increased application engagement by 5% by analyzing parameters like views, likes, comments and watch time of the video courses to sort the them based on user popularity - Increased application engagement of fee test section by suggesting best available test based on user behavior Show less

○ Successfully interpreted data in order to draw conclusion for managerial action and strategies○ Optimized data collection procedures and generated report on weekly and monthly basis○ Utilized google data studio for visualization of important business metrics for trend analysis

○ Led a team of 8 in logistics for providing food and refreshments to judges of various events○ Coordinated with other teams and volunteers to ensure smooth conduction the festival