Data Developer

CURRICULUM VITAE

Personal Data:

First Name Milan

Surname & Title Mihočko, Ing.

Address Ševčenkova 6

Postal Code 851 01

City Bratislava, Slovak Republic

Mobile +421*********

E-mail *****.*******@*****.***

Sex Male

Nationality Slovak

Professional Experience:

Period: May 2019 – March 2020

Position held: Business Analyst (Freelancer)

Company: MAIND Bratislava

Area: Bank

Goal & Scope of project Working on project (Constellation in VUB Bank Bratislava – Banca Intesa Sanpaolo)

Stakeholders and their location VUB Bank, Bratislava

Job Description: Changing core banking system

Analysis of the business requirements of the new core banking system (area: loans, payments, trade finance), analysis of the attributes from the new delivered system and from the existing system

Analysing the data required for reporting from the new delivered core banking system

Preparing mapping documents and interfaces for the data transfer from the new core to the ODB - operational data store

Preparing relevant data for creating logical and physical Data Model

Identify all the affected applications and interfaces

Platform: Windows web client,

Used tools: MS Word, MS Excel, JIRA, SQL developer, PowerDesigner, Hogan core banking system, FlexCube core banking system

Period: May 2018 – February 2019

Position held: Business Analyst (Freelancer)

Company: Ceska sporitelna Prague (member of Erste Group Vienna)

Area: Bank

Goal & Scope of project Working on projects (PAD)

Stakeholders and their location Ceska sporitelna, Prague

Job Description:

Analysing of business requirements and sources of required data for creating yearly customers payment – project PAD (Payment Accounts Directive)

Find optimal solution for required functionalities

Preparing relevant data for creating logical and physical Data Model

Identify all the affected applications and interfaces

Describe developed functionality and creation of PAD statement in Confluence

Platform: Windows web client,

Used tools: MS Word, MS Excel, JIRA, SQL developer

Period: February 2018 – April 2018

Position held: ICT Business Analyst

Company: ČSOB Bratislava

Area: Bank

Goal & Scope of project Working on projects (TEMENOS)

Job Description:

Analysis of required functionalities for the new core banking system TEMENOS,

Identify all the affected applications

Used tools: MS Word, MS Excel

Period: May 2017 – February 2018

Position held: Business Analyst (Freelancer)

Company: Ceska sporitelna Prague (member of Erste Group Vienna)

Area: Bank

Goal & Scope of project Working on projects (IFRS16, MEP)

Stakeholders and their location Ceska sporitelna, Prague

Job Description:

Analysis of required functionalities for IFRS16 (gathering the data for property, car and IT leasing into the SAP-REM module, preparing business functional specification), MEP (sending corporate payments information data from core banking system SYMBOLS into Data - Warehouse),

Find optimal solution for required functionalities

Identify all the affected applications and interfaces

Write Business Functional Specification documents

Platform: Windows web client, Java

Used tools: MS Word, MS Excel, JIRA, SQL developer

Period: May 2016 – March 2017

Position held: Business Analyst (Freelancer)

Company: IBM Slovakia

Area: Software House

Goal & Scope of project Build centralized selling and information system

Stakeholders and their location IBM worldwide

Job Description: Analysis of internal Information and financial system

Interact with product owners and developers

Gathering and describing functional requirements

Identify all the affected applications and interfaces

Write user stories and use cases

Write Business Functional Specification documents

Support developers and testers by resolving business issues that come up during the technical implementation and testing phase

Platform: Lotus Notes, Windows web client, Java

Used tools: MS Word, MS Excel, IBM Notes, IBM Slack, Murals, GitHub

Period: October 2015 – March 2016

Position held: Business Analyst (Freelancer)

Company: TCS Worldwide

Area: Software House

Goal & Scope of project Change of the core banking system

Stakeholders and their location UniCredit Bank

Key Achievements The old core system was successfully transformed into the new one

Job Description: Core banking system CORE02 (Project in Prague)

Interact with both business and IT

Participate in Requirement analysis, models and validations of business requirements

Identify all the affected applications and interfaces

Write Business Functional Specification documents

Support developers and testers by resolving business issues that come up during the technical implementation and testing phase

