Skip to content

MADHU THOTA

Operations Analyst • Springfield, MA • drivetube.ai/•••••

Professional Summary

Operations Analyst with 3+ years of experience supporting operational performance, process improvement, and supply chain analytics in banking and cloud-technology environments. Proficient in SQL, Advanced Excel (Power Query), Power BI and Tableau for building KPI-driven dashboards and automating recurring reporting. Experienced with inventory planning, demand forecasting, procurement coordination, and capacity tracking using SAP MM and Oracle ERP data extracts. Applied Lean Six Sigma (DMAIC) methods and root-cause analysis to reduce bottlenecks and improve ticket and workflow lifecycles. Delivered executive reporting and interactive visualizations that informed risk controls and resource-allocation decisions across cross-functional stakeholders. Adept at designing data validation routines, improving data integrity, and standardizing workflows to increase reporting accuracy and operational visibility.

Technical Skills

Programming Language: SQL
Databases: Oracle
Testing & QA: Audit Support
Data Analysis & Visualization: Power Query,Power BI,Tableau,Inventory Planning
Data Integration & ETL: Data Validation
Supply Chain Management: Lean Six Sigma,DMAIC,Procurement,Demand Forecasting,SAP MM
Process Modeling & Documentation: Process Mapping
Manufacturing & Quality: Pp

Work Experience

JPMorgan Chase & Co. (JPMC)
Springfield, MA
Operation Analyst Intern
Jan 2026 – May 2026
Supported enterprise-wide operational intelligence and control monitoring for banking operations, delivering analytics, dashboards, and governance support to operations and compliance teams.
Tech Stack: SQL, Excel, Power Query, Power BI
  • Delivered the Enterprise Operations Intelligence project by extracting and transforming transaction datasets using SQL and Advanced Excel to enable cross-team operational monitoring.
  • Analyzed transaction and processing flows to identify data exceptions and process gaps; recommended workflow changes that improved turnaround times by 22%.
  • Developed interactive Power BI dashboards and KPI reports that visualized service-level trends and operational risk indicators, reducing manual report compilation.
  • Automated recurring data preparation steps in Excel using Power Query and advanced formulas, standardizing inputs and improving reporting accuracy.
  • Partnered with compliance and process owners to design control-monitoring workflows and document findings for audit support and regulatory adherence.
  • Designed validation routines and exception-tracking processes to strengthen data integrity and reduce downstream processing errors.
VMware
Springfield, MA
Operation Analyst
Sep 2021 – Jul 2024
Supported cloud infrastructure operations and asset/inventory management for technology operations teams, focusing on performance optimization, reporting, and demand/capacity planning.
Tech Stack: SQL, Excel, Power BI, Tableau, SAP MM
  • Backed Cloud Operations Performance Optimization by maintaining asset and inventory records in SAP MM and coordinating procurement and vendor fulfillment across business units.
  • Analyzed operational datasets with SQL and Advanced Excel to identify process gaps and implemented standardized reporting templates that reduced report preparation time by 20%.
  • Developed Power BI dashboards to track workload trends and capacity metrics, increasing visibility for infrastructure managers and guiding resource allocation.
  • Built Tableau reports and executive summaries to present KPI trends and operational insights used in strategic planning and operational reviews.
  • Maintained demand-planning and capacity-tracking databases to support resource-allocation decisions and improve forecast accuracy for support teams.
  • Performed root cause analysis using Lean Six Sigma (DMAIC), documented corrective actions, and drove process improvements to shorten ticket lifecycles.
  • Established data-quality checks and audit-support procedures to ensure integrity of operational datasets and compliance with governance policies.

Projects

