Mani Penmathsa

Mani Penmathsa

Senior Data Engineer & AI Practitioner

Senior Data Engineer & AI practitioner with 7+ years delivering scalable ETL pipelines, Cloud data architecture, and ML-powered analytics at Fortune 500 financial institutions. Currently building AI MCP Servers and Agents using LLMs.

Feb 2023 – Present

Data Engineer

Vanguard

  • Architecting an AI-powered MCP server for enterprise SQL optimization via natural language, projected to cut manual query-development time by 30%+. Built and optimized production ETL pipelines on AWS Glue, cutting operational costs by ~40%.
  • Delivered reusable data blocks powering a hyperPersonalization ML model and Tableau dashboards for the Complaints Analytics team, driving measurable gains in client revenue and experience.
Feb 2022 – Feb 2023

Senior Data Specialist

Vanguard

  • Architected a centralized Tableau Hub integrating client behavioral, financial (AUM), and multi-channel data — adopted org-wide, dramatically reducing time-to-insight for analysts.
  • Delivered NPS/CSAT deep-dives and time-series analyses to senior leadership, directly informing CX improvement roadmaps.
May 2021 – Feb 2022

Data Scientist

Bank of America

  • Built an ML NLP model to classify Zelle payment memo lines for risk modeling, and automated data quality breach-reporting pipelines in Python integrated with Tableau.
  • Engineered the Client Financial Health Analytics dashboard used across Risk Analytics teams to analyze and predict consumer risk at scale.
Jan 2019 – May 2021

Financial Data Analyst

Wells Fargo

  • Automated data loading for financial forecasting models (RLAP/RLEN) via Python and SQL, eliminating manual processes and improving accuracy.
  • Led Tableau adoption across the analytics team significantly improving reporting speed and operational compliance.
Jan 2019 – May 2020

Master of Science — Data Science & Business Analytics

University of North Carolina at Charlotte (UNCC)

Aug 2014 – May 2018

Bachelor of Science — Electrical Engineering

Illinois Institute of Technology, Chicago

Tech Stack

PythonSQLPySparkSparkAWS GlueAWS EMRHadoopHiveImpalaTableauRVBAPowerShellGit / GitHubBitbucketJupyterAnacondaMySQLTeradataOracleSASVisual Studio

AI & LLM Tools

Claude CodeMCP ImplementationGitHub CopilotChatGPTGeminiLLM AgentsPrompt Engineering

Certifications

AWS Certified AI PractitionerAWS Certified Data EngineerAWS Certified Cloud Practitioner