Available — Boston, MA · Open to relocation

Turning data into
decisions. Turning
problems into solutions.

Business Analyst with deep experience in banking operations, transaction management, and operational reporting. I work where SQL, BI dashboards, and regulated workflows meet — translating high-volume data into measurable business outcomes.

Boston, MA UMass Boston · M.S. ICICI · Wipro alum
ops_console.sql
Live
-- daily reconciliation snapshot
SELECT channel, COUNT(*) AS txns,
SUM(amount) AS volume_usd
FROM payments.transactions
WHERE txn_date = CURRENT_DATE
GROUP BY channel ORDER BY volume_usd DESC;
TXNS / DAY
8,412
+3.2%
RECON RATE
99.97%
+0.04
MTTR (hrs)
1.8
-22%
30-day txn volumetrend ↗
SQL · 200K+ TXNS / MO POWER BI · TABLEAU M.S. BUSINESS ANALYTICS BANKING OPERATIONS PYTHON · R · EXCEL ROOT CAUSE ANALYSIS RECONCILIATION · UAT AWS REDSHIFT · S3 40% MANUAL EFFORT ↓ COMPLIANCE AWARE SQL · 200K+ TXNS / MO POWER BI · TABLEAU M.S. BUSINESS ANALYTICS BANKING OPERATIONS PYTHON · R · EXCEL ROOT CAUSE ANALYSIS RECONCILIATION · UAT AWS REDSHIFT · S3 40% MANUAL EFFORT ↓ COMPLIANCE AWARE
01 · Recruiter dashboard

The numbers, at a glance.

KPI
200K+
Monthly Banking Transactions Analyzed
KPI
1M+
Healthcare Records Processed
KPI
100K+
Sales Records Analyzed
KPI
40%
Reduction in Manual Processing
KPI
M.S.
Business Analytics, UMass Boston
KPI
3+ yrs
Banking · Analytics · Operations
02 · About

Operations rigor. Analyst's eye.

I'm Gowrav Sai Garikapati (John) — a results-driven Business Analyst who has spent the early part of his career inside transaction-intensive, regulated environments. At ICICI Bank via Wipro, I supported payment operations covering hundreds of thousands of monthly transactions: investigating exceptions in SQL, running root cause analysis, owning reconciliation, and contributing to the controls that keep banking operations clean and auditable.

Today, as an Operations Analyst at Earthbox Enviro, I apply that same operational discipline to reporting workflows, KPI dashboards, and process improvement — helping leadership see the story behind the data and act on it faster.

I pair that operational backbone with a master's-level analytics toolkit — SQL, Power BI, Tableau, Python — to turn messy operational data into dashboards and decisions that leadership actually uses.

Business Analyst
Operations Analyst
Banking Operations
Financial Operations
Fund Services
Compliance Operations
Reporting Analyst
Data Analyst
Operations Transformation
03 · What I do

Three lanes. One operator.

Business Analysis

Requirements, root cause analysis, UAT, and stakeholder alignment — translating ambiguity into shippable decisions.

Banking & Ops Support

Transaction monitoring, reconciliation, production support, and operational controls across regulated, high-volume payment flows.

Core strength

Analytics & Reporting

SQL investigations, Power BI / Tableau dashboards, and KPI reporting that leadership actually uses to steer the business.

04 · Experience

Where the work happened.

Operations Analyst

Earthbox Enviro
Feb 2025 — Present
Boston, MA
  • Built operational reports and KPI dashboards that improved reporting visibility for leadership.
  • Analyzed business performance data to surface bottlenecks and improvement opportunities.
  • Drove data-informed decision making through documentation and stakeholder communication.
  • Supported process improvement initiatives across reporting workflows.

Business Analyst — Banking Operations & Transaction Management

Wipro · ICICI Bank
May 2021 — Jan 2023
India
  • Analyzed 200,000+ monthly banking transactions; performed SQL-based investigations and root cause analysis.
  • Reduced manual effort by ~40% through Excel automation and standardized reconciliation workflows.
  • Provided production support for payment operations, transaction monitoring, and incident management.
  • Strengthened operational controls and compliance processes across high-volume payment flows.
05 · Working process

How the work actually flows.

01

Discover

Sit with the data, the system, and the stakeholders. Map what is, before assuming what should be.

02

Investigate

SQL queries, reconciliation, and root cause analysis. Prove the problem with evidence, not anecdote.

03

Design

Dashboards, reports, controls, and process changes — each tied to a specific decision or risk.

04

Operate

Hand off with documentation, UAT, and production support so the fix sticks long after I'm gone.

06 · Featured projects

Analytics that moved a number.

Healthcare · Operations01

Healthcare Claims Analytics

