Assistant manager consumer analytics/MIS/BI - Permanent Role (Present)
BANK AL-FALAH, ABU DHABI GROUP OF COMPANIES
Total years of experience :12 years, 8 Months
SQL server administration setup for staging server and off-site & on-site backup planning, planned to setup virtual machine server for backup maintenance.
Responsible for regular daily/monthly and AD HOC data/MIS deliverables.
Suggested and implemented data delivery mechanism through using SSRS & EXCEL as a client tool to connect with server side databases.
Implementation of data request form.
Logical and physical data model development using through ERWIN and implementation of data mart for managing credit cards portfolio, Credit Cards dashboard, cards segmental MOB, cards portfolio segmentations, CIF, AIF movement, ENR movement, daily & monthly spend analysis, Attrition analysis, Automation of Credit Cards MIS Pack, portfolio segmentation, daily spend analysis, transaction reconciliation using through Excel VBA macros, Merchant Acquiring MIS, Cashback campaign analysis, Spend reconciliation project, DECILE analysis, Good and bad analysis, ON-US/OFF-US analysis, top 10 merchant analysis, data requirements for different credit cards campaign analysis.
E-CIB data scrub project.
Sourcing of CARDPRO data into TERADATA warehouse project that includes GAP analysis, UAT, Technical transformation of credit cards business logics, development of access layer by identifying Dimension and facts, Switching of data model to BI layer, Training of staff, Transformation of existing SQL server based queries to TERADATA platform.
Automation of existing MIS (Autos Ageing using through SSIS, Spend MIS, creation of user defined functions in SQL server database, Debit Cards data file parsing mechanism, Cross product analysis database, CARDPRO data loading on staging server using through SSIS and AUDIT log maintenance).
Emirates Islamic Bank - Dubai (UAE) - (2010 to 2012) Business Intelligence Analyst
Support Areas IBCRD, IBCOD, IBRPC, IBFIN, IBCLC, IBCB, IBCOMP, IBINA, IBRAU, IBBPRM
Key Achievements
✓ Regular deliverable of Initiatives, Change requests, business service requests, data deliverables and AD HOC MIS using SQL server data extraction tools SSIS and COGNOS reporting tool.
✓ Development and automation of policy MIS pack in COGNOS using FINNONE system for IBCRD.
✓ SQL to SYBASE IQ migration project. Automation & transfer of existing data marts, SQL scripts of Emirates-NBD MIS to SYBASE IQ platform.
✓ Automation of customer Information File (CIF), Trade License Expiry MIS, Accounts Closure exercise, audit trail of DOCSAFE - document archival system for financial statements, Anti-money laundering MIS for AML alerts, loan enquiry module of legacy loan systems RFS- Retail financing system (application booking) and LMS- loan management system, Monthly & AD HOC deliverable of Inward & Outward Remittances MIS, Corporate exposure & portfolio MIS for IJARAH and MURAHABAH customers on COGNOS., Retail Home Finance portfolio data extraction using SSIS, ESTATE corporate customer portfolio MIS, MOODYS weekly MIS (customer ratings and grades based on loan performance), \{EQUATION (Core banking system), EDOC system & MOODYS interface MIS, Regular deliverable of Credit Cards and Debit Cards portfolio MIS & data to Credit and collection department using VISION PLUS system, Aging MIS for Home finance products (IJARAH, ISTESNEH, MURAHABAH, IJARAH through ISTESNEH), Maturity MIS for IBFIN, IBCRD FINONE system MIS Pack for tracing and ensuring that retail loan application approval/rejection process is following policy CAPS and parameters., IBDISB MIS pack for Corporate IJARAH, MURAHABAH, INVESTMENTS and WAKALAH deposit, an interface of core banking & Corporate / REAL ESTATE systems., Standing Order MIS for IB-DISB, IBCRD monitoring MIS for REAL ESTATE (IJARAH, MURAHABAH, ISTESNEH, ISTESNEH THROUGH IJARAH), CORPORATE (IJARAH, MURAHABAH), TRADE FINANCE (MURAHABAH) for Profit suspension.
✓ COORPORATE DATAMART model for Islamic banking corporate loan management system. interface of core banking, retail, corporate, Trade finance
✓ Designed and developed FINNONE system CAS data mart model for application through the door analysis and application scorecards development. Model was physical deployed on SQL server database and implemented on COGNOS for business users.
✓ Migration of data from legacy systems, RFS - Retail financing & LMS - Loan management system to FINONE system (for retail lending) using complex SQL scripting and using SSIS.
✓ Late Payment Fee Migration Project- Migration of Late payment Fee from legacy system to FINNONE using complex SQL scripting and SSIS.
✓ Capacity planning project for operations department. Capacity planning is used for calculating commission, other incentives and setting up other allocations for RBE (Retail Banking Executive) . The project involves some structural changes and SQL writing additional SQL scripting for requested modifications.
✓ Automation project of existing IBCLC, IBCRD & IBCOD MIS. Modifications were made in existing COGNOS MIS.
✓ Data extraction & data mining from data warehouse for all retail, liability and investment products for application and behavioral Scorecards development. Data extraction was done using SQL scripting. Data uploading / transformation and analytics was also performed in SAS for supporting credit department.
✓ Scorecards monitoring MIS implemented on COGNOS.
✓ Cross sell and cross product analysis for all existing retail lending customers using SQL writings.
✓ Developed Retail lending Application Sourcing, TAT, DEVIATION, Authorized/Un-authorized company customers and REJECTION MIS on SQL/COGNOS for Retail authorization unit.
✓ Quarterly MIS pack developed and automated on COGNOS that includes sourcing, TAT, productivity, LPO issuance, loan initiation data (Application log), Stage Reversal.
✓ Corporate Customer Grade migration exercise from MOODYS to EQUATION - Core banking system.
✓ Developed data mart on COGNOS for Equation - Core banking system that allows user to interact with key account level, customer level & deal level information of customer liability, retail products, corporate products, average balances, product segmentation, remittances details, standing order, customer demographics, financial transactions, account status details, high/low balances, Customer / Account / product types, Funded and non-funded balances, Customer limits, Turnover statistics, Customer demographics details
✓ Retail & Corporate Customers behavioral & application level data provided for Dubai Bank integration project.
Emirates-NBD-Dubai (UAE) (2007 till 2009)
Support Areas RCB, FIN- (CWM), Network international - NI (Merchant Acquiring
business), FRMU, Credit Policy
Key Achievements
✓ Credit Cards data mart development & Implementation for Emirates NBD Bank using VISIONPLUS, CAPS, BASE24 & EQUATION systems. Data mart was implemented on COGNOS.
✓ Implementation of Credit Cards Daily & Monthly MIS in COGNOS using VISIONPLUS system.
✓ Supported Business intelligence, Group retail credit, Retail consumer banking, Collections, Finance - Consumer Wealth management for Credit Card AD HOC MIS and data using V+ system.
✓ Performed Gap Analysis for Credit Bureau on Charge-off /defaulter's database (Performed GAP Analysis for EMCREDIT)
✓ Automation of daily, weekly and monthly Credit Cards (VISION PLUS) MIS on COGNOS that includes;
o Spend, Attrition, MOB, New Business MIS, CIF, Attrition, Trend analysis, Vintages, Promotion MIS, Through the door analysis, ENBD Channels MIS, Diners Cards MIS, Debit cards Retail & Cash (Domestic-International Off-Us, On-Us Spend MIS. Credit Cards Transactional data.
✓ Supported Network international for merchant acquiring business for Daily/weekly/monthly MIS. This includes;
o Merchant Turnover, profitability, transactional information, Merchant details & demographics, NI data mart.
1. MCB Bank Limited (Karachi - Pakistan (2006 to 2007) Designation: Manager
Automations & MIS (Officer Grade - 1)
✓ Suggested ETL process for data management between Oracle and SQL server.
✓ Developed screen layouts & UAT support for APPLICATION TRACKING SYSTEM (ATS)
✓ Developed timely Ad hoc MIS by writing SQL queries using SQL Server and supported FRMU - Fraud & Risk management Unit, Collections, CIU, and Credit Policy.
✓ Branch wise & product wise Cross-Sell Analysis performed during launching of first MCB VISA Credit Cards.
✓ Automation of CIF Reporting, Credit Card Checklist, Fraud and Cross Product match module., daily delinquency MIS for CAR4U, PIYARA GHAR and monthly CITY wise MIS, monthly MIS PACK for consumer asset portfolio for different retail products (CAR4U, MORTGAGE HOUSE FINANCE, and BUSINESS SARMAYA)
✓ Technical writings and documentations
o Maintained change management documents, technical manuals & user manuals of newly created automated programs, queries and ETL process.
Achievement Awards
• MCB Recognition shield' in response to efforts and contribution with Credit Cards launching team
2. ABN AMRO BANK N.V. (Karachi - Pakistan) (2004 till 2005) Designation: MIS Officer for Retail Cards business
✓ Performed CROSS-SELL Analysis on ASSET & Liability like BTF, PILS, Mortgage, Liability and CNC Customers during first launching of ABN AMRO Visa Credit Cards using VBA macros.
✓ Development & automation of weekly and monthly Credit Card MIS pack using VISION PLUS system, Credit Card Authorization module using VBA macros, credit cards provisioning, MOB, Vintages, Deviation analysis in MS-ACCESS using VBA macros, Credit Card Collection MIS using VISION PLUS system.
✓ Developed regular month end, weekly, quarterly & AD HOC credit cards and MORTGAGE MIS.
• ABN AMRO BANK N.V. MIS officer Award for the month of MAY 2005
3. Standard Chartered Bank (Karachi - Pakistan) (2001 till 2003) Designation: Analyst Programmer
✓ Utility Bill Pay System development version 1.0, Administration Module for IVS system., Lucky draw module in Visual basic 6.0, C&IB module created in VB 6.0 with SQL Server., Pipeline collection system PCS Text File upload utility created in Visual Basic 6.0, Funded & Non-funded income reporting module developed for Finance department., Know your customer KYC, encryption routines for EASY CREDIT SYSTEM., signature capture interface module for EASY CREDIT SYSTEM v. 1.0.0
✓ Support provided for IVR - Interactive voice response (SYNTELLECT system), process diagram and documentations of IVR for Call Centre project
✓ Change management documentations of (MNET Charges, CLUSTER, COPS, IVR-HSM, LMS, PCS, PFC Reporting)
✓ Spend 1 month in data Center to understand data center operations.
✓ Developed & implemented State Bank of Pakistan Foreign exchange return System (Versions implemented 1.0.0, 1.1.0, 1.2.0, 1.3.0) in Visual Basic 6.0/MS-SQL SERVER/CRYSTAL REPORTS.
✓ Developed Enhanced Cost control system ECCRS (v. 1.0.0)
✓ AUDIT documentations for internal audit of all PK - IS (local) and regional information system applications.
4. Bank AL-Falah (Karachi - Pakistan) (2000 till 2001) Designation: Programmer
✓ ActiveX control module created in VC++ for DIALOGIC PROLINE /2V IVR interactive voice response system.
✓ Developed encryption routines created in VB 6.0 for SMARTLINK software for SONERI BANK LTD.
✓ Developed an email client in Visual basic using ActiveX DLL for desktop mobile messaging.
5. DADABHOY Software Company (JAN 1999 till JUN 1999) Designation: Programmer
✓ ORACLE interfaced GUI simulation model created in C++ for PARCO (PAK ARAB REFINERY)
✓ Created software security module in C++ for DOS based software copy protection.
✓ Enhancements in payroll system for Y2k Bug fixing for DADABHOY company client JAVAIDAN - STATE CEMENT
Educational/Professional Qualifications 2006 Post Graduate Certificate (Microsoft .NET) NED University of Engineering & Technology
2000 ORACLE Certification ORASOFT Institute, Karachi
1998 M.Sc - Applied Physics University of Karachi
1997 1 year Diploma Certification in Software SINDH Board of Technical Education
1995 B.Sc. University of Karachi