May 2024 – May 2025 · 1 yr · Arlington, Texas, United States · On-site

• Assisted in migration of MySQL and PostgreSQL databases to AWS by executing validation scripts and backups efforts, achieving 100% data integrity.
• Improved academic database query performance by 25% by optimizing SQL queries and indexing, enabling faster operational analytics.
• Performed ad-hoc queries for analytics to support institutional reporting, troubleshooting tasks and data-informed strategic planning.
• Assisted to monitor and document performance metrics of academic databases, assisting in troubleshooting and operational continuity.
• Created and updated reports and dashboards under supervision, visualizing key operational metrics for real-time decision-making.

Aug 2021 – Dec 2023 · 2 yrs 4 mos

• Optimized query performance by 25% by developing and tuning Google BigQuery queries, leveraging schema design and partitioning strategies on large-scale retail data.
• Engineered and optimized petabyte-scale data pipelines using Pyspark, Python, SQL, and Google BigQuery, improving reporting performance by 25%.
• Designed and automated ETL workflows and reporting, reducing manual effort by 30+ hours/month while ensuring 99% data accuracy in reports.
• Created and delivered 30+ dynamic logistic reports covering revenue, sales, and marketing and other metrics, enabling real-time visibility for executives and driving 20% of data-backed decisions.
• Partnered with data scientists, analysts, product stakeholders and other cross functional teams to gather requirements and build scalable pipelines that supported 15+ analytics use cases across business functions.
• Led daily Agile scrum meetings, managed JIRA tickets where resolved 25% tickets and coordinated and documented tasks/issues using Confluence for streamlined feature releases.
• Implemented robust data validation, quality checks, and monitoring for data workflows; performed root cause analysis on pipeline failures across 10+ incidents, improving workflow reliability by 20%.
• Researched and implemented feature enhancements in Business Intelligence reporting tools, contributing to future proof architecture aligned with cost optimization and scalability goals.
• Strengthened data governance by improving metadata management and data quality validation processes across internal systems.

Aug 2021 – Dec 2023 · 2 yrs 4 mos · Hybrid

• At Dentsu, supported The Home Depot for maintaining and building scalable data pipelines and reports driving impactful data driven decisions.