Sid Mehandru Email & Phone Number

Dubai, United Arab Emirates

Premier Marketing Analytics firm. Turning heaps of data into actionable insights.Past Clients: Google, AmEx, NeilPatel, Delta, SitMeansSit, Sugatan, and 200 more...

Bengaluru, Karnataka

Strategy Analytics - Credit Cards

Gurgaon, Haryana, India

Project: Strategic Analyses for US based Small Business Loan ProviderMarketing:• Managed a 1-member team in execution of direct mail acquisition campaigns; Streamlined selection process helping reduce TAT by 30%• Identified population segments responsible for decline in approval rates for submitted applications Risk:• Managed 2-member team in development of ‘Monthly Portfolio Review’ deck for CXO team showcasing portfolio health and performance of key business segments• Analysed loss rates for different pricing based grades of customers; Recalibrated grade allocation in credit policy by identifying ~5X risk population segments • Identified weekly payment product major driver in losses; Implemented credit policy cuts on Construction & Transportation industries with ~3X risk• Developed an early warning dashboard with 50+ KPIs at application and acquisition level to predict future performance, and indicate early signs of economic recessionOrganizational Development: Indus Impacts (CSR Initiative), and Resource Development• Managed project workstream for India’s largest educational NGO to develop data collection and warehousing infrastructure for student examinations held on tablets• Led SQL and PowerPoint trainings for new recruits of 2019

Gurgaon, India

Project: Marketing Analytics Support for US based E-Commerce Insurance Firm• Identified optimal risk segments based on customer health profile by using decision tree algorithm (CHAID), and developed in-house underwriting strategy• Overhauled the marketing dashboard with the addition of 5 new identification tags thus improving the process of website traffic source identificationProject: Strategic Analyses for US based Credit Card ProviderDashboard Maintenance and Automation:• Developed and automated monthly dashboard exhibiting trends for acquisition metrics such as web/mobile enrolment and activity rates, and reducing TAT by 50%• Managed end-to-end maintenance of Tableau dashboard for CXOs show-casing metrics across business domains; Streamlined report generation, reducing TAT by 75%Analysis:• Undertook qualitative analysis for a newly launched balance transfer campaign to understand customer behaviour• Created excel tool to forecast month-end balance at portfolio level using campaign inputs such as % take rate, customers solicited and average balance transfer size• Identified seasonality in month-end balance curve and adjusted curves using past performance data; Collaborated with Finance team to re-calibrate modelled curves

Gurgaon, India

Project: Process Scale-up and Engineering Activities Related to Multi-Purpose Plants | Department: Chemical Technology Group(CTG)Created custom-made worksheet using excel modeling for Project Management of the P-22 plant to track deadlines, schedules, progress of team members, budget and display information on the dashboard as Gantt Chart and Milestone Tracker.Designed excel model for Fire Hazard PSV and Stripping Columns, and studies related to setting up of the pilot plant, by doing HAZOP, reaction kinetics, Heat of Reaction, and Material Incompatibilities study.

Chandigarh Area, India

Project: Identifying clusters of MSME in districts of Punjab, and developing case studies for MOFPI. Department: Government and Infrastructure Advisory(GIA)• Working with the Central Government as Project Management Advisors for the execution of various schemes to promote small and medium scale industries in Punjab. This involves creating Detailed Project Reports(DPRs) for the installation of Common Facilities Centre(CFCs) for industry clusters.• As part of the team of consultants for the Ministry of Food Processing, played a pivotal role in developing case studies of various FPO-corporate contract farming initiatives which involved on-ground interaction with farmers and operation heads of corporations, and eventually presenting them to the cabinet minister, Mrs. Harsimrat Kaur Badal.

Gurgaon, India

Project: Logistics freight volume consolidation with inventory management integration using excel modelling. Department: Strategy and Operations• Proposed 20% reduction in freight cost by developing an excel tool to maximise freight load giving product suggestions based on regional warehouse inventory levels• Successfully held a reverse auction for logistics vendor and negotiated prices along with on-site team, saving INR ~1.2 crores annually

Pune

Received special recommendation from Head SBU for being a “dedicated and hardworking intern” during completion of project. Reduced the cycle time by 5% and rejections by 10% using Dent Doctor tool. This involved creating a matrix of flow processes at the Die Casting Unit, identifying the faulty process and suggesting low cost solutions to improve it.

Engineer’S Degree, Chemical Engineering

Activities and Societies: Inspired Karters Racing BAJA, Society of Automotive Engineers, SSMS Election Commission

High School, Non-Medical Studies, 93.8%

Matriculate, Cgpa 10 Out Of 10