Stefan Block Email & Phone Number

Solna, Se

Stockholm, Se

• Data warehouse design and implementation for financial reporting.• Setting up ETL flow orchestration with SSIS and Azure Data Factory.• Building SSAS tabular cubes to serve front end applications such as Power BI and Cognos Analytics.• Setting up pipelines in Azure DevOps for deployment of database code, infrastructure and web applications.• Data flow documentation and writing specification of requirements.• Coaching and training new developers.

Gothenburg, Se

• Building and expanding a Kimball data warehouse using Visual Studio and T-SQL.• Setting up ETL flow orchestration with SSIS and Azure Synapse Analytics.• Building SSAS tabular cubes to serve front end applications such as Power BI.• Designing Power BI reports and paginated SSRS reports.• Maintaining and surveying data flow processes.• Setting up automated deployment pipelines in Azure DevOps• Serving as Scrum master to facilitate agile software development in sprints.

Redmond, Washington, Us

• Conducted two major internal Power BI projects focusing on visualization of Azure consumption. Project tasks included specification of requirements, data modeling and report design. Reported to Business Area Manager in the Swedish leadership team, among others.• Conducted assorted external Power BI projects, including cohort analysis and sales reports.• Specialization within Azure Data Services with certifications such as Azure Fundamentals, Azure Data Engineer and Azure AI Engineer.• Certification as Data Analyst (Power BI).

Solna, Stockholm, Se

Completed courses:• Business opportunities in Business Intelligence• Business Processes and Definitions in Business Intelligence (Power BI, Basics of Big Data)• Dashboard Design (Tableau)• Data Capture, Migration and Processing (ETL, SSIS, SSAS, SSRS, Power BI)• Database Modelling and Design (SQL, ERD, UML, Basics in SSIS & SSAS)• Internet of Things and Cloud Solutions (Azure, Function Apps, IoT hubs & devices)• Predictive and Prescriptive Analytics (Statistics, R, Azure ML)• Programming languages in Business Intelligence (HTML, CSS, JavaScript, Python)• SQL and Hadoop (SQL, NoSQL, Pig, Hive, Hadoop)• Statistical Programming and Machine Learning (R)• Statistics and Data Analysis (Excel)• Understanding Business Intelligence (BI Architecture, IT Security, Project Management, Requirements Analysis)

Stocksund, Stockholm County, Se

• Daily scheduling and coordination of appointments for clients and hired consultants.• Planning internal workflow; managed consultant resources and delegated tasks to linguist colleagues and consultants.• Evaluated and optimized workflow routines, created and revised workflow process documentation.• Trained 3 administrative assistants during a period of company expansion.• Wrote software requirements specification, evaluated offers, and supervised integration of Excel-based billing data with Visma Administration.• Ran internal audits on a bi-annual basis of the company’s quality management system.• Prepared billing data, consultant payroll reports and key performance index reports on a monthly basis.• Handled both internal + external IT queries and IT troubleshooting.

Higher Vocational Education Programme, Business Intelligence Analytics

Bachelor Of Arts, Computational Linguistics

Undergraduate, English, Linguistics

Certified Internal Auditor