Agnor Pettersen

• Development and implementation of a leading cloud based tax service
• Data engineer role: Developing data pipelines and ingestions from various sources
• Architect role: Making the total data / tech architecture 
• Participating with developers making utilization of modern technologies, including NET
  framework and Blazor to build robust solutions back end and front end for one of the projects
• Tax Advisory for customers within topics as wealth management, tax strategy, declaration
  and complaints to tax authorities.
• Tech stack: Azure, Databricks, SQL, dbt, python

• Development of IT systems with a primary focus on data management, data pipelines and arhitecture
• Design and implementation of tailored technological solutions to meet unique customer requirements for small and mid size businesses
• In house advisory from data products and architecture of data strategy and implementation
• Collaboration with multidisciplinary teams (business, tech, sales) to deliver scalable and efficient IT solutions within specified timeframes.
• Tech stack: Azure, micro services, Azure SQL, fabric, dbt, medallion arhitecture 

• Development of IT systems with a primary focus on data management, data security, and GDPR compliance for clients.
• Design and implementation of tailored technological solutions to meet unique customer requirements.
• Analysis of customer operations to identify opportunities for system improvements and secure handling of sensitive data.
• Consulting on GDPR-related matters to ensure full alignment with legal regulations and industry standards.
• Collaboration with multidisciplinary teams to deliver scalable and efficient IT solutions within specified timeframes.
• Delivery of high-quality documentation and recommendations related to technical architecture and security protocols.

• Lead responsibility for key areas within the on-premises data warehouse for Fremtind Forsikring, including further development of masking functionality to safeguard sensitive personal data (code 6/7). Managed automation and development tasks related to handling source data, file transfer techniques, file ingestion functionality, and other automated processes.
• Provided solution oversight for sales reporting and claims processing for the company's life insurance license. Conducted detailed analyses of data impacts and flows as part of preparations for migration to a cloud data warehouse. Delivered impact assessments regarding decommissioning parts of on-premise solutions in favor of cloud alternatives.
• Developed tailored reports to showcase both opportunities and limitations in the existing data warehouse architecture while ensuring alignment with business needs. Technical analyses required in-depth knowledge of architectural structures, system dependencies, overlapping systems, and identification of elements requiring redevelopment during migration.
• Demonstrated expertise in advanced SAS coding techniques, including efficient use of SAS Macro language features such as hash objects, loops, macro variables, arrays, and system functions. Peer-reviewed team members’ code with a focus on quality assurance, improving efficiency and readability while maintaining accountability through production-level testing.
• Played an instrumental role in ensuring high standards for data security and privacy compliance (e.g., GDPR). Contributed substantially to initiatives involving improved masking processes for sensitive customer information and ensured robust storage and reporting mechanisms aligned with legal requirements.
• Supported technical troubleshooting efforts across the team by providing analytical assistance during error resolution or solution assessment phases. Collaborated closely with stakeholders using tools like JIRA for task management and Confluence platforms for documentation sharing within a Continuous Delivery environment leveraging SAS technologies
• Tech stack: SAS9.4, SAS DI Studio, SQL

• Enhanced functionality in an Oracle-based data warehouse, focusing on data quality and unified dimensions across a large staging area, central data warehouse (EDVH), and various business area marts.
• Developed and tested ETL solutions using Oracle SQL Developer, including creation of logical objects, database links, as well as analysis and preparation of metadata.
• Designed and optimized new mappings in Oracle Data Integrator (ODI) to improve data integration processes.
• Facilitated the integration of new data sources into the data warehouse infrastructure, handling formats such as JSON, XML, flat files, and Oracle databases.
• Maintained technical solutions for configuration management and environment monitoring with tools like Jenkins; implemented scripting in PowerShell and Bash for task automation.
• Documented ETL processes thoroughly via platforms like Confluence to ensure accurate sharing of solutions and promote knowledge transfer across teams.
• Tech stack: Oracle SQL, Oracle ODI, SQL

• Ensured seamless data flow into Snowflake-based databases and optimized processing of extensive datasets using JSON and SQL.
• Developed and implemented technical logging mechanisms for ElasticStack to enhance data tracking and management workflows.
• Monitored server cluster resource usage on Microsoft Azure to prevent overloading, ensuring system stability and efficiency.
• Automated logging and monitoring processes to mitigate service latency and downtime, leveraging PowerShell, Bash scripting, and relevant technologies.
• Utilized ElasticStack (Logstash, FileBeat, ElasticSearch) alongside visualization tools like Kibana for advanced analytics and reporting.
• Collaborated within a multidisciplinary team of Java, Python, and SQL developers to drive solutions aligned with DevOps practices.
• Tech stack: Elastic, Snowflake, Azure, SQL

