Crm Analyst
Current•Lead the analysis on annual sale events, uncovering a 30%-40% revenue boost during federal holidays, and reduced YOY decrease from 20%-30% to 8% by suggesting a new sale name, enhancing cross-departmental event optimization efforts•Spearhead the creation of 3 interactive Power BI dashboards that provided crucial CRM insights, aiding in campaign optimization and offering a clear view of the company's overall health, while reducing reporting latency by 5-7 days•Utilize advanced SQL, Python scripting and Excel for high-level data analysis, streamlining reporting process from 3-5 days to 1 day upon stakeholder request and optimizing team productivity•Conduct incremental analysis projects across various marketing channels to unveil that the catalog program yields an incremental factor of 16%•Facilitate bi-weekly JIRA sprints to manage workload and priorities of 8-10 data warehouse partner members, resulting in streamlined operation and optimized project delivery
