Profile image of mpalgeo
@mpalgeo
Flag of Greece Agios Dimitrios, Greece
Member since June, 2014
4 Đề xuất

mpalgeo

Trực tuyến Ngoại tuyến
I am responsible for the Design and the Development of the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2. The database is being updated daily from the core system via SSIS and a numerous of KPIS are being daily updated during the ETL. For performance reasons the KPIS are replicated to another DB which exploits the dashboards via Power BI and reports via, SSRS to the consumers. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Finally several other reports are daily automatically produced and sent via email to the recipients. The size of the Master DB, which I am the Admin, is about 4TB and the replicated KPI DB is 350GB
$25 USD/giờ
70 đánh giá
6.2
  • 100%Các công việc hoàn thành
  • 98%Đúng ngân sách
  • 98%Đúng giờ
  • 23%Tỉ lệ thuê lại

Portfolio

Các đánh giá gần đây

  • image of ipowersoljef Highly qualified ms sql developer with BI skills $140.00 USD

    “He did the work in 7 hours while two other providers did work months on it. [13 September, 2017] i never experienced such a fast solution for my requirement : i had two other teams working on this for weeks .. this provider did it in 7 hours”

  • image of billpeterson SQL DATABASE $555.00 USD

    “Excellent Work from Top Notch Database Professional”

  • image of kajkanjan Microsoft 'Power BI' Data Analysis and Visualization needed $140.00 AUD

    “Excellent freelancer - solved problem and produced results very quickly where others struggled. Minimal interaction needed, was proactive and took on any feedback straight away. Will definitely ask to work with again on any similar projects/work.”

  • image of RishiErrabelli SQL Server Reporting Services (SSRS 2012) $83.00 USD

    “Work is Completed”

  • image of terbo2 Project for mpalgeo $136.40 USD

    “Mpalgeo did a great job, as always!”

  • image of mdongen MS SQL 2012 bottleneck investigation & recommendation €216.00 EUR

    “5 star freelancer all-round. Already started the next project with him. [07 May, 2017] Perfect communication and knowledge. Already started on the next project!”

Kinh nghiệm

Manager of Analysis & Reporting Information Systems

Mar 2000

Design implement and administer Relational Database in SQL Server 2008 R2 and Olap CUBES in Microsoft Analysis Services to provide online reporting using Microsoft Reporting Services.

Project Manager

Oct 1999 - Mar 2000 (5 months)

Development of LOGISTICS SYSTEMS Analysis, Design and Development in Visual Basic Logistics Projects.

Developer

Mar 1993 - Sep 1999 (6 years)

Analyst-Computer Programmer Analysis, Design and Development in MicroFocus Cobol of ERP Systems.

Giáo dục

4.3

2002 - 2004 (2 years)

80

1986 - 1987 (1 year)

Chứng chỉ

PRINCE 2 FOUNDATION EXAMINATION (2013)

APMG-INTERNATIONAL

PROJECT MANAGEMENT WITH PRINCE 2 PRINCIPALS.

PRINCE2 REGISTERED PRACTITIONER (2013)

APMG-INTERNATIONAL

PROJECT MANAGEMENT WITH PRINCE2 METHODOLOGY

Chứng Nhận

  • SQL Level 1
    100%
  • US English Level 1
    85%
  • MySQL Level 1
    80%
  • SQL Server 1
    80%

Các Chứng Nhận

  • Đã kết nối với Facebook
  • Freelancer Ưa Thích
  • Đã Xác Thực Thanh Toán
  • Đã Xác Thực Điện Thoại
  • Đã Xác Thực Danh Tính
  • Đã Xác Thực Email

Các kỹ năng hàng đầu của tôi

Xem các Freelancer tương tự