Aarohi Gupta

About Aarohi Gupta

A go-getter who gets the job done. I take ownership, drive solution delivery, and bring energy to solving complex data challenges with practical, efficient approaches.I started my career in the oil & gas industry, transitioning from a petroleum engineering graduate into a data-driven professional focused on data migration, ETL processes, and automation. Over the past 4 years, I’ve delivered on critical projects—migrating data to OSDU, building and leading ETL workflows, and automating data quality checks using Python.My day-to-day work involves cleaning and transforming large datasets, writing Python scripts (Pandas, Regex), managing SQL databases (SSMS), and testing APIs with Postman. I’m especially passionate about optimizing data pipelines, improving data quality, and acting as the bridge between technical teams and business stakeholders.Always learning, always adapting—I’m committed to making data more accessible, reliable, and actionable.Key Skills: • Data Migration (OSDU)| Data Quality & Cleaning | ETL Development • Python (Pandas, Regex, Tkinter)| SQL & SSMS | API Testing (Postman) • Data Automation | Governance | Process Optimization • Technical Documentation (Confluence)| Cross-functional Collaboration

Experience

1. Engineer Process Data

   Shell

   Jul 2023 — Present · Chennai, IN

   Key Responsibilities & Achievements• Led data engineering efforts for a legacy reservoir benchmarking data platform comprising 460+ stored procedures and ~500 tables/views, leveraging AI-assisted analysis to produce structured documentation that improved system maintainability and knowledge transfer.• Enhanced ETL pipelines supporting quarterly reservoir data refreshes by modifying mapping tables, optimizing stored procedures, and creating database views to improve aggregation and reporting accuracy.• Managed SQL Server database replication and refresh workflows, ensuring data consistency across environments during periodic ETL cycles.• Delivered a production-ready internal application in 6 weeks, pivoting from PowerApps to a Python-based web application and packaging it into a Windows executable using PyInstaller to bypass infrastructure deployment constraints; leveraged AI-assisted development tools to accelerate implementation.• Built a proof-of-concept metadata extraction workflow for contract documents, demonstrating how AI tools can interpret unstructured legal text to identify governance-related data obligations.• Supported data governance initiatives by reviewing contractual entitlements and obligations, documenting access requirements, and automating spatial data clustering using Python within ArcGIS.• Contributed to OSDU-aligned data migration initiatives, implementing validation rules that achieved ~99% data quality compliance by eliminating duplicate, orphan, and inconsistent records.• Developed Python automation tools (Pandas, Regex, Tkinter) for multi-source data validation and integration, significantly reducing manual quality checks.• Performed API testing and migration troubleshooting using Postman and Dynatrace to diagnose and resolve data flow issues.

Education

• UPES

  B.tech in Applied petroleum engineering with specialisation in upstream., Petroleum Engineering

  2016 — 2020