Johan Ejstrud

Johan Ejstrud

Statistician gone programmer

Nuuk, Greenland
760 followers 500+ connections

Services

Articles by Johan

  • Planting Sunflowers With Statistics

    Planting Sunflowers With Statistics

    All I wanted was a bed of sunflowers. This should be easy: Buy sunflower seeds Plant seeds Wait But it wasn’t that…

    7 Comments
  • 10 Things a 38-Year-Old Book Taught Me About Unix

    10 Things a 38-Year-Old Book Taught Me About Unix

    1984 is ancient. In a field as young as computer science, reading a book of this age is like reading about building a…

  • The World is Doing Great!

    The World is Doing Great!

    ★★★★★ Factfulness by Hans Rosling Right now, as the world experience the worst pandemic in many years, the title of…

  • Unix Philosophy Enforces Simplicity

    Unix Philosophy Enforces Simplicity

    In R&D of the Pharmaceutical industry there is a strong culture of reviewing - everything. This isn't without reason.

    3 Comments

Activity

Join now to see all activity

Experience

  • Ejstrud Consulting Graphic

    CEO, manager, and assistant

    Ejstrud Consulting

    - Present 3 years 11 months

    Greenland

  • Pisiffik Graphic

    Inventory Data Analyst

    Pisiffik

    - 5 months

    Nuuk, Greenland

    Did ad-hoc analysis tasks on inventory data in Greenlands largest retail chain. I also automated a lot of manual tasks in Excel with database queries and VBA scripts.

  • Novo Nordisk

    Novo Nordisk

    5 years 4 months

    • Novo Nordisk Graphic

      Statistician

      Novo Nordisk

      - 3 years 2 months

      Aalborg

      During these three years my focus started at statistics, then switched to programming, and finally to project management. After two years I won the award as employee of the year in Global Development. My most important contributions were:

      Project manager for:
      - Replacing system for defining, planning, and reviewing statistical datasets and outputs.
      - Utilising Azure DevOps to collaborate on internal software development.
      - Improving collaboration and agile mindset in a global…

      During these three years my focus started at statistics, then switched to programming, and finally to project management. After two years I won the award as employee of the year in Global Development. My most important contributions were:

      Project manager for:
      - Replacing system for defining, planning, and reviewing statistical datasets and outputs.
      - Utilising Azure DevOps to collaborate on internal software development.
      - Improving collaboration and agile mindset in a global team of +15 employees.

      Programming
      - Created a command line tool (Perl) which is now mandatory for documenting review.
      - Several automated Excel workbooks (VBA) to support existing processes.
      - Countless statistical tables and figures (SAS).

      Statistics
      - Responsible for all exploratory tasks on Fiasp®.
      - Helping ad-hoc with urgent tasks on other projects.

    • Novo Nordisk Graphic

      Scientific Student Assistant

      Novo Nordisk

      - 2 years 2 months

      Aalborg

      Supported more senior statisticians in making the Integrated Summary of Safety for both Fiasp and Ozempic. My most important contribution was to eliminate mundane task in Excel, by automating them through programming in VBA.

  • Aalborg University Graphic

    Student Teacher

    Aalborg University

    - 3 years 5 months

    Worked as part of AAU on Demand, delivering lectures for high schools students about interesting topics in mathematics and giving them insight into how it is to do a university degree. I did a presentation about paradoxes in infinity and one about counterintuitive results in probability theory.

  • Reykjavik University Graphic

    Visiting Scholar

    Reykjavik University

    - 6 months

    Iceland

    Did a semester at Reykjavik University during my masters degree taking courses in computer science.

  • Substitute Teacher

    Solsideskolen

    - 11 months

    Worked as substitute teacher at a primary school.

Education

  • Aalborg University Graphic

    Aalborg Universitet

    Master of Science (MSc) Mathematics

    -

  • Aalborg University Graphic

    Aalborg Universitet

    Bachelor of Science (BSc) Mathematics

    -

  • Aalborg Katedralskole

    High school

    -

  • Solsideskolen

    Primary school

    -

Licenses & Certifications

Volunteer Experience

  • Lighting technician

    Lyd & Lys gruppen

    - 6 years 10 months

    Volunteering in a group at Aalborg University that put up light and sound equipment for the university parties. Though my work I have had responsibility for designing and and overseeing building of stages for parties with more then 4000 guests. My experience with concert lighting has given me several freelance jobs in the industry.

  • Studenterhuset Graphic

    Lighting technician

    Studenterhuset

    - 1 year 2 months

  • Muskelsvindfonden Graphic

    Rigger

    Muskelsvindfonden

    - Present 12 years 6 months

    Health

    Toured with Grøn Koncert.

Publications

Courses

  • 17 other courses

    -

  • Applied Statistics

    -

  • Bayesian Inference and Mixed Models

    -

  • Practical Aspects of Statatistics

    -

  • Probability Theory

    -

  • R

    -

  • Spatial Statistics and Markov Chain Monte Carlo Methods

    -

  • Statistical Inference for Linear Models

    -

  • Statistical Modelling and Analysis

    -

  • Time Series Analysis and Econometries

    -

Projects

  • Analysis of Earthquakes in California

    The project consisted of a statistical analysis of 30 years of earthquake data from California. Our goal was to use spatial statistics to make a model for simulating earthquakes. In the report we cover the poisson, hawkes and ETAS model.

    Other creators
    • Jesper Haar Jakobsen
  • Linear Normal Model for Predicting House Prices

    The project consisted of a statistical analysis of a data set from the danish real estate company Home. Our goal was to make a model that could predict the price of a house given features such as size, number of bedrooms, distance to nearest city etc. To evaluate the performance we compared the predictions of our model, with the valuation of the houses made by SKAT (the Danish Central Customs and Tax Administration). Our model was significantly better.

    Other creators

Honors & Awards

  • Global Development Award 2019

    Novo Nordisk, Martin Lange

    This yearly award is given to an employee who has made an extraordinary contribution to Global Development and who lives the Novo Nordisk Way. In the delivery speech my contributions to various improvement initiatives were highlighted, and it was also noticed for being 'a very colourful person'.

Languages

  • English

    Full professional proficiency

  • Danish

    Native or bilingual proficiency

Recommendations received

More activity by Johan

View Johan’s full profile

  • See who you know in common
  • Get introduced
  • Contact Johan directly
Join to view full profile

Other similar profiles

Explore collaborative articles

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

Explore More

Add new skills with these courses