Skip to content

Lavanya Karicheti

Data Analyst • Delaware, USA • l****************@gmail.com • +13******206 • drivetube.ai/•••••

Professional Summary

Data Analyst with 3+ years of experience collecting, analyzing, and interpreting large datasets to deliver actionable business insights for financial services. Skilled in SQL-driven validation and reconciliation, Advanced Excel, Power BI and Tableau reporting, KPI dashboard design, and collaboration with compliance and risk teams to improve data quality and operational outcomes.

Technical Skills

Programming Language: SQL
Databases: Views
Testing & QA: User Acceptance Testing
Data Warehousing: Star Schema,Snowflake Schema,Data Modeling
Data Analysis & Visualization: Microsoft Excel,Power BI,Tableau,Metadata and Lineage Tracking,KPI Dashboards,Business Intelligence,Trend Analysis,Forecasting,SLA Dashboards,Data Sourcing Strategies,Quantitative Data Interpretation,Qualitative Data Interpretation
Data Integration & ETL: Data Validation
Compliance & Governance: Data Quality,Data Governance
Project Management & Collaboration: Google Workspace,Gap Analysis,Jira,Confluence,Agile,Kanban,Stakeholder Reporting
Process Modeling & Documentation: Process Mapping
Clinical Data Management: Data Reconciliation
Quality Assurance & Compliance: Root Cause Analysis
Financial Planning & Analysis (FP&A): Variance Analysis,Cost-Benefit Analysis

Work Experience

OneMain Financial
Remote, USA
Data Analyst / Business Analyst
Mar 2024 – Present
Worked in consumer lending and payments operations supporting Single Customer View and transaction reporting for a U.S. consumer finance firm.
Tech Stack: SQL, Power BI, Excel, Data Validation, Data Lineage
  • Designed and deployed interactive Power BI dashboards tracking delinquency, collection efficiency, and portfolio performance; dashboards informed leadership decisions and contributed to a 15% improvement in collection efficiency.
  • Authored complex SQL validation and reconciliation queries across SCV and payment transaction systems to identify data availability gaps and define preferred data sourcing approaches for reporting pipelines.
  • Managed merging and reconciliation of large Excel datasets (loan disbursement, repayment, portfolio records) using advanced formulas and macros to maintain data integrity across reporting systems.
  • Led root cause analysis on payment processing exceptions and data defects, implemented corrective logic and process changes that reduced transaction failure rates by 12% during high-volume cycles.
  • Collaborated with compliance, credit risk, and technology teams to validate datasets for KYC/AML and audit reporting; documented data lineage and controls, improving audit readiness by 20%.
  • Prepared and presented executive-level reports and stakeholder briefings translating analytical findings into prioritized actions for operations and product teams, improving cross-functional decision making.
HDFC Bank
Remote, India
Data Analyst / Business Analyst
Aug 2022 – Jul 2023
Supported retail banking analytics and regulatory reporting by analyzing customer transactions and validating loan data for a major Indian retail bank.
Tech Stack: SQL, Tableau, Excel, Data Governance, Data Validation
  • Analyzed customer transaction and payment datasets using SQL and Tableau to identify behavioral trends and build demand forecasting dashboards for retail banking segments.
  • Executed data validation and reconciliation between core banking and reporting systems for loan disbursement and repayment records, reducing data discrepancies by 15%.
  • Developed Excel-based KPI and SLA tracking reports, merging large files and automating key calculations to enable performance monitoring and improve SLA adherence by 14%.
  • Supported regulatory data reporting (KYC/AML) by gathering requirements, validating datasets, and defining data sourcing strategies to ensure compliance and reporting accuracy.
  • Performed gap analysis and data quality checks to identify reporting inefficiencies; recommended automation and source corrections that reduced manual correction effort and improved data accuracy.
  • Presented data analysis results and trend reports to management and stakeholders, translating complex datasets into concise, actionable summaries used to inform product and operations changes.

Education

University of New Haven
Master of Science — Business Analytics • West Haven, CT, USA • Aug 2023 – Dec 2024
Jawaharlal Nehru Technological University
Bachelor of Engineering • India • Aug 2019 – Jul 2023

Achievements

  • Reduced loan approval turnaround time by 18%: Performed SQL-driven process analysis and recommended workflow improvements that shortened loan approval cycles by 18%.
  • Improved data integrity across lending and payment systems: Implemented systematic SQL validation, reconciliation queries, and data quality checks to strengthen reporting accuracy.
  • Decreased transaction failure rates by 12%: Conducted root cause analysis on data exceptions and implemented resolution workflows, reducing failures during operational cycles.
  • Reduced audit findings by 20%: Documented data lineage, control processes, and compliance reporting datasets to improve audit readiness and reduce findings.

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