Analyst | Bank - Business Intelligence Unit
Al Masraf Bank
Total years of experience :15 years, 7 Months
Responsibilities:
• Create Dashboards and MIS reports to analyze business scenarios.
• Generate and distribute Management MIS packs in timely and accurate manner.
• Provide recommendations to update current MIS to improve reporting efficiency.
• Support Finance Department with all the MIS related to Central Bank Reporting.
• Provide strong reporting and analytical information support to all Departments in the Bank.
• Corporate Banking and SME Banking Dashboards prepared to analyze Corporate and Banking businesses along with Sales Team Performances.
• Consumer Banking Team Reports and Dashboards provided on daily and adhoc basis along with Portfolio targets and reallocations.
• Prepared MIS to support Trade Finance Department.
• Past Due Analysis and Central Bank Parameters Analysis done for Credit Risk Department.
• Consolidated and Individual Coverage Reports prepared to analyze Individual Relationship Managers Performance.
Responsibilities:
Prepare and monitor MIS to track customer relationship information on a detailed basis.
Prepare and manage complete loyalty program, retention and cross-sell program
Analyze business and transactions through reports, projects and plans to achieve cost effectiveness and careful spending.
Create and ensure formal and timely reports for customer evaluation for RBG
Business support for retail segment and developing reports as per the business/management.
Monthly MIS reporting to all sales and branches based on customer level details
Adhoc reporting for RBG to support business initiatives
Analysis of customer behavior and profitability
Supporting new initiatives such as Credit Scoring Matrix development
Data to support Cross-selling and marketing activities to increase sales
Involvement in the product development process
Interact and coordinate with the department staff and managers: ITD, Operations, Strategic planning, Marketing, Regional and Branch Managers, Retail Credit and Corporate Banking Division
Acting as business partner for retail segment and developing reports as per the business/management with focus on strategic performance of the segment and KPIs of staff members.
Attend queries from staff members regarding performance reporting and provide clarity
Design reports/information system for performance reporting to facilitate efficient decision making.
Preparation of all Retail MIS reports and incentive payout calculation for branch staffs.
RAK BANK (July 2008- May 2012).
www.rakbank.ae Dubai, UAE
MIS Officer
Cross Sell Dept, RAKBANK
(Nov 2010- May 2012).
Responsibilities:
Analyzing databases of customers holding Business Loan, RAK finance, Auto Loan, National Loan, Expat loan, Farm Loan, Overdraft, Mortgage Loan etc
To compile and monitor MIS reports as per the BIU calendar for circulation to Business Managers.
To compile and monitor Control Reports as per BIU calendar.
To assist and manage the team in carrying out a periodic review of current Business/Credit/Collection MIS reports for enhancements.
To assist various departments to extract databases for Cross-Sell and Credit Limit Increase programs as per the approved criteria.
To carry out periodical quality checks to ensure Data accuracy for all asset products and assist in data clean up exercises.
Automating various areas of MIS reports and carry out re-engineering initiatives.
To be effective backup for requirements such as incentive payout for staff in collections and recoveries, providing MIS reports for monitoring performance.
To ensure adherence to cut-off times mentioned in the SLA and Department & specific deadline are without fail.
Database Analyst
Credit Dept, RAK BANK
(July 2008- Nov 2010).
Reporting delinquency and portfolio information to higher officials
Keep track of outstanding payments and maintaining customer accounts for payments
Demonstration of various MIS reports, graphs and data marts on specific business functions of the Bank.
Data handling and analysis of key accounts
Preparation of monthly sales analysis reports and portfolio MIS reports.
WIPRO TECHNOLOGIES
www.wipro.com
August 2007- June 2008
PROJECT: PORT FOLIO MANAGEMENT SYSTEM
The basic purpose of the Portfolio Management tool is to help the user decide on the portfolio allocation of his investment based on reports generated by the tool. Provision for different type of role based entitlements. One user can be entitled for multiple roles such as primary analyst, analyst, user and the administrator. Dynamic Table Generation (DTG) is being utilized here. When a user logins to his home page he has the option to select different industry types. When a particular industry is selected he will be given a list of companies in that particular entry. When user clicks the company a portfolio management report is generated dynamically which gives the company information regarding the share price, average diluted shares outstanding, volatility, net income, operating revenue etc. of the selected company. With this information users will be able to get a general idea regarding the growth of company in a specified period and allocate his investments accordingly.
Environment: Java, JSP, Oracle.
Responsibility: As a Team Member, responsible for development, enhancements and implementation of the application. Involved in preparing Quality Process Documents as per the standards.
GREEN TECHNOLOGIES
August 2004 - July 2005
PROJECT: AIRLINE TICKET BOOKING SYSTEM
The purpose of the project is to develop and deploy a web based system for leveraging the existing IT infrastructure of Pan Airlines to enable them to be more vibrant, productive and efficient by developing an online reservation. This project would result in a completely web based airline reservation system which will allow users to check flight schedules, check seat availability on a flight, make or cancel reservation, view the airline’s network of flights and destinations, check the current reservation in the user’s name by interacting with this program.
Environment: Visual Basic, Oracle
PROJECT: VENTURE CAPITAL INDIA
The main objective of the project was to provide a web based system to allow investors and entrepreneurs to put their business plans and expectations together which helped them to find the required business and capital. The purpose of this project was to bring as many sources of capital together as possible, which would increase the likelihood that the business plan gets the needed exposure to help in raising capital.
Environment: Java, Java Script Oracle.
Master in Business Administration - Finance
M-Tech. Computational Engineering and Networking. (2005 - 2007) Amrita Institute Of Technology Amrita University, India Distinction (CGPA-8.01) Sun certified Java Associate Participated in the workshop on Mathematical Transform Methods in Engineering Participated in the Amrita Berkley Workshop on Research Frontiers in Machine Translation in Indian languages Attended the two day workshop on An introduction to Computational Chemistry and Molecular Modeling
B-Tech. Information Technology. (2000 - 2004) Cochin University of Science and Technology. Kerala, India First Class (73.67%).