__

Professional Background

Over the years, I have worked in air logitics, supply chain, marketing and eCommerce industries.

Senior Marketing Analyst- Strategy, Lifecycle and Customer Experience, zulily -

• Strategizing, management, financial modelling and reporting of zulily’s product returns program
• Utilized analytics to recommend product returns process improvements resulting in $8.1M annual cost savings
• Performing experiment design, power analysis and running A/B tests to improve customer experience and prevent churn
• Providing analytics support and building audience for Email and Offers campaigns
• Statistical analysis of user behavior on web and app using clickstream, orders and customer data
• Running price sensitivity tests for offers audience to optimize offers spend
• Answering ad-hoc business questions using advanced analytics techniques

Graduate Student Consultant

Worked as a graduate student consultant to help increase the annual revenue of a national food delivery company. The major tasks involved in the data-driven project -

• Customer Segmentation
• Market Basket Analysis
• Seasonality Analysis
• Creating Buyer Personas
• Measuring success of coupon campaigns

Business Analyst-

• Performed customer segmentation using K-Means clustering leading to better customer service and increased customer satisfaction
• Developed customer churn prediction model using Logistic Regression based on key metrics and developed retention strategies leading to a 12% increase in customer retention
• Led the design of Key Performance focused interactive dashboards in Tableau for Sales, Customer Support and Billing teams
• Provided technical consultation to air freight forwarders for setting up their business
• Developed competitive shared service models for small freight forwarders
• Consulting Airlines, Ground Handling agents, and the Freight Forwarders to help set up their business
• Working as a communication channel between HM Revenue & Customs Office and the group of Freight Forwarders, Airlines, and Ground Handling Agents
• Performing Descriptive analytics of the air cargo data
• Generating interactive reports for Sales, Customer Support and the Management teams in Tableau
• Visiting shed operators around London Heathrow and understanding their ground handling operations

Software Engineer

• Performed descriptive analytics in R and suggested cargo message tariff changes leading to an increase of 15% in quarterly revenues
• Developed Extract, Transform and Load (ETL) applications in Java to extract air cargo transaction data
• Led a team of four to design, develop and maintain the International Air Transport Authority air cargo message database in SQL, catering 0.2-0.3 million air cargo messages per day
• Developed SQL queries for Oracle Business Intelligence Discoverer dashboards for different teams
• Fine-tuned SQL queries to maximize efficiency and performance
• Managed client engagements and client visits to understand ground handling operations

Technical Associate

• Generated KPI focused Oracle Business Intelligence Discoverer reports for sales, customer support and billing teams
• Performed end-to-end white box testing of IATA air cargo message database

Tools and Languages

• R Programming
• SQL
• Python
• BigQuery
• SPSS
• Google Compute Engine
• SAS

Skills

On a day-to-day basis, I mostly work on R, SQL, Python and Tableau

Analytical Skills-

• Simulation
• Exploratory Data Analysis
• Regression
• Text Mining
• Sentiment Analysis
• Clustering
• Hypothesis Testing
• Association Rules
• Classification
• Optimization
• Statistical Modeling
• Bagging, Boosting
• Reporting and Visualization
• Information Filtering
• Geospatial Analysis
• Google Analytics