HARISH VADLAMANI

• Results-driven Data & Analytics Consultant with experience in performance measurement, experimentation, and yield optimization for a non-search ads marketplace. Proven expertise in driving data enablement, designing scalable solutions, and delivering actionable insights using Adtech KPIs . Skilled in stakeholder management, requirement gathering, and leading a high-performing offshore team of 7 analysts. Adept at balancing technical execution with strategic oversight to maximize ad revenue and business impact

• Spearheaded data enablement and yield analysis initiatives to evaluate KPI impact and recommend optimizations, resulting in improved ad performance across multiple publishers.
• Automated and optimized data pipelines in Azure Data Factory and SQL Server, reducing manual effort by 35% and enhancing data reliability and scalability.
• Led SQL database optimization efforts, achieving a 40% reduction in query runtime, significantly boosting project efficiency.
• Designed and developed interactive dashboards to visualize performance trends and uncover key performance drivers, enabling faster and more informed decision-making.

Data-Driven Clearance Price Optimization for US Retailer

• Designed and implemented an automated pricing optimization model to maximize revenue during clearance periods, generating weekly price recommendations for 1,000+ items across 700+ U.S. stores.
• Applied statistical modeling and data science techniques to quantify the impact of key variables such as seasonality, price elasticity, product breakage, and advertising.
• Built and validated a predictive framework to support dynamic markdown decisions using historical sales, promotions, and store-level performance data.
• Deployed the solution in a big data production environment, collaborating with data engineering, product, and operations teams to ensure end-to-end automation and scalability.
• Delivered measurable improvement in clearance revenue and inventory turnover, while maintaining margin efficiency.

HNI Targeting for Leading SE Asian Bank

EXL Decision Analytics | Jul 2014 – Dec 2015

• Developed a propensity model to identify and rank High Net Worth Individuals (HNIs) using features such as salary, car ownership, residential locality, age, and reachability.
• Engineered a locality-level land price indicator by mapping addresses and analyzing property rates across 1,300+ localities in 5 Indian cities.
• Identified clusters of luxury car owners to enable location-specific marketing events and targeted campaigns.
• Tools used: SAS, Excel, VBA.

Lead Generation via Twitter Analytics

• Led a social media-based lead generation project by mining Twitter data to identify prospective banking customers.
• Performed keyword extraction and tweet clustering to assign product affinities; implemented KNN to form social graphs for better targeting.
• Applied fuzzy matching techniques to cross-reference Twitter leads with the existing customer database, improving lead quality.
• Technologies used: Text mining, social graph analysis, KNN, fuzzy matching.

Predictive Modeling – Customer Income Estimation

• Built predictive models to estimate income levels for customers with missing income data using transaction history (CASA, Giro, etc.).
• Developed and compared multiple models including Linear Regression, GLM, and Neural Networks to improve income estimation accuracy.
• Supported customer segmentation and targeting initiatives by enriching customer profiles with predicted income levels.
• Tools & Techniques: SAS, Regression, GLM, Neural Networks.