GM
inspirisys
مجموع سنوات الخبرة :20 years, 4 أشهر
• Prepare high-level strategic plan, reports on various product campaigns & promotions, annual budget and monthly/quarterly portfolio forecasts.
• Develop and analyse detailed documentation of project / systems and client needs, including workflow, program functions and steps required to develop and modify programs.
• Lead and manage end-to-end database project developments as part of the system steering committee member. Requirement gathering process from business, Data Mart designing, Data Analysis, Data Modelling, project implementation and overall support to business. Star schema development for various standalone data marts.
• Create new Standard Operating procedures for ad-hoc and routine requirements and automation of all manual reports in Business Objects for speed and accuracy.
• Ensuring data security and MIS control and sharing of data on approved DRF.
• Manage statistical analysis for decision-making forecast, modelling thereby improving strategic planning administration of sales incentives to align individual interest with company goals.
• Provide product portfolio analysis report, sales team performance analysis & branch performance in the form of RAG analysis. Compute monthly sales incentives/compensation for sales staff using the Oracle ERP Solution.
• Identify the product penetration and provide potential up-sell & cross-sell leads for the existing customer base and help to develop incentive / promotion schemes.
• Spear head the branch-customer transformation strategy to reduce the customer foot-fall at branches and deliver the services through digital platform with a customer-centric focus.
Business Intelligence Unit
•To guide the ETL & COGNOS teams and the project team to make them understand the context of the program and project, project concept, project approach and desired future result.
•Responsibility includes requirement gathering from business, Data Mart designing, Data Analysis, Data Modelling, project implementation and overall support to business.
•Provide project scope, planning, timelines and project cost to the Business.
•To supervise and coordinate the data analysis team in various development projects of the bank.
•Provide leadership and coordination in planning, budgeting, forecasting, analysis & performance measurement of individual business units.
•Assist managers in preparation of strategic plan, reports on various product campaigns & promotions, annual budget and monthly/quarterly forecasts.
•Work with business teams to understand their requirements and to negotiate any change with a customer-centric focus.
•Support management to review performance & build business plans and assisting in internal auditing.
•Develop and analyse detailed documentation of project systems and client needs, including workflow, program functions and steps required to develop and modify programs.
Summary of Projects Handled in Emirates NBD
•Merchant Acquiring Dashboard Project - Developed a data model enabling the business to monitor the merchant total and average sales, calculating the profit margin for each individual merchant.
•Credit Card Issuance Data Mart Project - Designed and implemented a data mart to generate reports to third party banks on their card portfolio, credit card delinquency status, collections, sales volume, customer segments and to help Retail business to identify the market segments for their various marketing promotions/campaigns.
•Credit Card Pro-Risk & Fraud Management Project - Developed a dynamic data model to track, analyse and report fraudulent credit card transaction both in Issuance and Acquiring business perspective and supported business in credit card fraud investigation. Reports for operational risk assessment were also extracted from this database.
•Customer Life-cycle Management (CLM) Project- To analyse & provide data for Retail business for their research on customer behaviour.
•OPC (Ops. Core Banking) Project - Delivered a set of 79 standard reports from the FINACLE for the operations Dept. after the implementation of the new core banking system in the bank.
•CAPSTONE Project - Was part of a team in developing a credit risk score-card model for the legacy Emirates Bank International (EBI).
•Software Used:
•Reporting Tool: SAP Business Object, IBM Cognos, MS Excel
•Visualization Tool: Cognos Analytics, MS Excel, MS PowerPoint
•Querying Tool: SQL Server Management Studio
•Database: Oracle
•E-Suites: Finacle
Distribution & Processing Centre - Unit Head
•Managing the day-to-day activities of DPC unit.
•Query Resolution.
•Exception handling.
•Quarterly Self-Assessment of the team performance.
•To adhere to SLA and to the TAT of the process within the benchmark levels specified.
•Liaising between the branch and the DPC for smooth functioning of the unit.
•Through monitoring of incoming and printed cheques at DPC.
•To keep the unit always prepared for Continuity of Business (COB)
Credit Cards)
•To Review the Business Product Specifications and Functional Specification of the client and explain the basic requirements of the same to the Test Engineers.
•To prepare the test scope and approach based on the BPS and FS of the application.
•To give presentations to the management about the scope and approach.
•To review the test ware (test conditions, cases and scripts) prepared by the Test Engineers.
•Verifying the migrating credit cards historical data from Oracle 9i to Teradata.
•To check whether Isys Feeds Files from various systems are correctly populated into Teradata.
•Extracting VSAM feed files from TSO region using File-Aid utility in IBM Mainframe.
•Software Used:
•E-Suites: Empower, Hyperion
Gulf Auto Loans / India & Oman Application Processing Unit
•To authorise the loan applications processed by the team members.
•Fortnightly & monthly MIS to CPC.
•Monthly KRI & KCS (Key Risk Indicators & Key Control Standards) checks.
•Supervise and effectively manage a team of processing staff and ensure that the processing is completed within the stipulated TAT.
•Tracking of errors made by the team on a day-to-day basis.
•Monthly Update of ESAU ratings of team members to manager.
•Effectively track and manage the teams leave plan and training programmes.
•Try to maintain the error rating of the team to be under the benchmark level.
Chargeback Analyst - Jersey, India, Afghanistan, Gulf and Lavent Countries
•Action Customer Disputes (Perform Copy Request/Chargeback) relating to Purchase / Cash Advance / Credit Transactions for both Issuance and Acquiring business.
•Action Disputes from other Member Banks for ATM Acquiring Transactions.
•Action Re-presentments, Pre-Arbitration, Pre-Compliance issues relating to transaction Disputes.
•Initiating Customer Financials Entries & GL Entries relating to Disputed Transactions.
•Rectification of Posting Reject Transactions.
•Reconciliation and reporting on Chargeback Suspense Accounts.
•Handling CPC related queries on card holder chargeback cases.
•Have tested Cards 400 functionality in testing mode before the roll-out of Jersey Chargeback to Chennai and the new release of chargeback reason codes in Cards 400.
•Software Used:
•Reporting Tool: Tableau, MS Excel, Crystal Reports, MS PowerPoint
•Database: MS Access
•Core Banking System: Vision Plus, Cards 400(Mainframe), eBBS, BBS, Equation, Edit Package (Visa), People Soft
Content Providers for Sify’s finance websiteWalletwatch.com