Arun Kumar
Business Analyst
About
Business Analyst with 13+ years of experience in Banking and Corporate domains, specializing in Business Analysis, Data Analytics, Revenue Analytics, Dashboard Development and Performance Reporting. Proven expertise in Advanced Excel, SQL, Power BI and data-driven reporting to support management decisions. Strong ability to identify income opportunities, automate reporting cycles and improve productivity across business banking processes. Worked closely with senior business leadership to provide revenue insights that supported quarterly strategic planning and performance monitoring.
Skills & Expertise (25)
Work Experience
Manager, Business Analyst
RBL Bank Ltd
May 2023 - Present
Prepared executive business dashboards and management presentations highlighting key business performance and revenue insights for Management Review of BBG (Business Banking Group) Department. Managed end-to-end business operations for a portfolio of 2,000+ client accounts, including loan portfolio monitoring, renewal tracking, commitment charge processing, vendor payment management and sales incentive processing. Managed end-to-end stakeholder coordination with Business, Sales, Product, and Operations teams for timely execution of business initiatives. Developed daily, weekly and monthly business performance reports and analytical dashboards for Business Banking leadership. Managed monthly & quarterly RM incentive calculations, scorecards and payout processing for 100+ sales employees. Calculated and processed quarterly commitment charges worth ₹15–30 Lakhs for eligible client accounts. Developed business performance dashboards for Trade, FX, PF and Net Interest Income to support revenue monitoring and decision-making. Built leads conversion income analysis to track revenue contribution from Business Banking mapped leads. Monitored overdue and overdrawn loan accounts to minimize SMA/NPA risk through analytical reporting and proactive business follow-ups. Tracked renewal overdue accounts and coordinated with Sales/RM teams to ensure timely renewals. Managed legal and valuation vendor payment processing, ensuring timely verification, reconciliation and payment.
MIS Officer
NEO HBM Pvt. Ltd (Kanodia Group)
Nov 2022 - Mar 2023
Prepared and analyzed Outstanding Payment Reports to support timely collection and improve cash flow visibility. Developed Sales Performance Dashboards and Plan vs Actual reports to monitor business performance against targets. Performed sales trend analysis and shared actionable insights with the Sales team to support business decisions. Calculated and validated dealer incentive and discount schemes, ensuring accuracy before payout processing. Maintained dealer master data and sales records to ensure data accuracy and reporting consistency. Prepared documentation and performance reports for Sales Officers' market visits (Counter Visit Reports). Managed retailer database and generated periodic reports to support sales planning and territory management. Coordinated with Sales and Accounts teams to resolve reporting discrepancies and ensure timely submission of business reports.
MIS Analyst
3M Exim Pvt. Ltd
Sep 2016 - Nov 2022
Developed and maintained Sales, Inventory, Production and Cost Performance Reports to support business operations and management decision-making. Performed production costing, manpower costing and profitability analysis to identify cost optimization opportunities and improve operational efficiency. Managed ERP operations, including purchase orders, sales invoicing, inventory transactions and order execution tracking. Monitored the order lifecycle from order confirmation to dispatch through T&A (Time & Action) tracking, ensuring timely execution. Prepared business reports and dashboards for sales, production, inventory and order status to improve operational visibility. Coordinated with Production, Sales, Warehouse, Merchandising and Accounts teams to resolve operational issues and ensure smooth workflow. Analyzed inventory movement, production performance and sales trends to support planning and resource utilization. Performed data validation and reconciliation to ensure the accuracy and consistency of ERP and business reports. Supported management with periodic reports, business insights and ad-hoc analysis for operational planning and decision-making.
MIS Executive
Future Consumer Enterprises Ltd
Oct 2013 - Sep 2016
Developed daily, weekly and monthly sales performance reports to track business growth and support management decision-making. Performed customer segmentation and location-wise sales analysis to identify market trends and business opportunities. Monitored inventory performance and prepared stock movement reports to support inventory planning and availability. Maintained and analyzed expense records, ensuring accurate reporting and cost monitoring. Prepared periodic business reports and dashboards for Sales and Operations teams to improve performance visibility. Performed data validation and reconciliation to maintain consistency and reliability of business reports.
Education
M.COM - IGNOU University
- · Afghanistan
B.COM - Delhi University
- · Afghanistan
12th - CBSE Delhi
- · Afghanistan
10th - CBSE Delhi
- · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (25)
Click a skill to find developers with the same skill
