EDRES NASR AL-BAADANI

Management Information System Officer (MIS Officer)Full Time

• Job Details:- Collaborate with DWH/BI Project sponsor and PM to complete Project Charter, High-level Requirements, Test Scripts, UAT and Features Backlog for each Sprint. - Coordinate with IT team to plan and implement DWH/BI program overall design and infrastructure. - Conducted interviews with key business users to collect information on business processes and reporting requirements. - Develop process-specific Data Marts with conceptual (Dimensional Fact Model), logical (Star-schema, Surrogate Keys, and SCDs) and physical (Indexes, Partitions …etc.) models. - Design, develop and deploy SSIS ETL solutions, including logical data maps, staging area, metadata, SSIS Framework, scheduling jobs execution, exception handling, monitoring and tuning. - Generate and optimize complex SQL queries that extract and load data from diverse data sources types (i.e. Oracle DBs, IBM DB2 Files, Flat files, MS SQL DB…. etc.). - Develop dashboards and reports using Excel and Power BI desktop to analyze investment variance, risk analysis, deposits & loans portfolio, cash volume among other for decision-making purposes. - Provide production Level 1 and Level 2 support for local data marts ETL processing and SQL Servers administration as well as global EDW data quality and Hyperion Workspace jobs execution. - Educate and support area management managers to access deployed data marts and OLAP databases using MS Power BI. - Handle Arab Bank global standards and policies for DWBI Yemen SQL Servers. - Build, deploy, optimize, and secure in-memory Tabular Models using SSAS - Collaborate with Compliance team to clean and conform customers’ information by building ETL solution, DQS knowledgebase and data quality solution.

Freelance BI/Web DeveloperFull Time

• Job Details: - Build MSBI Solutions. - Developed Web apps. - Setup and manage web & email hosting servers and domains - Designed Html5 websites. - CMS website (WordPress, Kartris, Umbraco, Joomla) for various companies. - Brand and graphic design for various companies. - Create Social Media Marketing Strategy.

IT Support SpecialistFull Time

• Job Details:- Provided 2nd level on-site and remote base level IT support to more than 210 business users. - Performed rolls out of new systems, updates and patches for servers and PCs - Communicated with global IT teams (Dubai IT team, Jordan IT team) to research and resolve Arab Bank’ networks and applications issues. - Created manuals and educated business end users on using new implemented applications. - Handled Arab Bank Technical Policies and Procedures and documented evidences. - Operated and tracked Numera Track Service Desk (Help Desk), users’ cases, IT team assignment. - Installed and configured of applications servers (storage RAID, Windows Server 2012, SQL Servers 2005/2008/2012, migration strategy, security, and off-site back-ups). - Developed backup, recovery and high availability solutions based on requested RTO and RPO.