An eCommerce company, selling thousands of products across many ecommerce sites including Amazon, eBay and Walmart. My role here includes:• Work with business leadership, marketing team and customers to provide analytical insights.• Analyze customer behavior and marketing data on Google Analytics platform to measure the effectiveness of marketing and sales campaigns.• Organize data and set reporting structures for recurring reporting requirements.• Perform Customer Segmentation Analysis for better targeting of products and optimizing the marketing efforts.• Gather all the marketing data that is scattered across various platforms and channels. Direct queries and analyze MySQL databases and logs to produce daily, weekly and monthly reports.• Amazon Seller Central – Inventory management, reporting, promotions, follow up on cases with Amazon support, Reimbursements.• Aggregating and cleaning data from multiple data files and sources. Spotting and correcting inaccuracies in the underlying data. Identify, analyze, interpret and report on trends or patterns in complex data sets.• Business Intelligence Reporting - Prepare Tableau dashboard, reporting and stories with variety of interactive charts, tables. Created budget, forecast, and profit and loss reports.• Track product categories and individual product performance over time and correlate customers and the marketing data to establish trends.

As a freelance consultant, I worked with multiple eCommerce businesses, where my role varied from analyzing website and customer behaviors to efficient reporting system - to provide the data-driven solutions to the day-to-day business problems. • Google Analytics UA, GA4 – Implement the findings from analyzing the customer behavior, marketing channel performance and website performance.• Amazon Seller Central – FBA, FBM, Inventory management, reporting, promotions, follow up on cases with Amazon support, reimbursements, customer service.• Query MySQL database for extracting, cleansing data for missing values.• Tableau Data Visualization – Worked on variety of interactive charts, action set, dynamic parameters, LOD expressions.• Data analysis, dashboards and interactive reporting using Microsoft Excel

• Devise, implement and run innovative campaigns across accounts in line with the clients goals and objectives• Mentor new team members - impart training, setting up team goals• Web Analytics (Google Analytics) implementation, analysis & reporting • Pay-Per-Click planning, implementation and optimization• Provide assessments, audits, and implementations for advanced web analytics tracking using Google Analytics.• Perform ETL for data from multiple marketplaces, databases and thirst part tools• Collaborate with external partners to assist with data collection, reporting, tags, tracking parameter implementations.• Pre & post marketing campaigns analysis & reporting• Developed Dashboard & interactive reports using Tableau and Microsoft Excel.

• Google Adwords, Facebook Ads Pay-Per-Click (PPC) Planning, Implementation and Optimization• Conversion Rate Optimization• Devise, implement and run innovative campaigns across your client accounts in line withthe clients goals and objectives• Pre & post marketing campaigns analysis & reporting• Deliver regular paid search management services to clients

• SEM - strategy development and execution• Google AdWords, Bing Ads, Facebook Ads – management and optimization• Web Analytics – Implementation, reporting and analyses• Data Analytics - analysis and reporting

• MIS Reporting• Market research