Mohd Akram Khan

• Analyse client-provided bank transaction data to ensure accuracy and compliance with business validation
rules.
• Design and implement Power BI dashboards for transaction trend monitoring and profit & loss analysis.
• Identify transaction drop patterns and root causes related to uptime, cash-out, hardware, software, and
network issues.
• Present insights and actionable recommendations to management to maximize transaction benefits.
• Perform validation of trip data and cost analysis aligned with slab-based pricing models.
• Extract historical data, transform datasets, and load curated data for analytical reporting.
• Develop VBA/Macro-based solutions to automate report generation, PDF creation, and client email
distribution.
• Monitor SLA performance and transaction KPIs using analytical reports, supporting service quality and
operational efficiency
• Collaborate with cross‐functional teams (Operations, IT, Network) to investigate issues and drive data‐
backed corrective actions

• Extracted data from Salesforce and generated reports based on loan status and category.
• Managed MIS data for Home Loans (HL), Business Loans (BL), Loan Against Property (LAP), and Loan Against
Securities (LAS).
• Handled post-disbursement customer query data and incident tracking through Salesforce.
• Reviewed document-related incidents and monitored overall team productivity.
• Automated reporting using VBA, Power Query, and Excel-based data consolidation.
• Built Power BI dashboards and used basic SQL queries for structured data extraction.
• Analysed loan cycle data to identify trends, bottlenecks, and improvement areas, supporting better
decision‐making for operations and management

• Created MIS dashboards and reports using Advanced Excel and Power Query.
• Performed data cleaning, consolidation, and analysis for operational reporting.
• Extracted and analysed log data from ServiceNow for incident and service request management.
• Delivered SLA-based and priority-wise reports to senior management.
• Coordinated with operations and IT teams to track incident trends, escalations, and resolution timelines
• Improved reporting efficiency by standardizing Excel templates and automating recurring MIS reports

• Managed financial documents for loan processing (Personal Loan, LAP, Business Loan).
• Maintained dashboards and generated daily, weekly, and monthly MIS reports.
• Supported data accuracy, reporting timelines, and stakeholder communication.
• Coordinated with internal teams to resolve data discrepancies and ensure smooth loan processing
workflows
• Assisted in process improvement initiatives by standardizing MIS formats and reporting procedures