Job Description: Database requirement Analysis, Database physical and logical design. Integrate multiple data sources for reporting & analysis to management Written new ETL procedures & enhance existing procedures and automate the process. Performed tuning for long running ETL procedures, sql queries, and stored procedures. Data warehouse Operations support and MIS support.Major Projects: Finance GL Migration - Equation to Oracle GL… Show more Job Description: Database requirement Analysis, Database physical and logical design. Integrate multiple data sources for reporting & analysis to management Written new ETL procedures & enhance existing procedures and automate the process. Performed tuning for long running ETL procedures, sql queries, and stored procedures. Data warehouse Operations support and MIS support.Major Projects: Finance GL Migration - Equation to Oracle GL Project. ETL Migration, Package deployment to Catalog deployment & Performance tuning. FIS/Sun Guard’s, Ambit ACM Module Implementation, deployment and production support. FIS/ Sun Guard’s, Ambit Focus ALM Module Implementation, deployment and support.  IFRS9, data extract for Whole Sale & Retail portfolio and PD and EAD extract for Retail. Achievements:• Customer satisfaction by providing ETL and Reporting solutions, for their day to day operations and for SAMA reporting.• Successful ETL and Report impact analysis and Solution implementation for CIF upgrade project.• Migrated Big tables from daily load to SCD2.• Achieved ETL performance.• Successful implementation of IFRS9 by providing database and ETL solution and Implementation.• Successful implementation of ACM (SAMA Q17 reporting) and Focus (ALM, LRM, FTP) modules by providing data GAP solutions and production implementation and operations support. Show less

Job Description:  Database requirement Analysis and Database Design. Database (Oracle & SQL Server) Maintenance & Administration  Business Information Systems requirement Analysis & Development • Coordinate with business users & understand the requirements • Transform business requirements into IT terminology • Identify the data source (in data warehouse), of business interest • Develop information system for… Show more Job Description:  Database requirement Analysis and Database Design. Database (Oracle & SQL Server) Maintenance & Administration  Business Information Systems requirement Analysis & Development • Coordinate with business users & understand the requirements • Transform business requirements into IT terminology • Identify the data source (in data warehouse), of business interest • Develop information system for business users Provide MIS Support (Analysis, Report, Dash boards). Integrate multiple data sources for reporting & analysis to management. Write new ETL procedures & enhance existing procedures and automate the process. Plan infrastructure, for database and Business intelligence software to run operations effectively and efficiently and comply with the IT policy and procedure. Ensure the timely (Daily/Weekly/Monthly) availability of data. Ensure the data quality. Plan for backup and recovery for ETL and data-mart.Major Projects: Project # 1 : Sales Incentive & Bonus Distribution Project # 2 : Balanced Score Card Project # 3 : Takaful Document Tracking ApplicationAchievements:• Excellent understanding with the stake holders in identifying their data requirement for their daily reporting and analysis.• Excelled in development and implementation of Complete Balanced score card application automation.• Successful development and implementation of sales Incentive application.• Provided the data GAP requirement with the practical solution. Show less