Andrew Ponist

Experienced data analyst and developer with a focus on SQL databases, capable of reporting in several visualisation tools and happy to learn new skills. Very creative in finding data errors and subsequent designing an optimal solution.

Data & System Analyst
Asseco Solutions, Prague (Remote from the UK) October 2023 - Present

Conducting a system analysis for the ETL tool, implemented on the AVA platform in the next phase of development.

Collaborating on developing a Communication app mainly used for marketing communication with customers.

Cooperating with developers to elicit and document system specifications, requirements and design.

Working in MySQL and Enterprise architect, using BPMN, USE Case and State diagrams and other tools as an integral part of all analyses.

Data Analyst
SPCSS, Prague
July 2022 - September 2023

Provided ad hoc reporting for the company’s management.

Collaborated with the stakeholders on choosing and deploying a data visualisation tool, performed system analysis, and consulted with the vendors.

Developed an integrated dashboard in Power BI to monitor the performance of businesses in the gambling industry.

Developed data outputs in PostgreSQL.

Regular consultations with the Ministry of Finance on assigned projects.

Reporting Specialist
Societe Generale Group, Prague October 2021 - June 2022

Prepared and submitted regular reports on capital and financial markets to the CNB using the commercial bank’s internal tools.

Managed and maintained the internal database, analysed and corrected any errors in the report.

Utilised MySQL to validate the reports on a daily, weekly and monthly basis.

Collaborated with a team of analysts to optimise the reporting tools and processes.

Data Analyst & Application Specialist Colas Group, Prague
December 2020 - September 2021

Created approval processes in the KS program environment (internal HR and accounting software), including tools for creating workflow.

Collaborated with departments across the company to implement and optimise elements of the KS program.

Provided regular and ad-hoc reporting for individual departments using MySQL.

Tested and deployed new updates/modules of the existing software and subsequent implementation of these modules within the application.

Data Management System Specialist/Developer Compagnie de Saint-Gobain, Prague
July 2018 - November 2020

Developed, implemented and maintained web applications on the K2 platform in cooperation with a team of developers, created and updated user documentation for these applications.

Tested multiple versions of company web applications, corrected errors in the code and analysed incorrect parts of applications.

Utilised queries in T-SQL to provide reports that interpret data based on the manager’s responsibilities, material data and more.

Adjustment data outputs in data visualisation toolsets such as SSRS, Data Studio, and Tableau.

Conducted training for novices.

Cooperated with the SAP team for data migration from the SAP database to the MySQL database 1:1 by ETL processes.

Product & Data Analyst Heaven Labs – MANA, Prague March 2016 - June 2018

Managed to optimise almost all departments (mainly the department of production and customer service).

Implemented a new innovative production plan to achieve profitability, increasing the company’s net income by 15%.

Generated reports and dashboards (based on past developments) that affected the company’s future direction.

Wrote all outputs in Snowflake and transferred them via Keboola to the Data Studio, GoodData, and then to

Tableau, which was finally chosen as the main software for data visualisation.

University of Economics, Prague
Master of Science (2015-2018): Econometrics and Quantitative Economics 

Bachelor of Science (2012-2015): Applied Informatics