Business Intelligence Engineer
Current- Evaluate Google Analytics web performance data against data imported from Salesforce, Marketo, HubSpot- Growth charter related analysis using SQL (Snowflake) and Dash-boarding using Power BI- Expedite root cause Analysis of problems and suggesting improvements based on Data driven insights- Designing Business strategies based on Data findings and implementation- Sourcing, Designing & Building foundational data sets- Responsible for driving data-driven approach to highlight problems and identify opportunities- Setting up measurement frameworks like Pre-Post, A/B tests to assess project impact- Develop compelling stories with business insights, focusing on the strategic goals of the organization- Collaborating with cross-functional teams to understand the business requirements and deliver scalable business solutionsProjects - 1. Sales Analysis for e-commerce brands GWG Outlet and MommacartThe projects provided following insights :- Sales trends over time - Identification of the top/best-selling products- KPI Metrics for Total Orders- KPI Metrics for Total Sales- KPI Metrics for Total Products- KPI Metrics for Average & Maximum Sales- Calculates revenue metrics such as total sales and profit margins- Highest Sales By Month and Year- Geographic Insights- Top Product- Least profitable Product- Top Performing Customer2. Churn Prediction Analysis for e-commerce website GWG Outlet
