Apr 2017 – Mar 2019 · 1 yr 11 mos

• Working at a cusp of Product, Business & Technology teams at Yatra, constantly striving for more revenue and better customer experience. Led Business Intelligence, enabled 100+ Yatraites with data-driven decisions.
• Developed Dynamic Commission Parting System for B2B Flights Business - designed the full flow, variables and features, pilot experiments. Estimated Potential Savings is 0.25% of online revenue
• Designed Dynamic Discounting System for B2C Flights business - optimizing marketing spends across user-type, routes, airlines, booking-window, etc.
• Optimized Flights International Search Result Page - both in terms of quality of results and number of results by developing Heuristic Rules. Improvement of 10% in the funnel with 45% less results
• Conceptualized and integrated a NLP based parsing engine to decode cancellation charges details Comprehensibly & Correctly; Savings of ~ ₹1 Million per month by reducing operational losses

Nov 2015 – Mar 2017 · 1 yr 4 mos

• Data Analytics
• Reduced CPA of SEM Campaigns by 20%. Optimizing at Location, Time, Keyword bid and budget levels. Set up real-time monitoring of key campaign performance KPI’s with a control dashboard
• Performed customer segmentation over the entire user base, factoring in purchases, recency, and click-stream behavior; in-use for cross-selling & personalized campaigns, customer support etc.
• Data Visualization
• Designed an automated Visualization Suite – 10+ dashboards over 5 data sources – delivering actionable insights to the 60+ membered hotel partner team;
• Developed real-time funnels & alerts dashboards to monitor flights and hotels operations & business
• Data Warehousing
• Conceptualized Yatra’s data warehouse on AWS using Redshift and S3; integrating 20+ data sources, incorporated transactional data for all lines of businesses (LOBs), SSO data, App data, and clickstream data.

Mar 2015 – Oct 2015 · 7 mos · Bengaluru Area, India

• Core member of a chat based application where end user can fulfil his/her daily household and personal needs.

Jul 2014 – Mar 2015 · 8 mos · Mumbai Area, India

• Basic data modelling, data harmonization and data visualization involving extensive use of tools like MS Excel, SAS and Spotfire among others for providing analytical solutions to business queries of leading CPG firms

Jun 2013 – Aug 2013 · 2 mos · Mumbai

• Tailored a VBA Tool, instantly fetching 72 variables of loan customers, enhancing risk analysis.
• Automated and channelized the data capturing and validation processes using SSIS packages and SQL
• Acquired hands-on experience with Credit Risk Scorecard development and SAS

May 2012 – Jul 2012 · 2 mos · Pune Area, India

• A letter of appreciation was awarded for the hard-work and initiatives taken
• Devised a 270 days procurement plan of exhaust parts while achieving 33% less procurement costs.
• Implemented assembly line modifications; resolved 4 engine house issues with zero cost.
• Bench-marked 3 Tata cars against vehicle layout & best assembly processes

Dec 2011 – Dec 2011 · 0 mo

• Analysed the possible causes for deformation of high pressure reactors.

May 2011 – Jul 2011 · 2 mos · Beawar Area, India

• Worked on improving the wearing and tearing of Crushers and Roller liners.Suggested the use of Bimetallic castings and various heat-treatments.