SQLPythonTableau
  • Analyzed 50,000+ healthcare claims
  • Data cleaning and validation pipeline
  • Executive dashboards for trend visibility
Impact

Improved visibility into claims processing trends and cost drivers.

Commercial · BI02

Chocolate Co. Revenue Analysis

Power BIDAXPower Query
  • Processed 100,000+ sales records
  • Revenue, profitability, and customer behavior
  • Forecasting support for leadership
Impact

Sharpened management decisions through interactive dashboards.

Cloud · Scale03

Healthcare Analytics on AWS

Amazon RedshiftS3SQL
  • Analyzed 1,000,000+ healthcare records
  • Cloud-based analytics architecture
  • Query optimization for large-scale reporting
Impact

Cut reporting latency and improved data retrieval performance.

Banking · Diagnostics04

BankOps Insight (ICICI Bank)

SQLLinux CLICRON
  • Root cause analysis for transaction delays
  • Automated log extraction across banking systems
  • Diagnosed interbank latency & concurrency issues
Impact

Surfaced routing and scheduling bottlenecks behind production incidents.

Sports · Machine Learning05

Bowlmetrix

PythonScikit-learnSQLite
  • Scraped match data from ESPN Cricinfo
  • Cleaned & structured bowler performance records
  • Regression models to predict future performance
Impact

Turned raw match data into a predictive view of bowler form.

Public Sector · BI06

CrossBorder Insights

TableauTrend AnalysisStorytelling
  • Analyzed COVID-19 impact on international travel
  • Visualized a 50% decline in border crossings
  • Dashboards designed to inform policy decisions
Impact

Made a complex travel-disruption story legible at a glance.

07 · Capabilities

A stack built for ops + analytics.

Data Analytics

SQLPythonRExcelData ValidationData Reconciliation

Business Intelligence

Power BITableauKPI ReportingDashboard Development

Business Analysis

Root Cause AnalysisProcess ImprovementStakeholder MgmtDocumentationUAT TestingOperational Reporting

Banking Operations

Transaction MonitoringPayment OperationsProduction SupportReconciliationIncident ManagementCompliance AwarenessOperational Controls

Tools & Platforms

JIRAGitLinuxMicrosoft 365ERP SystemsAgile

AI Productivity

ChatGPTClaude AIGitHub CopilotPrompt Engineering
08 · What people say

Notes from the people I've worked with.

"
Gowrav approached every transaction exception with the patience of an auditor and the speed of a developer. He shipped fixes that held up under volume.
JB
Jashuva B.
Senior Manager · ICICI Bank
"
He turned a manual, error-prone reconciliation into an Excel-driven workflow that saved the team almost two days a week. Quiet, methodical, effective.
GY
Gopi Y.
Manager · Wipro
"
The dashboards Gowrav built became the meeting. We stopped arguing about numbers and started talking about decisions.
DM
David M.
Manager · Earthbox Enviro
09 · AI & continuous learning

Compounding skill with AI.

Actively learning

I treat AI as a force multiplier for analyst work.

I use Claude, ChatGPT, and Copilot daily to accelerate reporting, research, documentation, and business analysis — drafting SQL, pressure-testing assumptions, summarizing stakeholder calls, and turning rough notes into clean deliverables. The throughput gain is real, and so is the discipline of validating every output.

Claude AIChatGPTPrompt EngineeringAI ProductivityWorkflow OptimizationAI-assisted Analytics
10 · Certifications

Credentials & continued study.

2026
Anthropic
Claude 101
2026
Anthropic
AI Fluency: Framework & Foundations
2024
Coursera
Preparing Data for Analysis with Microsoft Excel
2023
IMS Proschool
Business Analytics Certification
11 · Education

Academic foundation.

Graduated Dec 2024

University of Massachusetts Boston

M.S. in Business Analytics
GPA 3.44 — Advanced analytics & decision systems
Graduated Aug 2021

Acharya Nagarjuna University

B.Tech in Mechanical Engineering
GPA 3.0 — Foundation in systems thinking
Open to opportunities

Got an operations problem? Let's talk.

Banking ops, fund services, reporting, transformation, fintech, SaaS, logistics, healthcare, retail, or manufacturing — if it involves messy data and a workflow that needs fixing, I'd love to hear about it.

12 · Contact

Let's connect.

I'm open to Business Analyst, Operations Analyst, and Reporting Analyst roles across banking, fund services, financial operations, compliance, fintech, SaaS, logistics, supply chain, healthcare operations, retail, and manufacturing. Based in Boston, MA — open to relocation and hybrid arrangements.

Operations is my home base, but I'm equally interested in analytics, process improvement, and reporting challenges in any domain.

Prefer email? Reach me directly at gowravsaigarikapati@gmail.com.