Serving multiple verticals of the City Logistics Product Team at Flipkart, my experience in brief:- Streamlining data using HQL and building dashboards on Power BI for product FLIP, enabling effective decision making in the areas of address intelligence of customers. - Performing multiple studies and analyses around delivery fakes, enabling a lot of insight and serving to build a model for the prediction of delivery fakes.- Building multiple Power BI dashboards across capturing… Show more Serving multiple verticals of the City Logistics Product Team at Flipkart, my experience in brief:- Streamlining data using HQL and building dashboards on Power BI for product FLIP, enabling effective decision making in the areas of address intelligence of customers. - Performing multiple studies and analyses around delivery fakes, enabling a lot of insight and serving to build a model for the prediction of delivery fakes.- Building multiple Power BI dashboards across capturing essential customer satisfaction and delivery related success metrics.- Handled multiple ad-hoc requests for data extraction and analytics. Show less

- Led and mentored three other analysts.- Built a system to detect anomalous behaviour in terms of order growth, key-eventstriggered and website traffic, which led to the creation of short term marketing policiesto boost growth in orders.- Used Segment.io's events to track the performance of front-end changes pitched by theproduct team to determine the feasibility of the product.- Set up data collection and dashboarding end to end for the offline department to… Show more - Led and mentored three other analysts.- Built a system to detect anomalous behaviour in terms of order growth, key-eventstriggered and website traffic, which led to the creation of short term marketing policiesto boost growth in orders.- Used Segment.io's events to track the performance of front-end changes pitched by theproduct team to determine the feasibility of the product.- Set up data collection and dashboarding end to end for the offline department to trackthe performance of the field executives.- Built a unified dashboard for the CEO's office to provide an aggregated, department wiseview on various metrics.- Categories leads, assigned them to calling executives & attributed conversions to agentsfor the pre-sales team which led to the team being able to handle approx. 13,000 calls amonth as compared to 8,000 calls being handled before the system was in place.- Built & automated reports to track KPIs of the channel sales & calling teams.- Built reports and dashboards for various teams to aid in the day-to-day functioning ofthe company.- Handled urgent requests for data extraction and analytics jobs on an ad-hoc basis. Show less

- Gathered, managed and processed data using SQL- Analysed textual data to find keywords and patterns- Predicted probable transaction failures using logistic regression