• Analyzed customer purchase patterns and ad performance using Shopify and Amazon analytics to drive data-driven decisions and improve marketing ROI.• Managed and maintained datasets on product sales and customer insights, supporting a business with significant annual revenue.• Developed and presented performance reports to partners, translating data insights into strategic actions to enhance operational efficiency.

•Analyzed and prioritized refactoring tasks, optimizing SQL database performance and ensuring seamless system functionality for reporting and analytics.•Enhanced and dynamically updated Power BI dashboards to meet evolving team requirements, enabling real-time decision-making.•Automated ETL workflows to streamline data extraction and transformation, reducing manual efforts by 40% and improving data accuracy.•Provided technical guidance and implemented best practices, fostering collaboration and improving overall data quality across departments.

•Translated stakeholder requirements into dynamic Power BI dashboards and SQL views, facilitating strategic decision-making.•Spearheaded the migration of Tableau dashboards to Power BI, meeting updated requirements and enhancing functionality.•Designed clear treemaps in Visio to visualize SQL views, tables, and database connections, helping stakeholders clarify requirements and guide future development.•Documented end-to-end technical processes, supporting transparency and scalability during data warehouse upgrades.

•Coordinated and managed projects for 5 groups, including project deliverables and reference materials.•Organized meetings weekly with students to address and resolve course-related inquiries.•Championed the successful completion and delivery of final projects.