Xxxxxx Xxxxxx, MEng, Sr. Business Analyst / Consultant
SUMMARY OF EXPERIENCE
More than 5 years of experience in data warehousing for banking industry with specialization in business analysis, data modeling and data mapping
More than 7 years experience in software development
Participated at leading data warehousing projects, both new developments and redesigns at a number of banking/consumer finance / telecommunication institutions
Knowledge of banking / telco business processes and their reflection in data structures
Knowledge of data warehousing methodologies, tools, techniques and technologies
Large data volumes processing – charts and views containing tens to hundreds of millions of lines (MS SQL, Sybase IQ, Oracle)

SUMMARY OF TECHNICAL SKILLS

Operating systems:
Windows 2000, Windows XP, Windows Server 2008, Linux
Languages:
VBScript, Java Script, PHP, SQL, HTML, XHTML, PL/SQL, T-SQL,  UML, MDX, Java, XPath, XQuery
Databases:
MS SQL Server 2000/2005, MySQL, Sybase IQ, PostgreSQL, Oracle, Teradata
Web Servers:
Apache Tomcat, Apache
CASE:
Sybase Power Designer, CA ERwin, MS Visio, Rational Rose
OLAP:
MS SQL Server Analysis Services, Pro Clarity
Reporting:
MS SQL Server Reporting Services, Business Objects Crystal Reports

RECENT PROJECTS
ADASTRA (www.adastragrp.com)
2005-present
Senior Business Analyst / DWH/BI Consultant



Customer: Telefonica O2 Slovakia
Project: Support & Maintenance, Euro Conversion of DWH, OZONE (CRM) migration
Project Role: Senior Business Analyst / DWH Consultant, Team Leader
7/2008 - present
Project duties including:
Maintenance of DWH/BI solution, bug fixing
Euro Conversion Analysis/Implementation of DWH/BI solution
Analysis / Implementation of CRM system migration to SIEBEL CRM (scope: DWH)

Technologies used: Windows 2003 Server, MS SQL Server 2005

Customer: CSOB (KBC Group)
Project: Primary Bank System Migration
Project Role: Senior Business Analyst
7/2009 – 09/2009
Project duties including:
Analytic meeting
Source system analysis
Mappings definition

Technologies used: MS SQL Server 2005, Oracle 10g, DB2

Customer: Telefonica O2 Slovakia
Project: Support & Maintenance, Euro Conversion of DWH, OZONE (CRM) migration
Project Role: Senior Business Analyst / DWH Consultant, Team Leader
7/2008 - present
Project duties including:
Maintenance of DWH/BI solution, bug fixing
Euro Conversion Analysis/Implementation of DWH/BI solution
Analysis / Implementation of CRM system migration to SIEBEL CRM (scope: DWH)

Technologies used: Windows 2003 Server, MS SQL Server 2005

Customer: Raiffeisen Bulgaria
Project: Information Management Architecture Review
Project Role: Senior Solution Architect, Team Leader
6/2008
Project duties including:
Conduct interviews with business & IT departments
Analysis of current IM solutions
Conceptual architecture design
Recommendations for the future development
Technologies used: Windows 2003 Server, MS SQL Server 2005

Customer: Postal Bank Slovakia
Project: Euro Conversion of Data Warehouse (Analysis)
Project Role: Business Analyst / Solution Architect
4/2008 – 5/2008
Project duties including:
Business requirement analysis
Migration plans - design
Technologies used: Windows 2003 Server , Sybase IQ, MS SQL Server 2005 Analysis Services

Customer: Raiffeisen Group IT (RZB Group)
Project: Group DWH 3.0
Project Role: Data Modeller
1/2008 – 3/2008
Project duties including:
Logical data modeling (L0, L1) of GDWH used in 16 countries
Technologies used: CA ErWIN DataModeler, Oracle 10g

Customer: CSOB Bank Slovakia (KBC Group)
Project: Datamart Slovakia, Reporting
Project Role: Business Analyst, Data Modeller
7/2007 – 12/2007
Project duties including:
L1 analysis (Teradata)
Requirement analysis & user interviews
Mappings definition – client profile
Data modelling (L1)
ETL development (Oracle)
Technologies used: Windows 2003 Server, Oracle 10g, Teradata  

Customer: Postal Bank Slovakia
Project: Statutory and internal reporting
Project Role: Business Analyst
9/2006 – 4/2007
Project duties including:
Analysis – Statutory reporting, Prudential reporting, COREP, FINREP
Mappings definition
Data modelling (Layers L0, L1, L2)
MIS design & implementation (SQL Server 2005/ProClarity)
ETL implementation (Sybase IQ)
Functional testing
Technologies used: Windows 2003 Server, Sybase IQ, MS SQL Server 2005, Transact SQL, MS Analysis Services 2005, Pro Clarity

Customer: Istrobanka (BAWAG)
Project: Project: 2. increment of data warehouse
Project Role: Consultant
1/2006 – 9/2006
Project duties including:
Analysis
Mappings definition
Design of 1. layer
Data warehouse implementation
Analysis, implementation and testing extracts for Slovak Credit Bureau
Technologies used: Windows 2000, 2003 Server, MS SQL Server 2000, Transact SQL, MS Reporting Services
Customer: Consumer Finance Holding (Intesa Sanpaolo)
Project: Project: 1. increment of data warehouse
Project Role: Consultant
8/2005 – 12/2005
Project duties including:
Feasibility study
Requirement analysis
Design of 1. layer
Mappings definition
Implementation of 1. layer
Testing
Technologies used: Windows 2000, 2003 Server, MS SQL Server 2000, Transact SQL



Customer: Istrobanka (BAWAG)
Project: 1. increment of data warehouse
Project Role: Consultant
4/2005 – 8/2005
Project duties including:
Requirement analysis
Mappings definition
Design of 0. layer
Data warehouse implementation
Technologies used: Windows 2000, 2003 Server, MS SQL Server 2000, Transact SQL, MS Reporting Services
Customer: VUB Bank Slovakia (Intesa Sanpaolo)
Project: POPAI2
Project Role: Consultant
1/2005 – 4/2005
Project duties including:
Datamart implementation using MS SQL 2000
Datamart testing
Technologies used: Windows 2000, MS SQL Server 2000. ,Transact SQL, MS Reporting Services


PoWWWer
2003 – 2004
Programmer, Analyst
Project duties including:
IS Development, Analysis, requirements specification, design, implementation,  
             testing and maintained
Technologies used: MS Windows 95, MS Windows XP, Linux, PostgreSQL, Borland Delphi 7
Techprom
2001 – 2002
Programmer
Project duties including:
Development of IS MPMMS for The Slovak Republic Government Office
Technologies used: MS Windows 95, Linux, PHP + JavaScript, MySQL, Apache
EDUCATION, TRAINING

Bc. (BEng.) from the Slovak University of Technology, Bratislava, Faculty of Electrical Engineering and Information Technology, Department of Informatics, specializing in Software Engineering
2003
Ing. (MEng.) from the Slovak University of Technology, Bratislava, Faculty of Informatics and Information Technologies, Department of Informatics, specializing in Software Engineering
2005
Adastra courses: Datawarehousing A - Z
2005
Adastra courses:  Informatica
2005
Adastra courses: DW in Telecommunication Industry
2005
MS SQL Server 2005 Performance Tuning
2006
Adastra courses:  Advanced DW/BI
2007
Adastra courses:  Master Data Management, Data Quality
2007
MS SQL Server Analysis Services 2005
2008
MS SQL Server Integration Services 2005
2008
CERTIFICATES





LANGUAGES
Slovak:
Native
English:
Fluent
German:
Intermediate