Petr Vojtík

Profinit associate

Prague, Czechia

About

Experienced Analyst with a demonstrated history of working in the information technology and services industry. Strong real estate professional skilled in Analytical Skills, Data Warehousing, Data Visualization, Relational and Analytical Database Skills, ITIL Processes Implementation and Java Programming.

Experience

  • Datawarehouse analyst and developer at Raiffeisenbank Česká republika
    Aug 2019 - Present · 6 yrs 11 mos

    Datawarehouse analyst and developer at Raiffeisenbank.

  • Senior Consultant, Profinit associate at Profinit
    Aug 2019 - Present · 6 yrs 11 mos

  • Senior Consultant at Solutia, s.r.o.
    Jun 2012 - May 2019 · 7 yrs

    • Relational databases: Oracle, Microsoft SQL Server, DB administrator, SQL, DB tunning/troubleshooting, DB design/editing/maintenance • Analytical database: Vertica, administrator, SQL, analyses, data processing, cluster maintenance • Data visualization: Tableau Desktop/Online/Server • Data analyzes/processing: Tableau, Tableau + R, MS Excel, TalenD, SQL, PL/SQL, Vertica built-in analytical functions, Oracle ODI • Programming: Java, Visual Basic, VBA, Android • Reporting: Crystal Reports • ITIL • Service Desk implementation/customization: Ivanti Landesk Service Desk, CA Service Desk manager • IT project management, Teamleader • Trainer: SQL, ITIL • Business/IT analyst: strong empathy for customer, fast understanding of the customer's business processes • DMS: Oracle UCM - Unified Content Management • GIS

  • GE Money Bank (Vyskočilova 1422/1a, Praha 4)
    • Analyst, Internal security, Legal & Compliance
      Jul 2010 - May 2012 · 1 yr 11 mos

      • Security Analyst – Member of the Internal Fraud Detection Team • Responsible for the Data Analyses of the Internal Frauds in the three Bank’s Data Warehouses (Oracle DB) (Bank – accounts, loans, mortgages, Multiservis – retail loans, Auto – car loans) – SQL, PL/SQL, VBA. Data support for analysts and investigators. • Responsible for the design and implementation of the new control for internal fraud detection • Project for the choice of the system for Internal Fraud Detection - RFI, RFP, PoC, data anonymization • PwC Fraud Forum member

    • System Analyst, Data Architecture, IT
      Apr 2007 - Jun 2010 · 3 yrs 3 mos

      • Data analyst at Integration hub team. • Flexcube integration hub • Microservices development • Responsible for data integration from different bank systems and creating workflows to provide that agreggated data (with business logic) to the rest of bank systems.

  • Analyst, Programmer at GEPRO s.ro.
    Jun 2004 - Apr 2007 · 2 yrs 11 mos

    • Responsible for maintenance of vector map of the Europe • 10+GB of data, responsible for storage in the Microsoft SQL Server database • Responsible for editing and preparing for vector map visuliasion in the GIS system. • Microsoft SQL Server DB design, indexes, triggers, queries, procedures, indexes. Visual Basic, Visual Basic for App.