business intelligence bi consultant
Nittaq for information technology
مجموع سنوات الخبرة :7 years, 2 أشهر
Developed, identified, designed, built, tested, optimized, and maintained a
Data Warehouse and OLAP Cube using the entire Microsoft BI.
• Contracted during the design phase of the project to help complete the
redesign of end client SQL Server 2017 Data Warehouse.
• Created Star Schemas for BI applications.
• Created eight OLAP cubes from a relational data warehouse with various
measures, dimensions, and business-critical KPIs and representing
aggregations in different ways hierarchically and using custom groupings
using SSAS.
• Developed reports interactive business and with drill-down abilities reports
using Microsoft SQL Server
• Reporting Services SSRS based on existing data sources.
• Wrote TSQL and MDX queries in support of reporting and analytic solutions.
SSIS to extract data from Access, Seibel, and Excel forms to perform
the transformation, cleansing, and loading into the data warehouse.
• Created OLAP cubes from the relational data warehouse to develop
measures, dimensions, and business-critical KPIs
• and represent aggregations in different ways - hierarchically and using
custom groupings using SSAS.
• Provided the application analyses, data modeling, metadata management,
and integration testing functions for existing applications and the new
performance assessment and invoice visibility applications.
• Created MDX queries according to business requirements.
Communicating with business users to deliver reports and other user
interfaces that drive business value and efficiently and effectively leverage
the use of data.
• Provided input to technical solutions in architecture meetings determining
project scope, tasks, timeframe, and resources to provide project estimates
for the BI Team Lead.
• Interaction with a variety of internal and external users to develop technical
designs and reviews with the rest of the project team as appropriate.
• Wrote T-SQL for the retrieval of the data. Identified the Data Sources and
defined them to build the Data Source Views.
• Developed a Query for generating drill-down reports in SSRS 2017.
• Created List reports, Cross-Sab reports, and different types of charts like
Column charts and Bar charts.
• Assigning different access permissions and security levels for the reports in
SSRS for various levels of users.