Resume

Sign in

Data Management Architect/Manager

Location:
Athens, Greece
Posted:
April 25, 2018

Contact this candidate

Resume:

NIKOLAOS V. VARDOUNIOTIS

Date of birth: **-**-***7

Marital Status: Married, 2 children

Mobile: +30-697*-******

Email: ac48su@r.postjobfree.com

Address: **, ********** ******, *****, *.O. 20200, GREECE

LinkedIn: https://www.linkedin.com/in/nikos-vardouniotis-8a8b9070

STUDIES

1996-2004: University of Piraeus – Department of Informatics

SUMMARY:

IT Professional specialized in Data Warehouse - Business Intelligence - Data Management. Deep knowledge of all the steps of a DW/BI system (gathering requirements, analysis and design, ETL/ELT, OLAP cubes, reporting), experience on the establishment and improvement of Data Management processes (mainly based on DAMA principles) and leadership capabilities.

WORKING EXPERIENCE:

03/08/2015 – present: TRASYS GREECE – NRB Group

Senior Architect/Technical Leader on BI/DWH projects:

Project: Business Intelligence and Data Integration platform of European Chemicals Agency (ECHA).

Role / responsibilities:

Architect / Technical Leader of the team.

Analysis, design and implementation of the DW/BI system of ECHA.

Development of ETL / ELT procedures using Oracle Warehouse Builder (OWB) and Oracle Data Integrator (ODI).

Data Modeling using Oracle Data Modeler.

Collaboration with the data consumers in order to design the overall data architecture.

Physical implementation of the Enterprise Data Model.

Collaboration with business users and management in order to improve the Data Governance processes.

Consultation and recommendations to the client for the future architecture of the system (implementation of the new architecture has already started).

Interviews with candidates to select the appropriate professionals for the team.

03/08/2015 – present: NVG DATA (founder/owner)

IT Company specialized in Data Warehouse - Business Intelligence - Data Management

01/03/2007 – 27/07/2015: Agricultural Bank of Greece (ATEbank) – Piraeus Bank (after the acquisition).

Business Intelligence Architect/Manager.

Collaboration with stakeholders in all levels of the bank to provide BI solutions that meet their reporting and data analytics needs.

Collaboration with external stakeholders to provide the requested data/reports (European Central Bank, Central Bank of Greece, Ministry of Finance, BlackRock etc.).

Establishment, design and implementation of the corporate Data Warehouse.

Database design and data modelling.

Development of complex ETL processes using Microsoft DTS and SSIS (handling huge amounts of data).

Design and implementation of Business Intelligence and OLAP applications for the bank and its affiliates (ΑΤΕ Insurance, ATE Leasing, ΑΤΕ E-mutual Funds) using Microsoft BI tools (SQL Server, Analysis Services - SSAS).

Creation of reports to support Decision making (SAP BO, Microsoft Excel - Pivot tables - Power Pivot, Microsoft Performance Point, Reporting Services - SSRS).

Establishment, coordination and technical leadership of the DW/BI team (2-5 persons).

Collaboration with business users and coordination of the group of people in order to establish the Data Governance (Enterprise Data Model, Data Glossary etc.).

Creation of the Business Intelligence/Data Governance Portal where the users could find all the reports, documentation and the components of Data Governance (i.e. Data Glossary).

Regular collaboration with Data Stewards and Data Owners in order to define and improve the internal processes and to continuously improve the system.

Achievements:

In ATEbank I created the DW/BI system from scratch. It was placed at the center of the bank as the only reference point for information/analytics. Integrating several source systems, it had been used to serve all the levels of the bank (Branches - Central Divisions - Top Management - CEO) as well as external stakeholders such as European Central Bank, Central Bank of Greece etc. As the top achievement I consider the change of the mentality of the people of the bank and the comprehension of the importance of such a system.

05/10/2006 – 05/05/2007 Ministry of Employment and Social Protection.

Advisor – Special Collaborator of Academic Education of the Ministry of Employment and Social Protection on Information Technology issues.

12/05/2005 – 13/02/2007 COSMOTE Mobile Telecommunications S.A.

Business Intelligence specialist.

Data Warehouse development for COSMOTE, COSMOTE Romania, AMC (COSMOTE of Albania), GLOBUL (COSMOTE of Bulgaria), COSMOFON (COSMOTE of FYROM) using Oracle BI Tools (Oracle Warehouse Builder, Oracle Discoverer).

Development of complex ETL procedures.

Development of the new BI system using COGNOS 8.

Installation, configuration and maintenance of new applications (COGNOS 8, Oracle BI Tools 10g etc.).

