SQL / Power-BI / Power Apps udvikler

Project name Building KPI Dashboard

Project Integrating data and building KPI Dashboard in PowerApps for mobile devices to
description track KPI results

Technologies SQL Server, T-SQL, PowerApps, AWS

Role & Team Business Intelligence Developer, 1 people
size

Responsibilities • Creating object to store data required for the report
• Creating procedures to load source data from AWS S3 bucket to SQL Server
instance
• Creating SQL Server Agent job to periodically execute load process
• Preparing PowerApps mobile app to display required set of data
• Preparing documentation
Time frame 3 months


Project name Data warehouse for Insurance company

Project Creating logical and physical data warehouse model to deploy on SQL Server
description database.

Technologies SQL Server, T-SQL, Visio

Role & Team Physical Data Architect, 3 people
size


1


www.softwarehut.com
Responsibilities • Analyzing source database, application and gathering business requirements
• Creating physical model for the new Data Warehouse and Data Mart
• Preparing graphical diagrams to represent the Data Warehouse model
• Preparing mapping between database and new Data Warehouse
• Generating DDLs to create physical model on database
• Designing and generating Indexes and Constraints
• Preparing documentation
Time frame 4 months

Project name Reports migration

Project Migrating reports from Oracle Hyperion to SQL Server Reporting Services
description
Technologies Microsoft SQL Server, T-SQL, SSRS, Oracle Hyperion

Role & Team BI Developer, 1 person
size

Responsibilities • Analyzing Oracle Hyperion existing reports
• Rewriting existing and creating new reports on SQL Server Reporting Services
• Configuring, customizing and branding SSRS Server


Time frame 3 months

Project name Building Data Warehouse for Insurance company

Project Project focused on creating new data warehouse for insurance company,
description migrating data from the soure system and building reports to display needed
data

Technologies Microsoft SQL Server, T-SQL, SSRS, SSIS, Git, VSTS

Role & Team T-SQL Developer, ETL Developer, Reports Developer, Team Leader, 6 people
size

Responsibilities • Creating a new Data Warehouse
• Writing T-SQL procedures and SQL queries
• Implementing ETL processes using SQL Server Integration Services (SSIS)
• Preparing reports using SQL Server Reporting Services (SSRS)
• Preparing code deployments
• Preparing documentation


Time frame 2 years

Project name BI Support for recruitment service company

Project Helping with preparing data for sales division, management and creating new
description reports to monitor sales and support decision making


2


www.softwarehut.com
Technologies Microsoft SQL Server, SSIS, SSRS, Tableau, Git, Jira

Role & Team BI Developer, 3 people
size

Responsibilities • Writing T-SQL procedures and queries
• Creating reports in SQL Server Reporting services and Tableau desktop
• Preparing data analysis
• Implementing new data warehouse and reporting services


Time frame 2 years

Project name Data migration for Insurance company

Project Migrating data from various sources to the destination Oracle system
description
Technologies Oracle, Microsoft SQL Server, SSIS, SSRS, SVN

Role & Team ETL Developer, 6 people
size

Responsibilities • Implementing ETL processes for client's insurance systems
• Writing PL/SQL and T-SQL procedures
• Writing SQL queries
• Implementing ETL processes using SQL Server Integration Services (SSIS)
• Designing and Implementing process to load huge amount of data into SQL
Server database (SSIS + Bulk Insert + SQL Server Agent)
• Preparing reports using SQL Server Reporting Services (SSRS)
• Preparing documentation
• Data Mining
• ActiveBatch - Tasks management


Time frame 3 years 6 months