Fridthjof G Eriksen

Mobile B2B applications

Android and IOS

Owner

Development Manager for the Server side of Numo (formerly known as Mobile Nordic AS) service offerings.

Manage internal and external development resources.

Chief Architect for a highly scalable mobile VAS platform.

Took the entire platform from serving a thousands of users daily up to 3.8 Million in the course of 2 years, using tools such as NLB, ARR, WFF 2.0 and various caching strategies, taking an IIS hosted solution to the very max of what it can deliver on scalability and fault tolerance.

Reduced error rates within the platform with unprecedented numbers, while improving latency and cuncurrency.

Streamlined development process, implementing an Continuos Integration workflow, later Continuos Deployment (using Thoughtworks Go).

Architect for, and managed migration of existing platform from .net 1.1, asp.net and rpc style POX to .net 4.0, WCF and a RESTful API. Extended API for 3rd party integration for Presence and Location Data.

Designed an synchronization protocol and api for use in automatic seamless cloudbased backup solution for mobile handsets (using Azure).

Lead technical Consultant for highly specialized BI company, working primarily in the CPM area, using Performancepoint Server and the rest of MS BI stack.

Technologies used: MS SQL, Reporting Services, Analysis Services, Sharepoint, Performancepoint and related software.

Assist in daily operations of hundreds of systems utilizing thousands of SQL Servers for clients such as DNB Nor, Storebrand, Telenor, etc.

Patching and maintaining individual Server Instances (hotfixes, servicepacks etc).

Operational responsibility for a TB+ sybase archival system.

Operational resposiblity for a sybase replication setup spanning Oslo, London, New york and singapore.

Implement CA monitoring, including setting standards for metrics, threshold values across customers and systems.

Assist in daily operations of Reconciliation System, used to detect leakage in Billing (Revenue Assurance).

Implement configuration and schema changes as required.

Develop new reconciliation jobs and controls.

Assist in daily operations of 80+ systems utilizing hundreds of SQL Servers for Jyske Bank and Nykredit.
Several clustered servers and SAN
Implement configuration and schema changes as required.
Setup, configure and troubleshoot Replication among multiple nodes (cross domain/dmz etc).
Patching and maintaining individual Server Instances (hotfixes, servicepacks etc).
Create database coding guidelines utilizing best practices for indexing ,common coding, error handling etc for internal development dept.

ETL Quality Assurance.
Informatica PowerCenter development.
Oracle/unix shell scripting.
Billing system migration support to Kenan BP for Polands former national Carrier.
Identifying data Mapping, Conversion and Load errors.
Identifying data Kenan configuration errors.
Detailed analysis of migration issues found/reported by other project members.

Modeled schema for a new complete convergent telecom platform
Programmed interfaces, and designed large parts of the Data Access Layer for 3rd party integration with various CRM and other systems.
Optimized and reviewed other developers code.
Major SME contributor to the platforms architecture.

The database solution FGE built for this platform includes:
- log shipping
- logical/physical portioning
- merge replication
- a custom built db based, xml versioning system
- extended procedures for asynch. soap calls
- integrated error handling with ms sql
- stored procedures galore
- udf, udt, views, triggers
- sqlxml
- internal background processes
- custom trace events for profiler etc, etc.

Consolidation of database backup routines.
Installation, configuration and scripting of SQL Litespeed Backup software
Reduced Maintenance Window with some ~200 percent.

Stabilized ETL packages (DTS) used for load of usage data (CDRs etc) to ODS and Statistical systems.
Enhanced data availability for reporting from 1 hour to 15 minutes
Reduced errors in the ETL processes with ~300 percent
Reduced recovery time after error from 60 minutes to 5.


Coaching and guiding operational database and backup staff.
Active participation in operations in regards to advanced troubleshooting/recovery processes, large scale schema deployments/migration across all countries, etc.
Continuously improve/extend functionality and performance/availability for existing systems.

Reviewing all existing SQL Server installations, configurations, security, backup/recovery , maintenance guidelines and operational routines.
Create a common, company wide standard for backup/recovery, maintenance, reporting and auditing jobs and operational processes.