IT-Entwickler/in

Getting Requirements from client and creating reports and dashboards
Creating Environments
Deploying the reports in Production and QA and Development
Creating content packs
Scheduling for Refresh data
Writing SQL queries based on the requirements
Creating schemas accordingly
Dax Expressions for Calculations and Schema Design

With Power BI Desktop, create own reports based on data from a wide variety of sources. Import data from on-premises sources such as SQL Server, SharePoint files and lists, Analysis Services, and other enterprise data solutions, or SaaS sources like Dynamics CRM, Salesforce, and Google Analytics. Reshape and model this data easily with the Power BI Desktop, to meet your analysis and reporting needs.

Architecture and design
A solution architect has overall responsibility for all architecture and design. This includes responsibility for data warehouse design and providing technical direction to data modelers, data analysts, data integration architects, data integration developers and database administrators. This includes: Data architecture;
Data warehouse operations management including:
Physical data base design, including
 Star schema and data mart design;
 Snowflake schema design;
 Change data design, including slowly changing dimensions
 Operational data store design;
 Defining database development software;
 Specifying business intelligence architecture;
 Database normalization;
 Database partitioning;
 Data aggregation;
 Data base management solutions;
 Data conversion solutions and Database design documentation.
Environment: Power BI, SQL Server, SSIS, SSAS, SSRS, MDX

• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler
• Experienced in programming tasks-Stored Procedures, Triggers, and Cursors using SQL Server 2008/2012 with T-SQL.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Expertise in generating reports using SQL Server Reporting Services.
• Expertise using Excel, Power Pivot Reports and Drill Through Dashboards using Warehouses and OLTP Connections.
• Expertise in Proactive Caching Degenerated Dimensions and Tabular Data Modeling for Moderate to Large Data Systems.
• Working on SQL Server (2008&2012) Analysis Services.
• Creation of data sources and data source views in SSAS.
• Knowledge on writing MDX queries.
• Creation of cubes and modifying measures and attributes, creating hierarchies and relationships among dimensions and facts.
• Implemented checkpoints at package level.
• Created calculated measures and members in calculations, KPIs, Partitions.
• Have worked in multiple projects as BI Developer in Designing ETL Packages and reports in development and implementation stages of the Project according to client requirements.
• Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, FTP Task and Data Flow Task in Designing packages.
• Proven proficiency at Data Transformations like Lookup, Derived Column, Conditional Split, and sort, data Conversion, Union All, Merge Join, SCD and OLEDB Command to load data into SQL Server destination.
• Maintaining the Log and Audit information in the SQL tables.

Anderes Zertifikat

–

–

–