• Contributed to the improvement of data quality in the financial reporting and credit scoring systems for Sparebanken SØR, Helgeland Sparebanken, and Sparebanken Sogn og Fjordane.
• Supported the development and enhancement of a SAS-based data warehouse solution aimed at building a Credit Score system for banking operations.
• Assisted in optimizing capital efficiency by enabling a larger loan portfolio with reduced capital requirements per loan volume.
• Collaborated with stakeholders from Sparebanken and Capgemini, ensuring alignment on project deliverables, technical development, and strategic goals.
• Provided support for technical maintenance, development tasks, and project management as part of an integrated team delivering solutions in partnership with SAS.
• Played a key role in the successful delivery of improved data infrastructure to support enhanced decision-making and risk management capabilities within the banking sector.
• Tech stack: SAS, SQL

• Conducted data analysis for various sub-projects, addressing client needs such as data visualization, analysis, and general data quality improvement.
• Developed and maintained ETL processes using SQL and SAS to automate quality assurance tasks, including cleansing and classifying email addresses with regex to reduce bounce rates.
• Built a white-list and black-list database to enhance email reputation management, resulting in fewer bounced emails, increased delivery rates, improved response rates, and better data quality.
• Designed Power BI dashboards using GUI and DAX code to monitor customer service efficiency and queue status.
• Optimized SQL databases and queries to enhance performance for analytical operations while generating reports based on underlying datasets.
• Implemented API testing processes utilizing XML and JSON formats via tools such as Postman to ensure proper integration of multimedia project components like audio file analyses (e.g., radio listening tests, music evaluations).
• Tech stack: SAS, SQL, Power BI

• Conducted comprehensive analysis of customer turnover and policy renewal processes for VIP clients, leveraging SAS Studio, QlikView, and MS Excel to assess trends and correlations.
• Provided data-driven insights and recommendations to decision-makers on optimizing business outcomes with a price-service perspective.
• Analyzed insurance tariffs and their market positioning relative to competitors across various insurance products, identifying opportunities for adjustment and enhancement.
• Performed qualitative research on customer departure causes, compared customer actions with prior communication to customer service, and developed predictive indicators for churn likelihood.
• Delivered high-quality advisory services to customers eligible for specialized treatment based on policy size and product portfolios during the main billing cycle.
• Supported headquarters as an analyst by collecting and analyzing data related to INSR ASA operations as well as competitor activities, utilizing tools like SAS Studio, SQL, Microsoft Exchange, and QlikView for efficient decision-making support.
• Tech stack: SQL, SAS, Qlikview

• Provided on-site installation and configuration of both software and hardware for sensor systems, ensuring efficient functionality across varying environments.
• Conducted data processing and sensor data analysis to generate actionable insights and produce comprehensive reports for diverse industry applications.
• Performed extensive analysis of potential customer cases to identify opportunities for improving efficiency and service delivery.
• Automated customer screening processes to streamline operations and enhance decision-making accuracy.
• Utilized Microsoft Excel to perform data analyses, calculations, and reporting essential to project objectives.
• Supported system troubleshooting, repairs, and maintenance for temperature, sound, air, and other specialized sensors deployed across various industries.

• Delivered 2nd-line IT support for both internal and external stakeholders, ensuring the resolution of technical issues related to financing applications and broader system infrastructure.
• Managed user administration tasks, including account creation, permissions, access control, and security configuration using tools such as Active Directory, AdminControl, and Citrix Management Console.
• Oversaw incident management processes through Support Point, addressing and resolving technical incidents efficiently to minimize service disruptions.
• Handled internal worldwide servicedesk operations (1st-line support) with a focus on technical troubleshooting for financial applications and general IT inquiries across global locations.
• Maintained systems and services including MS Exchange, Windows Server environments, Microsoft 365 applications, Jira platforms, SharePoint sites, and other enterprise-level technologies.
• Tech stack: Support point, Citrix, AdminControl, Windows Server, VMWare, AD

• Delivered specialized IT support for residential customers through TelenorNorge's premium on-demand service, Telenoreksperten, addressing a variety of hardware, software, and IT-related issues.
• Utilized internal Telenor systems for billing management, product handling, and core-level customer and product management to ensure streamlined service delivery.
• Provided remote support using LogMeIn software to troubleshoot and resolve complex issues efficiently.
• Conducted advanced technical advising as 2nd-line support, specializing in network equipment configuration and troubleshooting.
• Performed system recovery procedures for various operating systems, including OS X, iOS, Android, Windows XP, Windows Vista, and Windows 7 to restore device functionality.
• Executed data recovery operations to retrieve lost or corrupted files with precision and security compliance.

• Provided first-line customer support and advisory services, ensuring optimal resolution of client inquiries and issues.
• Addressed technical challenges related to PSTN, ISDN, IP telephony, internet lines, DSLAM systems, and fiber note troubleshooting.
• Utilized Siebel CRM systems efficiently for managing customer interactions and maintaining accurate records.
• Diagnosed and resolved network-related problems using ERX technology and associated tools to minimize disruptions.
• Assisted both private and industrial clients with diverse telecommunications needs, contributing to enhanced service delivery.
• Supported Telenor’s role as Norway's leading mobile data provider by delivering high-quality customer care solutions.

NTNU Bachelor 2009 - 2012

Trade and Technology management