Post Job Free

Resume

Sign in

Database Developer/DBA

Location:
Athens, Attica, Greece
Posted:
November 11, 2013

Contact this candidate

Resume:

EUROPASS

CURRICULUM VITAE

PERSONAL INFORMATION

Name ANTONIOS CHERAS MEng, MBCS, MCSA, MCP

Address ** ********, *****, *******, ******

Telephone Landline: +302********* Mobile: +306*********

E-mail acavae@r.postjobfree.com

Nationality Greek

WORK EXPERIENCE

• Dates (from – to) DECEMBER 2012 – PRESENT

• Type of business or sector Freelance Database Developer, Software Analyst and IT Consultant

Designing and developing software and databases to meet client needs.

• Main activities and responsibilities

Database logical and physical modeling, programming, performance tuning on SQL Server dbs.

Developing BI solutions using SQL Server 2005, 2008, 2012 tools (SSIS, SSRS, SSAS)

ERP consulting.

Indicative Projects

Design and implementation of a totally customizable and parameterized system, on SQL Server,

for executing T-SQL commands and exchanging data between a central and remote databases.

Central management without the need to have access to remote databases. Web services have

been used to establish communication and to handle the data transfers.

Implementation of the SQL Server database objects that utilize the above logic in order to exchange

data between the Argos SA, my client and former employer, and the cooperating distributors.

The analysis, design and database (SQL Server) programming of the new Distribution Management

System for the press distributors in Greece.

Enrichment of the Argos SA data warehouse to introduce the new data structures. Development of

the necessary ETL processes, using SQL Server Integration Services.

Development of the reporting solution that make use of the Argos SA newly acquired data, using

SQL Server Reporting Services.

• Dates (from – to) SEPTEMBER 2000 – NOVEMBER 2012

• Name and address of employer Argos S.A., 20th km of Markopoulo Ave, P.O. Box 65, 19002 Paiania ( www.argoscom.gr )

• Type of business or sector Press Distribution Agency, 3PL, Retail

• Occupation or position held IT Manager responsible for the Software Department, Database Developer / DBA

Analyzing the operation and information needs of the Company and developing technological

• Main activities and responsibilities

solutions to satisfy those needs.

Designing, developing, documenting & maintaining the company software.

Designing, programming, documenting & administering the company SQL Server databases and

data warehouses.

Managing assigned operations to achieve goals within available resources.

Managing a team of 6 technical staff.

Ensuring communicating important and sensitive IT-related information to superiors and resolving

escalating issues in a timely fashion.

Advising, evaluating, testing, training and supporting IT-related projects.

Indicative Projects

Design, development, 24/7 support of SQL Server databases and applications which communicate

with the ERP and cover the logistic, WMS, CRM, GIS and many more needs of the company.

Page 1 - Curriculum Vitae of

ANTONIOS CHERAS

Design and implementation of the group BI solution with SQL Server (SSIS, SSRS, SSAS),

consisting of data warehouses with billions of records and complex ETL processes. Data

warehouses for the clients, the publication companies, are also implemented on their own

premises, updated daily through SQL Server Replication (merge and transactional).

Implementation and 24/7 support of distribution management software and SQL Server databases

for a great number of cooperating distributors (about 400 all over Greece) and publication

companies.

Configuration and customization of Atlantis ERP, running on SQL Server, for Argos SA and its

subsidiary companies ArgosNet SA and Argos-Europi LTD

