Sachin Patel

About Sachin Patel

Professional Summary : Data Engineer with 6+ years of experience in IT, specializing in Azure Cloud Data Solutions, ETL development, and Data Warehousing. Proven expertise in orchestrating large-scale data workflows, optimizing performance, and driving automation initiatives. Adept at working with diverse data sources, leading integration projects, and delivering scalable solutions that improve efficiency and reliability. Skilled in collaborating with cross-functional teams and guiding junior members, with strong analytical and problem-solving capabilities.Core SkillsCloud & Data Integration: Databricks, Azure Data Factory, Azure Synapse Analytics, Microsoft Fabric, Microsoft CRM Dynamics, Azure DevOpsETL & Data Warehousing: Informatica PowerCenter, SQL Server, Oracle Database, Dataflows, Azure Synapse PipelinesDatabases: Oracle PL/SQL, MS SQL Server, Azure Synapse SQLData Modeling: Fact & Dimension tables, Slowly Changing Dimensions (SCD), Star & Snowflake schemaData Sources: Deltalake Table, Parquet, JSON, APIs, Salesforce, Flat FilesOther Skills: Performance Optimization, Monitoring & Automation, Production Support, Process Improvements

Experience

1. Azure Data Engineer

   Marsh

   Jan 2024 — Present · Mumbai, IN

   Orchestrated end-to-end data workflows using Azure Data Factory, streamlining Accounts, Contacts, Employee Information, Sales and Opportunities data processing.• Integrated data from Dataverse to Azure Synapse SQL table and Oracle table using Synapse Pipelines and Dataflows.• Took ownership and leading a data integration team responsible for building pipelines/Jobs as a solution to automate the flow of the sales and marketing related data.• Developed pipelines based on the business\'s requirements and parallelly worked on the bugs/defects in the existing code.• Worked with various data sources, including parquet files, JSON, SQL Server data, Salesforce, and API calls.• Restructured the existing pipeline, reducing the pipeline run time by 80%.• Instituted automated monitoring solutions using Azure Monitor and Application Insights, slashing incident response times by 50% and bolstering system reliability.• Utilized Azure DevOps for Work items, Tasks, and authoring deployments on various environments.Built custom solutions in Azure Synapse working with sources of data API, Flat files, databases.

Education

• A. C. Patil College of Engineering Navi Mumbai-410 210

  Bachelor of Engineering (BE), Computer Engineering

• Dublin City University

  Master of Science - MS, Computing (Data Analytics)

• Mohindar Singh Kabal Singh English High School

  Secondary Education

  2002 — 2012

• K M Agrawal Junior College

  Higher Education/Higher Education Administration

  2012 — 2014

Skills

• Management
• Microsoft Excel
• Microsoft Word
• C++
• Microsoft Powerpoint
• Leadership
• Video Games
• Kali Linux
• Php
• Java
• Mysql
• Windows
• Microsoft Office