Data Analyst with Financial Analytics Expertise

Prudhviraj Karnati

+1-508-***-**** *****************.*.***@*****.*** http://www.linkedin.com/in/prudhviraj-karnati Worcester, MA PROFESSIONAL SUMMARY

Data Analyst with 3+ years of experience driving business and financial performance through data-driven insights. Skilled in SQL

(CTEs, window functions), Excel, Tableau, Power BI, and Python for EDA, funnel analysis, forecasting, and KPI reporting. Proven record of improving conversion efficiency, profitability, and operational accuracy through stakeholder partnership, automation, and dashboarding. Experienced in competitor benchmarking, reporting governance, and delivering actionable recommendations for leadership decisions.

EDUCATION

Masters in Information Technology, Clark University, Worcester, MA August 2023 – May 2025 Bachelors in Computer Science, Sri Sai Degree and PG College, India August 2018 – November 2021 PROFESSIONAL EXPERIENCE

Data Analyst - Financial June 2025 – Present

Capital One, USA

● Analyzed financial and operational datasets using SQL (joins, CTEs, window functions) and internal reporting tools to detect a 15% decline in revenue conversion, driving root-cause analysis and actions that enhanced conversion efficiency by 20%.

● Conducted market research + competitor benchmarking across 100+ financial products, using pricing and feature gap analysis to increase adoption of high-margin offerings by 15% and support product strategy decisions.

● Built and optimized KPI dashboards and reporting frameworks using Excel (Power Query, PivotTables, Lookups) and Tableau, improving visibility into profitability, cost drivers, liquidity metrics, and increasing actionable insights by 15%.

● Led stakeholder interviews, requirement gathering, and documentation (BRD/FRD) with Product, Ops, and Compliance teams, identifying inefficiencies and control gaps that improved operational accuracy and client satisfaction.

● Performed exploratory data analysis (EDA), trend analysis, and funnel analysis to measure customer drop-offs across acquisition and onboarding, converting insights into prioritized recommendations to improve conversion performance.

● Automated recurring reporting and data validation by building SQL-driven extracts, reusable Excel templates, and QA checks

(reconciliation, exception tracking), reducing manual effort and improving data quality for weekly leadership reviews. Business Strategy Analyst June 2024 – May 2025

Discover Financial Services, USA

● Analyzed tuition revenue, enrollment funnel trends, and cost drivers using Excel (Pivot Tables, Power Query, What-if Analysis) to identify profitability gaps and recommend actions that improved program profitability by 15%.

● Built and automated Power BI dashboards tracking tuition collections, enrollment conversion, retention, and HRMS operational KPIs, improving leadership visibility and enabling data-driven decisions that boosted operational efficiency.

● Partnered with business stakeholders to gather requirements, define KPIs, and document reporting logic; delivered recurring insights and variance analysis that reduced manual reporting effort and enhance accuracy of monthly performance reviews. Data Analyst September 2021 – July 2023

Deloitte, India

● Leveraged SQL to extract and analyze data from over 1 million transaction records, enhancing sales forecasting accuracy by 15% by identifying key purchasing trends.

● Created and managed 10+ dashboards using Power BI (employing DAX and Power Query), improving reporting efficiency and enabling stakeholders to make data-driven decisions.

● Conducted advanced statistical analyses using Python libraries (Pandas and SciPy), uncovering significant cost-saving opportunities that led to a 10% reduction in customer acquisition costs.

● Designed and optimized 5 complex data models to streamline analytical processes, increasing by reporting efficiency and deeper insights into customer behaviours and preferences.

● Employed web scraping techniques using BeautifulSoup and Scrapy to analyze data from 100+ competitor websites, facilitating strategic pricing adjustments that contributed to a 5% increase in market share.

● Implemented accurate predictive models utilizing Scikit-learn and Statsmodels, achieving a 20% improvement in inventory level predictions and reducing stockouts by 15%, impacting supply chain efficiency.

● Collaborated with cross-functional teams to gather requirements, clear communication and deliver tailored analytical solutions.

TECHNICAL SKILLS

Languages & Databases: Python, Java, SQL, JavaScript Visualization Tools: Power BI, Tableau, Lucid Chart, MS Office, SSRS Databases: Oracle SQL, MySQL, MSSQL, PLSQL, MS Access Cloud Services: Azure (Databricks, Data Lake, Blob Storage, Active Directory), AWS (S3, Glue, Lambda) Documentation & Reporting: Git, GitLab, Jira, Confluence, Salesforce, ServiceNow, Request Fulfilment, KPI & Dashboard Project Governance: Agile (Scrum, Kanban, SAFe) UAT, BRD/FRD/User Stories, Stakeholder Management, RAID Logs, RACI Matrix, Vendor Management

Analysis & Strategy: Digital Transformation, Product Strategy, Requirements Elicitation, Advanced Excel, Cost- Benefit Analysis, Risk Assessment (AML, KYC, Basel III, SEC), Lean Six Sigma

Contact this candidate