See all developers
Lukáš S.

Lukáš S.

  • Prague
  • 7
  • Full-time (40 hrs/week)
Lukáš is now available for hire Hire Lukáš

BI: Tableau, QlikSense, Spotfire, PowerBI
DB: SQL Server, OracleDB
Programming: Python, VBA, Javascript, DAX
Documentation: Draw.IO, Visio, PowerDesigner
Other: Jenkins, Pipeline Pilot, Jupyter Lab

Skills and experiences

Skills and experiences

BI Developer - L3

Novartis 2019 - Present

E2E development of reporting solutions & data analytical platforms (technical requirements, delivery, UAT, documentation, handover), migration of existing reporting from Tableau/PowerBI to Qlik Sense, data transformation, stakeholder communication

Technology stack used for solutions:
BI: QlikSense, Tableau, PowerBI | Data: SQL, API, QVD, DAX | Programming: Python (pandas, numpy,requests), VBA, Javascript, PowerShell | Automation: Jenkins

BI Data Analyst

MSD 2017 - 2018

E2E delivery of reporting & data analytical solutions (technical assessment of BR, delivery, handover to support team), reporting industrialization, structured/non-structured data transformation

Technology stack used for solutions:
BI: Spotfire, Tableau | DB: Oracle DB, SAP Hana | Programming: Python (Pandas, BS4), Iron Python, Javascript, VBA

Senior Consultant

PwC 2015 - 2017

KPI Reporting for PWC CEE region, reporting process automation, data processing, ETL scripting, consulting QlikSense/Tableau/Dashboarding, holding client WS, assessing business requirements, agile development of reporting/service tools for multiple US pharma clients

Sales Operations Analyst

Medtronic 2013 - 2015

Delivering sales reports and analytics for the whole EMEA Region, creating and maintaining KPI's, regular KPI reporting in compliance with various deadlines, conducting performance analyses, creating and maintaining VBA and Tableau tools, developing KPI process automation, Excel and Powerpoint automations, building reports in Cognos Reporting studio & Query studio, case study calculations, script to regularly gather data from over 2000 files scattered across local network, reduced update time from 3 days to 3 hours


GSD support analyst

DHL 2012 - 2015

Data analyses providing further insight into Reports, automatization of reporting tools via VBA scripts, creating interactive user forms, creating dynamic dashboards, creating KPIs, creating tools for maintenance and batch editing of existing sharepoint KPIs,creating Excel to PowerPoint automated reporting, creating and adjusting Access database, Excel to Access automation (script to automatically gather more than 600 userform feedbacks), VBA code optimization (reducing un-optimized script's time consumption from 12 hours to 5 minutes)

Assistant auditor - Internship

KPMG 2011 - 2012

Performing various tests of controls, mapping processes, complex analysis of accounting statements, operative problem solving with team/client

Data analysis

IDC CEMA s.r.o. 2011

Data analysis, regular database updating, reporting, vendor data processing using pivot tables, research activities depending on department needs

Want to hire Lukáš S. or just want to talk? Schedule chat with Lukáš

Other developers