Ujjwal Gupta

About Ujjwal Gupta

Hello everyone! I\'m Ujjwal, a recent graduate with a Master\'s in Information Systems from Northeastern University, specializing in Data Engineering and Business Intelligence. With 3.5 years of experience as data engineer, I am passionate about leveraging the power of data and technology to solve complex challenges.As a Data Engineer at McKinsey & Company, I spearheaded critical projects focused on the developing, automating, and migration of data pipelines. This involved data migration of proprietary / client assets, surpassing billions of records, from on-prem systems to Snowflake cloud data warehouse. Designing and optimization of Enterprise Data Warehouses, leading to substantial cost savings and efficiency enhancements, and creating impactful real-time visualizations and dashboards. I specialize in modelling data warehouses, data lake and architectures, alongside the development and optimization of pivotal data pipelines for data-driven decision-making. I excel in automation of ETL processes, implementation of enterprise data warehouse, data integration & migration from diverse sources. I thrive in collaborative environments, working with cross-functional teams to ensure that data solutions align with business objectives, delivering efficient and scalable data solutions. I have a keen eye for optimizing data solutions to enhance performance and efficiency while maintaining a strong focus on data quality assessment and validation, resulting in accurate and reliable data assets.Additionally, I am committed to documenting data engineering processes, fostering transparency and insight into pipeline architecture, data flow, and transformation logic.Let\'s connect and explore how I can contribute to your organization\'s data-driven success as a Data Engineer TECHNICAL SKILLS- Languages – Python, SQL, R, Java- Database – MySQL, PostgreSQL, Oracle ADW, MongoDB (NoSQL), Microsoft SQL Server (SSMS)- Cloud Services – Snowflake, Azure (azure data factory, Azure Synapse, ADLS, Databricks), AWS (S3, Athena, Redshift, Glue), GCP BigQuery- Data Integration (ETL) Tools – Talend, Alteryx, Knime, Tableau Prep, Informatica, Airflow- Data Visualization – Tableau, Power BI, Looker - Big Data – Apache Spark (PySpark, Spark SQL), Hive (HiveQL), HDFS, Hadoop, mapReduce, Sqoop- Python Libraries – Pandas, NumPy, SciPy, Scikit-learn, Matplotlib, Seaborn, NLTK, Text2emotion- Tools – DBT, Dbeaver, Azure Data Studio, Domo, ER Studio, GitHub, Jira, ServiceNow, Agile, Salesforce, Confluence, MS Excel- IDE’s – VS Code, Jupyter

Experience

1. Senior Data Engineer

   Fidelity Investments

   Mar 2025 — Present · Dallas-Fort Worth, TX, US

   Part of Workplace Investing | Stock Plan Services

Education

• Northeastern University

  Master of Science - MS, Information System

• Visvesvaraya Technological University

  Bachelor of Engineering (B.E.), Information Technology