Jacek Szanduła

$33/hr
PhD, Assistant professor, statistical analyses, R, VBA, Excel
Reply rate:
-
Availability:
Hourly ($/hour)
Location:
Wrocław, dolnośląskie, Poland
Experience:
15 years
PhD Jacek Szanduła 42 years 15 years of experience Area of Expertise: Econometrics, statistics, forecasting economic and demographic processes, time series analysis Skills: Technical:  Programming languages: SQL, VBA, HTML, JavaScript, XPath, BeanShell  Technologies: Moodle  Tools: R, Matlab, Simulink, Octave, Statistica, SAS, SPSS, Gretl, OX, Adobe Acrobat, Adobe Photoshop  Databases: Access  System: Windows, Linux (Ubuntu)  Others: Word, Excel, PowerPoint, Corel, Photoshop, GIMP, Webharvest Functional:  Teaching statistics, econometrics, forecasting, financial analysis both in a classic form and via elearning platforms  Organizing scientific conferences  Editorial works Certificates:  Europass Mobility Trainings/Workshops:  Scientific conferences in area of forecasting, modeling, financial analysis, demography (more or less twice a year)  Matlab & Simulink – 3-4 times  Maple  GRETL 1 Languages:  Polish:  English:  German:  Croatian: Native Very good Good Basic Education: Wroclaw University of Economics Faculty: National Economy Doctoral thesis: Analogue methods in socio-economic forecasting Degree: PhD 1999 - 2002 Wroclaw University of Economics Faculty: National Economy, Finance & Banking Specialization: Forecasting Degree: Master 1994 - 1999 Professional Experience: Wroclaw University of Economics, Department of Economic Analyses & Forecasts Assistant Professor Since 2006 Self-employment Freelancer Since 2014 Lower Silesia Voivodeship Division of National Health Fund Member of Council 2010 - 2012 Wroclaw University of Economics, Department of Economic Analyses & Forecasts Instructor 2002 - 2006 VIT-2 sp. z o.o. Financial Analyst 2000 DPW Kwadro sp. z o.o. Board Assistant: Financial Matters 1999 BS Art Design sp. z o.o. Computer graphic designer 1998 2 Professional Experience – details: Wroclaw University of Economics, Department of Economic Analyses & Forecasts Assistant Professor Since 2006 The area of my research interests include mainly the theory of forecasting with particular emphasis on analogue methods, and time series analysis. In practical applications I mainly deal with the study of irregular cyclical fluctuations in the micro and macro scale. Earlier, I dealt with the demographic processes . I am the author of 25 publications. In addition to publication in scientific journals I prepared and made available on my website workbooks using VBA macro for calculating analogue forecasts.  Research o Theory of forecasting with particular emphasis on analogue methods and time series analysis o Dealing with the study of irregular cyclical fluctuations in the micro and macro scale o Dealing with the demographic processes o Prepare and made available on personal website workbooks using VBA macro for calculating analogue forecasts. Programs:  analogie_makro1.xls - available on www.szandula.pl ; workbook is to calculate forecasts with the use of space-time analogy.  analogie_makro2.xls - available on www.szandula.pl ; workbook is to calculate similarity measures according to the formula proposed in the work Cieślak M., Jasiński R. (1979). Miara podobieństwa funkcji. Przegląd Statystyczny, XXVI – issue 3/4.  Variables generation based on the correlation matrix – Application in R/shiny for generating variables based on the correlation matrix.  Teaching o Holding both lectures, classes and computer labs. For last two years also in English  financial analysis  financial forecasting  forecasting and simulation  forecasting theory and computer simulation  fundamentals of quantitative methods  mathematical statistics and econometrics o Creating prototype tool for automated checking students' knowledge of different courses. Macros written in VBA generate for each student individual set of exercises as well as their solutions. Student's solution is automatically checked . This system has been used successfully for 7 years in an increasing number of courses. It currently supports : financial analysis , mathematical statistics and econometrics, financial forecasting , fundamentals of quantitative methods and it is planned to be launched on e-learning platforms Technical Environment: Word, Excel, PowerPoint, Access, Matlab, Simulink, Octave, Statistica, SAS, SPSS, R, Gretl, OX, SQL, VBA, HTML, JavaScript, Webharvest, XPath, BeanShell, Adobe Acrobat 3 Self-employment Freelancer   Since 2014 Different tasks mostly arranged and agreed through internet portals (mainly Upwork, ~50 projects so far, see https://www.upwork.com/freelancers/~01743f43cfc63efc45). For example (job titles): o R scripting, Data analysis guru, statistician to write scripts that analyze data o Modifying Multiple Regression Econometric Analysis o Analyse past client forecasts and past sales (quantities), forecast sales (quantities) and optimize inventory o Mixed frequency regression price forecasting o Credit risk model in R o R developer needed to support CTO o database interface + Backtesting engine o Excel VBA script / macro – modelling o Database system basing on an Excel interface and files for property agents Technical Environment (so far): Word, Excel, VBA, R, shiny Lower Silesia Voivodeship Division of National Health Fund Member of Council 2010 - 2012  As a Member of Council of Lower Silesia Voivodeship Division of National Health Fund I dealt with: o reviewing the financial plan draft o adopting the work plan for the voivodeship division of the Fund o reviewing the report of the implementation of the financial plan of the division o monitoring the correctness of the proceedings on the conclusion of agreements on the provision of health care services and the implementation of these agreements o controlling of the of the current activities of the division o periodic analyzes of complaints and claims submitted by the insured o monitoring the medical needs of the insured, in particular access to medical services Technical Environment: Word, Excel, Power Point Wroclaw University of Economics, Department of Economic Analyses & Forecasts Instructor 2002 - 2006  This position was prior to my present one at Wroclaw University of Economics. I dealt more or less with the same matters as now (see Assistant Professor) excluding lectures. Technical Environment: Word, Excel, PowerPoint, Access, SQL, VBA, Statistica 4 VIT-2 sp. z o.o. Financial Analyst 2000  The Company was a mini holding managing cooperatives of sheltered employment. I analyzed offers of potential partners. Besides I prepared educational texts for the future e-learning platform. Technical Environment: Word, Excel DPW Kwadro sp. z o.o. Board Assistant: Financial Matters 1999  I was responsible for reporting to the Board about the ongoing business. In particular: o sales o accounts receivable past due o the profitability of particular products o costs Technical Environment: Word, Excel, Power Point, TETA BS Art Design sp. z o.o. Computer graphic designer 1998  I designed leaflets, business cards. I made rubber stamps, advertising inscriptions and pictures. Technical Environment: Corel Draw, Photoshop 5

Simple time tracking.
Easy payments.

Hubstaff streamlines the way you work with freelancers.
Make life easier