Senior Manager- Data Warehouse
Riyad Bank
مجموع سنوات الخبرة :24 years, 11 أشهر
Serving as Senior Manager Data Steward Specialist for Treasury Segment in Business Data Management (BDM) division. My job responsibility are as follow:
• Enrichment and Management of Treasury Products in Enterprise Data Warehouse.
• Actively managing and maximizing the value of the data.
• Aligning the availability of the data with business priorities.
• Handled Oracle OFDM and OFSAA framework from Treasury business perspective mainly for FTP related tasks.
• Increase trust in data and information by regular communication with Business users and key end-users.
• End to End Information deliverable support to Business.
• Conduct in-depth customer, product and portfolio analysis to provide insight into customer base and to facilitate profitable growth.
• Worked with management and key end-users to understand and obtain information requirements.
• Worked with I.T. Department to make the required information available in data warehouse for the analytical and operational needs.
• Supported the business to devise and monitor various campaigns that are run by the product managers.
• Supported Treasury & Investment and Balance Sheet Management divisions for their regular operational and analytical needs.
• Handled Midas to Calypso transformation project for TBO.
• Participated in creation of 360 degree Customer View
• Central Bank reporting project using data from all the business areas used to produce the required information
Business Analyst and Test Manager for FOREX and Structured Products related implementation at Credit Suisse AG Private Banking APAC region (client)
Elicitation of business requirements and converting business requirements into Functional Requirements Document (FSD)
Providing support to developers in functional and business aspects
Preparing/Reviewing Test strategy, Test Plan and provide testing estimates based on the business requirements.
Successfully led 4 Projects including onshore and offshore implementations and front to back end integration projects with teams of size up to 8 resources
Program Test management/Business Co-ordination/SME for FX and Treasury related modules in Globus T24.
Preparing/Reviewing Test strategy, Test Plan and provide testing estimates based on the business requirements.
Interacting with various internal IT stakeholders like Development, Change Management, Quality Assurance and Application support for successful completion of projects
Functional Support during the User Acceptance Testing (UAT) phase, providing business/product clarifications to business users
Good functional/business process knowledge within T24 in Forex, Securities (Equities, Fixed Income), Money market and Client Outputs.
Mentoring the testing team on T24 Product Functionalities, Business process, and ensure that proper knowledge base is built within the team.
FCY Statutory Reserve maintenance
FX Exposure management
Interbank and trade NOSTRO fund management
Handled FX proprietary and Swap book
Traded on Reuters Dealing 3000 and Bloomberg dealing systems
Handled central bank on interbank and fund related areas
Carried-out major trades with central bank
Provided support to other business units enabling them to get more business for the newly formed bank
Annual Budget setting for each treasury product and area
Responsible to keep track of the budgetary deviations and transfer pricing between books.
Preparation & analysis of individual product risk and return model
Key member in Business Analysis and Implementation of FX, MM and FX Sales modules of Temenos T24 in Treasury Front Office
Interfaced self-made software with Reuters XTRA information system
Determination of the changes needed to be made in Temenos T24 Model Bank software in order to operate in accordance with the local laws & practices
Supported NDC members in customization of modules in accordance with the bank’s requirements
Automated Foreign Exchange and Money Market Desks using Visual Basic and MS Excel
Foreign Exchange Dealer
Dealing in Ready, Spot and Promise.
Managing NOSTRO and Net Open Position.
Money Market Dealer
Asset & Liability Management
Reserve Management
ALCO Analysis
Product Development
Risk Management Task
IRR Analysis
ALCO Numbers
Sensitivity Analysis of Interest Rate Risk and Exchange Rate Risk.
System Related Task
Established Reporting Mechanism of Newly Established Bank
Deviation in Actual v/s Budget (Comparative Analysis)
Automated The Foreign Exchange and Money Market Trading Desks Using Visual Basic, Crystal Report 9 and MS SQL Sever 2000.
Weekly FX & MM Report
Foreign Exchange Dealer
Dealing in Spot, Forwards and Third Currencies both on Reuters Dealing System and Local Brokerage Houses.
Cash Flow Management.
Swap Structuring.
Dealing with Foreign Correspondents, Authorize Dealers and Brokers.
Market Analysis.
Managing Exchange Exposure, NOSTRO and Net Opening Position.
Treasury Marketing Unit
Dealing in Ready, Forward Covers and Document Discounting.
Money Market Dealer
Managing Cash & Liquidity Reserve Requirements.
Trading in various money market instruments.
Cash Flow Management.
Mismatching.
Coupon Washing.
System Related Task
Worked at Reuters Dealing 2000 & Money 2000 systems.
Automated the Foreign Exchange and Money Market Trading Desks using Visual Basic, Crystal Report 9, MS SQL Server 2000, Developer 2000 and MS Excel.
Designed a Foreign Exchange Mark-to-Market Revaluation Program in Developer 2000 & MS Excel.
Assisted software developers in integrating the Treasury Trading Desks Systems and the Bank master database.
Designed Treasury Foreign Exchange Cash Flows and Gap Management
System and Decision Support System.
Research Analyst
Financial & Investment analysis of Cherat Papersack Company and Ibrahim Fibres Company Ltd.
Daily Stock Market Analysis
Dealing
Dealing in Ready Market and Carry over Transactions (C-O-T).
Database Administrator and Software Developer
Process re-engineering and re-designing.
Managing allocation of tables for optimal performance, referential integrity checking in order to lower the overhead costs.
Backup & Recovery tasks.
Designed Trade Position System, Receivable & Payable System and Client’s Holding System.
Internship
Worked in Deposit, Securities and Remittance departments. Responsibilities included opening of accounts, issuance of government securities, issuance of local and foreign currency pay orders and demand drafts respectively. Also worked in the advances/credit department as a credit analyst.
Development Programming, Database Management & Server Management
PL/SQL Paper passed 90% marks Aug-1999
This diploma covered SQL Plus 3.3,Forms 4.5 & 5.0, Report 3.0, Procedure Builder, Graphics, Schema Builder, Erwin and Oracle 7.3 & 8.0 Enterprise Edition.
Banking Laws & Practices Finanacing of International Trade Treasury & Fund Management Retail Banking Investment Banking Financial Management Project Evaluation
Introduction to Business Economics Accounting Commercial Geography
Principles of Commerce Economics Accounting