Paras Chugh

About Paras Chugh

Strong software engineering professional currently working as a Specialist Programmer - L2 (Data Engineering) at Infosys for a Major US Tech Client. Having 3.5+ years of extensive experience in Azure Data Engineering Stack.Skills - Apache Spark, Azure Synapse Analytics, Azure Databricks, Azure Data Factory, Azure Data Lake Storage Gen2, Data Warehousing, Data System Design, Data Design Patterns in Python, ETL, Microsoft Fabric, Azure Data Explorer, Azure DevOps, CI/CD, Microsoft PowerBI, Cosmos Scope Scripts, SSMS, Socket Programming, Data Structures & Algorithms, OOPs, DBMS, GitLanguages - C++, Scala, SQL, PySpark, Python, JavaAcademics - B.Tech in Computer Science & Engineering from MAIT, GGSIPU, Delhi (8.82/10 CGPA)Highly skilled in ETL, Problem Solving (500+ problems solved over various platforms), Leading small teams.Published two Research Papers, first on \'Decentralized Crowdfunding using Blockchain\' in IJPREMS, and second on \'Shell Shoveling Using Socket Programming\' in Internship experience during college - Problem Setter at TechCurator, Subject Matter Expert at Mercer Mettl, Gurgaon. Currently open to SDE/Data Engineering roles or any business opportunities.Reach a••••••••@gmail.comHave a marvelous day!

Experience

1. Specialist Programmer

   Infosys

   Aug 2022 — Present · Hyderabad, IN

   Engineering high-performance, scalable Azure Data Engineering solutions for a major US tech client leveraging Azure Synapse Analytics, ADB, and ADF.• Developing and deploying ETL pipelines using Spark SQL, Scala, and PySpark, processing 1M+ records daily with a config-driven approach using Spark.• Implementing advanced data transformations (joins, pivots, reduce, partitions, CTEs, SCD, window functions, ranking, regex, incremental loads, aggregations) to enhance data quality and business readiness, achieving a 40% performance optimization.• Creating interactive dashboards with Power BI to drive data-informed decision-making.• Led the migration to Microsoft Fabric, orchestrating the transition of front-end logic from datasets and views to back-end code, including all the calculated columns and MQuery logic, yielding a remarkable 95% reduction in the dataset refresh time, becoming the first team in the company to achieve this.• Migrated Excel-based ingestion to an API, secured tokens via Azure Key Vault, implemented robust paginated fetching with 5-day backfill and delta merge for reliable, incremental data processing, reducing notebook runtime by 80%.• Created Cosmos Scope scripts to onboard data from 7 new source tables, configured Scope ingestions, and built transformation notebooks to deliver clean, structured data to downstream users.• Migrated a highly critical Dimension to a new shared source, impacting 50+ Facts across 3 DataMarts and 5 Cubes. Developed scripts to: identify usage of the Dimension Key in tables; overwrite the key in incremental-load entities; validate the key differences after overwriting. Designed a dual-stage transformation process (pre/post P1) to minimize upstream changes by 80% while eliminating redundant columns downstream.• Participated in sprint deployment and monitoring activities using CI/CD workflows in Azure DevOps, resolved production pipeline issues, ensuring 100% data accuracy, integrity, and availability.

Education

• Adarsh Jain Dharmic Shiksha Sadan, Delhi

  12th CBSE

  2017 — 2018

• Maharaja Agrasen Institute Of Technology

  Bachelor of Technology - BTech

  2018 — 2022

• Holy Cross School, New Delhi

  10th CBSE

  2015 — 2016