Data analyst

Prudhvi k

Memphis,TN, United States ***** 901-***-**** *******.*.****@*****.***

Professional Summary

Results-driven Data Analyst with 3+ years of experience delivering cloud-based analytics solutions for U.S. Financial Services and Insurance clients. Strong expertise in SQL, Python, AWS (Redshift, Glue, S3), ETL development, and BI reporting. Experienced in regulatory reporting, risk analytics, data governance, and stakeholder collaboration across cross-functional teams.

Professional Experience

DATA ANALYST 01/2025 - Current

Goldman Sachs - TX, United States

• Designed and maintained AWS Glue ETL pipelines processing 15M+ daily trade transactions.

• Optimized complex SQL queries in Amazon Redshift improving reporting performance by 40%.

• Developed automated data ingestion workflows from S3 to Redshift using Glue jobs.

• Built executive dashboards tracking VaR, Liquidity Coverage Ratio (LCR), NSFR, and capital exposure.

• Supported Basel III & CCAR regulatory reporting ensuring compliance and audit readiness.

• Performed trade lifecycle analytics for derivatives, equities, and fixed-income products.

• Implemented reconciliation frameworks reducing reporting discrepancies by 30%.

• Conducted root cause analysis for data anomalies and implemented corrective controls.

• Improved data quality by implementing validation rules and exception reporting mechanisms.

• Collaborated with Risk, Treasury, Finance, and Compliance teams to gather reporting requirements.

• Assisted in cloud migration from legacy warehouse to AWS Redshift reducing infrastructure cost by 25%.

• Developed Python scripts for ad-hoc financial analysis and trend forecasting.

• Participated in Agile sprint planning, backlog grooming, and stakeholder demos. Designed and implemented dashboards and reports to visualise data for easy interpretation by non-technical users.

•

• Collaborated with cross-functional teams to define data requirements and deliver actionable insights. DATA ANALYST 03/2022 - 08/2024

Tata Consultancy Services (TCS) - Hyderabad, India

• Analyzed large-scale claims and underwriting datasets to identify fraud indicators and trends.

• Developed complex SQL queries for policy, premium, and claims data extraction and validation. Designed interactive Power BI dashboards monitoring Loss Ratio, Claim TAT, Approval Rate, and Premium Growth.

•

• Created DAX measures and calculated KPIs for real-time claims performance tracking.

• Automated recurring MIS reports reducing manual effort by 30% and improving reporting accuracy.

• Performed reconciliation between policy administration and claims systems ensuring data consistency.

• Conducted root cause analysis on rejected claims improving processing efficiency by 15%.

• Supported UAT testing and validated business rules prior to production releases.

• Documented data definitions, transformation logic, and reporting standards.

• Collaborated with underwriting and claims leadership teams to enhance operational reporting.

• Assisted in fraud detection analysis using rule-based SQL flagging techniques.

• Provided ad-hoc data insights to senior stakeholders for performance review meetings.

• Client: Leading U.S. Insurance Provider

Core Skills

• SQL (Advanced)

• Python (Pandas, NumPy)

• AWS (S3, Redshift, Glue, Athena, Lambda)

• Power BI

• Tableau

• QuickSight

• ETL/ELT Pipelines

• Data Warehousing

• Regulatory Reporting (Basel III, CCAR, SOX)

• Risk & Liquidity Analytics

• Insurance Claims Analytics

• Data Modeling

• Excel (Advanced)

• Agile/Scrum

• Data analysis

• Data visualization

• Data cleaning

• SQL query optimization

• AWS Glue

• ETL processes

• Dashboard design

• Regulatory compliance

• Root cause analysis

• Fraud detection

• MIS report automation

• Excel proficiency

• SQL

• SQL databases

• Data visualisation tools

• BI tools knowledge

• Python for data science

• Big Data analytics

• Excel VBA

• R programming

• Statistical data collection

• Understanding complexity

• Collaborative mindset

• Financial risk assessment

• Debugging technique

• Risk assessment models

• Banking expertise

• Outcome-Oriented

Websites, Portfolios and Profiles

linkedin.com/in/yourprofile

Education

University of Memphis - Memphis Master's

Data Science, 2025

KKR AND KSR Institute Of Technology And Sciences - Guntur, AP Bachelor's Degree Computer Science / Engineering, 2023

Contact this candidate