Prepare test cases

Platform: CORE02 core banking system, AS400, Windows web client, SharePoint 2010 platform

Used tools: MS Word, MS Excel, JIRA

Period: June 2014 - September 2015

Position held: Business Analyst (Freelancer)

Company: Targit GmbH

Area: Software House in Vienna

Goal & Scope of project Change of the internet banking system

Stakeholders and their location UniCredit Bank worldwide

Key Achievements The old internet banking was successfully transformed into the new one within added the new functionalities

Job Description: Internet banking (Project in Vienna)

Interact with both business and IT

Work in an agile/scrum development teams

Analyse, model and validate business requirements, conditions and priorities within application development projects for the entire internet banking functionality.

Identify all the affected applications and interfaces (Mobile channel, Internet, …)

Ensure that specified requirements are transmitted entirely and correctly to the development and test team members by writing clear and detailed functional and non-function requirements specifications

Support developers and testers by resolving business issues that come up during the technical implementation and testing phase

Write Business Functional Specification documents

Platform: Windows web client, SharePoint 2010 platform

Used tools: MS Word, MS Excel, JIRA

Period: April 2014 - May 2014

Position held: Business Analyst & Tester (Freelancer)

Company: Interway a.s.

Area: Software House

Goal & Scope of project Build information system for Ministry of National Economy

Stakeholders and their location Ministry of National Economy

Key Achievements Successful implementation of the system

Job Description: Government Department

Design business processes in Enterprise Architect (BPMN diagrams)

Write Functional Specification document for government web portal processes

Propose future business processes

Platform: Windows web client, SharePoint 2010 platform

Used tools: Enterprise Architect, BPMN notation, UML notation

Period: August 2013 - January 2014

Position held: System Analyst & Tester (Freelancer)

Company: ARBES Technologies

Area: Software House

Goal & Scope of project Add new functionality into the core banking system

Stakeholders and their location Air Bank Prague

Key Achievements Successful implementation of the new functionality

Job Description: Core banking analysis & testing

Create Functional Specification document for execution on client current accounts and payment of living wage, clarification of business functionality requirements with bank staff

Propose the accounting entries for the new functionality

Design dashboard and fields on the dashboard

Create use cases in Enterprise Architect and participate in creation of data model together with programmers, clarification of functionality requirements with programmers

Prepare test plan and test cases for the new functionality, execute manual and automated testing, solve test failures

Check tested data in database via SQL Developer by using SQL query

Present new functionality to the client

Platform: Windows web client, SharePoint 2010 platform

Used tools: MySQL, SQL Developer, Spira, Bugzila, SELENIUM, JIRA, PSPad, Enterprise Architect UML

Period: August 2012 – July 2013

Position held: Banking Business Analyst (Freelancer)

Company: Equa Bank Prague

Area: Bank

Goal & Scope of project Update the core banking system

Stakeholders and their location Equa Bank Prague

Key Achievements Successful implementation of the new developed functionalities

Job Description: Work as an specialist for core banking systems

Analyse and test core banking systems Flex Cube, ELBOS

Analyse data in Oracle database, interfaces between bank core systems

Analyse bank’s Data Warehouse

Set parameters of new products and accounting entries

Analyse failures in production, solve the issues

Platform: Oracle Database, Oracle backend, Thin Web Client

Used tools: SQL Developer, XMLSpy, PSPad, JIRA, Enterprise Architect, UML, MS Office 2007, 8

Period: July 2011 – July 2012

Position held: Bank Business Consultant (Freelancer)

Company: CSOB Prague

Area: Bank

Goal & Scope of project Update the existing core banking system

Stakeholders and their location CSOB Bank

Key Achievements Successful implementation of the new developed functionalities

Job Description: Project PURE

Write High Level Design (HLD) analysis (transfer the existing functionalities from the old core version to the new one, find changes in functions, interfaces and extracts)

Appraise time consumption in MDs for required functional changes in HLD

Gather business requirements for the new functionalities

Write business specification documents

Platform: Profile, Thin Web Client

Used tools: MS Office 2007, 8

Period: September 2010 – June 2011

Position held: Information Systems Architect

