Curriculum Vitae


Peter Larsson
@swePeso
0046 73 408 45 00
peter@sqltopia.com

“Amateurs work until they get it right and professionals work until they can’t get it wrong because an amateur does what he loves while a professional loves what he does.”

 

Qualification Summary

http://ww1.prweb.com/prfiles/2005/11/02/305895/mvplogo.png
International expert on Microsoft SQL Server and Microsoft Business Intelligence


Promoted to MVP between 2009 and 2019 for 9 consecutive years. There are less than 300 people worldwide with this recognition within SQL Server/Business Intelligence. Three-time winner of Phil Factor Speed Phreak, an international competition in performance tuning.

  • Organizer of annual Swedish T-SQL Championship
  • Frequent speaker on conferences and an experienced instructor. Peter has produced about 20 courses in programming/SQL Server design and development.
  • Co-author to MVP Deep Dives Volume 2 and technical reviewer of RedGate’s ”Team Based Development”. Have written articles for RedGate such as ”How to think like a professional developer”. Technical reviewer of Microsoft Exam 70-462.

Characteristics

Peter is perceived as thorough, structured and analytic. Peter also have a strong pedagogic side. He is driving and delivers the optimal solution for the customer, according to the agreed timeline, and on budget.

His strength is the ability to see solutions where others have given up.

History

Senior database specialist, 2019 – ongoing

TietoEvry

Working with a number of investment companies as well as banks as Product Owner of Performance Team and Lead of database group.

Senior consultant & teacher and Mentor, 2011 – 2019

SolidQ

Working with a number of [international] customers such as If, Region Skåne, HomeEnter och a nordic bank as a mentor, database expert and developer. He has also worked with Lindab, CDON, DA, FDC, DSV, Sony Ericsson, Strusoft and Software Point with eliminating deadlocks and locks, enhancing data flow for the applications and at the same time allowing for multiple simultaneous users.

Mentor and senior architect and senior developer in multiple critical projects, with focus on performance and maintenance simplicity.

Chief database architect & main responsible internal Business Intelligence, 2009 – 2012

Homeenter AB

Homeenter is a company within Bonniers who operates the largest loyalty club in the Nordic countries regarding entertainment (film, music, game). Peter was main responsible of the design and schema for their Data Warehouse and Business Intelligence solutions. Operational data was captured from 4 core business systems and 7 production systems including up to 30 years of customer history.

Senior database architect & administrator, 2008 – 2009

StroedeRalton

Developer for several customer databases, including Åhléns, Kicks, Svensk Bilmärkning, SJ, Intersport, Retail’N’Brands, JC, Sisters, Brothers and others. Developed new algorithms and ran classes for SQL Server 2008. Designed and built Business Intelligence-solutions.

Senior consultant, 2005 – 2008

TedKompile

Did review and wrote performance optimizations for H&M, resulting in over 100% faster execution times and reducing use of local resources with 75%. Wrote and held internal classes for other consultants. Did benchmark testing, unit testing and migrering tests prior upgrading to SQL Server 2005. Other Assignments inlcudes EON, Watski, FL Snus, Lindab and Alfa Laval.

Database administrator and senior system developer, 1999 – 2005

Capinordic/Acta

Architect and developer for a new CRM system and databases for over 540 users in Sverige, Finland and Norge. Developed algorithms with Bankgiro and Svenska Försäkringsföreningen. Also wrote web front-end applications from.

Systems developer, 1998 – 1999

SPCS/Visma

Software company known for economy and accounting systems. Developed several critical algorithms for tax calculation.

Senior consultant, 1993 – 1998

Self employed

Developed applications in both Visual Basic and MS Office as well as SQL Server for ASG, Fiat, NTS, ERT, STS and PNO.

Assignments (abriged)

AbaSecurities Performance Product Owner
Aug 2019 – ongoing Peter invented a number of algorithms to gain superior performance. He also mentored architecture and coding.
Multiple flows became 10 times faster to 14 000 times faster.
OneMed Data Warehouse Designer
Oct 2016 – Jun 2017 Peter designed and wrote a new DW for OneMed, that had performance, maintenance and determinism in mind. Average load time went from 11 hours to 1 hour. Quality and determinism went up to 100%.
JBT SSIS, SSAS and SSRS
May 2016-Jun 2018 Peter led a project that converted 300+ DTS packages to SSIS packages, 33 2000-cubes to 2016 and some 400+ reports
   
R7 e-Arkiv, SSIS expert and database architect/developer
Feb 2015 – ongoing Peter initially did a pre-study to analyze the customer’s current solution and propose and new architecture to make the import more efficient for e-Arkivet. The pre-study resulted in a project to rebuild the import functionality with SSIS to maximize performance and also to facilitate multiple parallel imports at the same time the system is used for normal operations from 5000 users. Peter was the architect and developer in this project. Main goal was performance but a close second was maintenance simplicity.
Region Skåne e-Arkiv, SSIS expert and database architect/developer
Aug 2012 – ongoing Peter was summoned to solve a grave performance issue. He managed to bring the search times down from 134 days, to a sub-second response time. To achieve this, Peter had to redesign the database schema and minimize the interface to the client applications. Imports was rewritten with SSIS, which made the imports 10 times faster.
   

Certifications (abridged)

  • Microsoft Certified Trainer
  • SQL Server 2016 MCSE
  • SQL Server 2016 MCSA

Education

  • Malmö University / Lund University, The School of Teacher Education – 1992
  • Mathematic and Physics including programming classes. Major in pedagogy.

Additional experiences/competencies

  • SCRUM
  • Kimball Dimensional Modelling
  • Bill Inmon Data Warehouse architecture
  • .NET Framework / SQLCLR
  • SSIS – SQL Server Integration Services
  • SSRS – SQL Server Reporting Services