Data Analyst
Ministry Of Interior - KSA
مجموع سنوات الخبرة :6 years, 6 أشهر
• Accessing data, constructing and manipulating large data to support planned analysis, using SQL, Python.
• Designing and developing BI dashboards based on business requirement.
• Develop analysis and reporting capabilities, monitor performance and quality control plans to identify improvements.
• Adapt at queries, report writing and presenting findings.
• Research and validation of entity data using appropriate internal and external data sources.
• cleaning and preparing data for analysis process.
• Analysis, specification, testing and implementation of interfaces, workflow solutions, and reference data solutions.
• Understanding database concepts and terminology, database design principles and elements in order to deliver reporting. 08/2022 - present Riyadh, Saudi Arabia
• Analyzing services, transactions, and share trends to build warehouse data.
• Designed and implemented new ETL processes and adapted current ETL processes to accommodate changes in source systems and newbank business requirements.
• Track and fix much type of errors (logical and technical) that rises during ETL process.
• Analysis the tables and Design, create dimension and fact tables to build a good star schema to provide a good performance and analytics.
• A good experience over making DAX queries in Power BI desktop.
• Expert in using advanced-level calculations on the data set.
• Connecting data sources, importing data, and transforming bank data for Business Analysis purpose.
• Presenting information through reports and visualization.
• Using warehouse data to generate reports to support business decision-making and bank business performance monitoring.
• Maintaining data and data analytics platforms.
• Created eight OLAP cubes fromrelational data warehouse with various measures, dimensions, and business critical KPIs and representing aggregations in different ways hierarchically and using customgroupings using SSAS.
• Conducting troubleshooting on BI models.
• Develop detail and summary reports, line and pie charts, trend analysis reports and sub reports according to Bank business requirements.
• Developing visual reports, KPI scorecards, and dashboards using Power BI desktop.
• Analytical thinking for translating data into informative reports and visuals.
• Generating and delivering quality reports to customers and performing quality assurance checks on reports.
• Develop tabular and multidimensional models that are compatible with data warehouse standards.
02/2019 - 08/2022 Khartoum, Sudan
• Developed advance pl/sql packages, procedures, triggers, functions, indexes and collections to implement business requirements.
• Involved in continuous enhancements and fixing of core banking system problems.
• Conduct code reviews and participate in technical design;
• Analyze complex business problems, track down required information, document requirements, and develop technical solutions;
• Establish and enforce quality, security, and compliance requirements;
• Develop business applications using Oracle, PL/SQL, HTML and UNIX;
• Resolves complex software compatibility and interface design considerations;
• Researches and integrates design strategies, product specifications, development schedules, and user expectations into product capabilities.
• Oracle database troubleshooting.
• sql queries (Excellent).
• PL/sql scripting.
• Enhance and maintain the core banking system.