Nico S.

Quantitative modeling and model development, statistical data analysis, reporting

Cologne, Germany

Experience

Jul 2022 - Present
3 years 2 months

Quantitative modeling and model development, statistical data analysis, reporting

DB InfraGO / Brockmann & Büchner Partnergesellschaft

  • Technical project management, requirements management, and concept development to steer the data team in developing a predictive maintenance model for DB InfraGo's maintenance planning.
  • Statistical modeling and analysis programming with R Studio for failure analysis in preventive management: multivariate modeling using quasi-Poisson, negative binomial, lasso, offsets, splines, random forest.
  • Implementation of various R Shiny dashboards.
  • Acted as sparring partner and managed requirements for data engineering, data modeling, and ETL pipeline in Tableau Prep.
Jan 2021 - Mar 2022
1 year 3 months

Customer segmentation; setting up KPI monitoring, CRM

Auch schön - organic fashion & interior design

  • Customer segmentation; building KPI reporting; data analysis; writing scripts in R and Excel.
  • Data management and preparation: ETL to create an analysis-ready dataset, interface management to the online shop in R using httr and plumbR.
Aug 2019 - Feb 2021
1 year 7 months

Statistical data analysis and reporting, biostatistics training

O.I.s) OncologyInformationService

  • Data analysis: statistical evaluation, complex modeling of survival times, reporting and data visualization with SPSS, Visokio, R, and Excel. Syntax programming and writing scripts in R and SPSS. Data management and preparation: plausibility checks of the dataset.
  • Conducting biostatistics training in R: Kaplan-Meier, Cox regression, propensity score matching.
  • Managed a three-person project team.
Dec 2018 - Oct 2019
11 months
Germany

Statistical data analysis and reporting, methodological consulting, data management and consolidation

Santhera (germany) GmbH

  • Survival time analyses for quantitative data evaluation, methodological consulting and reporting, as well as visualizing results with R, SPSS/PSPP, and Excel VBA.
  • Automating key metric calculations to update analyses in an R Shiny dashboard.
  • Data management, cleaning, and preparation: case-by-case and plausibility checks, standardizing the dataset for maintainable structures, integrating ongoing observation waves.
Nov 2018 - Apr 2019
6 months
Cologne, Germany

Quantitative modeling, methodological consulting, data analysis

FOM Köln / covelo GmbH

  • Data management, data exploration, and time series analysis, methodological consulting, as well as statistical analysis and visualization of price dispersion dynamics in online pharmacy retail.
  • Merging and consolidating crawling data in an ETL process: merging, consolidating, preparing, structuring, and standardizing nested datasets.
  • Dashboard development, analysis, and visualization with R, Tableau, SPSS/PSPP, and Excel VBA.
Jun 2018 - Present
7 years 3 months
Cologne, Germany

Impact monitoring and statistical analysis, data management and consolidation, reporting and data visualization

Gewinnsparverein Köln e.V.

  • Impact analysis and customer segmentation for evaluating and controlling a marketing campaign: indicator development and quantitative evaluation, ex-post design of treatment and control groups, setting up a cross-sectional design.
  • Data management, structuring, consolidation: setting up an ETL pipeline to merge various data sources into a unified database solution (n=1,300,000). Visualizing results and designing a reporting format. Developing KPIs to guide and evaluate the initiative over time.
  • Analysis and visualization with SPSS/PSPP and R, macro programming in Excel VBA, dashboard development with Tableau.
Feb 2018 - Aug 2018
7 months

Evaluation: data analysis and impact monitoring

Verein für Kultur, Politik und Berufsbildung e.V.

  • Evaluation and report writing, participatory indicator development, and preparing a questionnaire for event evaluations. Conducting data analysis and delivering a reporting format.
  • Turning analysis results into charts and presentation materials
  • Implementation in R and SPSS and visualization in PowerPoint/Excel.
Feb 2018 - Jun 2018
5 months
Bonn, Germany

ETL and data visualization: implementation consulting, data management, database administration, dashboard development

