Adam Plachy
Business Intelligence Specialist at Adastra Digital- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Professional working proficiency
-
Czech Native or bilingual proficiency
Topline Score
Bio
Credentials
-
Oracle Database 12c: SQL Fundamentals
OracleNov, 2019- Oct, 2024
Experience
-
Adastra Digital
-
Czechia
-
IT Services and IT Consulting
-
300 - 400 Employee
-
Business Intelligence Specialist
-
Oct 2022 - Present
Komercni Banka - KYC Review Squad, Customer Tribe. - analyst / developer in KYC datamart
-
-
Senior Business Intelligence Developer
-
Jul 2022 - Dec 2022
Migration of acquired loan portfolio @SB Finance PH- responsible for IT development- SQL, T-SQL, ETL, data transformation
-
-
Senior Business Intelligence Developer
-
Apr 2022 - Jul 2022
SAS and RDM Datamart optimization @Moneta Money Bank- technical optimization of loads.- analysis of processes, ETLs, workflow- SQL, execution plan optimization
-
-
Business Intelligence Consultant
-
Jan 2022 - Mar 2022
End of Month Analysis - Customer MONETA Money Bank, a.s. Business analysis of End of Month processes
-
-
Business Intelligence Developer
-
Dec 2021 - Jan 2022
Oracle upgrade 19c @ MONETA Money Bank, a.s. Process optimalizations in the DWH due to Oracle upgrade to 19c Version.- Synchro packages analysis between ADS a ODS- Execution plan optimalization- Generating data sets for API mass tests.Technologies used: PL/SQL, SQL
-
-
Business Intelligence Developer
-
May 2021 - Nov 2021
Unification of FINREP Datamart @ MONETA Monety Bank, a.s. Redesign of FINREP Datamart - financial reporting for CNB- Entire datamart redesign - structures, ETLs, workflow.Technologies used: SQL, PL/SQL Developer, SAP PowerDesigner
-
-
Business Intelligence Developer
-
Feb 2021 - May 2021
Reconciliation on the General Ledger @ Eurobank of Serbia Implementation of brand new Data Warehouse- ETL development for accounting tables- Application Server instalations - Pentaho Data Integration, Codebook Manager, Nginx- Workflow managementTechnologies used: SQL, Metacroc (Cloud ETL management tool)
-
-
Business Intelligence Developer
-
Apr 2020 - Mar 2021
Wustenrot Integration (4/2020 - 3/2021) @ MONETA Money Bank, a.s. Integration of two new primary systems into the MMB DWH- ETL development across all layers in the DWH- CEU Reporting - Account evidence for CNB- Load management responsibity- Deploy managementTechnologies used: SQL, XML, PL/SQL Developer, SAP PowerDesigner, Visual Basic
-
-
Business Intelligence Developer
-
Dec 2018 - Apr 2020
First Vision @ MONETA Money Bank, a.s.Integration of a new card system into DWH - replacing the existing one - DML, DDL development- Load support- Technical analysis- Wowkflow developmentTechnologies used: SQL, XML, PL/SQL Developer, SAP PowerDesigner, Visual Basic
-
-
Business Intelligence Developer
-
Jul 2018 - Nov 2018
Erste Bank @ Erste Bank Vienna - DDL development- ETL development- Load supportTechnologies used: Oracle Data Integrator, SAP PowerDesigner, SQL, SQL Developer
-
-
-
ALSTON spol. s.r.o.
-
Prague, The Capital, Czech Republic
-
Structural Engineer
-
Feb 2017 - May 2018
• Structural engineering calculations, reports, CAD drawings, reinforcement • Structural engineering calculations, reports, CAD drawings, reinforcement
-
-
-
Pragoprojekt a.s.
-
Prague, The Capital, Czech Republic
-
Bridge Engineer
-
Mar 2014 - Apr 2016
• design of concrete reinforcement • CAD drawings • design of concrete reinforcement • CAD drawings
-
-
Education
-
Czech Technical University in Prague
Master of Engineering (MEng), Civil Engineering -
Loughborough University
Civil Engineering -
Czech Technical University in Prague
Bachelor's degree, Civil Engineering