Name: Tjernström, Magnus
Address: <request by e-mail>
Stockholm
Sweden
E-Mail: d92-mtm@ludd.ltu.se
Telephone: <request by e-mail>
Cellular: <request by e-mail>
Born: 1972
Sex: Male
Nationality: Swedish
Languages: Swedish (native)
English (fluent)
Driving license: Yes, type B (since 1991)


General information
My competence ranges from system and database design to pure programming and data analysis and I have been responsible for writing several system and functional requirement specifications. My current focus is database design and implementation on Microsoft SQL Server.

I'm creative and reliable when it comes to working independently, but is also a communicative and co-operative team player when working with people in a group. I'm well experienced in working on multinational teams where English is the common language.

As well as working with computers, my interest in them have also taken a large part of my spare time. I wrote my first program at the age of eleven on an ABC80 and have been active on the Internet since 1992.
Between 1995 and 2015 I administrated one of Swedens earliest and largest IRC (Internet Relay Chat) servers.

In my spare time I enjoy playing the guitar, reading, listen to music, working outside and visiting other countries.



Work Experience
1996 - MT Technology Partner, Stockholm, Sweden
Founder & Consultant
2002 - 2003 Foresee AB, Stockholm, Sweden
Co-founder & Consultant
1997 - 2002 Icon Medialab AB, Stockholm, Sweden
Programmer
Summer 1996 Icon Medialab AB, Stockholm, Sweden
Programmer
Summer 1992 Fakta, Nyland, Sweden
Clerk
Summer 1991 Fakta, Nyland, Sweden
Clerk
Summer 1990 SAAB, Kramfors, Sweden
Mechanic


References
Carl-Johan Schnell C-J Schnell Consulting AB
Founder & Consultant


Courses Attended
2009 Visual Studio 2008: Windows Presentation Foundation
2008 Implementing and Maintaining
Microsoft SQL Server 2005 Integration Services
2001 Oracle Statement Tuning
2000 Oracle Database Operator
1999 Object-Oriented Analysis and Design with UML
1998 Data Modeling with PowerDesigner
1997 IBM Net.Commerce Implementation


Publications
2001 Acknowledgements in RFC 2810, 2811, 2812 and 2813, which can be obtained from the IETF (Internet Engineering Task Force).
1991 "Computer aided recording of Fieldeffecttransistor characteristics", which can be obtained from Ådalsskolan.


Other information
2010 Received grade B on the "Certificate of Proficiency in English" (CPE) exam, Cambridge ESOL Examinations.
2005 - 2006 Worked in Belfield (Dublin), Ireland for twelve months.
2001 Worked for four months in Parc De Sceaux (Paris), France as database designer and developer.
1992 Completed military service at I21, Sollefteå, Sweden.



Higher Education
1992 - 1997 Luleå University of Technology, Luleå, Sweden

University modules:
Abstract Data Types, Algorithms, Automatic Control, Basic Physics, Basic course in Business Administration, C-Programming, Circuits Analysis and Design, Compiler Design, Computer Networks, Computer System Management, Computer-Controlled Systems, Digital Design, Engineering Mathematics, English for Students of Technology, Experimental Methodology, Functional Programming, Human-Computer Interfaces, Imperative Programming, Japanese, Man-Machine-Interaction, Mathematical Models, Multimedia Systems, Object Oriented Programming, Operating Systems, Optics, Oral Presentation and Report Writing, Processor/Software Interface, Project in Software Technology, Reactive Programming and Statistical Methods.


Education
1988 - 1991 Ådalsskolan, Kramfors, Sweden
1985 - 1988 Ytterlännesskolan, Bollstabruk, Sweden
1979 - 1985 Torsåkersskolan, Torsåker, Sweden 1979 - 1985 Torsåkersskolan, Torsåker, Sweden

Graduated from Senior High School with majors in:
Biology, Chemistry, Electrics, Electronics, English, German, History, Math, Physics, Social science, Swedish, Theology and Technology.


Technical Skills
Work experience in the following concepts and techniques:
Database design (conceptual- and physical modelling), Data analysis, System design, .NET, Microsoft Active Server Pages, PHP Hypertext Pre-processor, Rational Unified Process and Unified Modeling Language.

Work experience with the following databases:
Microsoft SQL Server 2000 (including Data Transformation Services) / 2005 (including SQL Server Integration Services) / 2008 / 2012 / 2014, Oracle 8i, Microsoft Access 2000, mSQL and mySQL.

Work experience in the following programming and mark up languages:
C, C#, HTML, JavaScript, JScript, PHP3, PHP4, SQL/PL, Transact-SQL, VBScript, Visual Basic, WScript, Xamarin, XAML and XML.

Basic knowledge in the following programming and mark up languages:
C++, Java, DTD, Eiffel, Meta Language, MIPS R3000 Assembler, Modula 2, sh / csh / tcsh, Turbo Pascal, Visual Basic .NET and WML.

Experience in installation and administration of the following systems:
Microsoft Windows, Linux, FreeBSD, Apache, Microsoft Internet Information Server and Internet Relay Chat.

Knowledge in (but not limited to) the following software:
Microsoft Office (Access, Excel, Outlook, PowerPoint, Word), Microsoft Project, Microsoft SourceSafe, Microsoft SQL Server Enterprise Manager, Microsoft Visual Studio, Microsoft Visual Basic 6.0, Microsoft Visual InterDev 6.0, Peregrine AssetCenter, SQL Navigator, SQL Plus and Sybase PowerDesigner.