Gurgaon, Haryana, India
Client: One of the Biggest Entertainment Conglomerate of US(Mobile App) Test Control Analysis • Play Along Video (PAV) is a cutting edge feature on the app designed to provide kids with a blithesome experience asking them to interact - tap, touch, swipe or speak to move through their various storylines while on the app • Analyzed the impact of newly launched PAV feature on customer retention, acquisition and engagement • Extracted all customers subscribed to the app for at least 6 months before the launch of PAV(long –term customers) • Segregated long-term customers into PAV watchers (test group) and PAV Non-Watchers (control group) • Mapped control group to test group based on minimum distance b/w total time spent on the app, total visits on the app and total videos started during the pre-PAV period • Extracted stratified samples from test and control mapped data and compared the means of the 3 metrics post launch using t-test • Analyzed post launch impact to conclude whether the PAVs had an impact on customer retention & engagement Decision Tree Algorithm • Compared the Android and iOS app usage behavior of subscribers and non-subscribers & engineered variables which helped in driving decision of subscription (start of the free trials) • Identified important shows on the app like no. of times the app was launched, no. of times a user has entered the subscription page, time spent on the app, etc. • Built Random Forest model to extract important factors that lead to start of free trial subscriptions • Subscribers and non-subscribers were segregated into separate groups based on the variables with high gini index from the model Client: One of the Biggest Entertainment Conglomerate of US Social Media Analytics • Performed social media analysis of various social media platforms like Facebook , Twitter, Instagram and many other using social media tools • Generated insights for marketing team of the channel to design the advertising strategies
•Analysed the effect of Flash Sales during December on Room Nights and Take-Rate on Hyperlocation, City, ASP-Buckets levels •Remodeled the discount rate in each hotel in order to reduce the Burn Rate; curtailed overall loss bore by the company •Proposed measures to increase the efficiency of Business Development Officers (BDO); incorporation of more number of hotels •Optimized BDO’s span on basis of geography, quality, no. of hotels; using travelling salesman algorithm in MS- Excel, Macros •Aided in uploading promo discount data and conditions of availing the discount to the website for the Flash Sales using Perl
• Analysed market values and business prospects of a specific case, Vehicle to Vehicle communication, an upcoming technology • Studied the impact of digital disruption on CPG and oil & gas sector including their supply chain predicting the future of the respective sectors. • Assisted in IT benchmarking for business continuity planning in a project for ministry of foreign affairs of one of the major GCC countries. • Maximized test data by collecting quality business cases, to be used as test input variables for an analytics model. • Received letter of recommendation based on outstanding performance.
• Analysed the annual reports of 810 established industries to cull financial data, to be used for future research work. • Deciphered the aspects of sample Comparative Balance Sheet and Income Statements. • Assisted the overall movement of project to minimize net completion time and expand research data.