Shiva Krishna Arjula
VA
Summary
Senior Data Analyst with 8+ years of experience in banking and financial data analytics, supporting enterprise analytics initiatives for large financial organizations. Strong expertise in Snowflake, SQL, Python, Spark, AWS, Tableau, and Amazon QuickSight, with a focus on financial reporting, data validation, reconciliation, reporting automation, and enterprise data integration and migration. Progressed from hands-on execution roles to a trusted Subject Matter Expert (SME) supporting high-visibility, business-critical initiatives, delivering accurate, audit-ready data and measurable efficiency improvements.
Overview
9
9
years of professional experience
Work History
Senior Data Analyst | SME
Capital One
Richmond, VA
07.2023 - Current
- Acted as a key Subject Matter Expert (SME) supporting a large, enterprise-wide financial data integration program and high-visibility, business-critical analytics initiatives.
- Delivered financial data analytics and reporting solutions using Snowflake, SQL, Python, Spark, Tableau, and Amazon QuickSight to support enterprise banking and financial reporting use cases.
- Supported accounting and finance teams by providing accurate, reconciled, and audit-ready datasets, enabling smoother month-end close and reducing manual follow-ups.
- Designed and implemented PySpark and SQL-based data processing logic to streamline analytics workflows, improve performance, and enhance scalability across large datasets.
- Built reusable Spark / PySpark functions and templates widely referenced by team members as examples, accelerating development cycles and reducing rework.
- Conducted in-depth research, impact analysis, and proof-of-concept (POC) development to evaluate enterprise integration and migration approaches and inform technical decisions.
- Defined and executed integration and post-migration validation strategies, identifying discrepancies early and preventing downstream rework, escalations, and reporting delays.
- Automated recurring data validation and reporting processes, reducing manual effort by 30–50% and saving an estimated 100+ analyst and accountant hours per month.
- Created dashboards and analytical views to monitor data quality, key metrics, and initiative progress, enabling stakeholder self-service and reducing ad-hoc data requests.
- Provided requirements clarification, technical inputs, and effort estimates for multiple analytics initiatives as a recognized SME.
- Frequently consulted by peers and stakeholders for Spark, PySpark, and Snowflake expertise in complex analytical and integration scenarios.
Assistant Manager – Data Analysis
Genpact (Client - Capital One)
India
02.2020 - 05.2023
- Supported enterprise banking and financial data analytics, ETL processes, and data warehouse integrity for large-scale reporting platforms.
- Performed source-to-target mapping, gap analysis, data reconciliation, and validation, ensuring accuracy and consistency across systems.
- Collaborated with business, accounting, and technical stakeholders to translate requirements into production-ready analytics solutions.
- Developed and validated complex SQL across Snowflake, Teradata, Oracle, SQL Server, and Big Data platforms.
- Designed dimensional data models to improve reporting performance and reduce development timelines.
- Reviewed analytical outputs to ensure data accuracy, quality, and consistency.
- Mentored junior analysts and supported knowledge sharing across analytics workflows.
Data Analyst
Collabera Technologies Private Limited
India
12.2018 - 01.2020
- Supported retail banking analytics using Python, SQL, Spark, SAS, and Tableau.
- Automated recurring reporting workflows using Python and Unix shell scripting, improving reliability and reducing manual effort.
- Assisted with cross-platform data migration initiatives involving Teradata, Redshift, Oracle, SQL Server, and Hadoop.
- Built Tableau dashboards to support business and product decision-making.
- Conducted data quality checks and produced process documentation.
Data Analyst Consultant
IQLOGG Inc (Client - Capital One)
Ashburn, Virginia
11.2016 - 11.2018
- Supported enterprise data integration and analytics initiatives across production platforms.
- Collaborated with business analysts on requirements gathering, testing, and validation.
- Developed Unix shell scripts to streamline data processing workflows.
- Identified data integration risks early, helping prevent reporting and production issues.
Education
Master of Science -
Pittsburg State University
Pittsburg, Kansas, KS10-2016
Skills
Analytics & Financial Data
- Banking & Financial Data Analytics
- Data Validation, Reconciliation & Controls
- Reporting Automation & Optimization
- ETL / ELT & Data Warehousing
- Enterprise Data Integration & Migration
- Data Quality & Governance
Programming & Querying
- SQL (Snowflake, Oracle, Teradata, SQL Server)
- Python, PySpark
- Unix Shell Scripting
Platforms & Tools
- Snowflake
- AWS (EC2, EMR, S3, Redshift)
- Databricks, Enterprise Model Platform (EMP)
- Tableau, Amazon QuickSight
- GitHub, Advanced Excel
Methodologies
- Agile / SDLC
- Business Intelligence & Analytics
Timeline
Senior Data Analyst | SME
Capital One
07.2023 - Current
Assistant Manager – Data Analysis
Genpact (Client - Capital One)
02.2020 - 05.2023
Data Analyst
Collabera Technologies Private Limited
12.2018 - 01.2020
Data Analyst Consultant
IQLOGG Inc (Client - Capital One)
11.2016 - 11.2018
Master of Science -
Pittsburg State University