Data & Business Analyst - SQL, Python, GIS, Tableau

BHANDARIPALLI MANI KRISHNA DATA

ANALYST

Montgomery, AL • 334-***-**** • ***************@*******.*** SUMMARY

● Accumulated as a Data and Business Analyst with 5+ years of experience delivering data-driven solutions across banking, energy, technology, and GIS domains.

● Proficient in Python (Pandas, NumPy, SciPy), R (ggplot2, dplyr), and SQL (advanced queries, stored procedures, optimizations) for statistical analysis, predictive modeling, and automation of workflows.

● Skilled in designing and developing interactive dashboards using Tableau and Power BI, enabling actionable insights into KPIs, financial performance, and operational efficiency.

● Expertise in GIS and spatial analysis using ArcGIS, QGIS, and photogrammetry tools to perform topographic mapping, geocoding, and spatial data modeling for business and operational planning.

● Experienced in database management with MySQL, SQL Server, and PostgreSQL, with proven ability to implement data validation, quality checks, and governance frameworks ensuring 99%+ data accuracy.

● Strong background in business analysis and documentation (FRD, BRD, SRS), translating stakeholder requirements into system specifications and analytical solutions that improve decision-making.

● Adept at managing cross-functional projects using Agile and Waterfall methodologies, leveraging Jira, Confluence, and MS Project for workflow optimization, stakeholder engagement, and UAT coordination.

● Knowledgeable in cloud platforms AWS (S3, RDS, EC2) and Azure (Data Factory, SQL Database), integrating secure data pipelines while ensuring compliance with HIPAA and GDPR standards. PROFESSIONAL EXPERIENCE

United Health Group (Remote), USA Apr 2025 – Current Data Analyst

● Designed and optimized SQL and Python data pipelines processing multi-million-row claims and EHR datasets, enabling tracking of HEDIS and Stars quality measures and supporting targeted care-gap closure initiatives.

● Built and automated Tableau dashboards monitoring PMPM cost, readmissions, ED utilization, LOS, and denial rates, improving executive visibility into operational and financial performance by 35%.

● Developed payment integrity and anomaly detection rules across medical and pharmacy claims, contributing to improved payment accuracy and reduction of improper payments.

● Partnered with care management and clinical teams to deliver HIPAA-compliant, audit-ready datasets with complete data lineage, validation, and reconciliation controls, supporting regulatory reporting.

● Prototyped risk stratification models to identify high-risk members (readmission and chronic condition flags), accelerating care management prioritization and improving intervention effectiveness. JPMorgan Chase, AL Jul 2024 – Mar 2025

Data Analyst

● Analyzed 1.2M+ customer and transaction records using advanced SQL (CTEs, window functions, performance tuning) and Python (Pandas, NumPy) to uncover spending patterns, churn indicators, and cross-sell opportunities, contributing to 8–12% lift in campaign targeting effectiveness.

● Built predictive and descriptive analytics models in Python and R to assess loan performance, delinquency probability, and portfolio risk, supporting credit decisions across $500M+ in managed assets.

● Designed and maintained Tableau dashboards tracking loan balances, default rates, approval ratios, revenue trends, and risk exposure, improving executive decision-making speed by 30%.

● Automated data ingestion, cleansing, and feature engineering pipelines, reducing manual data preparation effort by 20+ hours per week and improving reporting refresh cycles by 40%.

● Conducted trend, variance, cohort, and segmentation analysis across multi-quarter datasets, identifying early risk signals that reduced unexpected delinquency spikes by 10%.

● Implemented data quality profiling, reconciliation, and exception handling rules in SQL Server, increasing regulatory and executive report accuracy to 99.5%+.

● Partnered with marketing and product teams to translate insights into data-driven campaign strategies, improving customer engagement rates by 9% across priority segments.

● Applied geospatial and branch-level analytics using GIS tools to evaluate regional risk concentration and performance across 300+ branch locations, informing branch optimization and resource allocation.

● Integrated AWS S3-based secure storage into analytics workflows, enabling scalable access to 10+ TB of historical financial data while meeting internal security and compliance standards.

● Produced ad-hoc analytical reports, KPI scorecards, and executive summaries, enabling leadership to monitor portfolio health and operational risk in near real time.

● Supported audit, risk, and compliance initiatives by delivering traceable, well-documented datasets aligned with internal controls and regulatory expectations.

● Collaborated within Agile sprint cycles, managing analytics deliverables in Jira and partnering with engineering teams to operationalize insights into production reporting.

Hexaware Technologies, India Dec 2018– Aug 2022

Data Analyst

● Analyzed and validated 200+ weekly geospatial and operational datasets using advanced SQL and Excel, identifying anomalies and inconsistencies and maintaining 98–99% production data accuracy.

● Conducted monthly quality audits on 30+ datasets (POI attributes, routing accuracy, location metadata), driving 12% improvement in data precision across high-impact regions.

● Designed and implemented automated ETL validation scripts using Python (Pandas, NumPy) and SQL, reducing manual data validation effort by 40% and accelerating data release cycles.

● Performed in-depth analysis on 10,000+ geospatial data points per release, improving navigation accuracy, coverage reliability, and location- based service performance by 15%.

