Lukáš S.

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

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

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

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

 

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)

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

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