This platform facilitated:

Unified Customer Experience: Integrated data from various sources to provide a seamless customer experience across online and in-store touchpoints.

Streamlined Retail Operations: Centralized and automated back-office processes to enhance operational efficiency.

Key Responsibilities:

• Data Management and Analytics:

  • Designed and developed the data warehouse schema to efficiently store and analyze retail data.

  • Developed T-SQL queries and scripts for data extraction, transformation, and loading (ETL) processes.

  • Created comprehensive analytics reports using Power BI for data visualization and insights generation.

  • Implemented data load automation for streamlined data movement within the platform.

• Database Development and Administration:

  • Designed, developed, and administered Azure SQL databases and on-premise SQL Server instances.

  • Performed T-SQL performance tuning and optimization to ensure efficient data querying and retrieval.

• Development Operations:

  • Implemented a continuous integration and continuous delivery (CI/CD) pipeline for automated code testing and deployment.

  • Utilized PowerShell, Shell, and Batch scripting for various automation tasks within the platform.

• Communication and Collaboration:

  • Maintained direct communication with stakeholders to understand requirements and provide technical guidance.

  • Participated in code reviews and refactoring efforts to ensure code quality and maintainability.