Company: Hewlett Packard Prague

Area: World Product & Software House

Goal & Scope of project Change of the core banking system

Stakeholders and their location Raiffeisen Bank

Key Achievements Consultancy support of the project

Job Description: Project EVEREST - Raiffeisen bank Prague

Test lead for testing consumer loans and mortgages in FINACLE

Prepare test plans, test cases, support testing, support accounting entries (interest accrual, principal and interest postings, collaterals, etc.), prepare test scenarios

Advise on consumer/corporate loan and mortgages

Project in CSOB bank

Business analysis of the bank functional requirements, write Functional Specification document (partial and entire payment postponement of mortgages ), clarify bank functionality requirements with the bank stuff on behalf of the bank

Work with programmers on required changes in the bank software functionality

Platform: Profile backend, Thick Client

Used tools: MS Office 2007, 8

Period: April 2004 - December 2009

Position held: Implementation Analyst/Banking Consultant

Company: SunGard

Area: World Banking Software House

Goal & Scope of project Change of the core banking system

Stakeholders and their location Erste Bank Budapest, Erste Bank Prague, Erste Bank Slovakia, Erste Bank (in Kiev), Faysal Bank (in Karachi), ABC Bank (in Cairo)

Key Achievements The old core system was successfully transformed into the new one

Job Description:

Project in EBH Budapest 2004

Onsite testing of core banking system SYMBOLS (customer lending module, payments, settlements, drawdowns, fees, repayment schedules, etc.)

Project in FAYSAL Bank (Karachi – Pakistan) 2005

Onsite presentation to bank stuff on core banking modules “Client” and “Lending”, write GAP documentation, discuss customisation of bank requirements, clarify functional requirements, propose workarounds

Primary solution design, first assessment of realization costs for changed functionality in core system

Project in Ceska Sporitelna Prague 2005-6

Onsite testing of core banking system SYMBOLS (customer lending module, payments, settlements, drawdowns, fees, repayment schedules, etc.)

Report and solve software problems together with programmers, manage implementation of new system functionality

Prepare and deliver user manual

Prepare Test Cases, Test Plans

Project ABC Bank Egypt 2006

GAP document, Functional Specifications, mapping documents (map fields from the old system to the new system fields in SYMBOLS for module Customer Lending)

Define clients’ interconnect business requirements

Onsite project in EBU Ukraine in Kiev 2006-8

Gesture of Ukrainian project of SYMBOLS for Customer Lending module

Present lending module to the bank staff

Analyse bank’s Data Warehouse

Analyse bank products (set up static data, general ledger accounts, set up accounting entries for loan transactions automatic and manual, client classification according to BASEL II, payments, fees, charges, repayments, extraordinary payments, prepayments, etc.)

Train bank stuff (20 people) in module Customer Lending, write test cases, test plans, bug evidence

Write GAP document, Analytical Functional Specifications,

Prepare data migration activities

-Analyse data migration from the old system to the new one

-Prepare migration plan and analyse document

-Organize data migration meetings

-Analyse database, rules for rollback

-Write mapping documents (table by table), build a bridge between fields with different format or types, filter data, add missing data

-Create mirror tables

-Execute cross controls

-Transfer data to the target database

-Execute cross controls

-Reconcile data

-Analyse migrated data

-Propose possible solutions and workarounds

-Support system users

-Analyse report requirements

Platform: SYMBOLS backend, Thick Client, SharePoint 2010 platform

Used tools: Bugzero, SQL Server 2008 / 2012, TOAD, XMLSpy, MS Office, Enterprise Architect, PSPad, Macro Scheduler v.8, v. 10, MS Office 2007, 8

Period: November 2001 – March 2004

Position held: Banking & Technology Business Consultant

Company: GraTex International a.s.

Area: Leading Slovak Software House

Goal & Scope of project Change of the insurance information system

Development of banking management information system

Stakeholders and their location Social Insurance Company of Slovak Republic

IntesaBci Bank

Key Achievement Successful implementation of a new system

Job Description:

Analyse the social insurance core system with a special focus on financial operations with the bank

Provide onsite methodological support in the customer branches or by phone

Analyse the financial information data warehouse system DAKTO onsite in VÚB – Gruppo IntesaBci

