Senior Analyst BI & Data Management Analyst
Tamkeen technology Company
Total des années d'expérience :7 years, 4 Mois
- Consolidated financial information (revenue, profit, expense, and vat) from several products into a centralized DWH and created a PowerBI dashboard for top management.
- Developed an HR and financial Power BI dashboard for the company executives fed with live data by the ERP system.
- Developed Musaned and Ajeer operational and management Power BI dashboards.
- Developed custom data quality solution to measure the quality of all product data managed by the company following the DAMA Framework best practices using SSIS and Power BI.
- Writing and maintaining ad-hoc reports by using and optimizing advanced SQL queries on SSRS, MSSQL, MySQL, and PostgreSQL.
- Developed and maintained several ODS, DWH, and Data Marts for a number of internal and external products using SSIS and SSAS.
- Adding dimension or fact tables into existing DWH or Data Marts and maintaining SCD types on SSIS and SSAS.
- Work on cleansing and enrichment of HRSD master data for several products. Installing and configuring
- Hortonworks big data platform on 10 nodes (Ambari, Yarn, HBase, Spark, Superset, and Hive)
- Administrate SQL version from SQL 2008R2 - 2017.
- Implement and configure high availability solution.
- Implement and configure SSRS, SSAS, and SSAS.
- Build cluster 2 nodes and 3 nodes with active-active and active-passive. Troubleshoot database issues and performance issues.
- Design a backup and restore strategy.
- Support projects in new implementations and upgrades.
- consolidating SQL server databases.
- Implement changes to current databases.
- Upgrade and migrate SQL Servers.
- Work extensively on writing stored procedure, trigger, function, and view.
- Installation, Administration and Maintenance of SQL Server 2012 - 2016.
- Manage 120+ MSSQL servers on the virtual and physical environment.
- Create and configure linked servers.
- Develop scripts to automate the job. (T-SQL & PowerShell)
- Troubleshoot database issues.
- Implement changes to current databases.
- Consolidate SQL databases.
- Scanning and fixing third party vulnerabilities of SQL servers.
A general program that focuses on computers, computing problems and solutions, and the design of computer systems and user interfaces from a scientific perspective. Includes instruction in the principles of computational science, and computing theory; computer hardware design; computer development and programming; and applications to a variety of end-use situations.