It looks like you are in United States. Would you like to go to https://onsiter.com/us/ instead?
Might be available
(Updated 2024-01-26)Senaste uppdrag
Stockholm, Sverige
Native Svenska, Persian (Farsi), Fluent English
- Microsoft BI stack
- Analys av affärsverksamhet
- Business Intelligence
Skills (63)
SQL
AI
Business Intelligence
Crystal Reports
Systemutvecklare
DATABASER
DESIGN/UTVECKLING
DATABAS
Power BI
INTEGRATION
data
VISUAL STUDIO
SSRS
Business
SSIS
DW
BI-utveckling
Dimensionsmodellering
PowerBI
Data Warehousing
EXTRACT, TRANSFORM OCH LOAD
Analytics
MS SQL Server
Data Warehouse
Technical Understanding
Jira
LAGRADE PROCEDURER
Microsoft Power BI
SSAS
BI
VISUALISERING
Azure
Developer
ELT
ETL
pipelines
Datamodellering
PROJECT MANAGER
VERKTYG
Master Data Management
affärsanalytik
UPPGIFTER
MODELLER
PL/SQL
Oracle
KUNDTJÄNST
STATISTIK
DATA SERVICES
MDM
EKONOMI
Stakeholder Management
SPSS
Qlik
HANA
Python
DRIVLINOR
MILJÖ
Forms Pro, visualisering
SVETSNING
CRM
LOADER
OLIKA TEAM
RECEPTIONEN
Professional Experience
Consultant
Eget företag
2002-01 - Present
Developed a sale support application, e-commerce (R3/SAP and C++)
Developed small projects in e-commerce, member register, .Net
Participated in implementation of a member register, Business Objects
Implementation in Microsoft development tools and Crystal Reports (BI applications)
Business Intelligence/Financial reports (Business Objects / Cognos)
Developed small projects in e-commerce, member register, .Net
Participated in implementation of a member register, Business Objects
Implementation in Microsoft development tools and Crystal Reports (BI applications)
Business Intelligence/Financial reports (Business Objects / Cognos)
Software Developer
Vattenfall
2019-01 - 2020-01
(2019-2020)
Construction of a data warehouse and three Tabular AS models in Azure. Construction of several Power BI reports with integration in the web applications. The source data is retrieved from SAP. The deployment of SQL, Data Factory, AS models and Power BI is done by DevOps (including the versions handling of the code).
Techniques: Azure data warehouse, Data Factory, Analysis Sevices, Power BI, DevOps (deployment), Agile
Role: Software Developer
Construction of a data warehouse and three Tabular AS models in Azure. Construction of several Power BI reports with integration in the web applications. The source data is retrieved from SAP. The deployment of SQL, Data Factory, AS models and Power BI is done by DevOps (including the versions handling of the code).
Techniques: Azure data warehouse, Data Factory, Analysis Sevices, Power BI, DevOps (deployment), Agile
Role: Software Developer
Retail sales
Sats
2016-01 - 2019-01
(2016-2019)
I have developed a BI platform for analysis and data storage. PowerBI reports will replace Qlikview reports in all areas (PT training, Retail sales, Finance reports, Membership sales, etc.). Each area has its own requirements and end users.
The data store is populated using ETL processes (SSIS) each night. A tabular (SSAS) model is built each morning (for each area) and the reports run directly on the models.
I am responsible for the production of ETL, the models and reports in the mentioned areas.
I have developed a BI platform for analysis and data storage. PowerBI reports will replace Qlikview reports in all areas (PT training, Retail sales, Finance reports, Membership sales, etc.). Each area has its own requirements and end users.
The data store is populated using ETL processes (SSIS) each night. A tabular (SSAS) model is built each morning (for each area) and the reports run directly on the models.
I am responsible for the production of ETL, the models and reports in the mentioned areas.
Software Developer
HELP, Insurance company
2019-01 - 2019-01
in Norway (2019)
Construction of a data warehouse in Azure. Migration of data from different data sources (Azure databases, On-prem databases and flat files from FTP) to a data warehouse in Azure (including scheduling and tracing). Construction of the data structure for the data warehouse considering the sources and the requirements of the end users for the Power BI reports. Construction of a business model in SSAS.
I got access to a number of source databases and source files (Excel and csv files delivered on FTP). I designed entire ETL processes that loaded data from sources to the data store. I created a business model in SSAS. At the end of each ETL execution (once a day), the model was processed with fresh data. I created some reports in Power BI to end users based on data from the data store and definitions of 20's KPIs.
Techniques: On-prem databases, Azure data warehouse, Data Factory, Analysis Sevices, Power BI
Role: Software Developer
Construction of a data warehouse in Azure. Migration of data from different data sources (Azure databases, On-prem databases and flat files from FTP) to a data warehouse in Azure (including scheduling and tracing). Construction of the data structure for the data warehouse considering the sources and the requirements of the end users for the Power BI reports. Construction of a business model in SSAS.
I got access to a number of source databases and source files (Excel and csv files delivered on FTP). I designed entire ETL processes that loaded data from sources to the data store. I created a business model in SSAS. At the end of each ETL execution (once a day), the model was processed with fresh data. I created some reports in Power BI to end users based on data from the data store and definitions of 20's KPIs.
Techniques: On-prem databases, Azure data warehouse, Data Factory, Analysis Sevices, Power BI
Role: Software Developer
Software Developer
Sandvik
2018-01 - 2018-01
(2018)
Migration and construction of ETL processes from data sources to the data warehouse.
I worked in an ETL project to migrate data from source databases to a data store. The main task was that the ETL process would be incremental and cleared of duplications. I built a relational model between tables in the data store. The data store was used as a basis for a number of SSAS models.
Techniques: On-prem databases (SQL Server and APS), SSIS
Role: Software Developer
Migration and construction of ETL processes from data sources to the data warehouse.
I worked in an ETL project to migrate data from source databases to a data store. The main task was that the ETL process would be incremental and cleared of duplications. I built a relational model between tables in the data store. The data store was used as a basis for a number of SSAS models.
Techniques: On-prem databases (SQL Server and APS), SSIS
Role: Software Developer
Software Developer
Techniques
2015-01 - 2015-01
Presentation of tools for Business Intelligence, Data Quality, Master Data Management, ETL and Integration
Resale and Software Developer
Techniques
2015-01 - 2015-01
Design of ETL processes for the customer segmentation in 12 Schibsted's companies (Aftonbladet, Blocket, Prisjakt etc.). The data sources are different.
Techniques: SAP Data Services (BODS), SAP Business Objects
Techniques: SAP Data Services (BODS), SAP Business Objects
Lincube Group AB
2015-01 - 2015-01
Construction of several reports in SAP Crystal Reports. The reports were connected to the SAP application and contained statistical and analytical information.
Techniques: SAP Business Objects (Launch Pad), SAP Crystal Reports
Techniques: SAP Business Objects (Launch Pad), SAP Crystal Reports
Solution Architect / Software Developer
Ericsson
2014-01 - 2014-01
(2014)
Implementation of a customized dashboard and analytics report platform for Ericsson's external customers.
Techniques: IBM Cognos, IBM SPSS, MS SQL, Pentaho
Role: Solution Architect / Software Developer
Ericsson (2014)
Prestudy and investigation of ETL/dashboard tools from 4 vendors: SAS, SAP, IBM and Microstrategy.
Techniques: Tools from 4 vendors
Role: Solution Architect
Implementation of a customized dashboard and analytics report platform for Ericsson's external customers.
Techniques: IBM Cognos, IBM SPSS, MS SQL, Pentaho
Role: Solution Architect / Software Developer
Ericsson (2014)
Prestudy and investigation of ETL/dashboard tools from 4 vendors: SAS, SAP, IBM and Microstrategy.
Techniques: Tools from 4 vendors
Role: Solution Architect
Software Developer, Solution Architect, Tester
Folktandvården Stockholm
2013-01 - 2013-01
(2013)
Implementation of a .Net application for the economical processes.
Techniques: VB .Net 2012, SQL Server 2012, ETL (SSIS)
Role: Software Developer, Solution Architect, Tester
Implementation of a .Net application for the economical processes.
Techniques: VB .Net 2012, SQL Server 2012, ETL (SSIS)
Role: Software Developer, Solution Architect, Tester
Software Developer, Solution Architect
Axstores
2013-01 - 2013-01
(2013)
Maintenance of ETL processes to/from data warehouse and implementation of a .Net application
Techniques: Oracle PL/SQL, .Net C#, ETL (SSIS)
Role: Software Developer, Solution Architect
Maintenance of ETL processes to/from data warehouse and implementation of a .Net application
Techniques: Oracle PL/SQL, .Net C#, ETL (SSIS)
Role: Software Developer, Solution Architect
Project Manager, Solution Architect
Scandic Hotel
2013-01 - 2013-01
The ETL processes were migrated to the new version of Data Services and my mission was to validate all the processes and their results.
Techniques: SAP Business Objects (Data Services / Data Integrator)
Techniques: SAP Business Objects (Data Services / Data Integrator)
Data Services and Information Steward
Ericsson
2013-01 - 2013-01
(2013)
Prestudy and implementation of a central strategy regarding ETL, Data Quality and Master Data Manegement (MDM) within Ericsson. Data is extracted from SAP HANA into a Staging database (MS SQL Server).
Techniques: SAP Business Objects (Data Services and Information Steward), SAP HANA
Prestudy and implementation of a central strategy regarding ETL, Data Quality and Master Data Manegement (MDM) within Ericsson. Data is extracted from SAP HANA into a Staging database (MS SQL Server).
Techniques: SAP Business Objects (Data Services and Information Steward), SAP HANA
BI Expert, Solution Architect, Software Developer
Tele2
2012-01 - 2012-01
(2012)
Analysing, design and Creating of a data warehouse. The data warehouse contains the scores from Tele2 customers. Reports in IBM Cognos will show the satisfaction of the customers for different products and agents.
The goal of this project was to prepare a self-service platform for the internal users to create analytic reports and queries. The reports with business-defined alerts were supposed to trigger the issues which made the external customers unsatisfied. The customer scores and information about the telephone calls were in real time and extracted from generated log files. The data used in the reports was partly memory-based to increase the performance and access time.
Techniques: Cognos 10 (RTM), Oracle, ETL
Role: BI Expert, Solution Architect, Software Developer
Analysing, design and Creating of a data warehouse. The data warehouse contains the scores from Tele2 customers. Reports in IBM Cognos will show the satisfaction of the customers for different products and agents.
The goal of this project was to prepare a self-service platform for the internal users to create analytic reports and queries. The reports with business-defined alerts were supposed to trigger the issues which made the external customers unsatisfied. The customer scores and information about the telephone calls were in real time and extracted from generated log files. The data used in the reports was partly memory-based to increase the performance and access time.
Techniques: Cognos 10 (RTM), Oracle, ETL
Role: BI Expert, Solution Architect, Software Developer
Creating of reports for incidents and commissions in the support database
SEB Banken
2011-01 - 2011-01
The
reports are used to compare duration of each incident in different support group
reports are used to compare duration of each incident in different support group
BI Expert, Solution Architect, Software Developer
Techniques
2011-01 - 2011-01
OKQ8 / Hewlett Packard (2011)
Managing the business reports and creating new statistical reports. Working with migration from Cognos 8 to Cognos 10.
Managing the business reports and creating new statistical reports. Working with migration from Cognos 8 to Cognos 10.
Software Developer, BI Expert
Techniques
2010-01 - 2011-01
Modeling of a new history database for changes in the department Service Center.
Creating new reports for analyzing and statistical research. Scheduling of the
reports to deliver to different persons in different formats according to the requirements.
Techniques: Crystal Reports (Business Objects), Oracle, CMDB
Role: Solution Architect, Software Developer
Creating new reports for analyzing and statistical research. Scheduling of the
reports to deliver to different persons in different formats according to the requirements.
Techniques: Crystal Reports (Business Objects), Oracle, CMDB
Role: Solution Architect, Software Developer
Software Developer
SLL IT, Karolinska Sjukhuset
2011-01 - 2011-01
(2011)
Maintenance of the existing ETL processes (in SSIS) and updating the database according to the new requirements (from data sources).
Techniques:Cognos 8, OLAP-kubes, Microsoft SSIS, MS SQL Server
Role:Software Developer
Maintenance of the existing ETL processes (in SSIS) and updating the database according to the new requirements (from data sources).
Techniques:Cognos 8, OLAP-kubes, Microsoft SSIS, MS SQL Server
Role:Software Developer
Software Developer
Techniques
2010-01 - 2010-01
Modeling and designing OLAP-cubes in Microsoft SQL Server. Creating reports in Cognos 8. Statistical reports with information on Salaries, Invoices, Orders,
Customers and Staffs.
Customers and Staffs.
Creating of reports for incidents and commissions in the support database
Nasdaq OMX
2009-01 - 2010-01
The
reports are used to compare duration of each incident in different support group.
reports are used to compare duration of each incident in different support group.
Software Developer, BI Expert
Business Objects (Analytics), Web Intelligence, BMC ITSM
2009-01 - 2009-01
Updating reports in OTF (Online Trade Finance). The reports are used by end user to analyze the transactions in their account.
Techniques: Crystal Reports (Business Objects), Web Intelligence, SQL Server
Techniques: Crystal Reports (Business Objects), Web Intelligence, SQL Server
Software Developer, BI Expert
Bonnier
2009-01 - 2009-01
(2009)
Development and test of Bonnier Responsmedier Mobile Services. A web based application for sms services.
Techniques: ASP .Net C#/VB, Web Services, Crystal Reports, SQL Server
Role: Software Developer, BI Expert
Development and test of Bonnier Responsmedier Mobile Services. A web based application for sms services.
Techniques: ASP .Net C#/VB, Web Services, Crystal Reports, SQL Server
Role: Software Developer, BI Expert
Solution Architect, Software Developer, BI Expert
Silentium
2009-01 - 2009-01
(2009)
Development of the business platform. The Systemet. The application is used for the whole business area.s in the company.
Techniques: ASP .Net VB, Crystal Reports (Business Objects), SQL Server
Role: Solution Architect, Software Developer, BI Expert
Development of the business platform. The Systemet. The application is used for the whole business area.s in the company.
Techniques: ASP .Net VB, Crystal Reports (Business Objects), SQL Server
Role: Solution Architect, Software Developer, BI Expert
Solution Architect, Software Developer, BI Expert
Öhlins
2008-01 - 2008-01
(2008)
Implemented a windows application in .Net and Crystal Reports. The application was used to search components and instructions for the company products. The application was based on IFS system.
Techniques: ASP .Net VB (Windows-applikation), Crystal Reports, Oracle, IFS
Role: Solution Architect, Software Developer, BI Expert
Implemented a windows application in .Net and Crystal Reports. The application was used to search components and instructions for the company products. The application was based on IFS system.
Techniques: ASP .Net VB (Windows-applikation), Crystal Reports, Oracle, IFS
Role: Solution Architect, Software Developer, BI Expert
Solution Architect, Software Developer, BI Expert
HRG
2008-01 - 2008-01
(2008)
Responsible for the BI platform with Cognos and OLAP cubes. Implementation and maintenance of the reports in report studio.
Techniques: .Cognos 7&8, Sybase/SQL Server, OLAP Cubes, Excel
Role: Solution Architect, Software Developer, BI Expert
Responsible for the BI platform with Cognos and OLAP cubes. Implementation and maintenance of the reports in report studio.
Techniques: .Cognos 7&8, Sybase/SQL Server, OLAP Cubes, Excel
Role: Solution Architect, Software Developer, BI Expert
Software Developer, BI Expert
En fransk bank
2008-01 - 2008-01
(2008)
Participated in a financial project. Using Web Intelligence generated reports in the Business Objects playform.
Techniques: Business Objects, Web Intelligence
Role: Software Developer, BI Expert
Participated in a financial project. Using Web Intelligence generated reports in the Business Objects playform.
Techniques: Business Objects, Web Intelligence
Role: Software Developer, BI Expert
Solution Architect, Software Developer, BI Expert
Företagarna
2004-01 - 2007-01
(2004-2007)
Responsible for the BI platform with Business Objects and Crystal Reports. Implementation of the telephone application in .Net and SQL database.
Techniques: .SQL Server, ASP, ASP .Net VB/C#, CC250 (Telefoni), Crystal Reports, Business Objects, Excel
Role: Solution Architect, Software Developer, BI Expert
Responsible for the BI platform with Business Objects and Crystal Reports. Implementation of the telephone application in .Net and SQL database.
Techniques: .SQL Server, ASP, ASP .Net VB/C#, CC250 (Telefoni), Crystal Reports, Business Objects, Excel
Role: Solution Architect, Software Developer, BI Expert
Intermax
2003-01 - 2003-01
Development of an e-handel system.
Techniques: .SQL Server, ASP, Tomcat, Java,
Techniques: .SQL Server, ASP, Tomcat, Java,
Presale / Projekt Manager
Sybase
2001-01 - 2002-01
Integrated, presented and managed Sybase Enterprise Portal product, which provided secured personalized access to applications.
Developed and deployed new e-Business Application (in London).
Provided navigation to the right information, applications and processes involved in a project for a Swedish bank. Provided bank services in mobiles (cellular phones) and Palms (Ipaq).
Developed and deployed new e-Business Application (in London).
Provided navigation to the right information, applications and processes involved in a project for a Swedish bank. Provided bank services in mobiles (cellular phones) and Palms (Ipaq).
Arvid Nordquist
2002-01 - 2002-01
Employees:
EHPT (Team ledare / Software Architect)
Ericsson/Hewlett Packard
2000-01 - 2001-01
Adapted and redesigned EHPT SAFETRADER (to handle payments of goods and services securely over the Internet, SMS and WAP).
Integrated and managed APIs that support the multi-purpose payment method/protocol Jalda (transactions between Internet Payment Providers, Content Providers and End Users).
Integrated and managed APIs that support the multi-purpose payment method/protocol Jalda (transactions between Internet Payment Providers, Content Providers and End Users).
Sales and presentation methods
1995-01 - 2001-01
Network (TCP/IP)
2002 Java for mobile entity (J2ME)
2002 Java for mobile entity (J2ME)
Consultant
Tietoenator
1999-01 - 2000-01
Developed and deployed Ericsson Intranet in MS ASP and SQL Server (a database application with web interface included a mailing list and a Discussion Forum).
Developed and deployed a member register based on SQL Server and MS ASP using DHTML and VB
Developed and deployed a member register based on SQL Server and MS ASP using DHTML and VB
Sysdeco Mimer
1997-01 - 1999-01
Developed and deployed Virtual Technology Park (funded by EC to establish co-operation for software businesses in northern Europe).
Designed, developed and deployed Swedish Social Network (a database application with Internet user interface funded by EC for Swedish social home information).
Designed, developed and deployed European Information Center (funded by EC to establish a research center on Internet)
During this time I was teaching database and web application
Designed, developed and deployed Swedish Social Network (a database application with Internet user interface funded by EC for Swedish social home information).
Designed, developed and deployed European Information Center (funded by EC to establish a research center on Internet)
During this time I was teaching database and web application
Software Designer/Developer / Project Manager
Telelogic
1989-01 - 1997-01
Developed ITEX in SUN/C++ environment (the worldwide de-facto standard test environment for communicating systems which supports system design, simulation, verification and validation, test case generation and complete application generation for distributed real-time systems).
Integrated TTCN, ASN.1 and SDL in the SDT tool (the ASN.1 analysis and the test simulator for generation of complete Executable Test Suites).
Responsible for the documentation of their product
Integrated TTCN, ASN.1 and SDL in the SDT tool (the ASN.1 analysis and the test simulator for generation of complete Executable Test Suites).
Responsible for the documentation of their product
Software Project Management
1994-01 - 1994-01
Software Designer/Developer
Televerket
1988-01 - 1989-01
Developed a test tool (prototype) in Lisp with a graphical user interface based on a research report on Explorer/Xerox machines.
System Architect
Philips Elektronikindustrier
1987-01 - 1988-01
Integrerade arabiska tecken i Telex-maskiner.
Courses / Education:
Courses / Education:
Academic Background
Master
Uppsala universitet
1984-01 - 1988-01