monstershoogl.blogg.se - Sql business intelligence development studio 2014

SQL BUSINESS INTELLIGENCE DEVELOPMENT STUDIO 2014 CODE

Experienced wif adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.

Created and deployed SSRS Reports from SSAS cubes and various data sources on the portal for the user accessibility.

Experienced in logical, physical, and dimensional data modeling, data mapping, and data normalization, Proficient in creating Transact-SQL (DDL, DML, DCL and TCL), Indexes, Views, Table Variables, Complex Stored Procedures, User and System defined functions.

Experience in Creating Power BI Data Flows which work on Azure Cloud platform for the Power BI reports.

Extensively worked wif Team Foundation Server, Azure Devops and Share Point Server and successfully deployed various reports to the share point server.

Expert in creating the MDX queries to access cubes and dimensions (SSAS).

Experience in creating and managing SSAS Tabular models, creating Dimension and Fact Tables.

SQL BUSINESS INTELLIGENCE DEVELOPMENT STUDIO 2014 CODE

Experienced in writing VB.net, C#.net code for SSIS packages.Resolved SQL Reporting services issues and Proficiency in creating different types of reports such as Cross - Tab, Conditional, Drill-down, Summary, Form, OLAP and Sub reports, and formatting them. Sound Experience and understanding of SSAS, OLAP (MOLAP, ROLAP, HOLAP) cube and Architecture. Developed reports on SSAS & SSRS on SQL Server and Oracle.

Expert in SQL Server OLAP database development including KPIs, Data mining, working wif slowly changing dimensions.Experienced in using transformations like Aggregate, Lookup, Data conversion, Merge Join.Experienced in creating Jobs, Alerts, SQL Mail Agent, and scheduling DTS Packages.Experienced in various Extracting, Transforming and Loading (ETL) tasks using SSIS including tools like BCP utility, DTS and SSIS Packages wif proper control & data flow elements.Experienced in SQL Server DTS and SSIS (Integration Service) package design and deployment.Strong technical noledge in MS SQL Server development including Integration Services, DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases, Troubleshooting, Maintaining the Backup, and Recoverability.Created security access for the reports that are deployed to Power Bi Portal. Experienced in using DAX for building Power BI reports.

Created Power APPs wif APP Navigations for the Power BI reports. Experienced in creating aspx pages wif the Embedded Power BI Reports that are deployed on the Power bi Portal.Experienced in using POWER BI tool for creating Dashboards and Paginated reports.Highly experienced in MS SQL Server 2019/2017/2016/2014/2008/2005 wif Business Intelligence in SQL Server Reporting Services, SQL Server Analysis Services and SQL Server Integration Services.Experience wif the complete systems development lifecycle process.Over 10 years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment).