Prashant Mehra

Data Engineer

Duco Consultancy Pvt. Ltd•  April 2022 - Present•  Suva, Fiji

Implemented and optimized data pipelines to big data from ingest Microsoft D365 to Azure Data Lake and transformed data using Azure Synapse to increase execution speed. Helped New Zealand's top outdoor adventure store go-live and support postgo- live on both the Data Integration and Data Engineering front. Spearheaded Data Engineering Team to Clean, Model, and Structure Data in SQL for Reporting Purposes with Incrementally Loaded Tables. Develop Queries for Auxi AI Bot to display Charts on underlying data. Handled complex integrations involving various components of Azure and Synapse Analytics. Migrating resources across different environments with Azure DevOps. Provided performance tuning and improvement recommendations to enhance the usability and automation of the data platform Accessed data from multiple sources such as Microsoft Dynamics- 365, JSON files, function apps and other external sources to create data views to be used in BI tools such as Power BI. Aligned with cross-functional teams and Vendors to structure problems. Performed data warehousing and data modelling concepts such as star and snowflake schemas. Implemented DevOps methodologies for code version control, continuous integration, and automated deployment. Trained/Mentored Freshers and Colleagues.