Ritwik Mishra
Senior Data Analyst at Capital One
- Role
- Senior Data Analyst at Capital One
- Location
- Richmond, VA, US
- LinkedIn followers
- 500 followers
About Ritwik Mishra
Hiding within those mounds of data is knowledge that could change the life of a patient,…
Experience
Senior Data Analyst
Apr 2020 — Present · McLean, VA, US
Enhanced Capital One\'s credit policy compliance tracking and risk management by overhauling credit policy control scripts, adding error handling data quality checks, and automating them to reduce manual intervention, resulting in a 95% increase in efficiency and resolution of 25+ backlog issues. Continuously adapted the scripts to changing credit policies and client requests, resulting in streamlined operations and improved accuracy.• Demonstrated expertise in data management and scripting by conducting data pulls and performing data quality checks from multiple sources, guaranteeing compliance with auditing requirements across various business segments.• Developed 5+ control scripts to monitor acquisitions processes and report on any violations related to newly launched products or policies in US Card, while creating two control scripts to ensure timeliness and content accuracy of adverse action correspondence for credit card pre-approval requests coming via the prequalification system.• Managed and improved a portfolio of 20+ data quality control scripts, including taking ownership of 10+ scripts from another team, adapting them to support new intents and data changes, and addressing all issues and requests raised by internal clients in a timely and effective manner.• Exhibited strong analytical and data manipulation skills by conducting in-depth analysis of customer management tables to identify and rectify missing data, calculating over 100 columns for 20k+ missing rows, and effectively repopulating the table. Additionally, leveraged expertise in Snowflake and Python to extract keys from Json columns in another table, converting them into separate columns to improve data accessibility and usability.
Skills
- Telecommunications
- Microsoft Excel
- Microsoft Word
- Powerpoint
- R
- Python
- Sql
- Jira
- Sap Fi
- User Research
- Scenario Planning
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.