Syed Umair Hasan

Senior Data Engineer @ Data Science Dojo | Microsoft Azure x10

Karāchi, Sindh, Pakistan

About

As a certified Azure Data Engineer at Data Science Dojo, I specialize in creating efficient, scalable, and user-friendly data solutions. In my recent project with a major pharmaceutical company, I designed robust Azure Synapse pipelines that efficiently populate Power BI views for their financial data, significantly enhancing automation and data-driven decision-making. My proficiency in Python and data science allows me to develop impactful demos showcasing the capabilities of our technology on our website. Certified as an Azure Cloud Solutions Architect, my primary focus is currently on Azure Data Engineering. While I am yet to delve into cloud solutions architecture, I am excited to explore this area further, leveraging my skills to design and implement innovative, impactful cloud-based solutions. I am particularly drawn to UI-based platforms facilitating streamlined development, including Azure Synapse Analytics, Logic Apps, Power Automate, Azure ML, Azure Form Recognizer, and Power BI—areas that align with my interests and strengths. Beyond work, I find enjoyment in playing sports like soccer and cricket. I firmly believe in maintaining a balance between work and social life for sustained success. My ultimate goal is to contribute to something greater, whether it involves making a positive impact or continually improving myself.

Experience

  • Data Science Dojo (Redmond, Washington, United States · Remote)
    • Senior Data Engineer
      Jul 2024 - Present · 2 yrs 1 mo

    • Data Engineer
      Jan 2023 - Aug 2024 · 1 yr 8 mos

      Synapse Data Modernization for a Big Pharmaceutical Company - Structured Synapse artifacts and created a hierarchy of blobs. (Azure Synapse, Azure Blob Storage). - Migrated pipelines from dedicated SQL pool to serverless SQL pool. (Azure Synapse). - Parameterized pipelines and set up triggers. (Azure Synapse) - Created a pipeline to dynamically rename SAP column names. (Azure Synapse) - Automated various tasks previously done manually. (Azure Synapse) - Provided continuous support and regular maintenance for Synapse pipelines across different sites. (Azure Synapse) - Migrated and validated Synapse artifacts to other environments using existing architecture setup on - Azure DevOps by the infrastructure team. (Azure DevOps) - Collaborated with stakeholders from both SAP and LIMS teams to gather requirements and ensure the integration solution (logic apps) aligned with their needs. (Azure Logic Apps) - Implemented Azure Logic Apps to facilitate API integration between SAP and LIMS. (Azure Logic Apps) - Configured the integration engine (logic apps) to ensure reliable and secure data exchange between the two systems. (Azure Logic Apps) - Defined and implemented the necessary data transformation and mapping rules to ensure compatibility and consistency of data during the integration process. (Azure Logic Apps) - Monitored the API integration process to ensure smooth functioning and timely identification of potential issues. (Azure Monitor) - Conducted one-to-one knowledge transfer/trainings. (Azure Logic Apps, Azure Synapse). - Performed big data transformation using Synapse Spark notebooks. (Azure Synapse). - Extracted PDF content using Azure Document Intelligence and SynapseML. (Azure Document Intelligence). Company's Product: Ejento - Worked on indexing of email content and attachments via Azure Logic Apps and Azure Function Apps - Convert Azure Function to Azure Durable Functions

    • Associate Data Engineer
      Sep 2022 - Dec 2022 · 4 mos

      Synapse Data Modernization for a Big Pharmaceutical Company - Gathered client requirements for a data analytics modernization project for a major pharmaceutical company. - Ingested data from disparate sources, including SAP HANA, SAP ECC, flat files, and file shares into Blob storage. (Azure Synapse) - Worked with the internal Cambrex team to understand data definitions and calculations for uncleaned data. - Performed data cleaning on incoming SAP data. (Azure Synapse) - Converted language and currency data as needed. (Azure Synapse) - Updated and optimized six data pipelines. (Azure Synapse) - Created an automated process for periodically moving data from a customer storage blob to Azure Synapse and registering that data. (Azure Synapse) - Designed star schema. (Azure Synapse) - Advised the customer on their data warehouse setup. (Azure Synapse) - Set up or modified the data warehouse based on partner recommendations and customer approval. (Azure Synapse) - Delivered output data from Synapse Pipeline into a data warehouse. (Azure Synapse) - Advised the customer on data transformations, calculations, formulas, and processes as needed. Retrieval Augmented Generation (RAG) LLM application for an Insurace Company - Prompt Engineering - Fine Tuning of results via Data Augmentation - Indexing of data in Azure AI Search - Use of langchain and OpenAI to create an agent on company's structured data - Utilization of different chunking and retrieval strategies - Deploy flask app on Azure Web Apps

  • Autonomous Vehicle Intern at Smart City Lab - NCAI, NED UET
    Nov 2020 - Mar 2021 · 5 mos

    We developed the cheapest Self Driving Toy Car for training of next batch of students. Technology and Hardware: - Python - OpenCV - IpCam - RC Toy Car - L298N Motor Driver - NODEMCU ESP8266 - BATTERY - MOBILE CAMERA

  • Artificial Intelligence Club (Seasonal · 1 yr 11 mos)
    • Technical Team Member
      Jan 2020 - Nov 2020 · 11 mos

    • Web Developer
      Jan 2019 - Dec 2019 · 1 yr

      Developed website for AI CLUB using wordpress

  • Freelance at Fiverr
    Jan 2020 - May 2020 · 5 mos

    Worked as a Data Scientist

  • Web Developer at Interns Pakistan
    Jul 2018 - Sep 2018 · 3 mos

    During my period of Internship I learned: - HTML - CSS - JS - PHP - WORDPRESS