Applications Systems Officer
M H ALSHAYA
Total years of experience :8 years, 4 months
8+ years of experience in IT Business Intelligence
Worked as Applications Systems Officer at M H Alshaya
Expertise on ETL process, Analysis and Reporting services
Expertise on ETL tools like SSIS, Dell Boomi, Pentaho
Experience in Designing and Implementing a Data Warehouse
Experience in developing reports using Power Pivot and MS Excel Power View
Ability to effectively prioritize and execute tasks in a high-pressure environment
Strong logical, inspection, analytical and problem discovering skills
Roles and Responsibilities:
• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of consumers
• Migration of Databases from SQL Server 2008 to SQL Server 2012 using SSIS
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Performance Tuning, optimization, Data Integrity and Statistics by using SQL profiler, PerfMon and spotlight
• Handled Scheduled backUps and restore operations with Litespeed 8.0 and monitored the Tasks, Maintenance plans