Description: Works as a solution architect for data driven applications. Data modelling, requirement gathering, standards for development, documentation and architecture have been core interest areas. Implementing data solutions for different needs.

Projects:

• Statens Vegvesen: Analysis of architecture and solution requirements, data
  modelling, systems architecture, solution description and creation of
  design principles and methodology. Planning and estimating of solution.
  Implementation of data model, metadata semantic layer and some ETL and
  PL/SQL programming. Reporting on the car stock of cars within Norway,
  and their owners, as well as reporting on drivers licenses and actions
  takens within the organization to deal with seized licenses, newly
  acquired specializations and education thereof, car ownership changes
  and so on. Main Toolset: Oracle Business Intelligence Enterprise
  Edition, Oracle 11g, SAP Business Objects Data Services.
• Forskningsrådet: Analysis of architecture, restructuring and reimplementing solution based on webservices and simplifying the data using Informatica Powercenter. Complete redesign of solution to make it easier to maintain.
• RiksTV: Restructuring and reimplementing solution using ELT – more database driven transformation and moving of data with all the complexity stored in views and the ETL tool only handling the orchestration and generation of simple merge statements to insert the data. Creating analysis for shopping cart data (if two items are bought shortly after eachother, assume they’re part of the same shopping cart). After this, using the data to extract into a CRM tool (adobe campaign) for marketing purposes.
• Norgesgruppen: Integrating with SAP CRM to extract data for marketing purposes (SAS CI). Creating analysis tables with predefined analysis over shopping patterns.
• SpareBank 1: Integrating with data warehouse to extract data for marketing purposes (SAS CI). Creating analysis to be able to identify when a customer actually became a customer even considering gaps in the customership.
• LOFavør Medlemskort: Restructuring and reimplmenting a customer database using file imports from the different unions in LO.

Description: Worked as a Business Intelligence Consultant, focusing on Data Integration through ETL tools, data warehouse architecture, Business Intelligence project delivery methodology (agile), data modelling (3NF and Star Schema modelling), SQL implementation and optimization, and PL/SQL programming as well as report building and metadata structure configuration.

Projects:

• Toll Og Avgiftsdirektoratet – TRL – Feb 2011 –  Nov 2011. Maintenance of existing solution, development of ETL and reports, as well as testing and configuration of new systems infrastructure (new versions of all tools and software). Reporting on customs and other fees required for payment of import and export of goods, as well as reporting on car fee payments and customs seizures of smuggled items. Main Toolset: Informatica Powercenter, Sybase 15, SAP BusinessObjects
• Statens Vegvesen – Autosys – Nov 2011 – Dec 2012. Analysis of architecture and solution requirements, data modelling, systems architecture, solution description and creation of design principles and methodology. Planning and estimating of solution. Implementation of data model, metadata semantic layer and some ETL and PL/SQL programming. Reporting on the car stock of cars within Norway, and their owners, as well as reporting on drivers licenses and actions takens within the organization to deal with seized licenses, newly acquired specializations and education thereof, car ownership changes and so on. Main Toolset: Oracle Business Intelligence Enterprise Edition, Oracle 11g, SAP Business Objects Data Services.

Description: Worked mainly as a Business Intelligence developer, focusing on data integration with ETL tools like Informatica PowerCenter or SAS Data Integration Studio, data warehouse implementation architecture through Oracle databases and reporting with Siebel Analytics and SAP Buisiness Objects.

Projects:

• Telenor Wholesale – Jara NetBusiness – Feb 2007- Mar 2008. Report and ETL development for a CRM solution focused on orders and order tracking, SLA-fulfillment, Service Request reporting and similar reports. Main Toolset: Siebel Analytics, Informatica PowerCenter and Oracle 9i.
• Hjemmet Mortensen – Abonnement – May 2008 – Dec 2008. Report and ETL development for a magazine subscription department at a major magazine publisher, focusing on churn prediction of subscription holders, and reporting on circulation and sales. Main Toolset: SAS Data Integration Studio, SAS Report Studio, SAS Olap Studio and MS SQL Server 2008.
• Telenor Mobil – Telenorkunden – Jan 2009 – Nov 2010. Customer Centric Datawarehouse focused mainly on subscriptions and customer interactions with customer service, enabling tracking of all contact points a customer has with the company (including agreements, invoices, subscriptions for private and corporate phones, internet services and landlines).ETL and PL/SQL development of data integration and support-software. Main Toolset: Informatica PowerCenter, Oracle 10g, SAP Business Objects.

Classroom-based teachers assistant at the university with focus on guidance, correcting mandatory assignments and hold lectures explaining the assignment solutions.