Use of advanced technological equipment (Put To Light, hand-held devices running and

communicate through company custom software.

Data communication infrastructure for retail shops using SQL Server.

Design of advanced replication technologies (SQL Server replication, web services, linked servers

etc.) between the peripheral distributed databases and the central ones.

• Dates (from – to) MARCH 1999 – AUGUST 2000 AND SEPTEMBER 1995 – NOVEMBER 1997

• Name and address of employer LogiKal L.T.D., Pireos 226, 17778 Tavros Athens

• Type of business or sector IT Services

• Occupation or position held Senior Software Engineer & ERP Consultant

Planning, coordinating and conducting multiple complex software engineering activities .

• Main activities and responsibilities

Analyzing and designing of databases and user interfaces.

Software coding, testing and documentation.

Managing and supporting software engineering staff.

Consulting, training & development of ORAMA ERP in association with Quality & Reliability SA.

Indicative Projects

Design and implementation of ERP system suitable for companies who offer services in controlled

environment storage, food logistics.

Application development mainly for the medical and maritime industries.

Software for controlling measurement instruments for the Agricultural University of Athens.

ORAMA ERP on Oracle database installations for companies in the food and publication industries.

• Dates (from – to) NOVEMBER 1997 – MARCH 1999

• Type of business or sector Freelance Software Developer (during military service period)

Design and implementation of a suite of applications concerning the Transport and Communication

• Main activities and responsibilities

Departments of Prefecture Government Authorities.

Student monitoring application development for the Hellenic Naval Academy.

• Dates (from – to) FEBRUARY 1997 – MAY 1999

• Name and address of employer Greek Institute of Research and Technology, Ministry of Culture

• Type of business or sector Greek Presidency of European Union in Zapio building

• Occupation or position held Promoter-demonstrator of Greek Multimedia applications.

EDUCATION AND TRAINING

Education OCTOBER 1990 – FEBRUARY 1997 (while working)

National Technical University of Athens (NTUA)

Electrical Engineer and Computer & Software Engineer Degree

(5-year degree equivalent to British Bachelor and Master of Engineering)

Certifications JUNE 2013 – SEPTEMBER 2013

Microsoft Certified Solutions Associate (MCSA) : SQL Server 2012

Microsoft Certified Professional (MCP) in Implementing a Data Warehouse with SQL Server 2012

Microsoft Certified Professional (MCP) in Administering SQL Server 2012

Microsoft Certified Professional (MCP) in Querying SQL Server 2012

Page 2 - Curriculum Vitae of

ANTONIOS CHERAS

Training NOVEMBER 2007

Microsoft Certification of Achievement in “Implementing and Maintaining Microsoft SQL Server 2005

Reporting Services” (ITEC S.A.)

OCTOBER 2005

Microsoft Certification of Achievement in “Implementing Replication Using Microsoft SQL Server

2000” (Informacy S.A.)

OCTOBER - NOVEMBER 2001

Seminar in “Implementing a Database in SQL Server” (Pimus Business & IT Training)

SEPTEMBER 2000

Seminar in “Lotus Domino Server @Lotus Notes Administration” (Fast Forward S.A.)

SEPTEMBER 1999

Seminar in “Database Administration – Oracle 8” (Oracle Hellas S.A.)

PERSONAL SKILLS

AND COMPETENCES

MOTHER TONGUE GREEK (GR)

OTHER LANGUAGES ENGLISH (EN)

Understanding Speaking Writing

Self-assessment

European Level Listening Reading Spoken interaction Spoken production

Language EN C2 EN C2 EN C2 EN C2 EN C2 Common European Framework of Reference for Languages

Able to communicate effectively with all levels of management, stakeholders and co-workers.

SOCIAL SKILLS

Familiar working in a confidential environment.

AND COMPETENCES

Strong leadership characteristics – able to lead projects and project teams.

ORGANISATIONAL SKILLS

Excellent organizational, team building and high level problem solving abilities.

AND COMPETENCES

Proven track record for completing assignments on time and under budget.

Extensive experience leading all stages of the system development process, including requirements

TECHNICAL SKILLS

definition, design, architecture, testing, documentation and support.

AND COMPETENCES

Managing entire ERP project operations with a view to achieving business objectives and ensure

.

optimum utilization of available resources.

Remarkable experience in designing and programming database, data warehouse, BI solutions

using Microsoft SQL Server stack. Comfortable with complex SQL and T-SQL.

Specific technical skills in:

RDBMS: MS SQL Server (SQL, T-SQL, SSIS, SSRS, SSAS, Administration, Performance

Tuning, XML, DQS, MDS), SQLBase, Oracle (PL/SQL)

Programming: Delphi, Centura, Visual Basic, Visual FoxPro, Javascript, Clipper

Others: Mapinfo GIS, Crystal Reports, PowerDesigner, Visual Studio, BIDS, SSDT, Visual

Source Safe, ERP, WMS, Logistics, Technical Documentation

ARTISTIC SKILLS Playing the Guitar

AND COMPETENCES

OTHER SKILLS Sailing, Cycling, Basketball, Tennis

AND COMPETENCES

Member of Technical Chamber of Greece

ADDITIONAL INFORMATION

Professional Member of British Computer Society (MBCS)

Page 3 - Curriculum Vitae of

ANTONIOS CHERAS



Contact this candidate