Gaurang Mehra Email & Phone Number

Dallas, TX, US

Irving, Texas, United States

Built and put in production an ML survival model predicting risk of customer churn over the lifetime of the customer acting as the key input to an intelligent offer engine for retention transactions reducing net attrition by 1%.

Dallas

Developed the pricing strategy for Term Expiration and the Adjustable MTM portfolio. Partnered with the Advanced Analytics group to develop data driven pricing programsDeveloped analytics and forecasting for Term Expiration customers, set targets for channels, and helped drive renewal margins from $27/MWh to $32/MWh.Developed the Long-Range Plan and.

Dallas/Fort Worth Area

Dallas/Fort Worth Area

• Understood requirements of key stakeholders (Essilor Marketing, Frame dream Luxottica marketing) for enhanced reporting and tracking of online ads/formats post acquisition.
• Built the business case for switching the All About Vision Acquisition from their in house ad serving platform to DFP and led the migration effort
• Presented strategic plan to boost online ad revenues over the medium term by tapping opportunities such as selling international impressions on geo served ads, increasing overall revenue by 3% and international revenue.

Dallas/Fort Worth Area

Developed a Sales Analytics and CRM platform for Nassau Vision Group by joining/creating multiple data sources ( using Spotfire, SQL server and Excel ). This addressed the following use cases - Increased utilization of existing promotions by customers boosting unit sales by 12% - Automated creation of target lists for promotions based on usage - Developed.

Dallas/Fort Worth Area

Developed Analytics platform for Essilor Strategic sourcing team using Tableau/Spotfire and R - Helped uncover supplier redundancies across Essilor subsidiaries and drove savings of $2m. - Improved payment terms across the company leading to working capital improvement of $583K Developed package level transportation analytics for 5 Distribution centers for.

Dallas

Prepared marketing budget and promotion plan for 2014Developed and executed turnkey promotions with key wholesale lab distributorsDeveloped new KBco websiteCreated a seasonal lab rewards program for Independent distributorsCreated brand marketing materials and training guides for Eye Care Professionals (ECPs)Analyzed and reported on ROIs and streamlined.

Dallas/Fort Worth Area

• Developed Customer Lifetime Value Metrics for Eye Care Practioners (ECPs) in the Visioffice program and helped Essilor identify the 30% ECPs that were unprofitable potentially saving the company $5 million.
• Analyzed customer profitability and streamlined current marketing programs in accordance with customer profitability clusters with potential savings of upto $1 million per year.
• Developed best practices modules based on primary research with successful Visioffice ECPs.
• Rationalized the rebates offered to Visioffice ECPs with a potential savings of $750,000 per year.

Launched the Residual paint product line, recruited 4 retail sub-distributors and achieved sales of $300,000 in the first year.Renegotiated terms of the commercial policy agreement for the high grade resin line of products with Cytech. Rationalized orders into fewer larger orders based on previous demand patterns and negotiated volume rebates saving the.

Developed key business relations with consultants and architects, analyzed complex bids for projects and got orders worth $1,000,000 specked/approved including for the Birsa Munda Airport development in Ranchi India. Created a technical training module for the sales team, communicated with and trained the sales team on how to sell the new range of Simon.

· Created and managed the sales channel for the Collage Windsor apartments. Led a team of 6 channel partners, resolved channel conflicts as and when they arose and pre-sold 65% of the project garnering orders worth $4,000,000.· Managed the relationship with our overseas partner Avatar International and achieved 35% of our sales internationally.· Targeted.

Master, Business Administrationmarketing And Business Analytics; Electrical Engineering

Activities and Societies: Marketing Club, Consulting Club.GMAT 690 GPA (3.7/4)

Master Of Business Administration, Marketing And Business Analytics

Activities and Societies: Beta Gamma SigmaMarketing and Business Analytics; GMAT 690 Vice President International Club, Consulting Club.

Bachelors, Engineering; Electrical And Electronics Engineering

Electrical Engineering

Education record

Education record

Bachelor Of Engineering (Beng), Electrical And Electronics Engineering