Okba International

  • Developing dashboards in Excel VBA and Tableau to visualize inventory metrics. Programming in R and Excel VBA, Tableau.
  • ETL: merging existing data sources and integrating data structures into a unified database: consolidating, transforming, and standardizing data sets to build a digital inventory system.
Jul 2017 - Jan 2018
7 months
Cologne, Germany

Project coordination, data management, and research activities at the Competence Centre for Women in Science (CEWS)

GESIS – Leibniz Institut für Sozialwissenschaften

  • Working on a project to evaluate gender equality plans at European universities in the area of gender-based educational inequality, funded by the European Union's Horizon 2020 research framework programme.
  • Research to identify indicators for measuring gender-specific inequalities in academic careers
  • Data management and research ethics; specifying data management processes for monitoring and evaluation purposes.
Jun 2017 - Mar 2018
10 months
Bonn, Germany

Statistical analysis, data visualization, and reporting within the impact-oriented monitoring of the Academy for International

Akademie für Internationale Zusammenarbeit der deutschen Gesellschaft für Internationale Zusammenarbeit

  • Digitization, statistical analysis, monitoring, and reporting for quality management at the Academy for International Cooperation. Delivered evaluation reports with quantitative and qualitative results from course evaluations through a solution combining SPSS and Excel VBA.
  • Transforming analysis results into graphical charts and presentation materials and coordinating academic and student staff involved in the project.
Jun 2015 - Jun 2015
1 month

Founder

sove.it e.k.

Founded my registered company.

Jan 2015 - May 2017
2 years 5 months
Bad Honnef, Germany

Consulting, statistical analysis and reporting in impact-oriented project monitoring for the German Agency

Academy for International Cooperation of the German Agency for International Cooperation (GIZ GmbH)

  • Consulting to further develop the impact-oriented monitoring and internal evaluation of the "Key Qualifications for International Cooperation" program at the Academy for International Cooperation.
  • Methodological consulting on the survey instrument. Expansion and systematization of the monitoring and reporting system: development of uniform reporting standards, building an integrated database solution.
  • Monitoring and reporting for quality management: statistical analysis of around 5000 participant feedback submissions per year. Delivery of about 100 evaluation reports per quarter with quantitative and qualitative results of course evaluations through a solution that links SPSS and ExcelVBA.
  • Preparing analysis results into graphical representations and presentations, and coordinating the scientific and student staff involved in the project.
Jan 2015 - Feb 2017
2 years 2 months
Bad Honnef, Germany

Planning, coordination and implementation of a qualitative impact study for the German Agency for International Cooperation

Academy for International Cooperation of the German Agency for International Cooperation (GIZ GmbH)

  • Qualitative study on the impact and practical relevance of the departure training for the "Key Qualifications for International Cooperation" program of the Academy for International Cooperation. Coordinated a scientific project team and student assistants.
  • Designed the study and coordinated the two-phase data collection with seven comparison groups (n=100), including guided interviews with former departure training participants (technical and managerial staff of German International Cooperation: AA, BMZ, GIZ), expert interviews, and document analysis. Conducted analysis, reporting, and result presentations.
Jan 2012 - Dec 2014
3 years
Bonn, Germany

Student assistant at the Chair of Empirical Social Research under Prof. Jörg Blasius

Rheinische Friedrich-Wilhelm University

  • Contributed to teaching research projects of the chair and to the working group on university teaching evaluation: led tutorials and provided method consulting for students.
  • Graphical illustration of multivariate analyses, participated in data collection. Questionnaire design and data preparation. Created and managed online surveys for the chair's teaching research projects.

Languages

German
Native
English
Advanced
Italian
Intermediate
French
Elementary

Education

Oct 2010 - Sep 2014

Rheinische Friedrichs-Wilhelms-Universität

Master of Arts · Sociology · Bonn, Germany · 1.4

Oct 2006 - Sep 2010

Justus-Liebig-Universität

Bachelor of Arts · Social and Political Sciences · Giessen, Germany · 1.8

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions