Business Intelligence Developer
Jadara Solutions
مجموع سنوات الخبرة :6 years, 10 أشهر
Created SSIS package to load data from Excel Files to SQL Server.
• Designed, Developed, and Deployed reports in MS SQL Server environment using SSRS.
• Generated Sub-Reports, Conditional, Drilldown reports, drill-through reports, and parameterized reports using SSRS.
• Created reports to retrieve data using stored procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Involved in creating views, stored procedures, and custom SQL queries to import data from the SQL server to PowerBI.
• Reviewed SQL queries and edited inner, left, and right joins in Power BI by connecting live/dynamic and static datasets.
• Analyzing Reporting requirements and translating them into data sourcing and modeling requirements including Dimensional and normalized data models, Facts, Dimensions, Star Schema, Snowflake Schema, Operational Data Stores, etc.
• Creation of database objects like tables, views, materialized views, procedures, and packages using MSSQL.
(Outsourced).
1- Power BI: Imported data from SQL Server DB to Power BI to generate reports, Created Dax
Queries to generated computed columns in Power BI, Generated computed tables in Power
BI by using Dax., Creating Database objects - tables, views, functions and developing
procedures for implementing application functionality at the database side for performance
improvement, Involved in creating new stored procedures and optimizing existing queries
and stored procedures.
2- Lineage: As part of Data Quality analysis: Traced Data Lineage of data elements to be used in
the ADS, Identification of a Level 1 data source at attribute creation and subsequent levels,
Identification of a Level 1 data source based on attribute updates during the data life cycle,
Trace current daily staging-library collection of data, ETL transformations.
• Project #6
Clint: STC (Outsourced).
Create MicroStrategy reports and dashboards, Created the application objects(filters metrics, and prompts), Developed the Reports as per the Design Documents, Performed the report data manipulations using various options like(page by, sorting, totals, thresholds, etc., ), Created View filters, Report Limits on the report data, for ERP and CRM and OLAP and more projects.
• Project #5
Clint: Qassim Project.
Designed Power BI data visualization utilizing cross tabs, maps, scatter, pie, bar, and density charts and ETL implementation using SQL Server Integration Services SSIS, Reporting Services SSRS.
• Project #4
Clint: Royal Commissionin Jubail (Outsourced).
Create MicroStrategy reports and dashboards, Created the application objects(filters metrics, and prompts), Developed the Reports as per the Design Documents, Performed the report data manipulations using various options like(page by, sorting, totals, thresholds, etc., ), Created View filters, Report Limits on the report data.
• Project #3
Clint: GAZT (Outsourced).
Refreshment of Tableau server dashboards, Insure that all data sources refreshed on daily bases in planned times, Manage and monitor the storage utilizations, Monitor, manage and control the servers (application), Manage the upgrading tableau servers tasks, Deal with operation team notifications about the servers size and memory consuming.
• Project #2
Clint: NIC (Outsourced).
Installed Tableau Server and Publish Dashboards onto Tableau Server.
• Project #1
Clint: University of Prince Sattam.
Fetching data from Twitter and Reporting & Visualization (Big Data
Streaming).
Modern Academy For Computer Science And Management Technology
لقد تم حذف الرابط بسبب انتهاكه لسياسة الموقع. يرجى التواصل مع قسم الدعم لمزيد من المعلومات.