Sakshi Parashar
Data Analyst
Ghaziabad
Summary
Data Analyst with 2.5 years of experience at Barclays within the Collections domain. Proven track record of managing high-volume account datasets, identifying delinquency patterns and delivering KPI reports that drive team performance. Proficient in SQL, Power BI, and Advanced Excel, with a focus on transforming raw financial data into actionable business insights.
Overview
2
2
years of professional experience
Work History
Process Advisor (Operations and Data Analyst)
Barclays
04.2023 - 09.2025
- Operational Efficiency: Analyzed daily agent performance data to identify bottlenecks in After Call Work (ACW) and Hold Time; successfully implemented a strategy to reduce Hold Time from 15% to 7%.
- KPI Optimization: Streamlined the "After Call Time" (AST) target to 320 seconds, directly increasing the daily call volume per agent and significantly boosting overall business efficiency.
- Data Management: Utilized Salesforce, CCD and SQL to extract and audit account details for Bucket 1 and 2 delinquency, ensuring high data integrity for payment reconciliation.
- Automated Reporting: Engineered daily KPI reports for management, providing visibility into team productivity and feedback loops that improved process workflows.
- Customer Lifecycle Management: Managed high-volume credit card portfolios, leveraging account data to resolve payment delays and provide strategic reminders to customers.
Education
MBA - Specialization: Marketing & Human Resources
Institute of Technology And Science
Ghaziabad, India 04.2001 -
Bachelor of Technology - Specialization: Electronics Engineering
Rajkiya Engineering College
Kannauj, India 04.2001 -
Skills
Excel Proficiency
Documentation and Reporting
Data Wrangling
Salesforce and CCD
SQL
Data interpretation
Stakeholder Management
Risk Mitigation
Data Visualization
Power BI (Dashboard Design)
Cross-Functional Collaboration
KPI Analysis
Accomplishments
Project 1: Sales Performance & Customer Insights (Excel & Power BI)
- Objective: Designed an interactive dashboard to track monthly sales performance and customer purchasing patterns.
- Process: Cleaned and transformed raw CSV data using Power Query. Developed DAX measures in Power BI to calculate Year-over-Year (YoY) growth and Profit Margins.
- Outcome: Created a report featuring Slicers and Trend Lines, allowing for a deep dive into top-performing product categories and regional sales bottlenecks.
Project 2: Relational Database Extraction & Analysis (SQL)
- Objective: Extracted and analyzed business data from a relational database to answer key operational questions.
- Process: Wrote complex SQL queries involving Multiple Joins, and Subqueries to aggregate data across customers, orders, and products.
- Outcome: Successfully identified the "Top 10 Customers by Revenue" and "Slow-Moving Inventory Items" to pull actionable insights directly from a database.
Timeline
Process Advisor (Operations and Data Analyst)
Barclays
04.2023 - 09.2025
MBA - Specialization: Marketing & Human Resources
Institute of Technology And Science
04.2001 -
Bachelor of Technology - Specialization: Electronics Engineering
Rajkiya Engineering College
04.2001 -