Determine VUB bank customer requirements by conducting business requirements studies, define gap specifications and write Functional specification documents.

Test new functionality delivered for the bank

Period: January 1999 – October 2001

Position held: Senior Methodologist for Credit Review

Company: VÚB – Gruppo IntesaBci – Head Office

Area: Commercial Bank

Goal & Scope of project Loan Methodology

Stakeholders and their location IntesaBci Bank

Key Achievements Monitor compliance with the loan methodology by bank’s branch network

Job Description:

Analyse finance and business of entrepreneurial subjects based on statutory reports

Review loan agreements, notary public records, etc.

Provide methodological support to the branches

Participate in project work focused on setting up the user security profiles and access rights to the ILP system

Period: April 1993 – December 1998

Position Held: Systems Analyst

Company: VÚB – Gruppo IntesaBci – Head Office

Area: Commercial Bank

Goal & Scope of project Change of the core banking system

Stakeholders and their location IntesaBci Bank

Key Achievements The old core system was successfully transformed into the new one

Job Description:

Analyse and validate business requirements, conditions and priorities within application development

Experience with the following HOGAN functionalities:

Client (CIS) – set up retail and corporate clients, customer overview, create customer to customer relations, etc. (CUCU, CUSA, CUMN, etc.)

ILP – create consumer and corporate loans in various scenarios (from the customer set up > borrower > loan > collaterals, or set up each item separately and then link them together), create different kinds of repayment schedules (RPS) (skipping functionality, amendment of RPS), set up drawdown, restructure the loan, change interest rates, loan parameterisation via PCD, check accounting entries in GL and subledger, etc. (HRAP, LDEP, LOMN, LINQ, etc.)

Borrower – set up borrowers, amend data, and link them to the appropriate customer

Collaterals – set up collaterals, amend data collaterals, link collaterals to loans, accounting entries, etc.

Payments (PAY) – set up drawdowns, set up loan instalments, etc.

Prepare test cases

Test the loan module functionality (CSC Products)

Present customized system to the Board of directors of VUB Bank.

Design functional specification required for loans

Prepare data processing via SQL and reporting

Prepare the loan system functionality manuals for the branch users

Lead training courses for loan service representatives of the core banking system such as: Integrated Loan Processing System (ILP system), Customer information System (CIS), Payment System (PAY) and on the Integrated Deposit System (IDS) to the bank employees.

Support implementation of new core banking system to the pilot branch, direct support loan service representatives by entering loans to the system by implementation, data review after first end of day, check reports

Educational Background:

Period: 1986 - 1990

School/University: SPU in Nitra

Faculty: PEF - Faculty of Economics and Management, Master’s degree

Majoring Subject: Economics and Management

Follow up Studies/Courses

Period: 1993

Institution: Team Training (Austria)

Training Course: Management skills

Period: 1996-96

Institution: Export-Academy Baden- Wűrtenberg

Certificate: Certificate

Training Course: Specialised study in the International Commercial Law“ at IZO (Foreign Trade Institute of the Slovak Republic). Teaching and examining personnel were the lecturers from the Export - Academy in Reutlingen, Baden-Württemberg, Germany

Driving Licence: Category A, B, M

Languages: Slovak – mother tongue

English – fluent

Russian – fluent

German - good

IT skills: Expert in core banking applications SYMBOLS, HOGAN, working also with PROFILE, FINACLE, FLEXCUBE, Strong knowledge in: Oracle SQL Developer, Enterprise architect, UML, JIRA, Balsamiq (app for design of the Internet pages), UML Certified, Microsoft office package, Visual Studio 2010, SharePoint 2010 platform

• Expert as business analyst, tester

• Strong banking know-how (lending, deposits, payments, treasury, collaterals, CIS)

• Data analytical skills, presentation skills

• Strong analytical skills

• Problem solving

Personality profile: Goal-seeking

Team player

Patient

Quick to learn

References: Dipl. -Ing. Dr. Georg Pigel,

Team Manager

Email: *****.*****@*****.**

Phone number: +436*********

Milan Mihočko

In Bratislava on 06 April 2020

Contact this candidate