Oct 2021 – Jan 2023 · 1 yr 3 mos

Oct 2020 – Sep 2021 · 11 mos

Oct 2019 – May 2020 · 7 mos

• 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

Feb 2019 – Sep 2019 · 7 mos · Gurugram

• 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

May 2017 – Jul 2017 · 2 mos · Jaipur Area, India

• ○ 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

Sep 2016 – Oct 2016 · 1 mo · IITD

• ○ 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