Shubham Tripathi

About Shubham Tripathi

Senior data professional with 10+ years of experience designing, automating, and optimizing data systems that support business decision-making across financial services, banking, and technology domains. My work focuses on building scalable data pipelines, workflow automation solutions, and transforming complex datasets into accurate, actionable insights.I specialize in end-to-end data lifecycle management — including data ingestion, transformation, modeling, validation, and reporting. I have hands-on experience with Alteryx Designer for workflow automation, advanced SQL development, and VBA-driven Excel automation, enabling streamlined reporting and reduced manual intervention across finance and compliance teams.Alongside engineering expertise, I bring strong analytical capabilities including KPI design, variance analysis, trend analysis, reconciliation frameworks, and data quality validation. I have worked extensively with large transactional datasets (OLTP/OLAP), optimizing complex SQL queries and designing analytics-ready datasets for downstream reporting.Across roles at PIMCO, Flagstar Bank, and Voya Financial, I have delivered automation solutions that reduced manual reporting efforts, improved data accuracy, and enhanced operational efficiency. I collaborate closely with business stakeholders, compliance teams, and technical leadership to ensure scalable, auditable, and high-quality data solutions.From a technical standpoint, my experience spans Alteryx, SQL, VBA, Excel automation, Python, Azure Data Factory, Databricks, Power BI, and dimensional data modeling techniques.I hold Microsoft Certified: Power BI Data Analyst Associate and AWS Certified Solutions Architect – Associate credentials.

Experience

1. Sr Data Engineer Analyst

   PIMCO

   Mar 2025 — Present · NY, US

Education

• Dr. B R Ambedkar National Institute of Technology, Jalandhar ( PUNJAB)

  Bachelor of Technology - BTech

• W. P. Carey School of Business – Arizona State University

  Master's Degree

  2023