About
Data Analyst with strong hands-on experience in Advanced Excel and Google Sheets for data cleaning, transformation, and analysis. Skilled in working with raw, unstructured datasets, ensuring data accuracy, consistency, and quality before reporting. Proficient in building Excel-based dashboards using Pivot Tables, advanced formulas, and Power Query, with additional exposure to Power BI, SQL, and basic Python. Strong logical thinking and problem-solving abilities, with clear communication of insights to support data-driven decision-making.
Skills & Expertise (34)
Work Experience
Credit Process Analyst
ICICI Bank Ltd.
Mar 2018 - Jul 2020
Conducted end-to-end credit process analysis to support retail and corporate loan operations. Executed KYC and AML checks by reviewing customer profiles, identity documents, and transaction patterns. Developed Excel-based MIS dashboards with Pivot Tables and VLOOKUP to track loan status and risks. Created Tableau dashboards to visualize loan performance and approval trends for internal review. Analyzed historical loan data to support risk assessment and portfolio monitoring. Collaborated with internal teams to resolve data gaps and enhance reporting efficiency.
Data Analyst Intern
ICICI Bank Ltd.
Jan 2025 - Apr 2025
Collected, cleaned, and validated large volumes of banking data using MS Excel to ensure accuracy. Developed interactive Bank Analytics Dashboard for analyzing customer transactions and loan performance. Wrote optimized SQL queries to extract details from relational databases for improved reporting. Designed and maintained Tableau dashboards tracking customer retention, churn KPIs, and transaction behavior. Built Power BI reports integrating data from SQL Server and Excel for financial forecasting. Identified high-risk loan profiles and unusual transaction patterns to enhance risk assessment accuracy. Generated quarterly analytical reports with Power BI and Tableau to summarize performance metrics. Performed data mining using BI tools to uncover actionable insights and support decision-making. Cleaned and analysed raw banking datasets using Advanced Excel, applying lookup functions, IF logic, and Pivot Tables to ensure reporting accuracy. Prepared Excel-based MIS and operational reports, validating data consistency before sharing with stakeholders. Identified data gaps and duplicates, improving data quality, and reducing reporting errors.
Education
Data Analytics - ExcelR, Hyderabad
- 2025 · Afghanistan
Bachelor's Commerce - Nagindas Khandwala College of Commerce, Arts & Sci, Mumbai
- 2017 · Afghanistan
Company Secretary (CS): Executive level - ICSI
- 2019 · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (34)
Click a skill to find developers with the same skill
