• Interacted with stake holders to create an Analytical framework using Hive, Google BQ and bash scripts for automating data refresh for various customer related analysis.• Applied various analytical techniques like Test-Control Analysis, Customer Profiling and Time Series Clustering to assist business in devising marketing strategies for the customers.• Assisted Merchandising team by creating customer purchase footprint for better customer targeting.• Worked on Customer Value Index for e-commerce competitor analysis measuring factors impacting GMV.• Engaged with Marketing Clients to form various business hypothesis around omni-channel customer behavior and thereby conclude actionable business insights. • Worked on driving customer acquisition campaigns using Customer Propensity models.

• Interacted with Inventory, Operations and Finance Departments to model requirements into deliverables. • Created data pipelines for automated data refresh from Aurora ERP to SQL Warehouse• Created an Executive Level dashboard to report KPI’s for driving informed fact-based decision making following statistical quality control techniques.

* Descriptive Analytics on identifying patterns in resident’s recycling behavior and the impact of government's initiatives on the recycling habits of residents.* Predictive Modeling on classifying RFID malfunctioning.* Regression Analysis on identifying seasonality in neighbourhood participation rate based on demographic factors.

Financial Reporting for Microsoft:• Created Power BI Dashboards and Power pivots to report Sales KPI’s across Product Categories, Line of Businesses, geographies and other drilldowns for Online and Brick & Mortar Stores.• Centralized data pull by creating data pipelines using ETLs (Extract Transform Load) for more than 26 upstream sources including FTPs, Adobe Analytics Omniture APIs, Tabular Models and Databases.• Created OLAP Multidimensional Cube (SSAS) to assist Business and Finance clients in Sales Trend Analysis through Metrics as WoW, MoM, YoY etc.• Created a Test Case Auditor (SQL queries, Powershell) to identify issues and eliminate significant manual effort in post-production deployment testing.Site Analytics for Microsoft: • Used Omniture Site Analytics to measure conversion rate at various touch points during site navigation• Tracked Customer journey to Microsoft Store website by designing queries leveraging Cloud computing for Sales Funnel Analysis.• Performed A/B Testing to measure efficacy of multiple website modifications as well email campaigns.