Developed a sales analytics data warehouse and a reporting solution for a consumer healthcare client using MS Azure stack. Created complex daily sales, net revenue management and other reports, dashboards to support sales.

Developed data pipelines in Azure data factory V2 for data ingestion. Prepared and validated using data bricks. stored data in an Azure data lake and then model it in Azure Synape analytics (ADW) and used PowerBI to develop reports and dashboards.

Led the deployment using Azure DevOps pipelines to promote Azure components to a higher environment. Led a team of data engineers and business analysts while ensuring data governance policies are followed for data access.

Designed a reporting solution in Azure for an Online fashion clothing brand in UK to support the finance department, which extracts data from Dynamics365 into an Azure SQL database.

Built reports and dashboards for sales, P&L, Tax, VAT and other operational reporting to support finance operations. Developed a proof-of-concept to prove the solution and design flow.

Defined a data migration strategy to migrate data from the old system to Dynamics 365. Developed data extraction batches and refresh daily data loads to the Azure SQL database.

Served as a technical architect and lead for an online fashion clothing brand in the UK to design new applications and manage the technical delivery. Collaborated with the client DBE and architects to design new applications or enhance old ones.

Created ETL flow in SSIS to read data from a retail ERP and ingest into the operational database. Developed SQL Sprocs to transform and load the data in the target operational database. Reviewed code and technical deliveries to ensure quality.

Managed the production releases of the Middleware platform. Organized and facilitated agile and scrum meetings, which included sprint planning, daily scrums and stand-ups.

Served as the database engineer for a data migration of all customer-related information from a SQL Server database to Gigya data store (MongoDB) and changes in legacy SQL server database to implement the new features on the customer site.

Designed and developed ETL flow for data migration from sql server to MongoDB. Created and modified database objects such as procedures, functions, and views. Created and modified the replication between two databases.

Collaborated with the client for requirements gathering. Onsite coordinator for data migration project and other database tasks. Performed ETL unit, integration, and performance testing.

Developed an enterprise-level data warehouse for a retailer company that contains financial and HR data, which was further used for analysis and reporting.

Extracted data from SAP extractors using the Business Content Integration method. Developed an ETL flow in Informatica using Pushdown Optimization and Teradata Parallel Transport Operators. Acted as the point-of-contact for all ETL-related tasks.

Supported the Informatica environment by overseeing administration tasks.