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 forecast for the TXUE Mass Business retention portfolio, using a simulation-based approach to account for variability in various factors and developed confidence intervals around our plan estimates.Set up an A/B test to optimize the contact strategy, helped eliminate customer contacts that were not value accretive and saved $200K in marketing costs while maintaining margins.Managed pricing for the Adjustable Month to Month (MTM) portfolio, used a Machine Learning based algorithm (KNN) to segment customers into value clusters and drove incremental CM from $2M to $7MPartnered with Advanced Analytics to develop a weather-related customer credit program reducing losses on the Month-to-Month book by 2%.Developed a scripted and automated process for monthly price changes using python (xlwings) as the backend and excel as the front end.

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 by 12%

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 system of real time Transaction tracking to track accounts on Promotions - Developed Supply chain analytics automatically flagging late orders by SKU allowing for more dynamic adjustments to stock levels to meet demand. Boosted on time fulfillment from 92 to 98%

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 Essilor of America identifying and reducing accessorial charges by 12%

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 marketing program portfolio

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 company $80000 per year.Set sales targets for the sales team. Lead the team and worked closely with them to achieve our goals. Changed the product mix in Western Uttar Pradesh to favor residual paints. Increased sales in that region by $100,000.Developed the key business relationship with spectrum paints, negotiated price of resins based on their consumption, became a preferred supplier and booked orders worth $400,000.

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 S-82 Indios switches. Reduced product returns from distributors by 11%, a savings of $500000.Developed the pricing strategy for the project channel, creating bundles of common services and products. Developed the concept of pre-fixed, snap in place electrical switches, reducing installation costs for customers by 12% .

· 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 Collage's High net Worth individual database and sold a consortium of investors preleased commercial property in the Viva Collage mall in Jalandhar.

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