Data Warehouse Manager / Consultant
Gulf Bank
مجموع سنوات الخبرة :30 years, 8 أشهر
• Led and coached a team of senior developers and external consultants on projects involving DW environment and BI.
• Supervised multiple BO universes consolidation within Consumer Banking Group units to streamline change management and economize departmental report creation.
• Designed and implemented the Data Warehouse re-structuring project resulting in removal of redundant schemas and tables. Created roadmap addressing the DW performance, consolidation and data retention policy.
• Cooperated closely with the AML and Audit units to assure highest level of compliance.
• Designed and monitored implementation of the customer contact numbers clean-up and cross-systems customer data consolidation.
• Maintained close relationships with software vendors and solution providers - NCR (Aptra), SAP (BO) and SAS (Enterprise Miner).
• As a Business Service Leader maintained close cooperation with all bank’s units during the development life cycle.
• Managed the Marketing Data Mart retrofit project - conversion of the self service processes and data marts maintained by Marketing to ETL and SAP BO environment in custody of IT.
Executive Manager, Market Analysis (Marketing Department) 2006 - 2011 * Provided analytical assistance in preparation of commentaries and prepared business performance reviews. Designed innovative methods for KPI metrics and created dashboards in support of BI needs. * Synthesized information to identify key business trends and issues related to implementation of new products and policies.
* Successfully implemented selected prize draws. Created and automated a comprehensive term accounts analytics (FDs) . * Designed the customer income analysis based on salary, pensions, allowances and other income sources and introduced a new methodology of monitoring customer and products acquisition, attrition, product cross selling, salary conversions. Designed methods of measuring advertising campaigns effectiveness. * Obtained insights on customer demographics, retention, income, and channel activity. Generated actionable leads based on processing data originating from various sources including customers' on-line banking and web page activity. * Assisted Boston Consulting Group consultants in designing and implementation of the Sales Power Tool by designing and implementing a comprehensive data supply related to customer and product acquisition used for sales performance metrics and incentives. * Spearheaded the data quality and integrity project through broad system data analysis. Designed solutions for front-end system data cross-validation and master data cleansing process solutions with data quality monitoring. * Acted as primary consumer banking - IT liaison for specifying and monitoring the implementation of new business requirements related to core and satellite applications. * Designed and implemented the Marketing Data Mart providing a consolidated 360 degree customer view model enabling self-service BI within customer profiling and segmentation. Introduced MS Access Statistics tool to analyze customer transaction activity and behavior. * Exploited competitor analysis for marketing advantage, gathered and used official statistical information and local demographic data for strategic analyses and reporting in areas of market size, penetration and trends. * Supported customer satisfaction and brand loyalty analyses, monitored implementation of recommendations provided by research based on close cooperation with market research agencies - IPSOS and TNS. * Led a team of 4-5 analysts coaching and advising them on data modeling for analytical purposes and provided core and satellite systems knowledge to other marketing teams.
Manager, Data Warehousing (IT) 2003 - 2006 * Designed and supervised implementation of the Retail Data Warehouse and Departmental Data Marts. * Provided analytical support to Retail, Corporate and Marketing business units as well as accurate and timely information in the hands of stakeholders to enable them to monitor and understand their business effectively. * Designed and created a retail banking BO universe to support the growing consumer banking reporting needs. * Provided functional and technical specifications for system development and user self-service reporting solutions through integration of various data sources. Automated many back-office reporting processes for numerous departments and units through MS Access. * Implemented the Balanced Scorecard System for branch KPI and sales incentives within financial and HR quadrants.
Project Leader 1993 - 2003 * Supervised reporting development projects for Retail, Treasury and International Banking groups. Maintained the Capbanc system until conversion to Bancs system (FNS) . Designed and implemented the archiving of 13-year legacy system transaction history for statement retrieval. * Developed basic data marts to support business requirements after system conversion. * Defined and documented business requirements, developed detailed system specifications to facilitate application development. Acted as liaison to the product development technical team to communicate key system designs.
* Managed complex projects involving individuals from within and outside the organization. Designed and implemented the electronic distribution of daily system reports to branches through BO. Conducted extensive research of MIS methods and spearheaded the Retail Data Warehousing implementation and feasibility study on CRM for the bank.
Analyst Programmer 1985 - 1993 * Worked on reinstating systems data after the Gulf War in the so called 'catch-up' project aimed at updating the proper customer status after the liberation based on government policies. * Maintained and customized the Deposits and Retail Loans Capbanc software. Implemented the Bonus Savers product and the cost-effective FD auto-renewals method. * Designed the Central Bank Reporting suite of programs and the branches closure / merger process. * Designed and delivered numerous reports written in COBOL, UPG, NEAT/3 languages.
MERA System Poland / AIMS / Consultant in National Bank of Kuwait 1983 - 1985 * Maintained and customized the front-end system application for the Customer Integrated Reference File system (CIRF) . Module design and alpha testing.