Inventory Optimization & Stock Replenishment Dashboard
Tools Used: Excel, Power Query, Power BI, Inventory Planning, Demand Forecasting, EOQ Modeling, ABC Segmentation
  • Built an Excel and Power BI solution to analyze inventory levels, reorder points, and stock movement trends across multiple product categories to support replenishment decisions.
  • Developed automated KPI tracking for inventory turnover, stock availability, and replenishment planning to support data-driven forecasting and performance monitoring.
  • Applied Power Query to automate data cleaning and consolidation across multiple source files, then applied EOQ modeling, ABC segmentation, and safety-stock calculations to optimize reorder points.
  • Delivered executive-level replenishment reports with drill-down filters by category and supplier, improving forecast accuracy and replenishment cycle decision-making.
Customer Service Operations Analytics
Tools Used: SQL, Tableau, Root Cause Analysis, KPI Development, Performance Tracking
  • Analyzed service-request trends, resolution times, and workload using Tableau dashboards to support workforce planning and SLA monitoring.
  • Performed Pareto and root-cause analysis on ticket categories using SQL to identify top drivers of resolution delays and prioritize improvement efforts.
  • Built dashboards tracking FCR, AHT, SLA compliance, and CSAT to align staffing decisions with peak ticket volumes and raise service-level compliance.

Education

Western New England University
Master of Science in Business Analytics • Springfield, MA • Aug 2024 – May 2026

Certifications

Microsoft Power BI (PL-300) — Microsoft
Microsoft Fabric Analytics (DP-600) — Microsoft
Lean Six Sigma Green Belt

Powered by Drivetube · Create your own profile at drivetube.ai

Everything on Drivetube

Six products, two of them free forever. Start wherever you are.

Read the docs →
  • Your free digital resume

    at drivetube.ai/in/your-name: one true standard resume with a Hiring Snapshot (visa status, expected salary, notice period, work preference, relocation), an ATS-ready PDF download and a single shareable link. Free forever; interview requests come from verified employers and your contact details stay masked until you accept.

    Documentation
  • Verified jobs, posted in the last 3 days

    verified openings crawled ATS-by-ATS from 160,000+ real company career pages across 50+ ATS platforms. Shows the true posting date from the source ATS — not when a listing was indexed — and deletes every general listing 3 days after it was actually posted. No ghost jobs, no ad-sponsored listings, no staffing reposts, no account needed.

    Documentation
  • Written by senior career writers

    human-written, ATS-optimised resumes by senior career writers, from ₹499.99 / $25.99. Available in every country, written to the destination country's own standard — a US resume, UK CV, German Lebenslauf and Indian resume are genuinely different documents. A paid service, separate from the free Drivetube Profile.

    Documentation
  • Drivetube OneFrom $39.99 / 3 mo

    Daily matched jobs, tailored resumes, or we apply for you

    Drivetube's paid service. Community sends daily Jobsheets of fresh jobs matched to your profile on WhatsApp and email, with the Drivetube Community ($39.99 for 3 months or $69.99 for 6 months; ₹999 or ₹1,899 in India). Jobhunt is one-time application credits with Community included: one credit tailors one resume and its cover letter (100 for $99 with 3 months of Community, 250 for $199 with 6 months). Let Us Apply is an add-on to Jobhunt: a human expert applies 250 times for you on your credits ($0.60 each, $150). Everything lives on one dashboard at drivetube.ai/drivetubeone.

    Documentation
  • For employers — no job postings, no applications

    hiring with no job postings and no applications. Paste your real job description and AI matches it against candidates' true standard resumes, returning ranked candidates with a match %, matched and missing skills and written reasoning. Free tier included; employers pay, candidates never do.

    Documentation
  • Documentation

    every product explained in full, with feature-by-feature comparisons against the job boards, AI apply tools, resume services and hiring platforms people actually use.

  • Playbooks

    tactical job-search guides. Each post is one named tactic with the situation it applies to, the exact steps, a copy-paste message and honest failure modes. Free, no account.

The job board covers the United States, India, United Kingdom, Canada, Europe and Australia, and Resume Writing Services are available in every country.

Pricing is identical on the web, iOS and Android — no app-store markup. Monthly Community membership is purchased in the iOS app only; the website sells annual plans. The Android app has no in-app purchase, so Android members subscribe on drivetube.ai and then sign in to the app with full access. Membership follows your account, not your device.