Data Warehouse migration (from Oracle 8i to Oracle 10g).

Development and maintenance of jobs, procedures, functions, packages for the Data Warehouse.

Oracle Database Administration.

Creation of reports to support Decision making.

Development of automated procedures in order to create and send reports via e-mail.

Support to Data Warehouse users.

Seminars/training to Data Warehouse users.

Documentation.

Achievements:

Together with a highly skilled team, we implemented the DWH which contained a large amount of data. The next milestone was the implementation of the BI system using Cognos and it was achieved with great success.

10/07/2000 – 05/05/2005 Intrasoft International S.A.

Software Engineer.

Database Administration.

Development and administration of Data Warehouse systems.

Monitoring Oracle Application Server Instances.

Programming using Java, PL/SQL, Pro**C.

Technical support to the users.

Documentation.

Achievements:

Although it was my first working experience, I contributed to the successful implementation and delivery of two big projects for EU: CORDIS (as a junior developer) and SYMMETRY (as a senior software engineer).

LANGUAGES

English: Cambridge First Certificate

TECHNICAL SKILLS

Data Warehouse / Business Intelligence: SQL Server Integration Services (SSIS) 2005/2008/2012/2014, Microsoft SQL Server Analysis Services 2000/2005/2008/2012/2014, Microsoft Reporting Services 2000/2005/2008/2012/2014, Microsoft Performance Point (Microsoft BI), Microsoft SharePoint, Cognos 8-8.3, Business Objects, SAS, QlikView 11, Oracle Discoverer (Administration and Desktop edition), Oracle Warehouse Builder, Oracle Data Integrator (ODI).

Databases: Microsoft SQL Server 2000/2005/2008/2012, IBM DB2, Oracle 8i-9i-10g-11g-12c, Microsoft Transact SQL, PL/SQL, SQL,Oracle Reports, Oracle Toplink, Quest Software TOAD, PowerBuilder, Platinum Erwin.

Data modelling: Oracle Data Modeler, Microsoft Visio.

Programming Languages : Microsoft Visual Studio (.Net) 2005/2008/2010/2012, CA Gen (COOL:Gen), Pascal, C/C++, Pro*C, JavaScript, Delphi, HTML, XML, DHTML.

Microsoft Office: Word, Excel, Access, PowerPoint, Outlook.

Operational Systems: Windows NT, 98, 2000, XP, Vista,7, 8, 10, DOS, UNIX.

Other: Oracle AS Administration, Oracle AS Portals, IIS, Microsoft CMS.

SEMINARS-OTHER WORK

Certified Seminars:

-Oracle Data Integrator 12c: Integration and Administration

-Oracle Data Integrator 12c: Advanced Integration and Development

-Oracle Database 10g: Program with PL/SQL (5 days)

-Oracle Reports Developer 10g: Build Reports (5 days)

-Oracle Database 10g: SQL Tuning Workshop (3 days)

-Oracle AS Discoverer 10g: Creating Queries and Reports (2 days)

-Oracle Discoverer Administrator 10g: Develop an EUL (3 days)

-Oracle9i Warehouse Builder: Implementation (4 days)

-Oracle AS Portal 10g: Build Corporate Portals (3 days)

-Oracle Data Integrator 12c: Integration and Administration

-Cognos 8 BI Ad Hoc Querying (1 day)

-Cognos 8 BI Report Authoring Part I (2 days)

-Cognos 8 BI Report Authoring Part II (3 days)

-Cognos 8 BI Scorecard Application Development (2 days)

-Cognos 8 BI Content Administration (1 day)

-SAS Programming Fast Track (5 days)

-SAS Data Integration Studio: Fast Track (5 days)

-QlikView Designer (2 days)

-QlikView Developer (3 days).

Other Seminars:

-Microsoft Share Point (7 days)

-CA Gen (7 days)

-Microsoft Performance Point (3 days)

-SQL Server 2012 (2 days)

-SQL Server 2012 – Integration Services-SSIS (3 days)

-SQL Server 2012 – Analysis Services (3 days).

Participation in summits:

-VASCO Banking Summit (speaker): Moscow, April 2009.

-GARTNER Business Intelligence Forum: Athens, May 2009.

-MICROSOFT Business Intelligence Roadshow: Athens, March 2011.

-IBM Symposium 2012: Athens, March 2012.

OTHER INFORMATION

Fulfilled military obligations.

Ability to work personal and/or with other people.

Ability to work in pressure.

Pleasant personality and good relationships with the colleagues.



Contact this candidate