● Built and maintained Tableau dashboards tracking SLA adherence, defect trends, update cycle times, and accuracy KPIs, reducing reporting turnaround time by 30%.

● Executed exploratory data analysis (EDA) to identify root causes of recurring defects and data discrepancies, lowering rework and duplicate defects by 22%.

● Developed KPI scorecards (accuracy %, defect rate, cycle time, SLA compliance) used in weekly stakeholder reviews, improving transparency and accountability.

● Defined and enforced data governance standards including naming conventions, deduplication rules, referential integrity checks, and lineage documentation, improving audit readiness and data consistency.

● Implemented regex-based parsing and JSON/XML extraction scripts in Python to validate metadata and schema consistency, reducing validation errors by 18%.

● Authored standard operating procedures (SOPs) and process documentation for validation workflows, reducing new-hire onboarding time by 25%.

● Delivered 15+ technical training sessions on SQL, Python scripting, and data validation best practices, strengthening team productivity and analytical maturity.

● Collaborated with cross-functional teams to perform scenario-based spatial modeling (coverage density, traffic flow, service availability), supporting operational optimization initiatives.

● Supported A/B testing and impact analysis for new data feature rollouts, tracking adoption, error rates, and latency to inform go/no-go deployment decisions.

LTI Mindtree, India Aug 2017 – Nov 2018

Business Analyst

● Collaborated with finance stakeholders to gather, analyze, and document business requirements, creating comprehensive BRD and FRD documents for digital lending, portfolio monitoring, and regulatory reporting initiatives.

● Designed and deployed interactive Power BI dashboards to track 150+ KPIs related to loan performance, delinquency trends, and customer repayment behavior, enabling leadership to make informed credit policy decisions.

● Conducted financial gap analysis and variance tracking, identifying revenue leakages and implementing corrective frameworks that improved reporting accuracy by 18%.

● Integrated GIS tools to map branch performance across geographies, visualizing lending patterns, high-risk zones, and customer acquisition density to support branch expansion and financial inclusion strategies.

● Executed cost/benefit analyses and profitability modeling in MS Excel, optimizing budget allocation for 10+ regional units and improving cost efficiency by 12%.

● Partnered with compliance teams to ensure process documentation aligned with RBI and Basel III regulatory standards, reducing audit gaps by 20%.

● Facilitated workshops with finance, risk, and technology teams to align reporting structures, while documenting feedback in Confluence and converting requirements into actionable development tasks.

● Supported UAT and QA processes using Jira, validating financial data accuracy and reconciling 200+ data discrepancies across loan origination and collections systems.

EDUCATION

Auburn University at Montgomery, AL Aug 2022 - May 2024 Masters in Management Information System

GRIET, India Aug 2012 – May 2017

Bachelors in Electronics and Communication Engineering TECHNICAL SKILLS

Programming & Analysis Python (Pandas, NumPy, SciPy, Matplotlib, Seaborn), SQL (Advanced joins, CTEs, Window functions, Query optimization, Stored procedures), R (dplyr, ggplot2 – working knowledge), Statistical Analysis, Hypothesis Testing, Regression & Classification, Time-series Analysis, Risk & Anomaly Detection Data Visualization & BI Tableau (Calculated fields, LOD expressions, KPI dashboards), Power BI (DAX, Power Query, Data modeling), Excel (Pivot Tables, Power Query, VBA), Executive & Operational Dashboards, Self-service BI, Data Storytelling

Healthcare & Financial

Analytics

Claims & EHR Analytics, HEDIS & Stars Measures, PMPM, Readmissions, LOS, ED Utilization, Payment Integrity, Risk Stratification, Regulatory & Compliance Reporting, Portfolio & Credit Risk Analysis, Variance

& Trend Analysis

Databases & Data Platforms MySQL, SQL Server, PostgreSQL, Snowflake (querying & performance concepts), Data Modeling, ER Diagrams, Data Quality Frameworks, Metadata Management, Data Lineage & Governance Cloud & Data Engineering

(Analyst-Focused)

AWS (S3, RDS, EC2), Azure (Data Factory, Azure SQL Database), ETL / ELT Pipelines, Data Validation Automation, Batch & Incremental Loads, Secure Data Access Controls Business Analysis &

Requirements

BRD, FRD, SRS, Stakeholder Workshops, Gap Analysis, Process Mapping (As-Is / To-Be), UAT Coordination, Change Management, Agile & Waterfall SDLC GIS & Spatial Analysis ArcGIS, QGIS, Spatial Analysis, Topographic Mapping, Web Mapping, Cartography, GPS Navigation, Remote Sensing, Photogrammetry, Raster & Vector Analysis, Geocoding, Route Optimization, Site Suitability Analysis, Geodatabase Management

Visualization &

Reporting

Interactive dashboards (business KPIs, sales trends, risk management, spatial insights), Map-based reporting (supply chain, healthcare, financial datasets), GIS-integrated BI dashboards (Tableau/Power BI) Project Management &

Collaboration

Agile/Scrum, SDLC, Waterfall, Jira (task tracking), Confluence (documentation), MS Project (scheduling), MS SharePoint (workflow management), Stakeholder Workshops, UAT Coordination, Change Management

Contact this candidate