ASHISH RANJAN
Delhi
Summary
Dynamic analyst with a proven track record at Natwest Group, recognized for delivering high-accuracy assessments and optimizing processes. Skilled in financial analysis and critical thinking, I achieved significant improvements in risk management and team performance, earning multiple awards for excellence and innovation in operational strategies.
Overview
4
4
years of professional experience
Work History
Analyst
Natwest Group
02.2025 - Current
- Processed mortgage application cases from initial stage, verifying customer registration and mapping customer data from internal systems to generate unique identifiers
- Conducted detailed data validation and customer onboarding by registering new clients and accurately capturing information from Mortgage Application Forms (MAF)
- Executed CIN Napoli investigations by analyzing customer data across systems to identify discrepancies and ensure data consistency
- Analyzed customer account statements to identify arrears across multiple accounts, performing transaction-level reviews and adjusting discrepancies accordingly
- Identified and assessed arrears in mortgage accounts through detailed transaction analysis, supporting accurate credit risk evaluation
- Contributed to the Metro Bank Data Migration Project involving a £3.1B mortgage portfolio (13,000+ accounts), processing cases across multiple stages (0–50)
- Managed end-to-end case handling including customer onboarding, data validation, document verification, and property/valuation checks during migration
- Handled exception cases where automation failed, performing manual validation and coordinating directly with UK stakeholders to resolve discrepancies
- Evaluated mortgage applications in the pre-underwriting stage by reviewing financial and property documents before final credit assessment
- Ensured completeness and accuracy of documentation to support underwriting decisions and minimize processing delays
- Recognized for exceptional performance and selected to handle high-priority exception cases and liaise with UK teams
Operation Manager
Bata India Limited
05.2023 - 05.2024
- Analyzed daily and monthly sales data to identify trends and improve store performance, consistently exceeding revenue targets
- Monitored key performance indicators (KPIs) such as conversion rate, average bill value, and footfall to support data-driven decisions
- Used Excel to track sales, inventory, and performance metrics for reporting and forecasting
- Followed company policies and operational compliance standards in all transactions and reporting
- Maintained accurate records of transactions and inventory movements for audit purposes
- Ensured adherence to internal controls and standard operating procedures
- Designed an Excel automation tool for inventory tracking and performed variance analysis through audits to detect discrepancies, reducing manual processing time and enhancing data accuracy
Operational Intern
BarRaiser
06.2022 - 04.2023
- Conducted real-time evaluation of interview processes by tracking question flow, timestamps, and interaction quality using internal systems
- Performed quality audits on peer evaluations, assessing accuracy of time-stamping, content relevance, and scoring metrics
- Acted as a coordination point between interviewers, candidates, and technical teams to resolve live operational and system-related issues
Finance Intern
ONE'S OWN FINANCER
02.2022 - 03.2023
- Analyzed financial statements (P&L, Balance Sheet, Cash Flow) to evaluate company performance and support investment decisions
- Monitored market movements and price action to support data-driven trading and investment decisions
- Applied risk management techniques, including stop-loss mechanisms, to control downside risk in volatile market conditions
Education
Master of Business Administration - Finance
Narsee Monjee Institute of Management Studies (NMIMS)
01-2026
Post Graduate Diploma in Financial Management -
IGNOU
01-2024
Skills
- Excel proficiency
- Process optimization
- Root-cause analysis
- Continuous improvement
- Attention to detail
- Critical thinking
- Team collaboration
- Effective communication
- KPI monitoring
- Internal audit execution
- Inventory management
- Mortgage processing
- Transaction-level arrears analysis
- Pre-underwriting document review
- Customer onboarding and data validation
- Touch typing proficiency
Award & Certification
- EF SET English Certificate, 74/100 (C2 Proficient)
- Typing Speed Certification, 61 WPM
- Master Microsoft Excel (Pivot, VLOOKUP, Conditional formatting, Data Validation, If Function)
- Digital Certificate - Foundation to AML and KYC
- Google Data Analytics Certificate
- Anti-Money Laundering Concepts: AML, KYC and Compliance
- Google AI Professional Certificate
Accomplishments
- Awarded “Yes Check” and “TOFU” awards for identifying process gaps and implementing efficient solutions, improving workflow and turnaround time.
- Received reward and recognition by manager for consistently delivering high-accuracy pre-underwriting assessments and maintaining strong attention to detail.
- Awarded "Star Performer of the Month" for achieving the best KPIs, including highest growth and lowest inventory shrinkage.
Extracurricular Activities
Trading Video editing E-sports gaming
Timeline
Analyst
Natwest Group
02.2025 - Current
Operation Manager
Bata India Limited
05.2023 - 05.2024
Operational Intern
BarRaiser
06.2022 - 04.2023
Finance Intern
ONE'S OWN FINANCER
02.2022 - 03.2023
Master of Business Administration - Finance
Narsee Monjee Institute of Management Studies (NMIMS)
Post Graduate Diploma in Financial Management -
IGNOU